PASS Data Community Summit Courses

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

In-Memory OLTP Internals - Understanding the 30x Performance Boost in SQL Server Hekaton

Discover how SQL Server Hekaton's in-memory architecture revolutionizes data management, offering unprecedented performance boosts through optimized memory storage and innovative checkpoint mechanisms.

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

How to Use DMVs to Diagnose SQL Server Performance Problems

Master essential techniques for using Dynamic Management Views (DMVs) to effectively diagnose and troubleshoot SQL Server performance issues, improving database monitoring and optimization skills.

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

Enabling Real-Time Analytics with CDC and Data Warehouse Automation

Discover real-time analytics implementation through Change Data Capture (CDC) and automated data warehouse solutions, enhancing your organization's data processing capabilities.

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