PASS Data Community Summit Courses

Build Your Brand with Technical Writing

1 rating

Discover how technical writing can boost your career, enhance your brand, and make a global impact. Learn about the publishing process and strategies to kickstart your writing journey.

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

The Function of Windowing Functions - DBA Fundamentals

1 rating

Explore windowing functions in SQL for efficient data analysis, including row numbering, aggregation, lag/lead, and distribution functions. Learn practical applications and advanced techniques.

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

7 Tips to Performance Tuning, Optimization, and Everything

1 rating

Learn essential performance tuning and optimization techniques for databases from expert Pinal Dave. Discover practical tips to enhance efficiency and solve common challenges.

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

24HoP Portuguese Edition - Powershell: Passar de scripts simples a funções avançadas

1 rating

Aprenda a evoluir de scripts simples para funções avançadas no PowerShell, aprimorando suas habilidades de automação e gerenciamento de sistemas Windows.

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

Data Governance for Beginners

1 rating

Learn data governance basics for Microsoft Data Platform, including master data management and data stewardship. Discover practical steps for implementation and documentation to enhance organizational data value.

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

What it Takes to Create Value from Data and Analytics

1 rating

Explore key capabilities and practices for leveraging data analytics to drive smarter decisions, enable faster actions, and optimize outcomes in today's competitive business landscape.

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

SSAS multidimensional mejores prácticas

1 rating

Aprende las mejores prácticas para optimizar el rendimiento y la eficiencia de SSAS multidimensional en este tutorial avanzado para profesionales de datos.

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

Building Resilient Environments - Incorporating Security and Compliance into Database Monitoring

Discover essential strategies for database security and compliance monitoring, from vulnerability detection to access control implementation and audit processes for maintaining industry standards.

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

SQL Server Best Practices for SharePoint

Descubra as melhores práticas de configuração do SQL Server para otimizar o desempenho do SharePoint, maximizando a eficiência e o rendimento do seu ambiente de colaboração.

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

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