What Would You Like to See in a New Book on Indexing?
I am currently in the early stages of writing an outline for a new book on indexing, targeted towards novice...
2010-01-20
419 reads
Blog Posts
Windows Azure Platform Training Kit
Everyone interesting for Windows Azure Platform Training Kit - December Update, can find it from Microsoft location here.
There are lot of...
2010-01-20
956 reads
Windows LiveSynch
After a while, most people who work with SQL have accumulated quite a few scripts that they use for investigation,...
2010-01-20
519 reads
Collaboration Patterns – Part 1
I’ve been thinking a lot lately about how to be more effective at collaborating, usually in the context of a...
2010-01-19
680 reads
Goals and Theme Word for 2010
I was warned by my father when I turned 21 that, although it seemed like it took a long to...
2010-01-19
596 reads
Out Of My Comfort Zone: Building a Web App
If you read Fundamentals of Storage Systems – Stripe Size, Block Size, and IO Patterns you know I built a little...
2010-01-19
1,329 reads
SQL Server 2008 SP1 Cumulative Update 6 Released
Microsoft has released Cumulative Update 6 (CU6) for SQL Server 2008 SP1, which you can request here. This is Build...
2010-01-19
1,751 reads
Three Big Things That Got Me Here
I was tagged by Steve Jones in the meme that Paul Randal started a few days ago, so I need...
2010-01-19
839 reads
Three Events that Brought Me Here
Paul Randal started the latest community chain blog, What three events brought you here?, and I was tagged by Steve...
2010-01-19
637 reads
Three Things
So for the latest database geek meme, Paul Randal started this thing off and tagged Tom LaRock, who enlisted Grant...
2010-01-19
2,435 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