SQL Server articles, tips and tricks
Home
About me and Nucleus
Partners
Articles, tips etc.
My blog
Links
Microsoft articles
Forums
Courses and training
Information
The ultimate guide to the datetime datatypes
Moving a database between two SQL Server instances
Large transaction log lile
Why you want to be restrictive with shrink of database files
Recommended actions for corrupt or suspect databases
(recently updated)
Minimizing data loss when accidents happens
Changing the name of a SQL Server machine
BACKUP using NO_TRUNCATE and RESTORE
Utilities
MailAfterJob - send email after Agent job, with status in mail subject and output files attached
(new)
Agent Alerts Management Pack
sp_dbinfo - database space usage information
(recently updated)
sp_tableinfo - list tables and space usage
sp_indexinfo - enhanced index information procedure
TSQL script to create backup file including database name, date and time
Restore all databases from a number of backup files in a directory