Pens
On Monday I wrote about journaling and while any pen will do, I think having a pen dedicated (as it...
2018-12-06
250 reads
On Monday I wrote about journaling and while any pen will do, I think having a pen dedicated (as it...
2018-12-06
250 reads
In the spirit of “do more” we’re hoping to host at least 4 pre-cons in Orlando in 2019. Right now...
2018-11-27
261 reads
A few weeks back I wrote Some Thoughts on How To Prepare to Serve on the PASS Board of Directors....
2018-11-20 (first published: 2018-11-11)
1,528 reads
This was the 20th PASS Summit, a decent milestone! Interesting to pause and think, what will the Summit look like...
2018-11-12
257 reads
It turns out that the 2019 Summit and Ignite will be held the same week in 2019, see this post...
2018-11-02 (first published: 2018-10-23)
2,347 reads
I was disheartened to read the post that shows we have three candidates for three positions this year. Started with...
2018-11-02
312 reads
When you take a job, do you ask about holidays? Do you consider them a benefit? Andy Warren asks what those holidays might mean to you.
2018-10-25 (first published: 2015-03-03)
218 reads
From time to time I’m asked for advice and insight on running for and serving on the PASS Board. I...
2018-10-22
248 reads
We wrapped up our 12th SQLSaturday here in Orlando two weeks ago. Overall things went well. Registration was just a...
2018-10-20
256 reads
The right tool is important for a good job. Andy Warren asks if you're thought about the tools you use on a daily basis.
2018-10-17
67 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...
We have a SQL Server installed. We have a 500GB drive for the database....
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...
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