SQLSaturday #911 - Orlando 2019

Event Date: 09/28/2019 00:00:00

Event Location:

  • Seminole State College of Florida
  • 100 Weldon Blvd Building UP
  • Sanford, Florida

PDF of Schedule

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

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

Sessions

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

Title: DevOps - How To Setup CICD Step By Step For Your Website Database

Abstract: This session will cover how to setup your database source code in a source code repository, configure your website application, configure continuous integration and continuous deployments of your database alongside your application using Azure DevOps, Red Gate DLM, and Octopus Deploy.

Speaker(s):

  • Jeff Taylor

Track and Room: Developer - Misc2 (4208)

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: Security - R6-MiscSecurity (4102)

Title: Build a Modern Data Warehouse from disparate sources with Apache Spark and Power BI

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 (Star Schema)

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: Big Data/Data Science - R7-BigData/DataSci (4103)

Title: A Rocket Scientist Perspective on Index Column Selection

Abstract: Ever wonder how to select what columns need to be in an index definition and what columns should be in the INCLUDE clause. This session will take a deep dive in looking at two SELECT queries on the AdventureWorks2017 database and what indexes give the best, adequate, and poor performance and their relation to disk space utilization. Sometime what you have heard (word of mouth) is not always the overall best solution. In addition ever wonder if covering indexes can be used for UPDATE statements – answer is yes and a demo will show that. And a final tidbit will be a demo how an unused index can affect a SELECT statement’s performance poorly. This session is about 60% demos and yields some surprising results.

Speaker(s):

  • Mike Byrd

Track and Room: DBA - DBA2 (4206)

Title: Deep Dive into Blocking and Deadlocks Troubleshooting

Abstract: SQL Server Concurrency Model is, perhaps, the most confusing and least understood part of SQL Server Internals. Blocking issues and deadlocks occur unexpectedly and negatively impact performance and user experience in the systems. Nevertheless, this model is well-structured and easy to understand when you analyze it from lock types and their lifetime, and compatibility standpoints.

This, two-part session will explain why blocking and deadlocks occur, and how to troubleshoot them in your environments. First, it will provide the overview of SQL Server Concurrency Model and describe SQL Server locking behavior and root-causes of typical blocking issues. Next, the session will discuss how to capture and troubleshoot them using standard SQL Server tools, and how to simplify the analysis using Blocking Monitoring Framework developed by Dmitri.

Speaker(s):

  • Dmitri Korotkevitch

Track and Room: TSQL - R3-TSQL (3104)

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: Developer - R4-Dev/Docker (3205)

Title: Women in IT. A survival guide.

Abstract: One secret of success is failure! Great leaders turn setbacks into victories and obstacles into opportunities. Setbacks can be very challenging for individuals and people often feel helpless. Sharing real-life stories will motivate and encourage people to stay focused on their goals. The Survival Kit will provide the audience of women the tools to overcome so many struggles faced in life and specific to the technology industry.

Speaker(s):

  • Gilda Alvarez

Track and Room: Professional Development - Misc2 (4208)

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: ETL - R8-PowerBI/ETL (4205)

Title: SQL Server 2019 - New Features

Abstract: In this session, we will cover the new features that are being introduced in SQL Server 2019. There will be Demos!

Speaker(s):

  • Jeff Taylor

Track and Room: DBA - DBA2 (4206)

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 - R5-Cloud (3206)

Title: How to automate row level security in Power BI using DAX and SSAS

Abstract: Power BI is a business analytics solution that lets you visualize your data and share insights across your organization or embed them in your app or website. This session is for users are who want to automate Power BI row-level security by replicating the security of another data source such as corporate ERP. Many organizations maintain tight data security within their organization. Row-level security needs to be defined within Power BI. This can be difficult if you have many users and security changes happen quite often. If you are using a corporate ERP system that has security built into it, you would end up doing redundant work of managing security at two places, in ERP as well as in Power BI. DAX query can be used to filter out rows based on user ID/user name. We will go over the demo of the entire process starting from bringing data into SSAS, creating data model, applying row level security publish the report. Never again you will have to manually manage roles within Power BI.

Speaker(s):

  • Ashwini Jain

Track and Room: PowerBI - R1-PowerBI (3102)

Title: Encrypting Data within SQL Server

Abstract: Data breaches abound! Do you want to keep your company out of the headlines? What are some of the data privacy laws affecting you? How will encrypting data affect your database performance? What data fields should you encrypt? What else can you do to protect your sensitive data?

In this session, we will review each option to encrypt data within SQL Server, Transparent Data Encryption, Cell Level Encryption and Always Encrypted. While we look at the encryption options, we will review both on-premise and cloud offerings. This session will deep dive into setting up Always Encrypted encryption and share experiences implementing the encryption.

You will leave this session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance. Also, you will gather information on how to fully protect and review your sensitive data usage.

Speaker(s):

  • Thomas Norman

Track and Room: Security - R6-MiscSecurity (4102)

Title: Data Virtualization with PolyBase

Abstract: PolyBase is Microsoft’s data virtualization technology, allowing you to integrate SQL Server with external systems such as Hadoop and Azure Blob Storage. As of SQL Server 2019, PolyBase also allows you to connect to diverse systems such as Oracle, MongoDB, Cosmos DB, Teradata, Apache Spark, and even other SQL Server instances. In this talk, we will walk through the mechanics of PolyBase, showing how we can write T-SQL queries to access data from heterogeneous sources. We will investigate the Dynamic Management Views (DMVs) and other resources needed to tease out what the PolyBase engine is doing behind the scenes and where to go when things break down. Finally, we will look at several interesting use cases for PolyBase in the modern data environment.

Speaker(s):

  • Kevin Feasel

Track and Room: Big Data/Data Science - R7-BigData/DataSci (4103)

Title: That’s So Metadata: Discover Your Database From The Inside

Abstract: Have you ever needed to learn a new database design and don’t know where to begin? Or are trying to find out why a query doesn’t perform well? Or need to provide security information to auditors or your security team?

SQL Server has numerous metadata facilities available to help you with these tasks and more. Functions, dynamic management views, and system stored procedures can illuminate details from a single column up through an entire SQL Server instance. We will demonstrate metadata techniques to help you:

  • Document your database schema objects such as procedures, functions, tables, columns and indexes
  • Investigate performance and look for bottlenecks and tuning opportunities
  • Discover metadata to administer your databases backups, index maintenance, and security
  • Apply your own metadata using extended properties

We will also cover the official Microsoft documentation on these features and other resources on how to use them.

Speaker(s):

  • Rob Volk

Track and Room: TSQL - R3-TSQL (3104)

Title: Performance Tuning for SQL Developer through Execution Plans

Abstract: Performance Tuning for SQL Developer session aims to provide essential building blocks to get starting with this challenging subject. When it comes to performance tuning the execution plan needs to be the first stop for every developer however many developers don’t know how to read and extract relevant information. When looking at execution plans in SSMS, there are many different ways of getting relevant information however it is not always simple to understand. The goal of this presentation is to provide tools and high-level overview of pertinent information to enable each developer to start optimizing their code.

Speaker(s):

  • Vladimir Oselsky

Track and Room: DBA - R2-DBA1 (3103)

Title: Building Scalable Cloud Databases

Abstract: Usually when developers and DBAs talk about scaling databases we mean ‘scaling up’ our database server to handle the increased demands of our users. But what if ‘scaling up’ isn’t the only or best answer? What if we’re building a multi-tenant SaaS application, and want to have a single front-end for each of our clients, but have multiple back-end databases to segregate customer data? In this talk, we’ll look at ways we can scale our SQL Server Databases ‘out’ instead of ‘up’. We will touch on a few database design considerations before diving into the Elastic Database Client libraries to see how we can add intelligent data-dependent-routing to our applications, ensuring that each request is routed to the correct database. Finally, we will explore how Azure Elastic Database Pools can be used to optimize our database workloads in Azure.

Speaker(s):

  • Tim Lentine

Track and Room: Cloud - R5-Cloud (3206)

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 of 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: Docker Powershell - R4-Dev/Docker (3205)

Title: What’s New in Creating Data Models and Reporting with Power BI

Abstract: Power BI has grown into a very useful and powerful tool to analyze your corporate data, but not everyone knows that it is a product that is literally changing monthly. Each month Microsoft introduces new features to the downloaded and online versions of PowerBI. Keeping up can be time consuming. However, Microsoft provides documentation, videos, and other resources to not only help you up to date with these changes, but to also allow you to vote on potential new features and even to submit new feature ideas of your own. If you have not been keeping up with the changes to Power BI since you first downloaded your desktop version a year or more ago, you need to attend this session to learn how to keep up with this ever changing, ever improving product.

Speaker(s):

  • Michael Antonovich

Track and Room: PowerBI - R1-PowerBI (3102)

Title: SQL Server is not an excuse to avoid DevOps

Abstract: Working as a DevOps consultant in the field I hear this excuse all the time: “We can’t do DevOps, we use a SQL database” Handcrafted database deployments take days and are extremely fragile. This often leads DBAs to the misconception that introducing DevOps - which naturally leads to an increased cadence in deployments - will result in DBAs doing deployments all the time and with more breakages. We will dispel this misconception by showing how DevOps automation and a little discipline allow better testing, shorter release cycles, and reduced business risk. We will also discuss some techniques and best practices for introducing DevOps for SQL Server deployments.

Speaker(s):

  • Santosh Hari

Track and Room: Developer - R4-Dev/Docker (3205)

Title: Aggregations in Power BI: How to unlock the power of big datasets

Abstract: Aggregations are one of the most important optimization methods for managing big datasets in Power BI. Combined with Direct Query storage mode, they allow big datasets to be analyzed efficiently by answering high level analytical queries quickly from memory while sending more detailed queries back to the source database.

In this session, you will learn about the concept of aggregations, different table storage modes in Power BI, different kinds of aggregation tables, how to configure aggregation tables so that they can answer high level user queries, and finally how to use tools such as DAX Studio or Extended Events to determine if the aggregations are actually being used.

Speaker(s):

  • Shabnam Watson

Track and Room: PowerBI - Misc2 (4208)

Title: Power BI for the Data Systems Administrator

Abstract: Data systems administrators pride themselves on their ability to dig deep into the weeds of their systems and get to the root of problems. However, when it comes time to explain a complex or intermittent issue, we find that others don’t enjoy those weeds. Ever wish you could draw a better picture of what’s going on? Enter Power BI! This tool is beloved by many analysts and developers but it can transform more than just OLTP data. Attend this session to learn how you can use quick models in Power BI against administrative data such as the SSRS execution log, SQL Server Extended Events, XML JSON files, query performance data, and even those random Excel files you get from vendors. You’ll leave this session with the skills you need to survey your domain from a new angle and communicate what you learn to your organization.

Speaker(s):

  • Gina Meronek

Track and Room: PowerBI - R8-PowerBI/ETL (4205)

Title: PowerBI and PowerApps Married at First Sight

Abstract: PowerBI is Microsoft’s self service reporting tool that give businesses a robust visualization of their data. As Microsoft’s Power Platform has evolved, PowerApps is taking a similar approach by providing businesses with a self service application tier. In this session we will see the power of bringing the two together. Let’s explore how the visualization tier of PowerBI can enhance the development and capabilities of PowerApps. We will go from a blank canvas app and import visualizations while pointing out some of the pros and cons of marrying the two together. We will use the capabilities of PowerApps to write and update our SQL Server tables. Bringing the two together can provide businesses with a robust solution under one umbrella. Join me in learning how these two services came together and said “I DO”.

Speaker(s):

  • Dan King

Track and Room: PowerBI - R8-PowerBI/ETL (4205)

Title: PaaSport to Paradise: Lifting Shifting with Azure SQL Database + SSIS in Azure Data Factory

Abstract: This session focuses on the all PaaS solution of Azure SQL DB/Managed Instance (MI) + SSIS in Azure Data Factory (ADF) to lift shift, modernize, and extend ETL workflows. We will first show you how to provision Azure-SSIS Integration Runtime (IR) – dedicated ADF servers for running SSIS – with SSIS catalog (SSISDB) hosted by Azure SQL DB/MI, configure it to access data on premises using Windows authentication and Virtual Network injection/Self-Hosted IR as a proxy, and extend it with custom/Open Source/3rd party components. We will next show you how to use the familiar SSDT/SSMS tools to design/test/deploy/execute your SSIS packages in the cloud just like you do on premises. We will finally show you how to modernize your ETL workflows by invoking/scheduling SSIS package executions as first-class activities in ADF pipelines and combining/chaining them with other activities, allowing you to trigger your pipeline runs by events, automatically (de)provision SSIS IR just in time, etc.

Speaker(s):

  • Sandy Winarko

Track and Room: ETL - DBA2 (4206)

Title: Introduction to SQL Server on AWS

Abstract: Are you curious about the benefits of running SQL Server on the AWS Cloud? 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 implementation. This is an audience-driven session where you can choose from a variety of topics including infrastructure, security, migration, high availability, storage, monitoring, management, backup, and recovery.

Speaker(s):

  • Tom Staab

Track and Room: Cloud - R5-Cloud (3206)

Title: SQL Server Fundamentals for Beginners

Abstract: This session is for people who are brand new to SQL Server or are looking for a review of the fundamentals of SSMS. We will review features presented in version 17.9, specifically creating tables and views; choosing data types; creating indexes, constraints, rules and triggers; creating basic queries using select, from, where, order by; simple joins; more complex queries and operators; primary key, foreign key, composite key; generating a system data diagram.

Speaker(s):

  • Harvey Hyman

Track and Room: SQL101 - Misc2 (4208)

Title: Data visualization tips for Power BI

Abstract: In this session we will cover multiple data visualization tips to create more interactive Power BI reports and dashboards. Some of the Power BI features we will cover are report pages tooltips, drillthrough filters, better use of bookmarks, SVG Measures, and many more.

Speaker(s):

  • Orlando Mezquita

Track and Room: PowerBI - R1-PowerBI (3102)

Title: In-Place vs Side-by-Side SQL Upgrades; Clearing the Confusion

Abstract: Most of us are aware that when it comes to upgrading our SQL Servers, we have a couple different options when it comes to the methodology. Do we perform an In-Place upgrade or a Side-by-Side? Both options come with a myriad of pros and cons, and there’s usually a “best” solution for every environment. This session will attempt to examine exactly which scenarios lend themselves best to each technique, and we’ll provide a logical way of thinking about this critical step and how to accomplish this with the least stress.

Speaker(s):

  • Troy Gallant

Track and Room: DBA - DBA2 (4206)

Title: How UCF IT uses Power BI to monitor our IT Services

Abstract: Curious how to monitor your IT Services using Power BI? Come see how UCF tracks our IT services to ensure our staff, students, and faculty are meeting their teaching, learning, research, and service objectives. Utilizing ITIL (Information Technology Infrastructure Library) practices, ServiceNow data, and Power BI we are able to take quantitative information and turn it into graphical visualizations to aid leadership and our customers in making informed decisions.

Speaker(s):

  • Priscilla Camp

Track and Room: PowerBI - R8-PowerBI/ETL (4205)

Title: SQL based Tools to Build a Petabyte Scale Cloud Data Warehouse and Enable M

Abstract: The role of Big Data is growing. DBAs are challenged to move large volumes of data for analytics. In this session, you will be provided a demo / walk-through of key technologies and how you can transform your analytics initiatives and your careers by leveraging Cloud Technologies. Key Topics: addressing data volume, leveraging SQL for transformations, Machine Learning using SQL. Attendees will be provided free Hands-on/Live access to run Analytics in the Cloud.

Speaker(s):

  • Jay Rajendran

Track and Room: Cloud - R2-DBA1 (3103)

Title: Cloud Essentials for the Database Professional - Hands-On Session

Abstract: With the rapid growth of cloud technologies, the role of the DBA is evolving. Data will continue to be one of the most important assets. But how we manage that data it is also evolving. We will discuss the skills needed for DBAs in the cloud with demos of the tasks performed by DBAs in the cloud. We will be using Google Cloud for the demos but the topics will apply to any cloud environment. Key Topics: VM vs Full Managed DBs, Fault Tolerance, Disaster Recovery, Performance, Security, Monitoring and Budget Management. Attendees will be provided free Hands-on/Live access to run SQL in the Cloud.

Speaker(s):

  • Jay Rajendran

Track and Room: Cloud - R5-Cloud (3206)

Title: dbatools - A PowerShell Toolkit for the DBA

Abstract: In this demo driven session you will learn how to: prepare your computer for installation of the dbatools module, install dbatools and pre-requisites, use dbatools commands to automate routine tasks such as migrating logins and jobs, setup log shipping, and add databases to availability groups.

At the end of the session, you will be able to return to your office with dbatools as a new tool in your toolkit to help you manage your SQL Server estate in a more efficient manner.

Speaker(s):

  • Jack Corbett

Track and Room: Docker Powershell - R6-MiscSecurity (4102)

Title: Getting started with Azure Data Factory Data Flows

Abstract: Azure Data Factory Version 2 (ADFv2) Data Flows is the ETL/ELT tool of choice for highly scalable data integration solutions in the cloud. Learn how to build data pipelines with complex logic using Data Flows and how to optimize read and write performance to load modern data warehouses and data lake architectures. Attendees will walk away with a basic knowledge on how to create data pipelines leveraging ADFv2 Data Flows and how to integrate other Azure services for Big Data Analytics and Machine Learning.

Speaker(s):

  • Jose Chinchilla

Track and Room: ETL - R8-PowerBI/ETL (4205)

Title: Data, Data Everywhere, a lot of it is Free

Abstract: This session focuses on the techniques to discover, retrieve, extract, import, shape, model and analyze the tons of free and interesting data available in the wild. From daily NYC subway turnstile data to coastal accident statistics gathered by the Coast Guard, this data is just waiting to be loaded into your favorite analytics tools like Power BI Desktop or Jupyter Notebooks to yield interesting and often unexpected results.

Speaker(s):

  • Rodney Landrum

Track and Room: Big Data/Data Science - R7-BigData/DataSci (4103)

Title: PowerShell Core - Intro to SQL Server Linux Container

Abstract: This session will be covering the basic of working with Containers and PowerShell Core. We’ll be taking the steps of creating a SQL Server 2019 container in Windows Subsystem for Linux. Then, taking the updated image to be loaded on another Linux system. You’ll learn how to update, save, and reload a Docker container with SQL Server for Linux. Test the connectivity to SQL Server Container using Azure Data Studio and PowerShell Core. Get started with Containers!

Speaker(s):

  • Maximo Trinidad

Track and Room: Docker Powershell - R4-Dev/Docker (3205)

Title: The SSRS 2017 Restful API

Abstract: SSRS 2017 has recently added a RESTful API to the Reporting Server, in addition to its classic SOAP interface. Using Powershell’s Invoke-RestMethod , we will explore the new API with examples for creating folders, permissions, altering Timed Subscriptions and firing them off.

Speaker(s):

  • George Walkey

Track and Room: SSRS - R8-PowerBI/ETL (4205)

Title: The Psychology of Better Power BI Reporting

Abstract: In this course we identify some common mistakes that we see in the business world using Power BI. We will identify the psychology behind the reporting techniques needed to create powerful and effective reports. The attendee will leave the class ready to write better reports using Power BI in the real world.

Speaker(s):

  • Ed Watson

Track and Room: PowerBI - R1-PowerBI (3102)

Title: Big Data Clusters for the Absolute Beginner

Abstract: Are you a DBA or data professional working with out-dated technology or feel your skills are quickly becoming irrelevant? Stay ahead in today’s ever changing tech space and take your career to the next level.

Join Mohammad Darab this session to explore the cutting-edge technology that SQL Server 2019 has to offer: Big Data Clusters.

Topics include: -Big Data Cluster architecture and its components such as: Containers, Kubernetes and the newly enhanced Polybase -Unique advantage of SQL Server Big Data Clusters -Data Virtualization, Scale-out Data Marts, and Data Hub concepts

Speaker(s):

  • Mohammad Darab

Track and Room: Big Data/Data Science - R7-BigData/DataSci (4103)

Title: How to Speak SQL

Abstract: This will be a beginner level session on SQL clauses and the key parts of a SQL statement. We will cover the main building blocks of the language with the SELECT, INSERT, UPDATE and DELETE commands. We will do a syntax breakdown of the statement structure with special focus on the JOIN clauses in the FROM statements and conditional statements in the WHERE clause.

Speaker(s):

  • Carolyn Risk

Track and Room: TSQL - R5-Cloud (3206)

Title: Test Driven Development (TDD) for T-SQL Database Development

Abstract: This session will cover the incorporation of Agile’s Test Driven Development (TDD) into traditional T-SQL Database Development. The session will show the benefits of integrating this methodology into your database development processes. These benefits would include proper unit testing as well as the prevention of introducing performance issues into production.

Speaker(s):

  • Anthony Mendoza

Track and Room: TSQL - R3-TSQL (3104)

Title: Level-up your Power BI Reports

Abstract: You’ve been working with Power BI, building fantastic reports and dashboards. Let’s take a look at some of the cool features that will help you make your reports more appealing and add more functionalities. This session is 100% demos: Shortcuts, visuals interactions, drilling down/up/through data , custom tooltips, bookmarks.

Speaker(s):

  • Cecilia Brusatori

Track and Room: PowerBI - R1-PowerBI (3102)

Title: LEAD, LAG CTE

Abstract: Query too complex and slow? Using dynamic SQL a lot? Come and see how use of new SQL Server language concepts and build-in functions can help.

Speaker(s):

  • Victor Ivantsov

Track and Room: TSQL - R3-TSQL (3104)

Title: Starting a Career in IT - Ask the Panel!

Abstract: This moderated session features a panel of IT professionals with a wide range of experience ready to answer your questions about getting started and progressing in IT. Have a question about what you can do as a student to get ready? What employers look for from those brand new to the profession? How to grow your skills and know when to look for the next opportunity? Bring your questions and we’ll answer as many as time permits. This session is focused on college students, but is open to all.

Speaker(s):

  • Andy Warren

Track and Room: SQL101 - Misc2 (4208)

Title: Master Data Services (MDS): Friend or Foe?

Abstract: No matter the complexity of your BI application, Master Data Services can provide your organization the tools needed to conform, manage and simplify your dimensions. Attend this session and learn how to unlock value MDS can bring to your analytical organization.

Speaker(s):

  • Tyler Graham

Track and Room: Big Data/Data Science - R6-MiscSecurity (4102)

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 - R5-Cloud (3206)

Title: Performance tuning with SQLGrease

Abstract: Performance tuning a production system can be a difficult process when only relying on out of the box tools. This is even more difficult if you aren’t on the most recent release of SQL Server. In this presentation I will show you some common performance problems and how SQLGrease can help tune these. Along the way I will provide details on how SQLGrease collects its data in order to give some clarity on how we monitor as well as provide some useful queries you can use even if you aren’t a SQLGrease user.

Speaker(s):

  • franklin yamamoto

Track and Room: DBA - R4-Dev/Docker (3205)

Title: Introduction to Agile

Abstract: Agile software development is more than frameworks such as Scrum, Extreme Programming or Feature-Driven Development (FDD).

Agile software development is an umbrella term for a set of frameworks and practices based on the values and principles expressed in the Manifesto for Agile Software Development and the 12 Principles behind it. When you approach software development in a particular manner, it’s generally good to live by these values and principles and use them to help figure out the right things to do given your particular context.

Join us to learn how to apply this principles in real day to day activities.

Speaker(s):

  • Ryan Conrad

Track and Room: Developer - R4-Dev/Docker (3205)

Title: DAX for Beginners - Learn the basics for Power BI

Abstract: If you want to use PowerBI, you’ll want to learn the DAX language. We will go over what, when and how to use it along with where to get help! If you are an excel person, this might be an easy shift. If you are not, then you will definitely want to understand this language if you or your teams are using PowerBI.

Speaker(s):

  • Katie Schmidt

Track and Room: PowerBI - Misc2 (4208)

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: Big Data/Data Science - R7-BigData/DataSci (4103)

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: Security - R6-MiscSecurity (4102)

Title: Linked Servers - Creating, and Using

Abstract: Linked servers in SQL have been around for a very long time, but still can cause lots of headache when configuring one for use. In this session, we will dive in the the multiple creation, security, and configuration options that can be so important to making them work successfully. In the last part, we will cover the different syntax available over linked servers and when best to use one over the other, with some real life examples.

Speaker(s):

  • Dale Sullenberger

Track and Room: TSQL - R3-TSQL (3104)

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 demos and provide more opportunities for the audience to ask questions.

Speaker(s):

  • Alexander Fleming

Track and Room: DBA - R2-DBA1 (3103)

Title: Migrate Your Database(s) with Distributed AGs

Abstract: You find yourself needing to migrate to new hardware or new operating system. If you’re running SQL Server 2016+, you’re in luck! Distributed Availability Groups (AGs) may just be the solution you want.

In this session I will explain the purpose and usages of Distributed AGs, create a Distributed AG and the associated AGs, and perform a mock data center migration.

NOTE: This session expects that attendees are already familiar with Availability Groups.

Speaker(s):

  • Elizabeth Noble

Track and Room: DBA - R2-DBA1 (3103)

Title: Data Science 101: An Introduction to Data Science Using Python

Abstract: Data is everywhere and Data Science is a very popular topic among data analysts and BI professionals. In this session, I will cover the basic data science principles and methodologies using the Python programming language. I will also present some real-world data analysis case studies using the Python libraries, such as NumPy, pandas, Matplotlib, and SciPy. This session will benefit to anyone who is looking to get started in the data science/ Data Analytics field.

Speaker(s):

  • Ganesh Lohani

Track and Room: Big Data/Data Science - R7-BigData/DataSci (4103)

Title: Performance Tuning Magic

Abstract: When the server becomes unresponsive, the performance goes down the drain and the CPUs are at 100%. You asks yourself: I wish I knew what and how to do it. – How to configure your Sql Server for maximum performance – Execution plans: what plan is chosen by Sql Server and why? – Big databases issues and solutions – Indexes or Statistics updates, what and where: Rebuild or Reorg – Sql code tricks to increase code performance – What to do when in maximum performance pain

Speaker(s):

  • Valentin Iamandi

Track and Room: DBA - DBA2 (4206)

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: DBA - R2-DBA1 (3103)

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: DBA - R2-DBA1 (3103)

Title: Machine Learning with AzureML and Microsoft Excel API

Abstract: How cool would it be, if it is possible to run a Machine Learning model in AzureML to classify or predict your business requirement and give access of it to your employees to run it every time using their most favorite tool… yes Microsoft Excel

Also, would it excite you, if you were told, the entire time to build and deploy this ML App with AzureML and Microsoft Excel is a matter of hours, with no mobile app, no website, no servers… just set, ready to go.

Join me in this exploratory session on building and deploying Machine Learning model for your business with AzureML with Microsoft Excel API.

Speaker(s):

  • Srikrishna Krishnarao Srinivasan

Track and Room: Machine Learning - R6-MiscSecurity (4102)

Title: Metadata driven Data Pipeline using ADF

Abstract: Design pattern, best practices and demo of architecting, designing and building a metadata driven data pipeline framework using ADF and Azure SQL. Dive into delta processing using watermarks, ADLS Gen 2 architecture and Azure SQL configurations for building an end to end data pipeline for ingesting, curating and staging data.

Speaker(s):

  • Soumya Banerjee

Track and Room: ETL - DBA2 (4206)

Speakers

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

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.

Jeff Taylor

Twitter: - reviewmydb

LinkedIn: Jeff Taylor

Contact: https://blog.reviewmydb.com

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

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.

Carolyn Risk

Currently working for a non profit in the insurance industry that facilitates arbitration between member companies as a BI Tester. Have over 20 years experience as a developer across several industries, manufacturing, education, medical, insurance, and non profit for companies such as Rolls-Royce Aerospace, Ameritech, and IUPUI. I consider myself a full cycle developer for both front and backend by doing the requirements gathering, the designing, the programming and the security and maintenance of the applications. I also analysis data and processes and create reports, dashboards and visuals where needed. My experience crosses several languages and platforms, including SQL, VB, HTML, SQL Server, Oracle, ASP.Net, VB.Net, and reporting.

Troy Gallant

Contact: http://www.troygallant.com

Troy has been a SQL Server professional for over 18 years, filling various roles as analyst, developer, and for the last decade, DBA. As a regular speaker at SQLSaturdays up and down the east coast, he’s taught on a multitude of topics from disaster recovery to performance tuning to professional development. Currently residing in Jacksonville once again, he just got back from two years as Sr. DBA for the EDW of a major international insurance company in New York City.

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.

Gilda Alvarez

Twitter: - @Latina_DBA

She graduated from the University of Central Florida with MIS and Computer science degrees. She has over a decade of experience in Enterprise Information Technology solutions for several Fortune 500 companies. In depth and applied knowledge of database administration with emphasis on high availability and disaster recovery solutions, security audits, database health checks, capacity planning, resource utilization analysis and enterprise database migrations. She is a big advocate of technical and leadership education in her community. She loves to spend time with her family, friends and dance Latin music.

Michael Antonovich

Twitter: - @SharePointMikeA

LinkedIn: Michael Antonovich

Contact: http://sharepointmike.wordpress.com

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

Gina Meronek

Twitter: - @equerystrian

LinkedIn: Gina Meronek

Contact: http://ginameronek.com

Gina Meronek is a Business Intelligence, Application Architecture, and IT Management professional with 18 years of experience applying the right people and tools to produce genuinely useful technology. She is dedicated to transforming data into information that solves problems via the right system architecture and interactive data visualizations. Gina has been active in the SQL PASS Community for a number of years and is passionate about sharing knowledge with other data geeks in her community. When not glorying in all that Power BI can do, she loves reading, riding her horse, or attending theater with her husband.

Harvey Hyman

Twitter: - hymanphd

LinkedIn: Harvey Hyman

Harvey Hyman is an instructor specializing in MS SQL Server at University of South Florida’s MUMA College of Business. His current research areas include software delivery, cloud architecture, IT infrastructure and data analytics/visualization. He has 25+ years of experience in the fields of law, technology, and military service. His most recent professional positions include The Library of Congress, H. Lee Moffitt Cancer Center, and Queens CUNY College. He has previously taught at St. Leo University, New College of Florida, Georgia Southern University and Florida Polytechnic University.

Tim Lentine

Twitter: - tlentine

Tim Lentine is a father, husband, technologist and software developer based in Orlando FL. He is the Director of Product Development with a small software firm that specializes in compliance software for investment management firms. Tim enjoys the craft of software development and delivering solutions that delight end users.

Sandy Winarko

LinkedIn: Sandy Winarko

Contact: https://techcommunity.microsoft.com/t5/SQL-Server-Integration-Services/bg-p/SSIS

Sandy is a seasoned Product Manager with extensive experience in the US, Europe, and Asia, combining commercial/technical responsibilities in principal/senior roles at various TMT (Technology, Media, and Telecommunications) companies, such as Microsoft/Skype/Nokia, BSkyB (British Sky Broadcasting), and CW (Cable Wireless). At Microsoft, he is currently driving the efforts to modernize SSIS (SQL Server Integration Services) on premises and in the cloud as part of ADF (Azure Data Factory).

George Walkey

Twitter: - sqlbytehd

Contact: http://insyncva.com

SQL Server DBA, Developer, IT Manager, Business Owner from the Richmond, VA USA Area Interested in pushing the limits of both hardware software and my own brain

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.

Mohammad Darab

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

LinkedIn: Mohammad Darab

Contact: https://mohammaddarab.com

Mohammad Darab is a Microsoft Data Professional, speaker and blogger with over 19 years of IT professional experience, 10+ years of that working with SQL Server. Some areas of his focus are the database engine, HA/DR, and security. He is currently an MCITP, MCP, as well as an IDERA ACE Class of 2019.

Jeff Taylor

Twitter: - reviewmydb

LinkedIn: Jeff Taylor

Contact: https://blog.reviewmydb.com

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

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.

Jay Rajendran

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

Ed Watson

Twitter: - http://twitter.com/SQLGator

LinkedIn: Ed Watson

Contact: http://sqlgator.com

Ed Watson is a Principal Data Platform Consultant for Improving Enterprises, a full-stack Microsoft consulting firm in Atlanta. Ed is a Microsoft Data Platform MVP since 2014 and like most children, Ed was born at an early age. Today, Ed specializes in the Business Intelligence stack and enjoys specializing in Power BI immensely. He currently lives in Atlanta and is active with the Atlanta MDF and Atlanta BI user groups and is an organizer for SQLSaturday Atlanta, Atlanta BI, and Pensacola.

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.

Ashwini Jain

My interests span (but not limited to) application of analytics and technology in the construction industry, supply chain management and optimization, data science, analytics, data visualization, GIS and location analytics.

Jay Rajendran

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

Victor Ivantsov

Twitter: - @victorivantsov

Senior SQL Server developer with 20+ years of experience. I have enjoyed many SQLSaturday as participant, now is my time to contribute

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.

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.

Soumya Banerjee

Advanced Analytics architect working in data, analytics and cloud space for last 15 years, consulting for many and diverse clients in multiple geographies. Skills include everything related to data - data engineering, cleansing, profiling, governance, modeling, data warehouse, data science and visualization. Implemented multiple end to end data warehousing projects on diverse platforms like SQL Server, Oracle, Teradata, Netezza, Azure DW etc. Strong experience with entire Azure data stack(Data Lake, Blob, Data Bricks, DW, Data Factory, Data Flow, AAS etc.) and many ETL products like Ab Initio, Informatica, DataStage, Talend etc.

Shabnam Watson

Twitter: - ShbWatson

LinkedIn: Shabnam Watson

Contact: https://shabnamwatson.wordpress.com/

Shabnam Watson is a Business Intelligence architect with 20 years of experience developing data warehouse and business intelligence solutions. Her work focus within the Microsoft BI Stack has been on Analysis Services and Power BI.

She is an active member of PASS community and has spoken at PASS Summit, SQLSaturdays, PASS Business Analytics and Women in Technology virtual chapters, and many other local user groups and conferences. She is one of the organizers of SQLSaturday Atlanta BI Edition.

She holds a master’s degree in computer science, a bachelor’s degree in Computer Engineering, and a Certified Business Intelligence Professional (CBIP) certification by The Data Warehouse Institute (TDWI).

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.

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.

franklin yamamoto

Twitter: - @sqlgrease

LinkedIn: franklin yamamoto

Contact: http://blog.sqlgrease.com

Franklin has spent a majority of his career working as a performance tuning consultant. While working as a consultant he saw a need for a subscription based performance monitoring solution that could live in the cloud. After four years of development this became SQLGrease. Franklin now heads SQLGrease as CEO and chief technologist. His goal is to build software capable of replacing himself so he could spend more time sailing.

Thomas Norman

Twitter: - ArmorDba

LinkedIn: Thomas Norman

Contact: https://armordba.com/

Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.

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.

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.

Dan King

Contact: http://www.rdx.com/Blog/dba_tips/2014/04/the-merge-join-transformation-and-an-ssis-sorting-tip/

My name is Dan King. Believe it or not I am a huge computer geek. I have worked in the System Admin role and for the past 9 years I have worked with RDX holding many positions. My current role is Sr. Manager of Data Analytics. I am a father of one. I love sports and I am a huge outdoors man. I have a few blogs published by my company that can be found on there website.

Elizabeth Noble

Twitter: - SQLZelda

LinkedIn: Elizabeth Noble

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

Ryan Conrad

LinkedIn: Ryan Conrad

Ryan started his career in 2011 when he joined JPMorgan Chase as part of their corporate development program for new college graduates. Spending three years working in New York City before moving back to his hometown of Orlando, Florida in 2016. His job titles have included: Business Analyst, Business Manager, Project Manager, and Program Manager. For the last two years, he’s been working for a class action administration company, headquartered in California, implementing a new software development process.

Santosh Hari

Twitter: - _s_hari

LinkedIn: Santosh Hari

Contact: https://santoshhari.wordpress.com

Santosh is a Microsoft Azure MVP and a public speaker who has spoken at tech events including codecamps and regional/international conferences. He is an Azure Consultant @ New Signature, where he leverages his broad Azure skillset with a DevOps focused approach to add more value to companies looking to migrate to the cloud or build cloud first applications. Santosh is deeply involved with the local community as leader of the Orlando .NET User Group and co-organizer of the Orlando Codecamp. Santosh was listed in TechBeacon’s DevOps Top 100 for 2018

Vladimir Oselsky

Twitter: - @VladyOselsky

LinkedIn: Vladimir Oselsky

Vladimir Oselsky (Vlady) is an IT Professional with over 15 years of experience in various IT Jobs. Born and raised in Siberia, moved to United States in late 90s. Passion for computer and programming started with DOS games and learning Borland Paschal in 8th grade as a hobby. IT career consisted of everything from hardware and software support to server administration. Current focus on SQL Server Database Development and .NET programming

Tyler Graham

LinkedIn: Tyler Graham

Over 20 years experience in Data Management 6 Years at Microsoft One of the Original Designers of SQL Server Master Data Services Author - Master Data Services -SQL Server 2008R2 and 2012 6 Years at Profisee developing Industry Solutions

Orlando Mezquita

Twitter: - orlandomezquita

LinkedIn: Orlando Mezquita

Contact: http://www.MasterDataAnalysis.com

Orlando is principal consultant and trainer at Master Data Analysis. He is a passionate analytics professional who shares his knowledge through MasterDataAnalysis.com. Orlando provides analytics training and consulting services with Power BI, Excel, R, and Minitab.

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.

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)

Jack Corbett

Twitter: - http://twitter.com/unclebiguns

LinkedIn: Jack Corbett

Contact: http://www.wisemanorwiseguy.com

JJack Corbett began working with SQL Server, Access, and VB in 1999, when he served an apprenticeship with a good friend who was the software development manager at the local paper mill. He found his niche and has concentrated on SQL Server development and administration since late 2000. He has worked with SQL Server through version 2017 and was a Microsoft Data Plaform MVP from October 2011 to October 2016.

Jack is passionate about helping companies architect, design, and develop high performance applications based on the Microsoft Data Platform. He also has a passion for seeing database developers get the core application code (the database) protected under source control.

Jack has presented at many user groups and SQLSaturday even

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.

Jose Chinchilla

Twitter: - SQLJoe

LinkedIn: Jose Chinchilla

Contact: http://www.sqljoe.com

Jose Chinchilla is an experienced data analytics professional with multiple certifications including Microsoft Certified Database Administration (MCSE), Microsoft Certified Data Management and Analytics (MCSE), and Microsoft Certified Trainer (MCT). Jose specializes in Data Warehouse and Data Lake Architecture and Development as the Data Analytics Practice Lead at AgileThought, a full-service custom software and analytics consulting firm based in Tampa, FL. Jose is a book author (SQL 2012 Bible, Professional SQL Server 2012 Administration, Exam Ref 70-767 Implementing a SQL Data Warehouse 2016) and leads the Tampa Bay BI Data Analytics PASS Chapter in Tampa, FL.

Katie Schmidt

Twitter: - k_t_schmidt

LinkedIn: Katie Schmidt

Katie Schmidt has many years experience in SQL and started in the SQL PASS community as a professional student in 2011.

Rodney Landrum

Twitter: - @sqlbeat

Rodney Landrum has been architecting solutions for SQL Server for over 15 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has co-authored 4 books on Reporting Services. He has been a regular contributor to SQL Server magazine, sqlservercentral.com and Simple-talk.com. Rodney was also a Microsoft Data Platform MVP from 2008 through 2016.

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

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.

Valentin Iamandi

Contact: http://logicalreads.wordpress.com/

Valentin brings more than 10 years of database experience in tuning, architecture, backup, large data transaction, and more. He has a solid background in database analysis and development and his skills cover SQL Server and Oracle as well as a slew of different operating systems. Valentin fluently speaks English, French, and Romanian. Valentin has a passion for performance and optimization and shares his experience on the topic in his blog http://logicalreads.wordpress.com/

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.

Rob Volk

Twitter: - sql_r

LinkedIn: Rob Volk

Contact: http://weblogs.sqlteam.com/robv/

Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.

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.

Ganesh Lohani

LinkedIn: Ganesh Lohani

Ganesh Lohani has 10 years of experience working with Business Intelligence platform and Data Analytics, with over 8 years of experience with MS BI tools and Business Intelligence processes. He is currently working for Stericycle as a senior Business Intelligence Developer. He also enjoy his evening and weekend time in providing online training, coaching and mentoring individuals who want to learn MSBI (T – SQL, SSIS, SSRS, SSAS, and Power BI ) products. He holds MSIS degree from University of Texas at Arlington.

Anthony Mendoza

LinkedIn: Anthony Mendoza

Anthony Mendoza is currently employed as a Senior Development DBA with Transfast. He has worked with SQL Server in some capacity since 1998 across various industries such as government, elections, military, financial and transportation. He holds a Master’s Degree in IT Management as well as a MCDBA MCSD.

Priscilla Camp

Twitter: - ITDataDiva

LinkedIn: Priscilla Camp

Contact: https://itdatadiva.com

Priscilla Camp is a Business Intelligence and Analytics Specialist at the University of Central Florida. She has over 9 years of experience in the field of IT working as a Business Intelligence Analyst. Priscilla started her career working for a startup small business in 2010 and several years later moved over to the Higher Education Industry where she currently resides. Priscilla’s focus is T-SQL, Data Warehousing, MS Power BI, and B.I. Strategy. She is also the Leader of the Orlando Power BI User Group.

Srikrishna Krishnarao Srinivasan

LinkedIn: Srikrishna Krishnarao Srinivasan

My name is Srikrishna. I am a Technical architect, Python, R, JavaScript developer, Data Analytics Engineer, Machine Learning, AI and Digital Transformation enthusiast, from Tampa, Florida.

I started iSrikrishna.com to give back to community by sharing experiences. My entire career so far has been on Digital Transformation. Currently I’m exploring Machine Learning and the fullstack solutions based entirely on JavaScript (read NodeJS). I have a passion for creating value from Data Analytics, use technology to create a great experience for users and an enjoyable experience in their job.

I have used AzureML for close to 100 experiments on Logistic regression, Neural Network, K-Means Clustering, NLP, Boosted Decision Tree and few more.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page