SQL Server articles, tips and tricks

Home About me and Nucleus Partners Articles, tips etc. My blog Links Microsoft articles Forums Course demo files

Over the years, you run into frequently asked questions and issues that you find worthwhile looking a bit deeper into. Here, I have collected such elaborations, tips and tricks. Information, developer related The ultimate guide to the datetime datatypes Cross-reference between ANSI and SQL Server datatypes Cross-reference between ANSI and SQL Server functions Generate DDL scripts Information, administration related Why you want to be restrictive with shrink of database files Recommended actions for corrupt or suspect databases Minimizing data loss when accidents happens Changing the name of a SQL Server machine BACKUP using NO_TRUNCATE and RESTORE Utilities Agent Alerts Management Pack Recently updated: sp_db_space_usage - database space usage information Recently updated: 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