PASS Data Community Summit Courses

The Function of Windowing Functions - DBA Fundamentals

1 review

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
• On-Demand
• Conference Talk

Data Governance for Beginners

1 review

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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• Conference Talk

Deployment, High Availability & Performance Guidance for SQL Server Linux Azure IaaS Ecosystem

Explore deploying SQL Server on Linux in Azure, covering high availability, AD authentication, and performance optimization for production environments.

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

Azure SQL Is the Best Choice for Building Back-End REST API - Discuss

Explore Azure SQL's capabilities for building high-performance, scalable REST APIs with JSON support, CI/CD integration, and robust security features for modern agile development.

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

Microsoft Power BI - Business Intelligence Strategy, Vision, and Roadmap Update

Explore Microsoft Power BI's latest features and future roadmap for driving data-driven decision-making across organizations, presented by BI leadership at PASS Data Community Summit.

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

Migrating Oracle Workloads to Azure

Learn strategies for migrating Oracle databases to Azure, including architecture design, deployment automation, and success factors for moving to IaaS while leveraging both Oracle and Azure products.

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

Polybase - It's What's for Dinner!

Explore Polybase, Microsoft's linked server replacement, for connecting to diverse data sources. Learn setup best practices, scale-out groups, AlwaysOn integration, and performance optimization techniques.

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