SQL Server Backups
I’ve written many blog post and articles over the years about SQL Server backups and restore options. I am constantly amazed at how often I find databases that are...
2022-05-16
12 reads
Blog Posts
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
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
206 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
284 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
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
How Important Is a Google Knowledge Panel for Online Reputation?
I’ve been learning more about the google knowledge panel and it seems like one...
Which Wireless Credit Card Terminal Works Best for Small Businesses?
I’m currently researching the best wireless credit card terminal for a growing business and...
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
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