No Summit Submission This Year
I had three ideas I considered submitting this year:
Devops for the DBASQL ChecklistsLearning Plans v2I’ve presented the first topic a...
2018-03-29
265 reads
Blog Posts
PASS Virtualization Webinar – April 11
I am proud to present a free webinar for the PASS Virtualization virtual chapter entitled “Level Up Your Cloud Infrastructure...
2018-03-29
417 reads
Speaking at SQL Saturday Atlanta (#733)
I am so honored and humbled to have been selected to speak at SQL Saturday Atlanta (#733) on May 19,...
2018-03-29
399 reads
SQL Script: - How to find the last access date of a database
Sometime we create databases on Test/ Development database servers for temporary uses for short duration and forgot to delete them after the work got completed. As a part of...
2018-03-29
16 reads
SQL Script: - How to find the last access date of a database
Sometime we create databases on Test/ Development database servers for temporary uses for short duration and forgot to delete them...
2018-03-29
1,836 reads
SSMS now has a vulnerability report
Security is an important and often overlooked function of technology. Don’t believe me? Go to a SQL conference and look...
2018-03-29
431 reads
Stop Previewing the bim.layout File in SSAS Tabular
A quick blog post for future reference, because I know I’ll bump into this again someday.
When you’re working with a...
2018-03-29 (first published: 2018-03-22)
1,850 reads
Toolbox - Just the Basics
There are many query sets out there to collect varying groups of configuration data - the ones I most frequently use...
2018-03-29
700 reads
Why We’re Organizing SQL Saturday in Wheeling, WV on April 28th
Some of my friends know I am a huge fan of the song “Havana” by Camila Cabello. They also know I like to remix songs and if I was...
2018-03-29
11 reads
Why We’re Organizing SQL Saturday in Wheeling, WV on April 28th
Some of my friends know I am a huge fan of the song “Havana” by Camila Cabello. They also know...
2018-03-29
1,523 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