Last week reading (2018-03-18)

Good day SQL folks! Thanks for visiting our blog again! Here is the information you need to calmly start the new week.

Indexing and partitioning
An interesting example was done by Andrew Pruski when ALTER TABLE SWITCH might actually fail when there are no identical indexes on the partitions. Read this blog post to find the solution.

Controlling Access to Azure Cosmos DB
The title says it all. How to control access to your Azure Cosmos DB by Marcin Policht.

Cosmos DB access control with users and permissions
This article dwells a bit on the scenarios when to use permissions instead of masterkey and how you can use a set of permissions to grant access to multiple documents, collections, partitions at once.

Demo – Azure SQL Database Managed Instance in action
Azure SQL Database Managed Instance is new data service in Azure cloud that exposes fully-managed SQL Server Instance that is hosted in Azure cloud and placed in customer VNET. Here you can see some of the key new features that are available in Managed Instance.

Power BI Troubleshooting Checklist
If you have ever started a sentence with “I’m seeing a strange issue in my Power BI Desktop report” and wondered how to investigate, this article is for you.

ASF 008: Michael Rys interview
An interview with Michael Rys we did last PASS Summit. If you haven’t heard it yet – now you have your chance

Cheers,

Damian