Kill all USer Sessions before starting to restore a Database

If you have a requirement to Kill all USer Sessions before starting to restore a Database, you may use this script

Compare hotfix

Easy way to compare hotfix

Display Transaction Log Size

Stored procedure to display transaction log size for select databases.

Random Data Generator

A query to generate random values for several different data types.

List Job Dependencies

A Stored Procedure that lists all Jobs that target a database and the job dependencies

Function to convert UserAccountControl number to details text

Function that converts AD UserAccountControl number to details text

DB Integrity & Backup Report

This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.

Setup Alerts for SQL Replication

If you want to monitor few specific alerts for SQL Replication (Merge and Transnational), you can may consider adding these 14 alerts.

Monitor SQL Server and Service

To monitor SQL service and the host server is up and running, if down send e-mail to DBA

Recent Restore History

This script simply returns the most recent restore information about databases for a server.

Returns the destination database name, the device used to perform the restore and the restore date.