Daily Coping 1 Jun 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-06-01
18 reads
Blog Posts
How you can save up to 80% on Azure Data Factory pricing
… with this one weird little trick 🙂 Sorry for the clickbait, but you can actually save a lot on ADF pricing if you design your pipelines carefully. And...
2022-06-01 (first published: 2022-05-11)
673 reads
Performance of Azure Shared Disk with Zone Redundant Storage (ZRS)
On September 9th, 2021, Microsoft announced the general availability of Zone-Redundant Storage (ZRS) for Azure Disk Storage, including Azure Shared Disk. What makes this interesting is that you can...
2022-06-01 (first published: 2022-05-11)
339 reads
Azure High Availability
Lets write about Microsoft Azure, specially the area of high availability when it comes to virtual machines. No doubt you will know about Azure Virtual Machines. IaaS approach is...
2022-05-31
18 reads
Daily Coping 31 May 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-05-31
16 reads
New Pluralsight Course – Deploying and Managing Azure Kubernetes Service (AKS) Networking
My new course “Deploying and Managing Azure Kubernetes Service (AKS) Networking “ is now available on Pluralsight here! If you want to learn about the course, check out the...
2022-05-31
18 reads
Setting Up Sessionize for Your User Group – Part 1 – Create an Event
I jumped on the bandwagon early so to speak to use the user group feature of Sessionize and since then I’ve walked at least five user groups through setting...
2022-05-31
38 reads
Daily Coping 30 May 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-05-30
24 reads
Finding Memorial Day–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. It’s Memorial Day in the US. A holiday,...
2022-05-30
30 reads
TSQL Tuesday #150 – My first technical job
It’s that time of the month again, the blog party, woohoo! This time Kenneth Fisher (b | t) has invited us to blog about our first tech job. Oh...
2022-05-30 (first published: 2022-05-10)
179 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