Scalar UDF Inlining in SQL Server 2019
SQL Server 2019 introduces Scalar UDF Inlining, which is supposed to improve the performance of Scalar UDFs. This post investigates this new feature.
The post Scalar UDF Inlining in SQL...
2019-02-25
27 reads
Blog Posts
SQLTreeo SSMS Add-In guide
SQLTreeo Add-In plugin for SQL Server Management Studio Version Applies to SQLTreeo Add-In version 0.8.7 or higher. Purpose Informational guide...
2019-02-25
232 reads
SQLTreeo SSMS Add-In guide
SQLTreeo Add-In plugin for SQL Server Management Studio Version Applies to SQLTreeo Add-In version 0.8.7 or higher. Purpose Informational guide on how to use the...
2019-02-25
132 reads
Using the Microsoft Authenticator app to log into Azure
So I was trying to work on a blog post about the new truncation error this morning and realized I...
2019-02-25
237 reads
Weekly reading #4
It is spring around the corner but we do not know where the corner is. All I know it is...
2019-02-25
121 reads
Which cardinality estimator (CE) was used in my query?
SQL Server 2008 is reaching end of support this year, so upgrading your SQL Server might be on your mind....
2019-02-25
578 reads
Analyzing Heart Disease risk using Key Influencers AI visual in Power BI
The Gartner Magic Quadrant for 2019, announced earlier this month, names Microsoft the leader in Analytics and Business Intelligence Platforms. Microsoft also coincidentally announced the public preview release of...
2019-02-23
16 reads
Adding Azure VM Boot Diagnostics
A couple of weeks ago, I blogged about boot diagnostics and how they can help you troubleshoot issues when virtual...
2019-02-22
213 reads
ASF 019: Simon Whiteley interview
As Chief Cloud Architect with Adatis Consulting, Simon Whiteley has been working with the Microsoft BI Stack for a decade,...
2019-02-22
151 reads
Displaying the tags within the SQL Server docker repository
A while back Microsoft moved all their SQL images to their new registry mcr.microsoft.com which means that we can no...
2019-02-22
167 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers