SQLSaturday #442 - Orlando 2015

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

Event Location:

  • Seminole State College of Florida
  • 100 Weldon Blvd Building UP
  • Sanford, Florida

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: Table Vars and Temp Tables – What you NEED to Know!

Abstract: Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represents temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, “When do I use one or the other and what are the various impacts of doing so?”


  • Wayne Sheffield

Track and Room: Application Database Development - DBA 3 - 4205

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 - DBA 3 - 4205

Title: Real World SQL Server Administration with just a bit of sysadmin

Abstract: I will review the fundamentals needed to define a configurable permission model currently in use at a large insurance company that allows database administrators to do routine work without having unfettered access to business data.

I will show that many DBA tasks can be done without sysadmin access and explain what permissions are required for the most common tasks. Attendees will learn how to deploy a permission model that allows DBAs to do routine work and how to elevate permissions quickly to respond to emergencies.

I will demonstrate several T-SQL and PowerShell scripts that secure the database server, undo the permission model in case of unforeseen circumstances, and discover which servers are non-compliant.

Attendees will leave this session with the realization that DBAs don’t need to be sysadmin as often as typically believed, that most administration tasks can be done without elevated permissions, and with the means to deploy this model in their own environment.


  • Ronald Dameron

Track and Room: Enterprise Database Administration Deployment - Security - 3207

Title: Detect Worst Performing SQL Queries During Peak Hour

Abstract: How many times you have been thrown in a situation when you have been asked to fix performance issues of a database system which you have never seen before? Where do you start tuning? When do you stop tuning? Each application is different. With the ever increasing number of systems one production DBA has to manage today, it’s very important to use TOP to BOTTOM approach to troubleshoot performance issues, which will lead to the answers in the right way for the application under consideration.

While you can find top queries, wouldn’t it be awesome if you can find out which ones are the exact queries taking most of the resources in last hour and current situation? Now you can focus on those specific queries!

In this session, Prakash walks you through with scenario demos to find which exact queries are taxing production systems resources based on CPU/DISK/Memory/Network. They are all based on his own real-life experience from managing demanding database systems.


  • Prakash Heda

Track and Room: Enterprise Database Administration Deployment - DBA 2 - 4106

Title: DQ What? DQ Who? DQ How?

Abstract: Whether a company has 1 database containing 1GB of data or hundreds of databases containing terabytes or even petabytes of data, at some point they all have the same question…“What is the quality of our data?”. A business runs off of it’s data and if that data isn’t complete, consistent, and accurate bad decision can be made. Come to this session and learn how to tell if your data is quality data worthy of making decision from. We’ll learn what it means to have quality data and how you can measure the quality of your data using the Data Quality Services (DQS) component of SQL Server. Together we’ll explore this lesser known part of SQL Server and learn how it works and how you can start using it to measure and improve the quality of your data and thus the decisions being made from it.


  • Brian Davis

Track and Room: BI Platform Architecture, Development Administration - Azure+ - 1206B

Title: Eating The Elephant; A DBA’s Guide to Hadoop Big Data

Abstract: You’re a SQL Server DBA working at Contoso and your boss calls you out of your cubicle one day and tells you that the development team is interested in implementing a Hadoop-based solution to your customers. She wants you to help plan for the implementation and ongoing administration. Where do you begin?

This session will cover the foundations of Hadoop and how it fundamentally differs from the relational approach. The goal is to provide a map between your current skill set and “big data.” Although we will talk about basic techniques for querying data, the focus is on basic understanding of how Hadoop works, how to plan for growth, and what you need to do to start maintaining a Hadoop cluster. Additional discussion will cover the complementary nature of Hadoop and SQL Server.

Examples and demos will highlight basic query tools, including transferring data to and from SQL Server.


  • Stuart Ainsworth

Track and Room: Strategy and Architecture - BI 2 - 4104

Title: Loading Complex Data Structures using SSIS Programming

Abstract: On this session we are going to show at end-to-end solution for complex data structures such as IBM-37 using Comp-1, Comp-3 numeric fields, from the initial requirement using excell, creation of custom components, and finally the data loading using metadata to generate ssis dynamic at run time.


  • Jorge Novo

Track and Room: Application Database Development - BI 2 - 4104

Title: An Introductory Look at Execution Plans

Abstract: In this session we will look at some introductory execution plans, both estimated and actual, to help determine what the query optimizer will do, or has done, with the query presented. It should be noted that this session is not intended to be an in depth look at performance tuning, but rather a cornerstone in learning to use a tool appropriate for tuning.


  • Eric Wisdahl

Track and Room: Application Database Development - DBA 4 - 4208

Title: SQL 2016 Changes and Enhancements for BI and Beyond

Abstract: Operational Analytics: Insights on operational data, works with in-memory OLTP or on disklt;br/gt; lt;br/gt; In-memory OLTP enhancements: Greater T-SQL surface area, terabytes of memory supported and greater number of parallel CPUslt;br/gt; lt;br/gt; Query Data Store: Monitor and optimize query plans with full history of query executionlt;br/gt; lt;br/gt; Native JSON: Parsing storing of JSON as relational data exporting relational data to JSON lt;br/gt; Temporal Database: Track historical changeslt;br/gt; lt;br/gt; PolyBase: Manage relational non-relational data with the simplicity of T-SQLlt;br/gt; lt;br/gt; Power Query for Analytics and Reporting: Pull data from countless sources into data models and reportslt;br/gt; lt;br/gt; Enhanced SSIS: Designer support for previous SSIS versions and support for Power Querylt;br/gt; lt;br/gt; Enterprise-grade Analysis Services: Enhanced performance and scalability for Analysis Serviceslt;br/gt; lt;br/gt; Single SSDT in Visual Studio 2015: Build richer analytics solutions as part of your development projec


  • Charles Hyman

Track and Room: BI Platform Architecture, Development Administration - SQL Server 2016 - 1206A

Title: Enterprise Auditing with SQL Server Audit

Abstract: Audit. The very word strikes fear in the bravest of hearts. But as a DBA, the need to know who is doing what in your production databases is critical. In SQL Server 2008, Microsoft finally gave us a true auditing tool. But how does it work, what exactly can it track, and how can you handle its output?

In this session, we cover SQL Server Audit from the ground up. We go from the basics of which events can be audited to a look at how SQL Server Audit works “under the covers”, and what that means for performance. While implementing server and database audits, we discuss audit granularity and filtering, as well as the pros and cons of Audit’s output options.

Whether it’s through the SQL Server Management Studio (SSMS) interface, via T-SQL, or using PowerShell and Server Management Objects (SMO), at the end of this session you’ll be able to deploy SQL Server Audit across your enterprise and manage its output, fearlessly.


  • Colleen Morrow

Track and Room: Enterprise Database Administration Deployment - DBA 4 - 4208

Title: Execution Plans for Mere Mortals

Abstract: For beginning database professionals, execution plans can be intimidating. This session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache.

Reading execution plans becomes much less intimidating as we walk 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, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.


  • Mike Lawell

Track and Room: Application Database Development - DBA 2 - 4106

Title: Balancing Work and Home to Create a Better You

Abstract: If you are a working professional there is a chance that your career has interrupted your life and you’ve forgotten about you and/or your family. How do you create a healthy balance between the two so that you are happy and everyone else is to? In the session, you will learn how to properly manage time, erase stress, advance at work, address common marriage and family Issues, and ultimately create a better you.


  • Karlyn LeBlanc

Track and Room: Professional Development - Prof Dev - 3205

Title: A practical guide to Windows Azure SQL Database for the DBA

Abstract: What is “Windows Azure SQL Database” all about ? What does this mean for me as a DBA ? What is the process for setting up a Windows Azure database ? How would I go about migrating one of my databases to “The Cloud” ? How do I possibly leverage this new technology in my production environment ? If you are a production DBA and have contemplated one or more of these questions, this session is for you! Maybe, you have been tasked with finding out about “The Cloud”. Join me in exploring the cloud where I will show you how SQL Server works in the Windows Azure SQL Database world. We will run through the simple process of configuring a Windows Azure SQL database. We will investigate the similarities and differences between on premises SQL Server and Windows Azure SQL Databases. We will even look into the DR, HA, monitoring and performance tuning options available with Windows Azure.


  • Gareth Swanepoel

Track and Room: Cloud Application Development Deployment - Azure+ - 1206B

Title: Introduction to DataZen

Abstract: This is a must attend session for every data professional. Join me as I provide an overview of DataZen, Microsofts newly acquired on-premises mobile BI solution. Datazen is optimized for SQL Server and designed to enable rapid development and publishing of business intelligence in a way that delivers premium user experience on any device. In this session I will provide an overview of DataZen, discuss its key features, provide an architectural overview and finally demonstrate how to author and publish dashboards.


  • Patrick LeBlanc

Track and Room: BI Information Delivery - Azure+ - 1206B


Abstract: In this session we will cover new SQL Server 2016 features, Query Store and Live Query Statistics. Query Store is designed to help with query performance by making it easier to identify poorly performing statements and finding scenarios where performance regresses.

We will discuss how Query Store collects and presents historic information and how it can be used to reduce the time it takes to diagnose and resolve issues. If a query generates different plans, you can use Query Store to analyze the plan changes, identify performance degradation, and even force the query processor to use a particular plan for your query.

Live Query Statistics is a feature added into SQL Management Studio that provides the ability to view the live execution plan of an active query. This live query plan provides real-time insights into query execution process as the controls flow from one query plan operator to another. These execution statistics are extremely useful for debugging performance issues.


  • David Pless

Track and Room: Enterprise Database Administration Deployment - SQL Server 2016 - 1206A

Title: Management Data Warehouse and Data Collector

Abstract: If you’ve ever had to answer “why was the database server was slow at 3 AM?”, then you’ll want to learn about the Management Data Warehouse feature in SQL Server. If you’re already familiar with Server-side Tracing and Data Collector, then you’ll also want to add the Management Data Warehouse to your toolkit.

This session will cover installing and configuring the Management Data Warehouse feature in SQL Server, along with some customizations that can be added with additional Data Collector sets and custom SSRS Reports.


  • Ian Lanham

Track and Room: Enterprise Database Administration Deployment - DBA 2 - 4106

Title: Changing Data Is Easy, Managing Data Change is Hard!

Abstract: Databases are growing. The way we use data is changing and growing. When you have a lot of change, it has to be managed, or bad things happen to your data and your job! A common problem with database change management is… database change management. This session walks the user through the concepts of database change management, why it’s important, and how SQL Server Data Tools (SSDT) makes this process easy. There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be. Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.


  • James McAuliffe

Track and Room: Enterprise Database Administration Deployment - DBA 3 - 4205

Title: Data Factory: Data Integration in the Cloud

Abstract: The Azure platform is ever changing. Today is no different. Azure has released a new tool called Data Factory. It is a cloud PaaS that is SSIS in the cloud. Are you curious what all it entails and if you can use it? In this session, we’ll go over the basics of Data Factory like structure, billing, and building blocks. We’ll go over a couple instances on how you can use Data Factory in current processes that you have in your data warehouse ETL.


  • Josh Luedeman

Track and Room: Cloud Application Development Deployment - Azure+ - 1206B

Title: SSIS Performance Tuning Techniques

Abstract: SSIS is an extremely powerful ETL tool, but with great power comes great responsibility. The responsibility to not just create SSIS package, but create SSIS package that perform as efficiently as possible. This session will share best practices for developing packages that perform well from the start. It will also walk you step by step through identifying and fixing performance issues in an existing package. After watching this demo filled session you’ll be able to get your package performing better than ever!


  • Mitchell Pearson

Track and Room: BI Platform Architecture, Development Administration - BI 2 - 4104

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 - DBA 4 - 4208

Title: SQL Server 2016 Always Encrypted

Abstract: Join this session by security expert Sebastian Meine (PhD) for an introduction to the fascinating new SQL Server 2016 feature Always Encrypted. In this session, geared towards the Database Developer, you will learn what makes Always Encrypted more secure and easier to use than prior encryption technologies available in SQL Server. After exploring the architecture behind this new feature, you will be able to observe how to implement Always Encrypted in SQL Server and discover how it might affect your maintenance and recovery strategies.

After attending this session, you will be able to: • Explain how Always Encrypted works. • Setup and use Always Encrypted in your own SQL Server 2016 environment. • Identify places in your application that might require small changes.

To benefit from this 200 level session, you should feel comfortable writing stored procedures and views and not be scared when seeing C# code.


  • Sebastian Meine

Track and Room: Application Database Development - SQL Server 2016 - 1206A

Title: Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers

Abstract: Do you have applications in your environment that don’t use SQL written by a person but by the application itself? No, the system isn’t self-aware. Chances are the system is utilizing Microsoft’s Entity Framework.

Entity Framework (EF) and other object relational mapping technologies have been a boon for developers. But is Entity Framework a technology that developers should even be using? In this session, we’ll review what Entity Framework is and how it’s changed over time. We’ll also dive into how Entity Framework works and what to look for when inspecting a database generated by Entity Framework. Finally, we’ll review T-SQL generated by Entity Framework and give some tips on how to improve performance. If you’re a data professional that manages databases that are accessed through Entity Framework or would like a basic knowledge of how Entity Framework works this session is for you.


  • Richie Rump

Track and Room: Application Database Development - DBA 3 - 4205

Title: Taking the Scary out of Monster Reports

Abstract: So the big wigs have come up with a “master” report that shows everything you could ever want on a single report.#160; It includes grids and charts of varying sizes and complexities.#160; Did I mention they want it pretty as well?#160; In this session we will discuss how to use SQL Reporting Services 2008 R2 to bring it all together while avoiding the pit falls and mistakes.#160; The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts.#160; We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work.#160; To get the most out of this session, you should be able to build a report in SSRS.


  • Pam Shaw

Track and Room: BI Information Delivery - BI 1 - 4102

Title: SQL Server 2014 In-Memory Programming

Abstract: SQL Server 2014 introduces a game changer technology; in-memory objects. This session is a hands-on demo based presentation that will introduce you to what the technology is and how to use it. You will come out of this session with the knowledge and scripts that you can take back to your shop and instantly be productive. You will gain an understanding of the architecture, how to get started, indexes, natively compiled stored procedures and the limitations.


  • miguel Cebollero

Track and Room: Application Database Development - DBA 1 - 4105

Title: Microsoft Technologies for Data Science

Abstract: Microsoft provides several technologies in and around SQL Server which can be used for casual to serious data science. This presentation provides an authoritative overview of five major options: SQL Server Analysis Services, Excel Add-in for SSAS, Semantic Search, Microsoft Azure Machine Learning, and F#. Also included are tips on working with Python and R. These technologies have been used by the presenter in various companies and industries. Bring your beginner to advanced questions!


  • Mark Tabladillo

Track and Room: Analytics and Visualization - BI 1 - 4102

Title: How In-Memory Database Objects Affect Database Design

Abstract: With SQL Server 2014, Microsoft has added a major new feature to help optimize OLTP database implementations by persisting your data primarily in RAM. Of course it isn’t that simple, internally everything that uses this new feature is completely new. While the internals of this feature may be foreign to you, accessing the data that uses the structures very much resembles T-SQL as you already know it. As such, the first important question for the average developer will be how to adapt an existing application to make use of the technology to achieve enhanced performance. In this session, I will start with a normalized database, and adapt the logical and physical database model/implementation in several manners, performance testing the tables and code changes along the way.


  • Louis Davidson

Track and Room: Strategy and Architecture - DBA 1 - 4105

Title: Object Level Recovery Made Easy brought to you by Dell Software

Abstract: Have you ever found yourself in a situation where data mysteriously disappears from your database? Or a stored procedure or function was altered without your knowledge. How do I recover and get back to the original state? Recovering data and/or database code can be a frustrating and time-consuming effort without the proper tools.

In this session, I will show how to recover data and/or database code using native SQL Server tools. Do I have space to restore a copy of the database, do SLAs allow me to do this now or after hours, etc.

Then I will show how NetVault LiteSpeed for SQL Server’s Object Level Recovery (OLR) functionality can simplify the process and get back to the original database state in a fraction of the time. The result is you are the hero and everyone is happy.


  • Todd Phillippe

Track and Room: Advanced Analysis Techniques - DBA 3 - 4205

Title: PowerShell with Visual Studio SQL Data Tools

Abstract: This session will show the integration and use of PowerShell Tools for Visual Studio with SQL Data tools. Also demostrate how the use of a PowerShell script in SSIS “Script Task” component as part on a ETL flow. Covering some basic .NET Script code in both C# and VB. I’ll be adding some useful tips when re-using existing Powershell code. Integrating different .NET technologies in a SSIS package: C#, VB.NET, XML, and PowerShell.


  • Maximo Trinidad

Track and Room: Application Database Development - DBA 4 - 4208

Title: What’s New in SQL Server 2016

Abstract: SQL Server 2016 is on the way! SQL Server 2016 represents the largest release of SQL Server in almost 20 years. This will be the largest release in SQL Server since SQL 2000. Why? After SQL 2000 Microsoft took an approach to have major releases to the Database engine or the Business Intelligence Platform. That was the pattern for SQL Server 2005, 2008, 2008 R2, 2012, and 2014. In this release we will get change to SSRS, SSAS, SSIS, In-Memory OLTP, and AlwaysOn Availability Groups. We get new features like R integration, JSON Support, Polybase (the ability to query big data sources with T-SQL), Data Zen Integration, HTML 5 support, and much much more. If you use SQL Server, this release will impact you. Come find out how!


  • Bradley Ball

Track and Room: Application Database Development - SQL Server 2016 - 1206A

Title: Be the SQL Server Dev/Ops Hero, brought to you by Actifio

Abstract: As the value of Dev/Ops becomes more apparent to IT organizations, increasing demand is placed on the SQL Server DBA to manage a more agile and resilient database environment. A Dev/Ops model requires management of dozens of copies of each database across many servers, The need to provision and refresh these copies quickly is key to the success of any Agile development effort. In this session we will discuss the SQL Server DBA’s role within Dev/Ops - we’ll talk a bit about things like Sprints, Chef and Puppet, but most importantly we will discuss how you can present a database to any host in your environment in a couple of minutes regardless of size. Come see a copy of a 1.6TB SQL Server database presented to a host (same host or different doesn’t matter) in less than 2 minutes - try doing that from a database restore!


  • Jeff Abbott

Track and Room: Application Database Development - DBA 1 - 4105

Title: Implementing a SANLess Cluster in Under an Hour, brought to you b

Abstract: oin SQL Server MVP Kendal Van Dyke as he demonstrates how to create an SANless AlwaysOn Failover Cluster Instance using SIOS DataKeeper Cluster Edition - no shared storage, SAN, or SAN Admin required - in under an hour. At the conclusion of this sponsored session one lucky attendee will win an Amazon gift card courtesy of UpSearch!


  • Kendal Van Dyke

Track and Room: Enterprise Database Administration Deployment - BI 1 - 4102

Title: Why I won’t hire you and what you can do about it!

Abstract: As a hiring manager, I see the same mistakes over and over again. In this session we’ll talk about common mistakes in resumes, interviews, social media and how you can avoid them. We’ll also discuss lost opportunities and how not to miss them. This information applies to both internal and external candidates.


  • Leigh Freijo

Track and Room: Professional Development - Prof Dev - 3205

Title: Self-Service ETL with Microsoft Power Query

Abstract: In this session, I will introduce you to Microsoft’s new self-service ETL tool “Power Query” for Excel. I will show you, how to source data from various data sources, how you can massage the data and consume the data for your use in the data pipeline. I will introduce you to “M” language that is used in Power Query. I will show you how you can discover and mash data from public data sources within Power Query. If you would like to do ETL quickly without writing SSIS packages, Power Query is the way go. Come and attend this session to learn “Power Query”.


  • Damu Venkatesan

Track and Room: BI Information Delivery - BI 2 - 4104

Title: SQL Injection – are you ready for defense?

Abstract: The fact of the matter is that SQL injection is still a problem at the end of 2015. Web sites are still being hacked by using SQL Injection on a regular basis. Are you ready to learn as to protect your systems?


  • Andrey Korshikov

Track and Room: Professional Development - Security - 3207

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 - Prof Dev - 3205

Title: How to build your first Power BI Dashboard in 60 Min.

Abstract: Power BI is quickly becoming the tool of choice for self-service reporting. It’s time to get up to speed! In this session we will build a basic dashboard from the ground up using an existing database and the Power BI tools. You’ll take away examples to start building great looking dashboards for your organization Monday morning. Prepare to be inspired! The goal of this session is to empower you to start providing insights about your data that have previously been unexplored as well as enabling stakeholders to make data driven decisions that impact your organization.


  • Wes Springob

Track and Room: Analytics and Visualization - BI 1 - 4102

Title: PowerShell and Python - The Clash - Part Deux

Abstract: Comparison of one application done with both technologies using multi-threading to run simultaneous operations in a large set of servers and databases


  • Jorge Besada

Track and Room: Application Database Development - DBA 4 - 4208

Title: Thinking Outside of the In-Memory Box

Abstract: SQL Server 2014 In-Memory OLTP comes with a large set of limitations that prevents its widespread adoption and often makes refactoring and migration of existing systems cost ineffective. This session discusses two set of topics:

  1. How to address and workaround some of In-Memory OLTP limitations, such as 8,060-byte maximum row size, missing support for unique and foreign key constraints and different indexing behavior.
  2. How you can benefit from In-Memory OLTP objects even when system migration is cost ineffective.


  • Dmitri Korotkevitch

Track and Room: Application Database Development - DBA 3 - 4205

Title: Top 10 Wait Types Everyone Should Know

Abstract: There are over 800 wait types in SQL Server 2014, but there are only 10 (in my experience) that are seen very often. If you can learn these 10 wait types, what causes them and their solutions, you will be ahead of the performance analysis game. The list of 10 wait types to be discussed came from over 100 consulting engagements with customers, so come find out what they are and improve your performance troubleshooting skills.


  • Janis Griffin

Track and Room: Enterprise Database Administration Deployment - DBA 1 - 4105

Title: Interview Puzzles and how to handle them

Abstract: In today’s world of technology interview, employees have come up with more and more tricks and puzzles to test your brain. How would you move mount fuji? How many basketballs would fit in this room? In this session Mike will cover these questions and many more. You will leanr what not to say and how to handle tough questions.


  • Mike Davis

Track and Room: Professional Development - Prof Dev - 3205

Title: What’s New for High Availability in SQL Server 2016 and Windows Server 2016

Abstract: SQL Server 2016 and Windows Server 2016 are just around the corner. There are changes and enhancements to the availability features that SQL Server deployments - Windows Server failover clusters (WSFCs), clustered instances (FCIs), and availability groups (AGs). This session will cover what is new and what has changed since Windows Server 2012 R2 and SQL Server 2014 for WSFCs, FCIs, and AGs.


  • Allan Hirt

Track and Room: Enterprise Database Administration Deployment - SQL Server 2016 - 1206A

Title: AlwaysOn Availability Groups Kickoff

Abstract: Tired of dealing with Replication issues? Want high availability and readable replicas for reporting? The you should consider availability groups! This session provides a run through from start to end of my experience implementing AlwaysOn Availability Groups for High Availability and read only secondary database copies.


  • Jeff Reinhard

Track and Room: Enterprise Database Administration Deployment - DBA 3 - 4205

Title: DataTypes - What’s the Big Deal?

Abstract: Developers and DBAs: How do you determine what DataType will be required for your database? Far too often, Database Development teams are pressured into making quick decisions for their database models, usually full of NVarChars and GUIDs, typically based on a suggestion that these datatypes were the only useful datatypes for Web development. In this session, we will discuss the pro’s and con’s of the differing datatypes, and arm the Database Developers and DBAs with the analysis necessary to create databases that are easily maintained.


  • Susan Rickman

Track and Room: Application Database Development - DBA 2 - 4106

Title: Encryption 101: A look at SQL Encryption Options

Abstract: Are your backups like a stack of cash free for the taking, or a hardened ATM? Are your database connections scrambled and safe or are you sending data over the party line? In this session we will walk through the many ways SQL Server allows us to protect our data using encryption. We will evaluate the various methods for protecting data at rest, in the database, and while in transport. Since nothing comes for free, we will look at how much all of this is going to cost us, in time, money, and failure to implement.


  • Jason Carter

Track and Room: Enterprise Database Administration Deployment - Security - 3207

Title: The Encryption Primer

Abstract: Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.


  • Steve Jones

Track and Room: Application Database Development - Security - 3207

Title: How To Become a SQL Server DBA

Abstract: Are you a developer, network or systems admin that wants to become a database administrator? Or are you new to IT and think th role of the DBA might be the one for you? This presentation will start with discussing what a DBA does and how it varies from company to company, and then discuss how to acquire knowledge and experience as you try to land that first job as a working DBA.


  • Andy Warren

Track and Room: Professional Development - Prof Dev - 3205

Title: Achievement Unlocked: How to Get Promoted

Abstract: Have you ever felt like an extra in Office Space? You’ve got the skills. You’ve got the big brain. You feel like you have a higher calling, but those other guys get picked instead. What’s the deal?

In this session, you’ll learn how to promote yourself, how to speak confidently, how to build your personal brand, how to demonstrate value, and how to interview.


  • Dave Mattingly

Track and Room: Professional Development - Prof Dev - 3205

Title: Indexing your Data Warehouse

Abstract: One of the primary skill sets most database professionals are initially required to “master” is the art of proper indexing in our databases. We learn early on that an effective indexing configuration will go further in making our databases perform efficiently than probably any other single tuning technique. What’s not so commonly discussed though are the varying approaches one may wish to utilize when indexing your SQL Server enterprise data warehouse. This session will hopefully cause you to take a good look at your current indexing to see if indeed it could be operating even more efficiently.


  • Troy Gallant

Track and Room: Enterprise Database Administration Deployment - BI 1 - 4102

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 - Security - 3207

Title: Flash Storage Drill Down: Know Your Storage Infrastructure

Abstract: Flash Storage (Solid State Disks) have been proclaimed to be a DBA’s best friend. But not all flash storage is the same. In this talk, we will drill down a bit into the technology, and talk about the issues that can degrade your application’s performance. This talk examines those issues in detail, looking at how they specifically affect databases and the structured applications that depend on those databases. And just like the free version of Pandora Radio, there will only be one slide that is commercial in nature.


  • Patrick Pinchera

Track and Room: Enterprise Database Administration Deployment - Azure+ - 1206B

Title: Don’t Be Trigger Happy: Safe Use of Triggers

Abstract: Many seasoned DBA’s don’t want developers to use triggers because of the many common mistakes made when coding triggers that can adversely affect performance. We will discuss the different types of triggers: DDL and DML (Instead of and after) and see many common mistakes made and how to fix them. We will also discuss when a trigger may be the best solution and other options when a trigger is not the best solution.


  • Jack Corbett

Track and Room: Application Database Development - DBA 1 - 4105

Title: Building a Better Mousetrap: Using Cisco UCS for SQL Server Deplo

Abstract: Many DBAs still hold onto the notion that each implementation of SQL Server requires a dedicated physical server. In today’s world dominated by virtualization and an ever increasing eye towards all things cloud, the infrastructure under SQL Server has a greater impact than ever before. This session will discuss the key differences between physical, virtual, and cloud; how the platform choice affects SQL Server deployments; and how Cisco’s UCS can benefit not only SQL Server and the DBAs, but also system administrators.


  • Allan Hirt

Track and Room: Enterprise Database Administration Deployment - SQL Server 2016 - 1206A

Title: Designing a Data Warehouse from the Ground Up

Abstract: What if you could approach any business process in your organization and quickly design an effective and optimal dimensional model using a standardized step-by-step method? In this session we’ll discuss the steps required to design a unified dimensional model that is optimized for reporting and follows widely accepted best practices. We’ll also discuss how the design of our dimensional model affects a SQL Server Analysis Services solution and how the choices we make during the data warehouse design phase can make or break our SSAS cubes.


  • Dustin Ryan

Track and Room: BI Platform Architecture, Development Administration - BI 1 - 4102

Title: Transactional Replication: Architecture, Setup, and Monitoring

Abstract: At some point in every DBA’s career they’ll be probably be asked to work with transactional replication. While it may seem scary at first, it’s not that complicated once you understand how all the parts and pieces work together. In this session we’ll cover the fundamentals of how transactional replication works, walk through setting up a working replication topology, and learn how to keep an eye on things to make sure everything is working properly. You’ll return to work with the confidence and know-how that you need to set up and manage a transactional replication topology.


  • Kendal Van Dyke

Track and Room: Enterprise Database Administration Deployment - DBA 3 - 4205

Title: Roadmap: What’s Coming Next for SQL Server BI and Power BI

Abstract: In case you missed the memo, times have changed in the Microsoft BI world! We are now seeing massive investment in both cloud and on-premises Microsoft BI with rapid weekly releases. In this roadmap session, we will cover the Microsoft BI vision and then dive deeper into what is coming next for SQL Server BI and Power BI. There are many enhancements being made across SQL Server, MDS, SSIS, SSRS, SSAS, Power BI cloud, Power BI Desktop and other areas. Please join me in this “not-to-miss” session to explore upcoming innovations and enjoy a few bleeding edge demos.


  • Jen Underwood

Track and Room: BI Information Delivery - SQL Server 2016 - 1206A

Title: Advanced Performance Tuning Tips with Database Performance Analyz

Abstract: SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path.


  • Janis Griffin

Track and Room: Application Database Development - DBA 2 - 4106

Title: Introduction To R

Abstract: Data Science is a relatively new discipline. Core to this is the visualization of data. R is a language and environment used for data visualization and statistical computing.

In this session we’ll explore the basics of the R language and review some examples. Additionally we’ll review an implementation that integrates R into an ASP.NET application, allowing for sophisticated ways to display dashboards.


  • Robert Biddle

Track and Room: Analytics and Visualization - BI 2 - 4104

Title: Indexing for Join Optimization

Abstract: Everything you wanted to know about join optimization but were afraid to ask… Join types, indexing, and how the optimizer makes its selections.


  • Jeffrey Garbus

Track and Room: Information Delivery - DBA 1 - 4105

Title: Cortana Analytics Demystified

Abstract: Microsoft SQL Server and Microsoft Azure have been announcing so many features it’s hard to keep up. If you’ve heard of Cortana Analytics, you may be a little confused about what it is, and when you would use it. Buck Woody from the Cortana Analytics team is here to help with an overview of the Cortana Analytics stack, examples of how it works, information on what components to use when, and references to learn more. You’ll be able to amaze friend and family alike with your knowledge of the Blue side of the Force. No, really, you’ll be able to do that. He’ll prove it.


  • Buck Woody

Track and Room: Advanced Analysis Techniques - DBA 4 - 4208

Title: Analyze your query plan like a Microsoft Engineer!

Abstract: This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the “noteworthy” query plan patterns that go beyond the normal areas that customer tend to investigate.


  • Daniel Janik

Track and Room: Advanced Analysis Techniques - DBA 2 - 4106

Title: An intro to Azure SQL Data Warehouse

Abstract: In this session we will be covering one of Microsoft’s latest Azure offerings SQL Data Warehouse, which leverages the massive parallel processing (MPP) architecture. We will talk about the differences between SMP vs MPP architectures and benefits of an MPP architecture in the cloud.


  • Pankaj Satyaketu

Track and Room: Cloud Application Development Deployment - Azure+ - 1206B


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

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

Andy Warren

Twitter: - @sqlandy

Contact: https://sqlandy.com

Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.

Todd Phillippe

Todd has been a Sales Engineer with Dell Software since April 2011. He has 20+ years of database design, development, architecture and administration experience. Todd has a B.S. in Management/MIS from Georgia Tech, and an MBA from Florida Atlantic University.

Josh Luedeman

Twitter: - http://www.twitter.com/joshluedeman

LinkedIn: Josh Luedeman

Contact: http://www.joshluedeman.com

Josh is a Sr FastTrack Engineer with the FastTrack team in the Azure Engineering Group at Microsoft. Josh focuses on Microsoft’s Cloud Scale Analytics Solutions in Azure using products like HDInsight, Data Lake, Data Factory, and DataBricks. He has worked in IT for over 10 years holding positions in Application Support, Database Administration, and Business Intelligence, in industries like Higher Education, Consulting, Manufacturing, and Software Development.

Mitchell Pearson

Twitter: - @MitchellSQL

Contact: http://www.mitchellpearson.com

Mitchell is an experienced Business Intelligence Consultant and Trainer at Pragmatic Works and is currently the content training manager leading content development and delivery of training courses. Mitchell is experienced developing BI solutions using the full Microsoft BI Stack (SSRS, SSIS, and SSAS) as well as Microsoft Power BI. He is also very active in the community speaking at SQLSaturday events, local user groups, and online virtual events. Mitchell also blogs at mitchellpearson.com.

Sebastian Meine

Twitter: - @sqlity

LinkedIn: Sebastian Meine

Contact: http://sqlity.net/en/blog/

Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.

Patrick LeBlanc

Twitter: - patrickdba

LinkedIn: Patrick LeBlanc

Contact: http://patrickdleblanc.com

Patrick LeBlanc is a currently a Principal Program Manager at Microsoft and a contributing partner to Guy in a Cube. Along with his 15+ years’ experience in IT he holds a Masters of Science degree from Louisiana State University. He is the author and co-author of five SQL Server books. Prior to joining Microsoft he was awarded Microsoft MVP award for his contributions to the community. Patrick is a regular speaker at many SQL Server Conferences and Community events.

David Pless

Twitter: - @dpless

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

For the past nine years, I have been a Technical Solution Professional with Microsoft. As a TSP I conduct full training workshops, conduct demo sessions, and perform architectural reviews on all supported builds of SQL Server. I mainly support the Southeast focusing on Florida, but I can be anywhere in the world.

My core areas are Performance Tuning and Optimization, Azure, AlwaysOn, Reporting Services (SSRS), custom monitoring, building custom dashboards, and more.

Allan Hirt

Twitter: - SQLHA

LinkedIn: Allan Hirt

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

SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.

miguel Cebollero

Twitter: - SQLMiguel

LinkedIn: miguel Cebollero

Miguel is a father, husband and database professional with more than 18 years of experience. He has held positions in management, database administration, development, architect and BI development. Miguel is a regular speaker at local user groups, regional SQLSaturday and the national PASS Summit conference on various database topics. He has been an avid volunteer, chapter leader, contributor for PASS and published author of Pro TSQL Programmers Guide; ApressMedia, Published 2/27/2015

Mark Tabladillo

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

LinkedIn: Mark Tabladillo

Contact: http://marktab.net

Mark Tabladillo Ph.D. works for Microsoft as a Cloud Solution Architect for the US CTO Customer Success Team. He has a science doctorate from Georgia Tech. Based in Atlanta, GA, Mark provides cloud enterprise solutions for companies in the US for Microsoft’s strategic clients. He is a chapter leader for the PASS Data Science virtual chapter.

Louis Davidson

Twitter: - drsql

LinkedIn: Louis Davidson

Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/

Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.

Karlyn LeBlanc

Karlyn LeBlanc is a native of Chicago, Illinois. She currently resides in the Atlanta, Georgia area. Karlyn obtained her Bachelors degree from Louisiana State University in Baton Rouge and her Masters from Tulane University in New Orleans. Her career began as licensed master social worker where she spent twelve years counseling patients, supervising master level social workers, and facilitating support groups. In addition, she’s a bestselling author of two books and motivational speaker.

Gareth Swanepoel

Twitter: - @GarethSwan

Contact: http://mygareth.com

Gareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 25 years. He enjoys solving the complex problems that customers encounter when performance tuning SQL Server or when deploying SQL Server in large data warehouse environments. He is originally from South Africa and is currently a Dedicated Support Engineer (PFE) with Microsoft. He is a passionate member of the SQL Server community and is an accomplished author and speaker having presented at various user groups, SQLSaturdays, the PASS Summit and other technical conferences.

Leigh Freijo

Twitter: - @leighfreijo

LinkedIn: Leigh Freijo

Leigh Freijo is a Manager in Database Administration for Raymond James Financial. Leigh is an experienced SQL Server DBA and the chapter leader of the Pinellas SQL User Group.

Jorge Novo

Twitter: - @ETLDEVDBA

LinkedIn: Jorge Novo

Contact: http://etldevelopernotes.blogspot.com

Jorge Novo is a database developer with more than 10 years of experience in the design, implementation, and maintenance of OLAP, ROLAD database system for the enterprise. Jorge specialize himself on ETL processes, SQL tuning, and much more. Jorge is always eager to learn and shared his ideas and challenges with the SQL Community.

Eric Wisdahl

Twitter: - @EricWisdahl

LinkedIn: Eric Wisdahl

Eric Wisdahl is a computer engineer working in the database field. He has held multiple roles and positions in e-commerce, marketing and insurance industries. Currently, he is working as a database administrator in a development role for an e-commerce company.

Eric Wisdahl does not like writing about himself in the third person. It is kind of creepy.

Richie Rump

Twitter: - @jorriss

LinkedIn: Richie Rump

Contact: http://jorriss.net

Richie Rump is a dataveloper with Brent Ozar Unlimited, where he writes code to solve data problems. He developed statisticsparser.com and sp_DataProfile, two tools that help data professionals tune SQL Server. Richie is also the co-host of the Away From The Keyboard Podcast and founded dotNet Miami, a community focused on enterprise development with .NET. He holds the Project Management Professional (PMP) and Certified Scrum Master (CSM) certifications as well as certifications in various Microsoft development technologies. He can be found on Twitter at @Jorriss or at http://jorriss.com.

Colleen Morrow

Twitter: - @ClevelandDBA

LinkedIn: Colleen Morrow

Contact: http://colleenmorrow.com

Colleen Morrow is a database professional living in Cleveland, OH who has been working with database systems since 1996. For more than 12 years, she was a Database Administrator at a large law firm where she developed an appreciation for auditing, automation, and performance tuning. Since that time she has worked with clients in the healthcare, manufacturing, software, and distribution/freight delivery industries. Colleen is currently a Senior Consultant at Fortified Data. She is an active member of the Ohio North SQL Server User Group and has presented at many SQLSaturday events as well as PASS Summit 2014 and 2015.

Damu Venkatesan

Twitter: - @vdamu

LinkedIn: Damu Venkatesan

Damu Venkatesan is a Business Intelligence Consultant with over 25 years of IT experience including architecting and implementing BI/DW solutions using Microsoft SQL Server, PDW, SSIS, SSAS, SSRS, and Power BI. He has been speaking at many SQLSaturdays and user groups on data analytics and is actively involved in the Atlanta SQL community for several years. He has successfully delivered several BI/DW solutions and data migrations to various clients. He is also currently serving as President of DAMA Georgia chapter in Atlanta. He is the co-organizer of BI SQLSaturday in Atlanta.

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.

Ian Lanham

LinkedIn: Ian Lanham

Ian is a Database Administrator in the Orlando area, and is a regular attendee of SQLSaturday#39;s and MagicPASS#39; monthly meetings.

James McAuliffe

LinkedIn: James McAuliffe

James McAuliffe is a Cloud Solution Architect with CCG Analytics, a Microsoft Gold Partner. He is also a Microsoft Preferred Partner Solutions expert and has been worked with clients of all sizes, from local businesses to Fortune 500 companies. Today’s mix of Big Data and cloud offerings make yesterday’s dream today’s possibility. Let’s talk about it!

Patrick Pinchera

Twitter: - @patp19

LinkedIn: Patrick Pinchera

Pat Pinchera is a senior storage architect with Tegile Systems covering Florida and the Caribbean, and has spent 27 years in the IT industry. Prior to Tegile, Pat was with EMC where he worked storage pre-sales for Microsoft applications (Exchange, SQL, Hyper-V), and he was with Sun Microsystems for 15 years. Pat got his Bachelors in Chemical Engineering, and Masters in Computer Science from Florida Institute of Technology. He has been married for 27 years, and has two college-aged children.

Jeff Abbott

LinkedIn: Jeff Abbott

Jeff has been certified in various versions of SQL Server going back to version 4.2 - waaay back. He is a former Microsoft employee where he did SQL Server development. Jeff was the SQL Server lead for Veritas Storage Foundations product efforts while at Veritas Software and has provided consultative input to a wide range of international and fortune 500 companies. He has been a speaker at Microsoft TechEd, Veritas Vision and EMC World conferences and currently works for a Boston based

Ronald Dameron

Twitter: - @RonDBA

LinkedIn: Ronald Dameron

Contact: http://RonaldDameron.com

Ronald Dameron is The Only DBA at a small software company building planet-scale mobile resource management software.

He has over 20 years IT experience on a variety of platforms. His current interests are Azure, PowerShell, SQL Server 2016 and Linux.

He was a PASS Summit 2015 Speaker Idol contestant and has spoken at SQLSaturday Tampa, Orlando, South Florida, and the Tampa and Orlando SQL User groups. He has recently earned the Competent Communicator Award from Toastmasters International.

He is most active on Twitter as @RonDBA.

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.

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.

Pam Shaw

Twitter: - @PamShaw

LinkedIn: Pam Shaw

Contact: http://sqlpam.wordpress.com/

Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQLSaturday Tampa.

Troy Gallant

Contact: http://www.troygallant.com

Troy has been a SQL Server professional for over 18 years, filling various roles as analyst, developer, and for the last decade, DBA. As a regular speaker at SQLSaturdays up and down the east coast, he’s taught on a multitude of topics from disaster recovery to performance tuning to professional development. Currently residing in Jacksonville once again, he just got back from two years as Sr. DBA for the EDW of a major international insurance company in New York City.

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

Contact: http://blog.waynesheffield.com/wayne

Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne

Buck Woody

Twitter: - BuckWoodyMSFT

LinkedIn: Buck Woody

Contact: http://buckwoody.wordpress.com/

Born helpless, naked, and unable to provide for himself, Buck Woody overcame these amazing handicaps to become a software developer, data professional, teacher, and a productive invertebrate member of society.

Wes Springob

Twitter: - /SQLWes

LinkedIn: Wes Springob

Contact: http://SQLWes.com

Wes Springob is a Premier Field Engineer (PFE) at Microsoft and speaks regularly on Business Intelligence, Power BI, database and report development.

Brian Davis

Twitter: - @Brian78

LinkedIn: Brian Davis

Contact: http://blogs.sqlsentry.com

Brian Davis is a Product Integration Engineer at SentryOne and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands-on experience with SQL Server 2000 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.

Mike Davis

Twitter: - @mikedavisSQL

LinkedIn: Mike Davis

Contact: http://MikeDavisSQL.com

Mike Davis, MCITP, is a Consulting Team Lead at Pragmatic Works. He is an author with books covering Business Intelligence and SSIS. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, SQLSaturday, and SQL Rally. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.

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.

Jason Carter

Twitter: - TampaDBA

Contact: http://jason-carter.net

Jason#39;s past has included being a developer, a development manager, accidental DBA, and now a full-time DBA. Having worked with VLDBs as a developer, he found great interest in tuning, tweaking, and making things run faster. With the support of his wife, he gave up his managerial duties and jumped the Development ship and dove head first into his new career as a Database Administrator

Andrey Korshikov

Работать с SQL Server начал в 2003 году. Довелось работать и сдавать сертификационные экзамены по версиям SQL Server от 2000 до 2012. Участник конференций SQLSaturday, Платформа, DevCon и TechEd. География выступлений от Тампы до Красноярска, от Санкт-Петербурга до Тбилиси. Основатель сообществ Krasnodar SQLamp;BI Usergroup и Global Russian Virtual Chapter. На данный момент являюсь PASS Regional Mentor for Central Eastern Europe.

Susan Rickman

Susan Rickman, Principal Consultant at Intellinet, has over 14 years of experience in leading enterprise-wide data solutions. She specializes in data integration and migration, performance tuning, clustering/high availability, disaster recovery, security, and virtualization. Susan lives in Atlanta, Georgia with her family and is actively involved in many local and global charities, as well as the local SQL Server Community.

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.

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.

Charles Hyman

Mr. Hyman is an IT professional with over twenty years experience, currently specializing is Business Intelligence, Data Warehousing and Back-End Process IT systems. Mr Hyman currently splits his time, between consulting assignments, and mentoring/training assignments. Mr. Hyman is considered an Expert in the Microsoft SQL Server Products as well as the ETL and Reporting tools, BizTalk and SharePoint. Building Data Warehouses from disparate systems is his specialty

Jack Corbett

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

LinkedIn: Jack Corbett

Contact: http://www.wisemanorwiseguy.com

JJack Corbett began working with SQL Server, Access, and VB in 1999, when he served an apprenticeship with a good friend who was the software development manager at the local paper mill. He found his niche and has concentrated on SQL Server development and administration since late 2000. He has worked with SQL Server through version 2017 and was a Microsoft Data Plaform MVP from October 2011 to October 2016.

Jack is passionate about helping companies architect, design, and develop high performance applications based on the Microsoft Data Platform. He also has a passion for seeing database developers get the core application code (the database) protected under source control.

Jack has presented at many user groups and SQLSaturday even

Pankaj Satyaketu

Twitter: - @SQLPS

Contact: http://www.sqltwist.com

Pankaj Satyaketu is a Solutions Sales Manager based out of South Florida focused on driving Data Workloads to Azure. Pankaj has also held several positions within Microsoft focused on Microsoft’s Flagship Database Engine, SQL Server.

Prior to joining Microsoft Pankaj was the Lead DBA for a major retailer out of South Florida responsible for managing and maintaining their database systems globally. Pankaj has 13+ years of experience with SQL Server in the areas of High Availability and Disaster Recovery, performance tuning, hybrid cloud migrations along with overall administration and automation.

Pankaj is an active supporter of local user groups and SQLSaturday events in Florida. He is also a graduate of Florida Atlantic University.

Jorge Besada

Jorge Besada is a SQL Server DBA with more than 15 years experience as a DBA. An electronic engineer in a previous life with an MSEE degree, Jorge morphed into an Information Technology professional and is enjoying every minute of it. His main interest is in automation of all tasks using PowerShell and Python and switching between them as needed.

Dmitri Korotkevitch

Twitter: - aboutsqlserver

LinkedIn: Dmitri Korotkevitch

Contact: http://aboutsqlserver.com

Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master, author of Pro SQL Server Internals and other books with years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect.

Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.

Daniel Janik

Twitter: - @SQLSME

LinkedIn: Daniel Janik

Contact: http://www.sqltechblog.com

Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQLSaturdays.

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.

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

Stuart Ainsworth

Twitter: - @codegumbo

LinkedIn: Stuart Ainsworth

Contact: http://codegumbo.com

Stuart Ainsworth (MA, MEd) manages a team of Service Reliability Engineers for the Gladiator Enterprise Information Security Services section of Profitstars, a division of Jack Henry and Associates. He’s a former DBA, developer, consultant, and public speaking professor. He’s one of the chapter leaders for AtlantaMDF, and a long-time organizer of SQLSaturday’s. He tweets infrequently (@codegumbo) and blogs even less often at http://codegumbo.com.

Allan Hirt

Twitter: - SQLHA

LinkedIn: Allan Hirt

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

SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.

Robert Biddle

Twitter: - @robert_biddle

LinkedIn: Robert Biddle

Contact: http://robert-biddle.com

Robert Biddle is a Data Architect for Hilton Grand Vacations in Orlando, Florida. He has over a decade of experience working with SQL Server in a variety of roles. He has a Bachelor’s degree in Computer Science from the University of Delaware and also has MCITP certifications for Database Administration and Database Development. In recent years, Robert has specialized himself working with data integration, ETL, and data warehousing. He is a frequent speaker at SQLSaturday and Code Camp events.

Prakash Heda

Twitter: - @prakashheda

LinkedIn: Prakash Heda

Contact: http://www.sqlfeatures.com/

Prakash Heda works as Manager (Data-IT) at SSC Advent. His expertise encompasses the work of automation, performance tuning/troubleshooting, high availability, san configuration and windows administration. Heda has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Heda holds certifications for MCDBA and MCITP. His background includes administration development using VB/ASP/SSIS with SQL server 2000 to 2017. He is an active member of PASS, SQLSaturday, and as well a frequent presenter at user groups, SQLSaturdays, and other community events. He is also an avid tweeter, blogger and runner.

Maximo Trinidad

Twitter: - maxtrinidad

LinkedIn: Maximo Trinidad

Contact: http://www.maxtblog.com

Maximo Trinidad (Florida Aka – Mr. PowerShell), currently work as a SAPIEN Technologies Evangelist and specialing in scripting automation on SQL Server Microsoft Cloud Technologies. Also a Microsoft MVP (PowerShell) since 2009 and active speaker since 2007 participating at SQLSaturday, IT Pro .NET Code Camps events.

Bradley Ball

Twitter: - @SQLBalls

LinkedIn: Bradley Ball

Contact: http://www.sqlballs.com

Bradley Ball is a Sr. Azure Engineer for Microsoft, and former Data Platform MVP. During his IT career Bradley has spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office of the President of the United States, and the former Data Platform Practice Manager for Pragmatic Works Consulting. He has presented at SQLSaturdays, SSUG’s, SQL Rally, DevConnections, SQLBits, SQL Live 360, and the PASS Summit. Bradley can be found blogging on http://www.SQLBalls.com

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!

Jen Underwood

Twitter: - @idigdata

LinkedIn: Jen Underwood

Contact: http://www.jenunderwood.com

Jen Underwood is a Senior Director at DataRobot. Over the past 20 years, Jen has held worldwide product management roles at Microsoft and served as a technical lead for system implementation firms. She has a unique blend of product management and “hands-on” experience in data warehousing, reporting, visualization, and advanced analytics. In addition to keeping a constant pulse on industry trends, she enjoys digging into oceans of data to solve complex problems with machine learning.

Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego.

Jeffrey Garbus

LinkedIn: Jeffrey Garbus

Contact: http://mssqlperformance.blogspot.com/

Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses.

In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems.

His latest book is “Transact SQL the Definitive Guide.”

Dustin Ryan

Twitter: - @SQLDusty

LinkedIn: Dustin Ryan

Contact: http://sqldusty.com

Dustin Ryan is a senior BI consultant and trainer with Pragmatic Works in Jacksonville, FL. Dustin specializes in delivering quality enterprise-level business intelligence solutions to clients using SSRS, SSIS, SSAS, SharePoint, and Power BI. Dustin has authored and contributed to SQL Server books. You can find Dustin speaking at events such as SQLSaturday, Code Camp, and online webinars.


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

Back to the SQLSaturday Event List

Back to the home page