SQLSaturday #484 - Chicago 2016
Event Date: 03/05/2016 00:00:00
Event Location:
- DeVry University - Addison Campus
- 1221 North Swift Road
- Addison, Illinois
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: Turbo-Charged Transaction Logs
Abstract: The transaction log is one of the most critical, yet often misunderstood components of SQL Server. From out of control log growth to very long start-up times, problems with the transaction log can cause a lot of pain. In this session, we’ll look at how the transaction log works and how to optimize its performance. You’ll learn how to determine the right settings for maximum throughput, and what to do when things get out of control.
Speaker(s):
- David Maxwell
Track and Room: Enterprise Database Administration Deployment - Room 214
Title: What’s New in SQL Server 2016
Abstract: Come to this session to learn the new features and functionalities available in SQL Server 2016. SQL Server 2016 delivers breakthrough mission-critical capabilities with in-memory performance and operational analytics built-in. Comprehensive security features like new Always Encrypted technology help protect your data at rest and in motion, and a world-class high availability and disaster recovery solution adds new enhancements. Organizations will gain deeper insights into all of their data with new capabilities that go beyond business intelligence to perform advanced analytics directly within their database. Additionally to the ability to dynamically stretch warm and cold transactional data to Microsoft Azure in a secured way.
Speaker(s):
- Ross LoForte
Track and Room: Enterprise Database Administration Deployment - Room 215
Title: Scripting out SQL Server for Documentation and Disaster Recovery
Abstract: Most DBAs need to use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects. Even using Visual Studio and Database Projects, not all objects are exportable and live at the server level, above the database. By Learning a little Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for moving or recovering a SQL server instance for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, and Server Triggers
Speaker(s):
- George Walkey
Track and Room: Enterprise Database Administration Deployment - Room 208
Title: Big Data in the Cloud - An Intro to HDInsight and Microsoft Azure
Abstract: BIG DATA! There, I’ve said it. But, what exactly does it mean for YOU?
This session will help to dispel some of the Big Data confusion. This session will focus on HD Insight, Microsoft’s Hadoop based cloud implementation. Loading data and querying a database is one thing and that will certainly be covered. Exploring how we can integrate data from HD Insight into our existing analytic solutions is one of the real world implementations this session will be focused on. This is one of the keys to successfully selling management on the needs for a Big Data solution. It’s not just another database, it’s a tool to enhance existing analytic structures.
During this session, we’ll start with a brief overview of Hadoop and HDFS. Next we’ll take a look at HDInsight, and explore some of the features therein.
Speaker(s):
- Josh Fennessy
Track and Room: Cloud Application Development Deployment - Room 207
Title: Becoming the Data Platform Engineer of Tomorrow
Abstract: You’re a DBA/Dev/BI Professional (delete as appropriate), what will your role be like in five years time? In this session we will talk about how the industry has changed over the last couple of years and hypothesize on where it is going and the type of work we might be doing and technologies that we will be dealing with.
Will the traditional developer, BI and DBA roles that we know so well today be the same, or will we need to diversify and look at expanding into other areas to stay ahead of the curve?
Speaker(s):
- John Martin
Track and Room: Professional Development - Room 217
Title: Encrypting Data within Sql Server
Abstract: Data breaches abound! Sql Server has several options to encrypt the data, Transparent Data Encryption, Cell Level Encryption and Sql Server 2016 Always Encrypted. Let’s review each option to hide the encrypt the data. Let’s also look at new options to hide data with Always Encrypted.
Speaker(s):
- Thomas Norman
Track and Room: Application Database Development - Room 209
Title: Licensing Simplified: AlwaysOn, Virtualization, and More
Abstract: How does licensing work? Sure, you understand the difference between Standard and Enterprise, but what happens with AlwaysOn Availability Groups, virtualization, clustering, and disaster recovery? Microsoft Certified Master Brent Ozar will cut through all the confusion and explain your high availability and disaster recovery options, show how licensing impacts them, and keep you out of prison.
Speaker(s):
- Brent Ozar
Track and Room: Strategy and Architecture - Room 215
Title: Profiler is Dead! Long Live Extended Events!
Abstract:
Did you know that Profiler and SQL Trace are deprecated? I know it still works (even in SQL Server 2016 CTP2), but it will never be updated with the latest features. In fact it will never be updated at all! That means if you want to capture information about any new feature, from version SQL Server 2012 and beyond, you need to use another tool.
That new tool is Extended Events (XE). Not only has it replaced Profiler, and can be used to capture information on all new features, but it is a substantially better tool!
In this session we will discuss the architecture of Extended Events, how to setup a new trace from scratch or convert an existing Profiler trace, and the new abilities that never existed in Profiler. We will also cover the difference in overhead cost of Profiler and Extended Events.
Profiler was a friend of mine, but it is time to embrace the new king!
Speaker(s):
- Keith Tate
Track and Room: Enterprise Database Administration Deployment - Room 217
Title: XML Without Xanax: How to Handle XML in SQL Server
Abstract: Do you cringe whenever you have to look at an XML document? Does the very thought of XML data living in your database make you scream? Do you have a panic attack any time you have to parse XML? If you answered yes to any of these questions, then this session is for you!
We’ll start with reasons why having XML in SQL Server might be a good thing, then we’ll face our fears and turn tabular data into XML, and finally we’ll confront the true source of our anxiety by parsing XML back into tabular data using xQuery.
If you survive this session, you’ll have faced your fears about XML in SQL Server, you’ll have a solid understanding of creating XML from tabular data, and you’ll know how to use xQuery to parse XML.
Speaker(s):
- Adam Belebczuk
Track and Room: Application Database Development - Room 209
Title: Effective Data Visualization: The Ideas of Edward Tufte
Abstract: We spend much of our time collecting and analyzing data. That data is only useful if it can be displayed in a meaningful, understandable way. Yale professor Edward Tufte presented many ideas on how to effectively present data to an audience or end user. In this session, I will explain some of Tufte’s most important guidelines about data visualization and how you can apply those guidelines to your own data. You will learn what to include, what to remove, and what to avoid in your charts, graphs, maps and other images that represent data.
Speaker(s):
- David Giard
Track and Room: BI Information Delivery - Room 209
Title: How to collect a baseline on all your servers and still get a good night’s sleep.
Abstract: Your boss comes up to you and asks you why the system is slow, unless you know how your system is supposed to respond you are stuck scrambling to answer those questions. With a few free quires and some SSIS magic you can capture a Baseline of your systems. With this you will be able to know exactly where to look and what might be amiss. Before you can say what is wrong with your system you need to know how it reacts under normal circumstances. This session will provide the tools you need to start collection of your systems baselines and give you a great deal of information.
Speaker(s):
- Jim Dorame
Track and Room: Enterprise Database Administration Deployment - Room 207
Title: Wish you could live the glamorous consulting life?
Abstract: Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn’t start earlier? (and walk away from a cushy job).
I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I’ve learned the hard way. In this session you will learn sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out. Y
Speaker(s):
- Juan Soto
Track and Room: Other - Room 215
Title: Data Pages, Allocation Units, IAM chains… Oh My!
Abstract: Understanding how SQL Server organizes your data under the hood can seem like a daunting task. In this session we’ll take a look at how objects such as tables and indexes are stored in the data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions.
We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.
Speaker(s):
- Brandon Leach
Track and Room: Enterprise Database Administration Deployment - Room 208
Title: Dimensional Modeling Design Patterns: Beyond Basics
Abstract: Dimensional modeling is arguably one of the most important fundamentals of business intelligence. It is still relevant even as new technologies like PowerPivot and SSAS Tabular Models are becoming more popular. Correctly modeling your organization’s data not only protects the most important asset your company has but ensures that your data mart or data warehouse will be responsive and capable of accommodating emerging requirements.
This session provides a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. Finally we will cover physical design choices.This case study and demo based session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
Speaker(s):
- Jason Horner
Track and Room: BI Platform Architecture, Development Administration - Room 214
Title: Infrastructure for the DBA: An Introduction
Abstract: It doesn’t matter if you are a Junior DBA, an accidental DBA or all the way up to a Senior DBA, the infrastructure your SQL Server environment runs on is important. Many among the DBA community came in as developers or perhaps directly into database administration roles it is equally possible that you have been out of the operations world long enough to have fallen out of the loop with what is happening. This session is intended to provide a full stack infrastructure overview so that you can talk shop with your cohorts in operations to resolve issues and maybe even be proactive. We will discuss, in an introductory fashion, hardware, network, storage, virtualization and operating system layers. Additionally, some suggestions as to where to find more information will be provided.
Speaker(s):
- Peter Shore
Track and Room: Enterprise Database Administration Deployment - Room 208
Title: Lock, Block and Two Smoking Barrels
Abstract: SQL Server is a high performance relational engine and provides a highly scalable database platform but due to its complexity (and bad programming practices) can be prone to serious concurrency problems, unexpected behaviors, lost updates and much more! In SQL Server 2005, two optimistic concurrency mechanisms were introduced and touted as the solution to all our problems. Now in SQL Server 2012, 2014 and 2016 even more have followed, but many challenges and problems still remain. Let’s take a long look into the world of SQL Server concurrency and investigate Pessimistic and Optimistic isolation understanding how they work, when you should use them, and more importantly when they can go very wrong. Don’t be staring down the wrong end of SQL Server’s two Smoking Barrels and join me for this revealing and thought provoking presentation.
Speaker(s):
- Mark Broadbent
Track and Room: Application Database Development - Room 217
Title: Big Data in the Modern Data Warehouse
Abstract: ‘Big Data’ has been the buzzword of the past few years. With the exception of a few niche verticals and use cases, it’s often been a solution in search of a problem, as well as a word in search of a definition. With decision makers excited to push big data and predictive analytics solutions within organizations, data architects and developers must quickly understand its strengths within an enterprise BI architecture.
This session aims to define big data from the perspective of the enterprise data warehouse, while also arguing that both big data and data warehouses compliment one another perfectly. By using Google’s big data analytics platform (BigQuery), SSIS, and a data warehouse built in SQL Server, we will illustrate how big data can best serve your organization, while also combining cloud and on-premise solutions across competing technology platforms.
Speaker(s):
- Fred Bliss
Track and Room: BI Platform Architecture, Development Administration - Room 215
Title: Virtual SQL Servers, Actual Performance
Abstract: Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance.
This session is packed with many tips and tricks for getting the most performance from your virtual SQL Servers. The major roadblocks to performance are discussed, and the knowledge gained can help you work with your infrastructure engineers so that you can optimize the system stack for performance. Tools, techniques, and processes are demonstrated to help you measure and validate the system performance of the key components underneath your data.
Speaker(s):
- David Klee
Track and Room: Enterprise Database Administration Deployment - Room 215
Title: Clusters! From the ground up, let’s build one together
Abstract: You’re looking to protect your SQL instance from a machine failure. Or maybe your storage budget and tight and you don’t want to have your databases in two places with one of the other highly available options that SQL provides. Let’s learn what a cluster is and why it might be the right thing for you. We’ll explore the system, network, storage and database administration sides of the equation. And, when it’s all said and done we’ll even have built a SQL clustered instance!
Speaker(s):
- Paul Popovich Jr
Track and Room: Enterprise Database Administration Deployment - Room 214
Title: Much Ado About Hadoop
Abstract: Hadoop is a hot topic right now, and Microsoft is betting that Hadoop and SQL Server will go together like peanut butter and chocolate. This presentation will spend a little bit of time on the theory behind Hadoop, but the rest will be a demo-driven look at how to get a handle on Hadoop before somebody introduces it into your enterprise.
Speaker(s):
- Kevin Feasel
Track and Room: Strategy and Architecture - Room 215
Title: Monster Text Manipulation: Regular Expressions for the DBA
Abstract: Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures, filled with table variables, instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cut that work from hours or days to minutes or even seconds. Stop writing code manually and let regular expressions do it for you. Learn: • The most useful regular expression commands • The appropriate times to use regular expressions • How to use regular expressions to write code for you • How to incorporate regular expressions into large tasks and combine them with other methods
Speaker(s):
- Sean McCown
Track and Room: Enterprise Database Administration Deployment - Room 207
Title: Anatomy of an Optimizer
Abstract: In this session, we look in depth at how the query processor architecture and show what operations it performs during query optimization to generate equivalent query plans and find a “good enough” plan with limited time during query optimization, explain query optimization phases and show a few DMVs that are useful when diagnosing optimizer behavior We will also explore the differences between In-Memory OLTP tables vs Disk based tables, and have a look at some considerations when you use the new cardinality estimator We explain why query optimization complexity increases exponentially with the number of tables included in the plan, and how to diagnose and remedy issues that relate to bad query plans
Speaker(s):
- Luke Jian
Track and Room: Enterprise Database Administration Deployment - Room 218
Title: Azure SQL Database for the Earthed DBA
Abstract: Everyone knows that Azure SQL Database only supports a small subset of SQL Server functionality, small databases, and has really bad performance. Except, everyone is wrong. In fact, Azure SQL Server Database is ready to support many, if not most, databases within your enterprise. This session reintroduces Azure SQL Database and shows the high degree of functionality and improved performance that is now available. You’ll leave this session with a more thorough understanding of the strengths and weaknesses of Azure SQL Database so that you can make a more informed choice over when or if you should use it within your environment.
Speaker(s):
- Grant Fritchey
Track and Room: Cloud Application Development Deployment - Room 216
Title: “R” You Ready For SQL 2016?
Abstract: R is one of the fastest growing programming languages, useful for data analysis and visualization. You’ve been able to connect to SQL databases to work with large data sets before using R packages. But now, with the upcoming SQL 2016 release, R will be included as an Advanced Analytics Extension. You’ll be able to run the same R scripts right in your database.
In this beginner session we will look at how to set up R on your SQL instance. We’ll work with some sample data to show how R works with SQL inside and outside the database with some basic R commands. And we’ll create some graphs and charts for use in some SSRS reports.
Speaker(s):
- John Pertell
Track and Room: Analytics and Visualization - Room 208
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: Enterprise Database Administration Deployment - Room 216
Title: Context Calculation, Back to the Basics with DAX
Abstract: The learning curve for DAX isn’t a straight line - it starts off gradual and quickly gets steep. With a syntax similar to Excel, DAX seems easy enough for an Excel power user but things quickly get confusing without a good foundation in the basics of DAX. Those basics - context and calculation - are the topic for this session.
This session is for the intermediate DAX user who has produced some quality data models and DAX calculations but who is still having difficulties with functions around filtering, time intelligence, and complex calculations. We’ll go through a number of practical examples that show that DAX at a fundamental level is a combination of creating filter and row CONTEXTS and then using those contexts to produce CALCULATIONS. Understanding this concept is a must to produce more complex code in DAX and it’s also a very useful framework for someone just getting started.
Speaker(s):
- Austin Senseman
Track and Room: Advanced Analysis Techniques - Room 207
Title: Time to Stretch: Scaling out with Azure DB Elastic Scale
Abstract: Elasticity is one of the main promises of cloud computing. The cloud has given us the ability to programmatically add or remove resources to an application and dynamically respond to our workload volume to allow for cost efficient, high performing solutions. However, achieving this elasticity in a transparent way can be a challenge in itself.
In particular, dynamically scaling the database tier can be difficult due to having to deal with distribution schemes, data movement, application routing and the actual increase or decrease of the database resources. Azure SQL Database and the Elastic Scale .NET API combine to provide a solution to these challenges in an easy to use but powerful set of capabilities.
In this session we will demo the elastic scale API, elastic db pools, elastic query and elastic database jobs and how they combine to bring database elasticity in your own application and take advantage of true cloud optimized infrastructure!
Speaker(s):
- Warner Chaves
Track and Room: Enterprise Database Administration Deployment - Room 207
Title: Biml for Beginners: Speed up your SSIS development
Abstract: SSIS is a powerful tool for extracting, transforming and loading data, but creating and maintaining a large number of SSIS packages can be both tedious and time-consuming. Even if you use templates and follow best practices you often have to repeat the same steps over and over and over again. Handling metadata and schema changes is a manual process, and there are no easy ways to implement new requirements in multiple packages at the same time.
It is time to bring the Don’t Repeat Yourself (DRY) software engineering principle to SSIS projects. First learn how to use Biml and BimlScript to generate SSIS packages from database metadata and implement changes in all packages with just a few clicks. Then take the DRY principle one step further and learn how to update all packages in multiple projects by separating and reusing common code.
Speed up your SSIS development by using Biml and BimlScript, and see how you can complete in a day what once took more than a week!
Speaker(s):
- Cathrine Wilhelmsen
Track and Room: BI Platform Architecture, Development Administration - Room 217
Title: Tame Your Unruly Data…With Constraints!
Abstract: Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!
Speaker(s):
- Rob Volk
Track and Room: Application Database Development - Room 216
Title: What is your Character Data Type?
Abstract: This session focuses on what you need to know about working with SQL Server Data Types. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter will focus on the differences between character data types, working with implicit vs. explicit conversions and using conversion functions.
Speaker(s):
- John Deardurff
Track and Room: Application Database Development - Room 207
Title: Continuous Deployments using SSDT
Abstract: DevOps is a word that gets thrown around a lot these days and is the way most shops will operate in the future. In my presentation I’ll show you how to fast forward to the future by automating your deployments from SSDT using Powershell and SQLPackage.exe.
Speaker(s):
- Christopher Wolff
Track and Room: Application Database Development - Room 214
Title: Data Architecture 101
Abstract: This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!
You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!
This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.
Speaker(s):
- Pat Phelan
Track and Room: Application Database Development - Room 218
Title: Introduction to Window Functions
Abstract: SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could.
This session will teach you how to avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You’ll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
Speaker(s):
- Kathi Kellenberger
Track and Room: Application Database Development - Room 216
Title: Workload Replay: Synthetic vs Real-World Benchmarking
Abstract: How much do you really understand how your workload changes based on the time of day, background processing, user load, or which application module is in use? There’s no better way to understand your workload than to benchmark and replay it. This will help you mitigate risk in production before making changes, allow you to find and improve bottlenecks in your code or infrastructure. In this session, you will learn the process of using both synthetic (when applicable) and real-world capture tools to test your environment to make you look like a rockstar.
Speaker(s):
- John Sterrett
Track and Room: Enterprise Database Administration Deployment - Room 218
Title: Reporting Services 2016 Solutions: The New Awesome
Abstract: Your old favorite reporting tool just got a lot better. In the new world of SSRS, traditional RDL reports integrate with mobile dashboards, Power BI and Excel. You’ll receive guidance and learn best practices to design and orchestrate integrated reporting and BI solutions with improved Reporting Services features and the new report portal.
Speaker(s):
- Paul Turley
Track and Room: BI Information Delivery - Room 217
Title: Top 10 Clustering Dos and Don’ts
Abstract: Clustering SQL Server still vexes many in one way or another. For some, it is even worse now that both AlwaysOn features - clustered instances (FCIs) and availability groups (AGs) - require an underlying Windows Server failover cluster. Storage, networking, Active Directory quorum, and more are topics that come up quite often. Learn from one of the world’s experts on clustering SQL Server some the most important items - both good and bad - that you need to do to be successful whether you are creating an FCI, AG, or combining both together in one solution.
Speaker(s):
- Allan Hirt
Track and Room: Enterprise Database Administration Deployment - Room 215
Title: What is a Latch, and Why Do I Care?
Abstract: Latching is a necessary function of the database engine. Although latching is a topic is normally presented only in expert-level sessions, a good grasp of the problems excessive latching exposes is important even for novice tuners. This session focuses on the PAGELATCH_* and PAGEIOLATCH_* wait types, explaining what is happening, why it is happening, and how to use the exposed information to tune queries and solve performance problems. If you’ve seen these wait types in Activity Monitor and wonder what they meant, then this session is for you!
Speaker(s):
- Eddie Wuerch
Track and Room: Enterprise Database Administration Deployment - Room 216
Title: Transform Database Agility with XtremIO – EMC Sponsored Session
Abstract: Abstract: All-Flash Arrays deliver IOPS in abundance. XtremIO goes further to provide predictable, consistent sub-millisecond latency and unleash agility for your SQL Server databases. Our unique XtremIO Virtual Copies (XVC) capabilities allow for fully writable copies for production, test/dev, reporting/analytics workloads on our market leading consolidation platform. This allows for consolidation of your SQL Server based environments onto a single array to maximize efficiency.
Speaker(s):
- Wendy Pastrick
Track and Room: Strategy and Architecture - Room 216
Title: Spatial Data - Looking Outside the Map
Abstract: I’ve said it before and I’ll say it again, spatial data doesn’t get much love in SQL Server. It is a feature worthy of much appreciation and will become more vital as more location data is collected. In this session we will explore spatial data and discover many ways it can be used for incredible analytics. You will learn some new ways to visualize your data outside of the typical plots on a Bing map layer. Come and learn how powerful spatial data can be even though it lacks a snazzy “power” title.
Speaker(s):
- Hope Foley
Track and Room: Analytics and Visualization - Room 214
Title: Making the Leap from Developer to DBA
Abstract: You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.
Speaker(s):
- Amy Herold
Track and Room: Professional Development - Room 208
Title: DELL Sponsored Session - David Swanson
Abstract: TBA
Speaker(s):
- Wendy Pastrick
Track and Room: Other - Room 209
Title: Teaching Your Servers to Call For Help
Abstract: DBAs need to regularly monitor their servers for a regular health check. Running the daily checklist becomes tedious and requires a lot of time. In this session, SQL Server MVP Mike Hillwig will teach you his signature “See Something, Say Something” method. You’ll learn how to use the SQL Agent to turn the daily checklist into actionable alerts. By leveraging the SQL Agent severity alerts and some basic scripting techniques, you’ll stop mindlessly going down a checklist and instead have your servers tell you when there is a problem.
Speaker(s):
- Mike Hillwig
Track and Room: Enterprise Database Administration Deployment - Room 208
Title: Intro to Monitoring I/O: The Counters That Count
Abstract: For many engineers, interpreting disk I/O is a black art. Yet analyzing perfmon, virtual file stats, wait stats is typically straightforward. This session provides authoritative, clear guidance on collecting interpreting disk I/O metrics.
Speaker(s):
- J May
Track and Room: Enterprise Database Administration Deployment - Room 218
Title: Analyze your query plan like a Microsoft Engineer!
Abstract: This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the “noteworthy” query plan patterns that go beyond the normal areas that customer tend to investigate. This session covers SQL Server 2005 forward and includes the new SQL Server 2016 Query Store and Live Query Statistics.
Speaker(s):
- Daniel Janik
Track and Room: Advanced Analysis Techniques - Room 214
Title: Introduction to Indexes and SARGability
Abstract: Did you know that there is more than one type of index? Do you know the differences between them? Do you know when SQL Server flat out can’t use an index? Join Jared Karney as he explains the differences between the types of indexes and when they can and cannot be used (SARGability). He will talk about the different ways they are used and how you can make good indexes even better. You will leave this session understanding the basics of indexes and how they work, which is crucial to making your queries and servers perform well.
Speaker(s):
- Jared Karney
Track and Room: Application Database Development - Room 218
Title: Be a Role Model for Women in Tech through Blogging
Abstract: Have you wanted to start giving back to our amazing SQL Community through writing, but are not sure how to start? Do you want to start blogging, but are anxious about criticisms? Are you unsure what to write about? I’ll walk through how to find topics to start writing about. I’ll go over tools to help you blog, and websites that you can start blogging about. We’ll discuss why it’s import to be a woman blogger, and I’ll share with you my experience over the last three years as a woman blogger in our community. Role models are needed for women in tech. They need to know that they are wanted in the community and that they have a voice. Be that role model through blogging.
Speaker(s):
- Mickey Stuewe
Track and Room: Professional Development - Room 214
Title: Shortcuts from an Impatient DBA
Abstract: This session is about performance tuning your day.
We spend a lot of time thinking about how to write efficient code, but we don’t spend a lot of time thinking about how to be efficient at writing code. In this session I will show you some lesser known keyboard shortcuts, tips, tricks, and hacks that will make your day easier. These are the tricks I’ve picked up over the years that help me get my work done quicker and easier.
Speaker(s):
- Andy Mallon
Track and Room: Professional Development - Room 209
Title: Designing SQL Server HA/DR Infrastructure to meet the SLA
Abstract: Once you agreed to an SLA for the databases you manage its time to deliver on this promise This session will show how to select from the many HA/DR features you have in SQL Server to pick the ones that will help you meet the SLA and most important will tell you how you must combine them to be successful. For each one of the solutions we discuss we will define a series of failure modes and then check if the solution actually can fulfill the SLA as promised or if it needs more
Speaker(s):
- Thomas Grohser
Track and Room: Enterprise Database Administration Deployment - Room 217
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: BI Platform Architecture, Development Administration - Room 218
Title: IO Whack-a-Mole
Abstract: Disk IO for a virtualized SQL Server database takes a mysterious journey. In this session we will take the mystery out of virtual disk IO. Using common infrastructure tools we will explore the path of a disk IO and share repeatable methods that can be used to quickly identify the cause of a performance bottleneck. Along the way we will explore SQL Server, the Virtual Machine, the hypervisor, virtual switches, physical switches, and the storage.
Speaker(s):
- Christopher Slater
Track and Room: Enterprise Database Administration Deployment - Room 208
Title: SQL Server and PowerShell: Let’s Get Serious
Abstract: Whether you’ve dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell is something worth learning to make your life as a SQL Server professional easier. Whether you’re a DBA, a SSIS developer, or security professional, In this session you’ll see practical, real world examples of how you can blend SQL Server and PowerShell together, and not just a bunch of regular T-SQL tasks that have been made more complicated.
Speaker(s):
- Drew Furgiuele
Track and Room: Enterprise Database Administration Deployment - Room 209
Title: Common TSQL Mistakes
Abstract: We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application’s performance. I have given this talk over SEVENTY times now and it is always very highly rated!
Speaker(s):
- Kevin Boles
Track and Room: Application Database Development - Room 209
Title: Effortless Backups with Minion Backup
Abstract: Let’s take the new, free backup tool out for a spin. We can hop through a quick installation, glance at the multi-install PowerShell script, and dance around the table-based schedules, for a start. Afterward we’ll have a long, leisurely walk through some of the best things you can do with MB: backup ordering, pre- and postcode, live insight, striping and mirroring, and of course so much more. Feel free to download MB and follow along on your own laptop!
Speaker(s):
- Jennifer McCown
Track and Room: Enterprise Database Administration Deployment - Room 207
Title: Power BI - Explore SQL Server Database and Performance Metrics
Abstract: Power BI is a powerful analytics tool. It allows users to easily shape and transform their data into actionable insights in a very short period of time. We’ll explore how the tool can connect to your SQL Server database and allow you to visualize Database and Performance Metrics, such as, file size, Buffer Pool and Plan Cache, Wait Stats and more. We will create visualizations and reports in Power BI Desktop using SQL queries, publish that information to the Power BI Service, and walk through sharing and mobile consumption. The goal of this session is to provide you with a better understanding of how to leverage Power BI for yourself and your organization.
Speaker(s):
- Seth Bauer
Track and Room: BI Information Delivery - Room 216
Title: Are You Optimistic About Concurrency?
Abstract: What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012’s SNAPSHOT Isolation optimistic? How can SQL Server 2014’s In-Memory OLTP provide truly optimistic concurrency? In this session, we’ll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!
Speaker(s):
- Kalen Delaney
Track and Room: Enterprise Database Administration Deployment - Room 217
Title: Performance Monitoring AlwaysOn Availability Groups
Abstract: Have you deployed Availability Groups in your data center? Are you monitoring your Availability Groups to ensure you can meet your recovery objectives? If you haven’t this is the session for you. We will discuss the importance of monitoring and trending Availability Group Replication, how AGs move data between replicas and the impact replication latency can have on the availability of your systems. We’ll also give you the tools and techniques to go back to the office and get started monitoring and trending right away!
Speaker(s):
- Anthony Nocentino
Track and Room: Enterprise Database Administration Deployment - Room 218
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Peter Shore
Twitter: - pshore73
LinkedIn: Peter Shore
Peter Shore is a seasoned IT professional with over 25 years of experience. He took the accidentally intentional DBA plunge in 2013 and has discovered that he loves to find the stories the data has to tell. Peter is comfortable working with both physical and virtual servers, where he tries to apply best practices to attain performance improvements. He is also adept at bridging the gap between technical and business language in order to bring technology solutions to business needs.
Jared Karney
Twitter: - jaredkarney
LinkedIn: Jared Karney
Jared Karney has been working with SQL Server since 2007. He currently works as a Premier Field Engineer for Microsoft. His specialties include performance tuning, big data, cloud, automation, internals, and overall architecture. He is an MCT and holds a number of Microsoft certifications. He is also a leader for the Chicago SQL Server Users Group.
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.
Daniel Janik
Twitter: - @SQLSME
LinkedIn: Daniel Janik
Contact: http://www.sqltechblog.com
Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQLSaturdays.
Brandon Leach
Twitter: - SQLServerNerd
LinkedIn: Brandon Leach
A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.
Anthony Nocentino
Twitter: - nocentino
LinkedIn: Anthony Nocentino
Contact: http://www.centinosystems.com/blog/
Anthony Nocentino is the founder and President of Centino Systems as well as a Pluralsight author, Microsoft Data Platform MVP, Linux expert, and corporate problem solver. Anthony designs solutions, deploys the technology, and provides expertise on business system performance, architecture, and security. Anthony has a Bachelors and Masters in Computer Science with research publications in high performance/low latency data access algorithms and spatial database systems.
Eddie Wuerch
Twitter: - @EddieW
LinkedIn: Eddie Wuerch
Contact: http://www.indydba.com
Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.
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.
Christopher Wolff
Twitter: - @tickytong
LinkedIn: Christopher Wolff
Contact: http://sqlred.blogspot.com/
Chris Wolff has been a developer, report writer, and an admin in Microsoft and SQL Server Space since SQL Server 2000 in industries such as telecommunications, green energy, money transfers, and online accounting. He has been an active member of the Denver SQL User Group since 2011 and enjoys learning new things about computers. His interests includes video games, movies, and enjoying time with his wife and 2 kids.
Mike Hillwig
Twitter: - @mikehillwig
LinkedIn: Mike Hillwig
Contact: http://www.mikehillwig.com
Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.
Josh Fennessy
Twitter: - @joshuafennessy
LinkedIn: Josh Fennessy
Contact: http://www.joshuafennessy.com
Josh Fennessy, Solution Architect at BlueGranite, has been building solutions with the SQL Server BI stack for 8 years. He is a Microsoft Certified Solutions Expert in Business Intelligence. Josh#39;s passions include manipulating data in novel ways to open analytic possibilities not before possible.
Josh is active in the SQL Server and Open Source communities. Beyond relational and OLAP data projects, Josh is also involved in projects using cluster computing platforms such as Hadoop.
Kathi Kellenberger
Twitter: - auntkathi
LinkedIn: Kathi Kellenberger
Contact: http://auntkathisql.com
Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.
Amy Herold
Twitter: - @texasamy
LinkedIn: Amy Herold
Contact: http://www.sqlkitten.com/
Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQLSaturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.
Fred Bliss
Twitter: - twitter.com/fblissjr
LinkedIn: Fred Bliss
Contact: http://www.fredandjulia.com
Fred has over 10 years of experience primarily focused in the technical implementation of complex business problems, with an emphasis on data-related development and architecture. Fred#39;s past work has included all phases of the design and development of data solutions, including cloud integration, data warehouse modeling, ETL, and front-end reporting implementations.
Fred#39;s current professional interests include taking advantage of complex computing to incorporate big data and machine learning elements into enterprise data warehouses, as well as using web services to integrate cloud data with other enterprise data.
Fred lives in Chicago with his wife, Julia, and his daughter, Claire.
Paul Turley
Twitter: - paul_turley
LinkedIn: Paul Turley
Contact: http://www.sqlserverbiblog.com
Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.
David Giard
Twitter: - @DavidGiard
LinkedIn: David Giard
Contact: http://DavidGiard.com
David Giard is a former accountant and a former biochemist, who has been developing solutions using Microsoft technologies for over 2 decades. Currently, David helps people build solutions in his role as a Microsoft Technical Evangelist. David has been very active in the developer community, speaking at numerous major conferences, code camps, and user groups around the world; helping to lead user groups; and helping to organize conferences and other geek events.
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.
Wendy Pastrick
Twitter: - @wendy_dance
Contact: http://wendyverse.blogspot.com
Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.
J May
Twitter: - @aspiringgeek
LinkedIn: J May
Contact: http://blogs.msdn.com/jimmymay
Jimmy May is a Microsoft Certified Master (MCM). He’s formerly a Principal Architect at Microsoft as well as Senior Program Manager for the SQL Server Customer Advisory Team (SQL CAT) where he managed the Customer Lab which hosts the biggest, fastest, most interesting SQL Server apps from all over the world. More recently he was a SQL Server Technologist for what was Fusion-io’s Data Propulsion Lab (DPL). He is a founder of the IndyPASS IWUG user groups.
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.
John Martin
Twitter: - SQLDiplomat
LinkedIn: John Martin
Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/
John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK.
John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.
Thomas Norman
Twitter: - ArmorDba
LinkedIn: Thomas Norman
Contact: https://armordba.com/
Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.
Warner Chaves
Twitter: - @warchav
LinkedIn: Warner Chaves
Contact: http://sqlturbo.com
Warner is a SQL Server MCM, Data Platform MVP and Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, building and managing data solutions in many industry verticals while leading a highly talented team of Data Platform consultants.
Mark Broadbent
Twitter: - @retracement
LinkedIn: Mark Broadbent
Contact: http://tenbulls.co.uk
Mark Broadbent is a Data Platform MVP and SQL Server MCM with more than 20 years of experience working with SQL Server and principal of SQLCloud, a consultancy specializing in concurrency control and highly available solutions. He is the founder of the UK’s SQLSaturday Cambridge (its first and largest), SharePoint Saturday Cambridge, the Hybrid Virtual Chapter and the East Anglia SQL User Group.
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.
Keith Tate
Twitter: - https://twitter.com/keith_tate
LinkedIn: Keith Tate
Contact: http://thesqlchef.com
Keith Tate is a Senior Database Administrator with over 17 years of experience as a data professional. During Keith#39;s professional career he has been a developer, DBA and data architect. Keith is also active in the SQL Server community and is currently the chapter leader of the Albuquerque SQL Server User Group.
Paul Popovich Jr
Twitter: - @pmpjr
LinkedIn: Paul Popovich Jr
Contact: https://pmpjr.wordpress.com/
Paul Popovich Jr. has been in the IT space for his whole career and tinkering with computers since his 486 PC back in the mid 1990s. Professionally he is a senior DBA for a large hospital system. You can find on twitter @pmpjr, email at paulpopovichjr@gmail.com.
Kevin Feasel
Twitter: - feaselkl
LinkedIn: Kevin Feasel
Contact: http://www.catallaxyservices.com
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.
John Sterrett
Twitter: - JohnSterrett
LinkedIn: John Sterrett
Contact: https://johnsterrett.com/community/
John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John’s community activities can be found at https://johnsterrett.com/community/
Austin Senseman
Twitter: - https://twitter.com/austinsense
LinkedIn: Austin Senseman
Contact: http://www.powerpivotpro.com
Austin spent the last five years using Modern Excel in the field to solve analytical challenges for the financial services industry, first at BBVA and later at Harbert Management Corporation. As a former analyst, Austin is focused on enabling other data professionals to experience the joys of Power Pivot Power BI. Austin is a CFA Charterholder, former CPA, Excel Power User, and SQL Server Professional, whose involvement in data/analytics projects lowers the communication costs between business users and IT professionals and helps organizations get to solutions faster.
Thomas Grohser
LinkedIn: Thomas Grohser
Thomas Grohser has spent most of the past 26+ years 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 has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.
Ross LoForte
Ross LoForte is a Technology Architect at the Microsoft Technology Center in Chicago focused on SQL Server solutions. With more than 16 years of business development, project management, and SQL architecture solutions experience, he has been working with the Microsoft Technology Centers the past 10 years and has led architecture design and proof-of-concept engagements for Microsoft’s largest and most strategic customers to design enterprise, mission-critical SQL Server solutions.
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.
George Walkey
Twitter: - sqlbytehd
Contact: http://insyncva.com
SQL Server DBA, Developer, IT Manager, Business Owner from the Richmond, VA USA Area Interested in pushing the limits of both hardware software and my own brain
Rob Volk
Twitter: - sql_r
LinkedIn: Rob Volk
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
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.
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.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Wendy Pastrick
Twitter: - @wendy_dance
Contact: http://wendyverse.blogspot.com
Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.
Drew Furgiuele
Twitter: - pittfurg
LinkedIn: Drew Furgiuele
Contact: http://www.port1433.com
Drew Furgiuele is a senior DBA that lives in Dublin, Ohio who is passionate about SQL Server and PowerShell. He’s been working with SQL Server since 2002. When he’s not accidentally dropping tables in production, he likes writing automation scripts, blogging about SQL Server Replication, wiring electronics, playing board games, and spending time with his dog. He’s also not embarrassed by his Spotify playlists.
Adam Belebczuk
Twitter: - @SQLDiablo
LinkedIn: Adam Belebczuk
Contact: http://www.sqldiablo.com/
Adam Belebczuk is the Owner amp; Principal Consultant at Belebczuk Consulting Services, LLC and has more than 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL Server development, performance tuning, high availability, and disaster recovery.
Jennifer McCown
Twitter: - http://www.Twitter.com/MidnightDBA
LinkedIn: Jennifer McCown
Contact: http://www.MidnightDBA.com/Jen
Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.
Jason Horner
Twitter: - jasonhorner
LinkedIn: Jason Horner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.
I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.
In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
Allan Hirt
Twitter: - SQLHA
LinkedIn: Allan Hirt
Contact: http://www.sqlha.com/blog
SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.
Mickey Stuewe
Twitter: - @SQLMickey
LinkedIn: Mickey Stuewe
Contact: http://www.MickeyStuewe.com
Mickey Stuewe has been working with SQL Server since 6.5. That gives her over 20 years of experience. She has not only been a database developer, but also an application developer, even before Visual Studio existed. She is now thankful to be focusing on database design, t-SQL development, and query optimization. She also has a habit of enjoying SSIS and data warehouse design.
She blogs regularly on her website mickeystuewe.com and contributes to sites such as SQL Server Central and SQL Server Pro. She enjoys presenting at PASS Summit, SQLSaturdays, User Groups and other events.
When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often…just ask her children.
Cathrine Wilhelmsen
Twitter: - @cathrinew
LinkedIn: Cathrine Wilhelmsen
Contact: https://www.cathrinewilhelmsen.net/
Cathrine loves teaching and sharing knowledge :) She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Warehousing, Data Integration, Analytics, and Reporting projects. Her core skills are Azure Data Factory, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she’s active in the SQL Server community as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.
Andy Mallon
Twitter: - AMtwo
LinkedIn: Andy Mallon
Contact: http://www.AM2.co
Andy is a Data Platform MVP and SQL Server DBA that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. He has been supporting high-volume, highly-available OLTP environments with demanding performance needs since 2003.
Andy is the founder of the BostonSQL User Group, and previous co-organizer of SQLSaturday events in Boston. He blogs at am2.co.
Andy lives just outside Boston, Massachusetts, USA with his husband and their two dogs.
Sean McCown
Twitter: - @KenpoDBA
Contact: http://www.midnightdba.com/dbarant
Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
Juan Soto
Twitter: - jsoto22
LinkedIn: Juan Soto
Contact: https://accessexperts.com/blog/
I’m the President of IT Impact, a Microsoft Access MVP and a frequent author on the official Microsoft Access blog as well as the first Access developer to be profiled on their site. I’m also a frequent speaker at Access User Groups throughout the USA, covering subjects such as SQL Server with Access as well as providing tools and resources for Access developers on the web. My expertise is optimizing Access with SQL Server and helping SQL Server DBAs understand how to design tables for Access.
Pat Phelan
Twitter: - @YetAnotherSQL
LinkedIn: Pat Phelan
Pat Phelan first joined a computer user group (DECUS) in High School, and has joined many more since then. Pat worked many jobs in high school and college, and over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team. Involta builds, owns and operates world class colocation datacenters and also provides managed services and support staff to clients.
Christopher Slater
LinkedIn: Christopher Slater
Christopher Slater has over 20 years of experience working at the intersection of database, virtualization, and storage technologies. At Tintri he helps customers virtualize business critical applications and production database workloads on Tintri storage with VMware and Hyper-V. Christopher has presented at a number of technical conferences, including VMUG, SQL PASS, OAUG, and OracleWorld.
Grant Fritchey
Twitter: - @gfritchey
LinkedIn: Grant Fritchey
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
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.
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
Seth Bauer
Twitter: - https://twitter.com/Eno1978
LinkedIn: Seth Bauer
Seth Bauer is a Technical Architect with Concurrency Inc. He is a Microsoft Data Platform MVP (Power BI) and a Microsoft Certified Professional. He is the leader of the Milwaukee “Brew City” Power BI User Group in the Milwaukee and Brookfield Wisconsin area. He has partnered with Mike Carlo and produces tools and PowerBI related content on PowerBI.tips. And is a major contributor in the Microsoft Power BI Community forum. His major focus area is Power BI, and sharing what he’s learned with the user Community. He enjoys working with clients across the Midwest implementing BI / Power BI solutions.
Hope Foley
Twitter: - hope_foley
LinkedIn: Hope Foley
Contact: http://www.hopefoley.com
Hope Foley, a former Data Platform MVP, has worked across many industries as a DBA and Business Intelligence consultant. She joined team at Microsoft and is a Data AI Technology Solutions Professional. She has worked with enterprise customers but now focuses on education. Hope is an active member in the SQL Server and PASS communities speaking at events and organizing the SQLSaturday event in Indianapolis.
Sponsors
The following is a list of sponsors that helped fund the event: