Last week reading (2018-05-20)

That was a really tough week for us. Damian and I have led a workshop at SQLDay conference in Wroclaw (Poland) and also a regular session (separately this time). I will publish all materials soon and Damian has take a lot of good pictures, so let’s fingers crossed to see them on the blog soon either. That’s why not too many reading during past week.

Creating Azure SQL Managed Instance using ARM templates
A recipe how to cook it with ARM template and PowerShell script.

Extract management insights from SQL Data Warehouse with SQL Operations Studio
Interested to see more information about your Azure SQL Data Warehouse (SQL DW)? New widget shows you Data Skew, Columnstore health and statistics, Users Activity and Resource Bottlenecks. This is only beginning.

Accelerate your cloud data warehouse with automation tools
Supposedly, there are 3rd tools that let you automate some work with SQL DW.

LONDON PUG DATA VIZ – Episode 2
Prathy [T] has recently started a new discipline to encourage attendees of London Power BI User Group to make your own dashboard based on the same dataset.

Quick Tips For Debugging Large Stored Procedures
Read all tips from Brent Ozar’s Team which help you cope with loooong Stored Proc.

Bookmarks and Buttons: Making Power BI Charts Even More Interactive
In that post, Reza [T] shows you some usages of buttons and bookmarks which is related to visual’s interactions.

Incremental refresh in Power BI Premium
Incremental refresh enables large datasets in the Power BI Premium service with several benefits. In the video, Adam Saxton [T] and Christian Wade [T] discuss the significance of incremental refresh.

A brief reminder of the SQLDay conference (stay tuned – there will be more…)

That’s true – speaking at #SQLDay makes people happy 😉 @DamianWidera @NowinskiK #DataCommunityPL #SQLFamily pic.twitter.com/WBxkRkuf55

— Agnieszka Cieplak (@AgCieplak) 14 May 2018