This event has ended

SQL Saturday #222 Sacramento Precon with Kalen Delaney

Sacramento SQL Server Users Group

Friday, July 26, 2013 from 8:30 AM to 5:00 PM (PDT)

Sacramento, CA

SQL Saturday #222 Sacramento Precon with Kalen Delaney

Ticket Information

Ticket Type Sales End Price Fee Quantity
SQL Saturady #222 - Precon Kalen Delaney (Early-Early Bird)
April Early Bird Special End April 30th, 2013 at midnight. Total cost is $129
Ended $129.00 $0.00
SQL Saturady #222 - Precon Kalen Delaney (Early Bird)
May Early Bird Special ends May 31st at Midnight. Total cost is $139
Ended $139.00 $0.00
SQL Saturady #222 - Precon Kalen Delaney   more info Ended $149.00 $0.00

Who's Going

Loading your connections...

Share SQL Saturday #222 Sacramento Precon with Kalen Delaney

Event Details

SQL Saturday Sacramento #222 Precon with Kalen Delaney

 Sacramento SQL Server User Group will be hosting an all-day Precon on Friday July 26th

Performance Tuning with Indexes: Internals and Best Practices

Indexes allow SQL Server to access your data in the most efficient manner. Understanding exactly how your indexes are structured and stored internally can give you a deeper understanding of what indexes will be useful for your queries.  Knowing how indexes are useful can allow us to generalize some best practice recommendations.  In this seminar we’ll look at the following topics:

Basic Index Structures

Clustered vs nonclustered

Unique vs non-unique

Included columns

Tools for Exploring Index Structures

Index maintenance

Page splits

Fragmentation and Defragmentation

Index Design Considerations

AND’s/ OR’s

JOIN’s

Composite Indexes

Best Practice Guidelines

Columnstore Index Storage

Columnstore Index  Guidelines

 

Class Cost:

Early-Early Bird - $129 until April 30th, 2013 for the all day training which includes lunch.

Early Bird - $139 from May 1st until May 31st, 2013 for the all day training which includes lunch.

Staring June 1st, 2013, the cost will be full price at $149 which includes lunch.

 

Plan ahead and get in early!

 

About Kalen Delaney

Kalen Delaney has been working with SQL Server for over 25 years, and provides advanced SQL Server training to clients around the world. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long. Kalen has spoken at dozens of technical conferences, including every PASS conference in the US and multiple TechEd events in both the US and Europe. Kalen is the author or co-author of many books on SQL Server, the most recent being SQL Server 2012 Internals, from O’Reilly/Microsoft Press. She is one of the main editors for SQL Server Central’s SQL Server Stairways series, http://www.sqlservercentral.com/stairway. Her most recent major editing project was as editor of SQL Server MVP Deep Dives, Volume 2, a collection of articles by SQL Server experts from around the world, with all the royalties going to charity.  

Kalen’s website with her current training schedule is at http://www.SQLServerInternals.com and she blogs at www.sqlblog.com.

 

 

 

Have questions about SQL Saturday #222 Sacramento Precon with Kalen Delaney? Contact Sacramento SQL Server Users Group

When & Where



Patrick Hays Learning Center
2700 Gateway Oaks Drive, Suite 2600
Sacramento, CA 95833

Friday, July 26, 2013 from 8:30 AM to 5:00 PM (PDT)


  Add to my calendar

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.