Compression estimates

The script estimate compression benefits per each object in the database for which the page compression has not been implemented.

Recent database restores

The scrip returns history of database restores from MSDB

Run SQL/T-SQL scripts on folder

What to do when you have several sql scripts to run in your DB? Put all in a folder and use this...

Remove Database Encryption Key on all user databases

Below script will remove database encryption key, database certificate and master key on all the user databases.

For tempdb database, you need to restart the SQL Server Instance to complete the process.

Note: It is advisable to take transaction log backup before this activity is performed.

All Link servers working status check and failure alert over E-mail

This procedure will help you to automation of link server failure status check with help of SQL agent job scheduling. Job query :-
exec proc_check_linked_servers 'profiler name','E-mail ID'

How to read an audit file

The script reads data from audit files for a particular audit

Compare MS SQL Agent jobs on two servers

During a database migration or a side by side database upgrade project we need to migrate the MS SQL Server Agent jobs. This script compare jobs by names and shows unmatched jobs.

Insert data into a SQL Server Table using Powershell using Invoke-SQLc

How to insert data into a SQL Server Table using Powershell using Invoke-SQLcmd Commandlet

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.

Database maintenance progress

Often we need to know on which stage is a maintenance operation such as: backup, restore, check database. You can get this information using my script.