One year later: my look back on the PASS organization
My good friend and talented singer Rob Volk reminded me recently that I had promised to write about my involvement with PASS at the end of its life, and I...
2022-01-05
17 reads
Blog Posts
Tech Debt – Free Yourself from the Precipice
No matter how you name it, "hairball", "spaghetti code", "tech debt" or "DIY code", the result is the same - you are dealing with legacy code that nobody wants...
2022-01-05 (first published: 2021-12-25)
359 reads
Daily Coping 4 Jan 2022
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...
2022-01-04
29 reads
Get Certificate Details for SQL Encryption In-Transit Using PowerShell
In my opinion, all customers should be encrypting connections to their SQL Servers to secure data in-transit, but that’s a discussion for another day. Today, I wanted to discuss...
2022-01-04
361 reads
Daily Coping 3 Jan 2022
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...
2022-01-03
16 reads
On the nature of constant change
Recently my spouse and I travelled to South Africa (yes, I know there’s a pandemic on) to deal with a gloomy family matter that required in-person interaction. Being an...
2022-01-03 (first published: 2021-12-22)
194 reads
Searching dbatools–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I learned something new about dbatools. That’s using...
2022-01-03 (first published: 2021-12-22)
333 reads
Azure DB – A Quick Spelunk Into XEvents to Love
This is a very simple introduction into the creation of an Extended Event session using a template for Azure SQL DB. I demonstrate the use of the GUI to...
2022-01-02
64 reads
Last Week Reading (2022-01-02)
?? Press Efficient Upserts into Data Lakes with Databricks Delta When MERGE on data lake is inefficient. Building a Data Mesh Architecture in Azure – part 1 With this...
2022-01-02
17 reads
Last Week Reading (2022-01-02)
? Press Efficient Upserts into Data Lakes with Databricks Delta When MERGE on data lake is inefficient. Building a Data Mesh Architecture in Azure – part 1 With this...
2022-01-02
4 reads
Blogs
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
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