Community
Community.
In the SQL Server community, we are basically one big #sqlfamily. This is a story of how the family helped...
2018-03-23
382 reads
Blog Posts
Power BI Custom Visuals Class (Module 95 – VitaraCharts–MicroChart)
In this module you will learn how to use the VitaraCharts – MicroChart. The VitaraCharts – MicroChart provides a intuitive way to...
2018-03-23
1,038 reads
Scripting Tables with dbatools
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-03-23
1,615 reads
SQL Saturday #695 Guatemala
This is probably a very delayed post, but I have been really busy lately.
As mentioned in my previous post, I...
2018-03-23
101 reads
SQLSaturday Madison – “Data Security for the Cloud” and “Three Steps to Lasting Encryption”
In just a few short weeks, SQLSaturday Madison will happen in Madison, WI, and I’m happy to say that I’m...
2018-03-23
233 reads
T-SQL Tuesday #100: What’s New With Scalability Groups in SQL Server 2026
Welcome to T-SQL Tuesday #100. In a community filled with ADD people like the SQL community (myself included), who would...
2018-03-23 (first published: 2018-03-13)
2,446 reads
Data experiments with salary survey – I
As someone who just crossed three decades of working in technology – I have a sudden renewed interest in understanding how...
2018-03-22 (first published: 2018-03-12)
2,736 reads
Getting Started With R In SQL Server 2017
Prior to SQL Server 2016, running R on Microsoft platform required an installation of the R Language and its environment...
2018-03-22 (first published: 2018-03-13)
4,314 reads
Recruitment Agents are not bad people...despite what you might read
Welcome to WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent...
2018-03-22
367 reads
SQL Vulnerability Assessment for Azure SQL Database
Back in September 2017 Microsoft announced a new security feature for Azure SQL Database called the SQL Vulnerability Assessment (VA)....
2018-03-22
1,000 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