Monitoring the Number of Connections
Monitoring your SQL Server is important. This article examines one of the metrics you might want to keep an eye on.
Stairway to SQL Server Extended Events Level 3: Working with the Extended Events UI
In the next installment of our stairway to Extended Events, we delve into the Live Data and Target Data Viewers.
What's a Lot of Money?
Handling a budget can be an interesting experience for many technical professionals. Today Steve wonders if you treat this differently than your budget at home.
Customizing Database Deployments using Flyway Callbacks and Placeholders
How to customize a database deployment process using Flyway, demonstrating how to incorporate tasks such stamping a version number into the latest database build, or writing to the SQL Server log.
Partitioned Tables Cause Longer Plan Compilation Times
Folks sometimes ask, “When a table has more indexes, and SQL Server has more decisions to make, does that slow down execution plan generation?”. Brent Ozar talks through his response in this article.
Query Optimizer Suggests Wrong Index and Query Plan -- Why?
A good example where the Query optimizer picks the wrong query plan and suggested index.
UX Matters
User interface is a part of software development that many technical people pay little attention to during the process of building something. However, it can be a problem for your customers.
Ten tips for building a collaborative DevOps culture
There is more to DevOps than tools and automation. In this article, Robert Sheldon explains how to create a DevOps culture based on collaboration.
Reteaming
Many organizations will change their teams around over time, but not all do this regularly. Steve talks about how Redgate does this every year.
Comparing and Syncing Data using SQL Data Compare Command Line
Robert Sheldon demonstrates how to start automating data comparisons between two databases, from the Windows command line or PowerShell. With a single command, you can easily compare and sync data such as test data sets, or static data used for reference or lookup purposes.
Blogs
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...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
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...
Multiple Sequence Values
Comments posted to this topic are about the item Multiple Sequence Values
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers