Monday, 5 November 2012

Microsoft SQL Server 2012 Security Cookbook


  • Start securing your database right from the first step when you install it
  • Protect your database against brute force attacks, denial-of-service attacks, and SQL Injection
  • Secure SQL Server Analysis Services (SSAS) and Reporting Services (SSRS)
  • Use a SQL or Web Application Firewall
  • Perform user authentication and authorization
  • Manage object ownership and protect data through views and stored procedures
  • Create and use certificates, and symmetric and asymmetric encryption keys
  • Authenticate stored procedures by signatures
  • Monitor SQL Server logs and use DML and DDL trigger for auditing
  • Configure SQL Server database audit and manage audit resilience after a crash

(Ref- )

No comments:

Post a Comment