Rotating encryption keys for Always Encrypted
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine...
2018-05-09 (first published: 2018-05-01)
2,940 reads
The Data Files
Rotating encryption keys for Always Encrypted
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...
2018-05-01
35 reads
Rotating encryption keys for Always Encrypted
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...
2018-05-01
9 reads
Rotating encryption keys for Always Encrypted
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...
2018-05-01
11 reads
Rotating encryption keys for Always Encrypted
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...
2018-05-01
6 reads
SQLSaturday Madison – “Data Security for the Cloud” and “Three Steps to Lasting Encryption”
In just a few short weeks, SQLSaturday Madison will happen in Madison, WI, and I’m happy to say that I’m...
2018-03-23
233 reads
“Data Security for the Cloud”: A New Pre-Con at SQLSaturday Chicago
More and more companies are considering a move to the cloud, but one aspect of such a migration that may...
2018-02-07
330 reads
An open letter to the PASS community (2017)
PASS is our community.
It may sound a little cliche, especially with the current political climate in the US and other...
2017-09-20
351 reads
Replacing an expiring SQL Server encryption key
So you’re using encryption in SQL Server, but you’ve discovered that the expiration date of a certificate is expiring. What...
2017-05-17 (first published: 2017-05-05)
5,542 reads
24 Hours of PASS is coming up!
Another installment of 24 Hours of PASS is coming up next week on May 3-4! This semiannual event features 24...
2017-04-27
592 reads
Blogs
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
Forums
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers