PASS Data Community Summit Courses

Using Open Source Software to Collect Performance Metrics

Learn to set up an inexpensive system using Telegraf, InfluxDB, and Grafana to collect and visualize SQL Server performance metrics, aiding in troubleshooting and capacity planning.

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

On-Premises Power BI and Reporting - Reporting Services 2019

Explore on-premises Power BI reporting with PBIRS: installation, configuration, report development, and management through the portal. Learn tips for leveraging on-premises features effectively.

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

Azure Storage Options for Analytics

Explore Azure storage options for analytics, including data lakes and databases. Learn best practices, structures, and appropriate choices for different scenarios to build effective data ecosystems.

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

10 Cool Things You Can Do With Azure Databricks

Discover 10 practical Azure Databricks applications through live demos, including VS Code integration, streaming with Event Hub, and Delta time travel, enhancing your data engineering skills.

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

Privacy and Security by Design in a Cloud Environment

Learn security and privacy design principles for cloud architectures, with practical implementation examples and best practices for integrating these crucial aspects into your solutions.

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

Azure SQL Database - Maximizing Cloud Performance and Availability

Optimize Azure SQL Database performance and availability for mission-critical applications. Learn best practices, configuration tips, and troubleshooting techniques to maximize cloud resources and achieve 99.995% uptime.

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

Improving Database Code Quality with Unit Tests

Learn to implement unit testing for T-SQL code, enhancing database quality. Discover tools and techniques for automated testing, test-driven design, and integrating tests into your development workflow.

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

Design Strategies and Advanced Data Visualization

Advanced techniques for effective data visualization, including accessibility design, data storytelling, and creating impactful reports and dashboards for diverse audiences.

• YouTube
• 1 hour 15 minutes
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• Conference Talk