Top Ten Presentations #sqlsat79
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…
Mike’s Top 10 OPERATIONAL Mistakes TO AVOID: Helping keep your Sanity Intact
- Not Setting Min and Max Memory
- Not Planning to Scale
- Using your Server as a Workstation
- Improper Use of Traces
- Enabling Auto Shrink
- Allowing Data Files to Grow in 1 MB Increments
- Not Configuring SQLMail Alerts
- Not using a Domain Account for SQL Services
- Not Configuring SQLMail Alerts
- Not Testing Restores
- Not Allowing Instant File Initialization
- Plus Bonus Rules!
And my slide decks…
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.
Hey, great presentation. Great pace. Great tone. Great impromptu mix of personal experiences and overall 5 stars!