PASS Data Community Summit Talks & Presentations

PASS Data Community Summit

Techniques to Beautiful Data Insights with R and SSRS

Discover five powerful techniques for creating stunning data visualizations using R and SQL Server Reporting Services, enhancing your ability to derive meaningful insights from data.

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

PASS Data Community Summit

Expert Query Performance Troubleshooting

Dive deep into query processor optimization, exploring recompiles, memory issues, and execution plans to enhance SQL Server performance and efficiency.

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

PASS Data Community Summit

Inside SQL Server Latches

Explore advanced SQL Server internals, focusing on latches for critical operation synchronization. Gain insights into internal data structures and advanced diagnostics for optimizing database performance.

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

PASS Data Community Summit

Query Tuning Mastery - Zen and the Art of Workspace Memory

Explore advanced query tuning techniques, focusing on workspace memory optimization for improved performance and scalability in SQL Server. Learn monitoring, query hints, and memory internals for complex queries.

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

PASS Data Community Summit

Top 10 Things You Didn't Know About SSIS in SQL Server Code Name "Denali"

Explore SSIS improvements in SQL Server "Denali": enhanced developer experience, project & parameter model, server-based deployment, and hundreds of customer-reported fixes for highest quality release.

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

PASS Data Community Summit

Developing and Managing a Business Intelligence Semantic Model in SQL Server Analysis Services

Learn to create, manage, and troubleshoot BI Semantic Models using SQL Server "Denali" features, with PowerPivot as a starting point for enhanced business intelligence capabilities.

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

PASS Data Community Summit

End-to-End SQL Server PowerPivot

Explore SQL Server PowerPivot add-ins for Excel and SharePoint, enabling large-scale data analysis, multidimensional modeling, and collaborative business intelligence within familiar Microsoft tools.

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

PASS Data Community Summit

Page and Row Compression Deep Dive

Explore advanced techniques for optimizing database performance through in-depth analysis of page and row compression strategies for DBAs.

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

PASS Data Community Summit

Query Optimizer Deep Dive

Explore advanced techniques for optimizing SQL queries, enhancing database performance, and mastering the intricacies of query execution plans with expert Paul White.

• YouTube
• 2 hours 35 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

SQL Server Execution Plans - From Compilation to Caching to Reuse

Comprehensive exploration of SQL Server execution plans, covering compilation, caching, reuse, and optimization strategies for improved database performance and scalability.

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

PASS Data Community Summit

Field Testing Buffer Pool Extension and In Memory OLTP Features

Explore SQL Server 2014's In-Memory OLTP and Buffer Pool Extension features through field testing results, benchmarks, and real-world examples to enhance database performance and scalability.

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

PASS Data Community Summit

Create Your First SSAS Tabular Model

Learn to create your first Analysis Services Tabular model using Visual Studio. Import tables, establish relationships, and write formulas for data browsing with Excel and Power View.

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

PASS Data Community Summit

Query Tuning Mastery - Manhandling Parallelism, 2014 Edition

Mastering parallel query execution techniques for optimal SQL Server performance, focusing on advanced tuning strategies and best practices.

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

PASS Data Community Summit

Right-Sizing Your SQL Server Virtual Machine

Learn to optimize SQL Server VM performance through proper sizing, resource allocation, and configuration techniques for enhanced efficiency and cost-effectiveness.

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

PASS Data Community Summit

Going Asynchronous with Service Broker

Learn to leverage SQL Server Service Broker for asynchronous processing, database integration, and event notifications. Explore architecture, contracts, message types, and implementation techniques.

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