Course info

Rating

(23)

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

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.

Section Introduction Transcripts

Course OverviewHey 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.