Posts

What Changed? SQL Server 2014 Auditing Options

 

About the Presentation

What Changed? SQL Server 2014 Auditing OptionsWhen 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

What Changed? SQL Server 2014 Auditing Options

Presentations (Upcoming & Past)

Want to Learn More About SQL Server Audit?

If you'd like to learn more about how UpSearch can support your SQL Server audit initiative, visit SQL Server Audit or contact us today.

About the Author

SQL Server Consultant

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

up-social-round

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.

Manage Both On-Prem and Azure Databases with SQL Server PowerShell

 

About the Presentation

Manage Both On-Prem and Azure Databases with SQL Server PowerShell

In today’s world, you’re more likely to have databases both on premises and in the cloud. Managing databases in different environments can make your life more complicated, but with the new PowerShell cmdlets introduced with SQL Server 2014, it actually becomes easier.

In this session, we’ll introduce you to the new cmdlets and show you how to manage your on-prem and Azure databases consistently.

Session Level: Intermediate

This session was presented at PASS Summit 2014.
Manage Both On-Prem and Azure Databases with SQL Server PowerShell

Download the Presentation

Manage Both On-Prem and Azure Databases with SQL Server PowerShell

Presentations (Upcoming & Past)

 

About the Author

Microsoft SQL Server MVP and Practice Leader

Allen White

Allen White is an UpSearch Alum and Microsoft SQL Server MVP.  For over 30 years, Allen has specialized in developing applications that manage the movement of data and maximize data's usefulness. Allen excels at communicating highly technical information using language that results in increased client engagement and understanding, regardless of technical competency.

Allen has been working with relational database systems for over 20 years. He has architected database solutions in application areas like retail point-of-sale (POS), POS audit, loss prevention, logistics, school district information management, purchasing and asset inventory and runtime analytics. Allen thrives on providing comprehensive solutions to information management problems across a great variety of application environments.

About UpSearch

up-social-round

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.