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!
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.
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.
Keeping the Lights On: SQL Server for the Accidental DBA
Fabiano Neves Amorim
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.
2. Servers, Instances, and Databases
3. Backup and Recovery
5. Databases, Filegroups, and Files
6. Security Basics
7. Worst Practice Prevention
8. Worst Case Scenario Resolution
9. Wrap up and Q&A
Illuminating Query Optimization
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
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.
Abstract Business Intelligence from Soup to Nuts
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