PASS Data Community Summit Courses

JSON for the Data Mortals

Explore JSON in databases: learn its origins, investigate, manipulate, and validate JSON data using Microsoft SQL Server tools and example code.

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

How to Deploy SQL Server Containers on Kubernetes in Azure

Explore deploying SQL Server containers on Azure Kubernetes Service. Learn container creation, SQL Server deployment, and automation techniques for scalable and highly available database management.

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

Amazon Aurora - Design for High Throughput Cloud-Native Relational DBs

Explore Amazon Aurora's innovative architecture for high-throughput cloud databases, focusing on network optimization, fast recovery, and fault tolerance without distributed consensus algorithms.

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

Complete CI - CD for C# and SQL

Practical demonstration on automating CI/CD for C# applications and SQL databases, covering source control, build processes, and deployment strategies for different environments.

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

Upgrading SQL Server - Prepare for Success

Comprehensive guide to successful SQL Server upgrades, covering planning, version selection, migration strategies, and best practices to minimize downtime and user impact.

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

Microsoft Data Engineering Unplugged

Meet Microsoft's Data Engineering team, discuss SQL Server, Azure SQL, and data services. Gain insights into product development, engineering processes, and future plans. Engage directly with PMs in this interactive session.

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

Query Analysis Deep Dive - 13 Causes of a Slow Query

Comprehensive exploration of 13 common query performance issues, providing practical solutions and a checklist for optimizing slow SQL queries.

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

Delivering a Data Warehouse in the Cloud

Learn to evaluate, provision, and optimize Azure SQL Data Warehouse. Covers scalability, cost-effectiveness, data loading, performance improvement, and security best practices for cloud-based data warehousing.

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

Whacha Just Say? Talking Technology to Non Technical People

Strategies for effectively explaining technical concepts to non-technical audiences. Interactive session with audience participation to bridge the technological knowledge gap.

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

Azure Data Studio - The New Frontier

Explore Azure Data Studio's features for managing data platforms, including dashboards, snippets, profiling, charting, and more. Learn when to use it over SQL Server Management Studio.

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

Relational Data Modeling Trends for Transactional Applications

Explore modern data modeling trends for transactional applications, addressing challenges in NoSQL, microservices, and cloud environments. Learn to adapt traditional principles to meet current business demands and facilitate rapid changes.

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

Spatial Analysis with SQL Server, R and Power BI

Discover the power of spatial analysis using SQL Server, R, and Power BI. Learn to analyze location-based data, make informed decisions, and create compelling visualizations for real-world applications.

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

Eliminating Anti-Patterns and RBAR for Faster Performance

Learn to boost SQL Server performance by identifying and fixing schema and code design issues, focusing on real-world examples and reproducible workloads to achieve faster query execution and better scalability.

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

An Azure Data Engineer's ETL Toolkit

Explore Azure's data movement and transformation options, comparing SSIS with Data Factory, Databricks, and Logic Apps. Learn ETL patterns and Data Flow features for scalable cloud migration.

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

SQL Isn't for Analysis - Why Everyone Needs OLAP Data Models

Explore the power of middle-tier modeling and calculation layers in data analysis, challenging the traditional "storage and charts" approach with case studies and clear explanations of their value.

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