SQLSaturday #755 - South Florida 2018

Event Date: 06/09/2018 00:00:00

Event Location:

Nova Southeastern University
3301 College Ave
Davie, Florida

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques

Abstract: When done right, data visualization informs users quickly and efficiently with a minimum of distraction. When done wrong, we end up with spinning 3D pie charts. In this talk, we will look at techniques for effective dashboard design, minimizing noise and clutter (like spinning 3D pie charts) while providing relevant information to the intended audience. We will see how different types of charts work, build out rules of thumb around which charts to use, and integrate visuals to create a coherent dashboard image. When it comes to dashboards, we will compare and contrast dashboards based on their intended uses, such as interactive dashboards versus TV dashboards. Finally, we will take an awful dashboard and turn it into something which end users will appreciate.

Speaker(s):

Kevin Feasel

Track and Room: Analytics and Visualization - 3047

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 - 3045

Title: Getting started with SQL Azure Database: What you need to know

Abstract: Azure SQL Database offers a way to quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore. In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.

Speaker(s):

Jim Donahoe

Track and Room: Cloud Application Development Deployment - 1053

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: DBA Advanced - 3046

Title: Patterns for Managing Your Career Learning Needs

Abstract: Most of us want to “keep up” with changes in the technologies we use and most of us feel like we’re failing to do so. Can that be right? Is it possible to learn what what we need to learn in order to stay current and still have time for a life outside of work? It is!

This presentation is about patterns you can apply to how and when you learn. My goal is to give you the ideas and techniques that will help you learn effectively and do so for your entire career - something you can use for 40 years!

Attendees - bring your lists. Bring the list of stuff of you want to learn or think you should learn. Take a few minutes to write down the challenges you’ve had in ‘keeping up’. We’ll discuss some during the session and I’ll be available afterward for one on one conversations for the rest!

Speaker(s):

Andy Warren

Track and Room: Professional Development - 3045

Title: Blockchain - A Database Architecture Paradigm Shift

Abstract: Joe takes you on an easy to understand journey of Blockchain technology. Blockchain is the basis of Cryptocurrencies such as Ethereum, Bitcoin etc., however, extends way beyond these as a framework for Smart Contracts.

To better understand developer Blockchain opportunities, Joe deploys an Ethereum simulated multi-member network in Azure, consisting of a set of load-balanced transaction nodes with which an application or user can interact to submit transactions and a set of mining nodes to record transactions.

Joe will also investigate new toolsets coming out to assist in Blockchain Development including CoCo Framework, App Builder and Enterprise Smart Contracts.

Speaker(s):

Joe Homnick

Track and Room: DBA Beginners - 1048

Title: Quick and Dirty Push Datasets with Power BI

Abstract: Using Power BI, you can connect to hundreds of different data sources. Once you have published your data to the Power BI service, you can use an on-premises gateway to refresh your datasets up to every 15 minutes. Power BI can also connect live to large cubes that are a result of very complex ETL and calculations. Some of these cubes may only be refreshed daily or weekly. For real-time streaming of data, you can use Azure Stream Analytics or the Power BI REST API.

Have you heard of Power BI push datasets? With push datasets, data is pushed into the Power BI service. Since it is stored there, you can use all of Power BI’s report building features with it.

In this session, I walk through the different options for real-time streaming in Power BI. I will demonstrate setting up a push dataset and show you a very easy way to push data to Power BI using PowerShell. I will also demonstrate a Power BI push dataset connected to a Microsoft Cognitive Services Computer Vision app.

Speaker(s):

Gary Lock

Track and Room: Analytics and Visualization - 3047

Title: I know what you did last transaction: Auditing using CDC, Temporal Tables and Triggers

Abstract: 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: DevOps - 3044

Title: So You think You can Speak?

Abstract: If you’ve ever enjoyed or admired the knowledge and know-how of a speaker at a SQLSaturday or a Summit , remember that they started where you are, with an interest in SQL and I.T. topics, a passion to learn more, but also with the desire to share what they know with their peers. If you have an interest in SQL or any of the Microsoft Data platform technologies, and have learned something useful in your I.T. career, consider giving back to the community by sharing what you know. While it may seem intimidating to give an hour long talk at an event like this, remember that every great speaker had to start somewhere. And for you, maybe that start is here! “Do You Think You can Speak” is a friendly competition for anyone, even first time speakers, to share for 5 - 10 minutes on a technical topic, SQL, Business Intelligence, Power BI, or otherwise, that is informative, useful, and entertaining.

Speaker(s):

Diana Betancourt

Track and Room: Professional Development - 1053

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: DevOps - 1053

Title: For Love or Money, Your Tech Career

Abstract: Contracting at the cutting edge of technology is exciting and produces great rates. But what happens when the contract ends and the mortgage payments must continue?

Maintaining a steady job with biweekly direct deposit salary is comforting. But do you ever feel technologically “stuck” at your job when so many other technology professionals are using the latest, most marketable technologies?

In this highly interactive group session, you will learn multiple career strategies for maximizing both the Love and the Money of your multidimensional technology career.

Speaker(s):

Alex Funkhouser

Track and Room: Professional Development - 3045

Title: Data Science, and the changing Role of Data professionals; Data-Information-Knowledge and Wisdom

Abstract: Data Science techniques are becoming popular and because statistics usually teaches at the Math Department people think of it as an exact science but Statistic is the science of prediction and expectations. In the excitement of the possibilities that Big Data technology and Data Science techniques are opening, we are forgetting that correlation is not equal than causation and that any design model has intrinsic limitations. Dr. Deming said “In God we trust, all others must bring data.” but what he really wanted to reach was Wisdom! Data is just the raw material the real goal is Wisdom I have been thinking about the chain toward Wisdom (Data-Information-Knowledge-Wisdom) and wonder how many organizations have reached, at least, the level of Knowledge and if any at all have reached the pinnacle of Wisdom. We are drowning in a sea of data and we are starving for wisdom. How is Data Science and Big Data changing our profession? What is a Data Scientist? Which skills do we need?

Speaker(s):

Frank Quintana

Track and Room: Professional Development - 3045

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 leverage the Python programming language integration with SQL Server 2017 Machine Learning Services (In-Database).

Most importantly, those examples are designed in a manner that are easy 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: Data Science - 3033

Title: Data Science: Supervised and Unsupervised machine learning

Abstract: Continuation of previous year track from basic concepts of Conditional Probability Regression to supervised and unsupervised machine learning techniques.

In this session, we will look at various supervised ML techniques including Decision Trees, Random Forest as well as unsupervised techniques such as Clustering. and Principle Component Analysis.

The session includes theory around each of the technique as well as a demo using a sample data set.

Speaker(s):

Josh Kodi

Track and Room: Data Science - 3033

Title: Advancements in Azure Database

Abstract: This will be the third time delivering this session in South Florida and much has changed in the past year. In this session I will be covering the new enhancements added to the service in the past year including Managed Instance, automatic tuning capabilities and support for Open Source databases.

I will wrap up the session with an overview of the shifting responsibilities of the DBA as cloud becomes more mainstream.

Speaker(s):

Pankaj Satyaketu

Track and Room: Azure Cloud - 1053

Title: New Instance, Now what?

Abstract: Congratulations, you’re now our DBA! A new SQL instance is like a blank canvas, you stare at it and wonder where to start. As an accidental dba, this session will help you learn how to survive in your new role.

In this session, you will be supplied with the beginning brush strokes to make your server a master piece. To do so, we will review best practices for standard configurations, backups, maintenance, and disaster recovery.

By the end of this session, you will have developed a pallet of tools to help you create your SQL Server Masterpiece and be able to use it as a print for others.

Speaker(s):

Jim Donahoe

Track and Room: DBA Beginners - 1048

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

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

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

Speaker(s):

Dmitri Korotkevitch

Track and Room: DBA Advanced - 3046

Title: Artificial Intelligence, Cognitive Services, and Power BI

Abstract: Microsoft Cognitive services is a series of services based on Microsoft Research using Deep Learning techniques, ready for you to enrich your unstructured data. Microsoft Services includes: Vision (Computer Vision, Emotion, Face, Video), Speech/Language (Speaker Recognition, Spell, Sentiment, Language, Key Phrases, Topic detection, Linguistic Analysis), Knowledge, and Search. These services are consumed by using the Cognitive Services APIs. Power BI enables you to consume the APIs to enrich your unstructured data inside your Power BI solutions. During this session, we will cover how to consume the API using Power Query to then visualize the results with Power BI visuals. We will also consume the Cognitive services API by using a R script inside Power BI. This session is structured with a B2C Survey case study solution with a real time Dashboard using a streaming dataset.

Speaker(s):

Paco Gonzalez

Track and Room: Data Science - 3045

Title: DataGrip IDE: How your tool can help writing SQL

Abstract: Now IDEs on IntelliJ-platform are one of the most popular tools for developers. More than two million people use IntelliJ IDEA, PyCharm and other IDEs. At the same time, they use various SQL clients for writing and executing statements. But working with SQL is possible just from these IDEs. There is also a stand-alone IDE for SQL called DataGrip which was created based on a huge expertise in code-insight which JetBrains, IntelliJ creators, have. In this session, I will briefly show main tips and tricks of using database support inside IDE’s based on IntelliJ platform.

— Tips for writing and executing statements — Editing data from UI — Using code completion and code inspections — Comparing result-sets — Searching through database objects — Navigating through data — and other features.

Speaker(s):

Maxim Sobolevskiy

Track and Room: DevOps - 1053

Title: Career Panel - What You Need To Know

Abstract: We all know how important tech is right now - but what happens when hiring managers don’t know how to find the candidates they need, and they candidates don’t know what the managers are truly looking for?

In this career panel we will dig into the manager / candidate gap that is prominent in the marketplace, and how to progress your career by being able to establish yourself as a leader in your field. Whether you are someone involved in the hiring process, or someone looking to move your career forward, this panel is for you!

Speaker(s):

Adam Weiss

Track and Room: Professional Development - 3045

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: Business Intelligence - 3035

Title: Making Sense of the Power BI Ecosystem

Abstract: Power BI has taken the world by storm since it’s release in mid-2015. Since then, Microsoft’s cloud analytics offering has matured and grown in scope and complexity. In this session, we’ll seek to understand the moving parts of the Power BI ecosystem including Power BI Pro, Premium, Report Server, Embedded, the Common Data Service, and more. By the end of this session the audience should have a firm grasp on the ecosystem and when to use what.

Speaker(s):

Dustin Ryan

Track and Room: Analytics and Visualization - 3047

Title: Using PowerBi to troubleshoot SQL Server instances

Abstract: Power BI is the hottest new tool for data insights. While PSSDIAG and SQLNexus are go-to tools used by Microsoft engineers and 3rd party Consultants to gather a wealth of performance data from SQL Server, displaying and analyzing that data is not a trivial task. Participants will learn how to configure a performance collection, how to collect and analyze performance data and use Power BI to review SQL Server bottleneck that are exposed by the interactive visual experience Power BI offers. Disclaimer: Demo filled session, few slides

Speaker(s):

Sam Mesel

Track and Room: DBA Advanced - 3046

Title: Fundamentals That Will Improve Your Query Performance!

Abstract: Time and time again the same misunderstandings by developers and query writers appear when query performance issues arise. In this demo heavy presentation, we will review these specific topics such as data types, implicit conversions, sargability, and some others that all have an impact on query performance. Come join me and by the end of this session you will have the knowledge to boost your query performance!

Speaker(s):

John Wells

Track and Room: DevOps - 3044

Title: SQL Server Query Plans - Journeyman and Beyond

Abstract: A detailed look at Query Plans, the Query Optimizer, and how this important tool can help us recognize and remediate performance issues. We will look at statistics, indexes, types of joins and detail the query plan operators. We will also discuss some well-known performance killers and how to spot them.

Speaker(s):

Ernest Libertucci

Track and Room: DBA Advanced - 3046

Title: “The Modern Data Architecture: Business Intelligence (BI) and Big Data Management Systems (BDMS)”

Abstract: The arrival of the Big Data movement (Hadoop and NoSQL) is changing the enterprise data architecture. In this presentation, I will describe the advantages and disadvantages of OLTP, OLAP and Big Data, and the increase of BDMS (BIG DATA MANAGEMENT SYSTEMS). I will show how the Modern Database Architecture landscape is changing. I also intend to present a general description of the techniques and tools used in The Modern Data Architecture

Speaker(s):

Frank Quintana

Track and Room: Business Intelligence - 3035

Title: Improve Your Knowledge of the Optimizer and Statistics!

Abstract: What is the Optimizer, what does it have to do with Statistics?? Database Engines rely on an algorithm to determine the best way to access data. The power to influence how the data is accessed to achieve the best SQL performance possible is in your hands!! Focusing on the Optimizer and Statistics, many techniques and tools are available to assist report writers, developers and DBA’s in achieving the optimal paths to the data. I will give you the education you need to consider the options, and a portal into how the optimizer works to help your code work with the optimizer to achieve the better performance.

Speaker(s):

Julie McLain-Harper

Track and Room: DBA Beginners - 1048

Title: The building blocks of Azure Databricks

Abstract: In this session you will learn the basics of Azure Databricks as a collaborative tool for developers, Data Scientists, querying and reporting. We will demo the creation of a cluster environment and connectivity with PowerBi via JDBC

Speaker(s):

Diana Betancourt

Track and Room: Cloud Application Development Deployment - 3033

Title: Brand yourself like a pro 2.0 “How to tell the story”

Abstract: There are many “social media outlets” but not all of them are “the right one” for you, especially if you don’t have a brand. Building a brand has to be intentional. You cannot just be you. Discovering the things that make you unique is not enough. You have to package these things in a way that highlights and perhaps even over exaggerates them. In this interactive session, you will learn how to use Social Media to create your personal brand to positioning yourself as a pro, telling the story in the way that the people want to hear at the same time that you increase your self-confidence.

Speaker(s):

Patricia Monica Ojeda

Track and Room: Professional Development - 3045

Title: Modis and R

Abstract: R is a great platform for analysis and extracting data, which includes open source satellite data. We’ll just be going over the basics or bringing this data into R and visualizing it.

Speaker(s):

Stephen Ippolito

Track and Room: Data Science - 3033

Title: APPLY Yourself

Abstract: Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

Speaker(s):

Kevin Feasel

Track and Room: DevOps - 3044

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: DBA Beginners - 1048

Title: Performance Tuning for the BI Professional

Abstract: Being a BI Professional, you need all the performance tuning the DB folks get and more. In this hour, we will go over important performance tuning tips that you can use to help make your deliverables faster and more effective. We will touch on the MSBI tools of SSIS, SSAS, SSRS and PowerBI.

Speaker(s):

Jonathan Stewart

Track and Room: Business Intelligence - 3035

Title: Migrate your On-Prem Database to Azure SQL Database

Abstract: Do I want to migrate my on-prem database to Azure? If yes, then how? Excellent questions! We will briefly discuss why you want to migrate to Azure, and then I will show you how to do it! Join me in this demo driven session where we will walk through the options and migration of an on-prem SQL Server database to an Azure SQL Database.

Speaker(s):

Joe Abbott

Track and Room: Azure Cloud - 2064

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: Azure Cloud - 1053

Title: Adaptive Query Processing in SQL 2017 and Azure SQL Database

Abstract: Come join me for this session on Adaptive Query Processing (AQP) in SQL Server 2017 and Azure SQL Database. During this session I will show how this new feature can enhance your application and query performance without code changes.

Come see how you can benefit from a self-learning artificial intelligent database.

Speaker(s):

Sherwin Anderson

Track and Room: DBA Advanced - 3044

Title: Much Ado About Hadoop

Abstract: If you’re interested in Hadoop but don’t know where to begin, this session will give you an idea of what you can do with the open-source platform. We will see an overview of the Hadoop architecture, becoming familiar with the overall platform and its solutions for warehousing, ETL, streaming data ingest, in-memory processing, and more. We will compare Hadoop to SQL Server to help gain an understanding of when to deploy which technology.

Speaker(s):

Kevin Feasel

Track and Room: Business Intelligence - 3035

Title: Indexing for performance

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

Speaker(s):

Jeffrey Garbus

Track and Room: DBA Advanced - 2066

Title: Power BI for large databases

Abstract: Today’s enterprise business analytics requires run complex analytic queries against large datasets stored in different sources like Azure SQL Database, Azure SQL Data Warehouse or Amazon Redshift data warehouse. In this session, BI Architect and Microsoft Certified Professional, Hector Villafuerte focuses upon the design, architecture and best practices that allows Power BI to offer the best functionality and performance combination. Throughout the session, we explore various large datasets and witness how to implement Power BI in different modes to achieve high performance and capabilities.

Speaker(s):

Hector Villafuerte

Track and Room: Analytics and Visualization - 3047

Title: Database Backup and Restore Best Practices

Abstract: Backups are a vital part of any DBA’s job. Acting as the “last line of defense”, we rely on backups to safeguard the company’s most important asset: the data. But how do we know we’re managing our backups appropriately? This session will cover the fundamental principles of building out our backup (and restore strategy), covering the “why” of backups and best practices for our data protection.

Speaker(s):

Michael Fal

Track and Room: DBA Beginners - 1048

Title: Data Visualization: How to truly tell a great story!

Abstract: We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There’s a lot more to creating that story than just getting the correct information. Come learn not just the do’s and don’ts, but the whys…

Speaker(s):

Jonathan Stewart

Track and Room: Analytics and Visualization - 3047

Title: Intro into SQL Server High Availability Technologies

Abstract: In this session, Harold will provide the overview of SQL Server HA/DR Technologies such as AlwaysOn Failover Clustering, AlwaysOn Availability Groups, Log Shipping, and Replication. You will learn how those technologies are implemented, their benefits, downsides, best use-cases, and choose the propper technology to meet business requirements.

Speaker(s):

Harold Velazquez

Track and Room: DBA Beginners - 1048

Speakers

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

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

Jeffrey Garbus

LinkedIn: Jeffrey Garbus

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

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

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

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

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.

Jim Donahoe

Twitter: - SQLFlipFlopsDBA

Contact: http://www.sqlflipflopsdba.com

Jim is a Premier Field Engineer for Microsoft in the Data/AI space. He lives in Pittsburgh in a small suburb. He loves working with all things Azure(ARM templates, DBaaS, SQL on IaaS). He is an avid collector of retro video games! He is a member of the Idera ACE program for 2018.

John Wells

Twitter: - @SQLServerDBA318

LinkedIn: John Wells

Contact: https://sqlrookieinthe318.wordpress.com/

I’m a DBA at Lamar Advertising in Baton Rouge. I’m a member of the Baton Rouge User Groups Board as well as a co-organizer for the ONLY SQLSaturday that serves Jambalaya for lunch! I started speaking in 2018 and enjoy everything about this powerful community! I enjoy performance tuning, helping developers with best practices and DBATools.

Maxim Sobolevskiy

Twitter: - 0xdbe

Contact: https://blog.jetbrains.com/datagrip/

Maxim Sobolevskiy is a Product Marketing Manager from JetBrains. After ten years of SQL development, he decided to realize his so-called soft skills and joined JetBrains in 2015 as a marketing manager. He is a member of the team which is working on DataGrip, a development environment for SQL developers. Hi is passionate about the phrase “the simpler the better”.

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

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

Jonathan Stewart

Twitter: - sqllocks

LinkedIn: Jonathan Stewart

Contact: https://sqllocks.net/

Jonathan Stewart is a Business Intelligence consultant specializing in data visualization, data warehousing, and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments.

Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and Business Intelligence at numerous SQLSaturday events, local user groups, and conferences throughout the United States and around the world. He participates in webcasts, podcasts, and on

Jim Donahoe

Twitter: - SQLFlipFlopsDBA

Contact: http://www.sqlflipflopsdba.com

Frank Quintana

Twitter: - Frankqr2

LinkedIn: Frank Quintana

Contact: http://www.businessintelligencematters.us

Doctor Quintana has been involved in optimization and math modeling since the ’80s. He is an IT University professor of Data Science, Databases, Data Mining, and Knowledge Discovery. He is a former head of an RD department. He worked as a research engineer at the Memorial University of Newfoundland. He also worked as a consultant in the role of a technical team leader and software architect for EDS responsible for critical parts of the SDLC for multi-million dollar projects. He is one of the Software Architects that designed and built the “Health and Benefits System for the of the Veteran Affairs of Canada” He is a regular speaker at national and international events In 2004 he started his consulting practice in South and Central Flori

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

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Jonathan Stewart

Twitter: - sqllocks

LinkedIn: Jonathan Stewart

Contact: https://sqllocks.net/

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.

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Jeffrey Garbus

LinkedIn: Jeffrey Garbus

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

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

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

Julie McLain-Harper

LinkedIn: Julie McLain-Harper

As “The Goddess of the Database”, I am a Sr DBA, Technical Professional and Microsoft Certified Trainer who has over 25 years of experience and a passion for EDUCATING, new technology, system performance and troubleshooting. My experience started with Hierarchical Databases and thankfully moved to Relational Databases, Open Systems technology, and SQL Programming. Because of my desire to give Developers a new perspective on their process of interacting with database data, I began educating co-workers and then training others in SQL Programming best practices. I have significant background as a professor/educator; a Sr. DBA; in performance tuning; as a data, app and infra architect; an Adopter of PowerShell and am MCSA Certified.

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.

Frank Quintana

Twitter: - Frankqr2

LinkedIn: Frank Quintana

Contact: http://www.businessintelligencematters.us

Adam Weiss

LinkedIn: Adam Weiss

Adam is a sales leader with extensive experience in Recruiting, Sales Management, and Training.

Over the last 10 years he has not only been a top producer for some of the top companies in the country, but has built, trained, and lead multiple award winning teams.

Under his supervision, business deals have been executed with some of the leading organizations in the US Canada. Individual transactions have been completed north of $40M.

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.

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Stephen Ippolito

Well as of 2015 I’ a graduate of FAU with my Ph.D in Applied Mathematics go Owls! Following gradation I started a Post Doc modeling Crop Diseases for the USDA and ASTA (The American Seed Trade Association). Recently I started a position as a Data Scientist for Florida Crystals. My research interests involve using dynamical systems and Bayesian methods to understand biological phenomena. Recently I’ve worked on a project involving student success in Math Classes. On my spare time which I affectionately call “The empty set”, I like to run, go dancing, and cook.

Patricia Monica Ojeda

Twitter: - pm_ojeda

LinkedIn: Patricia Monica Ojeda

I’m a Bilingual Management Consultant and Executive Coach, with 20+ years of experience in the fields of Information Technology, Marketing, and Operations. I help companies have successful projects, professionals with their personal brands, Millennials with their social communication, and Women to discovering their full potential. I have extensive experience building professional networks, I am known by the identification of opportunities, analyzing operations, and the development of winning solutions.

Jonathan Stewart

Twitter: - sqllocks

LinkedIn: Jonathan Stewart

Contact: https://sqllocks.net/

Michael Fal

Twitter: - @Mike_Fal

LinkedIn: Michael Fal

Contact: http://mikefal.net

Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently.

Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He has been caught playing trombone in public on more than one occasion.

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.

Dustin Ryan

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

LinkedIn: Dustin Ryan

Contact: https://sqldusty.com

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!

Paco Gonzalez

Twitter: - @pacosql

LinkedIn: Paco Gonzalez

Paco Gonzalez is the CEO of SolidQ North America, and a Microsoft Data Platform MVP. Focused on Business Analytics and Artificial Intelligence, he specializes in helping organizations become data driven from a strategic and technical perspective. Paco is a speaker at small and large conferences such as PASS Summit, Ignite, and Business Applications Summit, and he has published several books and whitepapers. He is based in Atlanta, GA.

Adriano da Silva

Twitter: - AdasilvaTek

LinkedIn: Adriano da Silva

Joe Homnick

Twitter: - @SmokingJoe

LinkedIn: Joe Homnick

Contact: http://joeblog.homnick.com/

Joe Homnick is a Microsoft Regional Director since the start of the program over 20 years ago and is a principal owner of Homnick Systems (HSI), a Microsoft Gold Certified Partner located in Boca Raton, Florida. HSI is one of the most established Microsoft Certified Partners in the world, dating back to the beginning of the program in 1993. HSI delivers Microsoft services in the areas of system development and implementation through software consulting, development, training and mentoring.

Dmitri Korotkevitch

Twitter: - aboutsqlserver

LinkedIn: Dmitri Korotkevitch

Contact: http://aboutsqlserver.com

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.

Diana Betancourt

Twitter: - dianabeta

LinkedIn: Diana Betancourt

Former graduate of the quot;Universidad Santa Maria La Antiguaquot; School of Computer Science. I have been involved in the IT world since 1992, since then I have been working with many OS platforms, development languages and databases, among them Unix, Oracle, SUN, Informix, FoxPro, Microsoft SQL Server, just to mention a few. Diana enjoys solving complex performance tuning issues, examining your data using Databricks, designing in Azure SQL Datawarehouse, developing cool visuals using Power Bi, or evangelizing about Microsoft Data technologies at community events like SQLSaturday and local user group meetings.

Gary Lock

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

LinkedIn: Gary Lock

Gary is a Solution Architect at BlueGranite. He enjoys combining his extensive background in business with a passion for technology. His expertise encompasses the full Microsoft BI stack including Microsoft Azure, Power BI and Cortana Intelligence. He has a passion for process improvement, and has extensive experience developing analytics using data from many of the leading management systems (ERP, CRM, MRP, WMS, PSA).

Josh Kodi

LinkedIn: Josh Kodi

Enterprise Data Engineering and Analytics leader with significant experience defining and executing overall organization’s strategy for Big Data, Data Warehouse and Business Intelligence. Possess an excellent blend of hands on technical and management experience to direct all aspects of data engineering program.

Pankaj Satyaketu

Twitter: - @SQLPS

Contact: http://www.sqltwist.com

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

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

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

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.

Hector Villafuerte

Twitter: - optimumclick

LinkedIn: Hector Villafuerte

Contact: http://www.hectorv.com

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

Diana Betancourt

Twitter: - dianabeta

LinkedIn: Diana Betancourt

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.

Hiram Fleitas

Twitter: - @hiramfleitas

LinkedIn: Hiram Fleitas

Contact: http://fleitasarts.com

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.

Jonathan Stewart

Twitter: - sqllocks

LinkedIn: Jonathan Stewart

Contact: https://sqllocks.net/

Sherwin Anderson

Twitter: - sqlsherwin

LinkedIn: Sherwin Anderson

Sherwin Anderson is a Microsoft Certified Master. He has worked with SQL Server for over 15 years. He currently works for Microsoft as a Premier Field Engineer specializing in performance tuning, optimization, high availability, as well as APS/PDW. When he is not working you can generally find him officiating lacrosse around the state of Florida.

Sam Mesel

will be provided later on

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.

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.

Alex Funkhouser

Twitter: - AlexFunkhouser

LinkedIn: Alex Funkhouser

Contact: http://www.sherlocktalent.com/newsletter-archive/

Alex Funkhouser wrote his first lines of code on a TRS80. Alex serves as CEO of SherlockTalent, a South Florida based tech talent agency helping top tech talent find great opportunities. He is an avid supporter of the technology community and also serves as president of ITProCamp, Inc., the community non-profit 501c3 that helps produce amazing tech events such as CodeCamp, TechNightAtTheBallPark, ITProCamp and originally ITPalooza. He earned a Bachelor of Science from Washington University and an MBA from The Netherlands School of Business. Alex’s recruiting philosophy: “Know who is best at what, and know who needs the best!”

Harold Velazquez

Harold (MSCE, MSMIS) has been working with SQL Server for over 18 years focusing on high availability, disaster recovery, OLTP databases, virtualization, and performance troubleshooting. Currently he is working as Sr. Enterprise Database Administrator at Chewy.com managing mission-critical, highly transactional SQL Servers environments with little or no maintenance windows, and 100% uptime business requirement.

SQLSaturday #755 - South Florida 2018

Sessions

Title: Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques

Title: Are They Hearing What You Said - or Something Completely Different?!

Title: Getting started with SQL Azure Database: What you need to know

Title: Hack / Protect / Predict SQL Server - Come learn them.

Title: Patterns for Managing Your Career Learning Needs

Title: Blockchain - A Database Architecture Paradigm Shift

Title: Quick and Dirty Push Datasets with Power BI

Title: I know what you did last transaction: Auditing using CDC, Temporal Tables and Triggers

Title: So You think You can Speak?

Title: Dell: #GetModern with Dell EMC

Title: For Love or Money, Your Tech Career

Title: Data Science, and the changing Role of Data professionals; Data-Information-Knowledge and Wisdom

Title: Applied Machine Learning with Python

Title: Data Science: Supervised and Unsupervised machine learning

Title: Advancements in Azure Database

Title: New Instance, Now what?

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

Title: Artificial Intelligence, Cognitive Services, and Power BI

Title: DataGrip IDE: How your tool can help writing SQL

Title: Career Panel - What You Need To Know

Title: Populating a Data Warehouse with SSIS and Biml Patterns

Title: Making Sense of the Power BI Ecosystem

Title: Using PowerBi to troubleshoot SQL Server instances

Title: Fundamentals That Will Improve Your Query Performance!

Title: SQL Server Query Plans - Journeyman and Beyond

Title: “The Modern Data Architecture: Business Intelligence (BI) and Big Data Management Systems (BDMS)”

Title: Improve Your Knowledge of the Optimizer and Statistics!

Title: The building blocks of Azure Databricks

Title: Brand yourself like a pro 2.0 “How to tell the story”

Title: Modis and R

Title: APPLY Yourself

Title: Temporal Tables: Creation, Use, and Optimizing

Title: Performance Tuning for the BI Professional

Title: Migrate your On-Prem Database to Azure SQL Database

Title: Introduction to IoT using Azure

Title: Adaptive Query Processing in SQL 2017 and Azure SQL Database

Title: Much Ado About Hadoop

Title: Indexing for performance

Title: Power BI for large databases

Title: Database Backup and Restore Best Practices

Title: Data Visualization: How to truly tell a great story!

Title: Intro into SQL Server High Availability Technologies

Speakers

Sponsors