SQLSaturday 526

Rochester, United States

PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. This event will be held on May 14 2016 at Rochester Institute of Technology, 1 Lomb Memorial Drive, Rochester, New York, 14623, United States

Register Now

Welcome to Rochester's 5th Annual SQLSaturday!

Free* SQL Server training! Chance to win great prizes! What more could a SQL Server Professional ask for? If this sounds good to you then don’t miss your opportunity to attend SQL Saturday #526, the largest FREE* training event dedicated exclusively to SQL Server Administration, Development and Business Intelligence to hit Rochester, NY.  

* There is a modest $10 fee for lunch.

SQLSaturday Rochester (#SQLsatROC)? What is it? Why should you sacrifice a Saturday in Upstate NY? When is it? Where is it? How do I get involved? Let us fill you in.

What: This is a one day training event for SQL Server (BI, DBA & Developer) professionals and those wanting to get some intensive technical learning.

Why: It is a great opportunity to learn from people who have been there and to network with other professionals doing the same thing you are doing. This professional level training and networking can set yourself apart from others!

When: Saturday, May 14th, 2016. Register online now to reserve your spot. Attendee check-in will begin at 8:00 AM and run through 8:45 AM. The first sessions start at 8:45 AM.

Where: Golisano Hall at Rochester Institute of Technology, 1 Lomb Memorial Drive, Rochester, NY 14623. A map of the campus can be found here.  Parking for the event will be in the J Lot and the T Lot.

How: All you have to do is register online to reserve your spot, drop in on Saturday and attend the sessions you like.

So what are you waiting for? Register today to be a part of SQLSaturday #526!

Pre-Conference Sessions

SQL Saturday Rochester is pleased to bring you three pre-conference sessions on Friday, May 13th!

Full-Day Session: 50 Things All SQL Server Developers Need to Know

What are the most problematic patterns and anti-patterns that trip up SQL Server developers on a daily basis? What sort of SQL and Transact-SQL challenges does every SQL Server developer encounter at some point in their career? This full-day, pre-conference seminar takes a tour of the most common and challenging issues that database developers face. Learn how to conquer them in the lab today so that they won’t take you surprise in the future.  Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.

In this session, you'll learn:
  1. Internal operations of the SQL Server query optimizer and caching mechanisms and their impact on T-SQL code performance, including ways to shortcut default behavior using trace flags.
  2. Tricks, techniques, and metadata analysis needed to make T-SQL code, including queries and stored procedures, achieve top performance and maximum reliability.
  3. A variety of patterns and anti-patterns in T-SQL coding that are common challenges for all but the most advanced database developers.
With these 50 tricks and techniques in your coding toolkit, you’ll be able to write T-SQL code that consumes less system CPU, memory, and IO, while being easier to maintain and offering faster performance.

Presenter: Kevin Kline
Kevin Kline is a database expert and Technology Evangelist at SQL Sentry, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS, author of many books, blogger, columnist, and popular international speaker. Kevin's best known book is the best-selling "SQL in a Nutshell" and contributes monthly for Database Trends & Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/KevinKline.

For more information or to register for this pre-con, visit Eventbrite registration

Half-Day Session 1: Porting existing .NET Applications to Always Encrypted

This will be a half day Precon on how to port an existing database to use Always Encrypted features. We will cover the following:
  • How to setup Always Encrypted
  • Migration considerations (e.g varchar column collations will have to change to binary)
  • Key management
  • Schema Management in Source Control
A sample ASP.NET MVC application that makes uses of Code First EF, Database First EF, and vanilla ADO.NET calls will be provided to all participants and we will migrate appropiate columns to an Always Encrypted state.

Presenter: Justin Dearing
Justin Dearing has been working in IT since 2002. He started as a night shift AS/400 operator and rose through the ranks at a series of companies.
He currently works as a developer for Alan Seiden Consulting. Justin has served in both the development and production side of the house on Windows, Unix and Midrange Platforms. His database experience includes MongoDB, MySQL, Postgres and Microsoft SQL server. These days he programs in C#, PowerShell and Python and PHP.
Justin has trained individuals and teams in companies in three countries on various aspects of software development.

For more information or to register for this pre-con, visit Eventbrite registration

Half-Day Session 2: Getting Started with Power BI
Analysis Services Maestro, SQL Server MVP and Business Intelligence Architect Bill Pearson leads this half-day, hands-on introduction to using Power BI to deliver self-service business intelligence.  The focus of the course is to help those unacquainted with the features that debut in Power BI to become familiar with the assembly of data from diverse sources into data models that deliver BI upon demand, and to leverage current features for enhanced analysis and reporting.

Participants will gain exposure to accessing and relating data, and to employing the Data Analysis Expressions (DAX) language, to construct and share Power BI applications that support analysis and reporting throughout the enterprise.    We will overview both Power BI Desktop and the Power BI service (PowerBI.com), as well as delve into the Power Query components, and visualization and reporting options, within the context of each.  The course provides an introduction to Data Analysis eXpressions (DAX), within the perspective of Power BI, and an exploration of dashboards and many other features of the rapidly evolving Power BI suite of tools.

Presenter: Bill Pearson

Bill Pearson, SSAS Maestro and SQL Server MVP, CPA, CITP, CGMA, CMA, CIA, MCDBA, MCSE, is a consultant, author, mentor and business intelligence architect who has been working with business intelligence for over 20 years, and with the integrated Microsoft Business Intelligence solution since its inception.  Bill has been awarded the Microsoft Most Valuable Player multiple times for his technical experience implementing Microsoft BI, as well as his contributions to various communities as an author and speaker.  Bill’s recent series’ include the Stairway to MDX and Stairway to DAX and Power BI columns at SQLServerCentral.com, and he presents regularly at SQL Saturdays and other, diverse events worldwide.

For more information or to register for this pre-con, visit Eventbrite registration

Half-Day Session 3: Designing SQL Server HA/DR Infrastructure to meet the SLA
Most DBA's rarely establish Service Level Agreements (SLA) with the Management and if they do they sometimes just come up with some random numbers for availability. Then when at some point something goes really wrong everybody wonders why it takes so long to bring everything back online.
This Session will teach you how to ask the right questions, analyze your databases and servers and write a realistic SLA.
Once we have the SLA defined you will learn how to combine HA/DR features SQL Server has to offer to build infrastructure that will meet the SLA.
The surprising twist comes when you learn it's not just the infrastructure. The operating procedures and how the databases is used and maintained might play an even bigger role in the SLA than the technology.

Presenter: Thomas Grohser

Thomas Grohser for the past 21+ years has spent most of his time exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical and financial services industries. His primary focus is to architect, plan, build and operate reliable, highly available, secure and scalable infrastructures for SQL Server. Over the years he managed thousands of SQL Server instances processing trillions of rows taking up petabytes of storage. Thomas is a Microsoft Data Platform (former SQL Server) MVP.

For more information or to register for this pre-con, visit Eventbrite registration

Event Location

Event news

Our half-day pre-con session "Designing SQL Server HA/DR Infrastructure to meet the SLA" with Thomas Grohser is live! Check out the full details, including registration link, on our event homepage Read More

Our Saturday schedule is now live! Read More

Our half-day pre-con session "Getting Started with Power BI" with Bill Pearson is live! Check out the full details, including registration link, on our event homepage Read More


Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us

What is a PASS SQLSaturday?

PASS SQLSaturdays are local events organized by PASS community members around the world. PASS is a not-for-profit association for data professionals who leverage the Microsoft Data Platform, offering interactive learning built by community and guided by trusted data experts.

Back to Top cage-aids