Storage Field Day 23 – HammerSpace
I am thrilled to have been a part of this year’s Storage Field Day 23 event, held by Gestalt IT during the first week of March. This event is...
2022-05-16
49 reads
Blog Posts
SQL Saturday Jacksonville Slide Decks
Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous Integration Using Local Agents Adopting a DevOps Process for Your Database
2022-05-14
58 reads
Daily Coping 13 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-13
13 reads
Power BI: Creating an Info Button with UNICHAR()
Reports are only as useful as they are easily understandable. When making reports for executives and other business leaders, it is vital to ensure the context and insights of...
2022-05-13 (first published: 2022-05-04)
433 reads
Snowflake + Azure Privatelink
Azure Privatelink provides private connectivity from an Azure Virtual Network to Azure PaaS such as Snowflake. This secures the connection between client endpoint and Snowflake(more...)
The post Snowflake + Azure...
2022-05-13
205 reads
SQL Saturday Jacksonville – May 14th, 2022
Hi Everyone, This is your Austin SQL Server Consultant and I will be speaking at SQL Saturday Jacksonville. I am happy to get back out and, on the road,...
2022-05-13
17 reads
Synergy of Azure Synapse & Joyful Craftsmen
Why „synergy”? Let’s take a look at the context first. Data warehouses have undergone development on Microsoft technologies in the last few years.
From the beginning, customer data warehouses were...
2022-05-13 (first published: 2022-04-28)
238 reads
Azure SQL Managed Instance – Maintenance Windows
A post close to my heart, Azure SQL Managed Instance, I have blogged about this many times but I feel I should be sharing more details about this. One...
2022-05-12
281 reads
Cross DB Access With Module Signing
Foreword
I’ve recently had to revisit this topic and spent a lot of time recalling the details. So I’m writing this blog post mainly as a reminder for myself.
The most...
2022-05-12
18 reads
Daily Coping 12 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-12
31 reads
Blogs
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
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) ...
Forums
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
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...
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