There is so much to think about when talking/writing about the SQL Server on the cloud VMs, and in this blog post I am going to touch on one of the less spoken and might be – one of the…
SQL Server Azure VM Disks Caching & Uncaching
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…
Memory-Optimized TempDB Metadata
Besides In-Memory being declared by many people as a “dead feature”, it looks like Sql Server is bringing some stuff into the game, steadily improving the feature and integrating it with Microsoft is introducing something really daring in The feature…
Sql Server 2019 Standard Edition Changes (Yeah, TDE-ah!)
The upcoming release of Sql Server 2019 which is largely expected to take place during PASS Summit 2019 & Ignite 2019 simultaneously (and given that Rohan Kumar (Microsoft VP) seems to be present only at the PASS Summit, I am…
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…