PASS Data Community Summit Talks & Presentations

PASS Data Community Summit

Real-Time Big Data Analytics with R

Explore real-time big data analytics using R, covering data distillation, model development, validation, deployment, refresh, and scoring. Learn to integrate R with Hadoop and database systems.

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

PASS Data Community Summit

SSAS Design and Performance Best Practices

Explore scalable SQL Server Analysis Services cube design patterns and optimization techniques to enhance SSAS performance for your organization's needs.

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

PASS Data Community Summit

Don't Repeat Yourself - An Introduction to Agile SSIS Development

Learn to streamline SSIS development using Biml and BimlScript. Generate packages from metadata, implement changes efficiently, and reuse code across projects for faster, more agile development.

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

PASS Data Community Summit

50 Things All SQL Server Developers Need to Know

Discover 50 essential SQL Server development tips, covering database design, T-SQL best practices, and query optimization techniques for improved performance and efficiency.

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

PASS Data Community Summit

Enabling Familiar, Powerful Business Intelligence

Empower users with business intelligence through familiar Office tools and manage data needs with a powerful, scalable platform for meaningful insights across web and organizational information.

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

PASS Data Community Summit

SQL Server 2014 In-Memory OLTP Overview

Explore SQL Server 2014's in-memory OLTP technology, its architectural pillars, and integration with SQL Server for optimized workloads and improved performance.

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

PASS Data Community Summit

SQL Server Integration Services Roadmap

Explore the future of SQL Server Integration Services with industry experts, covering upcoming features, best practices, and strategic insights for data integration professionals.

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

PASS Data Community Summit

Microsoft's Data Platform

Explore Microsoft's data platform vision and strategy, including latest innovations and future directions in database technology and analytics.

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

PASS Data Community Summit

Windows Azure Deep Dive

Explore Windows Azure's architecture, services, and capabilities with Microsoft Technical Fellow Mark Russinovich in this comprehensive deep dive session.

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

PASS Data Community Summit

Hekaton - Why, What, and How

Explore Hekaton, Microsoft's in-memory OLTP engine for SQL Server, with David DeWitt. Learn its purpose, functionality, and implementation details in this comprehensive keynote presentation.

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

PASS Data Community Summit

Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad

Explore how skewed data affects cardinality estimates and query plans, learning strategies to improve SQL Server performance and optimize database operations.

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

PASS Data Community Summit

Dos and Don'ts of Database Corruption

Learn essential strategies for preventing, detecting, and recovering from database corruption, ensuring data integrity and minimizing downtime in critical systems.

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

PASS Data Community Summit

Policy-Based Management and Central Management Server

Explore policy-based management and Central Management Server for efficient SQL Server administration, including server registration, policy creation, and evaluation modes.

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

PASS Data Community Summit

Being the DBA of the Future - A World of On-Premise and Cloud

Explore the evolving role of DBAs in hybrid environments, covering essential skills for managing on-premise and cloud databases, and strategies for adapting to future technological changes.

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

PASS Data Community Summit

Extending Your Use of Extended Events

Explore advanced Extended Events techniques for SQL Server troubleshooting. Learn to leverage targets, actions, and predicates for innovative problem-solving beyond traditional Trace capabilities.

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