Optimize SQL Server Queries with Index Statistics

Television’s Mythbusters seem to have a lot of fun; it’s interesting that so many myths seem to involve blowing stuff up on camera. SQL myth-busting may not be as visually dramatic, but for people who are interested in query performance, it is much more important. There are a lot of people who think that it […]
Read More ›

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 ›

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 ›

Why Should You Pursue a Microsoft Certification?

If you’re considering taking a Microsoft Official Curriculum course (or your company is considering sending you to one) you should know that it’s a good choice for both of you. The most obvious benefit of taking a Microsoft Official Curriculum (MOC) course is that you’re getting information about Microsoft technologies from the source. Coupled with […]
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.