Last week I presented on three separate occasions during what is considered the biggest Microsoft Data Platform conference of the year, the PASS Summit: Full-day pre-conference session Speaker Idol...
2020-11-18
70 reads
Mike Walsh invited us on March 1st 2010 to write about I/O. This abbreviation stands for Input / Output, and is often used as shorthand for persisted storage. Given...
2020-11-11
13 reads
When it comes to Microsoft products, the rule of three — at least as far as I’m concerned — is where you can accomplish the same task in three...
2020-11-10
79 reads
In my quest to respond to every T-SQL Tuesday since the dawn of the end of 2009, it was only a matter of time before Rob Farley’s name came...
2020-11-04
28 reads
For the second T-SQL Tuesday ever — again, hosted by Adam Machanic — we were asked one of three options, and I elected to go with the first one:...
2020-11-02 (first published: 2020-10-28)
320 reads
T-SQL Tuesday is a fantastic series of blog posts derived from over 130 topics over the past 11 years, inviting bloggers to share their thoughts on a particular theme...
2020-10-21
21 reads
This — like last week’s post — is not about SQL Server or Azure SQL Database. In a way, it hearkens back to a post I wrote a few years...
2020-10-14
28 reads
This post is brought to you — indirectly — from a boss I loved working for, on a project which almost killed me, at a company which I had...
2020-10-07
439 reads
This post looks at a curious data type that isn’t really a data type. Instead, sql_variant tries to be all things to all people. As with most things in...
2020-09-30
229 reads
Tencent Security has released a report (written in Chinese) describing a new malware attack by the name of “MrbMiner” on SQL Server instances exposed to the Internet with passwords that can...
2020-09-23
388 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