This post provides an example of a stored procedure which A) identifies the last two partitions of an Azure Synapse Analytics SQL pool table (which
Category: SQL Server
Simple DirectQuery Performance Tips
This blog describes a few simple, easy-to-implement techniques that can be used to increase the performance and scalability of Power BI reports which utilize DirectQuery
Husker Power BI Preview
On October 25th, 1997, I attended a football (American) game in Lawrence, Kansas between the number 1 ranked Nebraska Cornhuskers and the Kansas Jayhawks. It
Analyze SQL Server Query Store with Power BI
SQL Server and Power BI Collaboration Earlier this week at PASS Summit 2017, Erin Stellato, Principal Consultant with SQL Skills, delivered a pre-conference session regarding SQL
Should I use SSAS, given Columnstore?
I just watched the video below regarding different use cases and customer experiences with columnstore indexes in SQL Server, particularly SQL 16+. If you’re interested
Top 10 MSBI Enhancements for 2017
A Quick Look Back at 2016: Banner Year for MSBI 2016 was a great year for the MS data platform – for customers, partners, and
Insight Quest 