PASS Data Community Summit Courses

Microsoft Power BI for the Data Engineer

Explore Power BI's capabilities for enterprise-grade insights, performance, governance, and security over massive datasets. Learn simplified data modeling and visualization techniques for actionable insights.

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

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

Transform Software Delivery with Test Data Management

Discover how Redgate's enhanced test data management tools can streamline your software delivery process, improving release quality, accelerating data provisioning, and ensuring data security.

• YouTube
• 48 minutes
• Self-Paced
• Free Video

Building Resilient Environments - Incorporating Security and Compliance into Database Monitoring

Discover essential strategies for database security and compliance monitoring, from vulnerability detection to access control implementation and audit processes for maintaining industry standards.

• YouTube
• 59 minutes
• Self-Paced
• Free Video

SQL Server Best Practices for SharePoint

Descubra as melhores práticas de configuração do SQL Server para otimizar o desempenho do SharePoint, maximizando a eficiência e o rendimento do seu ambiente de colaboração.

• YouTube
• 58 minutes
• Self-Paced
• Free Video