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

Head Geek

SolarWinds

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.

All other laptop requirements will be provided to attendees 2 weeks prior to the conference.