How To Recondition Batteries
These days we are all looking for ways to save money and even to help the
environment. If you came across this site you are most...
2018-04-24
26 reads
These days we are all looking for ways to save money and even to help the
environment. If you came across this site you are most...
2018-04-24
26 reads
The Southwest Missouri SQL Server Users Group (SWMOSSUG) is dedicated to providing SQL Server Education and Career Guidance for IT...
2012-08-29
1,804 reads
I have been told by hundreds of DBAs that I have the best DBA job in the world as Director...
2012-08-15
1,106 reads
I think all of us have had poor, good, and great managers at one time or another in our career....
2012-07-02
1,931 reads
Reprinted from my editorial in the Simple-Talk Newsletter.
It’s hard to believe, but it was five years ago that Red Gate Software...
2012-06-18 (first published: 2012-06-11)
2,044 reads
When I was a novice DBA, I spent little time documenting my SQL Servers. But as I became more experienced,...
2012-06-12 (first published: 2012-06-05)
4,741 reads
Dynamic Management Objects (DMVs and DMFs) are some of the most useful tools for the DBA. So this month’s question...
2012-06-01
1,028 reads
If you haven’t heard yet, Red Gate Software is sponsoring a six city tour of the United States of its...
2012-06-01 (first published: 2012-05-29)
1,784 reads
As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections...
2012-05-24 (first published: 2012-05-21)
2,176 reads
Reprinted from my Database Weekly editorial.
Forget what you thought you knew about SQL Server certification, as Microsoft has completely redesigned...
2012-05-21
4,316 reads
Good documentation gets you started. Good books get you deep. After years of working...
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
Comments posted to this topic are about the item Creating a JSON Document IV
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
When the schema of an object is changed, SQL Server wipes out the previous...
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