SQL Server Auditing and Compliance Tips
Administration
Administrators
Auditing
- SQL Server Database Security Audit (Part 1): What to expect?
- SQL Server Security Audit (Part 2): Scripts to help you or where can you find more information
Data
- Audit and Prevent Unwanted SQL Server Table Changes
- Auditing Failed SQL Server Transactions Using Table Variables
- Auditing SELECT statements in SQL Server 2008
- Designing Tables for Audit Data in SQL Server
- Prevent Confidential Data at the Application Layer from getting into SQL Server
- SQL Server 2008 Audit Change Group
- SQL Server 2008 Auditing Feature
- SQL Server 2008 TSQL Auditing Commands for SELECT statements
Databases
Import and Export
Logins
- Audit SQL Server Logins Using SQL Profiler
- Audit SQL Server Logins without filling up the Error Log
- Auditing Failed Logins in SQL Server
- Auditing Windows Groups from SQL Server
- Automate collection and saving of failed logins for SQL Server
- How to Audit Login Changes on a SQL Server
- Tables and Views for Auditing SQL Server Logins
- Use Extended Events to Get More Information About Failed SQL Server Login Attempts
Overview
Passwords
- Auditing SQL Server Password Age
- How do I enforce SQL Server 2000 password changes?
- Password management options for the SQL Server sa login
- SQL Server Login Properties to Enforce Password Policies and Expiration
Permissions
- Auditing SQL Server 2012 Server Roles
- Auditing SQL Server Permissions and Roles for the Server
- Auditing SQL Server User and Role Permissions for Databases
- Auditing sysadmin on multiple servers using PowerShell
- Auditing your SQL Server database and server permissions
- How to find out what SQL Server rights have been granted to the Public role
- Identify Orphaned Windows Logins and Groups in SQL Server with sp_validatelogins
- Identifying What Runs at Startup on SQL Server
- SQL Server Login Management using LOGINPROPERTY function
- SQL Server Security Auditing to Match Logins And Users
- What Windows Server Groups Should I Audit on my SQL Servers?
Regulations
Reporting
- Script to auto generate a security report for your SQL Server instance
- SQL Server Security Audit Report
- Using a Backup to Find SQL Server Security Changes
Security
Tools