PASS Data Community Summit Courses

Troubleshooting SQL Server Like a Microsoft Engineer Using Public Tools

Master SQL Server troubleshooting techniques using free public tools, learn data capture methods, and discover customization approaches for performance analysis from Microsoft engineers.

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

Indexing for Beginners

Master the fundamentals of SQL Server indexing, including clustered and non-clustered indexes, index maintenance, and optimization strategies for improved database performance.

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

SQL Server 2016 Temporal Tables

Dive into SQL Server 2016's Temporal Tables functionality, exploring how to track and manage historical data changes while maintaining data integrity and auditability.

• YouTube
• 1 hour 9 minutes
• Self-Paced
• Free Video

In-Memory OLTP in SQL Server - Overview and Architecture

Dive into SQL Server's In-Memory OLTP architecture, exploring memory optimization, native compilation, and lock-free concurrency control for enhanced database performance.

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

In-Memory OLTP for Database Developers in SQL Server 2014

Dive into SQL Server 2014's in-memory OLTP optimization, exploring memory-optimized tables, hash indexes, and natively compiled stored procedures for enhanced database performance and lock-free transactions.

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

Performance Tuning SQL Server Integration Services (SSIS)

Master advanced SSIS performance tuning techniques, from optimizing data flow to resource management, while exploring efficient features in SQL Server 2008 and 2012 for better ETL processes.

• YouTube
• 1 hour 1 minute
• Self-Paced
• Free Video

Private and Hybrid Cloud Features in SQL Server 2014

Discover new private and hybrid cloud capabilities in SQL Server 2014 through hands-on demonstrations and practical implementation strategies for cloud-based database management.

• YouTube
• 1 hour
• Self-Paced
• Free Video

MongoDB for the SQL Server Professional

Discover how MongoDB's architecture and functionality compares to SQL Server, exploring key differences in data modeling, querying, and administration for database professionals.

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

PowerBI e o Futuro da Análise de Dados - Soluções de Self Service BI

Explore o PowerBI da Microsoft e suas funcionalidades para implementar soluções eficientes de Self Service BI na nuvem, transformando dados em insights valiosos para sua organização.

• YouTube
• 1 hour 13 minutes
• Self-Paced
• Free Video

Managing On-Premises and Azure Databases with PowerShell

Master PowerShell cmdlets to efficiently manage and control both on-premises and Azure SQL databases through unified administration techniques and consistent management practices.

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

Spatial Data Analytics: Looking Beyond Traditional Mapping

Discover powerful applications of spatial data in SQL Server beyond traditional mapping, exploring advanced analytics and innovative visualization techniques for location-based insights.

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

Trabalhando com Resource Governor no SQL Server 2014

Descubra como gerenciar recursos no SQL Server 2014 usando Resource Governor, explorando suas funcionalidades e melhorias para otimizar o desempenho do seu ambiente de banco de dados.

• YouTube
• 1 hour 1 minute
• Self-Paced
• Free Video

Using Azure Machine Learning to Predict Consumer Price Index

Discover how to leverage Azure Machine Learning for predicting Consumer Price Index through practical demonstrations and real-world applications in economic forecasting.

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

The Complete Primer to SQL Server Virtualization

Master SQL Server virtualization fundamentals, best practices, and performance optimization techniques for efficient database management and deployment in virtual environments.

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

Developing a SQL Server 2016 Master Data Services Solution - Part 1

Discover essential techniques for implementing and managing Master Data Services solutions in SQL Server 2016, focusing on data governance and enterprise-wide data consistency.

• YouTube
• 1 hour
• Self-Paced
• Free Video