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 ›

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 ›

Missing Server Configuration Manager from SSRS Server

I had an interesting problem recently. I was doing some work for a client on a CRM deployment and a performance issue. Whilst onsite, I helped with a problem with SSRS and reports not displaying. Further investigation displayed an error that said SSRS was not using a valid execution account. The error was “The report […]
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 ›

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.