Category: Linux and UNIX

Back in April, I explained the new network interface names. Instead of eth0 it’s something like enp0s4 or p7p1. Let’s see how to check the settings. Run these commands on your system and play along! Physical Devices First, what are the network class devices? This system has two Ethernet interfaces: $ ls -l /sys/class/net total […]

In the previous blog, we looked at some of the annoyances encountered when installing RODBC on Linux. Of course, RODBC can also be used in R running on Windows. In either case, running queries using RODBC is straightforward and without surprises. As is always the case, the first thing we need to do is connect. […]

Down the Rabbit Hole with RODBC The most direct method for reading SQL Server data into the statistical program R is with ODBC. If R is running on a Windows system, this is straightforward using the R package RODBC. On a Linux system, the installation of RODBC is more challenging. Of course, RODBC requires a […]

Colleagues and friends often ask me how they can learn or practice Linux when they only have Windows at work and a single family Windows computer at home, for free. That’s a good question, and there are a couple of different answers. Before we get to the free methods, I want to acknowledge that there […]

Run sqlcmd on Linux or the SQL Server Managment Studio on Windows? As of November 2106, those are the only two choices provided by Microsoft to serve as a client to SQL Server vNext running on Linux. There are, however, other alternatives and one, in particular, might be attractive to folks looking for a graphical […]