Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Saturday #222

By Press Release,

Welcome to SQLSaturday #222

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, but we do charge a lunch fee of 8.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. 

This event will be held Jul 27, 2013 at:
Patrick Hays Learning Center
2700 Gateway Oaks Drive, Suite 2600
Sacramento, CA 95833

ANNOUNCEMENT!!!  SQL Saturday #222 Sacramento ALL-DAY Precon with Kalen Delaney - Performance Tuning with Indexes: Internals and Best Practices

Sacramento SQL Server User Group will be hosting an all-day Precon on Friday July 26th with Kalen Delaney talking about Performance Tuning with Indexes!

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:
Staring June 1st, 2013, the cost will be $149 which includes lunch.

Sign up here - http://sqlsat222precon.eventbrite.com

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.

Total article views: 406 | Views in the last 30 days: 2
 
Related Articles
BLOG

Kalen Delaney Speaking In Denver on June 9, 2010

Well-known SQL Server MVP and author Kalen Delaney (blog) will be speaking  about SQL Server Plan Ca...

ARTICLE

Kalen Delaney at the Denver SQL Users Group

Sponsored by Dell, Kalen Delaney is coming to the Denver Marriot Tech Center on June 9.

BLOG

Kalen Delaney SQL Server Internals DVD

I did end up pre-ordering the first DVD on SQL Server internals by SQL Server MVP and SQL Server int...

BLOG

Inexpensive Video Training from Internals Expert, Kalen Delaney

 I saw this in my blog reader today: You can pre-order the Kalen Delaney SQL Server Internals Cours...

ARTICLE

Prevent overlapping of time events with an indexed view

Prevent overlapping of time events with an indexed view.

Tags
events    
sql saturday    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones