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
15 reads
Blog Posts
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
20 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
23 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)
544 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
4 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
26 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
13 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)
614 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)
316 reads
SQL Server Journey till 2025 (brief)
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part of all the Versions!! 7 (70)– Foundation, OLAP Services, Query Analyzer 2000 (80) – SSAS,...
2026-02-27 (first published: 2026-02-26)
21 reads
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Secure Communications
Comments posted to this topic are about the item Secure Communications
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers