Welcome to SQLSaturday #272 Nashville, TN

Thanks Ron Reiring, for the imae.

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 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 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.

Register here


Session 2 : David Klee – Virtualization for SQL Server DBAs

VMware vExpert 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.

Course Objectives

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

Register here


Register

*We do ask that you consider to OPT-IN for the Sponsors of this event. Without their assistance, we cannot bring this FREE event to you. You can always opt-out if and when they contact! Thank you for your consideration.

Click here to view/download event summary in XML format.

Join us on Twitter!

Event News

Event Sponsors

  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
SQLSaturday Home
PASS