Events


Events

Upcoming Events

No events found


Past Events

28Oct2015

Enterprise Auditing with SQL Server Audit

Audit. The very word strikes fear in the bravest of hearts. But as a DBA, the need to know who is doing what in your production databases is critical. In SQL Server 2008, Microsoft finally gave us a true auditing tool. But how does it work, what exactly can it track, and how can you handle its output? In this session, we cover SQL Server Audit from the ground up. We go from the basics of which events can be audited to a look at how SQL Server Audit works "under the covers", and what that means for performance. While implementing server and database audits, we discuss audit granularity and filtering, as well as the pros and cons of Audit's output options. Whether it's through the SQL Server Management Studio (SSMS) interface, via T-SQL, or using PowerShell and Server Management Objects (SMO), at the end of this session you'll be able to deploy SQL Server Audit across your enterprise and manage its output, fearlessly.

From 1.30 pm until 2:45 pm

At PASS Summit 2015

Find out more...

24Oct2015

Enterprise Auditing with SQL Server Audit

Audit. The very word strikes fear in the bravest of hearts. But as a DBA, the need to know who is doing what in your production databases is critical. In SQL Server 2008, Microsoft finally gave us a true auditing tool. But how does it work, what exactly can it track, and how can you handle its output? In this session, we cover SQL Server Audit from the ground up. We go from the basics of which events can be audited to a look at how SQL Server Audit works "under the covers", and what that means for performance. While implementing server and database audits, we discuss audit granularity and filtering, as well as the pros and cons of Audit's output options. Whether it's through the SQL Server Management Studio (SSMS) interface, via T-SQL, or using PowerShell and Server Management Objects (SMO), at the end of this session you'll be able to deploy SQL Server Audit across your enterprise and manage its output, fearlessly.

At SQLSaturday #446 - Oregon 2015

Find out more...

10Oct2015

Enterprise Auditing with SQL Server Audit

Audit. The very word strikes fear in the bravest of hearts. But as a DBA, the need to know who is doing what in your production databases is critical. In SQL Server 2008, Microsoft finally gave us a true auditing tool. But how does it work, what exactly can it track, and how can you handle its output? In this session, we cover SQL Server Audit from the ground up. We go from the basics of which events can be audited to a look at how SQL Server Audit works "under the covers", and what that means for performance. While implementing server and database audits, we discuss audit granularity and filtering, as well as the pros and cons of Audit's output options. Whether it's through the SQL Server Management Studio (SSMS) interface, via T-SQL, or using PowerShell and Server Management Objects (SMO), at the end of this session you'll be able to deploy SQL Server Audit across your enterprise and manage its output, fearlessly.

At SQLSaturday #442 - Orlando 2015

Find out more...

13Aug2015

What changed? Auditing options in SQL Server 2014

When and how was this view changed? Where did that index go? Who's accessing my sensitive data? As a DBA, you'll face these and similar questions throughout your career. And if you don't have an audit in place, providing answers can be difficult. In this demo-rich session we'll examine auditing options in SQL Server 2014, including SQL Trace, event notifications, DDL and logon triggers, and SQL Server Audit. We'll begin by defining real-world requirements for an auditing solution, such as events to capture, data to collect, output destinations, and performance considerations. As we implement each tool, we'll discuss its unique benefits and limitations, and see how it stacks up against our specifications. By the end of this session, you'll have the knowledge you need to select and implement the auditing tool that's right for you.

At SQL PASS in Detroit (SPID) User Group

Find out more...

11Jul2015

What changed? Auditing options in SQL Server 2014

When and how was this view changed? Where did that index go? Who's accessing my sensitive data? As a DBA, you'll face these and similar questions throughout your career. And if you don't have an audit in place, providing answers can be difficult. In this demo-rich session we'll examine auditing options in SQL Server 2014, including SQL Trace, event notifications, DDL and logon triggers, and SQL Server Audit. We'll begin by defining real-world requirements for an auditing solution, such as events to capture, data to collect, output destinations, and performance considerations. As we implement each tool, we'll discuss its unique benefits and limitations, and see how it stacks up against our specifications. By the end of this session, you'll have the knowledge you need to select and implement the auditing tool that's right for you.

At SQLSaturday #421 Columbus 2015

Find out more...

16May2015

Enterprise-level auditing on a Standard Edition budget

In SQL Server 2008, Microsoft finally introduced a first-class auditing tool for monitoring what's going on in your databases. Unfortunately, that's an Enterprise Edition feature. What about those of us running Standard Edition? In this demo-heavy session, we'll learn about auditing methods for the masses, including triggers, event notifications, SQL Trace, extended events, and even SQL Audit.

At SQLSaturday #383 Rochester 2015

Find out more...

07Feb2015

Enterprise-level Auditing on a Standard Edition Budget

In SQL Server 2008, Microsoft finally introduced a first-class auditing tool for monitoring what's going on in your databases. Unfortunately, that's an Enterprise Edition feature. What about those of us running Standard Edition? In this demo-heavy session, we'll learn about auditing methods for the masses, including triggers, event notifications, SQL Trace, and extended events.

From 8:30 am until 9:30 am

At SQLSaturday #357 Cleveland 2015

Find out more...

06Nov2014

SQL Audit: From Introduction to Automation

From 5:00 pm until 6:15 pm

At Seattle, Washington

Find out more...

21Jun2014

SQLSaturday #303 - Rochester 2014

SQL Audit - auditing doesn't have to be boring

At 1 Lomb Memorial Drive, Rochester Institute of Technology (CIMS Building #78), Rochester, NY, 14623

Find out more...

14Jun2014

SQLSaturday #299 - Columbus 2014

SQL Audit - auditing doesn't have to be boring

At Ohio Dominican University 1215 Sunbury Road, Bishop James A Griffin Student Center Building 17, Columbus OH

Find out more...

17May2014

SQLSaturday #292 - Detroit 2014

SQL Audit - auditing doesn't have to be boring

At Lawrence Technological University, 21000 West Ten Mile Road, Southfield, MI, 48075-1058

Find out more...

26Apr2014

SQLSaturday #291 - Chicago 2014

SQL Audit - auditing doesn't have to be boring

At 1221 N Swift Road, Addison, IL, 60101

Find out more...

Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>