SQLSaturday #631 - Wausau 2017

Event Date: 09/16/2017 00:00:00

Event Location:

Northcentral Technical College
1000 W Campus Dr
Wausau, Wisconsin

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: Automated Restore Script Output for Ola Hallengren’s Maintenance Solution

Abstract: This session is designed to be useful to two different audiences: 1.Those implementing Ola Hallengren’s Maintenance Solution for the first time. (Or don’t even know what the Maintenance Solution is!) 2.Those that have been using it for awhile, but might have a hole in their DR plan – what to restore when a resource goes offline.

We will do an overview of the maintenance solution to start, then get down and dirty with the guts of the extension. What I am presenting is a custom extension that works out of the box for jobs created using the maintenance solution. The scripts will add an additional job step to all DatabaseBackup jobs which will output a text file that contains the most current restore scripts for each database in the instance. If you don’t know what I just described in that last paragraph, you should come to this session and that will be explained as well!

Speaker(s):

Jared Zagelbaum

Track and Room: Database Administration - Advanced - CBI110

Title: What is new in SQL Server 2016 for DBAs?

Abstract: SQL Server 2016 was released in June 2016 with tons of new features. When Service Pack 1 was released in November 2016, many of the Enterprise level features were allowed in lower editions of SQL server 2016. Microsoft made sure everyone got something out from an upgrade to SQL Server 2016. In this session, you will get an overview of several of the new features in SQL Server 2016. It will cover Dynamic Data masking, Row Level Security, Always Encrypted, Temporal tables and time permitting few more goodies. This is a high-level overview session on advanced features of SQL Server 2016 and therefore we will not be going deep into any one technology. My goal is to inspire you to take action and play with new features of this great product.

Speaker(s):

Ameena Lalani

Track and Room: Database Administration - Advanced - E101 (The Sentry Room)

Title: Get Your Optimizer to Give up All Its Secrets

Abstract: You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated? In this session, we will examine details the query optimization process that are not very well known. We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient. Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos? We’ll do just that, and then take it a step further with a unique visualization tool that I have created. With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn’t do it as well as might be hoped), you can write more efficient SQL statements.

Speaker(s):

Brian Hansen

Track and Room: Database Administration - Advanced - E101 (The Sentry Room)

Title: How to Keep Your Databases Secure in Just Minutes a Day

Abstract: You’re busy. You don’t have time to check the security of your systems all the time, right? It’s not like anyone has added a user that you don’t know about. And no one would create a database and add all logins to the db_owner role. And of course, no one would ever think of setting the TRUSTWORTHY property on a database… right?

Things like that happen on a daily basis, poking holes in even the most well-secured database. Those holes are just waiting for someone to find them. That someone could be you, or it could be an attacker probing for a way to get data from your company.

In this session, we will explore how to create reports that are quick to review so you can find the holes before someone else does - without interfering with the rest of your day. Along the way, you’ll also learn where to find security-related information in SQL Server’s metadata and logs to allow you to customize and extend the reports to meet your company’s unique needs.

Speaker(s):

Ed Leighton-Dick

Track and Room: Database Administration - Advanced - CBI124

Title: Navigating Modern BI Infrastructure – Power BI Report Server (On-

Abstract: Business Intelligence has sat pretty comfortably on the same laurels for well over a decade however that landscape has been disrupted by the surfacing new Azure tools, Power BI, and now Power BI on premise. With so many new tools and features, things can get pretty intimidating, especially for those with additional considerations and regulations. It can, however, open new doors to organizations who were previously unable to fully utilize BI. Through presentation, demo, and open discussion we attempt to navigate classic BI Architecture and the available options there in, as well as touch upon the future of BI and modern architecture.

Speaker(s):

George Bryant

Track and Room: Business Intelligence Development - CBI107

Title: Set Me Up: How to Think in Sets

Abstract: SQL Server is optimized to work in sets, but this is certainly a paradigm shift for someone accustomed to row-by-row operations.

We will look at T-SQL features that can break set-based processing – generally meaning poor performance – and gather empirical evidence to support that assertion. We’ll also look at some constructs to overcome these issues and make your T-SQL scripts run faster and use fewer resources.

Speaker(s):

Brian Hansen

Track and Room: Database Administration - Beginner - E101 (The Sentry Room)

Title: Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)

Abstract: As DBAs, we are asked all sorts of impossible questions. Who dropped that important table last month? Why was everything slow last week? Who made that user a sysadmin? You’d have to be a mind reader to know the answers to some of those, right? Not necessarily! SQL Server can help you find information about these and other common problems with its default trace and system_health Extended Events session, but you have to know how to collect and interpret the data they provide. In this session, we’ll explore what system_health and the default trace are, what information they contain, and how to use them to find the answers you’re searching for.

Speaker(s):

Ed Leighton-Dick

Track and Room: Database Administration - Advanced - CBI124

Title: Anatomy of a Transaction

Abstract: In SQL Server, the transaction log is the most important file in any database. All changes to the data and schema are tracked in the transaction log. Join me to learn how to read the transaction log, how to follow a transaction as is processes, and how SQL Server handles a transaction rollback. You will also learn how to identify the resources and objects SQL Server accesses during the course of the transaction. Finally, you will see how SQL Server processes transactions for In-Memory tables.

Speaker(s):

Frank Gill

Track and Room: Database Administration - Advanced - CBI124

Title: Visualize Your Transaction Log

Abstract: The SQL transaction log can be a mystery to many DBAs. We live in the age of visualizations, so let’s visualize the log! In this session, we will examine the purpose and organization of the transaction log and will explore the log through a unique visualization tool. We will consider common performance issues that are related to the logging mechanism and how to overcome these problems. Finally, we will discuss some techniques to monitor the log so that potential performance problems can be addressed pro-actively.

Speaker(s):

Brian Hansen

Track and Room: Database Administration - Beginner - E101 (The Sentry Room)

Title: Free SQL Server Tools

Abstract: Everybody loves a free lunch. Come to this session to learn about all the SQL Server freebees.

Speaker(s):

Cecil Spivey

Track and Room: Professional Development - CBI107

Title: Learn History from Temporal Tables

Abstract: SQL Server 2016 came out with a bucket full of cool new features. One of them is Temporal Tables. They are basically history tables of the normal tables; that allow us to retrieve data from any point in time for every change such as updates and deletes. It does this all without any change to application code and without using any behind the scene triggers. In this session, we will see what the requirements of creating temporal tables are. We will see the demo on insert and update functionality and how to query historical information using new TSQL clause. It has lots of demos and less theory.

Speaker(s):

Ameena Lalani

Track and Room: Database Administration - Advanced - E101 (The Sentry Room)

Title: How to Get Microsoft Certified

Abstract: Microsoft has recently streamlined the certification process and this session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for success.

Speaker(s):

John Deardurff

Track and Room: Professional Development - H101 (Beyond Impact Room)

Title: SSAS: What is it and How do I get started using it

Abstract: This session with provide a high level overview of what SQL Server Analysis Services is and what you need to know to get started. It will cover the fundamentals of Dimensions, Measures, how to view the data as well as the role of SSAS in the enterprise. The sessions with also provide a few scenarios demonstrating the benefits of using SSAS.

Speaker(s):

Dave Bland

Track and Room: Business Intelligence Development - CBI109

Title: Building Your First Data Warehouse

Abstract: Ever wonder about those mysterious databases that are full of data? Curious about what’s inside, or how they are built? Follow along in this session as we build a data warehouse from scratch. Learn about fact tables, dimension tables, measures, and attributes as we work through a small data warehouse using Microsoft’s newest sample database. In this beginner level session, we will talk about data warehouse concepts, build a small data warehouse with a fact table and several dimensions, and implement an ETL process using T-SQL and stored procedures.

Speaker(s):

Jesse Seymour

Track and Room: Business Intelligence Development - CBI109

Title: The SQL Server Transaction Log for Developers

Abstract: SQL Server tracks all changes to a database’s data and schema in the transaction log. This makes it the most important file in any database. Understanding transaction log architecture and behavior will help you develop code that will maximize performance and minimize resource consumption. Join me to learn about transaction log architecture , batching transactions, rollback activity, and the effect these things can have on performance.

Speaker(s):

Frank Gill

Track and Room: Database Administration - Beginner - CBI107

Title: How to use Execution Plans to find Performance Issues

Abstract: This is a introductory session on how a DBA and developers can use Execution plans to find performance bottlenecks. This will cover the fundamentals and cover some of the basic techniques that can be used to find hidden performance problems.

Speaker(s):

Dave Bland

Track and Room: Database Administration - Beginner - CBI109

Title: Processing Big Data with Azure Data Lake Analytics

Abstract: In this session of Getting Started with Azure Data Lake Analytics, we will learn the fundamentals of designing a Data Lake, how that fits into your organization, and then spend most of the time processing data with Data Lake Analytics in U-SQL.

Speaker(s):

Sean Forgatch

Track and Room: Business Intelligence Development - H101 (Beyond Impact Room)

Title: Creating an Azure SQL Database Using PowerShell

Abstract: Azure SQL Database provides an environment to quickly build SQL Server databases. This allows for testing of new versions and functionality with minimal effort. PowerShell provides cmdlets that create, configure and deploy an Azure SQL Database quickly and easily. Additionally, cmdlets exist to tear the environment down once you are done with it, Join me to learn more about the options available for scripting and automating the build of an Azure SQL Database.

Speaker(s):

Frank Gill

Track and Room: Server Administration - CBI107

Title: QA with SQL Experts

Abstract: Come chat with our panel of SQL experts for an hour long QA session. From DBA 101 to advanced internals, any question is fair game!

Speaker(s):

Krista Olson

Track and Room: Business Intelligence Development - CBI110

Title: SQL Server 2016 - New Security Features

Abstract: Per Microsoft, SQL Server 2016 “is the biggest leap forward in Microsoft’s data platform history with real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technology, and new hybrid cloud scenarios.” There’s a ton of ground to cover on all of the new enhancements, so this session will focus on some of the new advanced security offerings that Microsoft has incorporated into the platform: Dynamic Data Masking, Row-Level Security, and Always Encrypted.

Speaker(s):

Jared Zagelbaum

Track and Room: Database Administration - Advanced - CBI110

Title: Index 360 - Looking at Indexes from Multiple Perspectives

Abstract: If you have used a database, chances are almost certain you’ve utilized indexes as well. In this presentation I will discuss both Rowstore and Columnstore Indexes and why they are important to anyone that interacts with a database. This session will cover what they are, how they are utilized, how best to take advantage of them, and even when they can be problematic. It is my intention to help anyone become more comfortable with indexes and understand what they can do for you and your role, be it a DBA, Developer, or BI Professional.

Speaker(s):

John Eisbrener

Track and Room: Database Administration - Advanced - CBI110

Title: Extended Events: What are they and How do I use them

Abstract: Since Extended Events are replacing Profiler, every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session. This session will give someone who has never used Extended events before the skills to start using them!

Speaker(s):

Dave Bland

Track and Room: Other - CBI109

Title: SSAS Tabular in 60 mins: Developing Business-Driven Self-Service BI

Abstract: In this session we’ll develop a Tabular Data Model in MS SSAS and review our options for deploying, sharing and visualizing it. Well also discuss how senior leaders will see the business value of SSAS and how end users can utilize it for Self-Service Business Intelligence.

Speaker(s):

Wylie Blanchard

Track and Room: Business Intelligence Development - H101 (Beyond Impact Room)

Title: MS SSAS Business Value: Should I choose Tabular or Multidimensional?

Abstract: Determine which model presents the right business value for your company’s analytical needs. In this session we’ll discuss the difference between SSAS Tabular and SSAS Multidimensional modes, feature differences as well as the benefits and cons to utilizing both modes in MS SQL Server 2016.

Speaker(s):

Wylie Blanchard

Track and Room: Data Analysis - H101 (Beyond Impact Room)

Title: I Know SQL Server, but want to become a great DBA - What do I need to know?

Abstract: This session will cover what is needed to transition from someone who knows SQL Server to becoming a great DBA. It will cover what technical skills are needed, how to think like a great DBA and explore some of the functionality of SQL Server that can help all DBAs do their job. The presenter will share of the his experiences of his journey to go from a trainer to a successful DBA.

Speaker(s):

Dave Bland

Track and Room: Professional Development - CBI109

Title: Protecting Your Data with Encryption

Abstract: We’ve all seen the recent news stories about companies whose data has been stolen by hackers. What was once a rare event has become all too common, and companies large and small are at risk. While it isn’t always possible to prevent intrusions, you can reduce the risk by encrypting your data. In this presentation, I’ll show you the four ways that SQL Server provides to encrypt data: hashes, cell-level encryption, database-level encryption (also known as transparent data encryption), and backup encryption. We’ll also discuss the keys required for each type of encryption and discuss how to protect the keys themselves.

Speaker(s):

Ed Leighton-Dick

Track and Room: Database Administration - Beginner - CBI124

Title: Problem Solving With The In-Memory Engine

Abstract: There is a vast array of material in the SQL Server community that covers the in-memory engine in great detail, this session will cover some of the internals of the in-memory engine, however what it will also do is fill in the void as to common performance issues and how they can be solved with the in-memory engine, specifically:

Staging data as fast as possible
Turbo charging scalar aggregate functions
Implementing a scalable sequence
Overcoming the performance limitations of temporary tables
Making the critical path in your code base run faster

Speaker(s):

Christopher Adkin

Track and Room: Database Administration - Advanced - CBI110

Title: JSON for the Data Mortals

Abstract: In SQL Server 2016 Microsoft has include native handling of JSON. What does that mean? What is JSON? Why do I care? Will there be knives and hockey masks? Come to this session and you will learn what JSON is, where and how it is used and why as a data professional you need to know this.

Speaker(s):

Jim Dorame

Track and Room: Other - CBI110

Title: Understanding SQL Server 2016 Always Encrypted

Abstract: Always Encrypted is a highly-touted new feature of SQL Server 2016 that promises to make encryption simple to use and transparent to applications while still protecting the data both at rest and in motion, even from high-privilege users such as developers and DBAs. Does that sound too good to be true? It isn’t - Always Encrypted is an incredible feature - but like any new technology, it does have some limitations. In this session, you’ll see how to configure Always Encrypted, and we’ll talk about when you should and shouldn’t use it in your environment.

Speaker(s):

Ed Leighton-Dick

Track and Room: Database Administration - Beginner - CBI124

Title: The PROCESS of Queries

Abstract: This session is for the absolute beginner to learn the terminology and the PROCESS of queries. This includes how queries are Parsed, Resolved, Optimized, Compiled and Executed. We will see how this effects Batches, Transactions, and Errors. We will also briefly discuss table structures and the differences between Heaps and Clustered Indexes. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses.

Speaker(s):

John Deardurff

Track and Room: Database Administration - Beginner - H101 (Beyond Impact Room)

Title: Intro to Machine Learning

Abstract: Come to this session to get your toes wet with machine learning. What types of questions it can answer? What types of models it can produce? What are some techniques used? There will be practical demos using Azure Machine Learning as well. Enough info to get you started, or enough to quit while you’re ahead, either way, you’ll come out with some concrete ideas of what ML is all about.

Speaker(s):

Jared Zagelbaum

Track and Room: Business Intelligence Development - CBI110

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Frank Gill

Twitter: - skreebydba

LinkedIn: Frank Gill

Contact: http://skreebydba.com/

Frank Gill is a Senior Data Engineer at Concurrency With 21 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. Over the past several years, he has worked extensively with SQL Server solution in Azure, including Managed Instance. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.

Dave Bland

Twitter: - @SQLDave29

LinkedIn: Dave Bland

Contact: https://www.davebland.com

Over 20 years of SQL Server experience that includes being a DBA, BI development and Application development using VB.NET. Dave currently is the Manager of the DBA team at Stericycle. Dave is a Friend of Red-Gate for 2019. He is a frequent presenter at SQLSaturday events and user groups around the country. Has been teaching SQL Server since version 2000 and is the SQL Server instructor at Harper College in Palatine, IL. Current certifications include: • Microsoft Certified Trainer • MCTS: SQL Server 2008, Implementation and Maintenance • MCTS: SQL Server 2008, BI Development and Maintenance • MCSA: SQL Server 2008 • MCSA: SQL Server 2016 • MCSE: SQL Server 2016 - BI • MCDBA: SQL Server 2000 • MCSD • MCSE: Data Management and Analytics

George Bryant

Twitter: - Azure_George0

LinkedIn: George Bryant

George has over a decade of experience in the Business Intelligence industry and is an active member of the BI community across the Midwest. His knowledge spans multiple industries including, retail, manufacturing, finance, and medical, however recent years has seen him focus on the analytics in sports.

George specializes in BI architecture and end to end development in order to deliver advanced analytics and metrics to multiple organizations across the country. In recent years George has focused on and worked primarily in the Azure cloud, utilizing both established and recent offerings.

Dave Bland

Twitter: - @SQLDave29

LinkedIn: Dave Bland

Contact: https://www.davebland.com

Frank Gill

Twitter: - skreebydba

LinkedIn: Frank Gill

Contact: http://skreebydba.com/

Dave Bland

Twitter: - @SQLDave29

LinkedIn: Dave Bland

Contact: https://www.davebland.com

Jesse Seymour

Twitter: - https://twitter.com/jessebizint

LinkedIn: Jesse Seymour

Contact: http://www.jesseseymour.com

Jesse Seymour is a business intelligence hack of all trades. From data warehousing to report writing, Jesse Seymour is responsible for the complete business intelligence environment of the Forest County Potawatomi. In his free time, Jesse is one of the chapter leaders of WausauPASS, Wisconsin’s newest PASS chapter. Involved in IT since the age of 16, Jesse Seymour has played nearly the entire field of information technology, with over three years experience in business intelligence and over five years experience in Microsoft SQL Server.

John Deardurff

Twitter: - SQLMCT

LinkedIn: John Deardurff

Contact: https://www.sqlmct.com

John has been a Microsoft Certified Trainer (MCT) for over 20 years teaching Azure, SQL Server, Exchange Server, and Windows Server networking courses. He is currently a SQL Premier Field Engineer for Microsoft. He is an MCT Regional Lead for the Eastern United States and a former Data Platform MVP.

John Eisbrener

Twitter: - @johnedba

LinkedIn: John Eisbrener

Contact: http://www.dbatlas.com

John is a DBA (Default Blame Assignee) with over a decade of experience breaking and subsequently fixing, database solutions. He maintains separate swear jars for Oracle, Postgres, and Greenplum, but keeps the largest container reserved for SQL Server. When not accumulating loose change for his children’s college funds, John can be found trying to help others with their database solutions as the Principal Consultant for DB Atlas, speaking at various SQLSaturdays throughout the Midwest, or helping out with his local PASS chapter meetings in Madison, WI.

Wylie Blanchard

Twitter: - WylieBlanchard1

LinkedIn: Wylie Blanchard

Contact: https://WylieBlanchard.com/?utm_source=sqlsaturday.comutm_medium=profileutm_campaign=website

Wylie Blanchard, MCSE is an IT consultant, SQL Server professional and web strategist who enjoys helping people learn how to use technology as a tool to amplify their professional lives. He has 15+ years of experience in the IT Industry and holds several certifications in SQL and Oracle systems. He is a father of twin-girls, a gadget enthusiast and a self-proclaimed pizza connoisseur. Learn more about Wylie at: www.WylieBlanchard.com.

Jared Zagelbaum

Twitter: - @JaredZagelbaum

LinkedIn: Jared Zagelbaum

Contact: https://jaredzagelbaum.wordpress.com

With over 10 years of experience using the Microsoft Data Platform suite, Jared’s main areas of focus include data lake architecture, machine learning, and application embedded analytics. Jared regularly speaks at user groups and events across the Midwest, as well as blogs and provides technical review for SQL Server publications.

Ed Leighton-Dick

Twitter: - eleightondick

LinkedIn: Ed Leighton-Dick

Contact: http://www.edleightondick.com

Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.

John Deardurff

Twitter: - SQLMCT

LinkedIn: John Deardurff

Contact: https://www.sqlmct.com

Ameena Lalani

Twitter: - SQLHands

LinkedIn: Ameena Lalani

Ameena Lalani is a SQL Server veteran and started her journey with SQL Server 2000. She is a Microsoft Certified Solution Associate on SQL Server 2016 and also hold Azure Administrator Associate certification. Ameena works at Microsoft as a Premier Field engineer. She has implemented numerous High Availability and Disaster Recovery solutions at various companies. Ameena loves to share her technical knowledge and speaks at local user groups and SQLSaturday events throughout the United States.

Christopher Adkin

Twitter: - ChrisAdkin8

LinkedIn: Christopher Adkin

Contact: http://www.chrisadkin.io

Chris is a freelance SQL consultant who has been working with SQL Server since 2000, his passion is for squeezing every last drop of performance out of SQL Server and understanding the database engine at a level which conventional tools cannot provide any insights on.

Jim Dorame

Twitter: - @DBAJD

LinkedIn: Jim Dorame

Contact: http://www.jamesdorame.com/

Jim Dorame has been working with SQL Server for over 20 years. Over those years he has learned a great deal from the SQL community. He has also given back to the community in the hopes that he may help someone in their career. He is always looking for something to learn and luckily Microsoft keeps adding to SQL Server.

Dave Bland

Twitter: - @SQLDave29

LinkedIn: Dave Bland

Contact: https://www.davebland.com

Wylie Blanchard

Twitter: - WylieBlanchard1

LinkedIn: Wylie Blanchard

Contact: https://WylieBlanchard.com/?utm_source=sqlsaturday.comutm_medium=profileutm_campaign=website

Jared Zagelbaum

Twitter: - @JaredZagelbaum

LinkedIn: Jared Zagelbaum

Contact: https://jaredzagelbaum.wordpress.com

Ed Leighton-Dick

Twitter: - eleightondick

LinkedIn: Ed Leighton-Dick

Contact: http://www.edleightondick.com

Brian Hansen

Twitter: - tf3604

Contact: http://www.tf3604.com

Brian is a database administrator at Children International in Kansas City. He has been working with SQL Server technologies since 1998, including roles in report development, application development and database administration.

Frank Gill

Twitter: - skreebydba

LinkedIn: Frank Gill

Contact: http://skreebydba.com/

Cecil Spivey

Cecil is a DBA Engineer in the Twin Cities. He has been working in IT for over 20 years and was a consultant and a programmer/developer for many years until he was converted to the dark side.

Ed Leighton-Dick

Twitter: - eleightondick

LinkedIn: Ed Leighton-Dick

Contact: http://www.edleightondick.com

Ameena Lalani

Twitter: - SQLHands

LinkedIn: Ameena Lalani

Krista Olson

Krista has been a DBA for over 20 years starting with SQL Server 6.5 and all versions since. She has worked with databases up to TBS in size, and managed over 450 servers with her creative and over technical counterparts on her team. She has her MCP in database administration. When not being a DBA you can find her on or in the water as a Wisconsin Lake Leader and president of McDill Lake District.

Brian Hansen

Twitter: - tf3604

Contact: http://www.tf3604.com

Sean Forgatch

Twitter: - 4gatchsql

LinkedIn: Sean Forgatch

Contact: https://www.modern-dataengineering.com

Sean Forgatch is a Manager in Data Engineering consulting Avanade\Accenture based out of Chicago, IL focusing on Data Strategy, EIM , and Data Archtiecture. Serving multiple Fortune and Global 500 companies he has helped push the limits of Azure and is working on some of the largest Azure Data Lake and Analytics implementations in the industry. He has spoken at over 25 conferences across the United States since 2016, was the President of the Northeast Wisconsin PASS, and served on the board for SQLSaturday Madison.

Originally from Southern Illinois, Sean enjoys running and lifting, as well as casual conversations with coffee, and spending time with his dog Sailor, an all white Siberian Husky.

Jared Zagelbaum

Twitter: - @JaredZagelbaum

LinkedIn: Jared Zagelbaum

Contact: https://jaredzagelbaum.wordpress.com

Ed Leighton-Dick

Twitter: - eleightondick

LinkedIn: Ed Leighton-Dick

Contact: http://www.edleightondick.com

Brian Hansen

Twitter: - tf3604

Contact: http://www.tf3604.com

SQLSaturday #631 - Wausau 2017

Sessions

Title: Automated Restore Script Output for Ola Hallengren’s Maintenance Solution

Title: What is new in SQL Server 2016 for DBAs?

Title: Get Your Optimizer to Give up All Its Secrets

Title: How to Keep Your Databases Secure in Just Minutes a Day

Title: Navigating Modern BI Infrastructure – Power BI Report Server (On-

Title: Set Me Up: How to Think in Sets

Title: Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)

Title: Anatomy of a Transaction

Title: Visualize Your Transaction Log

Title: Free SQL Server Tools

Title: Learn History from Temporal Tables

Title: How to Get Microsoft Certified

Title: SSAS: What is it and How do I get started using it

Title: Building Your First Data Warehouse

Title: The SQL Server Transaction Log for Developers

Title: How to use Execution Plans to find Performance Issues

Title: Processing Big Data with Azure Data Lake Analytics

Title: Creating an Azure SQL Database Using PowerShell

Title: QA with SQL Experts

Title: SQL Server 2016 - New Security Features

Title: Index 360 - Looking at Indexes from Multiple Perspectives

Title: Extended Events: What are they and How do I use them

Title: SSAS Tabular in 60 mins: Developing Business-Driven Self-Service BI

Title: MS SSAS Business Value: Should I choose Tabular or Multidimensional?

Title: I Know SQL Server, but want to become a great DBA - What do I need to know?

Title: Protecting Your Data with Encryption

Title: Problem Solving With The In-Memory Engine

Title: JSON for the Data Mortals

Title: Understanding SQL Server 2016 Always Encrypted

Title: The PROCESS of Queries

Title: Intro to Machine Learning

Speakers

Sponsors