Nearly every professional industry must adhere to some form of professional standard, regulation, or legislative requirement. While requirements vary, many of the approaches and methods you as the technical administrator will employ can be standardized across many tools available within SQL Server. In this course, Practical SQL Server Security, Compliance, and Auditing, you’ll learn the most relevant features including new ones such as Always Encrypted released with SQL 2016. First, you’ll discover how to use auditing features that are found within SQL Server. Next, you’ll explore how to establish good sound encryption including capabilities that are new to SQL Server such as the 2016 release. Finally, you’ll learn how SQL Server manages the different principles in groups and logical organizations of objects within a database instance. By the end of this course, you’ll learn valuable security and auditing information in SQL Server.
Author Name: Russ Thomas
Author Description:
Currently an IT leader in Denver Colorado’s FinTech sector Russ has focused on database engineering, modelling, administration, and BI since 1997. Russ is a passionate trainer and community volunteer presenting regularly at tech events and local user groups around the US. In 2019 much of Russ’ focus turned to cloud based data lakes specifically on Google BigQuery, and the emerging world of large language models.

Table of Contents

• Course Overview
  1min
• Understanding Regulatory Compliance
  17mins
• Implementing Security with Users, Groups, and Roles
  34mins
• Modeling Schemas to Support Security Best Practices
  17mins
• Protecting Sensitive Data With Encryption
  32mins
• Protecting Sensitive Data in Transit
  26mins
• Setting up Compliance Enforcement, Monitoring, and Logging
  38mins
• Watching the Watcher with SQL Audit
  28mins
• Passing Audits with Compliance Reports and Documentation
  23mins