PASS Data Community Summit Courses

Migrating Oracle Workloads to Azure

A practical session on why lift-and-shift can suit Oracle workloads, with a demonstration of building and automating Oracle on Azure IaaS.

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

Polybase - It's What's for Dinner!

See how PolyBase scale-out groups handle node failures and affect query performance across multiple nodes.

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

The Cases of The Unexplained Memory Problems

Case-based troubleshooting of difficult, unexplained SQL Server memory usage problems.

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

Inclusive Presentation Design

Learn to format presentation materials and shape delivery so audiences with different abilities can see, hear, and understand the content.

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

Microsoft SQL Server Machine Learning Workloads on Red Hat Enterprise Linux and Red Hat OpenShift

Run data preprocessing, feature discovery, and model training inside SQL Server, then deploy the machine learning workloads in containers.

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

From Docker to Big Data Cluster - A New Era for SQL Server

Explore SQL Server 2019 in containers and Kubernetes, then create and use a Big Data Cluster with T-SQL and basic Python scripts.

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

Developer Best Practices in SQL Server

See how real-world T-SQL rewrites improve query performance while addressing sargability, SQL injection, and parameterization.

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

Statistics Techniques Can Fix Tough Performance Issues

See how filtered, computed-column, and manually created statistics can help SQL Server’s optimizer produce faster query plans.

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

How to Put DevOps Into Action for Your Databases

See how data professionals can use automated pipelines to move database changes from source control through testing and into production.

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

Giving Feedback - How to Effectively Communicate to Your Employees

Sample coaching conversations show managers how to prepare for tough feedback discussions and handle confrontation tactfully.

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

Modernize Your SQL Applications Recently Enhanced Version Azure SQL Managed Instance

Explore how Azure SQL Managed Instance combines managed-cloud operations with SQL Server compatibility, focusing on migration, networking, security, and recovery.

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

Moving Data with Azure Data Factory

Build native Azure Data Factory pipelines, move SSIS workloads to the cloud, and apply design patterns to execute and monitor pipelines and packages.

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

A Deep Dive into Execution Plans & How to Use Them

Learn to read SQL Server execution plans, interpret operator costs and statistics, and identify the steps that matter most for query performance.

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

Do You Feel the Need the Need for Speed in SQL Server Database?

A systematic SQL Server tuning workflow uses wait types and execution plans to pinpoint bottlenecks, then rewrites queries or selects better indexes.

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

Notebooks, PowerShell, and Excel Automation

Use Jupyter Notebooks with PowerShell and ImportExcel to automate recurring tasks and let users generate their own Excel workbooks.

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