Transparent Data Encryption - Encrypting the Log
One of the interesting things about Transparent Data Encryption is that it tries to ensure that your data, whenever it...
2009-06-09
468 reads
One of the interesting things about Transparent Data Encryption is that it tries to ensure that your data, whenever it...
2009-06-09
468 reads
Scott Klein still needs a few more speakers for the first ever SQLSaturday in Miramar (basically Miami). So far Jeff...
2009-06-08
350 reads
I'm done with SQLSaturday #14, actually stuck in Pensacola for an extra night, but that's another story.
It was a great...
2009-06-08
593 reads
Scripting tasks in PowerShell is a fairly easy way to automate tasks, but you have to know when you get...
2009-06-08
955 reads
We got something good in the mail last week!
Some quick observations:
The build quality is outstanding. Nothing cheap at all...
2009-06-08
579 reads
My friend Bayer White is the event lead for the fifth annual Jacksonville Code Camp being held on August 29th...
2009-06-08
293 reads
I'm just back from the event and it turned out very well, just over 170 attendees attending their choice of...
2009-06-08
900 reads
Just received these from Karla:
Expectations: 0 Did not Meet, 4 met, 6 Exceeded.
Overall quality: Zero 1's, Zero 2's, Zero...
2009-06-08
293 reads
The SQL Saturday Pensacola pics are up! Visit the SQL Saturday Facebook group at http://www.facebook.com/home.php#/group.php?gid=58052797867&ref=ts
and tag or leave your comments.
2009-06-08
834 reads
When the announcement for Bing came out, I didn't immediately go over and check it out. As a matter of...
2009-06-08
1,064 reads
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Comments posted to this topic are about the item Creating a JSON Document II
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Comments posted to this topic are about the item Every Database Has Problems
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