Practical SQL Server Security, Compliance, and Auditing

This course is a practical approach to leveraging SQL Server to meet the needs of your industry compliance, audit, security, and encryption standards.
Course info
Rating
(29)
Level
Intermediate
Updated
Jan 6, 2017
Duration
3h 40m
Table of contents
Course Overview
Understanding Regulatory Compliance
Implementing Security with Users, Groups, and Roles
Modeling Schemas to Support Security Best Practices
Protecting Sensitive Data With Encryption
Protecting Sensitive Data in Transit
Setting up Compliance Enforcement, Monitoring, and Logging
Watching the Watcher with SQL Audit
Passing Audits with Compliance Reports and Documentation
Description
Course info
Rating
(29)
Level
Intermediate
Updated
Jan 6, 2017
Duration
3h 40m
Description

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.

About the author
About the author

Currently an IT leader in Denver Colorado's financial sector Russ has focused on database development, modelling, administration, and BI since 1997 across the Microsoft stack. Russ is a passionate trainer and SQL community volunteer presenting regularly at PASS SQL Saturday events and local user groups around the US.

More from the author
More courses by Russ Thomas
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hey Pluralsighters, this is Russ Thomas. Out on Twitter I am @sqljudo. Welcome to this course, Practical SQL Server Security, Compliance, and Auditing. So from that title you might be asking yourself is this a course about implementing encryption, security, and doing things like backups, or is this a course about passing compliance audits, such as those that might be related to HIPAA, or PCI, or any number of standards that are related to most, well, and actually probably all industries that any of us are in. The answer to that is a whole lot of both. We're going to cover topics like how to use the auditing features that are found within SQL Server, how to establish good sound encryption including capabilities that are new to SQL Server such as the 2016 release of the always encrypted approach, how SQL server manages the different principles, and groups, and logical organizations of objects within a database instance, and we're also going to cover a lot about how to show that you are doing these up to a professional standard during an audit process. So now matter what standard you have to comply with or what your role is in database administration or SQL Server security, I can guarantee that there is some valuable information in this course for you.