Skip Main Navigation
Page Content

Save This Event

Event Saved

Looks like this event has already ended.

Check out upcoming events by this organizer, or organize your very own event.

View upcoming events Create an event

Real World Database Config and Tuning for SQL 2012 with Kevin Kline

SoCal SQL Saturday

Friday, April 10, 2015 from 7:45 AM to 5:15 PM (PDT)

Real World Database Config and Tuning for SQL 2012...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Early Bird   more info Ended $99.00 $6.44

Share Real World Database Config and Tuning for SQL 2012 with Kevin Kline

Event Details

SQL Saturday #389 - Full Day Preconference Session

Real World Database Config and Tuning for SQL 2012 with Kevin Kline

Abstract

This full-day training event combines a thorough overview of key concepts followed by hands-on demos to reinforce each conceptual lesson. Since most technologists learn by doing, this training is designed to maximize the time attendees spend working with SQL Server.    With ample demos, we’ll cover the spectrum of best practices as they relate to server and database design & configuration and performance tuning. 

Description

At the conclusion of the training, attendees will understand:

  • The internals and architecture of SQL Server and how they interact during read and, separately, during write operations, including an overview of SQL Server caches, memory buffering and clean-up processes, and user activity handling.
  • An introduction to bare-metal tuning of server hardware and storage configurations for database applications, including DASD, RAID, SSD, and SAN architectures.
  • Important Windows and SQL Server configuration settings and trace flags, including special considerations for SQL Server running on VMs.
  • Methods for benchmarking the performance of alternative configurations and settings.
  • Designing databases for performance through indexing, statistics and cardinality, data types, and recovery mode.
  • Monitoring and identifying performance bottlenecks and resolving performance issues, including PerfMon, traces and extended events, Dynamic Management Views (DMVs) and Wait Statistics.
  • Advanced database structures including “Hekaton” in-memory tables and Columnstore indexes. 

Kevin Kline

Kevin Kline is a renowned database expert and software industry veteran currently serving is the Director of Engineering Services at SQL Sentry, a leading vendor of database and business intelligence tools.  At previous companies, his product designs have won multiple “Best of TechEd” and “Readers’ Choice” awards.  A Microsoft SQL Server MVP since 2004, Kevin was a founding board member of the international Professional Association for SQL Server (PASS) and served as president from 2002-2006. He is the author of the best-selling SQL in a Nutshell, and co-author of SQL Server 2012 Management and Administration, Professional SQL Server 2008 Database Design and Optimization, and Database Benchmarking: Practical Methods for Oracle & SQL Server. Kevin writes monthly columns for SQL Server Magazine and Database Trends & Applications Magazine, while his frequent blog posts appear at SQLBlog.com, SQLServerPedia.com, SQLServerCentral.com, and SQLMag.com, as well as at http://KevinEKline.com. He tweets at KEKline. Kevin is a top-rated speaker at conferences worldwide such as Microsoft TechEd, the PASS Summit, DevTeach, Oracle OpenWorld, and SQL Connections.  When he’s not pulling his hair out over work, he loves spending time with his wife, four kids, three step kids, working on his antique truck, and in his garden.

FAQs

What is the refund policy?

Once purchased, tickets are non-refundable.  Tickets are transferrable. 

What does the ticket include?

The ticket for the event includes the following:

  • Access to Session Material for the Pre-Conference Workshop
  • Continental Breakfast, Lunch and Snacks are included. If you have any dietary restrictions please let us know at sqlsaturday389@sqlsaturday.com


What should I bring to the event?

There will be a lot of information presented at the event so you will likely need something to take notes.  If you have a laptop with SQL Server installed you may be able to follow along with demos or try techniques on your own databases

Where on campus is the event located?

Detailed instructions on the exact location of the classroom for your event will be sent closer to the day of the event in addition to information on parking.

Does this register me for the SQL Saturday event the next day?

No.  If you are plannig on attending the main SQL Saturday event the next day, please be sure to register on the main SQL Saturday site: https://www.sqlsaturday.com/389/register.aspx.

What if I have Questions?

Please email us at sqlsaturday389@sqlsaturday.com. 

Have questions about Real World Database Config and Tuning for SQL 2012 with Kevin Kline? Contact SoCal SQL Saturday

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.