SQLSaturday 340

San Diego, United States

PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. This event will be held on Sep 20 2014 at UCSD Extension - University City Center, 6256 Greenwich Dr., San Diego, California, 92122, United States

Register Now

Welcome to SQLSaturday #340

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Sep 20 2014 at 6256 Greenwich Dr., San Diego, CA 92122. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.

Where is my SpeedPASS?

Can't find the email or the link is not working?

Get Instructions on Printing your SpeedPASS here: SpeedPASS Instructions


The best way to schedule your time is to utilize the GuideBook application.  This application allows you to build your schedule, view all the session details and more all from your Mobile Device.  Simply download the app from the Links Below and search for "SQLSaturday" and download our event.  

Other Devices - Follow the instructions here: Using the Guidebook App

The other option you can use to build your schedule using the online Schedule Builder.  You can then print your schedule from the site.

You can download the room maps here:

First Floor Map    Third Floor Map

Driving Directions and Parking Information:

After Party - Player's Sports Bar

Be sure to join us after SQL Saturday for drinks, networking and good times

SQLSaturday #340 Pre-Con -- SOLD OUT!

You are simply not going to want to miss this event.  Itzik Ben-Gan is one of the foremost experts on SQL Server and his Pre-Cons and Sessions at PASS are always filled to capacity.  And we are bringing him to your front door.  This event WILL sell out, so do not pass up your chance to buy your ticket for this event.

Link:     Query and Index Tuning with Itzik Ben-Gan

Seminar: Query and Index Tuning
Level: mostly 200; at some points 300.

This seminar provides the foundations for tuning queries and designing a good indexing strategy.
You will learn about the internals of tables and indexes, index access methods, included non-key columns, filtered indexes and statistics, columnstore indexes, inline index definition, prioritizing queries for tuning, and gathering index and query information and statistics.
You will also learn about using temporary tables and table variables for tuning purposes, choosing between relational and iterative solutions, and performing query tuning by applying query revisions.
Prerequisites: Half a year to a year of experience writing and tuning T-SQL queries.

    Internals and Index Tuning
        Table and Index Internals
        Index Access Methods 
        Included Non-key Columns
        Filtered Indexes and Statistics
        Columnstore Indexes
        Inline Index Definition
        Prioritizing Queries for Tuning
        Index and Query Information and Statistics
    Temporary Tables
    Sets vs. Cursors
    Query Tuning with Query Revisions
Itzik Ben-Gan

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions and Microsoft SQL Server 2012 T-SQL Fundamentals. He has written articles for SQL Server Pro, SolidQ Journal and MSDN. Itzik's speaking activities include TechEd, SQLPASS, SQLU, SQLTeach and various user groups around the world. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.

Event Location

Event news

No Event News entered. Please come back later and check again


Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us

What is a PASS SQLSaturday?

PASS SQLSaturdays are local events organized by PASS community members around the world. PASS is a not-for-profit association for data professionals who leverage the Microsoft Data Platform, offering interactive learning built by community and guided by trusted data experts.

Back to Top cage-aids