Querying SQL Server Data from R Using RODBC

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. […]
Read More ›

Analyzing SQL Server Data with R and RODBC

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 […]
Read More ›

How to apply Logistic Regression using Excel

Logistic regression is one of the most important techniques in the toolbox of the statistician and the data miner. In contrast with multiple linear regression, however, the mathematics is a bit more complicated to grasp the first time one encounters it. We’re going to gain some insight into how logistic regression works by building a […]
Read More ›

SQL Server on Linux: Using LibreOffice Base as a Client Application

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 […]
Read More ›

Apply the Openrowset Function to Acquire Rowsets

In the previous blog on SQL Server’s OPENROWSET function we observed that while OPENROWSET is most often encountered in relation to linked servers, it is also valuable for directly reading flat files. It’s worth taking a moment to mention another less common application of OPENROWSET ( ). If you wanted to write code that returned […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.