Free SQL Server Health Check with dbatools

Roll your own SQL Server Health Check with dbatools

After a longer break than expected, I am back to the dbatools for SQL Server DBAs blog series, and this one is a monster! In fact, this project is so big that I think it will be better to release it incrementally. This will allow you clone the repository, test and modify it in your … Read more

Updates for all sp_Check tools – March 2026

DBA Toolbox

As promised last month, we are planning for (at least) monthly updates of our FREE sp_Check stored procedures, so here are the March updates. This month we did change the “ReadMore” URL links in the results of all tools to not use redirects. This might have been causing issues for folks who just wanted some … Read more

SQL Server Case of the Week: Databases in a “Recovery Pending” state don’t always require surgery

SQL Server case study of the week

You get an alert that there are one or more databases in a “Recovery Pending” state. This means the database started but could not complete the recovery pending process for some unknown reason. It is stuck in this state and unusable until recovery can be completed. The Investigation After receiving the alert, I verified that … Read more

Data Literacy is a Strategic Opportunity

Image

Every year, organizations spend money on data platforms, business intelligence tooling, and analytics subscriptions. The decision to start these projects get executive sponsorship. The implementation gets a project manager. The launch gets a company-wide email with a lot of enthusiasm and a screenshot of the new dashboard. Then, six months later, the same leadership team … Read more

SQL Server Case of the Week: SSRS Data-Driven Subscriptions Missing After Migration to SQL Server 2022

SQL Server case study of the week

You migrate SSRS from SQL Server 2016 to SQL Server 2022. The reports are there. The data sources look right. The encryption key is loaded. Everything checks out until you open the web portal, and your data-driven subscriptions are gone. You can see them in the ReportServer.dbo.Subscriptions table, but the portal won’t show them. And … Read more

SSRS Data-Driven Subscriptions Missing After Migration to SQL Server 2022 -Troubleshooting Guide

where is my subscription?!

If you’ve migrated SSRS to a new server and your data-driven subscriptions have disappeared, or new subscriptions are failing with a generic timeout error, this post walks through three separate issues we hit on a single migration and how we resolved each one. Data-Driven Subscriptions Disappeared After SSRS Migration to SQL 2022 Standard After migrating … Read more