I started tweeting various single-words you could start an argument with the other day. I really liked this suggestion from @SQL_Kiwi:
@Kendra_Little One word ways to start an argument: always (or never)
— Paul White (@SQL_Kiwi) December 31, 2014
It got me thinking. What are the things that I would say you a DBA should always do or be ready for with SQL Server, unconditionally?
You should always:
- Know how much data it’s OK to lose and how long your databases can be offline
- Know who has the ability to drop a database in your production SQL Servers
- Monitor your production SQL Servers
- Use x64 architecture for production SQL Servers
- Be ready to back up or restore a database
- Have a plan if your SQL Server stops working (even if the plan is to turn off your cell phone)
- Document who’s next in line if you stop working (even if the person next in line is nobody)
- Remember to lock your workstation when you get up from your desk
As for the “nevers”, I’ll let you come up with that list.