Missing Index Impact and Join Type
Erik Darling shows how missing index requests have different impact numbers depending on the query's join type.
Stairway to Advanced T-SQL Crossword
This crossword puzzle is based on the contents of the Stairway to Advanced T-SQL.
SQL Server Graph Databases – Part 3: Modifying Data in a Graph Database
Modifying data in Graph Database tables is similar to working with traditional tables, but there are several things to consider. Robert Sheldon explains how to insert, update, and delete rows of Graph Database tables and explains how to use several new helper functions.
Cloud Snake Oil
The Cloud isn't always what it seems and Steve notes that paying attention to finances might be the most important thing.
Alerts and Notfications for SQL Server Login, Database User and Role Membership Changes
Check out these scripts to create SQL Server jobs and Alerts when a login is created or dropped, a database user is added or dropped and when logins are added or removed from server roles or users are added or removed from database roles.
Spring into the Latest Features at the Luxemborg User Group
The next meeting of the Luxemborg SQL Server User Group has some great sessions planned.
SQL Community
Back in my early days as a database administrator, almost 16 years ago, I happened upon a web site called SQL Server Central. Because I found so many useful articles and forum posts, the site was open in my browser at work every single day. It was a great source of information, and eventually, I […]
How to Programmatically Identify When Your SQL Server Was Last Started
Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.
Keep It All
We could use more intelligence in our backup systems, since we don't need to keep all those files.
Blogs
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
Forums
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Spring Connections and Learning at PASS On Tour
Comments posted to this topic are about the item Spring Connections and Learning at...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers