Skip Main Navigation
Page Content
This event has ended

Denny Cherry: SQL Performance Tuning & Optimization

SQL Saturday #285 - Atlanta

Friday, May 2, 2014 from 9:00 AM to 4:30 PM (EDT)

Denny Cherry: SQL Performance Tuning & Optimization

Ticket Information

Use promotional code to access tickets.

Who's Going

Loading your connections...

Share Denny Cherry: SQL Performance Tuning & Optimization

Event Details

In this session you will learn about SQL Server 2008 R2 and SQL Server 2012 performance tuning and optimization. Industry Expert Denny Cherry will guide you through tools and best practices for tuning queries and improving performance within Microsoft SQL Server.  This session will guide you through real life performance problems which have been gathered and tuned using industry standard best practices and real world skills.

This session starts off with reviewing the various native tools which are available to you from Microsoft with your SQL Server License and how all of these tools can be used to help you performance tune your SQL Server installation.  These tools include SQL Profiler, Extended Events, Database Tuning Advisor and more.  We will use these tools to identify problem areas within the SQL Server database engine and how to solve for these problems.

We will look at the new ColumnStore index and how it can be used to improve performance within your data warehouse platforms, including how to use it in a data warehouse which needs to be written to through out the day bypassing the problem of the columnstore index being read only.

We will discuss some scaleout options which are available with Microsoft SQL Server both within the database by using table partitioning to spread the workload to multiple disks, as well as AlwaysOn Availability Groups and how they can be used to scale a database out across multiple servers.

Denny CherryDenny Cherry is the owner and principal consultant for Denny Cherry & Associates Consulting and has over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication and troubleshooting. Denny currently holds several of the Microsoft Certifications related to SQL Server for versions 2000 through 2008 including the Microsoft Certified Master as well as being a Microsoft MVP for several years.  Denny has written several books and dozens of technical articles on SQL Server management and how SQL Server integrates with various other technologies.

Lunch will be provided and is included in the cost of your ticket.

IMPORTANT: Registration for a precon session does NOT include registration for SQL Saturday on May 3 - please register here (it's free!) for Saturday's event.

Have questions about Denny Cherry: SQL Performance Tuning & Optimization? Contact SQL Saturday #285 - Atlanta

When & Where


Georgia State University - Alpharetta Campus
3775 Brookside Pkwy
Alpharetta, GA 30022

Friday, May 2, 2014 from 9:00 AM to 4:30 PM (EDT)


  Add to my calendar

Organizer

SQL Saturday #285 - Atlanta

Organized by AtlantaMDF (Atlanta chapter of SQL PASS), SQL Saturday Atlanta set an attendance record in 2013. The Atlanta SQL Server community attracts world-class speakers for event sessions as well as full-day pre-conference training.

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.