SQLSaturday #678 - Orlando 2017

Event Date: 10/07/2017 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.

Sessions
Speakers
Sponsors

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: Supercharge Your Maintenance Plans!

Abstract: Today’s SQL Server DBA has a myriad of options when it comes to implementing their backup and maintenance strategies. From internal maintenance plans to all-encompassing third-party solutions, the options are practically endless. One very popular solution revolves around a set of free scripts provided by Swedish data scientist, Ola Hallengren. These well admired scripts are used by corporations large and small worldwide in order to facilitate backups, integrity checks, and index maintenance operations.

In this session, not only will we introduce these scripts to those unfamiliar with them, but just as importantly, we’ll take a detailed look into just how these scripts can be extended and customized even further. You’ll be amazed at the flexibility offered by the optional parameters. We’ll also take a gander into the remarkably detailed logging tables in order to inspect the raw data and possibly turn it into a valuable reporting data source.

Speaker(s):

Troy Gallant

Track and Room: Enterprise Database Administration Deployment - R3102

Title: Data Security with Power BI, SSAS, SQL Server and Active Directory

Abstract: Today’s Business Intelligence Tools allow to secure the data for a variety of business scenarios. Learn How Row Level Security and other security data technologies can be implemented in Power BI, SSAS, and SQL Server and can change the design of corporate Apps using Active Directory. In this session, BI Architect and Microsoft Certified Professional, Hector Villafuerte focuses upon the design and architecture of data security using different tools: Power BI, SSAS, SQL Server, Web Apps and explain when to use them, their differences and their limitations. Throughout the session, we explore and demo various ways to secure the data and witness how to implement the security in each.

Speaker(s):

Hector Villafuerte

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

Title: Creating Reports and Dashboards with Power BI

Abstract: This session looks at both Power BI Desktop and Power BI.com to compare the advantages and capabilities of both platforms for creating and distributing data analysis within your organization. It will also touch a little on why you might choose Power BI over Power Pivot and why you might not. It will also look at how to create drill down detail screens to expose the details behind your visualizations. Finally, we will touch on how to publish your Power BI results for others in your organization to share. A basic understanding of database structures and referential integrity is an advantage to gain the most from this session, but as will be shown, not always necessary depending on the source of the data to be analyzed.

Speaker(s):

Michael Antonovich

Track and Room: BI Information Delivery - R2105

Title: Monster VM’s (Database Virtualization) with vSphere 6.5 Doing IT Right

Abstract: vSphere 6.5 has made a lot of changes to enhance the performance of Monster VM’s. Databases by their very nature are the classic Monster VM’s. If Monster VM’s are not virtualized properly they will never perform well and can negatively performance of other VM’s on the hosts. In this presentation, we will teach you how to properly virtualize Monster VM/Databases with vSphere 6.5. We will discuss why you virtualize, installation issues, how to Architect for performance discussing vSphere 6.5 specifics, the storage layer, the processor, Memory considerations, the network layer. Topics include NUMA, Memory reservations, how to avoid common mistakes. Lesson learned here help you optimize any workload you are virtualizing. With Special emphasis on Monster VM’s on Vsphere 6.5

Speaker(s):

Michael Corey

Track and Room: Cloud Application Development Deployment - R2103

Title: What’s new for SQL Server Analysis Services?

Abstract: So, do we stick with the Cube or move to Tabular? Has DAX functionality improved enough to rely on performance with DirectQuery in a Tabular Model? Will we be porting Analysis Service (SSAS) databases to Azure? How do we know what level or pricing model is adequate for an Azure SSAS database? When an SSAS database gets created, and users start to report against, it is very hard not to continue to expand the model. Anxiety is released when a new release of SSAS comes along adding functionality to replace the hooks created to satisfy user requirements. With 2016 and 2017, Microsoft is moving to update Tabular Models with more features, improved performance and better security. The Cube additions are mainly with Data Sources and better T-SQL generated to access source databases like Oracle and Teradata. So, let us examine the pros and cons together and get a consensus of the path forward with SSAS. You are definitely not going to want to stop using this tool.

Speaker(s):

Thomas LeBlanc

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

Title: Monitoring and Alerting of Availability Groups

Abstract: So you have your availability groups configured and everything reports green. How do you measure SLA compliance? Do you know when replication is delayed? Were you notified when it failed over last night? This session will answer all these questions and more, and will show you what you should be looking at to ensure no surprises. We will look at the DMVs, extended event sessions, perfmon counters, SQL agent jobs and alerts to show what to monitor in your AG and how to setup alerting so you know when to take action. Demo: Show AG dashboard and cause AG failures and excessive delay and show how alerts are sent Goals:
Teach what to monitor in AGs for proper health Alert on events when they occur which the DBA should know about Demonstrate alerts and notifications when failures or delays occur in your environment

Speaker(s):

Shawn Meyers

Track and Room: Enterprise Database Administration Deployment - R2208

Title: Uptight Database Security

Abstract: Do you work for an institution that fears it’s DBAs could go rogue on their production databases? Do you want to revoke continuous sysadmin permissions from your DBA team in an attempt to avoid being the next WikiLeak? Do you have concerns that the DBA team is querying sensitive databases? Then, you need Uptight Database Security. Come to this session to learn how to deploy a configurable permission model that provides on-demand access to SQL Server databases. This model allows DBAs to do routine work without sysadmin, elevate permissions to sysadmin only during production emergencies or disaster recovery scenarios. Attendees will leave this session with the fundamental knowledge and scripts to implement a low hassle solution that provides DBAs the minimum necessary access required to maintain a production database server.

Speaker(s):

Ronald Dameron

Track and Room: Enterprise Database Administration Deployment - R2206

Title: How To Tune A Multi-Terabyte Database For Optimum Performance.

Abstract: This session will cover how to tune a multi-terabyte database where all of the data is stored a single file, primary file group. We will look at file groups, managing indexes and moving large amounts of data.

Speaker(s):

Jeff Taylor

Track and Room: Enterprise Database Administration Deployment - R3205

Title: ARMed for Azure

Abstract: The Azure Resource Model (ARM) enables Azure infrastructure automation for both IaaS and PaaS deployments. Using Visual Studio as a management tool enables repeatable, automated, source controlled deployments for test and development environments, enabling true DevOps practices for all aspects of pre-production systems. In this session, I will demonstrate, explain, and deploy a IaaS/PaaS hybrid environment (SQL and BI stack elements) using ARM templates, Visual Studio, source control integration, and PowerShell scripts.

Speaker(s):

Geoff Hiten

Track and Room: Cloud Application Development Deployment - R2205

Title: Cautionary Tale of Recompilations, Excessive CPU Load and Plan Caching

Abstract: SQL Server reduces compilation and optimization overhead by caching and reusing execution plans for the queries. Plan caching helps to reduce CPU load on the server; however, it may also introduce unexpected issues and lead to suboptimal execution plans and performance problems.

In this session, Dmitri will explain how plan caching works internally and demonstrate how to address several common issues related to the plan caching. He will talk about parameter sniffing, simple and forced parameterization, OPTIMIZE FOR UNKNOWN strategy, and several other related topics. Finally, Dmitri will provide the guidelines how to reduce CPU load and recompilation overhead in the systems with heavy ad-hoc workload and non-parameterized queries.

Speaker(s):

Dmitri Korotkevitch

Track and Room: Enterprise Database Administration Deployment - R3205

Title: SQL Audit - Evidence Never Lies

Abstract: We’ve all heard about massive data breaches from big name companies. As a DBA, you should consider your company’s data to be the most valuable assets. So when a data breach happens at your company, will you be able to provide management with the information? If not, then discover how SQL Server Audit can help provide you with an accurate forensic analysis of who did what to your data. In this session, we’ll cover what SQL Audit can capture, how to set it up for both on-premise SQL Servers and Azure SQL Database, and finally produce reports from it.

Speaker(s):

Patrick Keisler

Track and Room: Enterprise Database Administration Deployment - R2206

Title: Logging Messages in SQL Server

Abstract: Logging messages in your database is a common request, and there are a million ways to do it. This presentation will cover basic methods and progress through more advanced ones. We’ll also show how autonomous transactions (available in some database products, but not natively supported in SQL Server) can be accommodated with some interesting techniques.

We’ll examine user-defined events, linked servers and the new SESSION_CONTEXT() feature in SQL Server 2016, to provide different levels of logging and transaction management, and cover their best use cases.

Speaker(s):

Rob Volk

Track and Room: Application Database Development - R3205

Title: vNUMA, pNUMA, save your SQL Servers from certain DoomA

Abstract: When presented with large SQL Server workloads in a virtual environment, which cross NUMA boundaries, it is very important to understand how the hypervisor presents vNUMA to the SQL Server virtual machine. When there is a NUMA imbalance, it can have as much as a 40% impact on performance, causing a significant effect on your virtual environment. In this session attendees will learn ways to optimize vNUMA including: • How vNUMA works across different processors; and the ways that Intel and AMD are different • Methods for determining if a NUMA imbalance exists • Which settings at the hypervisor, or virtual machine level, should be changed to ensure the best performance

Speaker(s):

Shawn Meyers

Track and Room: Enterprise Database Administration Deployment - R2208

Title: A DBA’s guide to whole stack performance troubleshooting

Abstract: Performance troubleshooting is a required skill for every DBA. Knowing the deep internals of how a query functions and why SQL Server chose to run it in a certain way is important. Knowing how to design a table or configure a database to squeeze every ounce of performance is our lifeblood.

What if I told you that you may be doing this all wrong? What if all the work and laborious effort put into design or configuration don’t improve the situation because the issue was never in SQL to begin with? Truth be told, the biggest differentiator between a good DBA and a great DBA is knowing the hardware and O/S; not just SQL.

Join me as I guide you through troubleshooting SQL Server performance from tip to toe to demonstrate the common performance problems you never knew you had.

Speaker(s):

Daniel Janik

Track and Room: Advanced Analysis Techniques - R2105

Title: Excel and SSIS: Better Together

Abstract: If you’ve ever used the standard Excel Source or Destination components in SSIS, you know there are some limitations. Cozyroc’s Excel Source Plus and Excel Destination Plus components remove those limitations. In addition, Cozyroc’s Excel Task enables editing of Excel files from SSIS packages. In this session, I’ll talk about the capabilities of the Cozyroc components and demonstrate how easy it is use use these components with SSIS.

Speaker(s):

Diane Schuster

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

Title: Getting Noticed: Strategies for Your Resume and LinkedIn

Abstract: You know you are well qualified for the jobs that you search for on any major job site. You know that if you just get to that next step that they will see it for themselves. This lightning talk focuses on strategies for your resume and LinkedIn profile to help get you noticed and reach that next step. Interaction with the audience is encouraged throughout the discussion.

Speaker(s):

Rick Heiges

Track and Room: Professional Development - R2205

Title: Query Store Primer

Abstract: This session will take a look at the new Query Store feature in SQL Server 2016. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse. We will take a hands on look at how to use Query Store to troubleshoot problems new features in 2017.

Speaker(s):

Tracy Boggiano

Track and Room: Enterprise Database Administration Deployment - R2103

Title: Indexing for performance

Abstract: Learn all you wanted to know about index design, but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session

Speaker(s):

Jeffrey Garbus

Track and Room: Enterprise Database Administration Deployment - R3205

Title: Azure Sql PAAS: Lessons from the Real World

Abstract: So you’re using Azure Sql Database Platform As A Service. Now what? Without a physical machine, how do you do restore? Where are the backup files? When are service packs applied? Can service packs be rolled up thru dev to production? What’s a service level and how does it impact database design? How do we encrypt, authorize, query tune, restore…? We’ll go over these questions and any others that you may have.

Speaker(s):

Jonathon Moorman

Track and Room: Strategy and Architecture - R2207

Title: Tips on Managing Lots of SQL Servers

Abstract: When managing a single server it is easy to keep track of the configuration of that server, but what about when you have more than ten servers to manage or a hundred? How do you know they are setup correctly? How do you maintain the databases on each server? How do you take care of patching? How do you know when your server is on fire?

In this talk we will answer these questions and more as we discuss technologies and approaches you can use to make sure your environment is configured and performing at its best.

Speaker(s):

Tracy Boggiano

Track and Room: Enterprise Database Administration Deployment - R2207

Title: SQL Server Data Partitioning

Abstract: Data partitioning allows for the efficient loading, storage, retrieval, and shedding of data in an RDBMS platform. This session will focus on its use in MS SQL Server and how table partitioning can improve performance, manageability, and decrease concerns over concurrency. Especially if you are working with a data warehouse, you want to be sure to understand these concepts and how/when you might leverage them.

Speaker(s):

Tom Hanley

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

Title: Execution Plan Basics - Beginners

Abstract: This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?

Speaker(s):

Thomas LeBlanc

Track and Room: Application Database Development - R3102

Title: Winning with Columnstore - A Customer Story

Abstract: This session will feature a real story of a customer who was running into performance and scaling issues on a big iron Oracle RAC system and why they decided to consider the magic of the Column Store for this situation. Discussion will focus on the existing environments for testing both SQL 2016 and Oracle as well as the methodologies used for testing. We will examine the decisions made for choosing indexes (both traditional and column store) for the main tables in the data warehouse as well as the partitioning strategies employed. We will wrap up the discussion with the results of the testing and where they are now.

Speaker(s):

Rick Heiges

Track and Room: Enterprise Database Administration Deployment - R2105

Title: Database Continuous Delivery

Abstract: Automating your deployments should not be limited to applications. In this session, learn how to create an automated deployment pipeline that includes your application and database using Redgate’s DLM Automation tools. You will get instant feedback on your code changes, get the exact script you need for release automation and, when you’re ready, you can deploy to production in confidence. We will use Visual Studio, Visual Studio Team Services to create a build and release pipeline to deploy your changes to dev, staging, and production environments. [Presenter will be Esteban Garcia]

Speaker(s):

Andy Warren

Track and Room: Enterprise Database Administration Deployment - R2206

Title: Replicating data from SharePoint Online to SQL Server

Abstract: Ever wanted to query SharePoint Online Lists from SQL Server directly, or even create a replica of your SharePoint data in a SQL Server database for offline reporting? In this session, I will show you a new technology that allows you to access your SharePoint environment through simple SQL queries, in real-time, and how to replicate your SharePoint lists for offline reporting with just a few clicks.

Speaker(s):

Herve Roggero

Track and Room: Strategy and Architecture - R3102

Title: Baseball Analytics: SQL Server 2016 In-Database R

Abstract: This session is meant to dive into the world of R using awesome data to make learning memorable. We will discuss a brief overview of the syntax, how to write an In-Database R query, and then dive into a data set using the Lahman database data from Retrosheets.org to examine baseball games from 1990 – 2016 to answer the following questions: If I want to see my team win a game should I go to a double header? What is the best day of the week to see my team play? What is the best day if they are above .500 or below? What if they have home vs. away games? Then we will display the results in Power BI or and Excel Dashboard. Come for the Science stay for the data!

Speaker(s):

Bradley Ball

Track and Room: Advanced Analysis Techniques - R2208

Title: InMemory Improvements on SQL 2016

Abstract: SQL Server 2016 lifted several limitations from its initial implementation. This session will cover how to implement InMemory objects, new capabilities (Defaults, Checks, FK validation, Triggers); performance gains; and an introduction to monitoring these objects.

Speaker(s):

Sam Mesel

Track and Room: Other - R3102

Title: Getting graphy with CosmosDB Graph API with Gremlin

Abstract: CosmosDB was announced at Build 2017 as an extension to Microsoft’s DocumentDB offering and is positioned to be a key component of the Microsoft Data Platform. In this session, we will explore CosmosDB’s graph API that is built using Apache’s TinkerPop and Gremlin projects. Graph databases allow you to build a powerful data model that explores connections and paths between data. At the end of this session, attendees will have a solid understanding of what a graph database is and how you can use Gremlin and the .NET API to interact with a graph database.

Speaker(s):

Christopher Sims

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

Title: Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Abstract: While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.

Speaker(s):

Amy Herold

Track and Room: Enterprise Database Administration Deployment - R2103

Title: Master Data Management with SQL Server 2016 MDS

Abstract: Want to know the position Master Data Management and MDS play in an organization’s overall data strategy? We’ll review the key concepts and the different roles and responsibilities to help you get your organization moving forward with MDM. We’ll then take a look at the features of SQL Server 2016 MDS that make it an excellent tool for MDM. This demo-packed presentation will cover architecture and installation, different ways of processing data, hierarchies, security and many other features that will get you up and running with MDS.

Speaker(s):

Neal Waterstreet

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

Title: Introduction to unit and integration testing with tSQLt

Abstract: Testing allows database code to be consistently verified during the development process, but it can be challenging to get testing setup for database development. This session will give an overview on the purpose of database testing, the installation of the tSQLt framework, and the design of unit and integration tests. I will use general concepts of test driven design to create and run tests to confirm that objects exist and to test single and multiple test cases. Learn how to implement testing in a development environment and create and run your own tests.

Speaker(s):

Elizabeth Noble

Track and Room: Application Database Development - R2206

Title: Processing Big Data with Azure Data Lake Analytics

Abstract: In this session of Getting Started with Azure Data Lake Analytics, we will learn about fundamental concepts and considerations for designing a Data Lake, how that fits into your organization, and then spend most of the time processing data with Data Lake Analytics using Microsoft’s new Big Data language, U-SQL.

Speaker(s):

Sean Forgatch

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

Title: Data Cleansing With SQL And R

Abstract: On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set.

Speaker(s):

Kevin Feasel

Track and Room: Analytics and Visualization - R2205

Title: Database Creation Process

Abstract: How to set up a Requirements Analysis to develop successful databases

Speaker(s):

Arvin Meyer

Track and Room: Application Database Development - R2208

Title: Working with SQL Server for Linux Cross-Platform

Abstract: I will be showing the latest build of SQL Server vNext for Linux. Everything you need to install and connect to SQL Server. Then, what tools are available to use from either Linux and Windows. Sample on querying for database information using Python and PowerShell between two environments. This will be a demo intensive session

Speaker(s):

Maximo Trinidad

Track and Room: Application Database Development - R2208

Title: The Path to #GetModern by Dell EMC

Abstract: To succeed in this new digital world, companies will require an IT Transformation. Dell EMC has announced a wave of innovations to help customers on their path towards a modern infrastructure and business agility. Join us to learn how to innovate faster, create competitive advantage, improve IT operations, reduce costs and ultimately #GetModern. The speaker for this session is Dominick Dequarto.

Speaker(s):

Andy Warren

Track and Room: Advanced Analysis Techniques - R3102

Speakers

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

Thomas LeBlanc

Twitter: - TheSmilingDBA

LinkedIn: Thomas LeBlanc

Contact: http://Thomas-LeBlanc.com

Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Warehouse Architect in Baton Rouge, and uses his 30+ years in IT to develop OLTP systems with normalized databases for high-performing T-SQL and dimensional data marts. Development is done in SSIS, SSAS, SSRS, Power BI, and Excel. As a PASS volunteer, he is past chair of Excel BI and Data Arch VCs and is active in the Baton Rouge Analytics and SQL Server User groups, as well as SQLSaturday in Baton Rouge. You can find his blog at TheSmilingDBA.BlogSpot.com and website at Thomas-LeBlanc.com

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.

Tracy Boggiano

Twitter: - TracyBoggiano

LinkedIn: Tracy Boggiano

Contact: http://databasesuperhero.com

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

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

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

Christopher Sims

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

LinkedIn: Christopher Sims

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

Chris is a software engineer and program manager with over 18 years of programming and 14 years of project management experience. Chris continually pushes his personal and professional boundaries by actively seeking out complex projects and applying innovative, sophisticated and elegant solutions to real-world problems. Chris is the technical principal of agile consulting firm, Sigao Studios. Sigao Studios specializes in offering modern responsive web solutions based on technologies that include Azure, CosmosDB and Azure Search. In addition to his technical pursuits, Chris enjoys stage acting and wood working in his free time.

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

Michael Corey

Twitter: - Michael_corey

LinkedIn: Michael Corey

Contact: http://michaelcorey.com/

Michael is a Director Cloud Computing Evangelist for Spectrum Enterprise Navisite. In 2017, was recognized as #42 of the top 100 most influential people in the “cloud industry”. Michael’s a recognized Microsoft Data Platform MVP formerly (Microsoft SQL Server MVP), recognized Oracle ACE, a recognized VMware vExpert and has worked with relational databases for over 30 years starting with Oracle Version 3. Michael is a Past President of the Independent Oracle Users Group (IOUG), A Founder of the Professional Association of SQL Server and current President of the IOUG VMware Special Interest Group. Michael is the original Oracle Press author, frequent blogger http://michaelcorey.com/, a regular columnist for the Big Data Quarterly

Sam Mesel

will be provided later on

Arvin Meyer

LinkedIn: Arvin Meyer

Having 16 consecutive MVP awards, Arvin maintains the Access Web http://www.mvps.org/access, an Access download site on his domain (http://www.datastrat.com), owns and is webmaster of http://www.accessmvp.com, and several client websites. A Microsoft Certified Professional and Microsoft MVP, Arvin writes freelance technology articles, is an author of a book on Access, leads the Access, Office, and Security Special Interest Groups at the Central Florida Computer Society.

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.

Shawn Meyers

Twitter: - 1dizzygoose

LinkedIn: Shawn Meyers

Shawn Meyers is a Field CTO working at Tintri. Shawn has worked in IT for 25+ years and specifically with SQL Server for 20+ years, beginning with version 6.5. A frequent speaker at many events including PASS Summit, VMworld, VMUGs, Virtual Chapter sessions, and many SQLSaturday events. Current focus is on improving DBAs lives with better infrastructure.

Patrick Keisler

Twitter: - @PatrickKeisler

LinkedIn: Patrick Keisler

Contact: http://www.patrickkeisler.com

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

Sean Forgatch

Twitter: - 4gatchsql

LinkedIn: Sean Forgatch

Contact: https://www.modern-dataengineering.com

Sean Forgatch is a Manager in Data Engineering consulting Avanade\Accenture based out of Chicago, IL focusing on Data Strategy, EIM , and Data Archtiecture. Serving multiple Fortune and Global 500 companies he has helped push the limits of Azure and is working on some of the largest Azure Data Lake and Analytics implementations in the industry. He has spoken at over 25 conferences across the United States since 2016, was the President of the Northeast Wisconsin PASS, and served on the board for SQLSaturday Madison.

Originally from Southern Illinois, Sean enjoys running and lifting, as well as casual conversations with coffee, and spending time with his dog Sailor, an all white Siberian Husky.

Diane Schuster

LinkedIn: Diane Schuster

Diane has worked with COZYROC since 2012. She has attended numerous SQLSaturdays to shine the light on the time-saving and capability-extending components and tasks that COZYROC offers in it’s SSIS+ library. Without even having a background in databases or SQL Server, Diane successfully configures packages in live demonstrations that use COZYROC components and tasks. She believes that, if the toolkit is this easy to use for a novice, then just imagine what a SQL Server expert can do with it!

In Diane’s data networking days, Diane performed a variety of development-related and customer-facing roles for IBM, Lucent Technologies, North Carolina State University and Connectware.

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

Thomas LeBlanc

Twitter: - TheSmilingDBA

LinkedIn: Thomas LeBlanc

Contact: http://Thomas-LeBlanc.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.

Rick Heiges

Twitter: - heigesr2

LinkedIn: Rick Heiges

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

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

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.

Neal Waterstreet

Twitter: - @nealwaterstreet

LinkedIn: Neal Waterstreet

Contact: http://www.nealwaterstreet.com

Neal is a BI Architect/Consultant with more than 20 years of industry experience. Neal is skilled in the entire BI spectrum, including dimensional modeling, ETL design and development using Integration Services (SSIS), designing and developing multidimensional cubes and Tabular models using Analysis Services (SSAS) and Master Data Management using Microsoft Data Services (MDS). He’s also involved with the database community and is the co-founder and co-leader of the PASS Healthcare Virtual Chapter and the Atlanta Modern Excel User Group.

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.

Hector Villafuerte

Twitter: - optimumclick

LinkedIn: Hector Villafuerte

Contact: http://www.hectorv.com

Hector Villafuerte is a Microsoft Certified Professional and is currently the BI Solutions Architect at Starwood Property Trust in Miami Beach, Florida. He has over twenty years of experience working in all areas of the Software Development Life Cycle. Current focuses include Power BI, SQL Server, SharePoint, Dynamics CRM, Office 365, Azure SQL, SSAS, No SQL, Machine Learning and other Azure Development Technologies as full stack developer.

Shawn Meyers

Twitter: - 1dizzygoose

LinkedIn: Shawn Meyers

Elizabeth Noble

Twitter: - SQLZelda

LinkedIn: Elizabeth Noble

Elizabeth Noble is a Director of Database Development in the metro Atlanta area. When she was introduced to her first database over 10 years ago, it was love at first sight. Her passion is to help others improve the quality and speed of deploying database changes through automation. When she is not trying to automate all of the things, she can be found spending time with her dogs, playing disc golf, or taking a walk at the gym.

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.

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.

Geoff Hiten

Twitter: - SQLCraftsman

LinkedIn: Geoff Hiten

Geoff Hiten is a Technical Solutions Professional at Microsoft. Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since. He specializes in highly available SQL systems, performance tuning, and systems migration. Geoff is heavily involved in the Microsoft SQL Server Community and was initially awarded MVP status in 2004. Geoff was appointed in 2011 to fill an interim Director position at the National PASS organization.

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.

Tom Hanley

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

LinkedIn: Tom Hanley

I grew up in New York state until sophomore year of high school when my family moved to the south. I attended Clemson and Georgia Tech. I then worked in Chicago and later in Charlotte for a few different companies. A Disney fan for much of my life, I was thrilled when I got an opportunity to work for the company and have been a Cast Member for 3 years. My background has largely been database development and solutions architecture with an emphasis on data warehousing.

Rick Heiges

Twitter: - heigesr2

LinkedIn: Rick Heiges

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

Herve Roggero

Twitter: - @hroggero

Contact: http://geekswithblogs.net/hroggero

Herve Roggero, Microsoft Azure MVP, is the founder of Enzo Unified (www.enzounified.com). Herve’s experience includes software development, architecture, database administration and senior management with both global corporations and startup companies. He holds multiple certifications, including an MCDBA, MCSE, MCSD. He is a Pluralsight author, runs the Azure Florida Association, and co-authored two Azure book with Apress.

Michael Antonovich

Twitter: - @SharePointMikeA

LinkedIn: Michael Antonovich

Contact: http://sharepointmike.wordpress.com

Michael Antonovich is the assistant director of Web and Technology Services in the Communications Division for Orange County Public Schools in Orlando, FL, where he manages the Internet and intranet infrastructure. He has published seven books, ranging from an Apple II User Guide to Office and SharePoint 2010 User’s Guide. His blog has focused mainly on PowerPivot and Power BI, but for the last year Mike has taken a break to pursue some other activities. He hopes to restart his blog later this year focusing more on style and presentation. Mike has used SQL Server since 1998 and, for the past 7 years, has been promoting SSAS, PowerPivot, and Power BI for the masses.

Tracy Boggiano

Twitter: - TracyBoggiano

LinkedIn: Tracy Boggiano

Contact: http://databasesuperhero.com

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

Jeff Taylor

Twitter: - reviewmydb

LinkedIn: Jeff Taylor

Contact: https://blog.reviewmydb.com

Jeff Taylor is a Senior Software Data Architect. His work with databases began with SQL Server 6.5 over 22 years ago. He specializes in performance tuning and critical operational database issues. Currently he is serving as the President of the Jacksonville SQL Server Users Group and is an active board member of the Jacksonville Development Users Group.

Jonathon Moorman

LinkedIn: Jonathon Moorman

Jon has developed using Sql Server since version 6.0! Easily distracted by shiny objects, he has always been on the bleeding edge of sql development. When not presenting, Jon might be found backpacking, hiking, camping, canoeing, or simply resting at home with a good scifi book.

Andy Warren

Twitter: - @sqlandy

Contact: https://sqlandy.com

Amy Herold

Twitter: - @texasamy

LinkedIn: Amy Herold

Contact: http://www.sqlkitten.com/

Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQLSaturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.

SQLSaturday #678 - Orlando 2017

Sessions

Title: Supercharge Your Maintenance Plans!

Title: Data Security with Power BI, SSAS, SQL Server and Active Directory

Title: Creating Reports and Dashboards with Power BI

Title: Monster VM’s (Database Virtualization) with vSphere 6.5 Doing IT Right

Title: What’s new for SQL Server Analysis Services?

Title: Monitoring and Alerting of Availability Groups

Title: Uptight Database Security

Title: How To Tune A Multi-Terabyte Database For Optimum Performance.

Title: ARMed for Azure

Title: Cautionary Tale of Recompilations, Excessive CPU Load and Plan Caching

Title: SQL Audit - Evidence Never Lies

Title: Logging Messages in SQL Server

Title: vNUMA, pNUMA, save your SQL Servers from certain DoomA

Title: A DBA’s guide to whole stack performance troubleshooting

Title: Excel and SSIS: Better Together

Title: Getting Noticed: Strategies for Your Resume and LinkedIn

Title: Query Store Primer

Title: Indexing for performance

Title: Azure Sql PAAS: Lessons from the Real World

Title: Tips on Managing Lots of SQL Servers

Title: SQL Server Data Partitioning

Title: Execution Plan Basics - Beginners

Title: Winning with Columnstore - A Customer Story

Title: Database Continuous Delivery

Title: Replicating data from SharePoint Online to SQL Server

Title: Baseball Analytics: SQL Server 2016 In-Database R

Title: InMemory Improvements on SQL 2016

Title: Getting graphy with CosmosDB Graph API with Gremlin

Title: Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Title: Master Data Management with SQL Server 2016 MDS

Title: Introduction to unit and integration testing with tSQLt

Title: Processing Big Data with Azure Data Lake Analytics

Title: Data Cleansing With SQL And R

Title: Database Creation Process

Title: Working with SQL Server for Linux Cross-Platform

Title: The Path to #GetModern by Dell EMC

Speakers

Sponsors