2026-04-22
371 reads
2026-04-22
371 reads
The magic way to get better performance from your system is to write better code from the start.
2026-04-22
72 reads
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks at how the proc works. Another post for me that is simple and hopefully serves...
2026-04-22
10 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)
105 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
16 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
133 reads
2026-04-20
789 reads
2026-04-17
740 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,416 reads
2026-04-17
87 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
i have huge table with lot of data and is also wide. i took...
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