First Session
I dropped into Brian Knight's "Clustering in 60 Minutes" to say hi. If
you've never seen this, it's pretty cool and...
2007-06-04
561 reads
Blog Posts
Tech Ed - Keynote
These will get pretty long as I'm kind of wordy, but these are impressions as things are occurring.
Registration is a...
2007-06-04
744 reads
Working Afternoon
I ended up driving around Orlando this afternoon to get books. We'd
printed the next version of our Two Minute SQL...
2007-06-04
573 reads
Midlands PASS Chapter Meeting for June 6, 2007
Our next meeting will be on Thursday, June 7th, at
6:30 PM. Training Concepts will once again be our gracious...
2007-05-29
1,355 reads
Speaking at PASS 2007
I'll be doing a spotlight session called 'Transactional Replication for Beginners' this year. I've been speaking at the Summit since...
2007-05-29
1,362 reads
Book Reviews
I've got a new article running on SSC today with a few more book reviews: http://www.sqlservercentral.com/columnists/awarren/2998.asp.
2007-05-23
1,425 reads
The Developer Differences
Here we are starting to see information on Katmai and I'm just getting around to an article comparing SQL 2005...
2007-05-22
1,322 reads
Volunteering
I've spent my spare time the last few weekends helping a non-profit called Fast Forward here in the Columbia, SC...
2007-05-21
1,498 reads
Webcast on exceptions and errors in SQL Server
When you have an hour to spare, jump over and view this useful discussion about errors and exceptions in SQL...
2007-05-21
1,447 reads
Stored procs vs user defined functions
I was at DevTeach/SQLTeach in Montreal last week. The conference was very well run and the organizers did a great...
2007-05-19
1,310 reads
Blogs
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers