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 destination drives....

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 cleanup the backup/restore history tables which reside in the msdb database. (You may also want to refer: http://beyondrelational.com/modules/2/blogs/77/posts/11371/sql-server-administration-cleanup-database-backup-history.aspx)...

In a rare case when you need to control the execution sequence of database triggers, you can use the sp_settriggerorder statement to do so. However, the recommended best practice always remains that you should have business logic dependent upon execution sequence within stored procedures....

using this script we can serialize Deserialize data...

In most of the website you must have seen, the contact us or contactme link at the end. Once you click that it will open a new mail window of your default mail client and it will have the mention subject and a mail id in the to box. So we can achieve that with the below line of code....

How do you identify system and user databases programatically? How do you hide the "master" database from the user when running an installer? Use these scripts to either list system or user databases as requried....

This function will convert time span difference of a time with current time into words and display it in English words. Suppose, if a post is 2 days old, it will return as "2 days ago". If it is 1 hours old, it will return as "2 hours ago"....

To check and provide the ACL of a folder/file you can use below DOS command or the Powershell Cmdlet. To know more about ACL read this : http://en.wikipedia.org/wiki/Access_control_list...

The following TSQL Script makes use of the Dynamic Management Function *sys.dm_os_volume_stats* to retrieve information about the physical disk drives. Please note that this function is available only from SQL Server 2008 R2 SP1 onwards. SELECT phy...

Most of the time we use script to play with folders in production or in local computer, here is a script to housekeep your folder keeping a retention period of required days....