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 ›

Awesome Way To Log in Power Query M Using Diagnostics.Trace

Several authors have described how to use the M function Diagnostics.Trace to monitor the performance of queries built with Power Query. In this installment, we will look at how to use the same function to record row-level error information in the trace log. Regardless of how we intend to use Diagnostics.Trace, nothing at all can […]
Read More ›

Using Pandas in SQL Server 2017 Python Scripts

Creating Row Data with Pandas Data Frames in SQL Server vNext In the previous blog, we described the ease with which Python support can be installed with SQL Server vNext, which most folks just call SQL Server 2017. In this entry, we will take a look at the use of pandas DataFrames within SQL Server […]
Read More ›

SQL Server vNext (aka 2017) CTP2 Includes Python Scripting

More Analytic Excitement in SQL Server 2017 Last week (the third week in April 2017) Microsoft released its Community Technology Preview 2.0 for SQL Server vNext, more often referred to as simply “SQL Server 2017”. Among the many new features of interest to business intelligence analysts, data scientists, and machine learning afficianados is support for […]
Read More ›

What’s New (In Fact Very New) in SQL Server 2017

Microsoft Releases Community Technology Preview 2.0 for SQL Server vNext (aka SQL Server 2017) As is usually the case, the release of a technology preview of SQL Server provides lots of interesting new features for SQL admins and developers to ponder. CTP 2.0 for SQL Server vNext (generally just called SQL Server 2017) is no […]
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.