script

PSBlitz 6.1.0 is out and it brings new backup and security checks, improved Excel handling, support for the ImportExcel PowerShell module, as well as other improvements. What is PSBlitz? For …

It took me a while, considering the previous release was back in December, but the latest release of PSBlitz (6.0.0) is finally out and it brings GUI Mode, Dark Mode, …

This post is an overview of PSBlitz, how I use it in diagnosing SQL Server issues, and the notable changes it went through over the past 3 years. Intro In …

This is a script that I wrote to help me next time I might need to bulk reseed out-of-sync SQL Server sequences tied to default constraints. Setting the scene Someone, …

In this post I demo a script I put together to count NULLs in all columns of a given table in SQL Server and store the results in a table. …

This is a brief post containing a query that lists object dependencies in SQL Server for either a specific object or for the entire database. Intro Figuring out object dependencies …

In this post I demo a query to get connection information in SQL Server aggregated by database, host, client and login name. Intro I’ve spent some time this week working …

This post contains a short SQL Server query to get storage info for the disks hosting your instance’s database files without having to RDP into its host VM. The query …

This brief post contains a script that can help switch a whole SQL Server instance, model and all user databases, to SIMPLE recovery. The script is useful in case of …