PASS Data Community Summit Courses

Design Your Data Vault and Load It With Azure Data Factory

Explore Data Vault methodology for data warehouse design and learn how to populate it using Azure Data Factory's Mapping Data Flows, with insights on ETL patterns and practical implementation.

• YouTube
• 1 hour
• On-Demand
• Conference Talk

Advanced Development Pipelines

Explore multi-threaded builds, database dependencies, container-based agents, and environment automation for advanced development pipelines in this comprehensive session.

• YouTube
• 1 hour 4 minutes
• On-Demand
• Conference Talk

App Modernization and Migration from End to End

Comprehensive guide to app modernization and data migration using Microsoft tools, focusing on SSIS to ADF and SQL Server to Azure SQL MI transitions with practical demonstrations.

• YouTube
• 58 minutes
• On-Demand
• Conference Talk

Deploying and Managing SQL Server with dbatools

Automate SQL Server deployment and management using dbatools PowerShell module. Learn installation, configuration, and operations techniques for efficient multi-system administration.

• YouTube
• 1 hour 15 minutes
• On-Demand
• Conference Talk

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

Optimize SQL Server licensing costs with expert guidance on editions, models, and scenarios for virtual environments, high availability, and non-production setups.

• YouTube
• 58 minutes
• On-Demand
• Conference Talk

ORMs and the DBA - How to Keep Both Happy

Explore strategies to mitigate ORM-related issues, improve performance, and satisfy both developers and DBAs. Learn to audit SQL, optimize code, and use tools for better ORM implementation.

• YouTube
• 38 minutes
• On-Demand
• Conference Talk

Big Data Clusters First Birthday

Celebrating SQL Server Big Data Clusters' first year, showcasing enhancements, and previewing future developments for accelerating data engineering and science projects.

• YouTube
• 54 minutes
• On-Demand
• Conference Talk

Execution Plans - Where Do I Start?

Learn to read and understand SQL Server execution plans, crucial for optimizing query performance and troubleshooting slow queries. Discover how to obtain plans and interpret them effectively.

• YouTube
• 1 hour 15 minutes
• On-Demand
• Conference Talk

PowerShell for DBA Beginners

Learn to automate SQL deployments and upgrades using PowerShell, starting with basics and progressing to multi-server scripts using JSON files.

• YouTube
• 1 hour
• On-Demand
• Conference Talk

Enable Real-time Analytics and Machine Learning with Azure Stream

Explore Azure Stream Analytics for real-time data processing, integrating with Power BI dashboards and Azure ML. Learn to build streaming jobs and implement lambda architecture for data-driven insights.

• YouTube
• 56 minutes
• On-Demand
• Conference Talk

Power BI CI - CD with Tabular Editor

Automate Power BI Dataset and Analysis Services Tabular model development using Tabular Editor, GIT, and Azure DevOps. Learn to implement continuous integration and delivery for efficient BI solution management.

• YouTube
• 1 hour 1 minute
• On-Demand
• Conference Talk

10 Cloudy Questions to Ask Before Migrating Your SQL Server

Explore key considerations for migrating SQL Server to the cloud, including service selection, availability requirements, dependencies, and migration strategies to ensure a successful transition.

• YouTube
• 1 hour 6 minutes
• On-Demand
• Conference Talk

Best Practices for Creating Stunning R Visuals in Power BI

Learn to create stunning data visualizations in Power BI using R programming, enhancing your data storytelling capabilities with the grammar of graphics concept and best practices for R visuals.

• YouTube
• 1 hour 12 minutes
• On-Demand
• Conference Talk

Extend SQL Applications to the Edge with Azure SQL Edge

Explore Azure SQL Edge's optimized database engine for IoT workloads, featuring data streaming, timeseries, and ML capabilities. Learn about customer implementations and new features for the Intelligent Edge.

• YouTube
• 48 minutes
• On-Demand
• Conference Talk

Power BI Time-Intelligence - Beyond the Basics

Explore advanced time-intelligence techniques in Power BI, including custom date tables, filter context manipulation, and complex DAX functions for sophisticated business analytics.

• YouTube
• 1 hour 3 minutes
• On-Demand
• Conference Talk