SQLSaturday #864 - South Florida 2019

Event Date: 06/08/2019 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: What’s New in SQL Server 2019: 100% Demos

Abstract: You haven’t installed SQL Server 2019 yet, and you don’t want to sit through a bunch of slides. You want to see a series of real-world demos focusing on the features of SQL Server 2019 that will make your users happier with as little work as possible on your part. You don’t have time to rewrite all your queries or learn new languages - you just want the database to go faster.

I’m Brent Ozar, and I’ll give you the whirlwind tour. I’ll focus on just the features that make the biggest bang for the buck, things you can implement right away and see a noticeable difference. I’ll show you what kinds of code will benefit the most so you can go back to the office and have an honest discussion with management about what to expect.

No slides here - not even an about-me slide. Let’s dive into some queries!

Speaker(s):

Brent Ozar

Track and Room: Enterprise Database Administration Deployment - Room B - 2081

Title: Climbing the SQL Server Index B-Tree

Abstract: You’ll find a lot of Word of Mouth (WOM) advice out there about SQL Server performance, especially when it comes to indexes. Some of the things you have probably heard are:  keep clustered index width small  unique indexes perform better  keep non-clustered index width small  compressed indexes have fewer logical reads  add one index for each column

But how do you know if this advice is good or bad? Did you know that there is a way to look under the hood at the actual index pages to see how the data is stored, and how it’s stored differently when data is compressed? Using this information, you can prove or disprove the WOM advice. Attend this demo-heavy session to learn how the SQL Server optimizer uses indexes. It’s all about performance, and the right indexes will give your application a big performance advantage.

Speaker(s):

Mike Byrd

Track and Room: Application Database Development - Room D - 2077

Title: Containerize your learning - a docker introduction

Abstract: You’ve heard about docker, but haven’t found that use case for it yet or simply just don’t have the time to learn it. This session will start off showing you what docker is at a high level, and its many simple use cases. You’ll leave with enough knowledge to either use someone else’s docker image or build your own. All if this without needing to install docker on your machine. We’ll go into how to spin up an environment using a cloud resource in minutes. After that, we’ll install a graphical interface for docker in a docker image to help speed up your learning. From there, we will even spin up an SQL Server in a container that can start and stop in little to no time.

Speaker(s):

Daniel Shrader

Track and Room: Cloud Application Development Deployment - Room G - 2072

Title: An Introduction to Power BI for Data Science With Python

Abstract: This session provides an introduction to the use of Power BI for Data Science. It covers the use of Power BI as part of the Data Science process; including EDA (Exploratory Data Analysis), Data Visualization along with its integration with Python, Scikit-Learn and SQL Server Machine Learning Services.

This is an introductory session designed for those with basic Power BI skills; as well as, minimal or no Python and/or Data Science experience. This is an applied session focusing on the utilization of the tools, technologies and machine learning libraries; such as Pandas, Numpy, Scipy, etc. The demos are centered around Power BI and its integration with Python, ML engine and Data Science processes.

Speaker(s):

Adriano da Silva

Track and Room: Data Science - Room J - 3046

Title: Constraints are the Key (to Data Integrity)

Abstract: This session is designed to introduce you or to re-engage your interest in all the options we have for setting constraints in a database. From datatypes to nulls to checks, defaults, foreign keys, and triggers we have a LOT of options, so it’s important to know the options and also have a bit of a professional philosophy on when to use each of them - we will do a brief look at each of them. We’ll talk about why getting them right on day 1 is so important, how to add them to existing tables (the syntax is the least interesting part!), and some patterns and anti-patterns you can look for when you get to the office on Monday. Constraints aren’t glamorous, but they matter, and they require an advocate - you! A good session for DBA’s, developers, and yes, even managers.

Speaker(s):

Andy Warren

Track and Room: Application Database Development - Room A - 2082

Title: Azure SQL DW. Redefining MPP, how it stacks against Snowflake and RedShift

Abstract: Data Warehousing has been traditionally deployed via on-prem MPP solutions, and due to cloud modernization, and datacenter reduction footprint initiatives, organizations are looking out to establish a relationship with a cloud solution that can help them get off the traditional storage and compute licensing scheme, to easily scale their workloads without spending millions in newly acquired hardware, and to reduce their database administration operational tasks. Snowflake, RedShift and Teradata provide a path to migrate workloads into the cloud and allows a very reduced utilization expense for both compute and storage. That is at least, what the marketing says as it has a tacit disclaimer around it. Azure SQL Data Warehouse offers scalability, pay-as-you-go compute solutions, with data contained within the database boundaries. The presentation shows a side by side comparison, with pros and cons of each platform and debunks some of the myths that have surfaced.

Speaker(s):

Oscar Zamora

Track and Room: Cloud Application Development Deployment - Room H - 3044

Title: Indexing Like a Rocket Scientist

Abstract: Performance is what your users care about, and indexes can both improve and decrease performance. As a SQL Developer, do you understand the difference between a clustered and non-clustered index or what a covering index is? What is different between OLTP and data warehouse databases when it comes to indexing? This session is a deep dive into  Clustered indexes  Non-clustered indexes  B-Tree traversal  Primary Keys  Covering indexes

This session will feature live query demos illustrating index utilization and performance using statistics and query plans. Understand indexing like a rocket scientist by attending this session!

Some knowledge of T-SQL and Management Studio is recommended.

Speaker(s):

Mike Byrd

Track and Room: Application Database Development - Room F - 2073

Title: DevOPS for DBAs - Where is your magic wand?

Abstract: DBA is key when a database platform change occurs and necessary to support the application, release processes and there is a miracle waiting to happen!

Based on my experience DBA is left out in the key element of DEVOPS, this is unfortunate. DBAs have a lot to offer . In this session let us overview where exactly DBAs can make miracles with their magic wand, let’s talk about process and procedures. To evaluate each change request to ensure that it is well thought out, is compliant with organizational best practices. Also review what Azure DevOps is offering to manage your cloud deployments.

Take away best practices associated in DEVOPS and DBA world.

Speaker(s):

Satya Jayanty

Track and Room: Enterprise Database Administration Deployment - Room C - 2078

Title: Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry

Abstract: Like parents having to break up a fight between battling siblings, SQL Server must do the same for conflicting transactions. We call these Deadlocks and they can present a problem to many DBAs. Deadlocks can be minor fights or major issues making SQL Server continually choose a side like constantly quarreling siblings.

To understand how Deadlocking occurs, we must understand what caused the fight . Learning about basic locking and blocking of SQL Server is a great place to start.

By the end of this session you will walk away with the knowledge of how the locking/blocking mechanism works, the basics of deadlocking, and what Isolation Levels are . You will know how these can help or hurt your situation. Finally you will have the power to capture, report, and stop the family fighting.

Speaker(s):

William Wolf

Track and Room: Application Database Development - Room B - 2081

Title: Changing Data Is Easy, Managing Data Change is Hard!

Abstract: Databases are growing. The way we use data is changing and growing. When you have a lot of change, it has to be managed, or bad things happen to your data and your job! A common problem with database change management is… database change management. This session walks the user through the concepts of database change management, why it’s important, and how SQL Server Data Tools (SSDT) makes this process easy. There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be. Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.

Speaker(s):

James McAuliffe

Track and Room: Enterprise Database Administration Deployment - Room I - 3045

Title: Build a Modern Data Warehouse from disparate sources and visualize the data with PowerBI

Abstract: A data warehouse (DW) is a core component of business intelligence and a central data repository for different sources. This poses many challenges as the schema definition for those sources may be completely different from one another. In this presentation, we discuss how to create a data warehouse model that can support data from multiple systems. Oscar Garcia shows how to build a dimensional model which can enable us to import the data with different shapes into a data warehouse. We then create processes to transform and load the data using Apache Spark. We finally use Power BI to visualize the data from our data warehouse and Spark.

Learning Objectives:

Challenges when using disparate data sources (different models)

Define a common model to support the different model shapes

Apache Spark Overview

Strategy for loading the different data-sets into the common model

Data analysis and visualization with Power BI

Speaker(s):

oscar garcia

Track and Room: Analytics and Visualization - Room D - 2077

Title: What to Do When SQL Server is Unusually Slow

Abstract: “Is something going on with the SQL Server right now?” You hear those words, and your heart starts to race a little faster. You try to connect to the SQL Server, and it responds, but you can tell it’s a little slow. You open up Activity Monitor, look at recent expensive queries, and maybe open up the Windows event logs to see if anything’s happened recently.

There’s gotta be a better way, right?

Good news – there is, and you’re about to learn how the pros do it. In one all-demo session, you’ll watch Brent Ozar use sp_WhoIsActive, sp_BlitzFirst, and sp_BlitzCache to solve several common emergencies. You’ll walk away with a written checklist to solve typical performance emergencies.

Speaker(s):

Brent Ozar

Track and Room: DBA Beginners - Room B - 2081

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 - Room E - 2074

Title: How AI Saved My Great-Grandma’s Cookbook

Abstract: True Story… My great-grandmother’s cookbook from 1937 was crumbling. It had her hand-written adjustments to recipes, her own additions, and was a prized possession within our family. Come learn how I leveraged the open-source JFK Files Project on Microsoft’s GitHub (with a few modifications) to turn 150 pages of ancient cookbook into a cool searchable website.

This session demonstrates how you can use both the built-in and custom AI in Cognitive Search. Cognitive Search ingests your data from almost any data source and enriches it using a set of cognitive skills that extracts knowledge and then lets you explore the data using Azure Search. I’ll show you how to use this framework to index and search documents, photos, and hand-written text. The public GitHub repo is available at: https://github.com/Microsoft/AzureSearch_JFK_Files

Speaker(s):

Audrey Hammonds

Track and Room: Data Science - Room H - 3044

Title: Azure Cosmos DB - What you need to know to build globally distributed apps?

Abstract: In this session let us find about (technical overview)what are the foundations and design goals of Azure CosmosDB. There are many benefits which will fit for web, mobile and globally distributed applications that need elastic scaling, high availability with a predictable performance which can elevate ease of development with NoSQL capabilities that every developer/architect/DBA should know about.

Speaker(s):

Satya Jayanty

Track and Room: Cloud Application Development Deployment - Room C - 2078

Title: Is Azure Data Studio Better Than SSMS?

Abstract: Does SSMS sometimes bug you? Do you feel like Microsoft will never add new features to SSMS?

Despite the name, Azure Data Studio works for both on-prem and cloud versions of SQL Server. You might have heard its previous name, SQL Server Ops (Operations) Studio.

Updates are coming out every month, making it easier to use, fixing bugs, and adding exciting new features. Come see some if these new features deserve a spot in your daily toolbox to make your work day easier.

Speaker(s):

Mike Burek

Track and Room: Application Database Development - Room I - 3045

Title: Run Like Google: Server-less Data warehousing and Analytics on Google Cloud Platform

Abstract: If you are looking for a Data Engineering Platform to run your data warehousing and analytics workloads, look no further. Google Cloud Platform (GCP) offerings have been enabling Enterprises deploy, manage and scale their analytics workloads efficiently. Analyze all your batch and streaming data by creating a logical data warehouse over managed storage, as well as data from object storage and spreadsheets. Create blazing-fast dashboards and reports with the in-memory BI Engine. Build and operationalize machine learning solutions or carry out geospatial analysis using simple SQL. Securely share insights within your organization and beyond as datasets, queries, spreadsheets, and reports. Deliver a complete data platform without the burden of provisioning, scaling and upgrading infrastructure. This session will provide a walk-through of Google’s approach to Server-less Data warehousing, analytics and architectural patterns to address your needs.

Speaker(s):

Jay Rajendran

Track and Room: Analytics and Visualization - Room J - 3046

Title: Building AI-powered Solutions with Microsoft Azure

Abstract: Do you understand what does it take to build end-to-end Cloud solutions that leverage Artificial Intelligence (AI) and Machine Learning (ML) to empower users and customers to achieve more? Which AI technologies to choose and when? Which skills does a traditional DBA or developer need to learn in order to work with AI? Come and join this session to find the answer to these questions.

On this session, Eumar Assis, Microsoft Technology Strategist will review and demo the different technology options to create Intelligent applications that are powered by Microsoft Azure. Attendees will learn how to use state-of-the-art Azure services such as Power BI Embedded, Azure Cognitive Services, Azure Cognitive Search, and Azure Machine Learning Service that help augment human capabilities. At the end of this presentation, attendees will understand the Azure AI portfolio and what to use when. Attendees will also learn about some real-world applications that have been built using AI on Azure.

Speaker(s):

Eumar Assis

Track and Room: Azure Cloud - Room F - 2073

Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming

Abstract: This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.

Speaker(s):

Diane Schuster

Track and Room: Business Intelligence - Room B - 2081

Title: “Past, Present, and Future of the Data Profession” Part 1- “Relational Databases Vs. NoSQL”

Abstract: To understand the present and get a glance to the future you have to look at the past. What are the differences between relational and NoSQL Databases? What is Data Science, Data Engineering and Data Analysis? What skills are necessary to keep been competent? How Universities and Business could reduce the deficit of talents in today market place? Part 1- “Relational Databases Vs. NoSQL” My objective of this session is to explain the evolution of the Data Profession from flat files, hierarchical, Network and Relational Databases, DWH, SQL, NF, Business Intelligence, etc. to Hadoop, Big Data NoSQL, ML, AI I also would like to introduce my model of the Intelligence Life Cycle and use it to clarify the advantages and disadvantages of Schema on-read and schema on-write which are the main difference between RDBMS and Big Data (“NoSQL”). What are the advantages and disadvantages of Big Data Compare to RDBMS? Are Data warehouses obsolete? Are Big Data models real schemaless?

Speaker(s):

Frank Quintana

Track and Room: Professional Development - Room K - 3047

Title: 5 Availability Groups Issues That May Ruin Your Day

Abstract: AlwaysOn Availability Groups have become the most common High Availability technology used with SQL Server. It provides protection at the database group level, and it stores a separate copy of each database on each node, eliminating storage from being a single point of failure.

While Availability Groups help to achieve required High Availability, they may also introduce issues in the system. In this session, Dmitri will discuss several less-known problems associated with them. You will learn how Availability Groups may impact transaction log truncation and contribute to the blocking in the system, how readable secondaries may increase CPU and I/O load on primaries among a few other things. Dmitri will also discuss how to properly setup monitoring for Availability Group infrastructure in your environment.

Speaker(s):

Dmitri Korotkevitch

Track and Room: Enterprise Database Administration Deployment - Room L - 3048

Title: “Past, Present, and Future of the Data Profession“ Part 2- “Data Profession in the 21st Century”

Abstract: I pretend to show how our profession has been changed in the last 50 years the impact of these new techniques, models, the raising of new job descriptions and the skills necessary to function in the data profession realm in the 21st Century. Part 2- “Data Profession in the 21st Century” In Part 2 I will concentrate on the skills and composition of Data Drive enterprises and teams and the challenges they are facing My objective of this session is to explain how Hadoop, Big Data NoSQL, ML, AI, and the IoT have influenced and transformed the Data profession. What is a Data Scientist? What is a Data Engineer? What do they do? What is the composition of ML and AI Team? What skills are necessary to keep themselves competitive today and in the near future? How Universities and Business could reduce the deficit of talents in today market place? And what is the future of the data profession? These are some of the main topics at this presentation

Speaker(s):

Frank Quintana

Track and Room: Professional Development - Room K - 3047

Title: Why You Should Consider Implementing Indexed Views

Abstract: This session will include an explanation of what indexed views are, the types of problems that they solve, and their limitations. Additionally, I will provide a methodology for determining whether or not you should consider using indexed views to solve problems in your environment - including how to test and compare them to some alternatives. I will then go through some demonstrations in order to clarify my points further and provide more opportunities for the audience to ask questions.

Speaker(s):

Alexander Fleming

Track and Room: Application Database Development - Room A - 2082

Title: Say what now? SQL Server 2019 + Spark + HDFS???

Abstract: Come learn about one of the ground breaking features being introduced in SQL Server 2019; SQL Server Big Data Clusters. With SQL Server 2019 Big Data clusters we can now create a highly scalable platform that can scale to petabytes of data and enable you to create data virtualization layer that connects to a variety of data sources such as your traditional Relation Databases, NoSQL and Big Data in one homogenized experience.

This is a completely different architecture that brings together a unified experience for SQL Server, Spark and HDFS.

Come join me for and overview and demonstration of the capabilities this platform can deliver.

Speaker(s):

Pankaj Satyaketu

Track and Room: Analytics and Visualization - Room H - 3044

Title: AI Application for everyone: Microsoft Power Apps, Cognitive Service, and Flow

Abstract: These days, Using AI is not limited to writing R or Python codes. There are different API that allows developers, business intelligence consultant and others to create an AI application or report without writing any single code. Microsoft Cognitive service is a toolkit that allows this for all Microsoft users. In this session, an overview on cognitive service will be provided, and attendees will see how to create an OCR (image to text application) to take a photo from an image in Power Apps, then how to use a combination of Microsoft flow and Cognitive service to convert the taken image to text. Moreover, the process of how to create a face recognition application (to detect the face,location in the picture, age, gender, emotion, hair color and so forth) using the Microsoft cognitive service, Power Apps and Microsoft Flow.

Speaker(s):

Leila Etaati

Track and Room: Artificial Intelligence - Room G - 2072

Title: What Is Clogging Your Database Performance?

Abstract: A concise and systematic approaches rather than guessing to analyze SQL Server performance will be presented. Through measuring the response time and wait time at the query level, the performance bottleneck is pinpointed and tuned. The presentation will look at the basic of gathering the stats from SQL Server DMVs.

Speaker(s):

Eddy Djaja

Track and Room: Enterprise Database Administration Deployment - Room I - 3045

Title: The Power Platform Game Changer

Abstract: This is a game changing session. Lets go 0 to 100 real quick by building a business app in minutes using PowerApps, Microsoft Flow and SQL Server. Then lets look at the enterprise-grade security to publish and share your app to iOS, Android, Web and Windows 10.

AGENDA:
1. T-SQL Stored Procedure on SQL Server database (on-prem or cloud).
2. PowerApps (Inputs, Button, Outputs)
3. Flow (Input, SQL Server, Variables, Respond, Tests)
4. Gateway
5. Publish Share with Enterprise Governance.

We’ll have time for QA. Maybe we’ll even ask Cortana a few questions. I look forward to seeing you there!

Speaker(s):

Hiram Fleitas

Track and Room: Cloud Application Development Deployment - Room G - 2072

Title: Database Performance Monitoring

Abstract: Are you struggling with performance issues and your current tools are not providing answers? This presentation will show several solutions from Quest Software that will give you real-time performance alerts and bring together all of your critical database metrics into a single dashboard, with color-coded alerts for problem severity which are clickable for rapid diagnostics. You’ll also learn how wait time and workload analysis can enable you to quickly focus on the worst queries causing the most issues currently and historically in your databases.

Speaker(s):

Janis Griffin

Track and Room: Enterprise Database Administration Deployment - Room C - 2078

Title: Basic Windowing Functions

Abstract: Windowing functions are when you add a “window” to which rows a function will look at using the OVER clause. We’ll start by learning how to add the OVER clause to the commonplace COUNT, SUM, AVG, MIN, and MAX aggregate functions, since the OVER clause is optional. From there, we’ll learn some ranking functions, which do require the OVER clause. You’ll see examples that use the ROW_NUMBER function to identify and delete duplicate rows. Finally, we’ll close with the RANK and DENSE_RANK functions that help you report on the grouping of your data.

Speaker(s):

Mike Burek

Track and Room: Application Database Development - Room F - 2073

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 - Room L - 3048

Title: Interviewing-Be So Good They Can’t Ignore You

Abstract: From the basics to the advanced, we will explore techniques that will ensure you leave a positive impression and help you land that role!

Speaker(s):

Leveat Ruse

Track and Room: Professional Development - Room K - 3047

Title: eCommerce Strategies found through usage data

Abstract: Usage data for eCommerce websites reveals not only secrets about your users, but also opportunities for new conversions. Find out how to best read what draws your eCommerce users, and how to use that data to make strategic business decisions, and user experience decisions that drive your users down the sales funnel and turns them into customers.

Speaker(s):

Ibis Fonte

Track and Room: Analytics and Visualization - Room J - 3046

Title: Building a Data Warehouse from the Ground Up

Abstract: What if you could approach any business process in your organization and quickly design an effective and optimal dimensional model using a standardized step-by-step method? In this session we’ll discuss the steps required to design a unified dimensional model that is optimized for reporting and follows widely accepted best practices. We’ll also discuss how the design of our dimensional model affects a semantic modeling technologies like SQL Server Analysis Services or Power BI and how the choices we make during the data warehouse design phase can make or break our reports.

Speaker(s):

Dustin Ryan

Track and Room: Application Database Development - Room E - 2074

Title: My IOT Journey

Abstract: I have been building an IOT device “AirMon” and will share what I’ve done, the tools I have used, how the decisions were made and what future refinements I want to make. It is still a work in progress but what I am learning should be helpful to others. Topics covered include devices, networks, Azure IOT Hub, Azure Functions, Azure WebApp and hardware design.

Speaker(s):

Dave Noderer

Track and Room: IoT - Room A - 2082

Title: Power BI Governance 101

Abstract: Deploying an enterprise business intelligence solution is no small task but one of the most important factors to consider in order to have a successful roll-out of a self-service analytics tool like Power BI is governance. In this session, we’ll discuss why governance is so important for a successful Power BI deployment, what are the components of Power BI that require governance, and how to govern your Power BI environment. By the end of this session, the audience should have a clearer understanding of governance in the context of Power BI.

Speaker(s):

Dustin Ryan

Track and Room: Business Intelligence - Room E - 2074

Title: Learn Power BI Report Server Enterprise Architecture, Tools to publish reports and Best Practice

Abstract: To improve the performance, sustainability, security and scalability of enterprise-grade Power BI implementations with constant velocity, we need to adhere best practices In this session Vishal will go over Power BI Ecosystem with Example, PBI RS evolution from its inception Architecture of Enterprise Power BI Report Server and usage through various tool available to publish -SSDT SSRS, Power BI Desktop(Optimized Version), Report Builder and mobile report builder and various Best Practices for PBI Report Server.

Speaker(s):

Vishal Pawar

Track and Room: Business Intelligence - Room E - 2074

Title: DELL Gold Sponsored Session

Abstract: DELL Gold Sponsored Session

Speaker(s):

SQLSaturday South Florida

Track and Room: Cloud Application Development Deployment - Room D - 2077

Title: Hack / Protect SQL Server - Come learn both.

Abstract: If you’re using Dynamic Data Masking, Row-Level-Security or just SQL Server and you don’t know how to hack it, then come to this session. I have some demos may leave you in aah. I’ll show you how to also protect yourself against these hacks, plus how to add your database to source control with Azure DevOps, TFS or GitHub to better manage your database changes/deployments.

AGENDA:
1. TDS
2. DDM
3. RLS
4. Database Source Control

We’ll have plenty of time for QA. I hope to see you there!

Speaker(s):

Hiram Fleitas

Track and Room: Application Database Development - Room A - 2082

Title: Artificial Intelligence (AI) Democratized with Power BI

Abstract: Power BI has new features that democratizes (makes accessible to all) AI capabilities. You don’t need to be a Data Scientist or write complicated Machine Learning scripts/routines to take advantage of AI with Power BI. Joe takes you on a demo rich learning experience of how all levels of users can implement AI capabilities in Power BI. These demos will include how to integrate both Amazon Web Services and Microsoft Azure Machine Learning packaged APIs into Power BI.

Speaker(s):

Joe Homnick

Track and Room: Business Intelligence - Room I - 3045

Title: Real-time Sentiment Prediction in SQL Server

Abstract:

ABSTRACT: In this session, I’ll show you from start to finish how to use Machine Learning to predict a sentiment in real-time with Python and SQL Server (On-Premise).
AGENDA:
1. Add ML Features
2. Grant Access
3. Config
4. Install Retrained Open-source ML Models
5. Code in Python and T-SQL
6. Real-time scoring
7. Review Sentiment Results
8. Resources

I look forward to seeing you guys there!

Speaker(s):

Hiram Fleitas

Track and Room: Application Database Development - Room F - 2073

Title: Tips of Running a Well-Oiled Database Team

Abstract: Running a database team is not a cookie cutter process. It is a combination of art and science; blended of technical knowledge and soft skills. This presentation will show the tips and techniques of running the well-oiled database team. Either it is one team member or more than two team members, the presentation is applied to every database professional not just for a database manager.

Speaker(s):

Eddy Djaja

Track and Room: Enterprise Database Administration Deployment - Room A - 2082

Title: Best Practices for SQL Server on AWS

Abstract: Learn how Amazon Relational Database Services (RDS) helps SQL Server DBAs focus their time where it matters most and why thousands of customers have chosen Amazon Web Services for their Microsoft Windows and SQL Server workloads. We will cover the benefits of running SQL Server on Amazon EC2 and Amazon RDS along with best practices for storage, monitoring, availability, security, backup, and recovery.

Speaker(s):

Tom Staab

Track and Room: Cloud Application Development Deployment - Room E - 2074

Title: Temporal Tables - Managing Large Data Sets and Their Effects on Performance

Abstract: So, you installed SQL 2016 (or newer) and implemented Temporal Tables for some of your data. Everything is running well, but now what? In this session we will look at the effects of adding various indexes to both the main and the history table and discuss what that might mean to the front end performance. We will go into data management scenarios, for when you do not want to keep all the data in that table forever.

Speaker(s):

Dale Sullenberger

Track and Room: Enterprise Database Administration Deployment - Room E - 2074

Title: Hadoop, Hive, and Big Data For MSSQL Professionals

Abstract: At times, we find ourselves learning new platforms and integrating them with our tried and true solutions. This session will be a primer for those that find themselves in a similar situation of going from MS SQL Server to the Big Data landscape. We will discuss an overview of Hadoop, including HDFS, Hive, and Spark along with a somewhat deeper description of Hive and how knowledge of TSQL and MS SQL Server can translate to HiveQL.

Speaker(s):

Ernest Libertucci

Track and Room: Application Database Development - Room H - 3044

Title: Power BI: From Ground to the Cloud (Getting started)

Abstract: Power BI is the Leading self-service analytics solution in the market. This session is for beginner users wishing to incorporate PBI to their skill-set and boost their Professional careers.

We will go on a quick tour of the different options offered by the tool, basic concepts, followed by demos and best practices that will let you to start your journey creating fantastic and interactive visualizations. Attendees will have the opportunity to learn how to get and shape data from different sources, create Reports, publish to the cloud and create dashboards.

Speaker(s):

Cecilia Brusatori

Track and Room: Analytics and Visualization - Room D - 2077

Title: SQL Server in the Cloud: Microsoft Azure vs Amazon Web Services (AWS)

Abstract: Migrating SQL Server to the Cloud or already there? Trying to decide which of the two leading Cloud Providers is best for your SQL Server solution? Using one, but always wondered about the other? What about using both for HA/DR? On the surface, the differences aren’t immediately obvious, and several offerings parallel one another. We will review the various options for deploying SQL Server in both Azure and AWS, then dig under the covers on storage and performance to ensure the solution fits your needs. This session will benefit everyone from the beginner to the advanced professional.

Speaker(s):

Darius Liktorius

Track and Room: Cloud Application Development Deployment - Room C - 2078

Title: Exploring Big data technologies and how unlock everything you thought you knew about your data!

Abstract: It could be overwhelming sometimes to learn and to choose among so many Big data tools available in the market. In this session we will help you understand what “Big data” really means and explore the Microsoft Big data landscape while learning about all of the different options, i.e. Data Lake Analytics, Azure Databricks, Azure SQL Data warehouse, Azure Analysis Services; And understand how Power Bi can help you tap into the power of your big data into one cohesive and easy to use tool, while comparing the pros and cons of the different Microsoft technologies.

Speaker(s):

Diana Betancourt

Track and Room: Azure Cloud - Room L - 3048

Title: Artificial Intelligence (AI) for Business Intelligence

Abstract: Cognitive Services provides intelligent algorithms to see, hear, speak, understand and interpret user needs. Azure Machine Learning performs highly specialized tasks such as feature selection, algorithm selection or hyper-parameter optimization. These two AI tools can now be integrated with Power BI. Hector will show and demo some original use cases with Cognitive Services, Azure Machine Learning and other new AI features recently available in PowerBI.

Speaker(s):

Hector Villafuerte

Track and Room: Business Intelligence - Room J - 3046

Title: PowerShell Core - Fundamental on How-To Persist Data in a SQL Server Container

Abstract: This session will give you the necesary knowledge on how to work with container(s) disk data. As a Database Developer and Admininstrator, it’s important to protect that information stored on our Database Servers. I’ll be showing how easy it is to start build a solution and how to make data persist in a container using Docker CLI only as a starting point.

Speaker(s):

Maximo Trinidad

Track and Room: Application Database Development - Room G - 2072

Title: Look, over there, your permissions are showing!

Abstract: You just walked into that fancy new gig, and you’re getting your first cup of coffee. Your boss walks up and asks, “Who has access to that prod server?”, do you know how to get the answers in the next hour? More importantly, do you know what these permissions mean, what an attacker could do with these permissions? In this session we’ll start from scratch assuming that you have no experience with an audit with this question in mind. We’ll work back from here to develop a strategy of how to harden your server.

Speaker(s):

Travis Page

Track and Room: Enterprise Database Administration Deployment - Room C - 2078

Title: Into the Deep End with Azure Data Lake Store Generation 2

Abstract: Azure Data Lake Store… The Next Generation. Gen2, that is. Come learn the what’s and why’s of data lakes, what Microsoft is bringing to the table with Azure Data Lake Store Gen2, and how to make it part of your modern data platform strategy. We’ll discuss the basics of what a data lake is, to how to configure, secure, and manage your lake in Azure, how to leverage Polybase with your SQL Server platform to create external tables using ADLS, and why this data storage option is critical for any organization interested in advanced analytics.

Speaker(s):

Audrey Hammonds

Track and Room: Cloud Application Development Deployment - Room B - 2081

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 - Room L - 3048

Title: PowerBI Challenge

Abstract: PowerBI Challenge

Speaker(s):

SQLSaturday South Florida

Track and Room: Analytics and Visualization - Room B - 2081

Title: Branding and Neuro-Marketing

Abstract: Researchers are gaining amazing insights into positioning a brand by using the science of neuromarketing. Let’s talk about What’s neuromarketing? and how this science will help us to light up people’s brains and positioning our brands.

Speaker(s):

Patricia Monica Ojeda

Track and Room: Professional Development - Room K - 3047

Title: Vision, Mission, Goals Strategies

Abstract: During my session I will talk about how to create a Vision, Mission, Goals Strategies for teams your personal career. I give example from big companies such Amazon also practical examples from the teams I manage. At the end of the session I hope to energize give you tools to create these elements for your teams yourself.

Speaker(s):

Vigi Kuruvilla

Track and Room: Professional Development - Room K - 3047

Title: Are you Running on Insights?

Abstract: Ever wonder what insights you can gain from your own data? This presentation will take you through use cases like fitness data and web traffic monitoring from day to day life and explains how to turn data into powerful visuals and interactive analytics using Power BI. It’s an interactive session that is best suited for beginners and intermediate users of Power BI Desktop and Cloud Service.

Speaker(s):

Santosh Kanthety

Track and Room: Analytics and Visualization - Room D - 2077

Speakers

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

Satya Jayanty

Twitter: - sqlmaster

LinkedIn: Satya Jayanty

Contact: http://www.sqlserver-qa.net

My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions

Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast

Diane Schuster

LinkedIn: Diane Schuster

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

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

Eddy Djaja

Twitter: - ewdjaja

Contact: http://dbaworld.blogspot.com/

I have worked as a SQL DBA since 1997. I have managed SQL Server starting from version 6.5 to the latest version. Throughout my career I also worked as Oracle DBA, database architect, lead DBA and managing DBA team.

Vishal Pawar

Twitter: - Vishal_BI

LinkedIn: Vishal Pawar

Contact: http://bimentalist.com/

Vishal Pawar is a Microsoft Data Platform MVP, Microsoft Certified Trainer (MCT), founder of the Global Power BI User Group and co-leader of the PASS Business Analytics Virtual Group. He is a Principal BI Architect in Green House Data, with decades of experience in BI solution architecture and best practices. He has published more than 1000 articles since 2011 in SQL and BI. Vishal teaches a free Power BI course through Udemy, which has more than 65K students from the glob. Vishal is an exceptional technology community of leaders worldwide who actively share their high quality, real-world expertise with the technical communities.

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.

Maximo Trinidad

Twitter: - maxtrinidad

LinkedIn: Maximo Trinidad

Contact: http://www.maxtblog.com

Maximo Trinidad (Florida Aka – Mr. PowerShell), currently work as a SAPIEN Technologies Evangelist and specialing in scripting automation on SQL Server Microsoft Cloud Technologies. Also a Microsoft MVP (PowerShell) since 2009 and active speaker since 2007 participating at SQLSaturday, IT Pro .NET Code Camps events.

Alexander Fleming

I think T-SQL is the best thing since sliced bread and I thoroughly enjoy reading and writing T-SQL whenever I can. I’m also doing increasingly advanced PowerShell scripting and ETL development with SSIS, PowerShell, and TSQL.

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.

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.

SQLSaturday South Florida

Twitter: - @sfssug

LinkedIn: SQLSaturday South Florida

Contact: https://www.sfssug.org

PASS CHAPTER - SOUTH FLORIDA SQL SERVER USER GROUP

https://www.sfssug.org

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.

Travis Page

LinkedIn: Travis Page

Most recently a Senior Database Administrator with Jackson Hewitt, Travis is on the leadership team of the Pinellas SQL User group and an active member of PASS. Passionate about all things related to technology, he maintains a CISSP certification.

Eddy Djaja

Twitter: - ewdjaja

Contact: http://dbaworld.blogspot.com/

Jay Rajendran

Focused on solving customer challenges through innovative technology solutions on Google Cloud Platform.

Oscar Zamora

Twitter: - ZamoraO

LinkedIn: Oscar Zamora

Contact: https://ozamora.com

For the past 20 years, I have led and executed complex data and analytics migrations into cloud and on-premises deployments. I help enterprises discover opportunities by enabling cloud services that improves their efficiency, reduce operational tasks, increase quality and help making strategic decisions that impact their bottom line. I work directly with Senior Management to establish and execute roadmaps and strategies, and mentor engineers with best practices for data processing and development.

Audrey Hammonds

Twitter: - @DataAudrey

LinkedIn: Audrey Hammonds

Contact: http://datachix.com

Audrey Hammonds is a Data Platform Specialist for Microsoft in South Florida. Twenty-one years ago, she volunteered for database training to escape the clutches of COBOL and has never looked back. A firm believer in good fundamentals and solid design, she gets her kicks from making data do nifty things. These days, she gets her kicks from helping customers adopt data services in Azure.

Leila Etaati

Twitter: - @leila_etaati

LinkedIn: Leila Etaati

Contact: http://blog.radacad.com

Leila Etaati is the First Microsoft AI MVP in New Zealand and Australia, as well as a Data Platform MVP. She has a Ph.D. from the University of Auckland and is the co-director and data scientist in RADACAD company with many clients around the world. Additionally, she is the co-organizer of Microsoft Business Intelligence and Power BI Use group in Auckland with more than 1300 members. Leila has also co-organized 3 main conferences in Auckland: SQLSaturday Auckland (from 2015), Difinity (from 2017) and Global AI Bootcamp. She is a data scientist, BI consultant, trainer, and speaker. She is a well-known International speaker to many conferences such as MS Ignite, SQL PASS, Data Platform Summit, SQLSaturday, Power BI World Tour and in Europe, USA, Asia, Australia, and NZ. She has over 10 years’ experience with databases and software systems. Leila is an active Technical Microsoft AI blogger in RADACAD.

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.

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.

Santosh Kanthety

LinkedIn: Santosh Kanthety

Contact: http://mybyeexperience.blogspot.com/

Santosh Kanthety has been a data practitioner for over a decade and is an active member of BI community. Santosh graduated from NJIT with a Masters degree in Electrical Engineering and worked as a BI consultant at various Fortune 50 companies. He is a Florida resident now and works at NextEra . He is very passionate about photography and travel and when he is not working you can find him along Florida coastline photographing sunrises and sunsets. https://fpl.sharefile.com/share/view/sccd1b6e501e4cdbb

Mike Burek

Twitter: - mikeburek

LinkedIn: Mike Burek

Contact: http://tikiwiki.mikeburek.com

He started by building a complete computerized inventory management system for a multi-state store. Next, he managed Texas Medicare and Medicaid claim data to keep it processing, and building new monitoring metrics. Afterwards, he processed and analyzed marketing data on tens of millions of customers and sent hundreds of millions of multi-lingual marketing messages worldwide. Upgrading those marketing skills, he then worked to process and query tune marketing data for tens of thousands of worldwide enterprise customers, bringing in tens of millions of dollars per campaign. Now he monitors database servers to keep them running well, tunes queries, and helps businesses build new ETL processes. He also runs the Austin, TX user group.

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

oscar garcia

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

LinkedIn: oscar garcia

Contact: https://ozkary.com

Oscar Garcia is a Principal System Architect, Company Founder, Microsoft MVP and certified solutions engineer with many years of experience building solutions using .Net framework and multiple open source frameworks. Currently, he specializes in building cloud solutions using technologies like Azure, AWS data platforms. He enjoys sharing his technical experiences by maintaining a blog and delivering presentations. You can follow Oscar on Twitter via @ozkary or visiting his blog at ozkary.com.

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

Eumar Assis

Twitter: - eumarassis

LinkedIn: Eumar Assis

I am an ISV Technology Strategist with Microsoft. I help Microsoft’s most strategic Independent Software Vendors (ISV) and Software-AS-A-Service (SaaS) providers to build applications and successful businesses on Microsoft Azure. With over 15 years of experience working with software development and building distributed and cloud applications, I am passionate about building Intelligent Applications that are powered by AI.

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.

Dmitri Korotkevitch

Twitter: - aboutsqlserver

LinkedIn: Dmitri Korotkevitch

Contact: http://aboutsqlserver.com

Mike Byrd

Twitter: - ByrdNest_TX

LinkedIn: Mike Byrd

Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com

Former rocket scientist and USAF Fighter Pilot – now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies.

Presenter at many SQLSaturdays over last 6 years in United States, Europe, and Australia.

Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).

Video presentations (for local SQL Server user groups or SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd

Leveat Ruse

Twitter: - www.twitter.com/ncsctechrecruit

LinkedIn: Leveat Ruse

As an Executive Technical Recruiter with Ctrl+f, I currently develop effective recruitment strategies to attract top talent at all levels of an organization. I am an IBM certified trainer and began my career performing general human resources duties. I quickly worked my way up through the ranks of technical recruiting from Lead Recruiter to Senior Recruiter to Business Development.

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.

William Wolf

Twitter: - sqlwarewolf

LinkedIn: William Wolf

Contact: http://www.sqlwarewolf.com

Bill is the Manager of SQL Server Performance Tuning for RDX. He works with over 400 customers on solutions within the SQL Server environment and specialized in code tuning and mentoring the team within RDX. He has become a SQLSaturday veteran speaking at nearly 40 SQLSaturdays in the last 3 years. He has also spoken at Summit and is an Idera Ace class of 2018. Bill is active in the Pittsburgh SQL Server User Group. He is also the chapter lead for the DevOps Virtual User Group. He is passionate about educating users on SQL Server and mentoring others.

Tom Staab

Twitter: - tomsql

LinkedIn: Tom Staab

Contact: http://tomsql.com

Tom is a Partner Solutions Architect at Amazon Web Services. He has worked with SQL Server for over 20 years as an architect, developer, administrator, mentor, and speaker specializing in the data engine and Integration Services. He enjoys interacting with the SQL Server community at events such as AWS re:INVENT and PASS Summit as well as online via Twitter (@tomsql) and as a moderator and contributor at ask.sqlservercentral.com.

Vigi Kuruvilla

LinkedIn: Vigi Kuruvilla

I’m been in the software development industry since 2008. Started out as an Software Developer intern with the travel website Orbitz in Chicago. I’ve worked on multiple teams and different programming languages frameworks. Recently I work with the Infrastructure Operations team within the Ultimate Software group as leader for the G Suite, Desktop Architecture, DBA’s DevOps teams.

Satya Jayanty

Twitter: - sqlmaster

LinkedIn: Satya Jayanty

Contact: http://www.sqlserver-qa.net

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

SQLSaturday South Florida

Twitter: - @sfssug

LinkedIn: SQLSaturday South Florida

Contact: https://www.sfssug.org

PASS CHAPTER - SOUTH FLORIDA SQL SERVER USER GROUP

https://www.sfssug.org

Dustin Ryan

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

LinkedIn: Dustin Ryan

Contact: https://sqldusty.com

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.

Brent Ozar

Twitter: - BrentO

LinkedIn: Brent Ozar

Contact: https://www.BrentOzar.com

Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.

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.

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.

Ibis Fonte

Twitter: - Techibis

LinkedIn: Ibis Fonte

Ibis is the president of The Software Factory which specializes in developing online stores. Her career building software and embedded integrated technology spans for more than 25 years. She is well known as a local tech community leader, a professor at TechLaunch.io, and for inspiring and mentoring others to pursue tech innovation and entrepreneurship. She is an for women in tech, a neuroscience and brain-computer interface enthusiast, and public speaker.

Cecilia Brusatori

Twitter: - CeBrusa

LinkedIn: Cecilia Brusatori

Contact: https://www.magnadatasolutions.com

Cecilia is a Consultant at Magna Data, with over 15 years as Business Intelligence and Data Analytics Professional, experienced in LawEnforcement, Finance, Retail, Events Marketing, Medicine, Accounting, Forensics, Fraud, Corporate Investigations.

Microsoft Certified Professional in SQL Server and Power BI. Passionate and curious, uses Data to solve simple to complex business scenarios and deliver high-value solutions.

She is very active and engaged with the community, leveraging activities and content to provide free forums of education, networking and professional growth. Leader of PASS South Florida SQL Server User Group (SFSSUG), Leader Organizer SQLSaturday South Florida, Leader Microsoft Data and AI (Official)

James McAuliffe

LinkedIn: James McAuliffe

James McAuliffe is a Cloud Solution Architect with CCG Analytics, a Microsoft Gold Partner. He is also a Microsoft Preferred Partner Solutions expert and has been worked with clients of all sizes, from local businesses to Fortune 500 companies. Today’s mix of Big Data and cloud offerings make yesterday’s dream today’s possibility. Let’s talk about it!

Leila Etaati

Twitter: - @leila_etaati

LinkedIn: Leila Etaati

Contact: http://blog.radacad.com

Mike Burek

Twitter: - mikeburek

LinkedIn: Mike Burek

Contact: http://tikiwiki.mikeburek.com

Frank Quintana

Twitter: - Frankqr2

LinkedIn: Frank Quintana

Contact: http://www.businessintelligencematters.us

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.

Dave Noderer

Twitter: - davenoderer

LinkedIn: Dave Noderer

Contact: https://geekswithblogs.com/dnoderer

Dave Noderer is the CEO / President and founder of Computer Ways, Inc., a software development company, COO of Nedd Tech Inc., focused on Augmented Reality, a Microsoft MVP and developer community activist. Mr. Noderer is an Electrical Engineer by training and has been doing software development since founding Computer Ways, Inc. In 1994.

Dave is very active in .net User Group communities. In 2005 he held the first South Florida Code Camp. This annual, free event, attracts over 1000 developers.

Brent Ozar

Twitter: - BrentO

LinkedIn: Brent Ozar

Contact: https://www.BrentOzar.com

Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.

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.

Darius Liktorius

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

LinkedIn: Darius Liktorius

Contact: http://www.liktorius.com

Darius has over twenty years of hands-on technical and managerial experience in Solutions Architecture, Performance Optimization, Database Administration Optimization, Infrastructure Engineering, Software Development and Cloud Solutions (both Azure and AWS). He has advanced numerous organizations from startups to non-profits and Fortune 100 enterprises through the use of technology, and mentored hundreds of developers, DBAs and engineers.

Audrey Hammonds

Twitter: - @DataAudrey

LinkedIn: Audrey Hammonds

Contact: http://datachix.com

Mike Byrd

Twitter: - ByrdNest_TX

LinkedIn: Mike Byrd

Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com

Presenter at many SQLSaturdays over last 6 years in United States, Europe, and Australia.

Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).

Video presentations (for local SQL Server user groups or SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd

Daniel Shrader

LinkedIn: Daniel Shrader

I’ve been dabbling with code since the late 90’s - currently working with Microsoft Business Intelligence products and Amazon Web Services. I’m also a stickler for automating as much of the day to day tasks as I can. When I’m not coding, I enjoy camping, building robots and hanging out with my family.

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.

SQLSaturday #864 - South Florida 2019

Sessions

Title: What’s New in SQL Server 2019: 100% Demos

Title: Climbing the SQL Server Index B-Tree

Title: Containerize your learning - a docker introduction

Title: An Introduction to Power BI for Data Science With Python

Title: Constraints are the Key (to Data Integrity)

Title: Azure SQL DW. Redefining MPP, how it stacks against Snowflake and RedShift

Title: Indexing Like a Rocket Scientist

Title: DevOPS for DBAs - Where is your magic wand?

Title: Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry

Title: Changing Data Is Easy, Managing Data Change is Hard!

Title: Build a Modern Data Warehouse from disparate sources and visualize the data with PowerBI

Title: What to Do When SQL Server is Unusually Slow

Title: Temporal Tables: Creation, Use, and Optimizing

Title: How AI Saved My Great-Grandma’s Cookbook

Title: Azure Cosmos DB - What you need to know to build globally distributed apps?

Title: Is Azure Data Studio Better Than SSMS?

Title: Run Like Google: Server-less Data warehousing and Analytics on Google Cloud Platform

Title: Building AI-powered Solutions with Microsoft Azure

Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming

Title: “Past, Present, and Future of the Data Profession” Part 1- “Relational Databases Vs. NoSQL”

Title: 5 Availability Groups Issues That May Ruin Your Day

Title: “Past, Present, and Future of the Data Profession“ Part 2- “Data Profession in the 21st Century”

Title: Why You Should Consider Implementing Indexed Views

Title: Say what now? SQL Server 2019 + Spark + HDFS???

Title: AI Application for everyone: Microsoft Power Apps, Cognitive Service, and Flow

Title: What Is Clogging Your Database Performance?

Title: The Power Platform Game Changer

Title: Database Performance Monitoring

Title: Basic Windowing Functions

Title: For Love or Money, Your Tech Career

Title: Interviewing-Be So Good They Can’t Ignore You

Title: eCommerce Strategies found through usage data

Title: Building a Data Warehouse from the Ground Up

Title: My IOT Journey

Title: Power BI Governance 101

Title: Learn Power BI Report Server Enterprise Architecture, Tools to publish reports and Best Practice

Title: DELL Gold Sponsored Session

Title: Hack / Protect SQL Server - Come learn both.

Title: Artificial Intelligence (AI) Democratized with Power BI

Title: Real-time Sentiment Prediction in SQL Server

Title: Tips of Running a Well-Oiled Database Team

Title: Best Practices for SQL Server on AWS

Title: Temporal Tables - Managing Large Data Sets and Their Effects on Performance

Title: Hadoop, Hive, and Big Data For MSSQL Professionals

Title: Power BI: From Ground to the Cloud (Getting started)

Title: SQL Server in the Cloud: Microsoft Azure vs Amazon Web Services (AWS)

Title: Exploring Big data technologies and how unlock everything you thought you knew about your data!

Title: Artificial Intelligence (AI) for Business Intelligence

Title: PowerShell Core - Fundamental on How-To Persist Data in a SQL Server Container

Title: Look, over there, your permissions are showing!

Title: Into the Deep End with Azure Data Lake Store Generation 2

Title: Intro Into Index Analysis

Title: PowerBI Challenge

Title: Branding and Neuro-Marketing

Title: Vision, Mission, Goals Strategies

Title: Are you Running on Insights?

Speakers

Sponsors