Last week reading (2018-08-12)

Good day SQL folks!

Here we are, new week, new Monday and something new to read about the Data Platform world.

Power BI Desktop August 2018 Feature Summary

The biggest news from the last week was about the Power BI. There are a lot of new features but integration with Python could be the one we have been waiting the most (but not only).

Optimization Thresholds – Grouping and Aggregating Data, Part 5

Great article written by Itzik Ben-Gan about query optimization

Azure Tips and Tricks Part 147 – Run TSQL on an Azure SQL database with Azure Functions

Great blog of Michael Crump who works for Microsoft. He gives a lot of great examples of code in his blog.

The First 3 Things I Look At on a SQL Server

As the title states. What should be the first 3 things to look at on SQL Server according to Brent Ozar.

Finding duplicated data in a case insensitive column

Interesting post by Louis Davidson about finding duplicates in a very special case

Cheers,

Damian