SQL Saturday #70
This blog is long overdue about my journey to Columbia SC for SQL Saturday #70. I was very fortunate to...
2011-04-07
428 reads
Blog Posts
A SQL Server Hardware Nugget A Day – Day 6
For Day 6 of this series, I am going to talk about a few useful tools you can use to...
2011-04-06
395 reads
Getting More Hardware Information from SQL Server Denali DMV Queries
As I recently discussed, I often hear from database professionals who are not allowed to access their database servers directly....
2011-04-06
2,758 reads
Microsoft Migration Assistant v5.0 Released
As I was surfing around twitter after the marathon TV event that was the Royal Wedding came to end last...
2011-04-06
711 reads
Posting Code? Trust, But Verify
Here's a tip for bloggers (or anyone else) who use third party tools to convert T-SQL code into a publishing ...
2011-04-06
641 reads
Powershell Day 6
Day 6 Functions and error handling As everyone aware of what is function, so no need to give therotical infomration...
2011-04-06
222 reads
Should a DBA be involved in the physical set up of a Database server? Part 2
Part 1 of this blog talked about the bad experience we had with a badly configured SQL Server. The second...
2011-04-06
1,608 reads
SQL Injection: It's not just about your data
On the topic of my SQL Connections SQL Server presentation, one of the things I pointed out about recent SQL...
2011-04-06
1,106 reads
SQL PASS ERC: How to Score the Interview?
One of the topics the Election Review Committee has discussed is how best to score the interview portion. Because of...
2011-04-06
1,356 reads
SQL Saturday #63–Dallas
I have been trying to get to Dallas for a SQL Saturday for nearly a year, when the first event...
2011-04-06
1,395 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