This Month… SSWUG Free SSIS Expo
Stinking Feet?
A couple months back I mentioned the SSWUG Free Expo Event: Basic and Complex SSIS Features. The time has...
2011-02-01
424 reads
StrateSQL
24 Hours of PASS Sessions Announced
In case you missed it last week, PASS has announced the speaker lineup for the next 24 Hours of PASS. ...
2011-02-01
555 reads
31 Days of SSIS – SSIS Naming Conventions (31/31)
31 Days of SSIS
We’re at the thirty-first, and last, post for the 31 Days of SSIS. The series started with...
2011-02-01
1,436 reads
Presentations Materials From Last Week
Last week I spoke at the PASSMN meeting here in Minnesota and then via a webcast to the Edmonton PASS...
2011-01-31
1,371 reads
31 Days of SSIS – Importing Execution Plans (30/31)
31 Days of SSIS
Almost time to wrap up the 31 Days of SSIS. We are down to just two more...
2011-01-31
2,857 reads
31 Days of SSIS – Exporting Execution Plans (29/31)
31 Days of SSIS
A day late for the twenty-ninth post of the 31 Days of SSIS, but it is still...
2011-01-30
2,378 reads
31 Days of SSIS – Jim Croce and the Foreach (File) Loop Container (28/31)
31 Days of SSIS
It’s Friday and I’m still taking Friday’s off in my 31 Days of SSIS blog series. As...
2011-01-28
887 reads
31 Days of SSIS – Adding Some Delta Force (27/31)
31 Days of SSIS
Welcome to day twenty-seventh post of the 31 Days of SSIS. We’re getting near the end now. ...
2011-01-28
1,537 reads
31 Days of SSIS – Small Package, Big Win (26/31)
Welcome to day twenty-sixth post of the 31 Days of SSIS. We’re getting near the end now. If you have...
2011-01-27
903 reads
Presenting on #SSIS to EDMPASS Today
Will you be in Edmonton today? How about near a computer connected to the inter-tubes? If so, you might be...
2011-01-26
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