Welcome to SQLSaturday #272 Nashville, TN
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jan 18 2014 at Lipscomb University; One University Park Drive, Nashville, TN 37204. Admittance to this event is free, but we do charge a lunch fee of 10.00 so that we can provide a lunch - not pizza! Please register soon as seating is limited, and let friends and colleagues know about the event.
You can follow us on twitter @NashSql and
Pre-Cons now available!
We are pleased to announce 2 very special ALL DAY sessions
on Friday January 17th from 8:00 am – 4:30 pm. This is the best deal
you will ever find on an entire day of technical training! From now till 12/20
at noon CST you can get this training for only $99 +Eventbrite fees, after that
the price goes to $125.
Session 1: Denny Cherry - SQL Performance Tuning and Optimization
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
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 throughout 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.
Session 2 : David Klee – Virtualization for
SQL Server DBAs
and SQL Server performance expert David Klee leads this full-day, hands-on
introduction to enabling and managing a virtualized SQL Server environment. The
focus of the course is to help those new to virtualization and/or
infrastructure concepts to become familiar with the concept and purposes of
virtualization and how it can benefit them as data professionals. Participants
will gain exposure to all layers of virtualization underneath SQL Server, from
storage to hypervisor to the SQL Server instance, and will learn how to
construct the entire stack with the focus on SQL Server performance.
Upon completion of this course,
attendees will be able to:
- Understand key virtualization and cloud concepts
- Determine the optimal infrastructure configuration for best performance
- Construct a SQL Server virtual machine template with best practices for agility and performance
- Understand how and what stack metrics to benchmark and baseline to ensure proper objective performance measurement
- Identify and remediate common virtualized SQL Server performance killers
- Understand proper virtualized capacity management techniques for long term management