Last week reading (2018-03-18)

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

Previous ASF 008: Michael Rys interview
Next Last week reading (2018-03-25)

About author

You might also like

Knowledge 0 Comments

Last week reading (2018-04-15)

Good day SQL folks! Spring is everywhere all around us! You might not necessarily see this Monday morning at work… I hope you will have an easy start of the

Last Week Reading (2019-07-21)

Another week passed. Look what did I find during that time. Press British Airways faces record £183m fine for data breach The penalty imposed on BA is the first one

Last Week Reading (2020-06-28)

Press ExpandString in Powershell This function can do much more than you think. Pester – using -should -throw Useful example when you want to filter output by ExceptionType or ErrorId. ADF:

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply