Index your FK
A few months ago I read an article from SQLServerCentral.com about some Foreign Key gotchas. Since that article, I have seen...
2010-03-05
866 reads
Blog Posts
Keep Your Data Clean
In working with client data you start to notice trends that raise flags in your mind. In my case I'm...
2010-03-05
502 reads
More SQL Azure Samples
I have been playing around some more with SQL Azure in order to get ready for an upcoming presentation, so...
2010-03-05
2,274 reads
PASS Update #24
Time to update you again on all things PASS. First, I haven’t made a lot of progress on the speaker...
2010-03-05
535 reads
SQL Saturday Schedule Update
In January, I blogged about the upcoming SQL Saturdays for 2010, and since then, many more events have been scheduled,...
2010-03-05
612 reads
Worst Thing to Do to your DBA
Recently Andy Warren Blogged about things that could drive your DBA mad. There was a lot of feedback on SQLServerCentral...
2010-03-05
758 reads
Focus on Your Passion
Tuesday night I was having a conversation with my younger son, whom we call Turtle. It's a nickname that came...
2010-03-04
1,084 reads
Heading to Charlotte
I think I’ll forever associate Charlotte, NC with my middle son. We were heading back to Denver from Virginia Beach...
2010-03-04
375 reads
Output = MAXDOP 1
It is widely know that data modifications on table variables do not support parallelism, Peter Larsson has a good example...
2010-03-04
558 reads
Please Provide PASS with Feedback on its Speaker’s Resource Pages
The PASS Program Committee is gearing up for the 2010 PASS Community Summit “Call for Speakers”, and it would like...
2010-03-04
1,001 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