Rules to Better SQL Databases - Admin

• ​DBAs - Do you measure Up-Time?
• DBAs - Do you check your SQL Server is up-to-date?
• ​DBAs - Do you design for database change?
• ​DBAs - Do you script out all changes?
• ​DBAs - Do you configure all your SQL Server Services to use a Domain Account rather than a local service account?
• ​DBAs - Do you name your SQL Server Domain Account as 'SQLServerMachineName' so it is easily identified when performing network operations?
• ​DBAs - Do you run SQL Server Services under non-Administrator accounts?
• DBAs - Do you use Database Mail (not SQL Mail)?
• DBAs - Do you turn on all the default alerts?
• DBAs - Do you create your own alerts?
• Backup - Do you set up a complete Maintenance Plan?
• Backup - Do you back up scripts?
• Backup - Do you take Restoration seriously?
• Backup - Do you have a Restoration Standard?
• DBAs - Do you know all the log files?
• DBAs - Do you secure your server by changing the 'defaults'?
• DBAs - Do you turn on security auditing?
• DBAs - Do you increase the Log Size of your Event Viewer?
• DBAs - Do you remove unnecessary permissions on databases?
• DBAs - Do you use Performance Alerts?
• DBAs - Do you make sure you use a consistent Collation server-wide?
• DBAs - Do you avoid collation errors?
• DBAs - Do you create new databases in the default data directory?
• DBAs - Do you know the compatibility issues between SQL Server 2000 and 2005?
• Performance Tuning - Do you make sure to clear SQL server cache when performing benchmark tests?