There are some events that I do submit to every single year and even more – I am anxiously waiting for the results of my submissions – and sometimes I can celebrate and sometimes I have to take a deep…
Speaking at PASS Summit 2019
Froid vs Freud: Scalar T-SQL UDF Inlining
Dear reader, I want to share with you some technical stuff under the name of Froid. Yes, Froid and not Freud, even though I guess one might argue that Froid can potentially be a kind of a Freud for the…
Updating Statistics on Secondary Replicas of the Availability Groups
UPDATE 25th of June 2019: The item related to this topic on Azure Feedback: Allow Updating Statistics on the Secondary Replicas of the Availability Groups We all love and use the wonderful features of the Availability Groups on the secondary…
Optimize for Analytics (Should be a Database Configuration option)
There is a world-famous “optimize for ad hoc workloads” Server Configuration Option in SQL Server since the version 2008 (meaning it is well over 10 years old), which is a great help for the to clean the single-use plan cache…
Database Scoped Configurations in 2018
What would be a good candidate for the very first blog post in 2019? The blog post I started writing in 2018 and did not finish. To be more precise I was planning & opened a draft with some notes…