Comments in your generated code : T-SQL Tuesday #155
The ever amazing Steve Jones (blog|twitter) is our host this month. And in case you didn’t know he also is ... Continue reading
2022-10-24 (first published: 2022-10-11)
309 reads
Blog Posts
Daily Coping 24 Oct 2022
Today’s coping tip is to find joy in tackling something that you have put off. I on not a bad procrastinator, but I do put plenty of things off....
2022-10-24
9 reads
How to use Azure Site Recovery (ASR) to replicate a Windows Server Failover Cluster (WSFC) that uses SIOS DataKeeper for cluster storage
Intro So you have built a SQL Server Failover Cluster Instance (FCI), or maybe an SAP ASCS/ERS cluster in Azure. Each node of the cluster resides in a different...
2022-10-24 (first published: 2022-10-12)
277 reads
Daily Coping 21 Oct 2022
Today’s coping tip is to do something constructive to improve a difficult situation. My life is amazing, but there are certainly some difficult times. Sometimes at work, sometimes at...
2022-10-21
13 reads
PGSQL Phriday #001: Two Truths and a Lie
As a part of my own journey of learning within PostgreSQL, I’ve decided that I’m going to take part in PGSQL Phriday as often as I can, just as...
2022-10-21 (first published: 2022-10-07)
188 reads
Presenting at DeveloperWeek Global!
I'm excited to be presenting my talk on Building a complete API in Azure
2022-10-21 (first published: 2022-10-20)
20 reads
T-SQL Tuesday #155–Using Dynamic SQL for SQLCMD
It’s that time of month, and I’m the host this month. I wrote the invitation last week and now its’ time to answer. I’m actually using an example from...
2022-10-21 (first published: 2022-10-11)
411 reads
Daily Coping 20 Oct 2022
Today’s coping tip is to avoid blaming yourself or others. Find a helpful way forward. I’ve been busy lately. My days are jammed up with a number of presentations...
2022-10-20
21 reads
Daily Coping 19 Oct 2022
Today’s coping tip is to take time to reflect on what you have accomplished recently. What have I done recently? Lots of stuff, but a couple things come out...
2022-10-19
11 reads
Overcoming a storage failover issue with SQL Server on Kubernetes using Portworx
In a previous post I talked about an issue with storage failover when a Kubernetes node goes offline. In a nutshell, the issue is that the attachdetach-controller in Kubernetes...
2022-10-19 (first published: 2022-10-11)
151 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