SQLSaturday #759 - Jacksonville 2018
Event Date: 05/05/2018 00:00:00
Event Location:
- The University of North Florida Campus
- 1 UNF Drive
- Jacksonville, 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: 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 - 51-1101 (Dev)
Title: Harassment| Bystander’s Guide to Action
Abstract: Have you ever encountered harassment at work? Me, too. In your workplace, what would you do if someone was choking? If their clothes were on fire? Statistically, you are far more likely to witness harassment. Do you know what to do? Bystanders have unique power to resolve harassment and restore respect in the workplace. Uncertainty is the biggest reason Bystanders don’t take action. Vagueness about what action to take, and when. Indecision about when and what action is warranted. Even doubt about the role Bystanders should play. In this session you will:
- Bystander will cultivate an awareness about workplace harassment.
- Bystander will learn to employ to observations and interpretation of cues and clues to workplace harassment.
- Bystander will apply measured steps to develop a plan of action/response in the face of workplace harassment.
- Bystander will confidently take action using moral courage and candid conversation to restore respect and resolve workplace harassment.
Speaker(s):
- Cindy Chapman
Track and Room: Professional Development - 51-1209 (Prof Dev)
Title: HiHo! HiHo! SQL Server on Linux, We Go!
Abstract: SQL Server has been running on Windows for years. Now Microsoft is making it available on Linux in order to provide a consistent database platform across Window and Linux servers, as well as on-premises and in the cloud. In this presentation, Janis Griffin, database performance evangelist at SolarWinds, will discuss the advantages of using SQL Server on Linux, comparing architecture, cost and performance. Several demonstrations on installing and maintaining SQL Server on Linux will be shown along with an introduction of several useful Linux commands.
The participant will learn:
- The advantages of using SQL Server on Linux, comparing architecture, cost and performance to Window servers.
- How to install, maintain and backup SQL Server on Ubuntu Linux systems
- Several useful Linux commands to monitor/manage SQL Server
Speaker(s):
- Janis Griffin
Track and Room: Enterprise Database Administration Deployment - 51-1103 (Features)
Title: Are They Hearing What You Said - or Something Completely Different?!
Abstract: In this 60 minute interactive workshop, attendees are given the knowledge tools to take charge of their listening skills to improve the quality of their communication with other professionals. Ever have trouble getting the right message across to your co-workers or clients? This topic deals with the ways we communicate – accurately and inaccurately – and includes 2 interactive elements: table exercise about voice inflection called “Really? REALLY?!” volunteer activity called the “Alien Press Conference” – a hilarious take on verbal non-verbal cues. Other topics include: Challenges of Communicating; Listening to Understand, Not Respond; 7 Stages of Communication; Verbal vs Nonverbal Cues; Tone is Everything; 5 Ways to Change Your Listening Habits Now; and more. Attendees will learn: • How to control their voice tone and inflection to improve their message delivery; • How to develop and improve their active listening skills; • How to use non-verbal cues to their advantage; more
Speaker(s):
- Brad Raney
Track and Room: Professional Development - 51-1209 (Prof Dev)
Title: To Azure and Beyond: Create an Azure VM with SSRS server and deploy Mobile and Paginated reports
Abstract: SSRS Report Server is no long ‘earthbound’; it can live among the ‘stars’ up in Azure! When we think of Azure, our happy home in the Cloud, we may not think Reporting Services; after all, we have Power BI. However, even with Power BI, there is still a strong need (desire) for paginated reports in today’s businesses. So how can we have the best of both worlds; have the data and servers in Azure and still create SSRS reports for the end users? The answer: create a report server in Azure. With that, you can host both Paginated (old style) and Mobile Reports. Steve will deploy both to the newly created VM. Steve will take you step by step to Build a VM in Azure, Create a Report Server on the VM, and Configure the various components; you will be able to see how everything works together. Come join Steve for this demo heavy session as he walks you through the entire process, including report deployment. Lastly, compare Paginated Mobile rpts to similar PowerBI. To Azure and Beyond!
Speaker(s):
- Steve Schneider
Track and Room: BI Platform Architecture, Development Administration - 4-1705 (Data Science / Visualization)
Title: Discovering SSRS 2016 in Azure: Dataset to Deployment
Abstract:
Dataset to Deployment (to Azure!!?) in one session, seriously? Well, it depends. Sixty minutes is not enough time to become an expert on how to create a dataset, develop a report with SQL Server Data Tools (SSDT) and deploy the report to a Report Server in Azure; but you can become familiar with the SSRS components and the report deployment process. Whether you are new to 2016 SSRS or have some SSRS experience, there’s something to learn for everyone.
In ‘Dataset’, we’ll talk about different options and ideas to create a good dataset. Then in ‘Develop’, we’ll look at the various components inside SSDT; building a report along the way. In ‘Deploy’, we’ll walk through the steps to configuration and deploy the report to a Report Server sitting on a VM in Azure. Yes, Azure!
By the end of the session, you will be more familiar with the SSDT environment and the report deployment process. You won’t be a pro after this one session, but you will definitely be on your way!
Speaker(s):
- Susan Schneider
Track and Room: BI Information Delivery - 4-1705 (Data Science / Visualization)
Title: Database Design Fundamentals
Abstract: Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming “difficulties” are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = ‘A’ is killing your performance, and more time for solving the next customer problem.
Speaker(s):
- Louis Davidson
Track and Room: Application Database Development - 51-1205 (Intro to DBA)
Title: Let Me Finish… Isolating Write Operations
Abstract: OLTP databases can be constantly written to and reporting databases are written to at least periodically. In order to ensure consistent results, connections must be isolated from one another while executing, ideally with the lowest possible cost to concurrency. How this isolation is handled is based on the isolation level, whether the classic lock based or the newer optimistic scheme of the in-memory OLTP engine is used, or even if both engines are enlisted in the same transaction. In this session we will look at examples of how SQL Server isolates reading and writing operations from other writing operations to explore how this may affect your application through error messages and performance hits.
Speaker(s):
- Louis Davidson
Track and Room: Application Database Development - 51-1101 (Dev)
Title: Successfully Virtualizing SQL Server on vSphere
Abstract: Today, many organizations have already virtualized most of their non critical applications, these organizations are now employing a “Virtual First” policy, harnessing the efficiency and cost savings of virtualization for their most critical applications. Still, many IT architects and DBA’s are hesitant of virtualizing their SQL workloads, they are worried about performance, scale, availability and support for what is usually considered their most critical applications. In this session we will review the guidance for successfully virtualizing critical SQL databases, we will cover the best practices, real world customer experience and what to watch out for when virtualizing the most critical SQL databases. The session is delivered by a member of the VMware’s SQL Server Experts Group.
Speaker(s):
- Shawn Meyers
Track and Room: Enterprise Database Administration Deployment - 4-1704 (Azure)
Title: What’s New in the 2017 Query Store
Abstract: The Query Store houses valuable information on performance of your queries as well as gives you great insights into your query workload and plan changes. This presentation will take a look at what’s new in the 2017 Query Store, the new adaptive query processing features and how to incorporate Query Store queries into the new SQL Operation Studio for monitoring slow running queries and analyzing waits. You will learn how to use the Query Store to quickly find plan changes, analyze performance issues and find the waits which caused them. Both DBAs and developers can increase their performance tuning skills by attending this session.
Speaker(s):
- Janis Griffin
Track and Room: Enterprise Database Administration Deployment - 51-1103 (Features)
Title: Intro to Cloud ETL: Azure Data Factory V2
Abstract: Azure Data Factory (ADF) has long been a service that confused the masses. With pipelines, data sets, availability schedules, and JSON littering the code based environment it was no wonder the learning curve was steep. With the introduction of Azure Data Factory Version 2 that has all changed. The environment is simplified, scheduling is easily understood, pipelines are more straightforward, and there is more functionality now than ever before. Data Factory now feels like a true cloud-born ETL tool for everyone who is already familiar with SSIS. As a bonus, the lift-and-shift story has never been easier as SSIS packages can now be run natively in ADF.
In this session, Brad will walk through the major features including creating the environment, authoring your first pipeline, scheduling, monitoring, deploying SSIS packages, and interacting with on-prem data sets. At the end of this session, you will be ready to orchestrate data movement with Azure Data Factory like a pro!
Speaker(s):
- Bradley Schacht
Track and Room: BI Platform Architecture, Development Administration - 4-1706 (Warehousing)
Title: Intro to MPP Database with Azure SQL Data Warehouse
Abstract: When database servers slow down the options are generally to tune or scale up. Massively Parallel Processing, or MPP, databases offer an alternative: scale out. A traditional database engine uses a single processor and memory space to process queries while an MPP engine will divide and conquer by spreading the workload across multiple servers resulting in increased query performance. MPP databases don’t operate the exact same as a traditional database engine. In this session Brad will explore the similarities and difference of operating in an MPP environment, dive into distribution theory, discuss join and aggregation compatibility, and get you up to speed on all the basics of MPP theory. By the end of the session you’ll be well positioned to understand the design pattern differences, ETL considerations, and query basics of MPP databases.
Speaker(s):
- Bradley Schacht
Track and Room: Enterprise Database Administration Deployment - 51-1103 (Features)
Title: Advanced Power BI
Abstract: By now you have probably seen many Power BI demos and likely love what you see in the product. However, you may have noticed in most Power BI demos that they tend to show scenarios where everything just works right on the first try. So what do you do when your data is not perfect or your business problem is more complex? In this session, you will see what happens when you go beyond the basics and try to solve those difficult problems that you inevitably will run into when you’re back at work. This session will give you many tips on how to solve real-world problems with Power BI.
Speaker(s):
- Mitchell Pearson
Track and Room: Advanced Analysis Techniques - 4-1705 (Data Science / Visualization)
Title: Introduction to Wait Time Analysis for Performance Tuning
Abstract: Are you struggling with performance issues and your current tools are not providing answers? This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing wait time analysis. The speaker will use real-life case studies to show how quickly you can identify and fix the problems that are affecting your end user applications.
Speaker(s):
- Janis Griffin
Track and Room: Advanced Analysis Techniques - 51-1205 (Intro to DBA)
Title: #GetModern with Dell EMC
Abstract: Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged… we have you covered.
Speaker(s):
- Tristan Coles
Track and Room: Other - 51-1209 (Prof Dev)
Title: All the ways to break into data science and analytics
Abstract: In this session, we will explore all the various ways to pivot into the data science field. We will go over some common scenarios, and will inspect different pieces of advice found on the Internet.
Speaker(s):
- Taras Kaduk
Track and Room: Professional Development - 51-1101 (Dev)
Title: Azure Analytics In the Cloud
Abstract: WIll present a sample business intelligence/analytics application of cloud technologies such as Azure Sql Server Analysis Services, Power BI and Azure Machine Learning and how it all works together.
Speaker(s):
- Luigi Delfin
Track and Room: Analytics and Visualization - 4-1704 (Azure)
Title: Test and Verify Instances with DbaChecks
Abstract: Once you have systems out in the wild, how do you know that they are configured correctly, and that the backups you are taking are actually valid? DbaChecks is a new Community built PowerShell Module (from the makers of Dbatools) that is designed to test your SQL Servers for various best practices, and help you prevent having a disaster. It also comes with a cool feature to output results to a PowerBI report. Basic knowledge of PowerShell is encouraged, but not required for this session.
Speaker(s):
- Joshua Corrick
Track and Room: Enterprise Database Administration Deployment - 51-1102 (DBA)
Title: How to Keep Your Database Servers Out of the News
Abstract: Every few months the headlines are filled with news of yet another system outage inconveniencing customers and users. As data platform professionals, the systems and servers for which we are responsible generally form the foundation of our companies’ customer-facing applications. In this fast-paced session, we’ll discuss the differences between high availability and disaster recovery as well as the tools and technologies Microsoft provides us within SQL Server to keep our databases up, our users happy, and our DBAs well rested.
Speaker(s):
- Matt Gordon
Track and Room: Enterprise Database Administration Deployment - 51-1205 (Intro to DBA)
Title: Health Check your Sql Server like a Boss
Abstract: – analyse database Sql Server configuration: Degree of parallelism and Cost threshold of parallelism, TempDB, disks latency – analyse databases configuration – maintenance plans: what works best – index maintenance: rebuild or reorg – Statistics maintenance – new indexes? Duplicate Indexes? We got it – slow sprocs? slow queries? we will give them a new life
Speaker(s):
- Valentin Iamandi
Track and Room: Enterprise Database Administration Deployment - 51-1103 (Features)
Title: SQL Server Analysis Services for SQL Server DBAs
Abstract: This session is for SQL Server DBAs who support BI developers with SQL Server Analysis Services (SSAS) projects. Join this session to learn what SSAS is, how it stores data, and how/when it queries data from SQL Server. During a demo you will see examples of these queries and learn the extent of the control that BI developers have over the design of such queries. This gives you an overview of both Multidimensional and Tabular modes of SSAS as it relates to interacting with SQL Server.
Speaker(s):
- Shabnam Watson
Track and Room: BI Platform Architecture, Development Administration - 51-1102 (DBA)
Title: Introduction to SQL Server Clustering
Abstract: This session will provide an introductory into failover clustering of SQL Server, including when and why to cluster SQL. We will cover the required components and walk through how clustering works behind the scenes
Speaker(s):
- Chad Churchwell
Track and Room: BI Platform Architecture, Development Administration - 51-1102 (DBA)
Title: Pull and Push Json Data Files into AWS using SSIS
Abstract: Generate and stream Json Files into Amazon Web Services AWS Learn how to create Json objects and deliver them into an AWS secure bucket, also learn how to interact with a source bucket to pull files into your on premises file store servers.
Speaker(s):
- Jorge Novo
Track and Room: BI Information Delivery - 4-1706 (Warehousing)
Title: Introduction to Azure SQL Database
Abstract: What is this “Azure SQL Database” that I keep hearing about? In this session we will start from the beginning and answer the big questions around what it is, how you use it, how much does it cost, and most importantly why you would and should use it in your particular environment/situation.
Speaker(s):
- Joe Abbott
Track and Room: BI Platform Architecture, Development Administration - 4-1704 (Azure)
Title: Numbers Don’t Lie. Or Do They?
Abstract:
82.7% of all statistics are made up.
Don’t believe it?
Well, you shouldn’t.
Statistics and data visualizations are misused every day. Sometimes by mistake, but often enough - deliberately.
You already know not to believe everything you read, so now come and develop a critical look at statistics and data visualizations.
Learn the “tricks of the trade” and become a better consumer of graphs, charts, and infographics.
100% of people who liked this talk, said they liked it!
Speaker(s):
- Haim Shternshus
Track and Room: Analytics and Visualization - 4-1705 (Data Science / Visualization)
Title: Lessons Learned from Two Years as a Devops DBA
Abstract: Join me as I talk about lessons learned from two years on a Devops team. Process, source control, changes that block, rolling back changes, out of band changes, and more! I still don’t have all the answers (or maybe even all the questions), but I can say this - DBA’s have nothing to fear and a lot to gain when an org adopts a devops culture.
Speaker(s):
- Andy Warren
Track and Room: Enterprise Database Administration Deployment - 51-1205 (Intro to DBA)
Title: About those SQL data files…
Abstract: This session is a talk on data and transaction log files; performance and best practices. How many databases have you come across where SQL Server was installed with all the default settings and wonder why performance is poor? We will discuss the defaults that affects SQL data files and how they ruin database performance. We will look at best practices, things to watch out for, and undoing the damage.
Speaker(s):
- Steven Wheeler
Track and Room: Enterprise Database Administration Deployment - 51-1102 (DBA)
Title: Using R in Power BI: why, when and how
Abstract: In this session, we will touch on R as the language for data science, and then will dive right into how to use R within the Power BI environment, and why to use it in a first place.
Speaker(s):
- Taras Kaduk
Track and Room: Analytics and Visualization - 51-1101 (Dev)
Title: Anytime, Anywhere Data with Power BI Mobile Reporting
Abstract: Over the past few decades, mobile devices have become incredibly important to the way we communicate, play and do business. In 2017, the time spent per day on mobile devices has reach a new record high of 3 hours and 15 minutes per day. With this much time on-the-go, it’s necessary to have your data right there with you.
In this session, you will learn how to design Power BI reports optimized for mobile devices and learn the ins and outs of the Power BI mobile app.
Speaker(s):
- Devin Knight
Track and Room: BI Information Delivery - 4-1705 (Data Science / Visualization)
Title: Make your SSIS 2016 packages talk to each other
Abstract: This presentation will focus on how SSIS 2016 packages can communicate with each other and how you can create a sophisticated solution for your enterprise integration with maximum code reuse and flexibilty
Speaker(s):
- Victor Ivantsov
Track and Room: BI Platform Architecture, Development Administration - 4-1706 (Warehousing)
Title: Monitoring and Tuning Azure SQL Database
Abstract: Being able to monitor and tune the performance of your database is an important part of any database professional’s job. Azure introduces a host of new tools and capabilities designed to make optimizing your managed databases easier than ever. In this session, attendees will be introduced to using tools such as Query Performance Insights, Intelligent Insights, and Automatic Tuning to monitor and tune the performance of their Azure SQL Databases.
Speaker(s):
- Dustin Ryan
Track and Room: Enterprise Database Administration Deployment - 4-1704 (Azure)
Title: SSIS Troubleshooting, Error Handling, and Logging
Abstract: Encountering error messages in SSIS can be confusing and incredibly frustrating. Sometimes it’s difficult to determine what’s causing a problem and how to correct or avoid it if it happens again. As developers, we have a useful yet underrated set of tools to help us navigate many ETL pitfalls. In this session, Shawn will walk through a variety of tips and tricks to interpret errors during design time and demonstrate some common uses for event handling to help prevent problems after deployment.
Speaker(s):
- Shawn Harrison
Track and Room: BI Platform Architecture, Development Administration - 4-1706 (Warehousing)
Title: Introduction to Azure Machine Learning
Abstract: Introductory session on Azure machine learning, overview and practical demo.
Speaker(s):
- Sumit Vadodaria
Track and Room: Advanced Analysis Techniques - 4-1704 (Azure)
Title: Surviving Your Sql Developer Interview
Abstract: Going into an interview is always stressful. The best way to reduce that stress is to have an idea of how the technical, and personal, interview will be conducted. Jon has conducted 50+ sql developer interviews and been interviewed by over a dozen companies. He has seen some really good things, but there have also seen some real head scratchers. Come hear some tips that you can use on your next sql developer interview!
Speaker(s):
- Jonathon Moorman
Track and Room: Professional Development - 51-1209 (Prof Dev)
Title: Policies are not just for HR
Abstract: The use of SQL Server Policies can make a DBAs life much easier. Nearly anything you need to track can be monitored with policies. When something changes you will be notified. Save hours and hours of looking at configurations or building your own monitoring database. Set a policy and apply it all SQL Servers.
Speaker(s):
- Shawn Meyers
Track and Room: Enterprise Database Administration Deployment - 51-1102 (DBA)
Title: The future data professional - Hacking your growth!
Abstract: We are in a new industrial revolution. Data is the new innovation lever and companies are all seeking new ways to use it to catapult them forward. Incremental growth or improvement are no longer optional. The current needs of the business world are outpacing the technology expertise of most of its technical leadership. Learn how to rethink your own development and get the right capabilities for an amazing future in data! Leave with a roadmap for building out your modern personal development plan.
Speaker(s):
- Adam Jorgensen
Track and Room: Professional Development - 51-1209 (Prof Dev)
Title: SSIS: Loading Dimension Tables
Abstract: In this session we will look at what options are available to developers within SSIS to load and maintain our Dimension tables within the Data Warehouse. As well we will explore alternate design patterns that could improve performance
Speaker(s):
- Manuel Quintana
Track and Room: BI Platform Architecture, Development Administration - 51-1101 (Dev)
Title: Intro Into Index Analysis
Abstract: Indexing in SQL Server is both - art and science. It is also never-ending process. Database schema, queries and workload change overtime, making old indexing strategy obsolete and leaving you with inefficient or unused indexes.
In this session, Dmitri demonstrates several techniques that help you to perform index analysis in the system. You would learn how to detect unused and inefficient indexes, identify incorrect clustered indexes and choose the right candidates for consolidation and further index refactoring.
Speaker(s):
- Dmitri Korotkevitch
Track and Room: Enterprise Database Administration Deployment - 51-1205 (Intro to DBA)
Title: Populating a Data Warehouse with SSIS and Biml Patterns
Abstract: This session will demonstrate how to leverage Biml Patterns, along with SQL Server Metadata, to rapidly build SSIS packages. The focus of this session will be on populating a data warehouse, however the concepts presented could be applied to most any ETL/ETL scenarios. The components used during this session:
- Biml
- BimlExpress
- BimlSnap On-line are all available at no charge. In addition, attendees will receive:
- A complete ‘SQL Server Metadata Manager’ solution (front and back end)
- A fully functional SSIS Framework
Attend to see how Biml can revolutionize your SSIS development!
Speaker(s):
- Jim Miller
Track and Room: BI Platform Architecture, Development Administration - 4-1706 (Warehousing)
Title: SQL to NoSQL: Querying Azure Cosmos DB
Abstract: NoSQL, or “Not only SQL”, might be the greatest misnomer ever. This session will discuss NoSQL queries on Cosmos DB using the SQL API, server side scripts, and some of the pros and cons of using NoSQL over a traditional RDBMS.
Speaker(s):
- Jason Brugger
Track and Room: Application Database Development - 4-1704 (Azure)
Title: What’s New In SQL Server For The Developer
Abstract: This session covers the new functionality directly related to SQL Server developers in the last several releases of SQL server.
Speaker(s):
- Jeff Taylor
Track and Room: Application Database Development - 51-1205 (Intro to DBA)
Title: Creating Your Personal Brand Behind the Staffing Curtain
Abstract: Creating Your Personal Brand Behind the Staffing Curtain I will share my experience over the years in Staffing to provide some tips and tricks to help the community. I will discuss online presence, personal branding, selecting a staffing vendor, resume tips and tricks, nailing a technical interview, industry trends and anything else that may come up!
Speaker(s):
- Ben Cusson
Track and Room: Professional Development - 51-1209 (Prof Dev)
Title: Temporal Tables: Creation, Use, and Optimizing
Abstract: With SQL 2016, Microsoft introduced Temporal tables. In this session we will learn what a Temporal table is, and discuss uses in current environments. We will learn how to create the tables and optimize them for query performance allowing simplicity for the consumers of the data.
Speaker(s):
- Dale Sullenberger
Track and Room: Enterprise Database Administration Deployment - 51-1103 (Features)
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Steven Wheeler
Twitter: - swheelerSQL
LinkedIn: Steven Wheeler
Steven Wheeler is a Senior Database Administrator at Enterprise Integration, supporting internal and customer database environments. He has worked with different versions of SQL server going back over the past 10 years to SQL Server 2000. Steven has completed the MCSA SQL Server 2012/2014 and 2016 certifications. His IT experiences go back over 20 years to include Electronics repair, Microwave line-of-sight communications networking, LAN Administration, Server/Desktop support, and application support.
Jason Brugger
Twitter: - @bigdataangler
LinkedIn: Jason Brugger
Contact: https://jasonbrugger.wordpress.com
Jason Brugger is a solution architect with experience in both traditional BI technologies and big data analytics on Azure and the Microsoft stack. He recommends and develops data solutions on both mature and emerging technologies, holding MCSE certification in Data Management and Analytics, as well as MCSE: Business Intelligence and MCSE: Data Platform. He has been working with SQL Server and Microsoft technologies since 1995.
Bradley Schacht
Twitter: - http://twitter.com/bradleyschacht
LinkedIn: Bradley Schacht
Contact: http://bradleyschacht.com
Bradley Schacht is a Cloud Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including “SQL Server 2014 Professional Administration”. As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as SQLServerCentral.com and an active member of the Jacksonville SQL Server User Group (JSSUG).
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.
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.
Shabnam Watson
Twitter: - ShbWatson
LinkedIn: Shabnam Watson
Contact: https://shabnamwatson.wordpress.com/
Shabnam Watson is a Business Intelligence architect with 20 years of experience developing data warehouse and business intelligence solutions. Her work focus within the Microsoft BI Stack has been on Analysis Services and Power BI.
She is an active member of PASS community and has spoken at PASS Summit, SQLSaturdays, PASS Business Analytics and Women in Technology virtual chapters, and many other local user groups and conferences. She is one of the organizers of SQLSaturday Atlanta BI Edition.
She holds a master’s degree in computer science, a bachelor’s degree in Computer Engineering, and a Certified Business Intelligence Professional (CBIP) certification by The Data Warehouse Institute (TDWI).
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.
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.
Tristan Coles
Placeholder for speaker
Chad Churchwell
Twitter: - @chadchurchwell
LinkedIn: Chad Churchwell
Contact: http://www.sqlchad.com
Seasoned SQL Server DBA Professional with over 18 years IT experience with 15 years experience in databases. I have managed an enterprise DBA team and am currently in a strategic consulting role specializing in HA, DR, Replication, and Performance Tuning and Optimization. I am currently speaking at several SQLSaturday’s as well as local user group meetings.
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.
Matt Gordon
Twitter: - sqlatspeed
LinkedIn: Matt Gordon
Contact: http://www.sqlatspeed.com
Matt is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY PASS local group and a frequent domestic and international community speaker. He’s an IDERA ACE alumnus and 2020 Friend of Redgate. His original data professional role was as a database developer, which quickly evolved into query tuning work that further evolved into being a full-fledged DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes that real world experience as a data platform consultant helping clients design solutions that meet their ever-changing business needs.
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.
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.
Adam Jorgensen
Twitter: - wadamj
LinkedIn: Adam Jorgensen
Contact: http://www.pragmaticworks.com
As President of Pragmatic Works Consulting Adam drives market strategy, sales, partnerships, implementation and thought leadership. He has over 15 years of experience helping companies use their data to fuel their growth. Adam has been wowing audiences around the world for over a decade. He has delivered hundreds of sessions, published over a dozen books and hundreds of online videos and webinars on data and cloud topics. His passion is growing companies and mentoring leaders and companies to help them achieve their dreams.
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.
Bradley Schacht
Twitter: - http://twitter.com/bradleyschacht
LinkedIn: Bradley Schacht
Contact: http://bradleyschacht.com
Bradley Schacht is a Cloud Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including “SQL Server 2014 Professional Administration”. As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as SQLServerCentral.com and an active member of the Jacksonville SQL Server User Group (JSSUG).
Valentin Iamandi
Contact: http://logicalreads.wordpress.com/
Valentin brings more than 10 years of database experience in tuning, architecture, backup, large data transaction, and more. He has a solid background in database analysis and development and his skills cover SQL Server and Oracle as well as a slew of different operating systems. Valentin fluently speaks English, French, and Romanian. Valentin has a passion for performance and optimization and shares his experience on the topic in his blog http://logicalreads.wordpress.com/
Steve Schneider
LinkedIn: Steve Schneider
Contact: http://sqlinsight.net/blog/
Speaker Bio: Steve Schneider is a Business Intelligence developer for the City of Jacksonville (Florida), and has been embedded in SQL for over 20 years. He is a Microsoft Certified Systems Engineer and a Microsoft Certified Database Administrator. Along with his passion for SQL, he spends his time running half marathons and sailing. His current focus of interest is performance tuning, security, and cube building. He tries to maintain a constant sense of gratitude to God for the wonderful things he has been enabled to do.
Ben Cusson
LinkedIn: Ben Cusson
Contact: http://www.snitechnology.com/Blog
SNI Technology earned the Best of Staffing® Award for providing remarkable service quality. Fewer than 2% of all staffing agencies in the U.S. and Canada earned the 2015 Best of Staffing Award for service excellence. With satisfaction ratings more than three times higher than the industry average, the Best of Staffing winners truly stand out for exceeding expectations. This award identifies the staffing industry’s elite leaders in service quality.
Shawn Harrison
Twitter: - @ShawnBHarrison
Contact: http://www.thesqlgoth.com
Shawn Harrison is a BI Developer at Community Hospice and Palliative Care. He oversees the data warehouse and works within other levels of the MS BI stack. He also speaks at community events such as SQLSaturday, user group meetings.
Susan Schneider
LinkedIn: Susan Schneider
Contact: http://susansblog.sqlinsight.net/
Susan Schneider is a certified Microsoft Professional with a concentration in Database Fundamentals. She is a Data Engineer for MoneySolvers , a Tax Defense Network company, in Jacksonville, Florida. Her passion is data, with a focus on T-SQL, Power BI and SSRS. She started her own technical journey ten years ago at a SQLSaturday event; and she wants to give back to the technical community that helped and encouraged her along the way. She has spoken at various SQLSaturday and IT Pro Camp gatherings, and enjoys meeting people new to technology. When she’s not working, learning, or blogging; she enjoys traveling and sailing with her husband, Steve. You can find her on LinkedIn or follow her blog. Happy Learning!
Manuel Quintana
Twitter: - @SQLRican
LinkedIn: Manuel Quintana
Contact: https://sqlrican.wordpress.com/
Greetings. I have been an employee with Pragmatic Works for the past 4 years. I have supported our software products and now have joined our training team. Teaching topics such as Power BI, T-SQL, SSIS and the other main items for the microsoft BI stack. Business Intelligence is a passion of mine and I always love learning new things. My strongest areas of knowledge lay in SSIS as well as Power BI.
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.
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.
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.
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.
Sumit Vadodaria
LinkedIn: Sumit Vadodaria
Sumit has more than 10 years of experience in SQL Server and BI tools. Currently he works as a Senior Database Engineer with One call care management in Jacksonville-FL ,where he is leading the master data management project. Prior to that he worked for Autopoint , a automotive marketing company based in Jacksonville , where he designed and implemented SQL db solutions for their multi terabyte database.
Joe Abbott
Twitter: - GrumpyDataGuy
LinkedIn: Joe Abbott
Joe spent over 10 years working in the Property Casualty Actuarial field before moving over to consulting. Skilled in Azure Architecture, Data Engineering, Data Movement, and Reporting. Joe can effectively communicate with clients which he pairs with excellent detailed documentation. He is a strong consulting professional with a desire to work with clients and help them exceed their goals!
Jim Miller
LinkedIn: Jim Miller
Contact: https://https://www.bitracks.com/blog
Jim has worked in various facets of the IT business for over 30 years, with a primary focus on data warehousing, reporting and analytics, business intelligence, data modeling (relational, multi-dimensional), ETL frameworks, database architecture, as well as database performance tuning. In previous engagements, Jim has fulfilled roles as Data Architect, DBA, IT Director, and Senior Consultant. He also has experience in account management, marketing/technical support, and software application training. Jim has also had some extraordinary opportunities to lead IT organizations, with multinational participants, on reconstruction projects based in Bosnia and Iraq.
Dustin Ryan
Twitter: - https://twitter.com/SQLDusty
LinkedIn: Dustin Ryan
Contact: https://sqldusty.com
Dustin Ryan is a Data Platform Solution Architect at Microsoft. Dustin has worked in the business intelligence and data warehousing field since 2008, has spoken at community events such as SQLSaturday, SQL Rally, and PASS Summit, and has a wide range of experience using the Microsoft business intelligence stack of products across multiple industries. Prior to his time at Microsoft, Dustin worked as a business intelligence consultant for a Microsoft partner. Dustin resides outside Jacksonville, Florida with his wife, three children, two cats, two dogs and enjoys spending time with his family and serving at his local church. You can learn more about him at http://SQLDusty.com.
Haim Shternshus
Twitter: - @shushaim
LinkedIn: Haim Shternshus
Haim Shternshus is an Intelligence Analyst at the Citizens Property Insurance Special Investigation Unit (try to say that five times fast), and holds a Mechanical Engineering degree. He uses his engineering experience and analytics expertise to interact daily with endless rows of data, and find the stories within. Haim specializes in designing interactive dashboards that enable users to make smart, data-driven decisions in real time. He has been speaking and training throughout his career.
Dale Sullenberger
LinkedIn: Dale Sullenberger
Dale lives in Valrico, FL with his wife Connie and son Nathan, three dogs and two cats.
While there is some prior user level database experience, Dale has been working with SQL Server in some manner since 1997, and has been in a DBA role for 13 years.
Brad Raney
Twitter: - https://twitter.com/Brad_Raney
LinkedIn: Brad Raney
Contact: https://bradraneyblog.wordpress.com/
Brad Raney is a national speaker, international author, sales/leadership/management trainer, entrepreneur and has almost 30 years’ experience in creating and developing high performance teams in a variety of industries across the country.
Brad’s first book on how to find your perfect job has now sold on three continents and his latest book called Reach YOUR Peak:Become CEO of Your Success! is selling fast across the country in traditional and e-book formats.
Brad has spoken to almost 100,000 people and was part of the highly successful “Pink Slip Tour presented by Virgin Mobile,” that made stops in Miami, Orlando, Jacksonville, Atlanta, Minneapolis, and Detroit.
Brad has been on Advisory Boards for: • The University of North Flori
Devin Knight
Twitter: - @knight_devin
LinkedIn: Devin Knight
Contact: http://devinknightsql.com
Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. He is an author of seven SQL Server and Business Intelligence books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQLSaturdays and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG).
Joshua Corrick
Twitter: - @joshcorr
LinkedIn: Joshua Corrick
Contact: http://corrick.io/blog
Joshua is a Systems Engineer at the University of North Florida, and has been in this role for 2.5 years. Josh has many different hats on his team, but tends to be given the DBA responsibilities. He is also a passionate advocate for PowerShell and automation of any fashion. He is a husband and father of two boys. They have lived in Jacksonville FL since 2014.
Taras Kaduk
Twitter: - https://twitter.com/taraskaduk
LinkedIn: Taras Kaduk
I solve problems using data. Power BI, Tableau, and lots of R.
Taras Kaduk
Twitter: - https://twitter.com/taraskaduk
LinkedIn: Taras Kaduk
I solve problems using data. Power BI, Tableau, and lots of R.
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.
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.
Cindy Chapman
LinkedIn: Cindy Chapman
Cindy Chapman is a master presenter with over 20 years in training and instructional systems design for clients all over the US and in 54 countries. Fun, interactive and energetic – her sessions are always fast paced, engaging and interactive. Work4Accord is a Pennsylvania based organization offering a compliment of Human Resource solutions and training. Founded by Becky C. Stauffer, MPA, SPHR, SCP services include mediation, consulting and training.
Victor Ivantsov
Twitter: - @victorivantsov
Senior SQL Server developer with 20+ years of experience. I have enjoyed many SQLSaturday as participant, now is my time to contribute
Luigi Delfin
LinkedIn: Luigi Delfin
Luigi Delfin is a Business Intelligence and Analytics Engineer for One Call Care Management. Luigi has worked in financial, banking, marketing and healthcare sectors building business intelligence, analytics and BigData applications and solutions. Luigi is particularly interested in machine learning, data analytics, automation, business intelligence and other high-impact projects that assist companies with their performance, efficiency, quality, and profit.
Sponsors
The following is a list of sponsors that helped fund the event: