SQLSaturday #801 - Orlando 2018
Event Date: 10/06/2018 00:00:00
Event Location:
- Seminole State College of Florida
- 100 Weldon Blvd Building UP
- Sanford, Florida
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Applied Machine Learning with Python
Abstract: The Applied Machine Learning with Python session covers some basic concepts, tools and a workflow used to explore, visualize, develop a model to attain answers from data.
This is an introduction designed for those with minimal or no Machine Learning experience. It is also an applied session focused on getting answers from data, and it does not emphasize the Math behind the ML model. The examples use SQL Server 2017 Machine Learning Services (In-Database) integration with T-SQL, Python, Numpy, Scipy, Pandas, MatplotLib, Scikit-Learn (Machine Learning Library), MicrosoftML, Revoscalepy..
Most importantly, those examples are designed in a manner that are easy for you to understand and to spur your future exploration, by making it possible for you to replicate and use it to expand your knowledge.
Speaker(s):
- Adriano da Silva
Track and Room: Analytics and Visualization - 2104
Title: Azure Data Factory + SSIS: Migrating your ETLs to the Cloud.
Abstract: Thinking about migrating your data warehouse to the cloud? What about all those SSIS packages executing ETLs against your on-prem data sources? In this presentation we will discuss how to successfully “lift and shift” your ETL workloads to the Azure cloud. You will l learn how to configure and deploy an Integration Runtime, deploy and execute SSIS packages in an Azure Data Factory pipeline, and how to monitor and troubleshoot your ETL executions in the cloud. Attendees will walk-away with an understanding of the features, capabilities and limitations of Azure Data Factory and the Integration Runtime and a strategy to leverage your existing SSIS package development efforts to the cloud.
Speaker(s):
- Jose Chinchilla
Track and Room: BI Platform Architecture, Development Administration - 4105
Title: I know what you did last transaction: Auditing using CDC, Temporal Tables and Triggers
Abstract: Attendees of this session at SQLSaturday South Florida 2018 voted to recommend it for SQLSaturday Orlando! There have been more advancements in the topic of auditing SQL inserts, updates and deletes during the past few years than in the nearly 30-year history of SQL Server. Eric Berkowitz presents a fast-paced, live demonstration and comparison of Change Data Capture, the new SQL Temporal Tables and conventional trigger-based methods. Gain the ability to audit, research and report on data changes, without recoding existing applications and proactively plan for auditing in new systems. Understand the overhead and performance implications and storage and retention options for each approach. See how querying, DDL changes and compatibility considerations vary among the methods so you can make informed decisions about implementing auditing in your system.
Speaker(s):
- Eric Berkowitz
Track and Room: Enterprise Database Administration Deployment - 3102
Title: Hack / Protect / Predict SQL Server - Come learn them.
Abstract: In this session, I’ll show you how to hack SQL Server using a simple C# console application and other tools. Most importantly, I’ll show you how to protect vectors that perhaps you’re trying to use to safeguard sensitive data for GDPR compliance.
- Tabular Data Stream (TDS) Protocol
- Dynamic Data Masking
- Row Level Security (Yep…)
- Database Source Control
Perhaps, you’ve seen these exploits before but do you really know how to reproduce them? Or, how to even protect yourself against them? No worries, I’ll show you the way along with a load test.
Finally, I am very excited to share with you how to analyze text using pre-trained Machine Learning models to predict a sentiment, on-prem with SQL Server 2017.
- SQL ML / AI - A deep dive to predict the sentiment
Looking forward to meeting you all.
Speaker(s):
- Hiram Fleitas
Track and Room: Application Database Development - 2103
Title: Tame Your Unruly Data With Constraints
Abstract: Bad data comes in many forms: duplicate rows, wrong data type, invalid values, and orphaned or missing foreign keys. Time is wasted cleansing, reviewing and correcting data, not to mention the potential hazards bad data can cause. This introductory presentation will explain the data types and constraints available in SQL Server, and how they can replace or augment business rules that would otherwise be written in application or procedure code. Performance benefits provided by constraints will be demonstrated. We will examine the various system views and procedures that describe constraints and how to use them to document your databases. You will be able to apply this knowledge to your database environments and see significant improvements in data quality, performance, and reliability.
Speaker(s):
- Rob Volk
Track and Room: Application Database Development - 1206
Title: Supercharge Your Maintenance Plans..the Ola Way!!
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 - 2103
Title: Everything You Need to Know About SQL Server Indexes
Abstract: You probably already know that indexes make your queries go faster. But do you know all the different types of indexes in SQL Server and when to use them? Also with each new release of SQL Server, there are new features that can impact how indexes function and are maintained. Finally, knowing how the different types of indexes work can help you make better indexing choices when tuning your queries. This presentation will review current SQL Server index structures and options, discuss how they work, when they should be used and how to maintain them. Examples of all the index types such as hash, in-memory, columnstore, filtered, etc… will be shown. This presentation is a must see for DBAs, Developers, Application Architects and anyone else who is interesting in maintaining high performance SQL Server applications.
Speaker(s):
- Janis Griffin
Track and Room: Enterprise Database Administration Deployment - 1206
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 - 1206
Title: Deciding to keep your BI Data Platform On-Premises
Abstract: The world is going to the cloud and there is plenty of good reason for it, but NOT every IT workload should go to the cloud and your BI is no different. Maybe you aren’t ready, maybe your organization feels fully invested in your current On-Prem infrastructure. Maybe there is some fear of the unknown.
The speaker will tackle these challenges and help you, the attendee, understand how and when to decide to stay On-Premises or move to a Cloud or a Hybrid solution. As an attendee, you should have the information to comfortably determine what is right for your organization today, and have a plan for the future.
Attendees will understand what On-Premises benefits are available exclusively to them Attendees will understand where Cloud and Hybrid solutions complement their existing deployments Attendees will be in a better position to explore moving beyond their On-Premises deployment
Speaker(s):
- Trey Johnson
Track and Room: BI Platform Architecture, Development Administration - 3103
Title: HA/DR Solutions Using Distributed Availability Groups
Abstract: When designing your HA/DR solution, you need to consider all the possible options SQL Server has to offer to implement what is right for you. You will see how to use Failover Cluster Instances, Standalone Instances, Clusters, Availability Groups and Distributed Availability Groups.
We will walk through how to set up and configure an HA/DR solution from beginning to end, review possible alerts, and how to monitor. We will take a look at the new SQL2017 Read-scale Availability Groups and why to use them. We will architect one of many possible VM solutions to host your HA/DR implementation.
Finally, we will see Automatic Failover and see how to perform a Manual Failover.
Speaker(s):
- Jennifer Brocato
Track and Room: Strategy and Architecture - 2103
Title: Dell: #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):
- Dominick DeQuarto
Track and Room: Strategy and Architecture - 3103
Title: Python and R Integration with SQL Server 2017
Abstract: If you are looking to expand your DBA or developer skills, statistics with Python or R integrated with SQL Server 2017 might be a path worth examining. This session will go through the installation of these options with SQL Server 2017. Then, we will configure the scripting Stored Procedures. Finally, the session will conclude with statistical graphs and analysis with both R and Python.
The role as a DBA is expanding, and even though you might not be a Data Scientist, you can still use the new features of SQL Server 2017 to do an analysis of performance monitoring data to enhance the predictability of proactive analysis on your current systems.
Speaker(s):
- Thomas LeBlanc
Track and Room: Analytics and Visualization - 4105
Title: Twitter Data Sentiment Analysis: Staring Logic Apps, Azure ML, Twitter Data, Power BI, and Python
Abstract: A year ago we went to Spider-man: Homecoming. On the way home I thought “I wonder what the rest of the world thinks of this movie? I wonder what people on Twitter are saying? I wonder if this is that tied to box office performance?” Over the last six months we’ve been building data sets on movies and collecting sentiment analysis of Twitter data. This lead to a journey of data discovery. First to figure out how to capture and analyze social media data from Twitter. Next we needed box office information. After that we wanted to capture sentiment. Then we wanted stock market data. Then we wanted movie information, runtime, rating, Metacritic score, IMDB score, and then how do we get historical data if we want to increase our data set? Once you collect the data how do you store it? How do you display it? All this and more….. but probably just this….because that’s a lot.
Speaker(s):
- Bradley Ball
Track and Room: Analytics and Visualization - 1206
Title: The Changing Role of CIOs and the Value of DevOps
Abstract: DevOps practices are a powerful tools to build productive, engaged teams who constantly learn and regularly deliver value to their customers. High DevOps performers report greater workplace satisfaction than their peers. But implementing DevOps isn’t a matter of being great at writing code, or choosing the right technologies: to become a high DevOps performer, you need the powerful catalyst of executive support. In this talk, we will discuss the value of DevOps from the perspectives of CEOs, CIOs/CTOs, and Managers. We will explore how the role of CIOs and CTOs are undergoing a major transformation, and how DevOps aligns with that transformation. You will leave the session with a fresh take on how to discuss DevOps with company leaders, and an understanding of how to explain the value of DevOps to people in these roles.
Speaker(s):
- Kendra Little
Track and Room: Strategy and Architecture - 4105
Title: Azure Analytics In the Cloud
Abstract: WIll present a sample business intelligence/analytics application using 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 - 3103
Title: Introduction to Azure Functions using Azure SQL Databases
Abstract: In this session you will learn about Azure Functions and how to build a simple HTTP proxy that returns data from an Azure SQL Database, built entirely in the cloud. We will review configuration settings, how to securely store your connection strings, how to implement logging, how to implement retry logic and how to troubleshoot your Azure Functions. The demos will be done entirely in the cloud, without using Visual Studio.
Speaker(s):
- Herve Roggero
Track and Room: Cloud Application Development Deployment - R3
Title: Thinking in SQL
Abstract: SQL is conceptually different than most programming languages. Join us for a conversation about SQL, why it’s different from traditional procedural languages, and how to effectively use this truly elegant programming language. Rather than focus on the kinds of information easily located on the Web, we’ll concentrate on how to use SQL for the tasks that it’s really good at. Beginners will get a great introduction to the style of thought that gets the most out of SQL. Experienced developers will find a good refresher and an opportunity to share their experiences with others.
Speaker(s):
- Robert Hatton
Track and Room: Application Database Development - 3102
Title: How To Setup Continuous Integration Continuous Delivery Step By Step For Your Website Database
Abstract: This session will cover how to setup your database source code in a source code repository, configure your website application, configure continuous integration and continuous deployments of your database alongside your application using Visual Studio Online, Red Gate DLM SQL CI, and Octopus Deploy.
Speaker(s):
- Jeff Taylor
Track and Room: Other - 3102
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 - 4105
Title: Rubrik-Simplifying SQL Data Protection
Abstract: When you think about backups in your environment, how many servers scripts do you have to manage? Or have you ever needed to get a table back from a large database and didn’t want to argue with the storage admins about space for the restore? With Rubrik, we empower you to backup and restore your databases quickly and with ease. Come see how you can quickly protect hundreds of databases with just a few clicks or bring back a database in minutes to satisfy your most demanding executives. With Rubrik, it’s not about backing up, it’s about going forward!
Speaker(s):
- Chris Lumnah
Track and Room: Strategy and Architecture - 2103
Title: Solution development for a query tool for a large Dataset
Abstract: Research and discussion regarding multiple attempts to devise a solution to provide a parameterized query tool that pulls against a 14MM record externally managed database. This session will delve into the trails and tribulations experienced while attempting to resolve real world problems in order to provide a business solution. Experience the thrills of each different solution attempt and the difficulties presented in a real business environment.
Speaker(s):
- Andrew Bozek
Track and Room: BI Information Delivery - 2104
Title: Introduction to IoT using Azure
Abstract: Ever wondered on what is the buzz about Internet of Things (IoT)? and interested in making your own? We will take an look on what is Internet of Things (IoT), the impact of IoT to the world, industries that IoT can disrupt and then, we will provide an overview of building an IoT solutions using various technologies in Azure such as IoT Hub, Functions, Stream Analytics, Power BI, and more.
Speaker(s):
- John Wang
Track and Room: Strategy and Architecture - 2103
Title: Performance tuning with SQLGrease
Abstract: Performance tuning a production system can be a difficult process when only relying on out of the box tools. This is even more difficult if you aren’t on the most recent release of SQL Server. In this presentation I will show you some common performance problems and how SQLGrease can help tune these. Along the way I will provide details on how SQLGrease collects its data in order to give some clarity on how we monitor as well as provide some useful queries you can use even if you aren’t a SQLGrease user.
Speaker(s):
- franklin yamamoto
Track and Room: Enterprise Database Administration Deployment - 3102
Title: Tally Ho! – Explore the Varied Uses of Tally Tables
Abstract: Because SQL Server is designed to efficiently operate with set-based queries it does not perform as well with loops and cursors. However there are situations where you really need some type of a loop. Tally tables give you the best of both worlds by allowing you to effectively “loop” through records in a set-based manner. We’ll explore what tally tables are, how they work, and more importantly review some of the many ways you can use them to turn your loops and cursors into efficient set-based operations.
Speaker(s):
- Aaron Cutshall
Track and Room: Application Database Development - 2105
Title: Performance Tuning Magic
Abstract: When your server becomes unresponsive, the performance goes down the drain and the CPUs are at 100%. You asks yourself: I wish I knew what and how to do it. – How to configure your Sql Server for maximum performance – Big databases issues and solutions – Indexes or Statistics updates, what and where: Rebuild or Reorg – Sql code tricks to increase code performance – What to do when in maximum performance pain
Speaker(s):
- Valentin Iamandi
Track and Room: Enterprise Database Administration Deployment - 3103
Title: Azure Resource Management with PowerShell
Abstract: You’re company is transitioning to the Cloud. Initially, your Azure deployment was small and could be managed primarily via the Azure portal but now it spans the globe with implementations in several countries. You have too many resources to manage with the Azure portal alone. You can automate these tasks with PowerShell without being a PowerShell expert. I’m Ronald Dameron. I’m responsible for managing the resources of twelve Azure subscriptions containing hundreds of resources. I can show you how. I’ve done it.
Speaker(s):
- Ronald Dameron
Track and Room: Cloud Application Development Deployment - 3102
Title: Encryption, Encryption, Encryption! Protect your data at the right level
Abstract: More and more regulatory requirements are coming out around having your data encrypted. Many DBAs are struggling to know where to encrypt and the impact to performance encryption causes at each level. We will walk through the basics of all encryption options for SQL Server workloads including TDE, Always Encrypted, database and column level encryption, encrypted connections, storage encryption, certificates, key management and much, much, much more!!!
Speaker(s):
- Shawn Meyers
Track and Room: Enterprise Database Administration Deployment - 2104
Title: Will my workload run faster with In-Memory OLTP?
Abstract: There are compelling reasons to consider deploying In-Memory OLTP, vastly improved in SQL 2016 and SQL 2017, and now running on all editions.
What are the use cases?
What are the tradeoffs?
We will lift the veil of confusion that surrounds this blazingly fast feature. By the end of the session, you will understand how In-Memory OLTP works and whether your workload is likely to see an increase in performance.
Speaker(s):
- Ned Otter
Track and Room: Strategy and Architecture - 3103
Title: Exporting and Synchronizing Data From SharePoint, Twitter and SalesForce into Azure SQL Database
Abstract: In this session we will review how to leverage Enzo Data Pipelines to export and synchronize data from hosted data sources (SharePoint Online, Twitter and SalesForce) into a relational database in the cloud for software integration and reporting. As part of this presentation you will see how you can implement a Change Data Capture (CDC) architecture on top of SharePoint Online, Twitter and SalesForce, allowing you to trigger actions when source data changes in those systems.
Speaker(s):
- Herve Roggero
Track and Room: BI Information Delivery - 2104
Title: SQL Server Development on Your Platform Of Choice with Containers
Abstract: SQL 2017’s built in support for Docker containers enables new development capabilities without requiring a Windows OS. In this session you’ll learn about why you should care about containers (even if you are running Windows), what you can - and can’t - do with containers, the basics of how to work with Docker to create and manage your own containers, and how Microsoft’s new cross platform tools enable you to work with SQL Server on Windows, macOS, and Linux. After this session you’ll have all the information you need to start using Docker on your platform of choice!
Speaker(s):
- Kendal Van Dyke
Track and Room: Application Database Development - 2105
Title: Azure Data Store Options
Abstract: In this session we will investigate the various data storage options that are presented for developers in the Microsoft Azure Cloud. We will look at the various storage options for both strongly and loosely bound schema. Topics will include table storage, Azure Search, CosmosDb, Azure Sql Database, and Azure Data Lake Analytics. We will also cover data movement options and security before doing a deeper dive into Azure Sql Database.
Speaker(s):
- Jonathon Moorman
Track and Room: Cloud Application Development Deployment - 2105
Title: Information Governance: Understanding the Risks and Developing Solutions around Unstructured data
Abstract: Organizations are faces with information overload from employee generated unstructured data in the form of emails and electronic documents. With no idea of the content that exists within these documents or the locations with more and more options being provided for storage of documents, Organizations are having to come to terms with the liabilities, overhead and management of these resources. This session looks at the issues of dark data within an organization and methods to understand and combat it.
Speaker(s):
- Greg Smith
Track and Room: Other - 2105
Title: SQL Execution Plans Demystified
Abstract: Discussion on how SQL Server performs the tasks asked of it by the user. Topics will include statistics, indexes, and the Query Optimizer, including operators detailed in the execution plan and what they mean.
We will also go over some demonstrations as well as commonly seen performance killers and how to quickly and easily identify them.
Speaker(s):
- Ernest Libertucci
Track and Room: Application Database Development - 4105
Title: ETL automation using BIML
Abstract: in this session, We will go over different design patterns to perform ETL using ssis and biml.
Speaker(s):
- Sarju Patel
Track and Room: BI Platform Architecture, Development Administration - 2105
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, query the data from the tables for different scenarios, and optimize them for query performance allowing simplicity for the consumers of the data.
Speaker(s):
- Dale Sullenberger
Track and Room: Application Database Development - 2104
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 (SQLOps) 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 - 1206
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Greg Smith
Twitter: - https://twitter.com/emazzanti
LinkedIn: Greg Smith
Contact: https://www.emazzanti.net/news/
Mr Smith has been involved in the high technology field for over 35 years, working independently and with various system integrators to provide comprehensive solutions to midsize and large customers. This has included deployment of enterprise standards based messaging systems, Novell, Microsoft and Cisco infrastructures. Recently his experience has centered around unstructured data, the collection, discovery and exploration of these data sources for compliance, regulatory evaluations around HIPPA, PCI and PHI as well as legal liability and eDiscovery purposes. He has spoken at various events in US, Canada and Europe.
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.
Jose Chinchilla
Twitter: - SQLJoe
LinkedIn: Jose Chinchilla
Contact: http://www.sqljoe.com
Jose Chinchilla is an experienced data analytics professional with multiple certifications including Microsoft Certified Database Administration (MCSE), Microsoft Certified Data Management and Analytics (MCSE), and Microsoft Certified Trainer (MCT). Jose specializes in Data Warehouse and Data Lake Architecture and Development as the Data Analytics Practice Lead at AgileThought, a full-service custom software and analytics consulting firm based in Tampa, FL. Jose is a book author (SQL 2012 Bible, Professional SQL Server 2012 Administration, Exam Ref 70-767 Implementing a SQL Data Warehouse 2016) and leads the Tampa Bay BI Data Analytics PASS Chapter in Tampa, FL.
Andrew Bozek
LinkedIn: Andrew Bozek
I currently develop Business Intelligence solutions using primarily TSQL, VBA, SSIS, and Sharepoint. I provide Project Management to ensure appropriate accountability to deliverables and tasks. I oversee Business Analyst coordination for requirements and documentation, I rapidly deploy Developing/coding/designing, I also provide QA and testing for functionality, efficiency and effectiveness. Lastly, I also provide support and maintenance for current items as well as legacy reporting and tools.
Eric Berkowitz
LinkedIn: Eric Berkowitz
Eric Berkowitz has been AlwaysOn with SQL Server since becoming certified by Sybase over 25 years ago, before SQL Server ran on Windows servers. In that time he’s participated in every aspect of designing, developing and optimizing SQL-centric systems of all kinds and has been an executive in corporate IT operations. For the past several years he has been an independent consultant through his company Berkflow, Inc., consulting for companies from coast to coast with SQL system implementation, administration, integration and reporting. Eric is also a SharePoint expert specializing in integration of SharePoint with other enterprise data, Designer and Nintex workflows, custom forms, reporting, and overseeing teams developing custom solutions.
franklin yamamoto
Twitter: - @sqlgrease
LinkedIn: franklin yamamoto
Contact: http://blog.sqlgrease.com
Franklin has spent a majority of his career working as a performance tuning consultant. While working as a consultant he saw a need for a subscription based performance monitoring solution that could live in the cloud. After four years of development this became SQLGrease. Franklin now heads SQLGrease as CEO and chief technologist. His goal is to build software capable of replacing himself so he could spend more time sailing.
Herve Roggero
Twitter: - @hroggero
LinkedIn: Herve Roggero
Contact: http://www.herveroggero.com
Strategist. Catalyst. Storyteller. Herve Roggero is recognized for his thought leadership and passion for providing accessibility to data in the tech space. Herve’s knack for distilling complex real-time data consumption challenges and presenting digestible solutions make him the ideal speaker, teacher, and teammate.
His leadership skills and passion of Microsoft Azure are a testament to his commitment to ultimately increasing operational efficiency - so much so that Herve has been an Microsoft Azure MVP for over 7 years.
Herve is the Co-Author of PRO SQL Azure, PRO Windows Azure SQL Database and PRO SQL Server 2012 Practices (from APress), a PluralSight author, and runs the Azure Florida Association.
Jennifer Brocato
LinkedIn: Jennifer Brocato
Microsoft Certified in SQL Server. Leads a groups of DBAs providing support of operations and implementing the latest SQL technologies. 25+ years experience in enterprise development and passionate about SQL Server. When I am not engrossed in SQL Server, I am judging USA Gymnastics in Maryland.
Kendra Little
Twitter: - Kendra_Little
LinkedIn: Kendra Little
Contact: http://littlekendra.com
Kendra Little is a Microsoft Certified Master and a Microsoft MVP. Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to become a database administrator for performance critical databases at Microsoft Corporation. Since then, Kendra has worked internationally as a teacher and consultant, and founded the training site SQL Workbooks. She joined Redgate as a Product Evangelist in 2018.
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
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/
Ned Otter
Twitter: - @NedOtter
LinkedIn: Ned Otter
Contact: http://www.nedotter.com
DBA with vast experience administering Microsoft SQL Server since version 4.21 to the present.
Certifications:
MCSE SQL Server 2012 Data Platform
MCTS SQL Server 2008
Overall computer experience: 25 years
SQL Server experience: 23 years
Currently obsessed with In-Memory technology.
Please see LinkedIn profile for more details.
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.
Trey Johnson
Twitter: - https://twitter.com/treyjohnson
LinkedIn: Trey Johnson
Contact: https://www.zapbi.com/blog/
A veteran of the SQL Server Business Intelligence community, Trey Johnson has been a senior board member of PASS, a global speaker and author and was an influencer for several years on Microsoft’s Business Intelligence Partner Advisory Council. Today, Johnson is the Chief Evangelist, a senior leader and technologist with ZAP, focused on bringing immense value from ZAP’s Data Hub and the Microsoft SQL Server, Analysis Services and Azure platform.
Johnson enjoys communicating about his experiences over 25 years with the intersection of analytics, SQL and BI.
Kendal Van Dyke
Twitter: - SQLDBA
LinkedIn: Kendal Van Dyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
Herve Roggero
Twitter: - @hroggero
LinkedIn: Herve Roggero
Contact: http://www.herveroggero.com
Strategist. Catalyst. Storyteller. Herve Roggero is recognized for his thought leadership and passion for providing accessibility to data in the tech space. Herve’s knack for distilling complex real-time data consumption challenges and presenting digestible solutions make him the ideal speaker, teacher, and teammate.
His leadership skills and passion of Microsoft Azure are a testament to his commitment to ultimately increasing operational efficiency - so much so that Herve has been an Microsoft Azure MVP for over 7 years.
Herve is the Co-Author of PRO SQL Azure, PRO Windows Azure SQL Database and PRO SQL Server 2012 Practices (from APress), a PluralSight author, and runs the Azure Florida Association.
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
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.
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.
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.
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.
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.
Ernest Libertucci
Twitter: - @elibertucci
LinkedIn: Ernest Libertucci
I have worked with SQL Server since October, 2000, including versions 2000 - 2017. SSIS, SSRS, performance tuning, and all the little things DBAs do. My background in college was Computer Science and Software Engineering. Currently, I am a Sr DBA/Engineer for SQL Server who also administers and develops on our Hadoop platform.
Aaron Cutshall
Twitter: - sqlrv
LinkedIn: Aaron Cutshall
Contact: http://sqlrv.com
Aaron N. Cutshall is an Enterprise Data Architect with 20 years of experience in analysis, design and development for applications and databases in manufacturing and warehousing plus over 15 years in the Healthcare Informatics field. His primary focus is in designing and developing solutions for extremely large data sets that perform quite well in SQL Server. He is active in the SQL Server community and speaks at SQLSaturday sessions across the country.
Dominick DeQuarto
LinkedIn: Dominick DeQuarto
32 year veteran in the IT industry. Providing education and guidance on how the IT industry is transforming and what it means for a company’s current business and future state. Discussions around the “as a service” model and the journey to the hybrid cloud. How all this ties into the most important asset any company can have - their data. Evangelizing the importance of Hybrid Cloud Management, Data Protection and Data Management across federations.
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.
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.
Hiram Fleitas
Twitter: - @hiramfleitas
LinkedIn: Hiram Fleitas
Contact: http://fleitasarts.com
Hiram Fleitas develops and manages database applications and AI bots using Machine Learning models trained on natural language, claims, policy, and social media data to predict business opportunities that grow customer satisfaction and loyalty in real-time.
He’s worked with SQL Server for over 20 years, with some of the largest companies in the world. He’s spoken on SQL Server, Azure and Power BI at User Groups, Code Camps, SQLSaturdays, and corporate events. He coded his first program in BASIC at 13 years old and developed a passion for computers ever since.
Hiram is also a code contributor to several open source projects and serves as the IS Flotilla Staff Officer for the United States Coast Guard Auxiliary.
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.
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.
Adriano da Silva
Twitter: - AdasilvaTek
LinkedIn: Adriano da Silva
Adriano da Silva is a Lead Power BI Trainer at Intellinsight LLC and a Principal Consultant at Bright International Corporation a consulting company focused in addressing complex business problems with innovative, effective and robust Solutions in the BI, AI, Big Data, Machine Learning Power BI. He is has years of experience in partnering with businesses leaders to advise and implement technical and process oriented solutions. He is engaged in knowledge sharing initiatives by presenting on conferences, user groups and authoring articles. He is also a lead organizer at the South Florida Power BI (SFPBI) and the Microsoft Data and AI South Florida user groups..
Chris Lumnah
Twitter: - @lumnah
LinkedIn: Chris Lumnah
Chris Lumnah began working in the IT as a programmer in 1996. He ended up becoming a SQL DBA out of necessity 15 years ago. He has worked on SQL Server version 2000 thru 2017. He likes to continue to use his knowledge of programming to create more automated solutions to assist him and his team to be more proactive. Chris lives in Providence, RI and is currently a SQL Server Solutions Architect at Rubrik Inc.
Robert Hatton
LinkedIn: Robert Hatton
Contact: http://www.RobertJHatton.com
Rob Hatton is the author of the Business Intelligence Team Handbook.
Rob is also a past president of the PASS Business Intelligence User Group here in Tampa. He is a veteran B.I. developer with more than 30 years of database experience and dozens of successful B.I. project deployments.
John Wang
John Wang is a Back-end .NET Developer. Currently, his interests are IoT, big compute, services, cloud computing, Powershell and SQL topics. He is an frequent speaker at the various Code Camp, Meetup, IT Pro Camp and SQLSaturday.
Sarju Patel
LinkedIn: Sarju Patel
Sarju Patel is Lead Software Developer at One Call Care Management. Experienced BI Developer with a demonstrated history of working in Azure Sql, SSIS, BIML and Data Warehouse design.
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.
Sponsors
The following is a list of sponsors that helped fund the event: