Last Week Reading (2019-07-28)

I believe that most of you have got a holiday already (enjoy!) or are planning some now. This is the last post of “Last Week Reading” series before my holiday. I have not decided yet what I will be reading during the holiday: posts, audiobooks, paper books (fiction or technical)? Time will show.

Press

SQL Server 2019 community technology preview 3.2 is now available
The latest CTP version of SQL Server 2019 is out.

Continue a Foreach loop after an error in a SQL Server Integration Services package
What is Propagate Variable in SSIS responsible for?

Understanding Allocation Units – In Row Data, LOB Data & Row Overflow Data
Let’s take a look into the internals of SQL Server storage.

The OUTPUT Clause for the MERGE Statements
Find out what does OUTPUT contains when MERGE is used.

Budget vs. Actual Model in Power BI: Calculations and DAX
Do apply DAX to calculate monthly, daily or weekly, even if your budget data is at a quarterly level.

Optimizing Clustered Columnstore Indexes
Maintenance of CCI is even more important than common indexes. Check out why.

SQL Managed Backups and Operating System Error 87
Very good article about the reasons and action to be taken to avoid this issue.

Tutorial: Monitoring Azure Databricks With Azure Log Analytics And Grafana
What kind of monitoring for Azure Databricks? There is a recipe step by step.

Filtering the Top 3 products for each category in Power BI
Learn how to apply a TOP N filter for each Category in Power BI.

A word from Microsoft’s CEO

Wonderful to have so many customers with us at our campuses around the world this week to collaborate and innovate with our employee teams as part of our annual hackathon. https://t.co/OEZuaza6Tt

— Satya Nadella (@satyanadella) July 25, 2019

Video: What is Azure SQL Database Hyperscale?

Smile Corner