PASS SQL Saturday - September 2012
PASS SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in...
2012-09-04
636 reads
Blog Posts
PASS Virtual Chapter Events - September 2012
PASS DBA Fundamentals Virtual Chapter
fundamentals.sqlpass.org / Twitter: @DBAFundVC
September 4, 2012 - 11:00 a.m. CST
Introduction to SQL Server Service Broker
Speaker: Adam Belebczuk
In this...
2012-09-04
1,066 reads
September Events
Wow, I can’t believe it is already September of 2012. Labor day has come and gone, school is in session and the SQL Community is still busy. With that,...
2012-09-04
4 reads
September Events
Wow, I can’t believe it is already September of 2012. Labor day has come and gone, school is in session...
2012-09-04
887 reads
Some Jargon from the SQL Server World
Not long ago I wrote about how to write well about SQL Server, and one major point was that jargon...
2012-09-04
1,126 reads
SSMS Report Error – Index(zero based) must be greater than or equal to zero and less than the size of argument list !
SSMS reports are one of the best ways to pull some great deal of Server level or Database level information...
2012-09-04
4,708 reads
The Field Museum – SQL in the City 2012 – Chicago
Chicago is a neat down. My first PASS Summit was in Chicago, back in 1999. My wife joined me with...
2012-09-04 (first published: 2012-08-29)
2,407 reads
Windows Server 2012
I haven’t paid too much attention to this version of windows yet, but I have just been reading up on...
2012-09-04
733 reads
Am I Following Your Blog?
As I sat around this past weekend I was left wondering… am I missing any good blogs out there? With...
2012-09-03
895 reads
Capture SQL Server Deadlocks using Extended Events
Microsoft SQL Server provides a variety of different options to monitor deadlocks. This includes Trace flags 1204 and 1222, SQL...
2012-09-03
1,525 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