Querying the Procedural Cache on Canada Day (July 1st)
The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources...
2009-06-30
2,444 reads
Blog Posts
SSIS - Creating a Deployment Manifest
Using a Deployment Manifest in SSIS allows you to deploy a set of packages to a target location using a...
2009-06-30
42,024 reads
Tracking My Goals – Half the Year
I made a series of resolutions in January related to SQLServerCentral. These are things that I wanted to accomplish this...
2009-06-30
1,728 reads
Unwired for Days
Today is the first day that I've really had any significant time on the computer over vacation. That probably sounds...
2009-06-30
1,380 reads
Best Thing I Learned at PASS
At the 2003 PASS Summit in Seattle the organization had a "SIG Challenge" that involved developing a database solution to...
2009-06-29
1,369 reads
Featured Blog: Jeremiah Peschka
I met Jeremiah at the PASS Summit last year and since then I’ve looked in on his blog from time...
2009-06-29
1,697 reads
SQL Saturday #17 - Abstract Submitted
I was asked to attend SQLSaturday #17 in Baton Rouge, LA. Despite my lack of desire to travel, I've never...
2009-06-29
1,518 reads
LinkedIn Groups
I’ve written a few posts now about LinkedIn, and for now still find it be the best fit for me...
2009-06-28
1,556 reads
SQLPSX Release 1.6
I completed Release 1.6 of SQLPSX which adds support for SQL Authentication and addresses several issues. SQLPSX consists of 106 functions,...
2009-06-28
1,612 reads
Incorporating Kids Into Work
I recently attended SQL Saturday #14 in Pensacola and took my daughter along. This was the third presentation she's come...
2009-06-26
1,474 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