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
12 reads
Blog Posts
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
20 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)
434 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
1 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
18 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)
558 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)
305 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)
20 reads
Ramblings about data communities and your contributions, no excuses
I have been active in the data community throughout my career. I have met people and made friends in the process. As I look back on it, I am...
2026-02-26
17 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers