[Coping] The Five Minute Journal
Reading Steve Jones’ posts about daily coping and seeing how it has affected me in a positive way, I’ve decided to share some of the things I’ve done to...
2020-08-14 (first published: 2020-07-30)
307 reads
Blog Posts
Daily Coping 14 Aug 2020
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...
2020-08-14
18 reads
Without PASS, Our Community is Worse Off
This year the PASS Summit is virtual. I’m speaking, as a donation, and Monica Rathbun has written some thoughts on the event. I’m hoping that attendance is high enough...
2020-08-14 (first published: 2020-08-06)
333 reads
Daily Coping 13 Aug 2020
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...
2020-08-13
17 reads
SQL Homework – August 2020 – More DML Triggers
Well, I’m running a bit late. Both for this month and the fact I completely missed last month. It was ... Continue reading
2020-08-13
87 reads
Unboxing SQL Clone 2020 for a PoC
When I got a new machine, I had SQL Clone on my old machine, in a few VMWare VMs. I decided to move this to my new machine, so...
2020-08-13 (first published: 2020-08-04)
350 reads
What Agent Jobs are Running??
Do you run SQL Agent Jobs in your environment? Do you know what is running at any given time? Most people do not know what is currently running if...
2020-08-13 (first published: 2020-08-04)
550 reads
Caution When Dropping Unused Indexes on an Azure SQL Database
Index Maintenance is an important aspect of database health. Above and beyond regular index rebuilds and reorganizations it is important to understand the usage of the indexes on your...
2020-08-12
15 reads
Daily Coping 12 Aug 2020
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...
2020-08-12
35 reads
Data Platform MVP 2020
I am humbled to be among so many great professionals and honored at the same time for having been chosen.
Related Posts:
It's an Honor: Microsoft MVP July 1, 2019
How...
2020-08-12
58 reads
Blogs
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
Forums
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...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
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