PASS Data Community Summit Courses

SQL Server Configuration and Deployment with Powershell DSC

Automate SQL Server deployment and configuration using PowerShell DSC for consistent, error-free setups. Learn Infrastructure as Code principles and implement a two-replica availability group effortlessly.

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

What's New in Security & Networking for Azure SQL

Explore Azure SQL's latest security innovations for safeguarding sensitive data, including authentication, encryption, network security, and threat protection in cloud and hybrid environments.

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

The Evolution of Machine Learning on Hybrid Cloud

Explore upcoming advancements in machine learning with hybrid Azure capabilities, focusing on innovative features and potential applications.

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

What is Power BI Doing to My Database?

Explore Power BI's impact on databases, including query types, frequency, and volume. Learn essential considerations for DBAs before, during, and after Power BI deployment in organizations.

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

Demystifying Dynamic SQL

Learn to create and utilize dynamic SQL scripts to enhance productivity and solve programming challenges, while understanding associated risks and mitigation strategies.

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

Give Power BI to the People - Securely Share Your Insights

Discover secure Power BI data sharing strategies, governance planning, and collaboration techniques to empower your organization while avoiding potential data breaches and privacy risks.

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

Power BI Governance - Top Tips

Learn essential Power BI governance strategies to balance user flexibility with risk management in complex deployments across multiple business units. Gain practical techniques for effective implementation.

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

Taking Your Data Hybrid With Azure Arc Enabled Data Services

Explore Azure Arc's hybrid cloud capabilities for data services, including SQL Managed Instance deployment, encryption, and authentication, with practical demos and insights.

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

Getting Started with Azure Data Studio

Learn to use Azure Data Studio: customize, create insights, use extensions, work with notebooks, and develop your own extensions. Master this cross-platform tool for data-related tasks and T-SQL editing.

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

Diversity, Equality & Inclusion Within Data Community and Outside World

Panel discussion on raising awareness and taking action against social inequalities, focusing on diversity, equality, and inclusion within the data community and beyond.

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

Power of Electric Snakes! PySpark for Big Data and Data Science

Learn to harness PySpark for big data analytics, covering RDDs, DataFrames, transformations, and machine learning. Gain practical skills for efficient data processing and analysis using Python and Spark.

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

Database Modernization Best Practices and Lessons Learned Through Customer Engagements

Discover real-world examples and engineering best practices for modernizing SQL and Non-SQL platforms to Azure SQL PaaS, leveraging Microsoft's Data 1st strategy for complex modernizations.

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

Getting to Know Google Cloud SQL for SQL Server

Explore Google Cloud SQL for SQL Server: architecture, provisioning, analytics, security, high availability, and replication. Learn best practices and tools for leveraging this managed database service.

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

Getting Started with PowerShell as a DBA

Learn PowerShell fundamentals for DBAs: syntax, TSQL translation, and practical applications. Discover how this powerful tool can enhance your database administration skills and workflow efficiency.

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

Performance Tuning - Getting the Biggest Bang for Your Buck

Discover essential SQL Server performance tuning techniques, from memory optimization to configuration changes, with real-world scenarios and practical solutions for immediate improvements.

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