SQLSaturday #287 - Madison 2014
Event Date: 03/29/2014 00:00:00
Event Location:
- 6000 American Parkway
- Madison, Wisconsin
This event has completed. All data shown below is from the historical XML public data available.
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: SQL Server 2014: Platform for Hybrid Cloud
Abstract: SQL Server 2014 provides a great platform for Hybrid Cloud as it enable new hybrid cloud solution such as backup to cloud, HA to cloud as well as other hybrid scenarios that can help you reduce costs and improve on-premises DR. We have also made it much easier for DBAs who may not be familiar with Microsoft Azure to easily deploy and manage SQL Server workloads to it. In this session, we will discuss how SQL Server 2014 offers a unique value proposition when it comes to building hybrid cloud solutions is our Cloud OS strategy of ensure a great and consistent experience no matter where you are running your data platform with a common set of tools across the entire application lifecycle.
Speaker(s):
- Chuck Heinzelman
Track and Room: Track 5 - N/A
Title: Recognizing the Parallel Data Warehouse (PDW) Workload
Abstract: If you are like many, you’ve been hearing a lot about Parallel Data Warehouse (PDW) lately. PDW is Microsoft’s appliance solution with SQL Server 2012 that allows massively parallel processing (MPP) of database workloads. But how do you know that you have a workload that requires or could benefit from MPP over the standard symmetric multiprocessing (SMP) architecture? In this session, we’ll review that question and more with a run through of how to identify MPP workloads? As part of the session, we’ll also review some of the key components and differentiators of the PDW platform. You’ll leave this session with a clear understanding of the value that PDW can bring to an organization and the types of workloads that it is best suited for.
Speaker(s):
- Jason Strate
Track and Room: Track 2 - N/A
Title: Implement a Dynamic Table Partitioning Solution
Abstract: Have a large or potentially large database that you would like to partition? Manually implementing partitioning and the corresponding maintenance can be a lot of work, especially if you have many tables. In this presentation we look at how you would implement a partitioning solution dynamically for all tables with the designated partition column. We set it up to keep a FIXED number of file groups. The partition maintenance will recycle the file groups over time as partitions are dropped and created. We do as much as possible through dynamic scripting. This solution can easily be used for archiving but in this example we are simply keeping the most current 6 months of data and dropping the rest. Assumes you have a basic understanding of SQL Server table partitioning.
Speaker(s):
- Kirby Richter
Track and Room: Track 2 - N/A
Title: Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues
Abstract: Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.
Speaker(s):
- Janis Griffin
Track and Room: Track 1 - N/A
Title: Performance-Tuning for Extract/Transform/Load (ETL) Operations
Abstract: Much has been written about performance tuning transactional systems and reports, but what about those huge queries used to populate your data warehouse, data marts or large data extracts? What good are reports if you can’t deliver the underlying data in a timely manner? What can be done to make handling millions of rows at a time go faster? In this talk, we’ll go over how to architect an ETL solution that will use every trick in the SQL-Server engine to make data move faster! We’ll be focusing on T-SQL based ETL stored procedures (and a little SSIS) rather than expensive tool-based ETL. We’ll also discuss hardware issues and how to tune processes that you can’t “change”.
Speaker(s):
- Ken Stuber
Track and Room: Track 1 - N/A
Title: DANGER: The Art and Science of Presenting
Abstract: Is there a great difference in the brain chemistry of someone fleeing a hungry mountain lion and someone presenting to a group of colleagues in a corporate board room? The answer is: NO. Over the past decade, a lot has been learned about the chemistry of the brain and why humans react the way we do to events in our environment. The concept of EQ (Emotional Intelligence) is a compelling and growing concept that applies this knowledge in a set of learnable, improvable skills for leading human beings. While EQ is often applied to corporate leadership, the parallels to presenting are fantastic. This session will explain the basics of EQ and demonstrate how you can apply it to make your presentations better in the following areas: * Crafting better slide decks * Preparing yourself for presenting * Delivering your content * Dealing with the unexpected Understanding and practicing the concepts of EQ can make your presentations a better experience for everyone in the room–including you.
Speaker(s):
- Mark Vaillancourt
Track and Room: Track 3 - N/A
Title: PowerShell 101
Abstract: If you haven’t dug in to PowerShell at this point, you’re missing out on some amazing, powerful, practical stuff that could save you time every day. PowerShell does have a learning curve at the outset, especially for those not already familiar with OO concepts or programming in a language like C#, so this introductory session will go through the very basics of PowerShell syntax. If that collection of pipes and hyphens and curly braces seems to be written in some incomprehensible foreign language, this session is for you. At the end of the session you should have a grasp of how and why a PowerShell script does what it does, and the confidence to dig in deeper and begin using POSH scripts in your own work.
Speaker(s):
- Merrill Aldrich
Track and Room: Track 7 - N/A
Title: Extending SQL Server with Advanced Analytics and R
Abstract: The Microsoft SQL Server stack provides an excellent set of tools for storing, visualizing, and analyzing data, but sometimes we want to do more. In this session, we’ll take a look at the open-source statistical software R and how we can use it to connect to SQL Server, analyze data, and put the results of our analysis back into SQL Server for later use. We’ll look at examples of analyses performed by a fictional company as they segment their customers, forecast their sales, and examine interesting relationships among their product offerings. Along the way, we’ll see what some of these analyses would take if done in SQL Server itself and why R is so effective when paired with SQL Server.
Speaker(s):
- Michael Schulte
Track and Room: Track 4 - N/A
Title: Database Snapshots - Making Your Job Easier
Abstract: Want to off load some of that reporting workload, make an emergency rollback during a production upgrade faster, or make managing your test databases easier? If any of these appeal to you, then you should be familiar with database snapshots within SQL Server. Available since SQL Server 2005, use of this feature can make your life a lot easier.We’ll spend the first part of this session taking an in depth look at how database snapshots work. We’ll look at what exactly is happening behind the scenes when you create a snapshot and when you query a snapshot. Once we’ve covered the basics, we’ll spend the rest of our time analyzing and discussing a number of real world use cases where snapshots can be very beneficial and save you a great deal of time.
Speaker(s):
- Paul Timmerman
Track and Room: Track 3 - N/A
Title: Be Friendly to SQL Server with TSQL Best Practices
Abstract: This session will take a look at things that you should regularly know and use when coding TSQL. How can you be really friendly to SQL? The items covered will show you things that will help ensure that your code is readable, efficient and maintainable. We will look at query semantics, datatypes, things to avoid as well as how to be super friendly to the SQL Engine and allow things to work well.
Speaker(s):
- Ben Miller
Track and Room: Track 2 - N/A
Title: Forward the Federations
Abstract: If you are working with Windows Azure SQL Database (WASD) then you know that the way to scale large data sets is to use federations. If you were using SSIS to move data into a federated database you know how challenging this can be. This year Microsoft released a new SSIS component that handles a lot of the federated headache. I’ll give the steps you need to set up federations in your WASD database and how to use SSIS to fill the tables with data.
Speaker(s):
- MIKE DONNELLY
Track and Room: Track 6 - N/A
Title: Every Byte Counts: Why Your Datatype Choices Matter
Abstract: Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns? Did your gut tell you that this is bad, but you had difficulty explaining why? Did you know that these Datatype Choices can be a real performance killer? Attend this session, learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now! When you leave, you should be able to explain why datatype choices matter to your colleagues, assess your own systems, and implement some best practices to mitigate these performance killers.
Speaker(s):
- Andy Yun
Track and Room: Track 4 - N/A
Title: Upgrading and Migrating SQL Server with limited downtime
Abstract: With SQL Server 2012 released and going strong, SQL Server 2014 coming quick, we’re all wanting the latest and greatest, high performing, SQL Engine sitting on our servers. How we do that is another question. How do you get a weekend of downtime? Do you like convincing the business you need it? I don’t and that is why we’re going to look at methods to upgrade or migrate SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 up to SQL Server 2012 and 2014 with as little downtime as possible – minutes..seconds! In this session, we’ll see how mirroring, log shipping and even replication, can make us look like DBA Rock stars at upgrade time.
Speaker(s):
- Ted Krueger
Track and Room: Track 7 - N/A
Title: Getting Started with Hekaton (In-Memory OLTP)
Abstract: So you’ve heard of Hekaton (In-Memory OLTP) but you aren’t sure where to start or if it’s for you or not. Maybe you’ve heard or read some information and not sure what’s true or not. There’s a number of misconceptions out there about Hekaton. By the end of this session you’ll have a better understanding of what Hekaton is and how it may be able to help you. We’ll discuss the basics of Hekaton and more as well as walking through some demos to show you how to use Hekaton and what it can do as well as help you get started diving into Hekaton on your own.
Speaker(s):
- Brian Davis
Track and Room: Track 5 - N/A
Title: Practical SQL Server Cardinality Estimation
Abstract: What is cardinality estimation and why should you care? In this session we’ll cover the mechanics behind cardinality estimation and why it is so very critical to overall query performance. We’ll cover concepts applicable to the last few major versions of SQL Server and also preview cardinality estimator changes being introduced in SQL Server 2014.
Speaker(s):
- Joe Sack
Track and Room: Track 2 - N/A
Title: How do I create an automated ETL test suite ??
Abstract: There are many automated test frameworks available for different types of applications, but Extract, Transform, and Load (ETL) data movement applications seem to lack an efficient and easy to use automated test suite.
We will review how the automated test suite is a data driven approach by showing how the tests self-generate based upon the data in the Information-Model schema in SQL Server and 4 slender custom tables that define the field data mapping between the source and target.
The last half of the session will be a demonstration of the tests to illustrate how they execute. To do this we will quickly review the stored procedure code that generates the tests.
Speaker(s):
- Terry Bunio
Track and Room: Track 6 - N/A
Title: Advanced Performance Tuning Tips with Database Performance Analyzer (formerly Confio Ignite)
Abstract: SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path.
Speaker(s):
- Janis Griffin
Track and Room: Track 6 - N/A
Title: Using DAX in SSMS and C#
Abstract: While the Tabular Model provides great self-service features with Excel and Power View many BI needs exceed these solutions. Using the DAX language within SSMS provides more flexibility and power. Incorporating these statements into a solution, such as in C#, can provide for better delivery of complicated BI requests that users cannot complete on their own. This presentation will give you a start on creating DAX statements and using those statements within a programming language.
Speaker(s):
- Marc Temkin
Track and Room: Track 7 - N/A
Title: How to baseline IO performance for your next SQL Server
Abstract: Optimal configuration of he I/O subsystem is critical and can ultimately be responsible for the response times of your applications. In this session we analyze the different options that you have for your IO subsystem, what are their pros and cons, what tools are available to baseline the performance of the hardware that you will use for SQL Server and what numbers are important to you.
Speaker(s):
- Luke Jian
Track and Room: Track 4 - N/A
Title: Solving Complex Problems with Extended Events
Abstract: New to SQL Server 2008, Extended Events provide a refreshingly new method of looking at what occurs inside of SQL Server. This session will show you how to leverage Extended Events to solve complex problems by identifying the root cause faster than other methods of data collection provide.
Speaker(s):
- Jonathan Kehayias
Track and Room: Track 8 - N/A
Title: Database Unit Testing
Abstract: Learn about Database Unit Testing, how it can add value to your projects, and how to do It with Microsoft Visual Studio. Brian will be speaking about the fundamentals of what database unit testing is and the Microsoft Visual Studio Tools for implementing database unit test projects. This talk is intended for audiences who are new to database unit testing and want to learn the basics behind using Visual Studio to perform automated database unit tests.
Speaker(s):
- Brian Beswick
Track and Room: Track 6 - N/A
Title: Delivering Self-Service BI with Power
Abstract: In this session, we will discuss the enhancements and new features that are provided with Excel 2013 as Microsoft continues its roadmap with self-service BI. First we will go over the changes that have been made in Excel 2013, covering the new features. From there we will show how PowerPivot models can be used to integrate and load data to be used for analysis. Lastly, we will look at using Power View inside Excel to provide self-service reporting capabilities that are highly interactive.
Speaker(s):
- Dan English
Track and Room: Track 5 - N/A
Title: Keynote
Abstract: Keynote - Opening Remarks
Speaker(s):
- Ted Krueger
Track and Room: Track 8 - N/A
Title: Social Networking Is Alive!!!
Abstract: Social Networking/Media is all over the news today. Did you see that on Facebook? Johnny 5 said what on Twitter?? Can you believe Susie moved to that company?? Do any of those sound familiar? No? Never heard of Twitter? Don’t have any fear as this session is for you! Social networking can be a very confusing place and when you don’t know where to start, that makes it even worse. In this session, we will go over different facets of Social Networking/Media and how you can use them to enhance not only your personal lives but just as importantly, your professional one. We’ll be covering Facebook, LinkedIn and Twitter.
Speaker(s):
- John Morehouse
Track and Room: Track 3 - N/A
Title: How Skyline Does Innovative BI
Abstract: Skyline Technologies will share their experience in using Agile project methodology and “Dev Camp” events to promote innovation and build technical skills - all while having fun! In particular, Skyline will highlight their recent project to demonstrate the mobile BI capabilities of Datazen and PowerBI using data around the recent NCAA March Madness.
Speaker(s):
- Scott Hietpas
Track and Room: Track 7 - N/A
Title: How to Tune Queries
Abstract: You’re in a dark room with an ugly query. What do you do next? Microsoft Certified Master Brent Ozar shares his time-tested method of tuning queries starting with simplifying, analyzing the execution plan, making index tweaks, and measuring improvements with statistics. You’ll learn a repeatable process you can use to make queries go faster.
Speaker(s):
- Brent Ozar
Track and Room: Track 8 - N/A
Title: Building Hadoop Clusters on Azure
Abstract: Big data and the cloud offer unparalleled opportunities for compute elasticity and deployment model flexibility. Learn about your options with the Windows Azure platform for deploying and managing Hadoop in the cloud. We’ll demonstrate cluster deployment and integration with the various options.
Speaker(s):
- Lara Rubbelke
Track and Room: Track 8 - N/A
Title: Hekaton Data: A Whole New World
Abstract: SQL Server 2014’s In-Memory OLTP stores your data and indexes in a whole new way. In this session we’ll take a look at way SQL Server 2014 In-Memory Database keeps track of your data with two new kinds of indexes, and why your data storage is so much more efficient.
Speaker(s):
- Kalen Delaney
Track and Room: Track 8 - N/A
Title: You’re the DBA. Now What?
Abstract: Are you an accidental DBA trying to find your way through your new role? Are you an experienced DBA moving to a new position, team, or major application? This presentation is for you! In this presentation, we will review best practices for what to do when you’re a brand new DBA. You will learn what to look for when you walk into a new environment, as well as pitfalls to avoid.
Speaker(s):
- Gill Rowley
Track and Room: Track 4 - N/A
Title: Resistance is Futile: What You Need To Know About Big Data
Abstract: The data community is all abuzz about Big Data, and for good reason. Much like Business Intelligence before it, we’re rapidly approaching the point where all data professionals should have at least a cursory understanding of what Big Data is and how it fits into an organization. To that end, this presentation will provide an overview of what Big Data is, discuss some common use cases for Big Data across a variety of industry verticals, and explore some common architectures for integrating relational and analytical data with Big Data. We’ll conclude with QA and an overview of resources for learning more.
Speaker(s):
- Michelle Ufford
Track and Room: Track 1 - N/A
Title: Fast and Flexible with Better Database Design
Abstract: Are you a jack of all trades? Have you been writing application code AND designing databases? Are you a DBA who can’t get that expensive database design training approved? Are you spending lots of time altering your tables knowing there has just got to be a better way? This session will take a dive into common pitfalls in database designs, prove out consistency issues and help you keep your applications fast and flexible. A properly designed database should perform at the highest levels and not require a gargantuan effort to adapt to routine application growth.
Speaker(s):
- Bill Lescher
Track and Room: Track 7 - N/A
Title: SSIS development is done: now what? Deployment, migration, maintenance and troubleshooting
Abstract: After attending this session, you will have the knowledge to care and maintain an SSIS Project Deployment model outside of SSDT
Speaker(s):
- Bill Fellows
Track and Room: Track 1 - N/A
Title: SQL Server 2014 Buffer Pool Extension
Abstract: SQL Server 2014 Buffer Pool Extension to SSD.
We will explore this new feature
a) When it is make sense to use it
b) Common misconception about this feature
c) Demo!
Speaker(s):
- Chirag Shah
Track and Room: Track 2 - N/A
Title: Contained Databases: What, Why and Where.
Abstract: In SQL Server 2012, Microsoft added the new feature “contained databases”.
Database movement with out the orphans! Developers working independent of an instance! Delegate some database administration with out granting SA! Sound to good to be true?
Come learn how these and other elements of a “contained database”, can impact your database life.
Speaker(s):
- Jim Dorame
Track and Room: Track 6 - N/A
Title: Unstructured Data in SQL Server
Abstract: A look at the Filestream and Filetable features in SQL Server that can allow you to handle unstructured data inside your SQL Server database.
Speaker(s):
- Steve Jones
Track and Room: Track 8 - N/A
Title: Maintenance and Backups: Intro to Ola Hallengren
Abstract: This session will provide an overview of the critically acclaimed SQL Server Maintenance Solution written and maintained by Ola Hallengren. If you’re using Maintenance plans, you’re started in the right direction, but Ola’s solution is the Gold Standard for Maintenance scripts. We will review the options and show you how these scripts can leave you more at ease with your backup, database and index maintenance duties.
Speaker(s):
- Jason Carter
Track and Room: Track 7 - N/A
Title: Integrate SQL Server with hadoop
Abstract: Our company built a system mixing Big Data technologies (hadoop/ElasticSearch) along with SQL Server to make a system that is both highly scalable and cost effective. In this session I’ll walk you through the ETL process of pulling data through sqoop, transforming data in hive and presenting a denormalized table in hive. If you are looking to understand how to get data from SQL Server into hadoop and leveraging parallel architecture this is the session for you.
Speaker(s):
- Pat Wright
Track and Room: Track 5 - N/A
Title: SQL 2012 and 2014 AlwaysOn Configuration Deep Dive
Abstract: Brief overview of AlwaysOn features, then dive into what you need to consider when implementing these new features. This session will be interactive, with demos and systems refer to. Bring ideas and questions on how to make this work in the real world. We will discuss the entire infrastructure needed to support DR and HA, and why you need to have a very good understanding of AD to have a successful implementation. We may even break out a white board!
Speaker(s):
- Michael Steineke
Track and Room: Track 1 - N/A
Title: An Introduction to FileTables
Abstract: With the release of SQL Server 2012 Microsoft introduced FileTables, a better way to store large objects inside a database. With FileTables you get the advantage of the security and transactional consistency of a database AND improved file streaming from the OS. In this session I’ll show you how easy it is to set up and use FileTables, as well as improved methods of searching document keywords with FullText and Semantic searches.
Speaker(s):
- John Pertell
Track and Room: Track 3 - N/A
Title: 10 Ways To Abuse T-SQL
Abstract: Learn 10 common T-SQL mistakes and how to avoid them. Procedural coding, misuse of user-defined functions, and non-SARGable filters are just some of the topics we’ll cover.
Speaker(s):
- Tracy McKibben
Track and Room: Track 4 - N/A
Title: Squeezing Top Performance from Your Virtualized SQL Server
Abstract: Just about anyone can click through a SQL Server installation and get it working, but more than a little tuning is required to get the most performance out of your servers. Once virtualized, additional tuning can help get even more performance out of that virtual machine. David Klee (@kleegeek) will discuss valuable details for both VMware vSphere and Microsoft Hyper-V on how to tweak and tune your virtual infrastructure for business-critical virtualized SQL Servers. Tips on configuring your SQL Server installations for maximum performance when virtualized will be covered in detail.
Speaker(s):
- David Klee
Track and Room: Track 5 - N/A
Title: SSMS: More Than Meets The Eye
Abstract: SQL Server Management Studio is the standard tool for working with SQL Server databases. It does the job well. But if you’re using the default settings, you’re missing out! You can enable word wrap and number the lines. Change the settings when you script objects out. Filter through objects. Create templates, projects, and snippets. Let me guide you through the world of SSMS settings!
Speaker(s):
- Jes Schultz
Track and Room: Track 5 - N/A
Title: DBA 911 - Database Corruption
Abstract: Database corruption is simply a fact of a DBA’s life - if you haven’t seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it.
Speaker(s):
- David Maxwell
Track and Room: Track 6 - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Scott Hietpas
Twitter: - @shskyline
LinkedIn: Scott Hietpas
Contact: http://www.skylinetechnologies.com/
Scott is a solution architect at Skyline Technologies with over 20 years of consulting experience helping organizations solve business problems with technology. He has architected on-premises and cloud-based data integration and data warehouse solutions as a foundation for data-driven decision making capabilities, and helped organizations adopt rich data visualization tools such as Power BI to turn data into insights.
Jes Schultz
Twitter: - http://twitter.com/grrl_geek
LinkedIn: Jes Schultz
Contact: https://blogs.lessthandot.com/author/jes-borland
Jes Schultz is a Software Engineer with Microsoft who has experience with a wide range of SQL Server features from version 2005 through 2019, and is on the cutting edge with Azure technologies. Since graduating Fox Valley Technical College with an IT-Programmer/Analyst degree, Jes has worked as an SSRS developer, DBA, and consultant. Before joining Microsoft, Jes was a six-time Data Platform MVP, recognized for her community work. Jes tackles every project and problem with tenacity and her enthusiasm is unmatched in the SQL Server community. In her free time, Jes never stops moving, and counts fitness, coffee, cooking, and travel as essentials in life.
Mark Vaillancourt
Twitter: - @markvsql
LinkedIn: Mark Vaillancourt
Contact: http://markvsql.com
Mark is a Data Solutions Architect for Microsoft, helping organizations design data solutions in Azure. He has been working with Microsoft data technologies since 2007. Before joining Microsoft, he was a Business Intelligence consultant and two-time Microsoft Data Platform MVP. With a background in Theater and Improvised Comedy, Mark makes sure that his presentations are both informative and fun.
Joe Sack
Twitter: - @JoeSackMSFT
LinkedIn: Joe Sack
Joe Sack is a Principal Program Manager in the SQL Server product team at Microsoft, with a focus on the Query Optimizer. Joe is an author and speaker with over 18 years of experience in the industry, specializing in performance tuning, high availability and disaster recovery.
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Gill Rowley
Twitter: - @BadgerBully
LinkedIn: Gill Rowley
Contact: http://gillrowley.wordpress.com
I#39;m a SQL Server DBA and Business Intelligence Consultant with over 10 years experience working with all versions of SQL Server dating back to SQL Server 7.0. When not playing with SQL Server I spend my time hunting, fishing, weightlifting, relaxing on my boat, playing men#39;s fast pitch softball, and playing with my rescued bull terrier Lola.
Brian Davis
Twitter: - @Brian78
LinkedIn: Brian Davis
Contact: http://blogs.sqlsentry.com
Brian Davis is a Product Integration Engineer at SentryOne and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands-on experience with SQL Server 2000 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.
Kirby Richter
Twitter: - @sqlkirby
LinkedIn: Kirby Richter
Kirby Richter is a Minnesota SQL Server Professional with 20 years’ experience. Currently Principal Database Architect at Dell Storage, specializing in Database Administration, large databases and Performance Tuning. Working with all versions of SQL Server since 6.5 Enjoys Development, Database Administration and Business Intelligence. Presents periodically at local events. Hobbies include kayaking, camping and amateur Astronomy.
Marc Temkin
Marc Temkin, is an independent consultant and teacher who has worked with PBS, Columbia College, Argonne National Laboratory and private banking using C#, C++, SQL and SQL BI tools. He also currently works for Northwestern University.
Jonathan Kehayias
Twitter: - @SQLPoolBoy
Contact: https://www.sqlskills.com/blogs/jonathan
Jonathan Kehayias is a Principal Consultant and trainer with SQLskills, and has been recognized as a Microsoft Data Platform MVP for over 10 years, and was the youngest person ever to achieve the Microsoft Certified Master – SQL Server certification. He has presented at numerous conferences including PASS Summit and SQL Rally, SQLBits, VMware Open Forum, SQLintersection, and multiple SQLSaturdays around the world. As a performance tuning and high availability expert for SQL Server, Jonathan has architected and implemented complex systems and solutions for some of the worlds most challenging workloads.
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.
Merrill Aldrich
Twitter: - @onupdatecascade
LinkedIn: Merrill Aldrich
Contact: http://sqlblog.com/blogs/merrill_aldrich/
Merrill is a consultant with the national Digital and Technology Consultancy RBA. In past lives he was a SQL Server DBA for Financial Services and Real Estate Management organizations, a designer of buildings, an expert in three dimensional computer graphics and building information modeling, a speaker, teacher, and visiting lecturer.
Paul Timmerman
Contact: http://blogs.lessthandot.com/index.php/author/mndba/
Paul is a Microsoft SQL Server MVP and the Lead SQL Server DBA at Hennepin County Medical Center in Minneapolis, Minnesota. Paul has fifteen years of experience in database administration and currently the Chapter Leader of the Minnesota SQL Server User Group, PASSMN. Paul is an active member of the PASS community and routinely speaks at user group meetings and SQLSaturday conferences.
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
John Morehouse
Twitter: - SQLrUs
LinkedIn: John Morehouse
Contact: http://www.sqlrus.com
John Morehouse is currently a Consultant with Denny Cherry Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member Community Ambassador, and 2016 Idera Ace. John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible. He is a user group leader, SQLSaturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQLSaturday’s as well as other conferences.
Michael Schulte
Mike Schulte is a decision support analyst at Gateway Health Plan. He works with tools such as SQL, Tableau, R, SAS, Azure Machine Learning, and Spark to use data to support decisions. These days he is trying to change the world by supporting value-based healthcare initiatives, whereby healthcare costs are lowered while quality of care is improved! In his spare time, he teaches economics and philosophy courses, plays chess and directs chess tournaments, and rings bells in church bell towers.
Luke Jian
Twitter: - @sensware
LinkedIn: Luke Jian
Contact: http://blog.sqlpositive.com
Luke Jian is an experienced database architect with a leading healthcare information company. A frequent speaker at conferences and local user groups he has 15+ years of experience in database design, development and optimization on SQL Server and Big Data projects.
Brian Beswick
LinkedIn: Brian Beswick
Contact: http://brianbeswick.com/
Brian is a Managing Consultant at Allegient. He has many years of experience in database architecture and development across multiple versions of SQL Server. He’s an accomplished Database Architect with a specialty in Business Intelligence. He’s particularly strong at understanding and designing solutions for complex requirements.
Michelle Ufford
Twitter: - https://twitter.com/sqlfool
LinkedIn: Michelle Ufford
Contact: http://sqlfool.com
Michelle Ufford is a published author, popular presenter, award-winning blogger, Microsoft Data Platform MVP, and well-known thought leader in the data industry. She has worked with virtually every aspect of the data lifecycle over the past 16 years and spent the prior 8 years building analytics infrastructure at GoDaddy. She’s presently geeking out at Netflix on the Data Engineering amp; Analytics (DEA) team. She blogs at hadoopsie.com and can be found on Twitter @sqlfool.
David Maxwell
Twitter: - https://twitter.com/dmmaxwell
LinkedIn: David Maxwell
Contact: https://dmmaxwell.wordpress.com/
David Maxwell has almost 20 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQLSaturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals Virtual Group, the Performance Virtual Group, 24 Hours of PASS, and the annual PASS Summit. David participates in his local Columbus Ohio PASS Local Group, where he serves on the board of directors as SQLSaturday coordinator.
Kalen Delaney
Twitter: - sqlqueen
Kalen Delaney is a Data Platform MVP who has worked with SQL Server for more than 32 years. She has provided performance consulting services and taught advanced courses on SQL Server to thousands of people and organizations. In addition to her courseware development, Kalen has been writing about SQL Server for decades. She is the primary author of SQL Server Internals and the Inside SQL Server series. Kalen is also one of the primary editors for the Red Gate SQL Server Stairways tutorials.
Bill Lescher
Twitter: - https://twitter.com/blescher
LinkedIn: Bill Lescher
Bill has over 20 years of database administration and development experience. He is a co-founder of the Chicago chapter of the Professional Association for SQL Server (PASS), where he served as President for its first decade. He is a recipient of the “Outstanding PASS Volunteer” award, and he was a top 5 finalist of the Exceptional DBA Award. Bill has been a key organizer of the annual “SQLSaturdays” in Chicago. An Alum of Illinois State University, he was born and raised in Chicagoland.
Chirag Shah
Worked with SQL Server since 2000.
Microsoft SQL Server Premier Field Engineer - Chicago, IL
Lara Rubbelke
Twitter: - @sqlgal
Lara Rubbelke brings her passion for architecting, implementing, and improving Azure data solutions to the community as a Principle Software Development Engineer for Microsoft. Many know Lara from her work on the DDP Framework, EPM Framework, and Separation of Duties Framework. Her expertise involves Big Data, analytics, OLTP and DW systems. Lara frequently delivers technical presentations at conferences and events including Build, PASS Summit, SQLBits, and webcasts on Channel 9 and MSDN.
Bill Fellows
Twitter: - @billinkc
LinkedIn: Bill Fellows
Contact: http://blog.billfellows.net
Bill Fellows is a SQL Server MVP and has been a database developer for most of his career, with the past 15 years focused on ETL. He is the organizer of Kansas City’s eight SQLSaturdays and a speaker at many other SQLSaturdays, User Groups and the PASS Summit. Bill is the owner of Sterling Data Consulting where he gets to solve interesting data problems.
Chuck Heinzelman
Chuck Heinzelman is a Senior Program Manager with the Business Process Division (BPD) Customer Experience team at Microsoft, working with both the SQL Server Customer Advisory Team (SQLCAT) and the Community Strategy team. His primary focus areas in the SQL Server arena are database design, application development, and physical infrastructure.
Chuck has been involved with the SQL Server community for over 10 years. He was a founding member of the Wisconsin SQL Server User Group and has attended all but one PASS Summit. He has a long history of volunteering with PASS, having served as an author, editor, presenter, and former Board member.
Ben Miller
Twitter: - DBAduck
LinkedIn: Ben Miller
Contact: https://dbaduck.com
Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.
MIKE DONNELLY
Twitter: - SQLMD
LinkedIn: MIKE DONNELLY
Contact: http://sqlmd.wordpress.com
Michael Donnelly has been working with SQL Server for 15+ years and holds the MCSE: Data Platform certification. He is an avid runner, blogger, and a wannabe gourmet chef. Currently living the SQL Life on the Jersey Shore.
Pat Wright
Twitter: - www.twitter.com/sqlasylum
LinkedIn: Pat Wright
Contact: http://www.sqlasylum.com
Pat Wright has been working in the DBA space for 10+ years. Focusing on Performance tuning and ETL/DW projects. He helped found the local SQL Users group(www.slcsql.com) and founded the Not For profit Organization Utah Geek Events(www.utahgeekevents.com) which was founded to help the local community put on events.
Ted Krueger
Twitter: - @onpnt
LinkedIn: Ted Krueger
Contact: http://blogs.lessthandot.com/index.php/All/?disp=authdiramp;author=68
Ted Krueger is a SQL Server MVP and has been working in development and database administration for the better part of his career. Specialties range from High Availability and Disaster / Recovery design, implementation, testing methods and administration, down to custom assembly development for SQL Server Reporting Services.
Jason Strate
Twitter: - @stratesql
LinkedIn: Jason Strate
Contact: http://www.jasonstrate.com/
Jason Strate is a SQL Server Solutions Architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. Jason writes, blogs, and presents on SQL Server.
Dan English
Twitter: - @denglishbi
LinkedIn: Dan English
Contact: http://denglishbi.wordpress.com
Dan is a Microsoft Data Platform MVP, author, technical editor, and community leader. He has been developing with Microsoft technologies for over 20 years, and over 15 years with Data Warehousing and Business Intelligence. He has been working with SQL Server since version 6.5 and now using 2017 and in Azure. Dan is the chapter leader for the PASS Business Analytics virtual group and on the executive leadership team for the MN Microsoft BI user group.
John Pertell
Twitter: - https://twitter.com/jayape
LinkedIn: John Pertell
Contact: http://www.pertell.com/sqlservings
I am an Accidental Database Administrator, working for the same healthcare company since 2000. I started using MS Access for report writing but started playing with SSRS 2000 and haven’t missed going back. In my spare time I enjoy reading, photography, and pretending I know how to golf.
Brent Ozar
Twitter: - BrentO
LinkedIn: Brent Ozar
Contact: https://www.BrentOzar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.
Michael Steineke
Twitter: - @MSteineke
LinkedIn: Michael Steineke
Contact: http://www.michaelsteineke.com
Michael Steineke is a Windows Server Platform expert with an industry-wide reputation as an innovator in the areas of Windows Server, storage and network architecture, disaster recovery, datacenter configuration, and SQL Server. He is a Cloud and Datacenter Management MVP specializing in High Availability and has spoken on subjects like Windows Server, clustering, Storage, Hyper-V, SQL Server, and multi-site clusters at user groups and conferences of all sizes, including SQLSaturdays, SQL PASS Summit, Microsoft TechEd, and the Microsoft MVP Summit.
Steve Jones
Twitter: - way0utwest
LinkedIn: Steve Jones
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
David Klee
Twitter: - kleegeek
LinkedIn: David Klee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.
Tracy McKibben
Twitter: - @RealSQLGuy
LinkedIn: Tracy McKibben
Contact: http://realsqlguy.com
Database background extending back to 1994, includes Clipper, FoxPro, dBase, all versions of SQL from 7.0 forward.
Currently managing a team of production DBAs for Pearson VUE, and serving as the Director Of Program Development for PASSMN.
Andy Yun
Twitter: - SQLBek
LinkedIn: Andy Yun
Contact: http://sqlbek.wordpress.com
Andy Yun is a SentryOne Principal Solutions Engineer and a former Microsoft MVP. He has been working with SQL Server for nearly 20 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQLSaturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQLSaturday Organizing Committee.
Ted Krueger
Twitter: - @onpnt
LinkedIn: Ted Krueger
Contact: http://blogs.lessthandot.com/index.php/All/?disp=authdiramp;author=68
Ted Krueger is a SQL Server MVP and has been working in development and database administration for the better part of his career. Specialties range from High Availability and Disaster / Recovery design, implementation, testing methods and administration, down to custom assembly development for SQL Server Reporting Services.
Ken Stuber
Twitter: - @KenStuber
LinkedIn: Ken Stuber
Contact: http://dropcleanbuffers.com/
Ken Stuber is the Data Architect at Jewelers Mutual Insurance in Neenah, WI as well as being an independent consultant with Drop Clean Buffers Consulting, LLC. Ken has been working with SQL Server since v6.5 in 1997 and has broad experience in the Microsoft Data Platform. His primary interests are in the performance tuning, enterprise architecture, DevOps, database design and database development. When not fighting the query optimizer, he can be found RVing around North America, backpacking, cooking, gardening, reading, and studying for whatever will replace the MCM program.
Terry Bunio
Twitter: - @tbunio
Contact: http://www.agilevoyageur.com
Terry started his career working with Adabas as a DBA., Over the next 20 years, Terry has worked with Oracle, Informix, Sybase, and Microsoft SQL Server as both a Data Modeler and DBA. Terry is a huge proponent of normalization and dimensional modeling.
Terry has implemented Operational Data Stores, Data Warehouses, and ETL solutions for Investors Group, LPL Financial, Manitoba Blue Cross, and others.
Terry has recently worked on integrating Agile practices into Database projects.
Jason Carter
Twitter: - TampaDBA
Contact: http://jason-carter.net
Jason#39;s past has included being a developer, a development manager, accidental DBA, and now a full-time DBA. Having worked with VLDBs as a developer, he found great interest in tuning, tweaking, and making things run faster. With the support of his wife, he gave up his managerial duties and jumped the Development ship and dove head first into his new career as a Database Administrator
Sponsors
The following is a list of sponsors that helped fund the event: