Basics of Virtual Log Files in SQL Server

Script to enable and disable all the triggers in SQL Server

Query behind FETCH API_CURSOR and sp_cursorfetch

Script to restore multiple databases in SQL server

Script to get database and object level permissions

Script to grant access on all databases

 

Script to get percent complete

Trigger for new DB creation in SQL Server

Script to Identify the lead blocker in Sql Server

Script to get restore history of a database

Script to shrink Log files of all Databases

Skip Reboot by changing registry settings

Backup Audit Script for SQL Server 2000/2005/2008/2012

Script all database MDF file space details :

Steps to add an article to the existing Transaction Replication