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…
Froid vs Freud: Scalar T-SQL UDF Inlining
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…
SQL Graph, part IV – Merge DML Support (aka MATCH support for the MERGE against the Edges)
This is the 4th blog post in the series of blogpost on the Graph features within SQL Server and Azure SQL Database. This particular post is dedicated to the support of the MERGE DML for Graph tables in Azure SQL…