Learn more about SQL Server tools

 

Tutorials          DBA          Dev          BI          Career          Categories          Events          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Events

DBA    Dev    BI    Categories

 

Top 5 Items to Audit in SQL Server

Sponsored by - IDERA

Whitepaper Abstract

SQL Server provides robust capabilities to monitor itself and it can be easy to be overwhelmed with the choices presented through catalog/dynamic management views, extended events, server side traces (for older versions of SQL Server), or performance counters. This is true on the security side as well. In this whitepaper we’ll present the top five items you should be auditing on all of your SQL Servers, and how to do them. Keeping an eye on these items will help you verify database security and access in your environment.

They are:
  1. Who has administrative access to SQL Server?
  2. Who has been granted CONTROL and IMPERSONATE permissions?
  3. Who are the database owners?
  4. What are the respective database permissions?
  5. What failed logins are you getting on your SQL Servers?


Format: PDF

To access materials please fill out the form below.



































By submitting this data you are accepting to receive newsletters, account updates and special offers about SQL Server from MSSQLTips and our sponsors. We respect your privacy and you can unsubscribe at any time.






Learn more about SQL Server tools