SQLSaturday 622

Albany, United States

SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This event will be held on Jul 29 2017 at SUNY Albany, 1400 Washington Ave, Albany, New York, 12222, 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, and most costs are covered by donations and sponsorships. At some events you will have the option to pay for lunch at the time of registration. Please register soon as seating is limited, and let friends and colleagues know about the event.

More Information

Welcome to SQL Saturday in Albany, NY: July 29, 2017

SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server and related technologies.  This is our 4th SQL Saturday in Albany, and will take place on the beautiful campus at the University of Albany.  The event is free, plus a $10 fee for those who will enjoy breakfast and lunch with us.  Please register soon as seating is limited, and let your friends and colleagues know about the great time to be had at our event!

Getting There

The street address for UAlbany is 1400 Washington Ave, Albany, NY 12222.  The following is a map indicating the location of the 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 the discounted rate of $139/night. 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.

Precon Sessions

We are offering 3 all-day precon sessions scheduled for Friday, July 28th at the Hilton Garden Inn at UAlbany, in Albany, NY:
"Keeping the Lights on: SQL Server for the Accidental DBA", by Mike Hillwig, "Illuminating Query Optimization", by Fabiano Neves Amorim, and "Abstract Business Intelligence from Soup to Nuts", by Steve Simon.

Mike Hillwig
Keeping the Lights On: SQL Server for the Accidental DBA

Mike Hillwig

Native Pittsburgher and Boston resident Mike Hillwig is a senior SQL DBA for a global financial institution. He's been working with SQL Server since version 7. He's got a background in infrastructure and networking. In his current role, Mike's portfolio of SQL servers grows weekly, sometimes daily. He's quite passionate about automating administrative tasks.Mike has been a SQL Server MVP since October 2014. 


You're the sysadmin, analyst, or developer. You have no DBA. You need to keep the lights on. By default, you’ve become the Accidental DBA.

In this all-day session geared toward non-DBAs, IT veteran Mike Hillwig is here to help you. You will start learning the skills you need to keep your SQL Server up and running--smoothly. You won't become a DBA in a day, but you will be in a much better position to keep the lights on.

At the end of this day, you'll leave with a handful of scripts and a whole lot of skill. You'll go back to the office on Monday, ready to take on your SQL Servers.


1. Services
2. Servers, Instances, and Databases
3. Backup and Recovery
4. Maintenance
5. Databases, Filegroups, and Files
6. Security Basics
7. Worst Practice Prevention
8. Worst Case Scenario Resolution
9. Wrap up and Q&A

Eventbrite - Keeping the Lights On: SQL Server for the Accidental DBA

Fabiano Neves Amorim
Illuminating Query Optimization


Fabiano Neves Amorim

Fabiano loves to conquer complex, challenging problems—especially the ones that others aren’t able to solve. He first became interested in technology when his older brother would bring him to his work meetings at the age of 14.

With over a decade of experience, Fabiano is well known in the database community for his performance tuning abilities. When he isn’t working, he loves to read and spend time with his wife and son. He also is a data platform MVP and actively involved in SQL Server community though forums, writes articles for Simple-Talk (https://www.simple-talk.com/author/fabiano-amorim/), and he also presents online Webcasts and In-Person events around world (Brazil , Portugal, UK, Japan, Canada, India, Denmark, Belgium, Israel, Johannesburg…), he already spoke to more than 15 SQLSaturday events.

His blog is on http://blogfabiano.com and you can follow him on twitter at @mcflyamorim.


This full day training conference aims to empower the SQL Server professional with the ability to analyze execution plans, focusing on T-SQL query optimization, by understanding how the execution plan works, how it is created and how to influence the plan as a skeleton key to optimizing T-SQL code.

After presenting the Query Optimizer, we will explore how the execution plans are executed, analyzing the characteristics of key operators, with emphasis on performance.

If you want to dive into to the world of the Query Optimizer, this is the right workshop for you! We’ll have deep dive samples and hours of fun with advanced commands.


  • Module 01 – Introduction to optimization on SQL Server
  • Module 02 – Introduction to statistics
  • Module 03 – Overview of Indexes
  • Module 04 – Key operators of the execution plans
  • Bonus - Module 05 – Advanced tuning techniques you did not know existed

Attendee’s pre-requisites/profile

Good knowledge on T-SQL and experience working with SQL Server 2005+. This is not a beginner training, it is required to have previous experience with SQL Server.

Aimed at Developers and DBA’s looking to better understand how their decisions about the database design and development impact the overall performance of the solution and strive to use SQL Server database resources more efficiently.


Eventbrite - Illuminating Query Optimization


Steve Simon
Abstract Business Intelligence from Soup to Nuts


Steve Simon

Steve Simon is a Data Platform MVP and a senior BI Development Engineer with Atrion Networking. He has been involved with database design and analysis for over 31 years. Steve has presented papers at eight PASS Summits and one at PASS Europe 2009 and 2010. He is also regular presenter on the SQL Saturday circuit and he is a regular contributor on SQLShack.com.


Within our rapidly changing and evolving business world, Business Intelligence has become more and more important by enabling decision makers to take those critical discussions vital to the health of the enterprise (with a minimal amount of time and effort).

In this all day session which is geared to the developer and business analysts alike, we shall be covering numerous business intelligence concepts and topics which will help us to hit the ground running.

By the end of the session you will have a few starter projects, scripts and PowerPoints to take back to the office to implement.


1. Interpreting and understanding user requirement2. Working with and utilizing SQL Server Integration Services

3. Working with and reporting from OLAP cubes

4. Working with and reporting from Data Mining Projects

5 Working efficiently and effectively with the Tabular Model (a CFO’s dream)

6. An introduction to DAX and DAX functions and how this super language can assist in turning data into valuable information.

7. Last, but not least we shall be looking at reporting utilizing SQL Server Reporting Services 2016 and the NEW Mobile Report Publisher.

8. Wrap up and Q&A

Eventbrite - Abstract Business Intelligence from Soup to Nuts


Event Location

Event news

  • Monday, June 26, 2017

    Thanks Quest for being a GOLD sponsor of SQL Saturday Albany!

  • Monday, June 12, 2017

    Lightning talks are announced and on the schedule!

  • Tuesday, June 6, 2017

    Lightning talks have been added to the schedule.  Check back soon for more details on who will be high-velocity presenting!


Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us

Back to Top