Category: Linux and UNIX

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 […]

A few months ago we had Daylight Savings Time. My parents were delighted to discover that “the clock” in their car automatically adjusted itself, as did their computer. But now they had to change the two clocks in their bedroom, the two clocks in the kitchen, and several others around the house. How did the […]