DBA MD
I just had the opportunity to spend some time with my four year old son at the doctor’s office. It...
2010-02-25
606 reads
Blog Posts
Editorial - “Dude, Your Fly Is Open”
In case you don’t subscribe to the SQL Server Central daily newsletter, check out the editorial I wrote entitled “Dude,...
2010-02-25
600 reads
Growing the Pool of SQL Speakers – Part 2
About a week ago I wrote Part 1, and got some interesting feedback (which I appreciate). Today I want to...
2010-02-25
864 reads
I’m Attending the South Florida Code Camp on February 27, 2010
I’m driving down tomorrow for the sixth annual South Florida Code Camp. This will be my third time attending and...
2010-02-25
524 reads
Renaming a Standalone Instance of SQL Server
I needed to upgrade the underlying IO subsystem of one of my IO intensive SQL Servers. After some discussion with...
2010-02-25
2,148 reads
Speaking in Cambridge, England March 24, 2010
If you are near Cambridge, England, I will be speaking at the Cambridge SQL Server Users Group on Wednesday, March...
2010-02-25
1,542 reads
SQLBits 6 to Be Held in London, April 16, 2010
The upcoming SQLBits 6, to be held Friday, April 16, 2010, will be held at the Church House Conference Centre...
2010-02-25
1,616 reads
The Apples and Oranges of Training
SQL Server Training is out there in all sorts of formats, price points and quality. It's time to look at...
2010-02-25
922 reads
The Journey from Smart to Good
“It’s easier to be smart than good.”
I heard that quote in a recent sermon at church and it is one...
2010-02-25
761 reads
Why Do My SQL 2008 Compressed Backups Shrink?
Introduction
Recently a coworker was doing some research with SQL 2008 Backup Compression on a very large database. During the testing...
2010-02-25
419 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