As a SQL Server DBA with years of experience tuning production environments, I’ve seen the same patterns repeat: nightly index maintenance jobs running for hours, consuming massive CPU and...
2026-07-06 (first published: 2026-06-19)
892 reads
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same frustrating issue. Applications and SSMS sessions that had been rock-solid for years suddenly started throwing...
2026-05-27 (first published: 2026-05-07)
323 reads
As a data nerd who’s spent the last 25+ years helping organizations keep their databases running smoothly, I’ve had this conversation more times than I can count: “We’re moving...
2026-04-14
7 reads
I hate writing these posts. On March 10, 2026, Microsoft dropped a security update that fixes CVE-2026-21262 – an Elevation of Privilege vulnerability in SQL Server. If you’ve got...
2026-03-11
20 reads
Hey everyone, Tim Radney here. Over the years I’ve seen far too many organizations learn the hard way what happens when you ignore database integrity checks. In traditional SQL...
2026-02-11
8 reads
Part of being a DBA is dealing with transaction logs that grow uncontrolled for some reason. This often gets raised to the DBA in the form of a drive...
2026-01-13
9 reads
SQL Server 2025 is Generally Available
The post SQL Server 2025: What’s New and Why It Matters appeared first on Tim Radney.
2025-12-03
198 reads
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...
2025-11-24
36 reads
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...
2025-10-14
28 reads
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...
2025-09-15 (first published: 2025-08-27)
849 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Hub Cs:08218154374 Jl. S. Parman No.66, Kebun Kenanga, Kec. Ratu Agung, Kota Bengkulu, Bengkulu...
Hub Cs:08218154374 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi,...
Hub Cs:08218154374 Jl. H. Agus Salim No.10 A, Sawahan, Kec. Padang Tim., Kota Padang,...
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers