Category: SQL Server Administration
This category contains all the articles and posts related to SQL Server administration.
-
How to check the last backup date of every database on your SQL Server?
This article provides a script to display the last backup date of all the database on your SQL Server. This covers the three main types of backups (full backup, transaction log backup and differential backup)
-
SQL Server Orphan Users and Logins – how to prevent and manage them, and the gotchas to be aware of
This article discusses what are SQL Server orphan user and logins, how to prevent users and logins getting orphanned, and how to manage them. It also talks about the security risks associated with orphan AD/Windows groups.
-
How to monitor all the currently running SQL Server Backup and Restore operations in real time?
Imagine a scenario: You have a very busy non-production environment hosting dozens of databases. Lots of developers are actively using the server. They are backing
-
How to find the last restore date (when, from where, and to what point) of every SQL Server Database on your server?
Some non-production environments require copies of latest production databases for live testing, bug fixing and new code deployments. These environments have a current production database
-
How to use sys.dm_io_virtual_file_stats to check the disk read and write performance of your SQL Server?
When it comes to checking how well the disks are performing on your SQL Server, sys.dm_io_virtual_file_stats is your best friend. This Dynamic Management View (DMV)
-
sp_WhoIsActive – What is it? How to deploy & configure it? How to maintain the collected data?
If you’ve been an SQL Server DBA for a while, chances are you are already familiar with sp_WhoIsActive, a comprehensive, free, lightweight stored procedure developed
-
Are you a system administrator? Worried about high memory usage on your SQL Server host? Read on!
Quite often, I get approached by Windows SAs or system administrators in my organisation, saying that my SQL Server host is using too much memory
-
How to check if an SQL Server database is in use?
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.
Latest Articles


