Building a Database Dashboard with SSRS

Learn how to create a dynamic database dashboard that tracks key metrics using SQL Server Reporting Services. From setting up to deploying your report.

Common SQL Server Problems: Network Related or Instance Specific Error Occurred

This is the first in a series of articles meant to provide practical solutions to common issues. In this post, we’ll talk about one of the most pervasive error messages out there:

Automating SQL Server Access Review

Learn how you can automate checks and reports to l...

Retrieving SQL Server Index Properties with INDEXPROPERTY

SQL Server has several functions to assist with meta data about the server, databases, indexes, and more. In this tip, we will look at how to get index information for indexes in a database using the INDEXPROPERTY function.

Recovering data in SQL Server without full backup

There are multiple reasons for no full backup: corrupted backups, taking too much time to restore, etc. In this post, I want to show an alternative for these cases, an ace up one’s sleeve, that you can use to recover data.

Removing a File

The Minimal Linked Server

How to Safely Remove a SQL Server Data File Without Downtime

Learn how to safely remove a SQL Server .ndf data file without any downtime using DBCC SHRINKFILE (EMPTYFILE). This hands-on tutorial walks through real-world Azure-based setup, data redistribution, and storage cleanup — ideal for DBAs managing enterprise SQL Server environments.

Removing Log Shipping

Secondary Query Store