Version independent spGetBackupDateFromFile

This is an version independent stored procedure to get the backup date from a backup file.

It's tested for SQL 2005, 2008(R2), 2012 and 2014.

Consider it a template to which you can add more output parameters from the headerinfo to meet your requirements.

SQL Job Timeline (Graphical)

This script generates a graphical timeline of all SQL jobs with a variable zoom level

Backup all SSAS databases using TSQL

Enumerates and backups all SSAS DB's

Compare 2 datasets and output delta in one TSQL statement

There are many ways 2 compare datasets to find differences, this is one of them.

List index information for all databases

This SQL script returns a recordset with all the index information for all tables for all databases in a SQL server(instance)

List index information for the current database

This SQL script returns a recordset with all the index information for all tables within a database