PASS Data Community Summit Courses

What's Going On in My Power BI Environment?

Discover effective methods for monitoring and managing your Power BI environment, including usage tracking, license management, and data collection automation using Azure and PowerShell.

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

Data Engineering Brick-by-Brick - An Intro To Azure Databricks

Explore Azure Databricks for cloud-based big data analytics. Learn cluster setup, collaborative notebooks, and machine learning integration. Discover its role in modern cloud data warehousing.

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

Database Administration Through the Ages

Explore modern DBA roles across platforms, leveraging existing skills for maintenance, monitoring, and disaster recovery on Windows, Linux, Azure SQL DB, and containers. Future-proof your career in database administration.

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

Normalization Beyond Third Normal Form

Explore higher Normal Forms in database design, debunking myths and enhancing your skills. Learn to identify, check, and understand the consequences of violations for improved database architecture.

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

Let Me Automate You - Take Power BI To The Next Level

Discover advanced Power BI automation techniques using CLI, PowerShell, and C#. Learn to streamline administration tasks, implement continuous integration, and create artifacts automatically.

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

The Right Tool for the Right Job - Serving Data From SQL Server

Strategies for efficient data retrieval from SQL Server, comparing methods like stored procedures and ORMs. Includes implementation examples in .NET and tips for performance tuning and database structuring.

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

Building a Highly-Available, Scalable Application with Amazon Aurora

Learn to build high-performance applications using Amazon Aurora, a MySQL- and PostgreSQL-compatible database. Explore scalability, high availability, disaster recovery, and global replication for open source databases on AWS.

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

Monitoring and Tuning Your Database as a Service Performance

Learn strategies for monitoring and optimizing database performance in cloud-based "as-a-service" environments, exploring built-in tools and purpose-built solutions to ensure optimal database health and query efficiency.

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

Diversity, Belonging, & Allyship - Essential DBA Skills for the Data Professional

Explore essential non-technical skills for data professionals: embracing diversity, fostering belonging, and practicing allyship. Learn techniques to cultivate inclusive cultures and become a better ally in the tech industry.

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

Splitting Up Your Work in Chunks

Techniques for efficient data processing through chunking: balancing set-based operations and loops, improving performance, handling application impact, and managing interrupted operations.

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

SQL Server Business Intelligence on Amazon RDS

Explore SQL Server Integration Services, Analysis Services, and Reporting Services on Amazon RDS. Learn cost-saving strategies, configuration, security, and reliability for Microsoft BI toolkit on cloud infrastructure.

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

Comparing Predictive Models from R, Python, SSAS, and Azure ML

Explore techniques for evaluating and comparing predictive models across R, Python, SSAS, and Azure ML, with insights on integrating diverse tools for optimal data mining results.

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

Back Up and Restore a SQL Server Database If You're Not a DBA

Learn essential database backup and restore techniques, including data files, recovery models, and automation, to safeguard your SQL Server data and prevent job-loss scenarios during disasters.

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

SQL Server Migration - The Last Mile

Explore post-migration steps for SQL Server upgrades, focusing on data accuracy, query performance, and leveraging new optimization features to minimize risks and improve workload efficiency.

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

AI for the DBA

Explore the AI ecosystem for DBAs, covering basics, support skills, and in-depth understanding to thrive in AI. Learn about architecture and operationalizing models using Azure ML Server.

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