Whitepaper : SQL Server Security Practices
Introduction:
Security is a core area for database management and non-negotiable when it comes to mission critical applications. With every release of SQL Server, there are tons of additions that get added as part of the platform. In this whitepaper, we will review common security practices for implementing security measures within a SQL Server deployment and outlines the security features introduced with SQL Server 2014, including:
•Auditing logins
•Sysadmin privileges
•Database permissions
Topics :
Products :
Introduction:
Security is a core area for database management and non-negotiable when it comes to mission critical applications. With every release of SQL Server, there are tons of additions that get added as part of the platform. In this whitepaper, we will review common security practices for implementing security measures within a SQL Server deployment and outlines the security features introduced with SQL Server 2014, including:
•Auditing logins
•Sysadmin privileges
•Database permissions
Topics :
Products :
Pinal Dave
Pinal Dave is a Developer Evangelist. He has authored 11 SQL Server database books, 14 Pluralsight courses and over 2900 articles on the database technology on his blog at http://blog.sqlauthority.com. Along with 10+ years of hands-on experience, he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). His past work experiences include Technology Evangelist at Microsoft and Sr. Consultant at SolidQ.
Monitor, audit and alert on SQL Server changes
- Audit sensitive data to see who did what, when, where, and how
- Monitor and alert on suspicious activity to detect and track problems
- Satisfy audits for multiple industry regulatory requirements
- Select from over 25 pre-defined compliance reports and create custom views
- Lightweight data collection agent minimizes server impact