Welcome to SQL Saturday in Albany, NY: July 30, 2016
SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server and related technologies. This will be our 3rd SQL Saturday in Albany, and will take place on the beautiful campus of 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 a discounted rate. The hotel is located at:
1389 Washington Ave, Albany, NY 12206 and you can reserve a room
or by calling them at (518) 453-1300. The block is reserved under Professional Association of SQL Server.
2 Full-Day Precon Sessions!
We are proud to have 2 all-day precon sessions scheduled for Friday, July 29th at the Hilton Garden Inn at UAlbany, in Albany, NY: "The Enterprise Scripting Workshop" by Jen & Sean McCown and "Introduction to R Programming" with Bryan Cafferky.
Jen McCown & Sean McCown
The Enterprise Scripting Workshop
Sean McCown is is co-owner of MinionWare, LLC, a Certified Master in SQL Server 2008, and a SQL Server MVP with 20 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos and co-hosts the popular web show DBAs@Midnight.
Jen McCown is co-owner of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in NTSSUG, PASS, and the PASS Women in Technology virtual chapter.
The database administrator (DBA) life can be frustrating: You rarely have time to innovate because the same tasks fill up your time day after day. Your users are unhappy about how long it takes to resolve “simple” tickets. You need to put big items on hold to manage special requests. As careful as you are, mistakes creep in the busier you get.
In this pre-conference workshop, learn how to develop enterprise scripts with a huge range of uses.. A good set of reusable scripts can reduce task time from hours or days to just a few minutes, and eliminate mistakes from your environment.
This session is for DBAs with a basic understanding of PowerShell. It’s for anyone who touches backups or security, maintains databases, troubleshoots performance, monitors disk space, or any of a hundred other DBA tasks. Enterprise scripting is for anyone who has more tasks than time.
The morning will be spent largely in discussion and lecture, so the attendee has solid scripting principles to build upon. The afternoon session will be spent largely in actual enterprise script development.
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 the precon will begin by 8:30.
Introduction to R Programming
Bryan Cafferky, of BPC Global Solutions LLC, is an independent Business Intelligence consultant with decades of experience in information technology focused on the Microsoft stack. Bryan is the author of Pro PowerShell for Database Developers published by Apress and available on Amazon. He is the founder and leader of the SQL PASS chapter, The Rhode Island Microsoft Business Intelligence User Group. Bryan has spoken on a number of subjects at various PASS chapters, Code Camps, and SQL Saturdays. He has worked in banking, insurance, Internet/Ecommerce, utilities, and health care. Bryan holds an undergraduate degree in Computer Information Systems from Bryant University and a Masters in Business Administration from Bentley University. Nothing makes Bryan happier than to learn and pass the knowledge on to others. You can contact Bryan at firstname.lastname@example.org and on LinkedIn at https://www.linkedin.com/in/bryancafferky. You can join his PASS Chapter at: http://www.meetup.com/The-RI-Microsoft-BIUG/. See his blog at www.sql-fy.com.
You keep hearing about the R programming language. Azure Machine Learning Studio is built on it and Microsoft recently acquired the R platform vendor, Revolution Analytics, with plans to integrate the R language into SQL Server 2016. The need to learn R is clear. This PreCon will get you up to speed on what you need to know.
We will start with a background on what R is and where it came from. Then you will learn how to install the language shell and R Studio, the development environment. You’ll learn about the unique vector based architecture of R which makes it such a powerful analysis tool. Through examination of examples that go from simple to advanced, you will learn the language. R supports rich data visualizations and you will learn how to use these to fit your needs. The goal of this session is to demystify R and give you a basic understanding of R programming. The focus is on the programming language so only a minimal understanding of statistics is needed.
- Background - what is R, a little history
- Installing and using R and R Studio
- Developing in R:
- The R CLI
- R Studio
- Vectors - The Heart of R
- R Programming Language Structures
- Writing functions
- Writing and using Vectorized functions
- R Classes Built on Vectors
- Loading External Files
- Accessing SQL Server
- Object Orientated programming
- Creating Visualizations in RIntegrating R with Windows via PowerShell.
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 the precon will begin by 8:30.