2026-04-22
2 reads
2026-04-22
2 reads
The magic way to get better performance from your system is to write better code from the start.
2026-04-22
6 reads
One of the things a customer asked recently about Redgate Data Modeler was how to adjust a FK constraint between two tables. The tool seemed to makes this easy,...
2026-04-20 (first published: 2026-04-13)
103 reads
One of the popular features of Redgate Monitor has been the ability to add custom mertics for various purposes. This has been popular, and along with our curated list...
2026-04-20
14 reads
A few countries are looking to reduce their reliance on US technology. While they might leave Windows, Steve thinks they will continue to run SQL Server.
2026-04-20
110 reads
2026-04-20
754 reads
2026-04-17
735 reads
In a world dominated by data, organizations heavily rely on business intelligence tools like Power BI for deriving insights and informed decision-making. Yet, as data volumes grow and user demands increase, achieving optimal performance becomes challenging.
2026-04-17 (first published: 2025-03-26)
2,409 reads
2026-04-17
79 reads
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on Wheels blog for a long time and I appreciate all that he does, especially given...
2026-04-16 (first published: 2026-04-14)
19 reads
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
Comments posted to this topic are about the item Creating a JSON Document II
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Comments posted to this topic are about the item Every Database Has Problems
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