PASS Data Community Summit Courses

Emergency! Are You Ready for Disaster to Strike?

Practice database recovery with backups to prepare for datacenter disruptions, including ransomware, and maintain business continuity.

• YouTube
• 1 hour 23 minutes
• Self-Paced
• Conference Talk

Best Practices for Branching Database Code in Git

Compare branching models for database code and choose a strategy that fits a team’s size and release practices.

• YouTube
• 1 hour 11 minutes
• Self-Paced
• Conference Talk

SQL PowerShell 2019 - The Lingua Franca for the Data Platform

Use PowerShell’s object-based workflows and notebooks to move data across SQL Server, Azure SQL Database, Azure Data Studio, and Excel.

• YouTube
• 1 hour 10 minutes
• Self-Paced
• Conference Talk

The Evolution of the DBA in the Age of Cloud

Explore how cloud services, virtualization, and automation are changing the DBA role and what data professionals can do to adapt.

• YouTube
• 1 hour 4 minutes
• Self-Paced
• Conference Talk

Encrypting Data Within SQL Server

Compare SQL Server’s encryption options and their performance effects, with a practical deep dive into configuring Always Encrypted and auditing sensitive data use.

• YouTube
• 1 hour 14 minutes
• Self-Paced
• Conference Talk

Start off the Season with Azure Snowflake

See how Snowflake separates compute from storage so loading and query workloads can scale independently while sharing data without contention.

• YouTube
• 1 hour 19 minutes
• Self-Paced
• Conference Talk

Power BI CI - CD with Tabular Editor

Tabular Editor’s folder serialization helps teams avoid merge conflicts when developing Power BI data models together.

• YouTube
• 1 hour 1 minute
• Self-Paced
• Conference Talk

10 Cloudy Questions to Ask Before Migrating Your SQL Server

Ten questions about availability, database dependencies, service choices, and migration strategies help prepare a SQL Server move to the cloud.

• YouTube
• 1 hour 6 minutes
• Self-Paced
• Conference Talk

Best Practices for Creating Stunning R Visuals in Power BI

Explore how R’s grammar of graphics and design practices can create effective visuals inside Power BI.

• YouTube
• 1 hour 12 minutes
• Self-Paced
• Conference Talk

Extend SQL Applications to the Edge with Azure SQL Edge

Azure SQL Edge brings a compact SQL database engine to IoT deployments, with built-in data streaming, time-series, and machine-learning capabilities.

• YouTube
• 48 minutes
• Self-Paced
• Conference Talk

Power BI Time-Intelligence - Beyond the Basics

Learn how date tables and filter context unlock more flexible time-intelligence calculations than Power BI’s built-in functions.

• YouTube
• 1 hour 3 minutes
• Self-Paced
• Conference Talk

Real World Implications of Bias in Coding & Machine Learning

Explore how developers’ assumptions and lived experiences can shape code and exclude users, and learn ways to identify bias and design more inclusively.

• YouTube
• 45 minutes
• Self-Paced
• Conference Talk

Log Shipping in SQL Server

See how SQL Server log shipping supports high availability, disaster recovery, scalability, and migrations, from wizard setup to customized manual configuration.

• YouTube
• 1 hour 1 minute
• Self-Paced
• Conference Talk

A Beginner's Guide to Becoming a Performance Tuner

A survey of SQL Server practices that hurt performance, from server configuration mistakes to T-SQL parallelism and TempDB problems.

• YouTube
• 1 hour 22 minutes
• Self-Paced
• Conference Talk

Running Managed SQL Server on AWS

Explore how Amazon RDS manages SQL Server workloads, including the operational tradeoffs between RDS and self-managed SQL Server on EC2.

• YouTube
• 56 minutes
• Self-Paced
• Conference Talk