Introducing The Blame Game
Introducing the Blame Game! Someone has messed up the new anatomy application’s (Mr. Body) performance and no one is willing...
2018-03-26
288 reads
Blog Posts
Is the traditional data warehouse dead? webinar
As a follow-up to my blog Is the traditional data warehouse dead?, I will be doing a webinar on that very...
2018-03-26
536 reads
Is the traditional data warehouse dead? webinar
As a follow-up to my blog Is the traditional data warehouse dead?, I will be doing a webinar on that very...
2018-03-26
73 reads
Notes on SQLSaturday Tampa 2018
Quick notes:
Same location as previous years, good!Parking was same place, but it was confused by a pay-to-park event on the...
2018-03-26
283 reads
PROJECT LIFE LESSONS - # Not The GDPR News
PROJECT LIFE LESSONS - # Not The GDPR News
Mark Williams and myself will delivering a seminar called #Not the GDPR news in Cardiff on...
2018-03-26
319 reads
Query Store and Automated Cleanup
Query Store has mechanisms for automatically cleaning your data. It is possible to cause them to break down. While presenting...
2018-03-26
534 reads
Revisiting catch-all queries
I originally wrote about catch-all queries early in 2009, just as something that I’d seen several times in client code....
2018-03-26 (first published: 2018-03-13)
4,549 reads
The 700 Milestone for SQL Saturday
This past weekend was SQL Saturday #700. Another milestone in the franchise of events, and I was glad to attend....
2018-03-26
750 reads
2018-03-25
11 reads
Allowing Azure Service to Connect to your Azure SQL server.
Allowing Azure Service to Connect to your Azure SQL server.
In this video David will look at the impact of allowing...
2018-03-23 (first published: 2018-03-13)
1,717 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
BCA KCU DARMO No.telp:08385883375
Whatsapp:08385883375 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
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...
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