A Wellbeing Day at Redgate
It’s a day off for Redgate today. This is our annual wellbeing day, where everyone gets the day off. Well, not everyone, but anyone that has to work today...
2026-03-02
11 reads
Blog Posts
Ad Hoc SQL Server Help
I just need a few hours of your time… We get a variation of this request a LOT. So now it’s time to do something about it! Ad Hoc...
2026-03-02
13 reads
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
continuing from Day 1 where we covered the history of AI and GPT family, today on Day 2 i would like to discuss what came next after Generative AI...
2026-03-02
18 reads
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed: AI, Performance & Beyond will take place! This hands-on training is designed to help DBAs,...
2026-03-02
22 reads
RANK() vs DENSE_RANK(): #SQLNewBlogger
I haven’t done one of these in awhile, but I saw an article recently about this and decided to explain it to myself, but in a slightly different way....
2026-03-02 (first published: 2026-02-18)
527 reads
TempDB Internals – What’s New (SQL Server 2016 to 2022)
I wrote about TempDB Internals and understand that Tempdb plays very important role on SQL Server performance and everything temporary / memory spill comes to tempdb and it is...
2026-03-02
2 reads
Blog a Day – Day 1: History of AI
it has been a year since i have not written much on the blog and i would like to start a “blog a day” series. i have been continuously...
2026-03-01
23 reads
A New Word: on tenderhooks
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which makes you feel that much more rooted to the world, even if the roots belong...
2026-02-27
12 reads
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in Visual Studio Code…they make presenting (and generally working) in Visual Studio Code really smooth. But...
2026-02-27 (first published: 2026-02-20)
595 reads
Setting FK Constraints in Data Modeler
One of the things a customer asked recently about Redgate Data Modeler was how to set a FK constraint between two tables. The tool seemed to make it easy,...
2026-02-27 (first published: 2026-02-11)
310 reads
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
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 TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers