Introduction
The topic of mixing SQL Server Failover Cluster Instances (FCI) with Always On Availability Groups (AG) is pretty well documented....
2019-03-13
2,516 reads
My next tip is to test your BI solution with the volume of data that you are expecting. This is...
2019-03-13 (first published: 2019-02-25)
1,956 reads
I recently shared a story about how I was personally responsible for a development project going off the rails (and...
2019-03-13
431 reads
I recently shared a story about how I was personally responsible for a development project going off the rails (and oh boy, did it go off the rails). It’s...
2019-03-13
4 reads
(last updated: 2019-03-15 @ 02:45 EST / 2019-03-15 @ 06:45 UTC )
Binary collations are, in many ways, simpler to understand than non-binary collations...
2019-03-13
13,633 reads
Yes. Here’s the proof from an output of SELECT @@VERSION: [crayon-5c98bf6b3202b962253620/] Here’s a screenshot of me running mssql-cli on the...
2019-03-13
683 reads
I’ve seen many people go through the trouble of setting up database mail and configuring SQL Agent Alerts only to...
2019-03-13
266 reads
I’ve been writing a bunch about Azure Data Studio. I’ve also been recording videos on the topic. A comment I...
2019-03-13 (first published: 2019-02-25)
2,373 reads
Are you interested in speaking at the Professional Association for SQL Server’s annual Summit conference? The call for speakers is now open, and you may submit up to three...
2019-03-13
5 reads
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I will again guide you through some of...
2019-03-13
947 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