After power surge last night, I realized few availability databases (also known as a “database replica”) have an unhealthy data...
2014-04-02
4,304 reads
I had a recent run in with collation problems and it got me started reading. As I read I started...
2014-04-02 (first published: 2014-03-26)
1,730 reads
I was looking at a product recently and came across a rather unpleasant surprise: the install instructions specified that I...
2014-04-02
3,308 reads
There are lots of Dynamic Management Objects (DMO’s, more commonly referred to generically as DMV’s) that require extra permissions. Without...
2014-04-02 (first published: 2014-03-25)
93,583 reads
Saw the announcement in the Connector today that the process of selecting the Nominating Committee (which vets applications for the...
2014-04-02
526 reads
The first version of the tool was developed by Amandhally and it can be found in the below path. Thanks...
2014-04-02
1,619 reads
The first version of the tool was developed by Amandhally and it can be found in the below path. Thanks...
2014-04-02
547 reads
Ausgezeichnet mit dem MVP-Award für SQL Server
(de)
Gestern, am 1. April 2014 erhielt ich die frohe Botschaft: Für meine Beiträge zur...
2014-04-02
3,481 reads
It’s three days to the first SQL Saturday in Nevada, taking place this Saturday in Las Vegas. I’m looking forward...
2014-04-02
655 reads
Today VMware released the list of 754 people who are the proud recipients of the coveted vExpert award for 2014....
2014-04-02
491 reads
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...
A while back I wrote a quick post on setting up key mappings in...
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