Technology Insights

Connect To Microsoft SQL Server From OSX

If your daily driver is a Macbook or similar and you also manage a network that has Microsoft SQL Server running on it then it can be useful to login to those MSSQL Servers remotely. Even if its simply to view database layout or verify a service is running properly by actually connecting to it there is no doubt that having an easy method to connect to Microsoft SQL from OSX is beneficial. There are a bunch of JAVA based clients such as SQuirreL SQL Client or SQLRazor that are great applications but I personally use DBVisualizer or Navicat which are both described in more detail below.

Technology Insights

SSH Add Server To known_hosts Automatically

If you ever need to write a shell script that uses either SSH or SCP to unknown hosts then you will likely have run across the issue of adding the remote host/server to the known_hosts file when automating either of the two commands are called within the script. You can easily get around this either by modifying the client computers ssh_config file or by using the -o switch available for both SSH (Secure Shell) and SCP (Secure Copy). Below we show how to modify the ssh_config file as well as an example of using each with the -o switch.

Technology Insights

Linux Create Fake Ethernet Interface

There could be numerous reasons to create a fake Ethernet interface on a Linux server though I have heard that people might do so to get around licensing of software that is tied to the MAC address of a specific Ethernet port. You really just enable a dummy Ethernet interface and assign the MAC address to it which is explain in more detail below. The easiest way to do this is to simply assign a MAC address to an Ethernet interface you are not using on your server where the drivers have already been installed automatically. If you do not have a spare Ethernet interface then the instructions below will assist you to accomplish your goal.

Technology Insights

SVN Mountain Lion

I needed to use SVN on a new installation of Mountain Lion OSX on my Macbook Pro and initially assumed it would be there because I already had Xcode installed however it was not or was not located in my path. After playing around in the Xcode interface for a moment I located the Command Line Tools package available for download which ended up installing svn on the command line. Below I describe how to verify if SVN is installed on OSX and explain how to install it if it does not already exist.

Technology Insights

Pretty Link Twitter Badge Not Displaying (Update)

I initially wrote an article about the Pretty Link Twitter Badge not displaying back in March of 2012 and it appears some things have changed since then. The issue in my case is a conflict between the Pretty Link WordPress plugin and Greg’s High Performance SEO WordPress plugin. Since the original article it appears that the GHPSEO has modified the location of a variable I modified to resolve the issue. Below is information on how to resolve.