UPDATE 2020-02-28: It looks that by RTM this feature has been disabled, check out blog by Solomon Rutzky for more information. With the release of the Sql Server 2019 CTP 3.2 we have received a new SECURITY feature, that is…
SQL Graph, part V – Shortest Path
This is the 5th blog post in the growing series of blogpost on the Graph features within SQL Server and Azure SQL Database that started at SQL Graph, part I. This time we are focusing on the one of the…
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…
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…
Troubles in Exec @stmt With Result Sets
This post was originally written and almost finished on the 10th of July 2012 and 5.5 years later, I decided that I rather publish it then rework further or keep on the ice (yeah, I have dozens of drafts –…