What Changed? SQL Server 2014 Auditing Options
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)
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/.
About UpSearch
UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.
