New Laptop Bag and My Event Bag
Last year I wrote about stuff I carry in my laptop bag. Nothing original, definitely a tendency to carry things...
2012-09-12
1,217 reads
Blog Posts
Pearls in the Ocean – Part 1
In our day to day life with SQL Server, We refer web for many reasons.
This includes understanding new SQL...
2012-09-12
808 reads
Sometimes Failure Is An Option
Wouldn’t it be nice if failure was an option? You could go along in life, screw it all up and...
2012-09-12
772 reads
SQL Server Virtualization
This past summer I have been working on a new course for Learning Tree 2109 SQL Server Virtualization and Consolidation:...
2012-09-12
998 reads
SQL Server: Understanding GAM and SGAM Pages
We know that SQL server stores the data in 8 KB pages. An extent is made up of 8 physically contiguous...
2012-09-12
26,688 reads
Why do you attend sessions?
Many of you have attended sessions by technical speakers at conferences and mini-conferences like SQL Saturday, SQL Rally, 24 Hours...
2012-09-12
1,097 reads
Find Skew in Distributed Tables
The SQL Server PDW (Parallel Data Warehouse) is a beast of a machine. Spreading workload across multiple nodes inside the...
2012-09-11
1,520 reads
Going to San Diego (#SQLSat157)
It appears that I signed up to speak at the San Diego SQL Saturday coming up this weekend. I knew...
2012-09-11
694 reads
Quick tip: Querying database metadata with DBCC DBINFO
Page 9 in file 1 (of the primary filegroup) in a SQL Server database is the header page and contains...
2012-09-11
2,125 reads
Talking Career and Unstructured Data
The Denver SQL Saturday is coming in less than two weeks, SQL Saturday #169 is our second event in Denver,...
2012-09-11
939 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