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

Azure Arc - From Edge to Core to Hybrid Cloud

Explore Azure Arc's role in extending Azure data services to on-premises, multi-cloud, and edge environments, enhancing SQL Server capabilities and enabling edge computing for valuable data insights.

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

Extending Your Use of Extended Events

Explore advanced Extended Events techniques for SQL Server troubleshooting. Learn to leverage targets, actions, and predicates for innovative problem-solving beyond traditional Trace capabilities.

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

Congratulations, You Are Now a DBA

Essential roadmap for new DBAs: daily, weekly, and monthly checklists for SQL Server administration, data protection, and server maintenance. Learn key responsibilities and long-term career prospects in data-driven decision-making.

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

Dr. DMV with Jupyter Notebooks

Comprehensive guide to using Dynamic Management Views for SQL Server diagnostics, leveraging Jupyter Notebooks to detect and resolve performance issues with detailed result interpretation.

• YouTube
• 2 hours 17 minutes
• Self-Paced
• Conference Talk

Building Data Lakes in Azure

Learn to build and leverage data lakes in Azure using Databricks and Synapse Analytics. Explore key services, implementation strategies, and querying techniques for modern data environments.

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

Charticulator - Create Custom Visual with No Code in Power BI

Learn to create custom Power BI visuals using Charticulator without coding. Explore the tool's environment, chart creation process, and importing custom visuals into Power BI desktop.

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

The Good, Bad, and Ugly of Migrating SQL Server to Public Clouds

Explore the challenges and best practices for migrating SQL Server to public clouds like Azure, AWS, and GCP. Learn from real-world experiences to ensure a successful transition from on-premises to cloud environments.

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

What's New in the SQL Server Tools?

Explore upcoming SQL Server tools and user experiences, featuring demos on Jupyter notebooks and SQL database projects, presented by the SQL Server product team.

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