SQLSaturday #452 - Charlotte 2015

Event Date: 10/17/2015 00:00:00

Event Location:

  • Central Piedmont Community College (CPCC)
  • 2800 Campus Ridge Road
  • Charlotte, North Carolina

PDF of Schedule

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).


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

Title: Getting the Skinny on Minimally Logged Operations

Abstract: Any changes to Non-Memory Optimized tables require a certain amount of logging to the transaction log in order to ensure the integrity of the operation and of course the database. Most of these are fully logged operations and can write a tremendous amount of data to the transaction log. As you probably already know these can lead to various performance and availability issues. However you may be able to minimize the effect of these with what is called a minimally logged operation. This session will outline how these can be used under the right conditions to save time, resources and potentially a lot of headaches. Various demos will hit home on just how much of an impact this can have on some every day operations.


  • Andrew Kelly

Track and Room: Enterprise Database Administration Deployment - Room 2316

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. Using 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


  • George Walkey

Track and Room: Enterprise Database Administration Deployment - Room 3315

Title: Introducing Forensic Analytics with PowerPivot for Excel

Abstract: Despite the wealth of analytical technologies available today, 65% of fraud at public companies is detected through tips, management review, or simple accidents. Forensic Analytics combine human intuition and leading-edge technologies, and can provide superior detection methods to significantly improve the detection and investigation of illegal or unethical activities. In this session, we explore Forensic Analytics: a set of techniques we can use to uncover irregularities in financial data. We also gain an understanding of goals of Forensic Analytics: to enable us to find out how — and why — these irregularities exist, and to find out their source(s) — especially when fraudulent activity is suspected. We discuss guiding principles that are key to isolating data anomalies, and outline a standard, repeatable process to Forensic Analytics. Throughout the session, we view examples of how we can employ PowerPivot for Excel to drive Forensic Analytics via various tests and reviews.


  • William E Pearson III

Track and Room: Analytics and Visualization - Room 3315

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!


  • Rob Volk

Track and Room: Application Database Development - Room 2316

Title: Analysis Services: Show Me Where It Hurts

Abstract: “Its.Slow!” are probably the two most dreaded words for any database professional (right behind “You’re fired!”)

What’s slow? Since when? Compared to what?

Join this “something-everyone-should-be-doing-but-isn’t” session, in which we will discuss baselines and performance monitoring for your SQL Server Analysis Services (SSAS) environment. We’ll cover what a baseline is, what information it needs to include, and how it can help you troubleshoot immediate problems and proactively avoid them in the future. Walk away from the session with a plan that you can implemented next week to help avoid being caught off guard by SSAS performance issues and to make troubleshooting a breeze.


  • Bill Anton

Track and Room: BI Platform Architecture, Development Administration - Room 3316

Title: SSIS 2014 Data Flow Tuning Tips and Tricks

Abstract: Do you want SSIS to go fast? This session is for you! Attend and learn techniques for developing, instrumenting, monitoring, and managing SSIS 2014 Data Flow performance in your data integration enterprise.


  • Andy Leonard

Track and Room: BI Platform Architecture, Development Administration - Room 3316

Title: Beginners SQL Server Security the Low Hanging Fruit

Abstract: Security is not for the faint of heart and this session is just the tip of the iceberg. Those new to the DBA role and of course the Accidental DBA’s can take away a few nuggets to get them started securing their SQL Servers and raising awareness to the importance of securing the data we have been sworn to protect. Let this session jump start your journey to learning why DBA’s are called the gatekeepers and increase your value in the office while getting noticed for caring enough to stop intrusions to your SQL Servers.


  • Lindsay Clark

Track and Room: Enterprise Database Administration Deployment - Room 2315

Title: Table Partitioning Intro and make that a sliding window too!

Abstract: A walk-through of creating a sliding window table partition on an AdventureWorks table.


  • Jeff Reinhard

Track and Room: Enterprise Database Administration Deployment - Room 3316

Title: Managing Complex Workloads Using the SQL Server 2014 Resource Governor

Abstract: The Resource Governor is a key SQL Server technology for managing competing workloads. New capabilities designed to provide greater flexibility in resource management have been added in SQL Server2012 and SQL Server 2014. As organizations consolidate their SQL architectures, effective management of compute and disk resources becomes more difficult. This session will detail Resource Governor functions as well as demos to illustrate advanced workload management using the SQL 2014 Resource Governor.


  • Denis McDowell

Track and Room: Enterprise Database Administration Deployment - Room 2302

Title: Crash course on becoming better SQL Developer.

Abstract: Crash course on becoming better SQL developer by focusing on common mistakes and how to overcome it. What does one need to know to become better SQL Developer? What tools can make your job easier and how to use them? How can I write modular code to make it reusable? These and many other questions will be answered by reviewing mistakes, showcasing free tools and going over bad code.


  • Vladimir Oselsky

Track and Room: Application Database Development - Room 2316

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.


  • Kevin Feasel

Track and Room: Other - Room 2300

Title: Getting Started With Execution Plans

Abstract: Are you just breaking into the query tuning side of managing your SQL Servers? In this session, we will cover the basics you need to start leveraging execution plans as part of your tuning process. We will discuss how SQL Server creates and uses plans, and how to collect them. Once we have the plans, we will go step-by-step through how to read them, and what the most common operators mean. We will look at the different types of operators not just from a standpoint of what they do, but how they can impact query performance. We will also cover how good database design and maintenance allow you to get better execution plans through having the right indexes and up-to-date statistics.


  • Scott Fallen

Track and Room: Enterprise Database Administration Deployment - Room 3316

Title: From T4 to BimlScript

Abstract: This session is for database and application developers who know Microsoft’s T4 (Text Template Transformation Toolkit) from Visual Studio but would like to make the transition to the powerful BimlScript language for generating SSIS and SSAS projects dynamically. Business Intelligence Markup Language (Biml) and BimlScript let you tap into the rich metadata of your SQL Server databases, multiplying your efficiency and accuracy many times over. During this highly-interactive session, we’ll leverage your familiarity with template-based code generators like T4, comparing its features to BimlScript to tackle some difficult Business Intelligence tasks in a fraction of the time it would normally take. If you don’t know T4, any prior experience with template-based code generators will prepare you well for this session. Moreover, if you’ve never done dynamic code generation before, you may still find this session fascinating and a quite useful addition to your toolbox.


  • Kevin Hazzard

Track and Room: BI Information Delivery - Room 3314

Title: What’s in a Date? Avoiding confusion with Dates, Times, and Durations

Abstract: Dates and Times can be very confusing. Julian Days, Fiscal Years Months, UTC, Atomic Time, Leap Seconds, ISO 8601, and more clutter up what, on the surface, appears to be a simple set of data types. This session will work to demystify dates and times, with a focus on SQL Server. It will cover the pros and cons of each of SQL Server’s date/time data types, why you need a Calendar table in almost every database (and maybe a Time table too), various good methods of handling intervals and durations, how to use the IANA tzdata database to help with time zones daylight savings. As a bonus, if we have time, we’ll also talk about SQL Server 2016’s Temporal tables and what they mean for the current/history table pattern.


  • Nate West

Track and Room: Application Database Development - Room 2301

Title: Getting Started with SSIS Script Tasks and Components

Abstract: SSIS has many great built-in tasks and components. Sometime, though, you need to go further than what they allow. Come to this session for an introduction to the scripting capabilities of SSIS. Many data movement activities can be handled with SSIS using the built-in tasks and components. Eventually, though, you will run into a scenario that will be better handled by extending SSIS functionality with custom code. In this session, we will cover the basics of using scripts in SSIS control flows and data flows. We’ll talk about the pros and cons of scripts, review the development environment for scripts, cover some interesting and useful .NET classes, and walk through multiple examples of scripts that add useful functionality to SSIS.


  • John Welch

Track and Room: BI Platform Architecture, Development Administration - Room 2315

Title: Profisee: Learn How To Build A Golden Record for Any Subject

Abstract: Attend the lunch demo and see how you can use Master Data Services and Maestro to: o Create a golden record for any subject area in a matter of minutes o Leverage your Microsoft licenses, skills and infrastructure to lower license costs and FTE costs, and reduce the complexity of an MDM environment? o Understand how to implement workflow and business process solutions around the management of MDM, without having to write complex custom coding for everything? o Tackle data quality, consistency and control by empowering business and subject matter experts, without needing heavy IT resources and writing complex code or scripting o Improve data quality, data stewardship, workflow, and data sharing with any of your enterprise


  • Gene Webb

Track and Room: Sponsored Session - Room 2302

Title: There May Be No Free Lunch But You Can Have Free Training

Abstract: Did you know that you don’t have to wait until the next PASS Summit or BA Conference to get more training? If your company can’t send everyone to the big conferences every year, it definitely doesn’t mean you have to go without keeping up your skills or increasing your knowledge. You’ve found your way to SQLSaturday, and that’s a great first step. But there is so much more out there. I’ll share with you free resources including blogs, user groups, PASS virtual chapters, Twitter, Linked In, online forums, and other websites. These resources will help you stay connected to the SQL/BI community year-round so you can continue to increase your skills without draining your company’s training budget or your wallet.


  • Meagan Longoria

Track and Room: Professional Development - Room 2302

Title: Policy Based Management: Introduction and Implementation

Abstract: In this session users will be introduced to the concepts and capabilities of Policy Based Management. We will review the basics of what policies are, the process for setting up new policies, evaluating policies against an environment, and scaling policies across an environment.


  • Ryan Brickey

Track and Room: Enterprise Database Administration Deployment - Room 2314

Title: Enhancing Data and Predictive Analytics with NoSQL

Abstract: The pervasiveness of Big Data has created significant challenges for companies that have historically utilized relational database management systems to perform data analysis and predictive analytics. This presentation outlines the challenges that stem from Big Data as it relates to deriving value from data, the types of NoSQL data stores available and how NoSQL can serve as a data platform that enhances the data analysis and predictive analytics capabilities of companies.


  • Cornell Emile

Track and Room: Analytics and Visualization - Room 3314

Title: Azure SQL Database - Is it right for my organization?

Abstract: Azure SQL Database is now based on the same bits as SQL Server 2014, bringing great enterprise capabilities. We will discuss business continuity features such as geo restore, point-in-time recoveries, and how to recover a deleted database with only a few clicks. No more retrieving tapes from you off-site backup vault! Learn how easy it is to configure a geo-replicated solution which allows for both disaster recovery and readable secondaries. Use the built-in SQL Server Management Studio wizard to migrate your on-premises databases into Azure SQL Database.


  • Lori Clark

Track and Room: Cloud Application Development Deployment - Room 3316

Title: Secure/Encrypt SQL Server Database With TDE

Abstract: TDE, Transparent Database Encryption, is a Microsoft built-in solution to protect sensitive information by encrypting entire SQL Server database. TDE encrypts and decrypts the data on the fly with minimum overhead and no code change at all on the development or application side.


  • Thomas Chan

Track and Room: Enterprise Database Administration Deployment - Room 2316

Title: Tone Analysis with HDInsight and Azure Machine Learning

Abstract: People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with format depending on the social network. Twitter messages are limited to 140 characters and use hash-tags,; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, Microsoft Big Data Hadoop distribution HDInsight and Azure Machine Learning


  • Paco Gonzalez

Track and Room: BI Information Delivery - Room 3314

Title: Creating a Performance Monitoring Solution for SQL Server BI Suite

Abstract: These talks discuss using the native Windows performance tools System Monitor and WMI technology to create logs that track the overall performance of SSIS, SSAS, and SQL Server. This will be a deep dive into Windows Performance Monitoring and WMI tools that are native to all Windows Operating Systems and how they can be used to track and monitor your SQL applications. I will discuss memory utilization, counters, WMI classes, and threading that is collected during SQL operations within the Windows OS. I will also show you how to collect this data manually or via automated schedule and export it for later evaluation or logging


  • Melvin Black

Track and Room: BI Platform Architecture, Development Administration - Room 2315

Title: Trust Your Data with Data Quality Services

Abstract: This session will step through the fundamentals that go into assessing existing data quality issues as well as an introduction on how to use Microsoft’s Data Quality Services to address those issues. The presentation will begin by discussing techniques to uncover pain points that may currently exists within your data. We will step through techniques for stakeholder discussions and things to look for when profiling your data. In the second half of the session, we will transition into a demo that introduces the capabilities of Data Quality Services. I will discuss the major functions of Data Quality Services such as, Knowledge Bases, domains, and matching. My goal at the end of the session is for each participant to have a good baseline understanding of what to look for when assessing quality within their data, as well as, how to begin solving the issues they find.


  • Justin Ward

Track and Room: BI Information Delivery - Room 3314

Title: Advanced SQL Server Agent

Abstract: When was the last time you read up on SQL Agent features? Is there more you could be doing with it?

We’ll answer this question and more as we take a deep dive into the SQL Server Agent. In this session we will cover some of the basic best practices of SQL Agent configuration as well as more advanced topics like managing large numbers of jobs, properly managing job history, and keeping jobs in sync across multiple instances.


  • Mark Wilkinson

Track and Room: Enterprise Database Administration Deployment - Room 2300

Title: Small Scale Data Collection Using PowerShell - Going NSA Style!

Abstract: While we are not the NSA, certain vital data needs to be collected – for example audit data, trace data, session information, performance data etc. – all to a central SQL Server repository, for analysis. In this session let us see how freely available PowerShell code can be used to collect data from multiple SQL Servers instances/databases. At the end of this session, you will have the knowledge and ability to collect pretty much any data to a central repository with just a couple of lines of code all in a manner that works specifically for you!


  • Jana Sattainathan

Track and Room: Other - Room 2316

Title: Database Corruption

Abstract: Database corruption could happen to you. This could potentially be one of the worst nightmares you could experience in the database world. In this session I will be talking about what database corruption is. I will also give a lesson on how dbcc works and the limitation of it. I will give examples of database corruption and how to resolve them. I will also give examples of how to verify integrity of backups. Backups are essentially the last resort for resolving database corruption.


  • Stephen Muliokela

Track and Room: Other - Room 2300

Title: First Look at SQL Server 2016

Abstract: Microsoft has been busy working on the next version of SQL Server - SQL Server 2016. We will go over some of the new features at a high level and dig deeper on Row Level Security and StretchDB. Row Level Security allows you to add another layer of security to your environment. StretchDB will allow you to transparently place part or all of a table into a SQL Azure DB freeing up your valuable SAN space for data that is COLD.


  • Rick Heiges

Track and Room: Enterprise Database Administration Deployment - Room 3315

Title: Pyramid Analytics: Looking for the Power BI on-prem alternative

Abstract: Do you like Power BI – but your company is not ready to move to the CLOUD? In this session we will be covering the On-Prem Power BI alternative that Microsoft has endorsed: Pyramid Analytics BI Office. We will discuss architecture considerations; use cases; integration points with Power BI, SharePoint on-prem, and SSRS; Tabular Modeling on-the-fly; and even consumption of data from Azure ML!

Do you want to allow your business users to build Tabular models on the fly, or connect to your multi-dimensional cubes - and visualize them immediately? Come and hear about how you can do all of this and more with Pyramid Analytics’ BI Office suite.


  • Mark Scott

Track and Room: Sponsored Session - Room 2301

Title: Power BI: Architecture, Integration Points, Implementation Options

Abstract: In this session we will review Power BI V2 architecture and integration points with corporate data sources, SaaS services, Azure, and third party apps. We will examine and demonstrate key capabilities in the Power BI web-based service, Power BI Desktop, Excel, and mobile apps. Implementation options for Power BI involving cloud, on-premises, and hybrid approaches will be explored. Finally, the concept of “Bimodal BI” will be introduced with use cases for how Power BI might be utilized for both self-service BI and certain corporate BI initiatives.


  • Melissa Coates

Track and Room: BI Platform Architecture, Development Administration - Room 2302

Title: Better Managed Services Through Monitoring with UpSearch and SQL Sentry

Abstract: In this presentation Brian Davis and Scott Fallen will demonstrate how SQL Sentry tools help UpSearch and their managed services customers monitor and tune their SQL Servers. Brian is a SQL Server Consultant for UpSearch, and Scott is a Sales Engineer for SQL Sentry. During the presentation, we will look at baselining, performance bottleneck identification, query tuning, alerting, and automated response with SQL Sentry in the context of how the team at UpSearch leverages these features. We will conclude with a demo of some of the powerful features of SQL Sentry Plan Explorer FREE.


  • Scott Fallen

Track and Room: Sponsored Session - Room 2315

Title: No Money for Performance Monitoring Tools? No Problem!

Abstract: So you like the idea of using one of the commercially available performance monitoring tools but can’t convince your boss to spend the money? Then join me as we explore some absolutely free tools born right out of Microsoft’s customer support teams: DiagManager and SQLNexus. We will see just how easy it is to use them to collect and analyze performance data from your SQL Servers. These tools can get you started quickly without having to deal with the red tape.


  • Patrick Keisler

Track and Room: Enterprise Database Administration Deployment - Room 2315

Title: Looking for the Power BI on-prem alternative?

Abstract: Do you like Power BI – but your company is not ready to move to the CLOUD? In this session we will be covering the On-Prem Power BI alternative that Microsoft has endorsed: Pyramid Analytics BI Office. We will discuss architecture considerations; use cases; integration points with Power BI, SharePoint on-prem, and SSRS; Tabular Modeling on-the-fly; and even consumption of data from Azure ML!

Do you want to allow your business users to build Tabular models on the fly, or connect to your multi-dimensional cubes - and visualize them immediately? Come and hear about how you can do all of this and more with Pyramid Analytics’ BI Office suite.


  • Mark Scott

Track and Room: Analytics and Visualization - Room 2301

Title: Status of the Charlotte IT Marketplace

Abstract: In this session you will learn what is the status of the local IT market. Included will be: Salary Information, Market Trends, City Facts, Who is HIring, and a lot more.


  • Leveat Ruse

Track and Room: Professional Development - Room 2301

Title: Introduction to R Programming

Abstract: R is a free software environment for statistical computing and graphics. By far the most popular programming language for data science projects, R is used to solve problems in fields such as biology, physics, finance and marketing. With the recent acquisition of Revolution R and the increasing capabilities of AzureML, Microsoft’s attention to deliver an enterprise-ready version of the R platform has increased exponentially. Please join me to learn the foundations of R, how to begin plotting data using ggplot2 and how R is integrated in AzureML.


  • Jake Switzer

Track and Room: Analytics and Visualization - Room 2315

Title: DELL SQL Server Solutions

Abstract: Your organization relies on SQL Server to support its applications, customers and employees. But to maintain productivity, control costs and protect data, your SQL Server environment must be up and running, effectively supported and secured. Come see how DELL SQL Server Solutions increase productivity, reduce costs and protect data in your SQL Server environment.


  • Vera Takakura

Track and Room: Sponsored Session - Room 2316

Title: SQL Server and Azure

Abstract: SQL Server 2014\2016 is on the edge of one of the larger revolutions in Database technologies in the recent past. The reason is that we have a new technology out there, and your may have heard of it, it’s called the cloud. Microsoft’s version of cloud technologies is called Azure.

In this session, we will learn some details of using SQL Server 2014 with Azure, as well as Azure Database as a Service. In addition, we’ll explore some of the new, improved features available in SQL Server 2016. We’ll explore how SQL Server integrates with Azure, and how you can put one toe in the water and get started integrating the cloud into your organization.


  • Rich Cargile

Track and Room: Cloud Application Development Deployment - Room 3314

Title: Introduction To R For Sql Developers

Abstract: In this session we will explore

  1. Installation of R and R Studio
  2. R basics
  3. Power of R
  4. Getting data from databases and other sources.
  5. Managing Data frame using Package dplyr
  6. Visualization of Data using Graphic Package ggplots2
  7. In-Database R in Sql Server 2016


  • Kiran Math

Track and Room: Analytics and Visualization - Room 2314

Title: Managing a Production Azure SQL Database - True Story!

Abstract: I develop for and manage a small, but active, web application that lives completely inside of Azure from code to data. I’ve been involved with it since inception, and I’ve learned a few things about developing for, and managing data in this environment the hard way.

I’d like to share some of the lessons I’ve learned in hopes that it can save others some time.


  • Jason Hall

Track and Room: Cloud Application Development Deployment - Room 2314

Title: Making Predictions with Microsoft Data Mining Tools

Abstract: Whether predicting customers or All Stars, the process and the tools remain the same. Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships. Join me to see what data mining is, what data mining is not and how Microsoft’s data mining tools can help you analyze your business. During this session, I will walk us through a start-to-finish data mining prediction project. It’s easier than you might have thought.


  • Mark Hudson

Track and Room: Other - Room 2300

Title: Disaster Recovery Where to Begin

Abstract: So you have a good backup strategy in place, but now you have to think about a disaster recovery. Where do you start and what are your options? SQL Server offers several options, but then how do you choose the right one to meet your business requirements? In this session, we will go over some of the common DR options including log shipping, replication, mirroring, clustering, and AlwaysOn. Then we will talk about how to choose the best one to meet your business needs.


  • Tracy Boggiano

Track and Room: Other - Room 2314

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.


  • Allen White

Track and Room: Application Database Development - Room 2314

Title: Building Your Yellow Brick Road: Directing Your Path to a Successful Career

Abstract: For most of us, our career in technology was and is the result of our combined education, experience, opportunities, and luck. In this presentation we will explore approaches to creating the career we want instead of the one we stumble into.


  • Justin Randall

Track and Room: Professional Development - Room 3315

Title: Statistics are hidden treasure.

Abstract: What are statistics? Why do we need statistics? How we can use statistics for our advantage?

I’ll show you the case, along with walking through statistics, execution plans, plan cache and query hints.

Also, will show how to use statistics in your day-to-day life and benefit from it.


  • Slava Murygin

Track and Room: Enterprise Database Administration Deployment - Room 3315

Title: PowerShell Basics for SQLServer

Abstract: Overview of PowerShell and how to perform SQL scripts using PowerShell. In this session you will learn the basics on building scripts using PowerShell and then learn the basics of using PowerShell for SQL server administration.


  • Michael Wharton

Track and Room: Enterprise Database Administration Deployment - Room 2302

Title: Planning for Virtualization

Abstract: This session will serve as a guide for database administrators who are considering virtualizing their SQL server instances (or are about to have that decision thrust upon them) and are unsure of the best approach. It will cover the basics of how to configure a virtualized environment for SQL server, make you aware of some of the common performance pitfalls and help to dispel some of the myths around managing database availability in a virtualized environment. At the end of the session you should have a good idea as to whether virtualization is the right choice for your database environment and a broad strategy for how to go about implementing it.


  • Brian Carrig

Track and Room: Other - Room 2300

Title: Beginning Azure

Abstract: The cloud is here! Are you ready? Microsoft, Amazon and others are all vying for your cloud attention. In this session, we will review the different types of cloud platforms available and what they mean to you. We will pay close attention to Microsoft’s Azure platform that offers two hosting solutions. What are these hosting options and what are the differences between them? Most importantly, how do I get started with all of this cloud business? Let’s put SQL Server into the cloud!


  • Thomas Norman

Track and Room: Cloud Application Development Deployment - Room 2302

Title: SQL Clinic

Abstract: SQL Clinic is an open session/discussion lead by couple of Microsoft engineers. If you have any SQL related problem or question, you can go there and ask and get a consult for free. If you do not have problems or questions you can just sit in and learn what kind of problems other people have in their environments.


  • Harsh Deep Singh

Track and Room: Enterprise Database Administration Deployment - Room 2301

Title: Configuring and using PolyBase to interact with Hadoop

Abstract: In this session, we are going to connect to a fully deployed Hadoop Cluster using PolyBase and Power BI. We will go over the Pros vs Cons of using this solution and what use cases this architecture fits.


  • Montrial Harrell

Track and Room: BI Information Delivery - 3314


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

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.

Scott Fallen

Twitter: - @ScottFallen

LinkedIn: Scott Fallen

Contact: http://blogs.sqlsentry.com/author/ScottFallen/

Scott Fallen (@ScottFallen) is a Solutions Engineering Manager on SentryOne’s Sales team and is responsible for technical sales support. He interacts with customers and prospective customers at conferences and trade shows. He also provides demos and online webinars existing and future users of SentryOne software.

Justin Randall

Twitter: - jh_randall

LinkedIn: Justin Randall

Contact: http://blogs.sqlsentry.com/justinrandall

Justin Randall is a Senior Consultant at SQL Sentry, LLC. He has over 30 years of data management experience in a variety of roles from Enterprise Data Modeler to DBA, supporting development in DB2, Sybase, and SQL Server. Justin frequently speaks at SQL Server User Group meetings and SQLSaturdays, and has presented at several SQLintersection conferences. His current professional interests are SQL Server performance monitoring and tuning, and career development.

Kiran Math

Kiran Math is a Software Engineer on the Construction Predictive Analytical team at Fluor, where he specializes in T-SQL, R, Python, C# etc.

A resident of Greenville, South Carolina, he can be found cycling and hiking the trails around Greenville.

He is active in his local SQL PASS chapter in Greenville, speaking and volunteering at SQLSaturdays.

Harsh Deep Singh

Twitter: - @harshdeepsingh

LinkedIn: Harsh Deep Singh

Contact: http://blogs.msdn.com/b/sqljourney/

HarshDeep Singh is a SQL Server Premier Field Engineer for Microsoft in the North America region. He has worked extensively on SQL Server with various Microsoft customers. He contributes to the community by speaking at technical events, as well as through his blog (http://blogs.msdn.com/b/sqljourney/).

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.

Nate West

I have been working with databases for over 10 years, as an application developer, data modeler, and data warehouse architect. How best to represent the real world in a computer always been a deep interest of mine. I have lived most of my life in the Pittsburgh area, moving to Charlotte in 2013.

Rich Cargile

Rich Cargile is a Senior Software Engineer at RDA Corporation. For over 10 years, he has designed, developed, and maintained a data-centric solutions within multiple industries such as Finance, Digital Marketing, State and Federal Government using Microsoft#39;s BI stack. His main interests include relational database performance tuning, ETL, Business Intelligence, and Azure.

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

Michael Wharton

Twitter: - MyProjectExpert

LinkedIn: Michael Wharton

Contact: http://MyProjectExpert.com

Michael Wharton is a Project MVP. He has been an independent consultant for the past 20 years, with over 30 Project/SharePoint Server deployments. He has an MBA from Wake Forest and has over 44 Microsoft Certifications. Michael’s primary job is helping companies setup a PMO, Project Management Office using Project Server using SQL server on a SharePoint Farm. He has worked extensively with the back end support setting up SQL server, SharePoint Server and Project Server using PowerShell.

Melvin Black

LinkedIn: Melvin Black

My background includes a wide and depth understanding in the End to End development of Reporting Solutions and Data Modeling using the Microsoft Business Intelligence stack.

Certified as Microsoft MCSE, MCSD (VB and SQL), MCTS (Performance Point 2007, SQL Business Intelligence 2005 and 2008, SCOM 2007). I have been a Microsoft Certified Profession since 1997,a former Microsoft Engineer, and currently an active Sr. BI Consultant.

B.S. in Information Systems Mgmt and M.S. Project Management

Jake Switzer

LinkedIn: Jake Switzer

Jake Switzer is a SQL/BI consultant for Microsoft. He works to deliver data analytics solutions to customers using a variety of Microsoft and Open Source software. He is interested in topics such as data science, business intelligence, and sports analytics.

Ryan Brickey

Twitter: - SQLBrickey

LinkedIn: Ryan Brickey

Contact: http://mindofadba.blogspot.com/

Ryan is currently a Database Administrator with Wells Fargo where he is responsible for a production SQL Server environment. Before coming to Wells Fargo, he started his career working as a data analyst doing data mining and developing ETL procedures. From there he turned to performance monitoring and tuning as a Software Support Engineer with SQL Sentry. He also holds the certification of MCITP - SQL Server 2008 Database Administration.

Patrick Keisler

Twitter: - @PatrickKeisler

LinkedIn: Patrick Keisler

Contact: http://www.patrickkeisler.com

I#39;m a husband, a father, an Atlanta Braves fan, and oh yeah…I know a thing or two about Microsoft SQL Server, because I work for Microsoft supporting it as a Premier Field Engineer. I have over 15 years of DBA experience and have gained considerable knowledge in SQL Server by supporting lots of different type of applications ranging from high-volume trading applications to large data warehouses. I hold several certifications: MCSE: Data Platform, MCITP SQL 2008 Admin and Dev, and Security+.

Andy Leonard

Twitter: - AndyLeonard

LinkedIn: Andy Leonard

Contact: https://andyleonard.blog

Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.

Melissa Coates

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

LinkedIn: Melissa Coates

Contact: https://www.CoatesDataStrategies/blog

Melissa Coates is a data architect with a background in data warehousing and business intelligence. Her current professional focus is enterprise-level Power BI governance, deployment, security, and administration. As the owner of Coates Data Strategies, Melissa produces training and consults to help companies strengthen and sustain their data-driven initiatives. Melissa is big supporter of the technical community, and has been a Microsoft Data Platform MVP since 2013. You can visit Melissa’s website at CoatesDataStrategies.com, which includes community resources like diagrams, blogs, and videos.

Andrew Kelly

Twitter: - gunneyk

Contact: http://sqlblog.com/blogs/andrew_kelly/default.aspx

Andrew J. Kelly is a Senior Technical Subject Matter Expert with B3 Group Inc. and lives in Clarkdale, AZ. He has over 20 years experience with relational databases and application development, but his main focus now is SQL Server. In addition to general SQL Server training and mentoring, he specializes in performance, scalability, and maintainability of large-scale SQL Servers. He is a regular speaker at conferences and user groups and was a SQL Server / Data Platform MVP for 18 years.

Mark Wilkinson

Twitter: - http://twitter.com/m82labs

Contact: http://www.m82labs.com

I am a father of 4, and live in Raleigh North Carolina. I love fixing problems, and learning new technologies that can help me fix those problems faster and better than I did the time before.

In my spare time I like to read, speak, and learn new things. I currently work as a Database Administrator at ChannelAdvisor where I solve fairly interesting problems on fairly large databases.

You can often find me on Twitter where I talk about SQL, beer, and anything else I find interesting.

Jana Sattainathan

Twitter: - www.twitter.com/SQLJana

LinkedIn: Jana Sattainathan

Contact: http://www.sqljana.wordpress.com

Jana works as a Senior Oracle and SQL Server DBA at SCOR, a leading Reinsurance company in the world. He has spent most of his professional life around databases. At work, he has automated most aspects of his job using PowerShell.

Most recently, he created PowerPump, a “PowerShell Database Copy Server” for his company to copy 50 billion rows (> 20 TB,) from 4000+ of Oracle/SQL Server tables on a recurring basis to SQL Server targets for migration/testing. He has also fully automated the database deployment which supports all components of SQL Server and Oracle using PowerShell (with about 150 functions) that is tracked extensively.

Jason Hall

Twitter: - @SQLSaurus

LinkedIn: Jason Hall

Contact: http://blogs.sqlsentry.com/jasonhall

Jason Hall (@SQLSaurus) leads SentryOne’s Product Management team, which is responsible for managing product design, development and delivery.

Jason has worked in varied technology roles for over 20 years and holds industry certifications including MCSE (legacy), MCSD, MCTS, MCPD, and PMC-III.

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).

Jeff Reinhard

Twitter: - @SQLMajor

LinkedIn: Jeff Reinhard

I have 25 years of database development experience, mostly with SQL Server, with companies such as Ernst amp; Young, Internet Security Systems/IBM, AirWatch, WebMD, CheckFree and others. My recent focus has been on AlwaysOn availability groups and database DevOps.

Denis McDowell

Twitter: - mcdowell_is

LinkedIn: Denis McDowell

Denis McDowell is a Microsoft Data Professional with over 20 years of experience with SQL Server, scripting, virtualization, IT operations, and Cloud implementations across multiple industries. He currently works as the Solutions Engineering Manager for SentryOne and owns a consulting practice in the Charlotte, NC area. Denis has been a regular presenter at local, regional, and national conferences and events, including PASS Summit, Microsoft Hosting Summit, and numerous SQLSaturday and SQL User Groups around the U.S. In his free time, Denis enjoys traveling with his family, playing and recording in his home music studio, and catering to the needs of his three dogs.

Lindsay Clark

Twitter: - @LindsayOClark

LinkedIn: Lindsay Clark

Lindsay started out in network administration with a BA in Computer Science from South University prior to finding her true love in database administration. Whether it#39;s mentoring in the office or presenting sessions at SQLSaturday, Lindsay loves to find new ways to collaborate and share information. In addition to her role as DBA at American Credit Acceptance, she actively recruits speakers for her user group and chairs her local SQLSaturday event.

Justin Ward

LinkedIn: Justin Ward

My name is Justin Ward and I am a Data Solutions consultant with Cardinal Solutions Group. Since joining Cardinal, I#39;ve had the opportunity to gain experience in multiple industries working with Reporting, Integration, and Data Quality tools across both Microsoft and IBM platforms. I#39;m very passionate about constantly learning and sharing knowledge with peers of my profession. This has driven me two present and partake in multiple SQL events in the Charlotte area over the past couple of years.

Stephen Muliokela

LinkedIn: Stephen Muliokela

I have been a DBA for many years now and currently hold multiple SQL Server certificates. In addition, I am also a Six Sigma Blackbelt.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence

Tracy Boggiano

Twitter: - TracyBoggiano

LinkedIn: Tracy Boggiano

Contact: http://databasesuperhero.com

Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC.

Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com.

Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.

Vera Takakura

Twitter: - vtakonsql

LinkedIn: Vera Takakura

Account Executive for Enterprise Database Solutions for Dell Software formally Quest Software

Mark Hudson

Twitter: - HMarkHudson

Mark Hudson is an MCITP with many years of experience in business intelligence and data analysis. He has developed data solutions using numerous platform tools including multiple SQL Server versions. He is a data architect and developer with CapTech (www.captechconsulting.com) and served as a leader of the Richmond SQL Server User Group (www.richmondsql.org).

Kevin Hazzard

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

LinkedIn: Kevin Hazzard

Contact: http://www.linchpinpeople.com/blog/

Kevin Hazzard is a Partner at Linchpin People LLC, leaders in the data integration and database wellness space. He was a long-time Microsoft MVP and the author of a book entitled Metaprogramming in .NET. Kevin also serves as an elected member of his local School Board and dedicates most of his non-professional time promoting public education.

Leveat Ruse

Twitter: - www.twitter.com/ncsctechrecruit

LinkedIn: Leveat Ruse

As an Executive Technical Recruiter with Ctrl+f, I currently develop effective recruitment strategies to attract top talent at all levels of an organization. I am an IBM certified trainer and began my career performing general human resources duties. I quickly worked my way up through the ranks of technical recruiting from Lead Recruiter to Senior Recruiter to Business Development.

Thomas Chan

LinkedIn: Thomas Chan

I work with SQL Server since 2001 with version 7.

Mark Scott

Twitter: - @usamjscott

LinkedIn: Mark Scott

Contact: http://www.pyramidanalytics.com/Pages/blog/Authors/mark-scott.aspx

Mark has over 20 years of consulting, managing, delivering, and selling in both private and public companies all over the US. Prior to joining Pyramid, he held consulting and sales leadership positions at Microsoft delivering and selling BI and Data Warehousing solutions to large enterprise accounts. In his spare time - Mark enjoys traveling and spending time with his wife, and two sons age 4 and 6!

Cornell Emile

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

For nearly two decades, Cornell A. Emile has designed, developed, and maintained data-centric solutions within multiple industries such as Finance, Digital Marketing, Non-Profit, Retail, Manufacturing State and Federal Government using Microsoft#39;s business and data products. His main interests include architecting data solutions, Business Intelligence and NoSQL databases.

Paco Gonzalez

Twitter: - @pacosql

LinkedIn: Paco Gonzalez

Paco Gonzalez is the CEO of SolidQ North America, and a Microsoft Data Platform MVP. Focused on Business Analytics and Artificial Intelligence, he specializes in helping organizations become data driven from a strategic and technical perspective. Paco is a speaker at small and large conferences such as PASS Summit, Ignite, and Business Applications Summit, and he has published several books and whitepapers. He is based in Atlanta, GA.

Gene Webb

Twitter: - None

LinkedIn: Gene Webb

Contact: http://None

Gene Webb is a Regional Sales Executive with The Profisee Group based in Alpharetta Georgia. Profisee is the successor to Stratature the company that built Master Data Services (MDS) and sold the product to Microsoft in 2007. Profisee focuses around Master Data Management (MDM) and as a Gold ISV provides solution sets built on MDS and the Microsoft Stack. Gene spent 7 years working at Microsoft as a SQL Server and Developer Tools solution specialist and an ISV Developer Evangelist.

Bill Anton

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

LinkedIn: Bill Anton

Contact: http://byobi.com/blog/

Bill Anton is an expert in Analysis Services and an experienced data warehouse practitioner. In 2013, he founded Opifex Solutions, a consulting firm with deep expertise in enterprise-scale architecture, design, and performance optimization of Analysis Services and Power BI solutions. He loves eating and spends most of his free time convincing his beloved wife to adopt more golden retrievers.

Slava Murygin

Twitter: - SlavaSQL

LinkedIn: Slava Murygin

Contact: http://slavasql.blogspot.com/

Started working with SQL Server 7.0 as DBA and Developer. Since then went through all SQL Server versions, migrations and multiple companies of different sizes and industries. Currently working as a contractor with all aspects of SQL Server, including, but not limited to: troubleshooting performance, designing/developing: databases, systems, processes, data warehouses, cubes, reports, ETLs; Refactoring old code; Migrating data from other systems to SQL Server; Securing the data on enterprise level.

Brian Carrig

Twitter: - @briancarrig

Brian Carrig is a Microsoft Certified Master of SQL Server and is currently a Senior Program Manager on the SQL Server Tiger Team at Microsoft focusing primarily on persistent memory technology and replication. In a previous life, Brian spent some time as an academic and holds a PhD in Computer Science. He is a native of Dublin, Ireland but now lives with his wife and two daughters in Redmond, Washington. If he is not talking about, thinking about or working with technology you will usually find him watching Chelsea FC.

Scott Fallen

Twitter: - @ScottFallen

LinkedIn: Scott Fallen

Contact: http://blogs.sqlsentry.com/author/ScottFallen/

Scott Fallen (@ScottFallen) is a Solutions Engineering Manager on SentryOne’s Sales team and is responsible for technical sales support. He interacts with customers and prospective customers at conferences and trade shows. He also provides demos and online webinars existing and future users of SentryOne software.

Lori Clark

As a Data Platform Specialist for State and Local Government, I work with customers to effectively license their SQL Server environments. I showcase various technical features through demos and on-site discussions, as well as assist customers with POCs. Recently, I recorded a Channel 9 quot;What#39;s New for Azure SQL Databasequot; video.

Mark Scott

Twitter: - @usamjscott

LinkedIn: Mark Scott

Contact: http://www.pyramidanalytics.com/Pages/blog/Authors/mark-scott.aspx

Mark has over 20 years of consulting, managing, delivering, and selling in both private and public companies all over the US. Prior to joining Pyramid, he held consulting and sales leadership positions at Microsoft delivering and selling BI and Data Warehousing solutions to large enterprise accounts. In his spare time - Mark enjoys traveling and spending time with his wife, and two sons age 4 and 6!

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.

Rick Heiges

Twitter: - heigesr2

LinkedIn: Rick Heiges

Contact: http://sqlblog.com/blogs/rick_heiges/default.aspx

Rick is a Former Data Platfrom MVP and Sr. Consultant for Microsoft where he focuses on working with customers on their data estate. His career includes work as a DBA, University full-time faculty member, Systems Analyst, Project Leader, and Developer. He has found his passion in working with data and the community. Rick served nine years on the PASS Board of Directors and spearheaded the popular 24 Hours of PASS event. He also started his local User Group in 2002. Today, he spends much of his time with his head in the clouds.

Vladimir Oselsky

Twitter: - @VladyOselsky

LinkedIn: Vladimir Oselsky

Vladimir Oselsky (Vlady) is an IT Professional with over 15 years of experience in various IT Jobs. Born and raised in Siberia, moved to United States in late 90s. Passion for computer and programming started with DOS games and learning Borland Paschal in 8th grade as a hobby. IT career consisted of everything from hardware and software support to server administration. Current focus on SQL Server Database Development and .NET programming

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.

Montrial Harrell

Twitter: - @blackdragon_sql

LinkedIn: Montrial Harrell

Contact: http://www.broadstrokeconsulting.com

Montrial has been involved with Technology since his first programming class in Junior High over 23 years ago. Since then he has been discovering how to use technology to solve problems in support of infrastructure teams, software development, Health Care and Government agencies. He has worked as a Systems Admin, LAN Admin, QA Engineer, instructor and finally decided to focus on Data Management and Governance because it offered so many ways to help businesses.

John Welch

Twitter: - @john_welch

LinkedIn: John Welch

Contact: http://agilebi.com/jwelch

John Welch joined SentryOne in spring 2018 as VP of Engineering with the acquisition by SentryOne of the software division of Pragmatic Works. John leads the development of a suite of products that make developing, managing, and documenting data solutions easier. John has been successfully delivering IT solutions to business problems since 1994, and has been focused on business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server and data topics. He also contributes to several open source projects and community initiatives targeted toward making data professionals work more productive.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page