Please vote for my SQLRally session
I’m hoping to do a presentation at SQLRally in Dallas on May 10-11, but I need your help!
There is a...
2012-02-21
724 reads
Blog Posts
Shameless Plug: Vote For My Sessions!
Have you voted yet for my sessions your favorite sessions for SQL Rally? If not, this is a friendly reminder...
2012-02-21
620 reads
Show Us Your Coolest SSRS Reports
I’ll show you mine if you show me yours. Over the past nine years or so, I have showcased many...
2012-02-21
915 reads
SSIS Script Component Source -- Proc/Select Stmt
I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks"...
2012-02-21
1,343 reads
SSIS Script Component Source -- Proc/Select Stmt
I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks" presentations. I had to build one moments ago and...
2012-02-21
8 reads
SSIS Script Component Source -- Proc/Select Stmt
I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks" presentations. I had to build one moments ago and...
2012-02-21
10 reads
Two Sessions Up for Vote at SQLRally!
I received great news last week that one of my sessions, Windows Operating System Internals for DB Pros, was accepted,...
2012-02-21
857 reads
What's New is SSIS 2012? - Find out with Andy Leonard at the NJ SQL User Group - tonight!
As us SQL professional folks know, since the advent of SQL Server Integration Services, affectionately known as SSIS, it has...
2012-02-21
2,614 reads
Where’s My Backup? SQL Server Backup Issues
You can cause yourself problems if you don’t know where your backups are stored, and how they are being made....
2012-02-21
1,514 reads
A Script A Day - Day 11 - User Permissions By Database
Today's script will return you permissions granted to a user for every online database. The script uses EXECUTE AS so...
2012-02-20
1,096 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