SQLSaturday 855

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 20 2019 at SUNY Albany, 1400 Washington Ave, Albany, New York, 12222, United States

Register Now

Event schedule is not published yet.

Welcome to SQL Saturday in Albany, NY: July 20, 2019

SQL Saturday is a training event for database professionals and those wanting to learn about SQL Server and related technologies.  This is our 6th 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 a delicious breakfast and lunch with us.  Vegetarian options are available for all meals.

Please register soon and let your friends and colleagues know about the great time to be had at our event!  In addition to educational sessions by leading industry experts, you can meet colleagues from around the world and maybe win some sweet raffle prizes!

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 $134/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

The following full-day training sessions will be offered on Friday, July 19th at the Hilton Garden Inn at UAlbany.  These events run from 8am to 5pm and include breakfast and lunch.  Please visit the Eventbrite pages for further details, agenda, and to register for an event.  If you are a company or organization wishing to register 5 or more attendees at once, please inquire for group rate discounts.

Kevin Feasel

R for the Data Professional

Presenter

Kevin Feasel is a database engineer and Microsoft Data Platform MVP who specializes in T-SQL and SSIS development, Hadoop, performance tuning, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (curatedsql.com) and a contributing author to Tribal SQL (www.tribalsql.com). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.
Kevin Feasel is a database engineer and Microsoft Data Platform MVP who specializes in T-SQL and SSIS development, Hadoop, performance tuning, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (curatedsql.com) and a contributing author to Tribal SQL (www.tribalsql.com). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.

Course

In this day-long training, you will learn about R, the premiere language for data analysis.  We will approach the language from the standpoint of data professionals:  database developers, database administrators, and data scientists.  We will see how data professionals can translate existing skills with SQL to get started with R.  We will also dive into the tidyverse, an opinionated set of libraries which has modernized R development.  We will see how to use libraries such as dplyr, tidyr, and purrr to write powerful, set-based code.  In addition, we will use ggplot2 to create production-quality data visualizations.

Over the course of the day, we will look at several problem domains.  For database administrators, areas of note will include visualizing SQL Server data, predicting error occurrences, and estimating backup times for new databases.  We will also look at areas of general interest, including analysis of open source data sets.
In this day-long training, you will learn about R, the premiere language for data analysis.  We will approach the language from the standpoint of data professionals:  database developers, database administrators, and data scientists.  We will see how data professionals can translate existing skills with SQL to get started with R.  We will also dive into the tidyverse, an opinionated set of libraries which has modernized R development.  We will see how to use libraries such as dplyr, tidyr, and purrr to write powerful, set-based code.  In addition, we will use ggplot2 to create production-quality data visualizations.

Over the course of the day, we will look at several problem domains.  For database administrators, areas of note will include visualizing SQL Server data, predicting error occurrences, and estimating backup times for new databases.  We will also look at areas of general interest, including analysis of open source data sets.

Eventbrite - R For the Data Professional

Alex Grinberg

Black Belt for the Database Administrator

Presenter

Alex Grinberg is a senior SQL Server DBA with more than 20 years of IT experience. He has been working on Microsoft SQL Server products since version 6.5. Alex is currently working in the Pennsylvania branch of Cox Automotive, headquartered in Atlanta, GA. His primary focus is to provide architecture, tuning, optimization, analysis, operational and development services, create new applications, convert legacy technologies (SQL Server, VB.NET and C# ) and provide on-site training with the latest Microsoft technologies including .NET (VB and C#), SSRS, SSIS. Alex is a frequent speaker at professional IT events, including SQLSaturdays, Code Camps, SQL Server User Groups, and other industry seminars, where he shares his cumulative knowledge. He is the guest author for SQLServerCentral.com and is also the co-founder of HexaArt inc., an IT consulting services company for small and mid-size corporations.
Alex Grinberg is a senior SQL Server DBA with more than 20 years of IT experience. He has been working on Microsoft SQL Server products since version 6.5. Alex is currently working in the Pennsylvania branch of Cox Automotive, headquartered in Atlanta, GA. His primary focus is to provide architecture, tuning, optimization, analysis, operational and development services, create new applications, convert legacy technologies (SQL Server, VB.NET and C# ) and provide on-site training with the latest Microsoft technologies including .NET (VB and C#), SSRS, SSIS. Alex is a frequent speaker at professional IT events, including SQLSaturdays, Code Camps, SQL Server User Groups, and other industry seminars, where he shares his cumulative knowledge. He is the guest author for SQLServerCentral.com and is also the co-founder of HexaArt inc., an IT consulting services company for small and mid-size corporations.

Course

In the modern world of information technology, keeping data stored and manipulated reliably and efficiently is one of the top priorities.

Within the last decade, SQL Server has evolved into a sophisticated Enterprise RDBMS tool, and it is still growing by providing more functionalities to store and manipulate data reliably. PowerShell, CLR integration, eXtensible Markup Language (XML) is one of the technologies that SQL Server implements not only for data manipulation but also for internal usage, such as Execution Plans, Extended Events, DDL trigger Eventdata() function, monitoring a server instances, and behind-the-scenes construction for SQL Server Business Intelligence Tools (SSIS, SSRS, SSAS). PowerShell, CLR integration.

XML skills often appear in SQL Server DBA job requirements because the ability to work with those allow the DBA to be faster and more efficient when solving different types of problems. Also, this session will cover JSON for SQL Server.

Eventbrite - R For the Data Professional

Guy Glantser

SQL Server Query Performance Tuning

Presenter

Guy Glantser, Data Platform MVP, is the leader of the Israeli PASS chapter and also the CEO and founder of Madeira Data Solutions. His career has been focused around data for the past 20 years, performing various roles as either an on-site DBA, an external consultant or a speaker. Guy is involved in many activities in the data community. He occasionally speaks at community events, such as PASS Summit, SQLBits, SQL Saturdays and user groups around the world. He also co-hosts the SQL Server Radio podcast.

Course

You identified a query that is causing performance issues, and your mission is to optimize it and boost performance. You looked at the execution plan and created all the relevant indexes. You even updated statistics, but performance is still bad. Now what?

In this pre-conference session we will analyze common use cases of poorly performing queries, such as the improper use of scalar functions, inaccurate statistics and bad impact of parameter sniffing. We will learn through extensive demos how to troubleshoot these use cases and how to boost performance using advanced and practical techniques.
The topics in this session are relevant for SQL Server versions 2005 through 2017. We will also demonstrate some of the new features introduced in the latest versions of SQL Server, such as Adaptive Query Processing. At the end of the session, you'll have a list of tips and techniques to apply in your environment.

Eventbrite - R For the Data Professional

Event Location

Event news

SQLGrease Sponsorship Read More

RedGate Sponsorship! Read More

CommerceHub Sponsorship! Read More

Contact

Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us


What is 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.

Back to Top cage-aids
cage-aids
cage-aids
cage-aids