Download SQL patch Info

This article shows how to download sqlserverbuilds.blogspot.com to build your own automated sql patch level check.

Visualize the timeline of your SQL jobs using Google graph and email

Generate an HTML page with the timeline of your SQL jobs using Google graph and sp_send_dbmail

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

Mirroring and different sector sizes? BAD IDEA!

Be carefull when replacing a defective (FLASH) storage device, its sector sizes may vary without you knowing it.

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