dutyDBA.com

Practical solutions from a real DBA

Category: SQL Server Administration

This category contains all the articles and posts related to SQL Server administration.

SQL Server Administration

How to check if an SQL Server database is in use?

Vyas Kondreddi

May 6, 2026

DBAs often get asked if a particular database is in use, often with a view to dropping any unused databases to save valuable disk space.
Continue Reading

Latest Articles

SQL Server Administration, SQL Server Engine, SQL Server Security

Errors 15138 & 15183 preventing the dropping of user from SQL Server databases?

September 10, 2026
Migration, SQL Server Administration

Identifying SQL Server cross-database dependencies when migrating

July 12, 2026
SQL Server Automation, SQL Server Security, SQL Server Tools

Management Studio tip – A menu driven RunAs launcher batch file to open SSMS using multiple different login credentials

June 30, 2026
SQL Server Administration, SQL Server Security, Troubleshooting

dutyDBA Case Files #2 – Who dropped the tables and deleted/recreated stored procedures on the production database?

June 29, 2026
PowerShell, SQL Server Administration, SQL Server Automation, SQL Server Tools

How to compare the server configuration and settings (sp_configure settings) of two SQL instances and identify the differences?

June 27, 2026