Replicated Stored Procedure Execution
One feature that many of my clients are unaware of is that the batched execution of a stored procedure can be...
2013-09-04
2,100 reads
Will Assaf
Pointers For SQL Saturday Attendance
I recently got an email from another SQL Saturday organizer asking for "pointers for getting more attendees" to their upcoming...
2013-08-20
491 reads
Cannot find NT Service\MSSQL$SQL2012?
If you cannot find the virtual account used by the default settings installation of your SQL 2012 instance (in this...
2013-08-16
1,192 reads
Distribution setup SQL Server Agent error: "RegCreateKeyEx() returned error 5, 'Access is denied.'"
In the Configure Distribution Wizard, the step "Configuring SQL Server Agent to start automatically" errors with the following text:
TITLE: Configure...
2013-08-15
11,943 reads
Baton Rouge Startup Weekend
I'm spreading the word out about an event this weekend called Startup Weekend.
It's an event for developers, designers, and entrepreneurs...
2013-08-13
625 reads
Recap from SQL Saturday Baton Rouge 2013
As the head of the planning committee for SQL Saturday Baton Rouge this year, I had the distinct pleasure of...
2013-08-04
801 reads
SQL Saturday Baton Rouge 2013
SQL Saturday is a global event to bring Information Technology speakers and professionals together for a community-driven, community-attended free day...
2013-06-11
568 reads
SQL Saturday Baton Rouge Call for Speakers closes June 6!
SQL Saturday Baton Rouge Call for Speakers is open through June 6 (closes June 7 at midnight).
This year's pre-conference banquet...
2013-06-04
664 reads
Hunt Down Tables Without Clustered Indexes
This one's a gimme, but an underrated utility script when I enter a new environment and look for low-hanging fruit...
2013-05-09 (first published: 2013-05-03)
2,571 reads
Use the Default System Trace to Find Autogrowth Events
The SQL Server Management Studio built-in standard report for "Disk Usage" is very handy to view the performance-sucking autogrowth events...
2013-05-03
2,409 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