PASS Data Community Summit Courses

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

Using Open Source Software to Collect Performance Metrics

Learn to set up an inexpensive system using Telegraf, InfluxDB, and Grafana to collect and visualize SQL Server performance metrics, aiding in troubleshooting and capacity planning.

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

On-Premises Power BI and Reporting - Reporting Services 2019

Explore on-premises Power BI reporting with PBIRS: installation, configuration, report development, and management through the portal. Learn tips for leveraging on-premises features effectively.

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

Azure Storage Options for Analytics

Explore Azure storage options for analytics, including data lakes and databases. Learn best practices, structures, and appropriate choices for different scenarios to build effective data ecosystems.

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