Microsoft Power BI 2.0

What is it about version 2.0? Perhaps when software reaches version 2.0 it seems to have gained some maturity and respectability, but is still young enough to be filled with excitement and energy. In any case, Microsoft’s Power BI Version 2.0, announced for general availability July 24, is generating considerable excitement within the community of […]
Read More ›

Executing DAX Queries From R

Christine, a student in Learning Tree’s course SQL Server Analysis Services for Business Intelligence, writes “I just created my first Analysis Services tabular model database, and I am having lots of fun. But now I want to do some more sophisticated statistical analysis using R. I can’t seem to find a way to use DAX […]
Read More ›

Monitoring SQL Server Wait Stats: Interpreting CPU Waits

Interpreting CPU-Related SQL Server Wait Stats A stockbroker once told me he had made a poor decision because he had been mislead by the numbers. A curious choice of words, indeed; it was as if he were an innocent bystander who had been deceived by the nefarious digits on some spreadsheet. In any sort of […]
Read More ›

Get Started Monitoring SQL Server Wait Stats

Amy P., a student in Learning Tree’s 535 Class, Developing High Performance SQL Server Databases, asks “There are so many waits and so many different wait types, I’m confused.” Well, actually, that’s a statement, not a question, but I know what you mean. You get the impression that SQL Server wait stats can be an […]
Read More ›

SQL Server 2014 New Features: How to Create and Test a Clustered Columnstore Index

How to Create a Clustered Columnstore Index In my last post we looked at what are clustered columnstore indexes, their benefits and how they have changed in SQL Server 2014. Now, let’s learn how to create one.  Since we would like to make some performance measurements on a clustered columnstore index, we will use a sample […]
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.