The Reader’s Choice Awards are Taking Nominations
If you’re using products, you might want to nominate a vendor or product for a database tool that helps you....
2019-02-26
886 reads
Blog Posts
Undercover TV – Sean McCown Joins Us For a Session on Beginning Powershell SMO
In this episode, Adrian looks at some of the new features of the Undercover Inspector1.3 and special guest, Sean McCown...
2019-02-26
242 reads
What Does the Undocumented UNCOMPRESS Function Do?
(last updated: 2019-02-26 @ 18:35 EST / 2019-02-26 @ 23:35 UTC )
IntelliSense in SQL Server Management Studio (SSMS) can be quite helpful. It...
2019-02-26
1,012 reads
Workload analysis with WorkloadTools
Last week I introduced WorkloadTools and promised additional posts to describe what it can do in more detail. So, here...
2019-02-26
559 reads
Friend of Red Gate
I’ve been a champion of Red Gate’s tools for years. Quite simply, they help me get work done quicker. They...
2019-02-25
159 reads
How Do You Export A Database in Azure Data Studio
I’ve been writing a bunch about Azure Data Studio. I’ve also been recording videos on the topic. A comment I received recently asked how to export a database from...
2019-02-25
14 reads
Imp Linux Commands
Important Linux Commands 1. uname -a: To know what version of unix we are using 2. hostname: System name 3....
2019-02-25
359 reads
Interview Trick Questions
Today, I am diverging from the more technical posts that I routinely share. Instead, as the title suggests, I want...
2019-02-25 (first published: 2019-02-04)
3,173 reads
Last Week Reading (2019-02-24)
Hello folks! This time quick review about Kubernetes, containers, automatic deployment of Data Factory and few things about Power BI....
2019-02-25
160 reads
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
9 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