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, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.
Parking & Venue Maps
We are offering two all-day pre-conference sessions on 2/3/17 at Hyland Software. Tickets are $150 for early birds (before 1/21/17), and are $175 after that. Click on the session title below for a full agenda\outline and additional details for each session.
Adam Machanic - Tuning Your Biggest Queries
Today's database workloads are all about bigger, better, and more: bigger data, better analytics, and more insights. While these improvements can be great for your business users, on the technology side they often translate into large, lumbering queries that monopolize the server and test the patience of even the calmest of analysts. This full-day seminar is specifically designed to help you tune these extra tough queries. The day begins by establishing a solid foundation for reading and understanding how query plans work, and what is and is not important to pay attention to when reading a plan. Next you will learn about plan shaping: types of query rewrites that work, which rewrites are bound to fail, and the various query hints you might want to leverage in especially difficult situations. Real-world application of these techniques will be covered with a discussion around how to understand what kind of plan is ideal given the particulars of a situation, and the introduction of an approach to help you analyze and fix even the biggest query plans. The day concludes with a look at various indexing strategies and patterns--both common and alternative, including a look at the applicability of columnstores in SQL Server 2016 and beyond. You will leave the class armed with an array of tools and ideas to help you tame even the biggest queries in your environment.
About the Presenter:
Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "T-SQL Querying" (Microsoft Press, 2015) and "SQL Server 2008 Internals" (Microsoft Press, 2009). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.
Ginger Grant - Data Analytics with SQL Server 2016, R, & Power BI
Advanced data analytics does not live only in the realm of data scientists. The necessary tools now exist in SQL Server 2016 to perform advanced analytical analysis with R. This session aims to demystify data science by showing how to create advanced analytical functions and display the results. These techniques can be applied to perform in-depth analysis on practical things like improving database monitoring. The ability to create predictive models for server performance load, determining when disk space will be required, and impact analysis of performance tuning tasks are some of the examples which will be covered in this session.
About the Presenter:
Ginger Grant started working in business intelligence for a number of industries including transportation, insurance, and healthcare. Looking for answers in data led to advanced analytics and data science, where she currently creates systems to provide solutions to data questions. An active member of the data community, she is a Microsoft VTSP and MVP in Data Platform and regularly blogs at DesertIsleSQL.com.