Generate INSERTs the new 26ai way
Six years ago(!) I did an Office Hours session where I demonstrated a little routine that would let you generate more efficient INSERTs by converting a standard INSERT-VALUES into...
2026-03-02
12 reads
Blog Posts
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)
560 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
9 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
36 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
21 reads
INSERT-VALUES – Bigger is NOT always Better!
One of the super cool features in 26ai is the ability to extend the VALUES clause in your INSERT statements to allow multiple rows per execution. If you’re unfamiliar...
2026-02-27
16 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)
648 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)
325 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)
25 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
24 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers