Nucleus Datakonsult SQL Server articles, tips and tricks

Home

About me and Nucleus
Partners

Articles, tips etc.
My blog
Links
Microsoft articles
Forums

Courses and training




Microsoft Most Valuable Professional


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