Last week we lost another SQLFamily member. Gareth Swanepoel passed away on 8 Jan 2021. He was a fellow speaker, jolly fellow, and Microsoft PM. Across many years of...
2021-01-22 (first published: 2021-01-14)
805 reads
Data Saturday #2 – Guatemala is tomorrow. This is the first event on the calendar, though the second one to move from SQL Saturday over. I’m thrilled that this...
2021-01-22
30 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-21
21 reads
2021-01-21
610 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-20
19 reads
Today Steve Jones gives you ideas on how to keep learning and growing your career.
2021-01-20 (first published: 2018-01-19)
303 reads
2021-01-20
512 reads
There was a security bulletin (CVE-2021-1636) for SQL Server, an elevation of Privilege vulnerability that could be exploited when an Extended Event session is running. SQL Server has released...
2021-01-20 (first published: 2021-01-13)
1,813 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-19
15 reads
2021-01-19
578 reads
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
i have huge table with lot of data and is also wide. i took...
Comments posted to this topic are about the item Creating a JSON Document II
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers