Special Events at the PASS Community Summit
If you’ve ever been to a PASS Community Summit, you know that each day is packed with a ton of...
2009-10-29
466 reads
Blog Posts
SQL University: Multiple Paths and Ownership Chaining
Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...
2009-10-29
2,671 reads
Suggested Max Memory Settings for SQL Server 2005/2008
It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something...
2009-10-29
253,646 reads
There was a rancher who had a DBA.... (Getting prepped for PASS)
and B-I-N-G-O was his game-o.
Maybe not that funny, but I think that SQL Bingo will be a fun time. If...
2009-10-29
824 reads
What Should PASS Strive To Be?
Steve Jones had a good editorial earlier this week entitled, What Do We Want from PASS?. It didn’t generate as...
2009-10-29
930 reads
Amazon.com Author Central Page
If you are a book author, Amazon.com now allows authors to promote their books with a new author’s page. The...
2009-10-28
610 reads
Crazy Egg
I know, I should have put more in the title. Crazy Egg is a web page traffic analysis tool that...
2009-10-28
564 reads
Electronic Health Records – What’s the Big Deal? (Part 2)
In the first installment of this discussion, I talked about the challenges facing database professionals and others with respect to...
2009-10-28
1,858 reads
How Many Rows Have Changed?
One of the things that I've asked DBAs, and I see asked often, is how much does your data change?...
2009-10-28
2,484 reads
2009-10-28
576 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