We Need Our Community Leaders to Share Their Views
My friend Jack Corbett returned to blogging recently and one of his comments was not wanting to be the guy...
2012-08-25
1,145 reads
Blog Posts
Book Review: Troubleshooting SQL Server A Guide for the Accidental DBA
Over the past few years, Adam and I have won several books at the local MadPASS chapter meetings. I’ve intended...
2012-08-24
2,155 reads
Government and Transparency
I ran across this report that talks about the effectiveness of transparency requirements put in place around the Recovery Act...
2012-08-24
652 reads
Mentoring
I’m putting my money where my mouth is, with respect to my last blog post. I am officially a mentor...
2012-08-24
641 reads
Paying it Forward
My company has recently put forth an effort to hire fresh college graduates and interns. I think this is a...
2012-08-24 (first published: 2012-08-22)
1,736 reads
Resources for Those Dealing with Security Patches
It's been a while since I was in the day-to-day business of security patches. However, I still keep up with...
2012-08-24 (first published: 2012-08-21)
2,577 reads
T-SQL: Performance of SQL Agent Duration Calculations
In my article published yesterday on using Powershell for SQL Durations (Working with SQL Agent Durations), I proposed using a...
2012-08-24
1,616 reads
Amazing Margaritas in Austin – SQL in the City US Tour
The last time I was in Austin was last year, for a weekend trip with my wife to see Stevie...
2012-08-23
1,479 reads
Another Execution Plan… In the Cloud!
A couple of weeks ago I posted about how different execution plans look when using the Azure Management Portal. I...
2012-08-23 (first published: 2012-08-20)
1,900 reads
Don't Disconnect Your Common Sense
This falls in line with a previous post about common sense in IT.
I was having lunch with a co-worker,...
2012-08-23
1,749 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