SQL Server 2008 R2 - The list of the supported features
The MSDN - Microsoft, has collected too much info about features supported by the SQL Server 2008 R2, for all editions...
2010-03-24
1,235 reads
Blog Posts
Why I Don’t Run for the PASS Board
It’s getting close to that time of year when you can apply to run for the PASS Board of Directors....
2010-03-24
1,649 reads
An Un-CATCHable Error?
I've been using the scripting tools in SSIS for some time, but I came across something today that I can't...
2010-03-23
2,175 reads
Critiquing Free Events
Yesterday I wrote about expectations at free events, basically saying they don’t differ a lot from paid events. The next...
2010-03-23
564 reads
Inserting into an XML document
I was reading through the latest XML Workshop article that I have from Jacob Sebastian. It’s a fantastic series for...
2010-03-23
2,050 reads
Left outer join vs NOT EXISTS
And to wrap up the miniseries on IN, EXISTS and JOIN, a look at NOT EXISTS and LEFT OUTER JOIN...
2010-03-23
12,586 reads
Managing Your Backup Files
I recently posted a couple of scripts that backup all databases on your SQL Server instance to disk with a...
2010-03-23
1,323 reads
Plagiarism Again
Update: The problem posts have been removed from the SQLTechConsulting site.
I ran across a note from Brent Ozar (blog | Twitter)...
2010-03-23
1,796 reads
SQL Saturday #39 New York
New York, New York, it’s a hell of a town. The Bronx is up and the Battery’s down. The people...
2010-03-23
553 reads
Virtual Presentation : Index Statistics
I just gave a virtual presentation, courtesy of Pass and the appdev group. The recorded presentation is available here:
Recorded Presentation
A...
2010-03-23
631 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