If you are deploying SQL Server in Azure, or any Cloud platform for that matter, instead of just provisioning storage like you did for your on-premises deployments for many...
2019-05-14 (first published: 2019-05-02)
670 reads
I’ve had this code in a snippet for a long time: I appreciate the markup to prevent SQL Prompt from doing this, which used to always happen. I can’t...
2019-05-13
119 reads
Availability groups (AG’s) is one of my favorite features of SQL Server, despite some DBA’s catalogue them as “too complex” to implement, configure, manage and maintain … I just...
2019-05-13 (first published: 2019-05-01)
760 reads
Watch this week’s episode on YouTube. When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs: or...
2019-05-13 (first published: 2019-04-30)
1,320 reads
Hello folks! One week passed, another one almost began. And that will be a crazy week on two conferences. Today, I’m in Wroclaw (Poland) where we’re prepping SQLDay conference...
2019-05-13
18 reads
If you haven’t read the proposed changes yet you should do that first and form your own opinion before reading mine. Thoughts here are high level, not a line...
2019-05-10
86 reads
In today's world, people expect to be able to commit one change, then have the entire project re-deployed and automated tests run against it. Using the SSIS PowerShell...
2019-05-10 (first published: 2019-05-01)
937 reads
A short one, but one that took some digging and debugging and help from others. Saving here, so I remember, as do others. I had a VMWare Workstation v12.x...
2019-05-10 (first published: 2019-05-01)
141 reads
This is the third interview we have done. This time our guest is Robert Farley who can be also recognized as the famous guitar player! Here you can find...
2019-05-10
49 reads
If you are like me and were unable to get away from the office to attend Microsoft Build 2019 you will be glad to know that Microsoft has published...
2019-05-10
88 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Comments posted to this topic are about the item Creating JSON III
Comments posted to this topic are about the item Testing is Becoming More Important
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