SQLSaturday #859 - Tampa 2019

Event Date: 03/23/2019 00:00:00

Event Location:

USF MUMA College of Business
12212 USF Maple Drive
Tampa, 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: Azure Data Factory + SSIS: Migrating your ETLs to the Cloud.

Abstract: Thinking about migrating your data warehouse to the cloud? What about all those SSIS packages executing ETLs against your on-prem data sources? In this presentation we will discuss how to successfully “lift and shift” your ETL workloads to the Azure cloud. You will l learn how to configure and deploy an Integration Runtime, deploy and execute SSIS packages in an Azure Data Factory pipeline, and how to monitor and troubleshoot your ETL executions in the cloud. Attendees will walk-away with an understanding of the features, capabilities and limitations of Azure Data Factory and the Integration Runtime and a strategy to leverage your existing SSIS package development efforts to the cloud.

Speaker(s):

Jose Chinchilla

Track and Room: BI Platform Architecture, Development Administration - 2305

Title: Storytelling for Machine Learning and Advanced Analytics

Abstract: Storytelling and depiction of information has existed for hundreds of years in various forms and formats. In today’s era of artificial intelligence and machine-assisted analytics, accurately interpreting and effectively communicating findings is becoming a crucial skill to bridge the growing data literacy gap. To help decision makers get the most value from analytics projects to drive better outcomes, you need to help them make sense of the results.

Machine learning and advanced analytics can be difficult to understand and explain. Describing the problem, the model, the relationships among variables and the findings are often subtle, surprising and technically complex. Effectively translating quantitative insights and telling a compelling story requires planning, compelling design, and visualization choices. Successful analytical communicators use the entire process to communicate with stakeholders. Don’t miss this fun demo-packed educational session.

Speaker(s):

Jen Underwood

Track and Room: Analytics and Visualization - 1201

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: Information Delivery - 124

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

Title: A System for Managing Career Learning

Abstract: Are you investing enough time and in right place when it comes to learning new stuff? Or do you feel like you’re spending too much time? Or, more commonly, that you’re setting goals and then falling off track? All of us struggle to manage learning while sustaining a career and family. But it IS possible! This session is designed to give you a prescriptive solution to the challenges of managing learning; identifying what you need to learn, how much time to invest in learning each topic, scheduling and tracking your learning, and recovering from the interruptions that life throws at us. My system won’t make you rich, but it will make you feel in control of your career learning goals.

Speaker(s):

Andy Warren

Track and Room: Professional Development - 2303

Title: “Past, Present and Future of the Data Profession”

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

Speaker(s):

Frank Quintana

Track and Room: Strategy and Architecture - 1301

Title: Successfully Virtualizing SQL Server on vSphere

Abstract: Today, many organizations have already virtualized most of their non critical applications, these organizations are now employing a “Virtual First” policy, harnessing the efficiency and cost savings of virtualization for their most critical applications. Still, many IT architects and DBA’s are hesitant of virtualizing their SQL workloads, they are worried about performance, scale, availability and support for what is usually considered their most critical applications. In this session we will review the guidance for successfully virtualizing critical SQL databases, we will cover the best practices, real world customer experience and what to watch out for when virtualizing the most critical SQL databases. The session is delivered by a member of the VMware’s SQL Server Experts Group.

Speaker(s):

Shawn Meyers

Track and Room: Enterprise Database Administration Deployment - 1201

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: Analytics and Visualization - 2304

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

Title: Accessibility Concerns of Reporting Style with Power BI

Abstract: Reports are no longer just black and white columns and rows of numbers. Reports combine tables with charts, KPIs and more. There is a lot to be concerned about when designing reports to provide information to your audience. Today, your company can face lawsuits if your reports are not accessible to all users. You must consider the way you display your data, the amount of data displayed, the use of color and maybe even the use of animation. Creating attractive reports is not just about making them pretty. It is about grabbing your audience’s attention. It is making sure you don’t inadvertently introduce accessibility problems that limit who can receive your message, your data. This session while looking at some reporting best practices will also give you information to steer you clear of accessibility concerns to insure access to your results by all consumers of your report. (Note: Accessibility is governed through the guidelines of the American Disabilities Act)

Speaker(s):

Michael Antonovich

Track and Room: BI Information Delivery - 1201

Title: Building Defense in Depth Using the Full Spectrum of SQL Server Encryption

Abstract: As the threat of Cybercrime and data breaches increases, it is important to know and understand the variety of options available to protect Personally Identifying Information and other business sensitive data. You need to be prepared to defend yourself from the threat of data theft by learning about and combining methods of encrypting data at rest and in transit. In this presentation, you will learn about encrypting data at rest, data in transit, securing the channels through which data is transported and other topics related to cryptography in SQL Server including details about validating certificates and preventing man in the middle attacks against your server. Other topics include an overview of replicating encrypted data and designing systems so that the DBA can’t decrypt the data. By the end of the session, you will understand how and when to use and combine every available encryption feature to design a defense in depth strategy for protecting data from escaping your network.

Speaker(s):

Michael Keleher

Track and Room: Compliance and Security - 124

Title: 14 Tips for an Effective Job Search Leveraging Recruiters

Abstract: It’s no surprise that embarking upon a job search can be a high-anxiety time. However, following an effective job search process and applying best practices when it comes to your resume and professional online marketing channels (including 5 key resume truths), working with Recruiters, always attempting the “referral route,” leveraging alerts and other strategies, etc. can help reduce frustrations and make it better. In this session, we’ll highlight our top 14 strategies to help you go from “I’m not finding jobs I’m interested in” and/or “I’m not hearing back on my resume or from Recruiters” to “it’s time to prepare for my interview!”

Speaker(s):

Erica Woods

Track and Room: Professional Development - 2303

Title: Understanding SQL Server Backup and Restore

Abstract: Everyone knows that it’s critical to have backups but it’s amazing how few people make sure those backups can be restored properly! Too many times to count, Tim has been brought in by organizations to help recover failed systems where administrators simply didn’t know how to properly restore SQL Server backups when they have to. In this session, Tim will explain the various types of backups that can be taken and demonstrate how to restore each of them. Apart from covering the common full, differential and log backups, Tim will also cover partial, file group, and COPY_ONLY backups, backing up to and restoring from a URL, backup encryption, and how to perform a hack attach for the ultimate tail log restore. There’s something here for everyone to learn!

Speaker(s):

Tim Radney

Track and Room: Enterprise Database Administration Deployment - 1201

Title: Your Interview Prep Action List - 11 To-Dos to Rock Their Socks Off!

Abstract: “I feel like I’m always the runner up or 2nd place candidate…”

The job market is fierce, and Managers are interviewing several qualified candidates. When you combine that with the fact that 92% of interviewees are highly anxious, and nerves impact their performance, and that most candidates simply don’t know how to effectively market themselves, it’s easy to see why interviewing is one of the most frustrating parts of the job search. However, we’ll teach you some tricks for preparing the right way, how to market yourself effectively, how to conduct a SWOT Analysis to guide your interview prep, provide example best practice questions to ask, share confidence building strategies and provide some favorite recommended resources and tools!

Speaker(s):

Erica Woods

Track and Room: Professional Development - 2303

Title: REAL WORLD REPORT SERVER PERFORMANCE SCALABILITY STRATEGIES

Abstract: In this session we will cover the best strategies to track and improve SSRS / Power BI Report Server performance and scalability. We will cover methods of tracking report performance through DMVs, leveraging the Report Server ExecutionLog3 catalog view, and monitoring Power BI Report Server / Reporting Services using performance monitor (perfmon), and more. We will analyze this information through T-SQL queries in SSMS and Power BI analysis.

We will discuss when to scale out the Report Server and when to focus on the reporting dataset queries that driven through report execution.

We will cover methods of isolating Report Server performance from OLTP activity and solutions to isolate expensive reports when you cannot isolate the OLTP and reporting overhead.

Finally, we will cover Reporting Services and Power BI Report Design techniques to improve report performance and scalability.

We will cover Azure Data Studio extensions, Power BI Dashboards, and examining the exec

Speaker(s):

David Pless

Track and Room: BI Platform Architecture, Development Administration - 1301

Title: Become a Power BI superstar under 1 hour !

Abstract: Power BI is Microsoft’s industry leading data analytics discovery and visualization tool that has disrupted the way data professionals interact and derive insights from their data. It is one of the most in-demand and sought-after tools to know in today’s IT career market. Join us for a fun and interactive learning opportunity to learn how to ingest, transform and visualize data from a wide variety of sources using Power BI. Learn how to create rich and interactive reports incorporating slicers, drill-down and drill-through actions. Attendees will also learn how to create, publish and share reports and dashboards for desktop and mobile consumption. Attendees will walk-away feeling like real Power BI *superstars, capable of tackling any data project in their paths! *Awesomeness may vary.

Speaker(s):

Jose Chinchilla

Track and Room: Analytics and Visualization - 2304

Title: Continuous Analytics Deployment with Azure DevOps

Abstract: DevOps lives at the fast paced intersection of developers and IT professionals. Our business partners are learning and expanding their analytics toolkit, putting more pressure on technical teams to deliver analytics at an accelerated operational cadence. I’m here to show you how to automate your production database code delivery even in large data warehouse environments.

Speaker(s):

Doug McClurg

Track and Room: BI Platform Architecture, Development Administration - 123

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

Title: Database Corruption

Abstract: Database corruption could happen to you. When it happens to you, do you know what to do? Will you realize quick enough that you have corruption? The presentation begins by talking about how to detect the corruption and the different strategies for handling unique corruption issues. Highlight of topics

Why corruption occurs?
Detecting corruption – how SQL Servers detects corruption at the page level.
Different types of corruption- e.g. False alarms, memory corruption etc.
Limitation of DBCC how to speed the DBCC process.
Undocumented DBCC commands.
Monitoring I/O errors.
Verifying backup for corruption.

Speaker(s):

Stephen Muliokela

Track and Room: Enterprise Database Administration Deployment - 2304

Title: 2017 SSIS Scale Out for HA/DR ETL

Abstract: 2016 SSIS packages can access data anywhere throughout the network, but normally run on the server they are deployed on. And if something terrible happens to that server, the manual setup of the SSISDB can be time consuming. With 2017, SSIS packages can be deployed once and run on several servers, even simultaneously. This session will teach you how to set up 2017 SSIS Scale Out packages so that your SSIS packages can now be in a Highly Available and Disaster Recovery environment.

Speaker(s):

Paul LaGrone

Track and Room: Enterprise Database Administration Deployment - 120

Title: Introduction to SQL Server Big Data Clusters

Abstract: In this session you will learn how SQL Server 2019 implements an elastically scalable storage layer that integrates SQL Server on Linux, PolyBase, Containers, Kubernetes, Spark and HDFS to scale to petabytes of data storage. You’ll get a complete explanation about the architecture for this platform, and you’ll also learn about common use case scenarios for using big data clusters.

Speaker(s):

Buck Woody

Track and Room: Advanced Analysis Techniques - 1201

Title: Stop Leaving Money On the Table – A Data Professional’s Guide to Unlocking Tax S

Abstract: Tired of paying too much in taxes? Learn how to save on your taxes by taking advantage of every credit and deduction you are eligible for. Jo Willetts will explain tax reform changes and delve into the deductions and credits you could be eligible for so you can keep more of your money come tax time.

Speaker(s):

Jo Willetts

Track and Room: Professional Development - 2303

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: BI Platform Architecture, Development Administration - 1201

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

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: BI Platform Architecture, Development Administration - 2304

Title: Thinking in SQL

Abstract: SQL is conceptually different than most programming languages. Join us for a conversation about SQL, why it’s different from traditional procedural languages, and how to effectively use this truly elegant programming language. Rather than focus on the kinds of information easily located on the Web, we’ll concentrate on how to use SQL for the tasks that it’s really good at. Beginners will get a great introduction to the style of thought that gets the most out of SQL. Experienced developers will find a good refresher and an opportunity to share their experiences with others.

Speaker(s):

Robert Hatton

Track and Room: Application Database Development - 120

Title: Making Sense of the Power BI Ecosystem

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

Speaker(s):

Dustin Ryan

Track and Room: Analytics and Visualization - 2305

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: Compliance and Security - 124

Title: Fundamentals That Will Improve Your Query Performance!

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

Speaker(s):

John Wells

Track and Room: Application Database Development - 120

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: Application Database Development - 120

Title: Powershell for DBA to day to day stuff

Abstract: Learn how easy to write powershell As being DBA Use powershell for reporting and check database status Run one powershell script for all instance and many more

Speaker(s):

Jignesh Patel

Track and Room: Other - 2304

Title: Modernize SQL with Dell Technologies

Abstract: Abstract: Dell Technologies has infrastructure platforms to Accelerate, Protect, and Modernize your SQL Server environments. SQL Server 2017/2019 coupled with advanced hardware platforms from Dell allows you to move to the next level of performance. Learn how next-gen hardware integrates directly into SQL Server.

Speaker(s):

Craig Allen

Track and Room: Strategy and Architecture - 1301

Title: SQL Server 2019 CTP 2.x - New Features

Abstract: In this session, we will cover the new features that are being introduced in SQL Server 2019 CTP 2.x.

Speaker(s):

Jeff Taylor

Track and Room: Enterprise Database Administration Deployment - 1301

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: Application Database Development - 123

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: BI Platform Architecture, Development Administration - 2305

Title: Azure Resource Management with PowerShell

Abstract: You’re company is transitioning to the Cloud. Initially, your Azure deployment was small and could be managed primarily via the Azure portal but now it spans the globe with implementations in several countries. You have too many resources to manage with the Azure portal alone. You can automate these tasks with PowerShell without being a PowerShell expert. I’m Ronald Dameron. I’m responsible for managing the resources of twelve Azure subscriptions containing hundreds of resources. I can show you how. I’ve done it.

Speaker(s):

Ronald Dameron

Track and Room: Cloud Application Development Deployment - 2305

Title: Creating a Resume for Online Submission

Abstract: Today’s hiring environment is very different from even 1 year ago. If you have applied online to jobs and have not had success this interactive session is for you. Come learn how to craft a resume to start getting results with online submissions. MOre interviews = more offers. Let’s learn how to beat the applicant tracking systems.

Speaker(s):

Suzanne Ricci

Track and Room: Professional Development - 123

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: BI Platform Architecture, Development Administration - 2305

Title: DevOps Database Obfuscation

Abstract: Database masking, obfuscation, CI, CD… What is this stuff? This is a story about how we did a complete overhaul on our development life cycle to create more outcomes for our users, resolve communication issues with the team, and provide pre-production databases for our developers through database obfuscation. We will discuss our why, our team structure, the preparation work completed, the database obfuscation process tools available.

Speaker(s):

Katie Schmidt

Track and Room: Enterprise Database Administration Deployment - 1102

Title: How To Tune A Multi-Terabyte Database For Optimum Performance.

Abstract: This session will cover how to tune a multi-terabyte database where all of the data is stored a single file, primary file group. We will look at file groups, managing indexes and moving large amounts of data.

Speaker(s):

Jeff Taylor

Track and Room: Enterprise Database Administration Deployment - 1301

Title: Hadoop 123. NoSQL, Not Only SQL SQL Everywhere

Abstract: Since the end of the previous decade, our profession has been kicked by a set of new models, technologies, and architectures that are revolutionizing our practice. I pretend to clarify the position of SQL as the LINGUA FRANCA for Data and the relational model versus the allegations of deprecation of the relational model, and the NoSQL movement presentation of SQL as a language with no future. These among others are the topics of my presentation. In this presentation, I will depict the Hadoop evolution from version1 to version 3, and its relation to legacy architectures models and in particular to SQL.

Speaker(s):

Frank Quintana

Track and Room: Strategy and Architecture - 1301

Title: Partnership Between Audit and Technology Teams

Abstract: Quick Introduction and Agenda Overview Roles and Responsibilities Audit and Compliance Teams Data Owners and Technology Owners Tips for Successful Collaboration Framing the Audit or Assessment Agreed Upon Findings Responding to Inquiry Partnering with Compliance and Audit Teams Questions and Contact Info

Speaker(s):

Martina Tesar

Track and Room: Compliance and Security - 124

Title: How to make a SQLSaturday Presentation

Abstract: Nearly everyone one who attends a SQLSaturday has something to share, which others can learn from. This session covers how to take your knowledge and ideas and turn them into a presentation. Most of the focus will be on content generation and organization of your idea into a presentation and demonstrations, to allow you to present.

Speaker(s):

Shawn Meyers

Track and Room: Professional Development - 2303

Title: Using Powershell to Document SQL Server

Abstract: Most DBAs use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects. Even using Visual Studio and Database Projects, not all objects are exported because they live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, Server Triggers and much more

Speaker(s):

George Walkey

Track and Room: Enterprise Database Administration Deployment - 124

Title: Women in IT . A survival kit.

Abstract: My journey of survival and overcoming discrimination, harassment, divorce, layoffs , single mothering and death . Independent of any industry women share many struggles, but it is more difficult when you try to do in an industry dominated by men. I will be sharing my experiences and tools to grow in your personal and professional life.

Speaker(s):

Gilda Alvarez

Track and Room: Professional Development - 123

Title: Introduction to IoT using Azure

Abstract: Ever wondered on what is the buzz about Internet of Things (IoT)? and interested in making your own? We will take an look on what is Internet of Things (IoT), the impact of IoT to the world, industries that IoT can disrupt and then, we will provide an overview of building an IoT solutions using various technologies in Azure such as IoT Hub, Functions, Stream Analytics, Power BI, and more.

Speaker(s):

John Wang

Track and Room: Strategy and Architecture - 123

Title: Tracking Change is the Backbone of Your Data Platform

Abstract: Features and concepts like Change Tracking, Change Data Capture, Temporal Tables, and other similar delta systems are complex and may carry a stigma or misapprehension in your organization around performance or security or cost. Even if you do not directly implement these features or methods absolutely, most information systems rely on tracking changes especially from legacy line of business applications. I’m here to show you robust techniques for implementing delta systems in SQL Server to increase the trustworthiness of your data warehouse. I will also steer you away from common pitfalls.

Speaker(s):

Doug McClurg

Track and Room: BI Platform Architecture, Development Administration - 1102

Speakers

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

Shawn Meyers

Twitter: - 1dizzygoose

LinkedIn: Shawn Meyers

Shawn Meyers is a Field CTO working at Tintri. Shawn has worked in IT for 25+ years and specifically with SQL Server for 20+ years, beginning with version 6.5. A frequent speaker at many events including PASS Summit, VMworld, VMUGs, Virtual Chapter sessions, and many SQLSaturday events. Current focus is on improving DBAs lives with better infrastructure.

David Pless

Twitter: - @dpless

Contact: http://blogs.msdn.com/b/sql_pfe_blog/

For the past nine years, I have been a Technical Solution Professional with Microsoft. As a TSP I conduct full training workshops, conduct demo sessions, and perform architectural reviews on all supported builds of SQL Server. I mainly support the Southeast focusing on Florida, but I can be anywhere in the world.

My core areas are Performance Tuning and Optimization, Azure, AlwaysOn, Reporting Services (SSRS), custom monitoring, building custom dashboards, and more.

Martina Tesar

I’ve been in the technology space in the Tampa Bay Area for over 20 years starting with Salomon Brothers (through various mergers to Citigroup). In 2007 I joined the IT Team at Publix Supermarket’s focusing on IT Compliance, then moving into management in the Identity and Access Governance area. In 2018, I joined Jackson Hewitt as the IT Compliance Program Manager.

Suzanne Ricci

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

LinkedIn: Suzanne Ricci

With a passion for technology and education, Suzanne established LaSalle Computer to fill a market need for an adult learning center with a focus on high-quality, hands-on training and high-level customer service. By age 27, she had purchased and sold, for a profit, a second school while still growing and leading LaSalle.

A life-long student with a deep dedication to education and continuous improvement, Suzanne was able to lead and grow LaSalle to become a successful acquisition by the second largest private equity firm specializing in the knowledge sector. With a love of helping others she established Computer Coach to continue to help IT and business professionals find career success through strategic career plans.

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!

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.

Michael Keleher

Twitter: - @makeleher

LinkedIn: Michael Keleher

Michael Keleher is a Microsoft Certified Professional and is currently the Database Administrator at Bisk Education, Inc in Tampa, Florida. He has over twenty years of experience working in all areas of the Software Development Life Cycle plus another three as a Database Administrator. He enjoys getting involved in security and performance tuning projects.

Tim Radney

Twitter: - @tradney

LinkedIn: Tim Radney

Contact: http://www.timradney.com

Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.

Doug McClurg

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

LinkedIn: Doug McClurg

Doug McClurg is the principal and founder of SOSRA Inc., an analytics leadership company. He brings both military and corporate experience to organizations who want to build or accelerate their analytics program. Doug has been building tailored Microsoft SQL Server solutions for many years. He brings deep knowledge of modern information architecture to projects ranging from innovating the traditional data warehouse to capturing WiFi presence and machine data to democratizing corporate analytics. He has served as a leader, mentor, and architect to teams in Government, Oil Gas, Hospitality, and Retail.

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.

Jen Underwood

Twitter: - @idigdata

LinkedIn: Jen Underwood

Contact: http://www.jenunderwood.com

Jen Underwood is a Senior Director at DataRobot. Over the past 20 years, Jen has held worldwide product management roles at Microsoft and served as a technical lead for system implementation firms. She has a unique blend of product management and “hands-on” experience in data warehousing, reporting, visualization, and advanced analytics. In addition to keeping a constant pulse on industry trends, she enjoys digging into oceans of data to solve complex problems with machine learning.

Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego.

Paul LaGrone

Paul is currently in his fourth year as the ETL Manager for a local CRM software firm. Paul’s database work dates back to early database platforms like Dbase III and has worked with every version of SQL Server since SQL 7.0 was introduced. His certifications include MCSE, MCDBA, and MCT. Along with holding a DBA job for the City of Fort Worth, Texas, he also taught T-SQL Intro and Advanced classes to several departments and the North Texas GIS community. In 2006, he founded and ran the Greater Fort Worth SQL Server group for three years, which still continues today. While moving data and other SSIS tasks are Paul’s responsibility now, he has also been a Production DBA, worked heavily in the GIS database co

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.

Robert Hatton

LinkedIn: Robert Hatton

Contact: http://www.RobertJHatton.com

Rob Hatton is the author of the Business Intelligence Team Handbook.

Rob is also a past president of the PASS Business Intelligence User Group here in Tampa. He is a veteran B.I. developer with more than 30 years of database experience and dozens of successful B.I. project deployments.

Erica Woods

Twitter: - ericawoodsgo

LinkedIn: Erica Woods

Contact: https://www.mssqltips.com/sqlserverauthor/128/erica-woods/

Erica Woods is the Manager of Contractor and Community Relations at Apex Systems, a national IT Staffing and Services firm. Her focus is on program management, training and development, customer relations, community evangelism and corporate social responsibility, communications, marketing and social media. She has 10 years of IT staffing, an MBA from Loyola University, is an Author at MSSQLTips, and runs a group called Techies for Good.

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.

Shawn Meyers

Twitter: - 1dizzygoose

LinkedIn: Shawn Meyers

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.

Dustin Ryan

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

LinkedIn: Dustin Ryan

Contact: https://sqldusty.com

Jignesh Patel

Twitter: - @jigneshswami

LinkedIn: Jignesh Patel

Learning about SQL Server database administration last 7 years

Erica Woods

Twitter: - ericawoodsgo

LinkedIn: Erica Woods

Contact: https://www.mssqltips.com/sqlserverauthor/128/erica-woods/

Craig Allen

Twitter: - @msftdude

LinkedIn: Craig Allen

Contact: http://www.msftdude.com

Craig Allen is a Dell EMC mSpecialist (Microsoft Specialist). His role as a technical consultant is to help customers in understanding Dell EMC’s products for the Microsoft platform. Craig can assist in the initial planning and evaluation of Dell EMC’s Proven Solutions for Microsoft, including requirements gathering, architectural guidance, and integration considerations. 　 Craig is located in Dallas, TX and comes to Dell EMC with 25 years of experience in IT.

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.

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

Michael Antonovich

Twitter: - @SharePointMikeA

LinkedIn: Michael Antonovich

Contact: http://sharepointmike.wordpress.com

Doug McClurg

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

LinkedIn: Doug McClurg

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.

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.

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.

Stephen Muliokela

LinkedIn: Stephen Muliokela

I have been a DBA for many years now and currently hold multiple SQL Server certificates. In addition, I am also a Six Sigma Blackbelt.

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.

Jeff Taylor

Twitter: - reviewmydb

LinkedIn: Jeff Taylor

Contact: https://blog.reviewmydb.com

Frank Quintana

Twitter: - Frankqr2

LinkedIn: Frank Quintana

Contact: http://www.businessintelligencematters.us

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

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

Frank Quintana

Twitter: - Frankqr2

LinkedIn: Frank Quintana

Contact: http://www.businessintelligencematters.us

Ronald Dameron

Twitter: - @RonDBA

LinkedIn: Ronald Dameron

Contact: http://RonaldDameron.com

Ronald Dameron is The Only DBA at a small software company building planet-scale mobile resource management software.

He has over 20 years IT experience on a variety of platforms. His current interests are Azure, PowerShell, SQL Server 2016 and Linux.

He was a PASS Summit 2015 Speaker Idol contestant and has spoken at SQLSaturday Tampa, Orlando, South Florida, and the Tampa and Orlando SQL User groups. He has recently earned the Competent Communicator Award from Toastmasters International.

He is most active on Twitter as @RonDBA.

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.

Jose Chinchilla

Twitter: - SQLJoe

LinkedIn: Jose Chinchilla

Contact: http://www.sqljoe.com

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.

Jo Willetts

Jo is an Enrolled Agent and what you might call a Tax Geek. She started in the tax industry as a tax preparer and over the past 30 years worked her way to the role - Director of Tax Resources for Jackson Hewitt. From showing self-employed people all the tax credits and deductions they should consider to solving complicated tax issues for experienced preparers, Jo loves helping everyone with all things tax-related.

John Wells

Twitter: - @SQLServerDBA318

LinkedIn: John Wells

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

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

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.

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.

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

Andy Warren

Twitter: - @sqlandy

Contact: https://sqlandy.com

Buck Woody

Twitter: - BuckWoodyMSFT

LinkedIn: Buck Woody

Contact: http://buckwoody.wordpress.com/

Born helpless, naked, and unable to provide for himself, Buck Woody overcame these amazing handicaps to become a software developer, data professional, teacher, and a productive invertebrate member of society.

SQLSaturday #859 - Tampa 2019

Sessions

Title: Azure Data Factory + SSIS: Migrating your ETLs to the Cloud.

Title: Storytelling for Machine Learning and Advanced Analytics

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

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

Title: A System for Managing Career Learning

Title: “Past, Present and Future of the Data Profession”

Title: Successfully Virtualizing SQL Server on vSphere

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

Title: Constraints are the Key (to Data Integrity)

Title: Accessibility Concerns of Reporting Style with Power BI

Title: Building Defense in Depth Using the Full Spectrum of SQL Server Encryption

Title: 14 Tips for an Effective Job Search Leveraging Recruiters

Title: Understanding SQL Server Backup and Restore

Title: Your Interview Prep Action List - 11 To-Dos to Rock Their Socks Off!

Title: REAL WORLD REPORT SERVER PERFORMANCE SCALABILITY STRATEGIES

Title: Become a Power BI superstar under 1 hour !

Title: Continuous Analytics Deployment with Azure DevOps

Title: Temporal Tables: Creation, Use, and Optimizing

Title: Database Corruption

Title: 2017 SSIS Scale Out for HA/DR ETL

Title: Introduction to SQL Server Big Data Clusters

Title: Stop Leaving Money On the Table – A Data Professional’s Guide to Unlocking Tax S

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

Title: What Is Clogging Your Database Performance?

Title: The SSRS 2017 Restful API

Title: Thinking in SQL

Title: Making Sense of the Power BI Ecosystem

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

Title: Fundamentals That Will Improve Your Query Performance!

Title: How to Speak SQL

Title: Powershell for DBA to day to day stuff

Title: Modernize SQL with Dell Technologies

Title: SQL Server 2019 CTP 2.x - New Features

Title: SQL Server Fundamentals for Beginners

Title: Why You Should Consider Implementing Indexed Views

Title: Azure Resource Management with PowerShell

Title: Creating a Resume for Online Submission

Title: Building a Data Warehouse from the Ground Up

Title: DevOps Database Obfuscation

Title: How To Tune A Multi-Terabyte Database For Optimum Performance.

Title: Hadoop 123. NoSQL, Not Only SQL SQL Everywhere

Title: Partnership Between Audit and Technology Teams

Title: How to make a SQLSaturday Presentation

Title: Using Powershell to Document SQL Server

Title: Women in IT . A survival kit.

Title: Introduction to IoT using Azure

Title: Tracking Change is the Backbone of Your Data Platform

Speakers

Sponsors