Last Week Reading (2019-07-28)

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

Video: What is Azure SQL Database Hyperscale?

Smile Corner

 

Previous ASF 024: Leila Etaati interview
Next The next crucial step in my career

About author

Kamil Nowinski
Kamil Nowinski 194 posts

Blogger, speaker. Data Platform MVP, MCSE. Senior Data Engineer & data geek. Member of Data Community Poland, co-organizer of SQLDay, Happy husband & father.

View all posts by this author →

You might also like

Last Week Reading 0 Comments

Last week reading (2018-12-30)

Good day SQL folks! Here is your weekly list of articles worth to read! The year is almost ended so I would like to wish you all the best in

Last Week Reading 0 Comments

Last Week Reading (2020-07-12)

Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions. Simplifying declarative deployments in Azure The power of What-If within ARM Template deployments. Collecting custom parameters/variables

Last Week Reading 0 Comments

Last week reading (2018-07-15)

Structured Streaming with Databricks into Power BI & Cosmos DB Giuliano Rapoz (Microsoft) is showing the concept of Structured Streaming with all these puzzles. Lightning fast query performance with Azure

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply