Back Home

SQL Server database administration in sunny Cleveland, OH

SQL Server database administration in sunny Cleveland, OH

Home » 2012 » July » 09

Daily Archives: July 9, 2012


SQL Audit 101 – Creating a basic audit

This entry was posted in Features and tagged Auditing SQL Audit SQL Server on July 9, 2012 by Colleen M. Morrow

SQL Audit was introduced in SQL 2008, and for the first time auditing was treated as a “first-class” object in SQL Server, meaning it could be managed by DDL statements.  It was built on the extended events framework and what made it really neat was that the event was recorded when the permission-check for that […]


Categories

  • BI (19)
  • Events (17)
  • Features (47)
  • General (32)
  • Internals (3)
  • Maintenance (21)
  • Non-SQL Stuff (7)
  • Powershell (9)
  • Professional Development (46)
  • Security (3)
  • SQL Tuning (7)
  • T-SQL (26)
  • Troubleshooting (16)
  • Uncategorized (4)

Recent Posts

  • SQL Server Service Broker – Security
  • Joining Fortified Data
  • SQL Server Service Broker – Networking
  • SQL Server Service Broker – Internal Activation
  • SQL Server Service Broker – Error Handling

Tags

#TSQL2sDay 70-463 a to z Auditing backup compression backups blogging certificates database maintenance data compression differential backup DMVs Event Notifications exam prep general dba goals high-availability index maintenance inventory linked servers memory mirroring Oracle page compression PASS performance powershell presenting professional development recovery Resource Governor scripts Service Broker slacking off snapshots SQL 2008 SQL Audit SQL Saturday SQL Server SSIS troubleshooting tsql update statistics WIT Women in Technology

· © 2023 ColleenMorrow.com · Designed by Themes & Co ·

Back to top