31 Days of SSIS – One Package, Unlimited Tables (25/31)
31 Days of SSIS
One day at a time and we have reached the twenty-fifth post in the 31 Days of...
2011-01-26
1,705 reads
StrateSQL
Time To Get Your #SQLRally Vote On! – Part 2
Now it’s week three of voting for the upcoming SQLRally. This week, we are voting for the Enterprise Database Administration...
2011-01-25
588 reads
PASSMN January Meeting Today
Minnesota SQL Server User Group (PASSMN) will be meeting today. Come down and learn about SQL Server with Kalen Delaney...
2011-01-25
506 reads
31 Days of SSIS – One Package, Unlimited Databases (24/31)
31 Days of SSIS
Another day, another blog post all about SSIS in my continuing journey through 31 Days of SSIS. ...
2011-01-25
1,410 reads
31 Days of SSIS – Generating Row Numbers (23/31)
31 Days of SSIS
It’s Sunday afternoon and a good time to be putting up post twenty-three for the 31 Days...
2011-01-24
2,490 reads
PASSMN January Meeting This Week
Don’t forget – if you are in Minnesota this week the Minnesota SQL Server User Group (PASSMN) will be meeting on...
2011-01-23
528 reads
31 Days of SSIS – Data Flow Expressions (22/31)
31 Days of SSIS
Today, we continue on with the 31 Days of SSIS blog series. Yesterday’s post was on the...
2011-01-22
2,330 reads
31 Days of SSIS – Controlling Your Flow In The Control Flow (21/31)
Remember, what I said last Friday? I’m going do it, again. Which means, I’m taking the day off. There will...
2011-01-21
924 reads
Now Let’s Vote for 24 Hours of PASS
Yesterday, I wanted you to vote for some SQLRally sessions, mine included. Today, let’s vote for the sessions for the...
2011-01-20
617 reads
31 Days of SSIS – No More Procedures (20/31)
Time to shift off of configurations and environments and talk more about SSIS packages and best practices. If you haven’t...
2011-01-20
1,832 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