Unused Indexes in your databases

This Script allows you to determine the list of unused indexes in your databases.
For sys.dm_db_indexes_usage_stats, make sure that the last rebbot of the service sql allows you to conclude

SQL Server Missing Index

SQL Server Missing Index Detail Script

Custom Replication Status Record Latency Monitor

Monitors replicated tables for any publisher/subscriber for latency in record counts, alerts via email if latency exists beyond a specified threshold

Get date for iteration of a DOW

Good for Thanksgiving, Daylight Savings changes, Others?

HTML Table Results For Email

HTML Table formatted results of a view or table for emailing

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'