SQL Server Performance Tuning and Optimization -- Live! 360 Events

SQL Server Performance Tuning and Optimization

Get the most from SQL Server – even if it's hosting a third-party application database! Learn the insider tricks to performance tuning, covering the Query Optimizer, CPU issues, transaction logs, monitoring, and much more. SQL Server Live! helps you maximize your SQL Server investment!

SQW11 Accelerate Database Performance through Data Compression Wednesday November 19 4:00pm - 5:15pm

Joey D'Antoni

This session will discuss the basics of how compression and de-duplication reduce your data volume. more

SQH02 Getting Started Reading Query Execution Plans Thursday November 20 8:00am - 9:15am

Grant Fritchey, Product Evangelist, Red Gate Software

This session will provide you with a simple set of tasks to get you started reading execution plans. more

SQH05 Secrets of SQL Server: Database WORST Practices Thursday November 20 9:30am - 10:45am

Pinal Dave MS Computer Science , SQL Server Performance Tuning Expert

This demo-oriented session will highlight database worst practices and how to avoid them. more

SQH08 Statistics and the Query Optimizer Thursday November 20 11:00am - 12:15pm

Grant Fritchey, Product Evangelist, Red Gate Software

This session will teach you what statistics are, how they are generated and their use within the optimizer. more

SQH11 Inside the SQL Server Query Optimizer Thursday November 20 1:30pm - 2:45pm

Bradley Ball, Sr. Consultant – Premier Support for Developers, Microsoft

In this session we will break down the changes that were made, why they were made, and example of how SQL 2014 can make your T-SQL life better! more

SQH14 Cardinality Estimates in SQL Server 2014 Thursday November 20 3:00pm - 4:15pm

Thomas LaRock, Head Geek, SolarWinds

In this session, Thomas will review everything you'll need to know about Cardinality Estimates in SQL Server 2014. more

SQF01 Workshop: Performance Tuning Best Practices - Every DBA and Developer MUST Know Friday November 21 8:00am - 5:00pm

Pinal Dave MS Computer Science , SQL Server Performance Tuning Expert

In this session we will try to bridge the gap between DBA and Developer. We will approach performance as a whole subject rather than dividing them into DBA or Developer problems. more