Welcome to SQLSaturday in Albany, NY
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jul 26 2014 at SUNY Albany, 1400 Washington Ave, Albany, NY 12222. Admittance to this event is free, but we do charge a lunch fee of 10.00 so that we can provide a great lunch! Please register soon as seating is limited, and let friends and colleagues know about the event.Getting There
The following is a map indicating the location of the SUNY Albany uptown campus and is centered on the State Purple parking lot. Signs will direct you from there to the lecture centers & fountain area, where all events will be taking place.
Google Map: State Purple Parking Lot
All events will be held in the Lecture Centers, which are located at the center of campus encircling the large tower & fountain. A Google map of SUNY Albany's campus can be found here, as well as a printable PDF version, as well.
The State Purple lot is the closest and most convenient place to park on campus, with easy access to the center of campus. All lots allow for free parking on the weekend, so you may park elsewhere, if desired. We will be using Lecture Centers (LCs) 20 - 25 for all sessions, and the concourse area outside of them for sponsors & registration.
Need a Place to Stay?
The Hilton Garden Inn @ SUNY Albany has reserved a block of rooms for attendees at a discounted rate. The hotel is located at: 1389 Washington Ave, Albany, NY 12206 and you can reserve a room online or by calling them at (518) 453-1300. The block is reserved under Professional Association of SQL Server.
Full-Day Precon Session!
We are ecstatic to announce an all-day precon event on Friday, July 25th at the Hilton Garden Inn in Albany, NY.
Query Performance Tuning in SQL Server
Sometimes, just buying
bigger and better hardware isn’t possible and you still have problems
with database performance you have to deal with. Now what do you do?
Since about 80% of the time, the problem lies in the T-SQL code, you
could try tuning your queries. This all day session takes you through
everything you need in order to tune your queries. We’ll start with
establishing an understanding of how the optimizer works, move through
methods for capturing query performance metrics and then step through
methods of fixing common problems. We’ll take advantage of the tools
offered by Microsoft such as the Dynamic Management Objects, Query
Execution Plans and Extended Events. You’ll leave with a better
understanding of how to identify and fix poorly performing queries that
you can apply immediately on your own systems.
Fritchey is a SQL Server MVP with over 20 years experience in IT
including time spent in support and development. Grant has worked with
SQL Server since version 6.0 back in 1995. He has developed in VB,
VB.Net, C# and Java. He has authored books for Apress and Simple-Talk,
and joined Red Gate as a Product Evangelist in January 2011
Logistics: Breakfast and lunch will be provided. The Hilton Garden Inn is located at 1389 Washington Ave, Albany, NY 12206. This is directly across the street from the campus of SUNY Albany, where the SQL Saturday will be held. The precon will run from 8:00am until 5:00pm. Breakfast is served at 8:00, and everything will begin by 8:30.
SQL Saturday Albany Precon is SOLD OUT! See you then!!
Register for SQL Saturday Albany here: