Browse by Tags

Tagged Content List
  • Blog Post: SQL 2012 Security Audit 3 (Predicate and Failure)

    This is the script to bring it all together. In this case I have opted for just a server side specification with a filter on the database and exclusion of system objects. You can certainly leave the access to system objects, however it will generate a significant number of audit entries. I encourage...
  • Blog Post: SQL 2012 Security Audit 2 (Database Audit)

    After mastering SQL Server Audit creation the next item is the database audit. As the name indicates, the Database Audit is Database scoped, so it will focus to the database level actions. This can be useful if you have a single database on the server, or perhaps even a single schema or even table...
  • Blog Post: SQL 2012 Security Audit 1

    While the SQL Server audit is not difficult to setup, I am still seeing many folks use and ask about SQL server side trace to address their auditing needs. Though the SQL Server Audit is a bit confusing the first time or two you set it up it is vastly more flexible and much easier to get the data out...
Page 1 of 1 (3 items)