PASS Data Community Summit Courses

Database CICD - Continuous Integration and Deployment

Learn to automate database operations and deployments for efficient management of hundreds of databases, meeting industry demands for faster, streamlined processes.

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

Azure SQL Database Edge - Overview

Explore Azure SQL Database Edge: optimized for edge computing with streaming support, machine learning, and "develop once, deploy anywhere" capabilities. Learn about features, deployments, and customer scenarios.

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

Help Me SSIS Logging, You're My Only Hope!

Discover effective SSIS logging techniques to troubleshoot errors, tackle inefficiencies, and identify data flow issues. Learn about built-in options and custom logging implementation for comprehensive package monitoring.

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

Managing and Monitoring SQL Server on Linux from the Command Line

Explore command-line tools for managing SQL Server on Linux, including installation, configuration, and monitoring. Learn to leverage bash for querying DMVs and gain insights for seasoned command-line users.

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

An Introduction to Data Visualizations and Design Best Practices

Learn effective data visualization techniques, including chart selection, color theory, and design principles to enhance your data storytelling skills and create impactful Power BI reports.

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

Azure SQL Database Serverless - Compute Autoscaling Solution to Optimize Database Performance and Cost

Learn about Azure SQL Database Serverless, an autoscaling compute tier that optimizes costs and performance for databases with unpredictable usage, automatically scaling and pausing based on demand.

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

Choosing Your Cloud - Step 2 in Your Cloud Migration Journey

Explore cloud vendor strengths, migration tools, and service mapping for OLTP and BI-stack migrations. Learn to evaluate single-vendor benefits and challenges for informed cloud platform selection.

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

Working with SQL Server Containers to Build Database Solutions

Explore efficient SQL Server solution deployment using containers, covering basic and advanced methods, real-world scenarios, and cross-platform portability for streamlined database management.

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

Aggregations in Power BI

Explore high-performance data analysis using Power BI Aggregations. Compare with Analysis Services, learn implementation strategies, and understand architectural approaches for optimized analytical solutions.

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

Never Lose Data - Digging Out From Corruption

Learn essential recovery techniques to prepare for, detect, and repair various corruption-based problems in databases, ensuring data integrity and minimizing disruptions in your enterprise.

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

Batch Execution Mode on Rowstore Indexes

Explore SQL Server 2019's Batch Execution Mode for Rowstore Indexes, its benefits, challenges, and optimal usage scenarios to significantly enhance workload performance.

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

AI Cognitive Services - Vision 101

Introduction to Azure's Computer Vision and Custom Vision APIs, covering basics, model creation, training, and implementation using Python in Azure Notebooks.

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

Microsoft Power BI - Business Intelligence Strategy, Vision, and Roadmap Update

Explore Microsoft's BI strategy and roadmap with Power BI leadership. See demos of latest enterprise features and learn how to leverage data for organizational success.

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

Different Types of Many-to-Many Relationships in Power BI

Explore various many-to-many relationships in Power BI, including classical, simple, and filter propagation. Learn when and how to use different types with practical examples and understand their impact on data modeling.

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

AI for the BI Professional

Explore AI integration in BI solutions for enhanced data insights. Learn to use pre-built AI tools, consume data scientist models, and leverage Power BI's AI features for intelligent reporting.

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