Tag: sql server

SQL Server 2016 End of Extended Support

| Posted on |

Many organizations are still running SQL Server 2016 in production. Sadly, many are running versions older than 2016 as well, however with SQL Server 2016, the end of extended support runs out very soon. July 14th, 2026, to be precise. After this date, there will be no additional updates unless you have an agreement for […]

SQL Server Upgrades

| Posted on |

I’ve had this conversation at least a 1000 times over the course of my career working with SQL Server and teaching classes. Is it better to upgrade in place or do a side by side upgrade. There are pros and cons to each method, however I’ll say upfront that my preference is a side-by-side upgrade […]

The “Kill” Command: What to Consider Before Stopping a SQL Server Process

| Posted on |

Whether you’re troubleshooting on-premises SQL Server, Azure SQL DB, Managed Instance, or Amazon RDS, you will eventually encounter a “lead blocker”—that one high-cost, long-running session holding every other process hostage. While your first instinct might be to issue a KILL command, the consequences vary wildly depending on what that session is actually doing. Here is […]

How to Reset the SA Password When You Get Locked Out

| Posted on |

Getting locked out of a SQL Server instance can happen due to a number of situations. The most common scenario I’ve encountered is when a SQL Server is moved from one domain to another without the domain being trusted or having a local SQL admin account. I recently encountered another incident where a DBA was […]

How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database

| Posted on |

I have recently had the privilege of working with multiple clients who have been taking advantage of Change Data Capture “CDC”. Change Data Capture is a feature that utilizes SQL Server Agent to log inserts, updates, and deletes occurring in a table. It makes these data changes available to be consumed in a relational format. […]