PASS Data Community Summit Courses

Understanding Accelerated Database Recovery

Explains how SQL Server’s Accelerated Database Recovery enables rapid recovery and near-instant transaction rollback through its Persistent Version Store.

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

The Art of Data Classification and Protection

Classify database data with SSMS, report the results, and audit who accesses the classified information.

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

Unlocking The Data Lake With Azure Synapse SQL Serverless

Use familiar T-SQL with Azure Synapse SQL serverless to explore and transform data in data lakes at scale.

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

Scaling a DWH Beyond the Petabyte

Plan and evolve a data warehouse from terabytes to multiple petabytes while avoiding wasted resources across on-premises and cloud infrastructure.

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

Design Your Data Vault and Load It With Azure Data Factory

See how Data Vault differs from other warehouse methodologies, then use Azure Data Factory Mapping Data Flows to populate a repository.

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

Advanced Development Pipelines

Build database release pipelines that coordinate .NET applications, dependent databases, containerized build agents, and environment automation.

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

App Modernization and Migration from End to End

A demo follows an end-to-end application migration and shows how SSIS and SQL Server workloads move to Azure services.

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

Deploying and Managing SQL Server with dbatools

Automate consistent deployment and configuration of multiple SQL Server instances with dbatools and PowerShell.

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

Pay Less, Get More - A Guide to SQL Server Licensing

Learn how edition choices, licensing models, and deployment scenarios affect the cost of licensing SQL Server.

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

ORMs and the DBA - How to Keep Both Happy

See how ORM behavior creates friction between developers and DBAs, and how inspecting generated SQL and changing application patterns can reduce performance problems.

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

Execution Plans - Where Do I Start?

Learn where to start when investigating a slow SQL Server query by obtaining and reading its execution plan.

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

PowerShell for DBA Beginners

A basic PowerShell script grows into a JSON-driven workflow for deploying SQL scripts across multiple servers and environments.

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

Enable Real-time Analytics and Machine Learning with Azure Stream

Build Azure streaming jobs that blend and aggregate incoming data for live Power BI dashboards, then combine stream and batch data with Azure ML.

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

Improving Database Code Quality with Unit Tests

Learn to unit test T-SQL database code, with demonstrations of testing database objects through test-driven design.

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

Data Modeling and Prototyping in Power BI Desktop

Use Power BI Desktop to quickly model data from multiple sources and build prototype reports that help secure project approval or funding.

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