SQL Server Features Components, Full Day HandsOn Labs

SQM01 Hands-On Lab: Advanced SQL Data Security and Privacy

11/15/2021

9:00am - 6:00pm

Level: Intermediate to Advanced

Thomas LaRock

Principal Developer Evangelist

Selector Software

Karen Lopez

Data Evangelist, Space Enthusiast, & NASA Datanaut

Modern database systems have introduced more support for security, privacy, and compliance over the last few years. We expect this to increase as compliance issues such as GDPR and other data compliance challenges arise.

In this advanced workshop, we cover data security and privacy protection for SQL Server and Azure SQL Database. With demonstrations and several exercises, this workshop uses group labs to cover database and data protection techniques, including threat analysis and remediation. We'll look at the new features, why you should consider them, where they work, and where they don't.

Discussion topics will include:

  • Data Categorization and Classification
  • Encryption; Transparent Data Encryption, Always Encrypted
  • Data Masking
  • Row-level Security
  • Security Center and Scores
  • SQL Assessment API
  • Azure Defender for SQL
  • Vulnerability Assessments
  • Advanced Threats
    • SQL Injection
    • Data Exfiltration
    • Information Protection
    • Anomalous Login attempts
  • Monitoring and Alerting with Azure Services
  • Azure Data Explorer

Attendees will leave this session with an understanding of the following:

  • How to find and assess data assets, using modern tools and techniques
  • How to identify and tag sensitive data
  • How to perform cost, benefit, and risk analysis on threats and solutions
  • How to deploy features in the right location to best protect data
  • How to leverage security services to protect data
  • The day will include lecture style format as well as interactive discussions and lab exercises.

You will learn:

  • How to find and assess data assets
  • How to perform cost, benefit, and risk analysis on threats and solutions
  • How to deploy features in the right location to best protect data

Attendee Laptop Requirements:

You must provide your own computer (Windows or Mac) for this hands-on lab workshop.

You will need to bring a laptop or device which allows you the ability to connect to, and work with, Microsoft Azure VMs

Complete LAB Zero BEFORE you arrive

Review this list and follow the instructions to test your laptop as soon as you are able