SQL Job Ownership Article on SSC.Com
Today, Please see my featured article appearing on SQLServerCentral.com discussing SQL Agent Job Ownership.
Have you ever had a situation...
2009-11-19
628 reads
Robert Pearl
Let's Talk Ownership (and SQL Jobs)
It seems that the ownership of jobs is something that is often overlooked when articles explain
2009-11-19
9,027 reads
And the Winner is........
DB Audit Challenge #1
And the Winner is….
First, I want to thank everyone that participated in the DB Audit Challenge, and...
2009-11-10
814 reads
Thoughts on a PASSing Scene...
Well it certainly has been a busy and exciting week at PASS. I couldn't go this year, but through the...
2009-11-05
521 reads
DB Audit Challenge #1 - Part II - Get a Clue
In the spirit of my Who DID IT and RAN SQL Caper presentation.....
OK, I was hoping to get the creative juices...
2009-11-03
742 reads
Reference to PASS Session - T-LOG
Hey, just caught wind of some timely stuff going on at PASS. Had my trusty 'Google alert' email me, set...
2009-11-03
810 reads
DB Audit Challenge #1
Take the DB Audit Challenge - Intermediate - DB Audit Challenge #1
For those of you who have been following my recent blogs,...
2009-11-01
1,191 reads
SQLSaturday Sensation in NJ
Well, it's a wrap! Saturday has come and gone, but memories will go on. It was great to see so...
2009-10-26
752 reads
Who did IT and Ran - The title of my upcoming presentation...
UPDATE: I just finished up my presentation slides for this upcoming NY/NJ SQL User Group meeting, on Saturday, 10/24/2009. I may cut...
2009-10-21
938 reads
It's NOT TOO LATE to Register....NY/NJ SQLSaturday Event 10.24.09
Hi, all;
The countdown to the NY/NJ SQL Saturday event this upcoming Saturday has begun. And it's NOT TOO LATE to...
2009-10-20
547 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