SQLSaturday 600

Chicago, 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 Mar 11 2017 at DeVry University - Addison Campus, 1221 North Swift Road, Addison, Illinois, 60101, United States

Register Now

Welcome to SQLSaturday

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. 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.

Lunch is available for purchase for $15. Please note Lunch Fee is NOT REFUNDABLE. We can accommodate a vegetarian option for lunch, if you have further dietary restrictions, please make alternate plans.

Hotel Information

Once again, we have reserved a block of rooms for those traveling from out of town, or if you just want to hang out with some fellow SQL Server enthusiasts!

Hampton Inn & Suites Addison
1685 West Lake Street
Addison, IL 60101
Click HERE to book at room at our special event rate!
King singles and Queen doubles are available for $99/night

Hilton Garden Inn Addison
551 N. Swift Road
Addison, IL 60101
CALL 630-691-0500 or Click HERE to book your room 
Rooms available for $107/night

Pre-conference Sessions

We are thrilled to welcome two distinguished industry experts: Adam Machanic & David Klee, who will be hosting pre-cons this year. Come attend an amazing in-depth day of training, the day before SQL Saturday!
Please remember if you do register for a pre-con, that you must still register to attend SQL Saturday. If you are attending a pre-con and are on the SQL Saturday wait-list, please contact sqlsaturday600@sqlsaturday.com.

Adam Machanic presents: Tuning Your Biggest Queries

Today's database workloads are all about bigger, better, and more: bigger data, better analytics, and more insights. While these improvements can be great for your business users, on the technology side they often translate into large, lumbering queries that monopolize the server and test the patience of even the calmest of analysts. This full-day seminar is specifically designed to help you tune these extra tough queries. The day begins by establishing a solid foundation for reading and understanding how query plans work, and what is and is not important to pay attention to when reading a plan. Next you will learn about plan shaping: types of query rewrites that work, which rewrites are bound to fail, and the various query hints you might want to leverage in especially difficult situations. Real-world application of these techniques will be covered with a discussion around how to understand what kind of plan is ideal given the particulars of a situation, and the introduction of an approach to help you analyze and fix even the biggest query plans. The day concludes with a look at various indexing strategies and patterns--both common and alternative, including a look at the  applicability of columnstores in SQL Server 2016 and beyond. You will leave the class armed with an array of tools and ideas to help you tame even the biggest queries in your environment. 

Register For Adam's pre-con here.


David Klee presents: The Complete Primer to SQL Server Infrastructure & Cloud

Microsoft MVP and VMware vExpert David Klee leads this full-day introduction to getting the most out of the infrastructure underneath your SQL Server environment, whether on-premises or in the cloud. The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with function and purpose of each layer of the architecture around their databases, and how this knowledge can benefit them as data professionals. Participants will gain exposure to all layers of infrastructure, virtualization, and cloud underneath SQL Server, from storage all the way through to the SQL Server instance and database, and will learn how to review and engineer the entire stack with a strong emphasis on SQL Server performance.

Register for David's pre-con here.




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