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

The Long Running Backup

Database Files on Shares I