SQLSaturday #530 - Indianapolis 2016
Event Date: 08/13/2016 00:00:00
Event Location:
- Indiana Wesleyan University North
- 3777 Priority Way South Drive
- Indianapolis, Indiana
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: DBA 102: Now What
Abstract: Things happened, you got a knock on the head and when you awoke your boss said “congratulations” you are our new DBA, perhaps you came to the role in a more intentional manner or are just DBA curious. Your environment is running but you are wondering “now what” or “what’s next”. In this session we will give an overview of a few things that could, perhaps even should be next and give some recommendations as to where you can find more resources on-line and maybe even suggest a few sessions to attend at this very SQLSaturday. So, what will be covered, recovery strategy (you think I mean backups, I don’t, you’ll see why), a touch on performance tuning with a hint of indexing thrown in, add a pinch of high availability and a smattering of security all of which will give you some idea how to answer “now what”.
Speaker(s):
- Peter Shore
Track and Room: Enterprise Database Administration Deployment - Room 108/110
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 108/110
Title: Learning and Optimizing the SQL Server Plan Cache
Abstract: SQL Server memory management is one of the most important aspects of a writing T-SQL code. And yet many of us don’t know the fundamentals beyond “SQL Server will take care of that”. In this session, we’ll go deep into the internal behavior of the plan cache. We’ll cover four main problem scenarios within the plan cache, what causes them, and how to fix them, including:
- Bloating – scenarios that cause SQL Server to needlessly waste space in the plan cache.
- Suboptimal plans – scenarios where SQL Server can’t help but choose a bad execution plan, usually self-inflicted.
- Parameter sniffing – situations in which SQL Server specifically chooses a bad execution plan do to the type of parameters pass into T-SQL code.
- Recompiles – situations where SQL Server is unable to completely process a block of T-SQL code without having to recompile it.
If you don’t know much about SQL Server memory management, especially if you write T-SQL code, then this session is for you! You’ll learn
Speaker(s):
- Kevin Kline
Track and Room: Application Database Development - Room 208/210
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 108/110
Title: Why “R” you not leveraging the power of “R” in Power BI?!?
Abstract: R is a very powerful statistical programming language that has been gaining a lot of traction in recent years. In early 2015 Microsoft acquired Revolution Analytics, a major provider of software and services for R. Microsoft has since incorporated R in Azure ML, SQL Server 2016, and Power BI.
In this session I will focus on the benefits of using R in Power BI. I will show how to leverage R for data munging (ETL) and I will also show how to leverage R to create custom visualizations. I will focus on the “Wickham stack” which is a group of very popular R packages developed by Hadley Wickham. The “Wickham stack” includes the ggplot2, dplyr, and tidyr packages. I will discuss logical use cases for using R within Power BI as well as some of the pitfalls that you may run into.
Speaker(s):
- Ryan Wade
Track and Room: BI Platform Architecture, Development Administration - Room 208/210
Title: Stretch Database and Managed Backups: Cloud Services for your SQL Servers
Abstract: Utilizing Azure cloud services does not mean moving all of your data or control away from your on-premises SQL Servers. In this session we will cover the new SQL 2016 Stretch Database and the SQL 2014 Managed Backups to Azure features. We will look at use-cases and limitations of both features to illustrate how these cloud services may fit into your current SQL Server environment.
Speaker(s):
- Andrew Loree
Track and Room: Enterprise Database Administration Deployment - Room 104
Title: SQLStarter - Intro to Data Science
Abstract: Session in the SQLStarter beginner track to introduce data science careers. Will discuss aspects of what this job entails and what day to day could look like in this career path. We’ll go over important skills and where to find training information.
Speaker(s):
- Dave Leininger
Track and Room: SQLStarter Beginner - Room 202
Title: SQL Server 2016 “Hidden Gems”
Abstract: By far the most important SQL Server release since the heady days of 2005, SQL Server 2016 represents a huge leap forward in a number of key areas. You’ve no doubt heard plenty about such features as Query Store, JSON support, Polybase, and the other big-ticket items. But there are also a number of very cool features that don’t usually make the top 10 lists. In this talk you’ll learn about enhancements to indexing (including both Columnstore and traditional b-tree indexes), DMVs, compression, string handling, encryption, configuration, and even timezone support. These smaller features may not be highlighted in the latest glossy ads from Microsoft’s marketing department, but they’re the kinds of things that add up to make your life easier. Attend this session to learn all sorts of new and different reasons to upgrade as quickly as possible.
Speaker(s):
- Adam Machanic
Track and Room: Application Database Development - Room 208/210
Title: Overcoming Chartaphobia with Power BI
Abstract: Do reports in your organization consist mostly of giant tables of data? Perhaps you have gotten as far as adding KPI indicators or conditional highlighting to the tables. Maybe you have charts, but they are hideous and distracting. Although tables of data presented as reports are commonly found in many organizations, they may be doing you and your users a disservice. We’ll discuss why cognitive psychological studies tell us that graphs and pictures are more effective at communicating trends and comparisons and how to prepare to create good data visualizations. Then we’ll explore how to employ purposeful data viz designs to help users achieve their goal of making informed decisions, using a fun and useful Power BI dashboard. You’ll leave with guidance on how to take boring or unreadable tables of data and turn them into useful and visually appealing reports.
Speaker(s):
- Meagan Longoria
Track and Room: BI Information Delivery - Room 108/110
Title: Azure, PowerShell, and SQL Server Virtual Machines
Abstract: While the web portal makes it easy to deploy SQL Server on Azure Virtual Machines, there are a number of benefits to using PowerShell to do the job. This session will introduce Azure PowerShell command-lets and how to create a basic Azure infrastructure to support a SQL Server VM. We’ll include the Azure Resource Manager, how to use ARM VM templates and Custom Script Extension, and how users can modify an existing Azure Gallery template. Desired State Configuration (DSC) will be covered to complete the Azure Powershell automation toolkit, allowing attendees to automate the deployment of dozens or more SQL Server virtual machines. Finally, we will configure Availability Groups and explain their eccentricities in the Azure environment as well as how to make them work effectively.
Speaker(s):
- Rob Volk
Track and Room: Enterprise Database Administration Deployment - Room 200
Title: Speed Up Your SSAS Cube’s Data Refresh With Dynamic Partition Processing
Abstract: Are you sometimes plagued with the unfortunate event of your SSAS cube refresh exceeding the scheduled maintenance window? Maybe you simply need to update recent data to reflect a critical change during business hours, but can’t afford several hours of downtime. I have a solution for you! In this session, we will focus on building an ETL framework while leveraging your cube’s logical partition design to dynamically process only the necessary data within your measure group. We will discuss audit logging, cube processing options, partition design and metadata access. These techniques and strategies will provide a faster data refresh process for your warehouse or data mart.
Speaker(s):
- Jeremy Frye
Track and Room: BI Platform Architecture, Development Administration - Room 114
Title: Performance Pitfalls from Code Reuse
Abstract: Have you ever found yourself deconstructing endless layers of nested code? Is your T-SQL codebase written in an object-oriented format with functions views? Did you know that object-oriented code reuse can come at a significant penalty?
Come to this session and learn why applying object-oriented principles can be extremely detrimental to your T-SQL’s performance. You will learn how T-SQL is not like other common programming languages. We will peek inside the Query Optimizer to see how it handles these scenarios. Through extensive demos, we will explore solutions to maximize performance. You will be introduced to a T-SQL tool that will aid you in unraveling nested code. Alternate design patterns will be shown to help you mitigate these performance pitfalls.
Speaker(s):
- Andy Yun
Track and Room: Application Database Development - Room 113
Title: Introduction to Azure Streaming Analytics
Abstract: This session will cover what is Streaming Analytics and the various use cases. We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review. The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.
Speaker(s):
- Warren Sifre
Track and Room: Cloud Application Development Deployment - Room 215
Title: Execution Plans for Mere Mortals
Abstract: Abstract: As a beginner database professional, execution plans are intimidating. In this 1 hour session, I will take you through the basics of reading graphical execution plans and drill into key operators, warnings and properties. Prerequisites: Basic understanding of T-SQL and the SQL Server Engine. Sections: • You will understand how, why and when the execution plan will be created and saved to plan cache. • Reading the execution plan will be much less intimidating as you can talk through the flow and process of a graphical execution plan. • After looking at the key operators you will be able to analyze the operators of your execution plans, the operator properties and identify common performance issues and tuning opportunities. • Finally, you will be able to capture the execution plan, save it for later analysis and comparison after modifications have occurred.
Speaker(s):
- Mike Lawell
Track and Room: Enterprise Database Administration Deployment - Room 200
Title: TempDB Done Right
Abstract: Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. There are additional concerns when using Always On Availability Groups. This session will dig into many of the otherwise-hidden issues that can kill server performance. Attend this session and you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.
Speaker(s):
- Eddie Wuerch
Track and Room: Enterprise Database Administration Deployment - Room 108/110
Title: SQLServer to Google Earth: visualizing spatial data in KML format
Abstract: Visualizing SQLServer spatial data in Google Earth is easy enough and can be done in a variety of ways. See these various techniques demonstrated and discuss the relative strengths and weaknesses of each approach. These same techniques can be adapted for use with other spatial analysis software packages.
Speaker(s):
- Frank Murphy
Track and Room: Analytics and Visualization - Room 215
Title: Peanut Butter Chocolate: Integrating Hadoop with SQL Server
Abstract: So you jumped on the bandwagon and set up a Hadoop cluster…but now what? Your database developers and app developers know how to integrate with and develop against SQL Server, but the Hadoop world is a completely different experience. This talk will help bridge the gap between SQL Server and Hadoop, using tools such as SQL Server Integration Services and Sqoop to migrate data between a Hadoop cluster and a SQL Server instance, as well as PolyBase to integrate the two like never before.
Speaker(s):
- Kevin Feasel
Track and Room: Application Database Development - Room 208/210
Title: Connecting Power BI to On-Prem Data with SSAS
Abstract: Microsoft Power BI is going great places. Its great visualizations, easy-to-use tools, and robust sharing capabilities are improving with new releases almost every time you turn around. But, what if uploading or storing your company’s data in the cloud is a potential deal-breaker? Fortunately, the Microsoft Power BI Gateway - Enterprise make it possible to live query data in an on-premises SSAS instance for display in Power BI. In this session, we will go through what this gateway does, how it works, and how it is installed to show that BI in the cloud doesn’t require data in the cloud.
Speaker(s):
- Kerry Tyler
Track and Room: BI Information Delivery - Room 215
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 113
Title: Making the Accidental DBA Look Good: Ten Insights You Need to Hav
Abstract: No one grows up saying they want to be a DBA yet there are plenty of us out there. Once in the role you never intended to be in you may find it hard to know where to go to answers - or even what questions to ask. You may find yourself struggling for time to accomplish all you need to do. You’re going to feel overwhelmed and be looking for support from others but not know where to turn. In this highly interactive session join Tim as he helps you navigate the most common questions you’ll likely face in your first years as a DBA - including a few you may not have considered - and where to go for those answers. He will also give you some of those insider shortcuts that it takes years to stumble across if your lucky. Finally we’ll discuss your support mechanisms and he community of like-minded people standing by your side globally and virtually.
Walk away from this session renewed, energized, and full of new insights… plus a downloadable cheat sheet for quick reference!
Speaker(s):
- Tim Ford
Track and Room: Enterprise Database Administration Deployment - Room 104
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 200
Title: ORMs… can’t live with ‘em, can’t kill ‘em.
Abstract: Object-relational mappers enable developers to work with relational databases like Microsoft SQL using the languages they know and love. Sometimes that means that the developers don’t know the underlying queries and statements being sent to the database. This doesn’t mean that the developers don’t love SQL. It just means that they don’t know it yet.
In this session, we’ll look at the latest builds of Microsoft’s Entity Framework and see what programming tools developers use to work with SQL databases. We’ll also take a look at Sequelize. Sequelize is an open source ORM written in JavaScript for Node.js.
We’ll take a look at code first development, advanced querying techniques, connecting to existing databases and migrations. We’ll also take a look at lazy and eager loading techniques. We’ll take a look at these two ORM’s from the eyes of the developer and the DBA.
Speaker(s):
- Aaron King
Track and Room: Application Database Development - Room 113
Title: Word Up: Text Mining in SQL
Abstract: Would a database by any other name smell as sweet?
Our databases are filled with words. By mining our text for patterns and meanings, we can extract the emotional content, track changes over time, ferret out plagiarism, find common phrases and usage, and even predict future text.
Learn how to dig through your library of language to make your data better.
Speaker(s):
- Dave Mattingly
Track and Room: Advanced Analysis Techniques - Room 215
Title: Web APIs for the BI Developer
Abstract: There are thousands of web APIs offering data on a wide range of topics. Web APIs are also a very common way for vendors to provide data to their clients. This session aims to demystify concepts such as REST, tokens, etc., and show you how to obtain data from the web using the SSIS Script Task, PowerShell, and Power Query.
Speaker(s):
- Chris Koester
Track and Room: Application Database Development - Room 208/210
Title: Wait Statistics - The Top 5 Waits You Should Know
Abstract: Wait statistics are a great tool for troubleshooting performance problems in SQL Server. However, there are so many different wait types in SQL Server, it can be challenging to determine what to focus on and what can be ignored. Even after discovering that SQL Server is waiting for something, most DBAs don’t know where to look next. In this session, we’ll examine 5 of the most frequently seen wait types in SQL Server and how to troubleshoot each of them. You’ll learn how to determine the root cause of a particular wait type, and how to avoid common mistakes made when troubleshooting with wait statistics.
Speaker(s):
- David Maxwell
Track and Room: Enterprise Database Administration Deployment - Room 104
Title: Explore the Microsoft Azure Data Landscape
Abstract: The Microsoft Azure ecosystem has exploded in size and variety in recent years. There are now a multitude of ways to persist your data in the cloud. Trying to choose among the different options can be a daunting task. In this session we will examine the use cases, strengths, and weaknesses of the following data services: SQL Database, SQL Data Warehouse, Document DB, Redis Cache, Storage (Table, Queue, and VM), and Azure Data Lake Store.
Speaker(s):
- Bradley Nielsen
Track and Room: Application Database Development - Room 113
Title: All things you need to know before you start setting up SQL AlwaysOn
Abstract:
Running the Availability Group Wizard, or installing a clustered SQL instance can go pretty smoothly. But in complex and larger networks, that is not always the case. Even if the wizards complete without error and you think you have a highly available system, you may not.
This session will review all the gotcha’s and things you need to know before you run the shiny wizard or run some PowerShell to make your HA/DR implementation of SQL a success.
Speaker(s):
- Michael Steineke
Track and Room: Enterprise Database Administration Deployment - Room 104
Title: Power BI SharePoint - A Marriage Made in Redmond
Abstract: We will explore the relationship between SharePoint and Excel, how Power BI swooped SharePoint off her feet, and the current Business Intelligence soap opera that stars all three. Using live demos, we will look at data interaction between SharePoint, Excel, Power BI (including the iOS app), and the intriguing new next door neighbor - Microsoft Flow.
Speaker(s):
- Daniel Glenn
Track and Room: BI Platform Architecture, Development Administration - Room 114
Title: Administration, Security and Data Management in Power BI
Abstract: Attendees will learn Power BI’s administrative features providing security and best practice methods for development and deployment. As Power BI does not use network security, the importance in things like Group Workspaces to ensure visualizations aren’t lost when people leave the organization are discussed. Practices to increase scalability over time are reviewed. Development of content packs are explored to increase adoption of Power BI while establishing data access standards using scheduled refreshes with gateways. Licensing strategies and use of One Drives and their impact on update strategies are also reviewed. Without any guidelines, many organizations proliferate data models over time leading to complaints about data accuracy as updates can be random. Learn processes for the use of gateways and their role to prevent rampant data model and create the ability to maintain the quality of the visualizations over time to provide a usable data framework for Power BI.
Speaker(s):
- Ginger Grant
Track and Room: BI Platform Architecture, Development Administration - Room 114
Title: Pyramid Analytics BI to Transform into a Data-Driven Organization
Abstract: Pyramid Analytics’ industry-leading Modern BI platform balances IT control and business user success. It offers enterprise capabilities such as advanced data modeling, self-service data discovery, interactive dashboards, and narrative reporting on any device. Here’s what makes Pyramid Analytics unique: #183; A true analytics platform that combines the security and stability of IT governance with the flexibility and utility of user-driven analysis #183; A scalable platform that supports the volume and variety of data, subject areas, and users across the enterprise #183; The BI Office collaboration engine lets users share analysis, comments, and context to bring the power of the collective to every decision #183; Enterprise-grade, role-based security that enables the right access for the appropriate audiences across the platform – even down to the cell level of content #183; Merging advanced visuals and powerful analytics as well as Pyramid#39;s integration with Power B
Speaker(s):
- Andrew Mauch
Track and Room: Other - Room 208/210
Title: How to Speak Australian: Oracle for the SQL Server Developer
Abstract: Even in the career of a SQL Server and/or MSBI expert, you will undoubtedly encounter Oracle databases – most often as source systems or data migrations. While the underlying structures and languages are mostly similar, there are a few differences which can be stumping. We’ll highlight some differences, including: Connecting to Oracle, Databases and schemata, object naming, and differences between T-SQL and PL/SQL, and tool selection.
Speaker(s):
- Britton Gray
Track and Room: Application Database Development - Room 113
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 108/110
Title: XML X-Treme!
Abstract: At some point we’ve all had to work with XML, and you may have even searched XML documents in a text editor. However, did you know that you can query XML documents within SQL Server? In this session, I’ll show you how you can query XML documents as a data source right along with SQL Server tables and how to optimize your queries for better performance. You’ll learn how to check conditions that determine if the data you need exists and how to deal with incomplete or missing data.
Speaker(s):
- Aaron Cutshall
Track and Room: Application Database Development - Room 200
Title: Adding Lightness: Better Performance Through Compression
Abstract: This is a deep dive into the data compression features in SQL Server and how it affects the performance of your database. After attending this session, you will be able to recognize situations in which enabling compression will help, how to configure it, and how to deploy it in your production systems.
Speaker(s):
- Jay Robinson
Track and Room: Application Database Development - Room 113
Title: An introduction to the magical world of BIML!
Abstract: Ever feel like you are just doing busy work while creating new SSIS packages? Feel like you are doing the same thing over and over while changing the names to protect the innocent? Ever wonder if there is a better way? Well wonder no more. Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors. Come with intrigue and leave with a fundamental understanding of BIML!
Speaker(s):
- Jonathan Stewart
Track and Room: BI Platform Architecture, Development Administration - Room 114
Title: SSAS 2016 Tabular - Diving into the new features
Abstract: Taking a looking at all the new features of SSAS 2016 Tabular, how to use them effectively and avoid pitfalls. Features include Bi-Directional Cross Filtering, Parallel Partition Processing, Calculated Tables, etc.
Speaker(s):
- Brian Beswick
Track and Room: BI Platform Architecture, Development Administration - Room 114
Title: Scalable Application Design with Service Broker
Abstract: How your business applications interact directly with the corporate database can dramatically affect how successful you are. One of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates, you can focus performance concerns where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently and minimizes conflicts with your critical updates. This session walks you through the steps to get Service Broker running and providing a consistent delivery of your business data.
Speaker(s):
- Allen White
Track and Room: Application Database Development - Room 114
Title: Maximizing Microsoft SQL Server Storage Investments
Abstract: 2016 is the year of All-Flash for primary storage and EMC’s industry leading portfolio of All-Flash arrays unlock the speed, efficiency, and agility that your business stakeholders have been demanding. Whether supporting 1,000 or 10,000,000 IOPS, EMC has a broad portfolio to ensure consistent sub-millisecond response time regardless of workload type.
Beyond just production database performance, EMC provides robust database repurposing via our iCDM or Integrated Copy Data Management capabilities. Creating and maintaining test/dev, near real-time analytic, or sandbox environments has never been simpler. Join us and hear how we can address the needs of all of your Microsoft SQL Server instances.
Speaker(s):
- Tom Spreacker
Track and Room: Other - Room 104
Title: Availability Groups 101: An Introduction
Abstract: One of the most talked about new features in Microsoft SQL Server is AlwaysOn Availability Groups. In this session, we’ll cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications and databases, are currently using Database Mirroring, or if you’re just curious about Availability Groups, then you won’t want to miss this session.
Speaker(s):
- Adam Belebczuk
Track and Room: Enterprise Database Administration Deployment - Room 200
Title: SQLStarter - Intro to DBA
Abstract: Session in the SQLStarter beginner track to introduce the database administrator career. Will discuss aspects of what this job entails and what day to day could look like in this career path. We’ll go over important skills and where to find training information.
Speaker(s):
- David Maxwell
Track and Room: SQLStarter Beginner - Room 202
Title: Using Powershell to Automate Your Restore Strategy
Abstract: As DBAs, our most important job is protecting the data. Making sure our backups are running successfully gets us halfway there, but those backups are useless if we can’t restore them. Join me for this session to learn how to use Powershell to automate a restore process for backup validation.
Speaker(s):
- Frank Gill
Track and Room: Enterprise Database Administration Deployment - Room 200
Title: SQLStarter - Intro to Big Data
Abstract: Session in the SQLStarter beginner track to introduce big data careers. Will discuss aspects of what this job entails and what day to day could look like in this career path. We’ll go over important skills and where to find training information.
Speaker(s):
- Josh Fennessy
Track and Room: SQLStarter Beginner - Room 202
Title: Using SQL Nexus for system health
Abstract: How do you determine a root cause of failure in your database server? What do you do with stack dump data and other logging you may be collecting? What do you do if you don’t have a 3rd party tool to diagnose issues? Take a look at SQL Nexus, the latest tool for SQL Server aimed at making you a Rockstar DBA! We will cover setup, collection and analysis of the data.
Speaker(s):
- Wendy Pastrick
Track and Room: Enterprise Database Administration Deployment - Room 215
Title: Migrating your SQL Server Instance
Abstract: Have an old SQL instance hanging around and need to migrate it? Have you had issues migrating a SQL instance before? Well we will cover the basics of migrating SQL. This includes planning, preparing your current environment, setting up the new environment, migrating the databases, and validation.
Speaker(s):
- Brandon Lukes
Track and Room: Enterprise Database Administration Deployment - Room 104
Title: Data, Statistics, and R Integration with BI…Why you should care!
Abstract: With the introduction of R Services in SQL Server 2016, many professionals and clients are using the buzz words: “Statistical Analysis”, “Statistical Approach”, “Predictive Analytics”, “Open Source R” and many more. This discussion will cover some key differences between the SQL Server R integration and the open source R tools available. I will cover how an organization can use basic statistical modeling to optimize business processes and improve turn-around-time. Finally, I will demonstrate how R can be used to predict future business metrics to help drive business decisions to meet the prediction or avoid the predicted outcome.
Speaker(s):
- Dustin Elery
Track and Room: Advanced Analysis Techniques - Room 108/110
Title: Using PowerPivot in MS Excel to analyze SQL Server Data
Abstract: Your end users want to analyze data in your data warehouse. They could deal with the learning curve of SSAS but they’d prefer to utilize a familiar application like MS Excel. Welcome PowerPivot, a tool that retrieves data from your data warehouse by combining the power of SSAS models and your SQL Server Data warehouse within the familiar interface of MS Excel. In this presentation well explore SSAS BI Semantic model, PowerView, PowerPivot in Excel.
Speaker(s):
- Wylie Blanchard
Track and Room: BI Information Delivery - Room 215
Title: Clusters! From the ground up, let us 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 104
Title: SQLStarter - Intro to Database Development
Abstract: In this session, you will learn the most important aspects of the database developer job and what it entails from a technical and interpersonal perspective. We’ll cover what a day in the life of a database developer looks like, the common salary ranges of this job, as well as job responsibilities. We will also go over important technical skills and where to find deeper training information, such as reading database models, building a database metadata library, basic SQL Server programmatic objects and when to use them, and basic T-SQL transaction writing.
Speaker(s):
- Kevin Kline
Track and Room: SQLStarter Beginner - Room 202
Title: SQLStarter - Certification/Recruiter Discussion
Abstract: We’ll have a split discussion. One portion will discuss certifications. One portion will discuss importance of networking and building a personal brand with a technical recruiter.
Speaker(s):
- John Deardurff
Track and Room: SQLStarter Beginner - Room 202
Title: Microsoft Business Intelligence 2016 – More Love for Your Data
Abstract: Heartbroken over Microsoft’s neglect of SSRS over the years? Well the 2016 release might start healing that broken heart. This upcoming release boast a handful of great new items; from connecting SSRS PowerBI to mobile report publishing. Join me while I walk you through the best of 2016 for Business Intelligence and help you fall in love with Microsoft BI again.
Speaker(s):
- Tamera Clark
Track and Room: BI Information Delivery - Room 208/210
Title: SQLStarter - Intro to BI
Abstract: Session in the SQLStarter beginner track to introduce the business intelligence career. Will discuss aspects of what this job entails and what day to day could look like in this career path. We’ll go over important skills and where to find training information.
Speaker(s):
- Jim Bennett
Track and Room: SQLStarter Beginner - Room 202
Title: SQL Server Encryption
Abstract: Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? What about encrypting your backups? This session will go over all the steps and caveats that go with this technology. TDE allows you to have your database encrypted on disk and the same Encryption Hierarchy allows you to back up your database and have it encrypt the contents in the backup file. We will discuss the Encryption Hierarchy which is used for encryption in SQL Server and take you through keeping your secrets safe. Master the concepts of SQL Server Encryption when you are done with this session.
Speaker(s):
- Ben Miller
Track and Room: Enterprise Database Administration Deployment - Room 104
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.
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.
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.
Brandon Lukes
Twitter: - balukes
LinkedIn: Brandon Lukes
Geek with 10+ years of SQL experience on a broad area of topics.
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.
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.
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.
Andrew Loree
Twitter: - @LowOnDiskSpace
LinkedIn: Andrew Loree
Contact: http://www.andyloree.com
Andrew Loree has over nineteen years of database experience with roles in architecture, design, development, and implementation of enterprise-scale SQL Server data solutions, supporting industries from legal e-discovery to manufacturing. Areas of expertise since SQL Server 2000 include data migration and ETL/ELT solutions, disaster recovery planning, high availability service design, licensing and virtualization. Andrew holds fourteen Microsoft certifications, has both a Bachelor and Masters of Science in Computer Science from Wright State University and is a Columbus (Ohio) PASS board member.
Dave Leininger
Twitter: - @DaveLeininger
LinkedIn: Dave Leininger
Contact: http://box160.com
I have decades of experience in data technology consulting. Projects in 2018 include data KPI analysis for the region’s largest healthcare provider, and data architecture for IoT monitoring in a smart home application. I spent ten years in Europe and Southeast Asia while discussing database development with enterprise developers in 20 countries. I have consulted in a variety of public and private companies, and government agencies, with a focus on data architecture, integration, and analysis.
Daniel Glenn
Twitter: - DanielGlenn
LinkedIn: Daniel Glenn
Contact: https://DanielGlenn.com
Daniel is a Microsoft MVP with 15 years’ experience building technology solutions, intranets and extranets. As Practice Leader for the Nashville-based InfoWorks Inc., Daniel helps organizations of all sizes solve complex data challenges by implementing Office 365 and SharePoint without the need of customization and costly investments.
Daniel is passionate about giving back and building the Microsoft technical community. Daniel holds leadership roles in various local user groups, serves as an organizer for Microsoft 365 Nashville, and is a co-host for the popular podcast 365 Message Center Show on https://MessageCenter.Show. You can follow Daniel online at https://DanielGlenn.com and @DanielGlenn on Twitter.
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.
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.
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.
Dave Mattingly
Twitter: - @dave_mattingly
LinkedIn: Dave Mattingly
Contact: http://www.davemattingly.net
Dave Mattingly has spent thirty years of designing, developing, databasing, documenting, and directing a variety of projects in many industries. In the past, he’s worked on space travel, fraud prevention, data accuracy, and virtual reality for industries such as games, ecology, health, religion, and money. He also writes, publishes, orates, teaches, and preaches.
Kevin Kline
Twitter: - kekline
LinkedIn: Kevin Kline
Contact: http://blogs.sentryone.com/author/kevinkline
Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.
Mike Lawell
Twitter: - @sqldiver
LinkedIn: Mike Lawell
Contact: http://sqlserverassociates.com/Blog
Mike Lawell is an 19 year veteran of SQL Server, working with all versions since 6.5. He specializes in performance tuning and high availability as an independent consultant.
He is a Linchpin People Teammate, he also consults with SolidQ, Intellinet and Microsoft Consulting Services.
He is also a certified Scuba instructor with a long bucket list of dive sites.
He resides in Atlanta, GA and you can catch him at many of the SQLSaturdays in the SE region of the United States.
Ginger Grant
Twitter: - desertislesql
LinkedIn: Ginger Grant
Contact: http://www.DesertIsleSQL.com
Ginger Grant manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.
Britton Gray
Twitter: - IDreamInSQL
LinkedIn: Britton Gray
Britton Gray is a veteran of database development, data management, business intelligence, analytics, and data privacy in BI. He has successfully completed projects in a variety of technologies in different technology stacks. Coming from a family full of teachers, he thoroughly enjoys the opportunity to share knowledge and insights; it’s an extension of “getting the right information to the right people at the right time” mantra of BI. He lives near Indianapolis, Indiana, and is the Director of BI for Project Lead The Way, a nonprofit organization providing transformative learning experiences in computer science, engineering, and biomedical sciences.
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.
Dustin Elery
I started my education in finance. After completing my MBA in Finance, I could not find interesting work locally. A recruiter knew of my passion for data and statistical analysis when completing financial models. He introduced me to the BI industry. I immediately knew this was going to be a great fit. I have not looked back since. I have held a couple of roles in a corporate setting but have been consulting for three years now. I have heavy experience in SQL development, statistical analysis, and data visualization. I have moderate experience in data warehousing, database management, optimization, and overall data architecture and the tools that spread across that landscape.
Warren Sifre
Twitter: - WAS_SQL
LinkedIn: Warren Sifre
Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com
Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.
Jeremy Frye
Twitter: - SQLBInstein
LinkedIn: Jeremy Frye
Contact: https://jeremyfrye.net
Jeremy Frye is the manager of the Business Intelligence and data warehousing team at RDX. He is a Business Intelligence architect and developer with a background in database administration as well. Jeremy has over 9 years of experience in SQL Server. He has spoken on BI topics at many SQLSaturday’s throughout the country, webinars, and local and remote SQL user groups. In his spare time, Jeremy often spends time trying to bridge the gap between keyboard strokes and workout reps.
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.
Jim Bennett
Twitter: - @DrBennett68
LinkedIn: Jim Bennett
I am a Business Intelligence Architect with over 17 years of database and technology experience spanning many disciplines. The roles I have performed include Enterprise Data Architect, Solution Architect, Business Intelligence Architect, Database Administrator, Datawarehouse Database Administrator, Integration Engineer, ETL Developer, Report Developer, Database Development Team Lead, Systems Engineer, Network Engineer, and Software Engineer. I specialize in Business Analytics, Master Data Management methodologies, Systems Integration, and Enterprise Data Management. I have implemented solutions to improve process efficiency, data quality, system performance, and provide process automation.
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.
Jonathan Stewart
Twitter: - sqllocks
LinkedIn: Jonathan Stewart
Contact: https://sqllocks.net/
Jonathan Stewart is a Business Intelligence consultant specializing in data visualization, data warehousing, and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments.
Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and Business Intelligence at numerous SQLSaturday events, local user groups, and conferences throughout the United States and around the world. He participates in webcasts, podcasts, and on
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
Kerry Tyler
Twitter: - AirborneGeek
LinkedIn: Kerry Tyler
Contact: http://airbornegeek.com
Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.
Tom Spreacker
Twitter: - @vonSpreacker
LinkedIn: Tom Spreacker
Contact: https://vonspreacker.wordpress.com/
26 years of IT experience as a customer and a consultant. The last 12 years at EMC as a System Engineer. Currently working as a Specialist System Engineer for All Flash.
Ryan Wade
Twitter: - MrDataGeek
LinkedIn: Ryan Wade
Ryan is an experienced data analytics professional. His education and work experience enables him to understand things from a technical, analytical, and business viewpoint. He has the ability to present complex data in an intuitive way using sound analytical and visualization methods.
He has an advanced analytical and technical skill-set which includes Power BI, T-SQL, R, Python, Azure Machine Learning Services, Azure Databricks, SQL Server Machine Learning Services, Advanced Modern Excel, SSIS, SSAS Tabular.
He is a data analytics enthusiast that has spoken at a variety of database and data science conferences about various topics dealing with data analytics.
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.
Wylie Blanchard
Twitter: - WylieBlanchard1
LinkedIn: Wylie Blanchard
Contact: https://WylieBlanchard.com/?utm_source=sqlsaturday.comutm_medium=profileutm_campaign=website
Wylie Blanchard, MCSE is an IT consultant, SQL Server professional and web strategist who enjoys helping people learn how to use technology as a tool to amplify their professional lives. He has 15+ years of experience in the IT Industry and holds several certifications in SQL and Oracle systems. He is a father of twin-girls, a gadget enthusiast and a self-proclaimed pizza connoisseur. Learn more about Wylie at: www.WylieBlanchard.com.
Adam Machanic
Twitter: - @AdamMachanic
LinkedIn: Adam Machanic
Contact: http://sqlblog.com/blogs/adam_machanic
Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is the author of the award-winning SQL Server monitoring stored procedure, quot;sp_WhoIsActive.quot; He has contributed to several books on SQL Server, including quot;T-SQL Queryingquot; (Microsoft Press, 2015). He is a Microsoft Most Valuable Professional (MVP) for SQL Server.
Tamera Clark
Twitter: - https://twitter.com/tameraclark
LinkedIn: Tamera Clark
Contact: http://tameraclark.com
Tamera Clark has been involved in the IT industry for greater than ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter, Co-leading the Nashville BI Chapter, assisting the Nashville PASS Chapter and serving as a Regional Mentor. Tamera is also the event chair of SQLSaturday Nashville.
Aaron King
Twitter: - https://twitter.com/trendoid
LinkedIn: Aaron King
Contact: http://www.aaronstanleyking.com
Aaron King is an application architect specializing in enterprise web applications and very large databases. He has helped several successful startups move to the software plus services model. He is currently working as an independent consultant on several long term engagements. Aaron is also a community leader and active in Indy PASS.
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.
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.
Jay Robinson
Twitter: - @downshiftdata
LinkedIn: Jay Robinson
Contact: https://downshiftdata.wordpress.com/
I write C# and T-SQL code that scales well. I teach others to do it. DBAs like me.
Bradley Nielsen
LinkedIn: Bradley Nielsen
Bradley Nielsen is a Data Science Engineer specializing in the Microsoft BI stack. He is passionate about data driven analysis and has worked with databases since his first college internship. Brad has a Master#39;s in Human Computer Interaction and a Graduate Certificate in Data Science from Indiana University.
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.
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.
Kevin Kline
Twitter: - kekline
LinkedIn: Kevin Kline
Contact: http://blogs.sentryone.com/author/kevinkline
Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.
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.
Frank Murphy
Twitter: - @dfmurphy20
LinkedIn: Frank Murphy
Contact: http://www.baldmanrunning.com
Brotherhood Mutual is a nation-wide property/casualty insurer that focuses on churches and related organizations. Frank works in the Enterprise Risk Management department as a Geospatial Analyst, where a large portion of his duties involves manipulating spatial data.
Aaron Cutshall
Twitter: - sqlrv
LinkedIn: Aaron Cutshall
Contact: http://sqlrv.com
Aaron N. Cutshall is an Enterprise Data Architect with 20 years of experience in analysis, design and development for applications and databases in manufacturing and warehousing plus over 15 years in the Healthcare Informatics field. His primary focus is in designing and developing solutions for extremely large data sets that perform quite well in SQL Server. He is active in the SQL Server community and speaks at SQLSaturday sessions across the country.
Tim Ford
Twitter: - @SQLAgentMan
LinkedIn: Tim Ford
Contact: http://thesqlagentman.com
Tim Ford is a Data Professional, Author and Community Leader whose technical passions lie in creative solutions for managing and presenting data. He#39;s been a healthcare DBA since 2000 and leads SQL Agent Man Consultancy and SQL Cruise. He takes 25 students and leaders in the SQL Community and places them on cruise ships for technical and professional development training without the distractions of the office and internet twice a year on SQL Cruises (www.sqlcruise.com). Currently Tim serves on the Board of Directors for PASS and is passionate about taking fellow Data Professionals to the next level in their careers. He enjoys telling stories with data.
Frank Gill
Twitter: - skreebydba
LinkedIn: Frank Gill
Contact: http://skreebydba.com/
Frank Gill is a Senior Data Engineer at Concurrency With 21 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. Over the past several years, he has worked extensively with SQL Server solution in Azure, including Managed Instance. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.
Chris Koester
Twitter: - cjkoester
LinkedIn: Chris Koester
Contact: https://chris.koester.io/
Chris Koester is a Data Analytics Solution Architect at DMI, focusing on cloud data engineering and architecture. Chris graduated from Indiana University in 2008 with a Bachelor of Science in Informatics.
Meagan Longoria
Twitter: - mmarie
LinkedIn: Meagan Longoria
Contact: http://datasavvy.me
Meagan Longoria is a business intelligence consultant with Denny Cherry Associates, and lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).
Andrew Mauch
Twitter: - @andrewmauch
LinkedIn: Andrew Mauch
Bio: Results oriented sales and management professional striving to help companies unlock the power of their data. Andrew has spent several years managing a consulting organization that built custom BI solutions from the Microsoft platform. Seeing how companies struggled with BI and complex builds, led him to join Pyramid Analytics where BI is made simple, putting the power of BI in the end users hands with the governance of IT.
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.
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.
Sponsors
The following is a list of sponsors that helped fund the event: