Weekly reading #7
It is MVP Summit time! I have not made it this year unfortunately. I hope all MVPs have a greate week with the product teams in Seattle. Now take your time and read the weekly readings!
15 minutes video about how to use Alter Row in ADF Data Flows for insert, update, delete, and upsert merges.
Amanda Cofsky presents a monthly feature summary about PowerBI desktop. This month you can read about single select slicers, heat maps and new DAX functions (and many more).
As you know Azure Cosmos DB offers five consistency levels for you to balance the tadeoff between consistence, performance and availability. This article shows how can you configure a custom synchronization to achieve higher availability and performance
Grant Fritchey has prepared a query that allows you to find missing indexes just by analyzing the data from the query store. Not trivial task as you need to analyze an XML but Grant did that for us.
Erik Darling shares his thoughts about lock promotion in the SQL Server – especially when you have parallel plans.
Alan Yu has announced a new version of the Azure Data Studio. There have been new things added this month like PostgreSQL extension, SQL notebooks, PowerShell extension, SQL Server DACPAC extension and updated SQL Server 2019 Preview extension
This is all for today! Some more excitemenst will be shared this week