2008-09-19 (first published: 2008-07-20)
1,486 reads
Scripts
2008-09-18 (first published: 2008-07-15)
702 reads
2008-09-16
334 reads
Create string from table
This simple script retrieves a range of values from a table and presents the results as a string.
2008-09-15 (first published: 2008-07-16)
1,617 reads
Get DBMail information
get the profile name and the account name etc about the dbmails created on the server
2008-09-12 (first published: 2008-07-13)
994 reads
2008-09-11
1,526 reads
2008-09-10 (first published: 2008-07-12)
1,515 reads
DB Connection Killer
This script opens a little cursor that will clean out connections to any DBs you specify.
2008-09-09 (first published: 2008-07-21)
1,526 reads
2008-09-09
1,079 reads
2008-09-08 (first published: 2008-07-20)
1,271 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers