PASS Data Community Summit Courses

Azure DevOps and the SSIS Development Lifecycle

Learn to manage SSIS projects through their lifecycle using Azure DevOps, from initial development to production release, with practical demonstrations and expert guidance.

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

Secure SQL Server Database Design - Tactics and Technology

Strategies for designing secure SQL Server databases, covering table design, roles, and built-in security features like Always Encrypted and Row-Level Security.

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

SQL Server Security from the Ground Up

Comprehensive introduction to SQL Server database security, covering permissions, securables, principals, best practices, and management techniques to protect valuable company data.

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

MSAs, GMSAs, and Groups - Use SQL Without Traditional User Accounts

Explore Active Directory features for enhanced SQL security, including AD Groups, MSAs, and GMSAs. Learn to simplify access management and reduce risks in database environments.

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

Packaging Permissions in Stored Procedures

Learn advanced techniques for fine-grained permission control in SQL Server stored procedures, including certificate signing and EXECUTE AS. Discover how to securely grant privileged actions without compromising overall database security.

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

Database Security, Who Owns It?

Explore layers of database security, from DBA to InfoSec roles. Learn secure-by-design practices within DevOps for comprehensive data platform protection throughout the development lifecycle.

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

Tips and Tricks for Using SQL Server Management Studio Effectively

Discover essential tips and tricks to enhance your productivity with SQL Server Management Studio, covering features like object explorer, scripting, query plans, and multi-server management.

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

Bad Designs Have Consequences

Explore real-world SQL database design pitfalls, their consequences, and learn from 15 years of experience to avoid common mistakes and improve your database architecture.

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

SQL Server 2017 Database Engine Enhancements - Why You Should Upgrade to It

Explore SQL Server 2017's Database Engine enhancements, including improved query processing, scalability features, and reasons to upgrade from previous versions.

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

The Care and Feeding of SQL Server

Learn essential SQL Server administration tasks: backups, integrity checks, index maintenance, disk management, and alerting. Gain foundational knowledge for effective database management and maintenance.

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

Storage 101 for the DBAs

Learn essential storage concepts for SQL Server, including IO basics, best practices, and troubleshooting tips to optimize performance and quickly diagnose issues.

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

Data Types Do Matter

Explore the critical importance of selecting appropriate data types for optimal data quality, storage, performance, and query accuracy in database management.

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

SQL Server and Kubernetes

Explore deploying SQL Server in Kubernetes: benefits, challenges, and practical implementation. Learn about orchestration, persistence, and chaos engineering for robust database management.

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

Azure Data Security

Explore Azure's data security tools: encryption, masking, threat protection, and more. Learn to safeguard your data assets effectively in the cloud environment.

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

Deadlocking for Mere Mortals

Explore common SQL Server deadlocks, their causes, and troubleshooting methods using various tools like Trace Flags, SQL Trace, Event Notifications, and Extended Events.

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