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,566 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,508 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,899 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,376 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,862 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
3,008 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
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers