PASS Virtual Chapter August presentations
If you do not know by now, PASS has many virtual chapters that give free webcasts all month long. I...
2012-08-19
772 reads
Blog Posts
Would You Listen To The Steve & Andy Radio Show?
My friend Steve Jones and I have talked every week for a long time, close to ten years now. On...
2012-08-18
973 reads
Database Corruption, Transparent Data Encryption, and Trace Flag 5004
This one comes straight from the email bag. A friend recently had a problem, they were placing TDE on a...
2012-08-17 (first published: 2012-08-13)
5,725 reads
Different ways to audit SQL Server security
Today, my first article (ie. Different ways to audit SQL Server security) published on SearchSQLServer.com. In this article, I discussed...
2012-08-17
1,085 reads
Home Backup for the DBA
I’ve been giving a Prepare for When Disaster Strikes talk at SQL in the City this year, and it’s designed...
2012-08-17
1,515 reads
RAID (Redundant Array Independent Disk)
RAID (Redundant Array Independent Disk) As disk/storage plays a very important role in any application, everything is saved on disk...
2012-08-17
909 reads
Restarting
Well, it’s been awhile since I’ve written anything. I have lots of excuses for not writing, but none of them...
2012-08-17
783 reads
Restarting
Well, it’s been awhile since I’ve written anything. I have lots of excuses for not writing, but none of them are rally valid. There are 2 real reasons for...
2012-08-17
12 reads
Actual Emails: The Customer Doesn't Want Full Recovery Mode
Got this question in an email. I'll paraphrase.
William Hoping you can advise me on best way to handle this. My client doesn’t...
2012-08-16
685 reads
Coming to Your Town
I can’t sing and I can’t play and I left the young generation behind a while ago, but I’m still...
2012-08-16
1,168 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