PASS Data Community Summit Courses

ORMs and the DBA - How to Keep Both Happy

Explore strategies to mitigate ORM-related issues, improve performance, and satisfy both developers and DBAs. Learn to audit SQL, optimize code, and use tools for better ORM implementation.

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

Big Data Clusters First Birthday

Celebrating SQL Server Big Data Clusters' first year, showcasing enhancements, and previewing future developments for accelerating data engineering and science projects.

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

Execution Plans - Where Do I Start?

Learn to read and understand SQL Server execution plans, crucial for optimizing query performance and troubleshooting slow queries. Discover how to obtain plans and interpret them effectively.

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

PowerShell for DBA Beginners

Learn to automate SQL deployments and upgrades using PowerShell, starting with basics and progressing to multi-server scripts using JSON files.

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

Enable Real-time Analytics and Machine Learning with Azure Stream

Explore Azure Stream Analytics for real-time data processing, integrating with Power BI dashboards and Azure ML. Learn to build streaming jobs and implement lambda architecture for data-driven insights.

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

Power BI CI - CD with Tabular Editor

Automate Power BI Dataset and Analysis Services Tabular model development using Tabular Editor, GIT, and Azure DevOps. Learn to implement continuous integration and delivery for efficient BI solution management.

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

10 Cloudy Questions to Ask Before Migrating Your SQL Server

Explore key considerations for migrating SQL Server to the cloud, including service selection, availability requirements, dependencies, and migration strategies to ensure a successful transition.

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

Best Practices for Creating Stunning R Visuals in Power BI

Learn to create stunning data visualizations in Power BI using R programming, enhancing your data storytelling capabilities with the grammar of graphics concept and best practices for R visuals.

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

Extend SQL Applications to the Edge with Azure SQL Edge

Explore Azure SQL Edge's optimized database engine for IoT workloads, featuring data streaming, timeseries, and ML capabilities. Learn about customer implementations and new features for the Intelligent Edge.

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

Power BI Time-Intelligence - Beyond the Basics

Explore advanced time-intelligence techniques in Power BI, including custom date tables, filter context manipulation, and complex DAX functions for sophisticated business analytics.

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

Real World Implications of Bias in Coding & Machine Learning

Explore how unconscious bias affects coding and machine learning, learn to identify and mitigate it, and discover inclusive design practices for creating more equitable and effective applications.

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

Log Shipping in SQL Server

Learn SQL Server log shipping for high availability and disaster recovery, covering fundamentals, use cases, configuration, and practical scenarios to enhance database management skills.

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

A Beginner's Guide to Becoming a Performance Tuner

Discover common SQL Server performance killers and learn essential tuning techniques for both DBAs and developers. Gain practical insights through demos on server configuration, T-SQL parallelism, and TempDB optimization.

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

Running Managed SQL Server on AWS

Explore Amazon RDS for SQL Server: automate administration, enhance availability, monitor performance, and scale effortlessly. Learn key features and differences from self-managed deployments on EC2.

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

Neurodiversity and the Data Platform

Explore neurodiversity in data platforms, focusing on autism spectrum disorders. Learn about strengths, challenges, and strategies for empowerment in the workplace and at conferences.

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