[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 435
  • Last Modified:

MSSQL Security Maintenance Tasks

I have been asked to identify some best practice "post implementation" (i.e. DB servers in production) routine security maintenance and monitoring tasks that a good DBA should be performing on routine basis specific to MSSQL. I was thinking along the lines of ensuring latest patches applied, occasional vetting DB level accounts and permissions once per quarter, ensuring no config changes have been made outsid change cotnrol etc. Can you give some pointers on any self audits you do to routinely reverify the security configuration of your Databases, and how often you do such checks.
0
pma111
Asked:
pma111
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Here you go with a Security checklist..

http://www.sqlserverspace.com/Security_checklist.html

and this one to answer the topics discussed above
http://www.sqlserverspace.com/SecurityModel.html
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now