PASS Data Community Summit Courses

A Query Runs Through It - An Introduction to the SQL Server Engine

Explore SQL Server internals, from data types to query processing, enhancing your ability to write and optimize queries across various platforms. Gain valuable insights into the engine's inner workings.

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

Data Integrity Demystified

Explore data integrity fundamentals, from table design to constraints, and learn how database constructs enforce it. Understand its importance and implementation for meaningful, reliable data.

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

HA - DR in SQL Server - Putting the Puzzle Pieces Together and Planning for the Future

Comprehensive overview of SQL Server's HA/DR capabilities, exploring options across Linux and Windows, discussing tradeoffs, and introducing upcoming developments in disaster recovery and high availability.

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

Tabular Data Modeling Solutions for Challenging Problems

Explore creative solutions for complex data modeling challenges in Power BI, focusing on resolving ambiguous relationships and connecting multiple tables effectively.

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

Workarounds for T-SQL Restrictions and Limitations

Aprenda técnicas criativas para superar limitações do T-SQL, incluindo cálculos de mínimo/máximo entre colunas, números de linha únicos e reutilização de aliases, com o especialista Itzik Ben-Gan.

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

Azure Digital Twins in a Nutshell

Explore Azure Digital Twins: simulate, analyze, and control physical objects digitally. Learn key features, business benefits, and real-world applications through demonstrations and use cases.

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

Attention Contention

Explore tempdb contention in SQL Server, covering allocation and metadata issues, diagnosis, best practices, and prevention strategies for on-premises and Azure environments.

• YouTube
• 54 minutes
• On-Demand
• Conference Talk

SQL Server Big Data Clusters Architecture

Explore SQL Server 2019 Big Data Clusters architecture, including containers, Kubernetes, Spark, and HDFS. Learn to unify data sources, run big queries, and implement data preparation in an end-to-end scenario.

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

Find - So You Can Fix - Those Troublesome Queries

Explore tools and techniques to diagnose, troubleshoot, and optimize problematic SQL Server queries, enhancing database performance and efficiency.

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

Data Warehouse Automation Using Agile Methods

Explore agile data warehouse development using Data Vault design and metadata-driven automation for faster delivery, flexible architecture, and improved documentation in business intelligence projects.

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

SQL Server on Linux Performance

Explore SQL Server performance on Linux: configuration, monitoring tools, tuning techniques, and leveraging persistent memory for cost-effective optimization.

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

Deadlocks - Understanding and Troubleshooting

Explore complex deadlock scenarios in databases, learn to identify root causes, and discover effective solutions for this challenging aspect of concurrent query management.

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

Inside Waits, Latches, and Spinlocks Returns

Dive deep into SQL Server internals, exploring waits, latches, and spinlocks. Learn monitoring techniques, troubleshoot common wait types, and gain insights into Azure SQL-specific waits through demos and Windows Debugger analysis.

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

SQL Server Containers in Action

Explore SQL Server containers: use cases, recent improvements, and future roadmap. Hands-on demo showcases practical applications and benefits for database management and deployment.

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

Query Store Best Practices

Optimize Query Store implementation with best practices, workload considerations, and performance insights for Azure SQL and SQL Server 2016+. Learn to address challenges and maximize benefits.

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