Security, Compliance and SQL Server

Name : Security, Compliance and SQL Server Author : Andy Warren Webinar Date : 29-01-2014

Top 10 Security Checklist

  • Don't use default port of 1433
  • Rename the SA account
  • Regularly run vulnerability scan
  • Track security changes
  • Use roles and only grant what's needed
  • Use Windows Logins over SQL logins
  • Monthly review of Sysadmin's
  • Monthly review for orphaned and dead users/logins
  • Require encryption for credit cards, etc
  • Require encryption of all backup's (Secure with AD permissions?)

Posted in Databases, Databases with : Webinar, SQL Server