Events for IT and Data Pros

04.24.2019 @ 11:00 AM - 12:00 PM CT

DBAs and Developers often work across multiple versions of SQL Server, both on premises and deployed on VMs which may be in the cloud. It is difficult to know every single configuration setting introduced in each version of SQL Server. To keep the behavior of SQL Server predictable, many of the newer settings are kept off or disabled. In this fast-paced demo-oriented session Pinal Dave will show three critical and several other important configuration settings, which once enabled instantly improve the performance of SQL Server. We will further explore these settings to understand how they work in the cloud and have a comprehensive understanding of the SQL Server's performance. By the end, you will understand how to enable a few important settings for SQL Server which can improve SQL Server performance by multifold.

Speaker: Pinal Dave is a Developer Evangelist and SQL Server performance expert. He has authored 11 SQL Server database books, 14 Pluralsight courses and over 2900 articles on the database technology on his blog at http://blog.sqlauthority.com. Along with 10+ years of hands-on experience, he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET).

05.15.2019 @ 11:00 AM CT - 12:00 PM CT

Increasing governmental and industry regulation coupled with the need for improving the security of sensitive corporate data has driven up the need to track who is accessing data in corporate databases. Organizations must be ever-vigilant to monitor data usage and protect it from unauthorized access.

Each regulation places different demands on what types of data access must be monitored and audited. Ensuring compliance can be difficult, especially when you need to comply with multiple regulations. And you need to be able to capture all relevant data access attempts while still maintaining the service levels for the performance and availability of your applications.

In this webinar, Craig Mullins will discuss these issues and present the requirements for auditing data access in relational databases. The goal of this presentation is to review the regulations impacting the need to audit at a high level, and then to discuss in detail the things that need to be audited, along with pros and cons of the various ways of accomplishing this.

Speaker: Craig Mullins is president and principal consultant of Mullins Consulting, Inc. where he focuses on data management strategy and consulting. He writes the monthly DBA Corner column for Database Trends & Applications magazine. With over three decades of experience in all facets of database systems development, he has worked as a programmer/analyst, a DBA, an industry analyst, a software executive and a consultant.