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
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: 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?”
Speaker(s):
- 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!
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- Patrick LeBlanc
Track and Room: BI Information Delivery - Azure+ - 1206B
Title: SQL SERVER 2016 PERFORMANCE FEATURES
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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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!
Speaker(s):
- 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
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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!
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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!
Speaker(s):
- 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!
Speaker(s):
- 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!
Speaker(s):
- 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.
Speaker(s):
- 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”.
Speaker(s):
- 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?
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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
Speaker(s):
- 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:
- 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.
- How you can benefit from In-Memory OLTP objects even when system migration is cost ineffective.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- Pankaj Satyaketu
Track and Room: Cloud Application Development Deployment - Azure+ - 1206B
Speakers
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.
Sponsors
The following is a list of sponsors that helped fund the event: