SQL PASS Summit 2009 – Day 3
The day started off with the Quest Software breakfast presentation, to which I arrived late to find a standing-room-only crowd. ...
2009-11-04
620 reads
Blog Posts
SQL Server 2008 Diagnostic Information Queries
Here is the script that I used in my Dr. DMV presentation this afternoon at PASS. It is a set...
2009-11-04
1,642 reads
Tuesday at the PASS Community Summit
Today was the first official day of the full (3-day) conference, with about 2,200 full conference attendees. Officially, PASS claims...
2009-11-04
416 reads
What Do You Do When Your Employer Doesn’t Want to Support Your DBA Career?
At the 2009 PASS Community Summit, I have gotten the opportunity to talk to many DBAs, and to find out...
2009-11-04
589 reads
Women in Technology Luncheon
I've never attended this in the past, but I've wanted to. As the father of young girl I want to...
2009-11-04
2,762 reads
Basic iFTS Monitoring Queries
This is one of the scripts that I will be using for my presentation “Tips and Tricks for Using SQL...
2009-11-03
1,474 reads
Check out Straight to 8 Program
We seem to be busting at the seams lately with quality content from great providers. I wanted to recommend to...
2009-11-03
224 reads
Date Expressions in SSIS
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted...
2009-11-03
573 reads
Day 1 – PASS Summit 2009
Up early again, started my day at the Convention Center for breakfast. Light breakfast, drinking water, never seem to drink...
2009-11-03
379 reads
Day Zero of PASS (Pre-conference seminar with Kim Tripp)
This week, I’m blogging and tweeting from the PASS Community Summit in Seattle, Washington. The week of the Summit is...
2009-11-03
784 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