Updated on the 10th of February after being pointed out by Dmitri Furman and Greg Low that as a matter of a fact a whole group of AAD users can be set as a Azure SQL Server administrators. The current…
Database Scoped Configurations in 2020
As the continuation of the tradition, started 5 years ago, each year I will be continuing tracing the changes taking place in Database Scoped Configurations. Database Scoped Configurations in the year 2020 We did not have any new major product…
Azure Elastic Job Agent
I wanted to write about a pretty old Azure feature that apparently approaching General Availability aka GA (as publicly mentioned by different Microsoft PMs) after 4+ years of being in preview – the Azure Elastic Jobs. The whole idea about…
SQL Server 2019: Session Context & Parallel Plans
You might have heard about the wonders of Context functions (SESSION_CONTEXT, CONTEXT_INFO) – they can offer some interesting solutions for the access control, but do you know what it can mean for the integration with the high performing queries? Session…
Database Scoped Configurations in 2019
Continuing the tradition that I started with Sql Server 2016 and the original appearance of the Database Scoped Configurations (an incredible feature, I have to repeat) and that last year precisely in January I have blogged about the Database Scoped…