PASS Data Community Summit Courses

Neither Here Nor There - Hybrid AO SQL Architecture On-Prem - Azure

Explore hybrid Always On SQL architecture, transitioning from on-premises to Azure Cloud. Learn configuration, troubleshooting, and best practices for global architecture in this eToro case study.

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

A Behind the Scenes Look at ML, AI, and Deep Learning

Explore the mechanics of ML, AI, and Deep Learning, understanding their differences and inner workings. Gain fundamental knowledge to support decision-making and organizational AI initiatives.

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

Dr. DMV's Troubleshooting Toolkit

Comprehensive toolkit for SQL Server diagnostics using Dynamic Management Views. Learn to identify performance bottlenecks, optimize queries, and fine-tune database configurations for enhanced efficiency.

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

Power BI Data Privacy Settings Deep Dive

Explore Power BI data privacy settings: configuration, impact on performance, and error prevention. Learn to optimize query speed while ensuring sensitive data protection across sources.

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

Best Practices for Branching Database Code in Git

Learn best practices for branching database code in Git, covering strategies for different team sizes and release requirements. Explore popular branching models and their strengths, with special focus on database-specific considerations.

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

SQL PowerShell 2019 - The Lingua Franca for the Data Platform

Explore PowerShell's versatility in managing diverse data platforms, from Excel to Azure SQL. Learn object-based data handling, code documentation, and sharing through PowerShell Notebooks for seamless integration across Microsoft data products.

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

Dipping Your Toes In - Azure Data Lake for DBAs

Explore Azure Data Lake basics, including storage, security, and U-SQL. Learn how this technology complements relational database skills and discover real-world use cases for data professionals.

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

Data Classification and Masking - The What and How of Data Protection

Learn techniques for protecting sensitive data across systems using SSMS and SQL Server tools. Explore data classification, dynamic and static masking to ensure data security while maintaining accuracy for testing and analytics.

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

Real-time Sentiment Prediction in SQL Server

Explore CosmosDB's capabilities for high-volume transactions, global distribution, and diverse data types. Learn to set up a local instance, load JSON data, create PowerBI visualizations, and seamlessly transition to the cloud.

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

Enabling End to End Scenarios with Data Virtualization in SQL Server 2019

Explore SQL Server 2019's data virtualization for seamless querying of Oracle tables, with enhanced features like data classification and server-based auditing for comprehensive data management solutions.

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

Everyone Has a Story to Tell - Developing Your First Presentation

Learn to create and deliver your first presentation with expert tips on idea development, content creation, and effective delivery techniques.

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

A Game of Hierarchies - Graph Processing with SQL Server 2019

Explore hierarchies and graph processing in SQL Server 2019 using "Game of Thrones" examples. Learn best practices for transforming complex data structures into useful information.

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

Dynamic SQL - Writing Efficient Queries on the Fly

Learn to create fast, efficient queries using Dynamic SQL for automating complex processes, facilitating reporting, and solving seemingly impossible problems. Explore best practices, applications, and maintenance techniques.

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

Improving Availability in SQL Server and Azure SQL Database with Accelerated Database Recovery and Resumable Operations

Discover innovations in SQL Server 2019 and Azure SQL Database that enhance database availability, reduce downtime, and streamline maintenance operations for improved performance and reliability.

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

Elementary! The Curious Case of Deceptive Query Optimizer

Uncover the mysteries of SQL Server Query Optimizer through case studies, investigating performance issues and revealing unexpected culprits in query execution plans.

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