Detecting and Removing Duplicate Indexes
Indexes are the solution to many performance problems, but with too many indexes on tables can hurt the performance of...
2012-09-14
1,813 reads
Blog Posts
Interesting Culture
A post from Alex Maccaw, programmer at Stripe. He talks about some things he likes about the company, and overall...
2012-09-14
1,201 reads
Register for Sean’s Dallas precon!
On October 13, Dallas will hold our second ever Special Bi Edition of SQLSaturday Dallas - #SQLSat163 for you Twitter folk...
2012-09-14
1,086 reads
Sleepless in Seattle – SQL in the City 2012
A few years ago I went to Seattle a few days before the PASS Summit started. I took my middle...
2012-09-14 (first published: 2012-09-10)
1,907 reads
Something for the Weekend – SQL Server Links 14/09/12
It’s SFTW Time, I hope you’ve had a great week!
Make sure you don’t miss this weekly round-up of SQL Server Links,...
2012-09-14
1,530 reads
Surface Area Configuration tool available in SQL Server 2008 & onwards
Surface area configuration is a security measure that involves stopping or disabling unused components. Surface area configuration helps to improve security by...
2012-09-14
4,538 reads
The DevConnections Schedule is out
It’s preliminary, but the fall 2012 SQL Server Connections schedule at DevConnections is out. I’ll be speaking Tuesday, Oct 30,...
2012-09-14
1,339 reads
Two Hundred Up
I was working on my blog this last week when I realised I was approaching my 200th blog post on...
2012-09-14
748 reads
Update on My Lenovo Laptop
Order status on the web site still shows an estimated ship date of the 4th (of September) for my X1...
2012-09-14
812 reads
Finding DDL Triggers
Triggers are the types of objects in SQL Server that are easy to lose track of. There isn’t an obvious...
2012-09-13
10,967 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