SET QUOTED_IDENTIFIER
We recently received a script for a modified stored proc from a vendor. My colleague ran the script on the...
2006-12-15
2,564 reads
Blog Posts
The Moto Q and Being Proactive
I am a big fan of automating whatever I can and being proactive. The more proactive you can be, the...
2006-12-14
1,506 reads
How to handle an invalid default database
My general recommendation for SQL Server service accounts and accounts that have sysadmin fixed server role membership is to default...
2006-12-11
1,898 reads
Midlands PASS Chapter is official
A group of us met on Thursday, December 7th, 2006, and voted to approve the bylaws and a motion to...
2006-12-11
1,450 reads
Jason Haley recently began posting his interesting finds again
Jason Haley used to post his Interesting Finds about every day, if not multiple times a day. The interesting finds...
2006-12-09
1,375 reads
SysInternals Tools Updated
Several SysInternals Tools have been updated. One of the big updates was to the PSTools Suite - now you can pass...
2006-12-09
1,432 reads
Windows 2000 Resource Kit Tools Available
If you're like me and rely a lot on the resource kit tools, you may have found that it's relatively...
2006-12-09
1,857 reads
Log Buffer #22: A Carnival of the Vanities for DBAs
Welcome to the 22nd edition of Log Buffer, a
weekly compendium of postings and news from database-related blogs across the...
2006-12-08
1,590 reads
Inserting missing rows
I can think of three ways to insert just the missing rows from one table or query into another table. ...
2006-12-06
2,979 reads
Extreme Work
"The Productivity Pro" Laura Stack posted in her blog today about jobs where long hours are the norm:
'Extreme' jobs...
2006-12-05
1,484 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