What Changed? SQL Server 2014 Auditing Options Archives

About the Presentation

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 SQL Server 2014 auditing options, 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.

Session Level: Intermediate

Download the Presentation

[iframe id=’powf_96659D7F994EE61180E9C4346BDC4261′ src=’https://pocloudcentral.crm.powerobjects.net/powerwebform/powerwebform.aspx?t=vGKc9HDSM0KIvgkegLCU53UAcABzAGUAYQByAGMAaAA%3D&formId=powf_96659D7F994EE61180E9C4346BDC4261&tver=2013′ frameborder=’0′ width=’100%’ height=’360′]

Presentations (Upcoming & Past)

SQLSaturday #421 – Columbus, OH – July 11, 2015

About the Author

Colleen Morrow

UpSearch Alum Colleen Morrow is a database strategist, community advocate, author, blogger and public speaker. She is passionate about helping technology leaders use Microsoft's SQL Server to protect, optimize and unlock data's value.

Colleen has been working with relational databases for almost 20 years. Since 2000, Colleen has specialized in SQL Server and Oracle database management solutions. She excels at performance tuning, troubleshooting mission critical SQL Server environments, and training technology professionals and business users of all levels.

Since 2011, Colleen has maintained a SQL Server focused blog at http://colleenmorrow.com. She is an active member of the Ohio North SQL Server User Group, as well as a volunteer for the Professional Association for SQL Server (PASS). Colleen earned a Bachelor of Science in Computer and Information Systems from Cleveland State University.

Learn more about Colleen Morrow at https://upsearch.com/colleen-morrow/.

SQL Server Health Check Series

This blog series will help you decide if UpSearch’s <a style=”color: #0000ff;” href=”https://upsearch.com/microsoft-sql-server-health-check/” target=”_blank”>SQL Server Health Check</a> is right for your organization. Follow the links below to learn how you can use our assessment to identify and resolve SQL Server problems.

<ol>
<li><a style=”color: #0000ff;” href=”https://upsearch.com/sql-server-health-check-introduction/” target=”_blank”>SQL Server Health Check Introduction</a></li>
<li><a style=”color: #0000ff;” href=”https://upsearch.com/sql-server-health-check-benefits/” target=”_blank”>SQL Server Health Check Benefits</a></li>
<li><a style=”color: #0000ff;” href=”https://upsearch.com/sql-server-health-check-step-1-collect-metrics/” target=”_blank”>SQL Server Health Check Process – Step 1</a></li>
<li><a style=”color: #0000ff;” href=”https://upsearch.com/sql-server-health-check-step-2-analyze-results/” target=”_blank”>SQL Server Health Check Process – Step 2</a></li>
<li><a style=”color: #0000ff;” href=”https://upsearch.com/sql-server-health-check-step-3-report-findings/” target=”_blank”>SQL Server Health Check Process – Step 3</a></li>

</ol>

Posts