Am I a Good Customer?
Maybe not. This is a great post and cartoon from David Reed (a friend) mentioning me.
We've had some good arguements...
2007-08-07
1,588 reads
Blog Posts
Professional Development Plans Article on SSC
This was fun to write. It's a subject I'm passionate about and that too few in our field seem to...
2007-08-07
533 reads
Risky Behavior
An interesting debate from one of my editorials on risk. Some great points raised by everyone, but I still think...
2007-08-07
602 reads
No More SSNS
We've dropped an acronym!
In my rounds of the blogs today, a number of people have pointed out that SQL Server...
2007-08-03
537 reads
Celko, SQL, and SQLSaturday
Big news here in Orlando is that Joe Celko will be presenting two sessions at SQLSaturday on Nov 10. Once...
2007-08-02
469 reads
Revisit What You Know - Published on SSC
The article went live earlier this week. Didn't quite accomplish what I had hoped I think, which was to point...
2007-08-02
446 reads
Katmai July 2008 CTP is Out
I'm downloading now, and you need some sort of inviation to do so, but it's available and ready for you...
2007-08-01
612 reads
Undocumented use of the Columns_Updated() function
Q I need an easy way to see if a delete transaction has fired a trigger. Do you have any...
2007-08-01
628 reads
Midlands PASS Chapter - August 2, 2007
"Database Professional Toolkit" with Brian and Jeremy
Midlands PASS Chapter - August 2, 2007 Meeting
Sponsored by Red Gate Software
The Midlands PASS Chapter...
2007-07-31
1,562 reads
User Groups Moved to New Domain
We've just moved all the PASS chapters that were hosted on ~.ssc.com domains over to ~.sqlgroups.com. This is part of...
2007-07-27
1,555 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