SQL documentation tools and permissions required

Database documentation tools like Devarts’ dbDocumenter will require, at a minimum, VIEW DEFINITION rights to the login:

Views – 528

Random SQL tips and best practices

Kevin Kline posted on wait states here with some valuable insight: TROUBLESHOOTING SQL SERVER WAIT STATS A number of these are from Adam…

Configuring SQL Database Mail

Here is a sample script for configuring database mail in the event you want to automate your SQL installs.