Free Tools for Testing SQL Sever
You Need To Test Your SQL Server!
Its like screaming “TEST THE BREAKS ON YOUR CAR!” If you don’t have the...
2012-08-16
2,251 reads
Blog Posts
2012-08-16
809 reads
Introduction to Windows Azure SQL Database (Part 1)
Windows Azure SQL Database also known as SQL Server Data Services or simply SQL Azure is a Microsoft’s cloud services...
2012-08-16
1,938 reads
Meme15: Top 5 Reasons I Like My Job
This month’s Meme15 topic is ‘Top 5 Reasons I Like My Job’. A little over a year ago, I started...
2012-08-16
1,330 reads
Monitor Deadlock in SQL 2012
Do you still use trace flag 1204 and 1222 to monitor Deadlock? or using profile to capture deadlock? Now we...
2012-08-16 (first published: 2012-08-12)
18,064 reads
Quick Tip: Accurate Log Shipping Status
Here’s a quick reminder for those of you using log shipping, and checking the SSMS report “Transaction Log Shipping Status”...
2012-08-16
887 reads
Replication and TFS
So, we’ve had this issue lately at work with our TFS build/deploys causing a significant amount of contention and only...
2012-08-16
2,329 reads
Speaking at 24 Hours of Pass
24 Hours of PASS (24HOP) has been around a few years now, but this will be my first time participating...
2012-08-16
560 reads
SQL Saturday 151 BI Pre-con: Stacia Misner
Hello Dear Reader, SQL Saturday 151 Orlando is picking up steam. The Pre-Con’s have been named and they are fantastic. ...
2012-08-16
743 reads
Unwanted dependency between different parts of the code
Small systems tend to grow with new functionality and new access points. When the system grows, the need for data...
2012-08-16
1,122 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