Many IT departments use pre-created ghost images to quickly setup development and quality assurance environments. When they change the name of the server after restoring the image, the SQL Server instance name remains unchanged. Here's a script to chang...

SQL Server provides a way to verify a database backup using the T-SQL command - RESTORE. This verification ensures that all backup sets are readable, checksum verification (if backup is checksum protected) and checking for sufficient space on the destin...

Additional rows are added to the backup and restore history tables after each backup or restore operation is performed. Hence, it is recommended that these history tables are periodically cleaned up. These SQL Server system stored procedures help you to...

If you want to save your PowerPoint presentation in HTML format and want it to show in a browser(IE) then following code might help you. Please be informed that this may not work for other browsers (other than IE) Read more: http://msdn.microsoft.com/e...

**Use case:** after some abortive attempt to make a copy of a database you can face with a problem that you have a copy of original database with all data, but all DEFAULT constraints were lost. This script allows you to get a list of all DEFAULT cons...

You can also specify ON DELETE and/or ON UPDATE rules while creating FOREIGN KEY constraints using script: ON DELETE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ON UPDATE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } For example: ...

This quick XQuery script was created to answer a question asked on my blog recently. The following code uses the XQuery functions "position()" and "last()" to determine the last element....

This is a script to to identify the unused indexes within a database. The column 'ReadsPerWrite' is an important field to consider. ...