TDE – Regenerating the Database Encryption Key
As discussed in the last post, with TDE (Transparent Data Encryption), you generally do not need to change the Database...
2018-04-03
1,138 reads
Blog Posts
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1
(last updated: 2018-04-09)
In answering a recent question on DBA.StackExchange related to why some characters work for parameter names and others...
2018-04-03
564 reads
Why Projects Fail...Free Session, Free Beer and Free Food
Why Projects Fail...Free Session, Free Beer and Free Food
Mark Williams and myself will delivering a seminar called #Not the GDPR news in...
2018-04-03
323 reads
AT TIME ZONE: The easy way to deal with time zones and daylight savings time
Many people think daylight savings time was created to help align the hours that the sun is up with our...
2018-04-02 (first published: 2018-03-27)
5,147 reads
Buggy Whips 2.0
I recently found myself rereading a very old blog post of mine, from the very beginning of this blog, discussing...
2018-04-02
277 reads
Free Webinar – DBAs vs. SysAdmins in Cloud Availability April 19
SIOS and I are proud to host a joint free webinar entitled “DBAs vs. SysAdmins in Cloud Availability” on Thursday,...
2018-04-02
284 reads
How SQL Compilation Can Prove the Server CPU
It is relatively easy to spot CPU-bound system. But, the source of CPU pressure is not always easy to pinpoint....
2018-04-02
1,253 reads
Imposter syndrome
Last week I posted the following “joke” on twitter: –
I’ve called it a “joke” but I wasn’t really joking. This...
2018-04-02
294 reads
Jacksonville, South Florida, and Houston
Just crossed off my quarterly goal of planning SQLSaturday attendance for the next quarter (I’m writing this on March 31st!)....
2018-04-02
299 reads
Migrating to Azure DBaaS – A Client’s Steps Taken to the Cloud – Part 2
Hello everybody! Thanks for stopping by again. In Part 1 of this series, I gave the background of the project, and...
2018-04-02
127 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
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...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
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