PASS Data Community Summit Courses

Improve Your Power BI Reports with DAX

Enhance Power BI reports with practical DAX formulas for conditional formatting, non-additive measures, top N analysis, and dynamic slicer descriptions. Hands-on examples provided for immediate application.

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

Taking Leadership to the Next Level - Mastering Your Own Growth

Develop a personalized system for continuous self-improvement as a leader, balancing technical and soft skills to achieve your goals and lead effectively in various situations.

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

Continuous Intelligence - What's This All About?

Explore Continuous Intelligence, combining Continuous Integration and Business Intelligence for flexible BI application deployment. Learn advantages, challenges, and implementation strategies for Analysis Services.

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

Azure SQL Database - Lessons Learned from the Trenches

Discover best practices, tips, and monitoring techniques for optimizing Azure SQL Database performance in production environments, based on real-world Microsoft CSS support cases and customer engagements.

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

Query Store In-Depth

Explore Query Store's capabilities, quirks, and real-world applications for troubleshooting performance issues in SQL Server, including updates for SQL Server 2019.

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

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