Today is SQL Saturday 79 in South Florida! I have two “Top Ten” presentations I’m giving.

Here are my bullet points. And the slide deck is attached below.

Mike’s Top Ten Rules for Managing a Production Environment: Best practices that will keep you sane

• Developers don’t touch production. Ever.
• Limit Access to SA and Service Account Passwords
• Services run as a domain user
• Plan for when things go bump in the night
• Access is Controlled via Active Directory Groups
• Triggers don’t send mail. Ever.
• Database servers are that and that alone.
• Look at things through the eyes of an auditor
• Test Restores. Frequently.
• Optimize for OLTP and not Reporting
• Plus Bonus Rules…