PASS Data Community Summit Courses

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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• Conference Talk

Data Modeling and Prototyping in Power BI Desktop

Explore rapid data modeling and prototyping using Power BI Desktop. Learn to connect, cleanse, and model data from various sources, creating quick reports for project approval without licensing costs.

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

Bringing Source Control to BI World

Discover how to implement source control in Business Intelligence environments, improving version management, tracking changes, and facilitating parallel development for databases, cubes, and reports.

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

Choosing Database Hardware for SQL Server 2019

Optimize SQL Server 2019 hardware selection for performance and cost-efficiency. Learn to evaluate workloads, choose processors, and navigate licensing changes to maximize database server capabilities.

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

Should I Move My Production SQL Server Workloads to Containers

Explore the pros and cons of containerizing SQL Server workloads, examining architectural differences, advantages, and challenges to help decide if containers are right for your production environment.

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

Two Truths That's A Lie - Data Visualization Ethics

Explore data visualization ethics, examining how color and chart choices influence storytelling. Learn to create truthful, impactful visualizations while protecting your company's reputation.

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

Innovative Data Modeling for Cool Data Warehouses

Explore agile data warehouse modeling techniques beyond traditional norms. Learn to build flexible, auditable solutions adaptable to various industries, leveraging MDM and Azure for enhanced performance and data integration.

• YouTube
• 2 hours 24 minutes
• On-Demand
• Conference Talk

Data Classification - Taking Your First Step on the Road to Agile Data Governance

Learn to build and maintain an evergreen catalog of your SQL Server estate, enabling agile data governance. Discover best practices for data classification, protecting sensitive information, and ensuring compliance with privacy regulations.

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