SQL Saturday 162
SQL Saturday 162 was a great event, kudos to the team involved and I took a lot of pleasure in...
2012-09-09
751 reads
Blog Posts
SQL Server:Output Clause
Couple of days back, one of my colleague came to me asking for help. He is inserting multiple record from a...
2012-09-09
1,494 reads
SQLSaturday Metrics
A recent article in the PASS Connector called out some interesting stats about SQLSaturday for 2011 and 2012. I’m including...
2012-09-09
702 reads
Upcoming Fall Events
During September/October I’ll be presenting at several in-person events:
Tampa IT Pro Camp
Join system administrators and IT professionals for the Tampa...
2012-09-09
1,117 reads
5 Performance Killers When Working With Linked Servers
When working with linked servers, the most expensive factor to consider is the amount of data that will have to...
2012-09-08
563 reads
My Session on Locking Internals Part 1 in CSSUG Meet
Bad weather won't stop hungry minds. Our today’s Chennai SQL Server User Group (CSSUG) meet happened with around 25 enthusiastic SQL Server...
2012-09-08
858 reads
SQL Server Best Practices for DMV's - Houston Tech Fest 2012
It is a pleasure meeting everyone today at Houston Tech Fest! The new facility is miles away - literally and figuratively...
2012-09-08
943 reads
Lost in Translation – Deprecated System Tables – sysdevices
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-09-07
1,168 reads
SQL Saturday 167
SQL Saturday #167 is just hours away. We have worked hard to get everything setup and in place and hope...
2012-09-07
579 reads
SQL Server vs. Oracle
Just so we’re clear, I use SQL Server. I like SQL Server. But, this doesn’t mean I have anything against...
2012-09-07
5,019 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