SQLSaturday #890 - Austin 2019

Event Date: 07/13/2019 00:00:00

Event Location:

St. Edwards University
3001 S Congress Ave.
Austin, Texas

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: SQL DevOps Simplified with Production Databases

Abstract: DevOps is based on building an application binary (immutable artifact) that supports a highly reliable, repeatable engineering process. In the case of SQL Server, however, a database is already in production and isn’t simply replaced (as an app binary), but is upgraded. Current SQL Server DevOps methods use source control to build a “development” database, with schema and objects and static data needed for functional testing. “Near production data” is used in Staging, and finally production is upgraded. This approach involves complexity, and breaks the principle of working with immutable artifacts throughout the process. Our session introduces a new approach to SQL Server DevOps, with production databases used in all stages. Production database clones are delivered more quickly than “built” databases, are more easily integrated with source control, and produces higher fidelity outcomes. Learn how leading enterprises are simplifying SQL DevOps.

Speaker(s):

Paul Stanton

Track and Room: DevOps - 211

Title: The SQL Career Roadmap for Women (and Men)

Abstract: The ideal way to become a SQL Server professional is to get a degree, get a junior position, and then work your way up. But, the vast majority of data professionals don’t follow this path! Instead, most of us start out as “accidental DBAs” and fumble our way into a full time data career. This is not ideal, and we could all use some help navigating through resumes, job hunting, interviews, and negotiating. You’ll learn about all that in this session. We will also talk about how to get around a big obstacle for both women and men: how to get back to work after a long period of not working. How can I get a database job with no experience? What’s the best way to learn the newest technology? What resources are out there? Bring your questions, and we’ll explore the answers.

Speaker(s):

Jennifer McCown

Track and Room: Career - 104 Closed Caption

Title: Successfully Migrating Existing Databases to Azure SQL Database

Abstract: First impressions have long-lasting effects. When dealing with an architecture change like migrating to Azure SQL Database the last thing you want to do is leave a bad first impression by having an unsuccessful migration. In this session, you will learn the difference between Azure SQL Database, SQL Managed Instances, and Elastic Pools. How to use tools to test migrations for compatibility issues before you start the migration process. You will learn how to successfully migrate your database schema and data to the cloud. Finally, you will learn how to determine which performance tier is a good starting point for your existing workload(s) and how to monitor your workload over time to make sure your users have a great experience while you save as much money as possible.

Speaker(s):

John Sterrett

Track and Room: Azure - 203 Closed Caption

Title: The Master Stored Procedure Workshop: Part 2

Abstract: Your job includes designing and writing stored procedures, but you haven’t had a lot of actual training on the subject, right? I will show you how to write stored procedures from scratch, using the design advice I’ve accumulated in my 20+ years of experience. Here are a few of the things you’ll learn: When and how to use stored procedures The benefits and basics of contractual programming How to write stored procedures from scratch How to structure and organize stored procedures Key techniques for ideal stored procedure management Troubleshooting and debugging stored procedures The session will be packed with tons of code examples, with plenty of labs to reinforce key concepts. Beginner and experienced T-SQL programmers both will walk away with a greater understanding of how to design, manage, and troubleshoot stored procedures. Join mefor one fun session of SQL Server programming!

Speaker(s):

Sean McCown

Track and Room: SQL Dev - 104 Closed Caption

Title: Advanced T-SQL Development with latest features.

Abstract: In the last releases, SQL Server development was enriched with new T-SQL features, such as CTE (common table extension), array of Ranking and Windowing functions (ROW_NUMBER, RANK, DENSE_RANK, TILE), MERGE statement, OUTPUT clause, EXCEPT and INTERSECT just to name a few. For various reasons some DBA/Developers do not utilize these new features. In this session, the audience will see demonstrations of the different practical use cases where these features can make T-SQL coding more efficient. This 100% code-based demo session highlights efficiency to utilize the latest T-SQL functions over conventional methods with the same functionality. The session will cover in depth live scenarios where these features have proven performance efficiency, code re

Speaker(s):

Alex Grinberg

Track and Room: SQL Dev - 116

Title: The Master Stored Procedure Workshop: Part 1

Speaker(s):

Sean McCown

Track and Room: SQL Dev - 104 Closed Caption

Title: Overcoming Challenges with Source Control and Continuous Integration.

Abstract: Have you tried implementing source control? How has your continuous integration (CI) process gone?

This session is for developers, database administrators, database engineers, and data architects that want to automate their database deployments. Particularly for those individuals that have hit roadblocks along that way. We will discuss the differences between migration and stated-based deployment methods. We will also discuss options with branching and merging.

At the end of the session, attendees will know how to select the best deployment method for their environment. In addition, attendees will be familiar with branching and merging strategies that can be used as part of their continuous integration strategy.

Attendees should be familiar with general concepts about source control and be comfortable with Visual Studio or VS Code.

Speaker(s):

Elizabeth Noble

Track and Room: DevOps - 116

Title: Make Database Documentation your Minion

Abstract: Most IT folks aren’t a fan of writing documentation. We are far more interested in creating solutions, solving problems, and making things go faster, than in documenting how we did it. But, Future Us will need to know what Today Us meant with this procedure’s parameters, and what that job is even for. Coworkers will thank us for explaining choices made for design, development, and admin. How can we do this without a big Word document? T-SQL comments are simple and natural to create, and can reduce your future troubleshooting time by ten times or more! In this session you’ll learn innovative options for documenting using comments, like using expanded flower boxes, headers, “extended commenting” (also known as help systems), and more. We’ll also talk about the options available for non-comment-able objects: tables, SSIS packages, and SSRS reports. Documenting via comments serves YOU. They’re your repository of tribal knowledge, your exobrain, and your minion. Come learn all about it

Speaker(s):

Jennifer McCown

Track and Room: SQL Dev - 203 Closed Caption

Title: Managing Excel Power Query With VBA

Abstract: In this demo-rich session, we will show how VBA can be utilised to create and manage Power Query queries within Excel, using Excel functionality and external files, all without using Power Query directly. The Power Query UI is used to validate that queries and functions are bona-fide. We start by building a query from within Excel VBA to demonstrate the capability and functionality available to the developer. Then we will show how to manage a library of Power Query functions using this VBA technique, demonstrating the usage of one of these functions. Time permitting, we will go on to show how we can extend this technique, taking a multi-company dataset and splitting it into multiple queries, building a template query that can be used to create the multiple queries. All of this will be done without using the Power Query UI, nor even opening Power Query. It is assumed that delegates will be familiar with VBA and Power Query, using the Power Query UI, basic M, and Power Query functions.

Speaker(s):

Bob Phillips

Track and Room: BI - 214

Title: Introduction to Linux for SQL Server Professionals

Abstract: SQL Server is now available on Linux but you only know Windows, now what? During this session we’ll introduce the Linux version of Windows commands you use on a daily basis for administering SQL Server. We’ll look at updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another. We’ll also look at default file locations for SQL Server and what can be moved and how to accomplish that.

Speaker(s):

Jay Falck

Track and Room: DBA - 117

Title: The True Story of Learning Biml

Abstract: How do you learn Biml when you don’t have years of SQL experience? Is Biml even worth my time and energy when I’m still working on perfecting my SSIS skills? It seems like a lot of work, what is in it for me?

In this session you will learn: Why Biml is worth your time and effort. How to identify ideal SSIS packages for conversion. How to convert those packages into Biml. How to troubleshoot your Biml build errors when Google fails you. How to automate SSIS package creation with BimlScript.

Speaker(s):

Melissa Stein

Track and Room: BI - 215

Title: Adopting a Compliant Database DevOps Process

Abstract: Presented by Redgate

DevOps is transforming software development, with many organizations and individuals adopting lean development practices, implementing Continuous Integration (CI), Continuous Deployment (CD), and performing on-demand deployments to their production environments. However, the database is largely ignored and seen as a bottleneck for a DevOps software development process. We will discuss the challenges of database development and deployment and examine why many developers find the database to be an impediment. We examine the risks of sensitive data in the development process and how you can ensure that data security concerns do not get in the way of the need for speed and agility. We’ll look at how you can adopt a Compliant Database DevOps approach that removes the database bottleneck while ensuring compliance with regulations governing the use of data within your organization such as GDPR, HIPPA or SOX. We’ll discuss the techniques used to include the data

Speaker(s):

Steve Jones

Track and Room: DevOps - 116

Title: Code Like a Pirate … Intro to R and Data Science Tools in MS

Abstract: R is the most popular statistics language used today. It is one of the most useful tools in the data scientist’s tool belt. It is also integrated into the MS stack in tools like Azure ML, SQL Server and Power BI and can be used to take your data analytics to the next level.

Come to this session to get an introduction to the R language including:

installing and Configuring R and RStudio
RStudio Overview and Debugging
how to Access and Manipulate Data
install and Manage Packages
create and Use Variables
control Flows
functions
basic Graphing and Statistical Analysis.

We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.

The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!

Speaker(s):

Jamey Johnston

Track and Room: BI - 214

Title: Python in SQL Server 2017 and 2019

Abstract: SQL Server 2017 and 2019 have arrived, bringing with them a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let’s get started!

In this introductory session we’ll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We’ll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We’ll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we’ll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!

Speaker(s):

Chris Hyde

Track and Room: BI - 215

Title: Your SQL Servers are Mi$ConFiguReDed

Abstract: Your SQL Servers are misconfigured!

And it is probably not your fault.

90% of the SQL Servers I have seen in my 18 year career are just wrong. Not “crash” or “won’t start” wrong. More like “why is the website so slow” wrong.

We are going to roll through a clean install and look at some things that can be made right during the install. And then we will look at some configurations that can only be done after the install.

Things like: · Instant File Initialization · Backup Compression · MAXDOP · TempDB configuration · Cost Threshold for Parallelism · And more if we have time!

Fair warning…I’m going to overuse the phrase “It Depends”

Dallas DBAs is dedicated to helping you find these issues, test them, remediate them and get the most stability, reliability and performance out of your SQL Server.

Speaker(s):

Kevin Hill

Track and Room: DBA - 117

Abstract: Users will learn the best practices for collaborating in the Power BI web service. We’ll review apps vs workspaces, sharing reports with non-Pro accounts, setting up email alerts for your favorite reports, Sharepoint collaboration, and more! This session is all about the Power of teamwork in Power BI!

Speaker(s):

DeNisha Malone

Track and Room: BI Information Delivery - B

Title: Querying Semistructured Data in Azure Data Lake with USQL

Abstract: Data is exploding across enterprises. Much of it is semi-structured junk. Or is it junk? What are you going to do with it until you can find out? Microsoft’s Azure Data Lake is a cloud storage and analytical service for parking a variety of data. I have stored in Azure Data Lake Store several gigabytes of US Census data at a reasonable rate per month. Now I can query that semi-structured data using an ANSI SQL language called U-SQL. In this session I will demonstrate the similarities and differences between U-SQL and T-SQL. I will demonstrate how easy it is to build a query against 21 GB of CSV files. Such queries can help you determine whether you have a gold mine in your data or a bunch of garbage before investing in a full data warehouse build.

Speaker(s):

Russel Loski

Track and Room: Azure - 216 Closed Caption

Title: A Primer on SQL Server Clustered Index Architecture

Abstract: How often when creating a new table you just made the Clustered Index using an Integer column with Identity properties. Seems like that is all I have done for last many years. But, in the last two years I’ve really dove into indexes and finally with this presentation looked at what really makes a good Clustered Index with benchmarks and varying scenarios. In some scenarios a well-defined clustered index may out perform a covering non-clustered index. Results are very interesting and may surprise you.

Speaker(s):

Mike Byrd

Track and Room: Performance Tuning - 214

Title: An Animated Look at Query Plans

Abstract: You’ve looked at query plans and done some tuning, but you’re not sure what’s going on underneath. Hash Match? Merge Join? Watch both come to life in animations, and more! See (not just hear) the inner workings of a plan, and learn about the details that matter for performance. When plans make sense, tuning will become easier, and maybe even fun!

Speaker(s):

Forrest McDaniel

Track and Room: Performance Tuning - 215

Title: Not All Data is Relational: An introduction to Cosmos DB

Abstract: In this session we will talk about the pros and cons of using a non-relational database and where it might fit best into your applications. We will then demonstrate these concepts using Cosmos DB. Azure Cosmos DB is Microsoft’s globally distributed, multi-model database service. Cosmos DB enables you to elastically and independently scale throughput and storage across any number of Azure regions worldwide. You can also take advantage of fast, single-digit-millisecond data access using your favorite API including SQL, MongoDB, Cassandra, Tables, or Gremlin.

Speaker(s):

Shawn Weisfeld

Track and Room: Azure - 216 Closed Caption

Title: Performance Tune like a Microsoft MVP

Abstract: The life of a DBA is evolving and your tuning skills should always be sharp. Tuning is one of the key components of a great DBA and developer. In this demo rich session we’ll deep dive into performance tuning for On-Prem, PaaS, and IaaS. We’ll discuss tips and techniques for troubleshooting bottlenecks and how to remediate them for hardware, OS, and the database.

Speaker(s):

Daniel Janik

Track and Room: Performance Tuning - 211

Title: Managing the mystery database

Abstract: As database administrators, we often are responsible for managing large amounts of databases so it can be difficult to understand who or what is using each of them and why. Yet we are responsible for making sure these databases are backed up, secure and cared for. As well as, we are responsible for leading projects such as upgrades and migrations where this information becomes relevant. If application owners and documentation exist, we can certainly utilize that, but what if it doesn’t or information is limited. This session will look at tips and tricks you can do to figure out what these mystery databases are so you can make better decisions on them.

By figuring out what these mystery databases, you will be more equipped to make decisions on things several items such as the following: • Decommissions • Lower resource allocation and costs (especially for storage) • Better planning for database migrations • Troubleshoot connection issues • Better planning for SQL upgrades

Speaker(s):

Dustin Dorsey

Track and Room: DBA - 117

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. This session is about 60% demos and yields some surprising results.

Speaker(s):

Mike Byrd

Track and Room: Performance Tuning - 203 Closed Caption

Abstract: Do you have a solid social media marketing plan for 2019-2020? Are you sitting on the sidelines paralyzed at the thought of creating engaging content every day for Podcasts, Blog Posts, Twitter, Instagram, Instagram Stories, Instagram TV, Facebook, Linkedin, Twitch, YouTube and SnapChat?

In this session, you will learn the 7.5 steps to create a never-ending fountain of meaningful and engaging content across all social media channels. You will gain actionable insight on how to connect with your community as we analyze how RedBull, Buffer, Virgin and Charity Water connect with their communities.

At the end of the session, you will be equipped with the tools, resources, and energy-efficient shortcuts to create a custom and scalable marketing strategy.

Speaker(s):

Peter Doyle

Track and Room: Career - 214

Title: Annoyed with a stubborn pivot table? PowerPivot is your answer.

Abstract: This session is for you if you’ve ever built an amazing data set that was everything you needed, but then you went to create a dashboard, you got annoyed by any of the following:

-Your boss won’t approve the costs to get PowerBI Desktop. -You’re not a coder, so learning R or Python sounds super scary -You add a whole bunch of columns to your data set and now your file size is gargantuan -You add a field to a pivot table and the grand total row makes no reasonable sense -Your average between two dates is 2.6166666667; how many hours and minutes is that? -You add a date field to a pivot table and the month names get sorted alphabetically -You add a graph to your dashboard, but have to add a table that will be hidden from a user later -The two new pivot tables make your dashboard looks out of whack

Providing an overview of the above, the demos will give an insight into how powerful PowerPivot, PowerBI, and DAX can be. I’ll provide cool tricks and new ideas on what to search

Speaker(s):

Toni Haag

Track and Room: BI - 215

Title: Tuning Like CSS: With These Tools There’s No Need Call Support

Abstract: What do you do when you have a performance or troubleshooting problem that you can’t figure out? One option is to open a support ticket with Microsoft Support (CSS). The CSS engineer will use a specific set of tools to collect and analyze workload data from your SQL Server. Based on this information they might recommend patches, configuration changes, or identify the worst-performing queries. But what if you could bypass support and do all of this analysis yourself? In this session, you’ll learn how to use battle tested tools to analyze your workload and error logs. Armed with this information, you’ll understand the root cause of the problem and propose solutions to performance and stability problems.

Speaker(s):

Kerry Tyler

Track and Room: Performance Tuning - 211

Title: CosmosDB is the missing piece to your Data puzzle!

Abstract: You have been hearing about Azure CosmosDB but you haven’t had a chance to explore it. In this session, you will learn the key concepts of Azure Cosmos DB. I will use many analogies to explain advantages and limitations of Azure CosmosDB. By the end of this session, you will be able to setup CosmosDB and know its available tools.

I will cover the following topics in this session Why do we need another database system? How to setup Azure CosmosDB How to create database and containers. How much does it cost? Multi-Model Apis CosmosDB vs SQL Server How to Import Data into CosmosDB How to use Cosmos DB Emulator CosmosDB Limitations

Speaker(s):

Hasan Savran

Track and Room: Azure - 216 Closed Caption

Title: SSIS Performance Tuning with BimlScript

Abstract: You may heard that Biml can automate ETL loads, but what if your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we’ll discuss how to use BimlScript to accomplish the following: – Dynamically create multiple SISS packages for a data warehouse ETL load, each following a different best practice design pattern. – Automatically execute each package multiple times and record the results for analysis. – Determine which package version should be used in production. The only way to be sure that your SSIS packages are performing optimally is to test them against multiple patterns. Make your life easier and let BimlScript do the work for you.

Speaker(s):

David Stein

Track and Room: BI - 117

Title: Using Oracle GoldenGate to Replicate SQL Server Data

Abstract: Some people think of Oracle and SQL Server as mutually exclusive. In my experience many SQL Server customers use Oracle products to enhance their SQL Server databases because of replication challenges as well as enhanced security. Some of Oracle’s products, such as Oracle GoldenGate, Oracle GoldenGate Veridata, Database Firewall and Audit Vault can greatly enhance Microsoft SQL Server.

This presentation covers the basics of what Oracle GoldenGate is, how it works with Microsoft SQL Server and a few case studies on how it has enhanced some large SQL Server installations. GoldenGate is a heterogeneous replication project. It can be used to migrate data between various databases as well as different versions of the same database product. It can be used for database upgrades and migrations, loading data warehouses and data lakes and a number of other purposes. This presentation will introduce you to Oracle GoldenGate, its uses and how to use it.

Speaker(s):

Edward Whalen

Track and Room: DBA - 117

Title: Azure Databricks (ADB) and the Traditional DBA

Abstract: As more data services come online in Microsoft Azure, DBAs are being tasked with bringing these services into their organizations. Azure Databricks is one such service that has the appeal of combining scalable compute resources with collaborative development and analytic tools in Notebooks and workspaces. To the traditional DBA, however, many of the concepts and language support may be foreign. What the heck is Scala anyway? This session is designed to introduce the DBA to the Azure Databricks workspace and show how to easily integrate it with upstream and downstream services like Azure Data Factory and Machine Learning.

Speaker(s):

Rodney Landrum

Track and Room: Azure - 216 Closed Caption

Title: A Perfect Ten: The Data Model

Abstract: Do you know what makes a great data model? What does it mean to be Third Normal Form or a Star Schema? When would you use one over the other and why? How can you identify bad designs? In this presentation you will be exposed to good and bad models and learn what you should do in order to create a perfect ten model of your own!

Speaker(s):

Leslie Andrews

Track and Room: BI - 214

Title: XML and JSON, does the DBA need it?

Abstract: This session explains internal SQL Server XML processes and demonstrates how XML shredding could help to solve issues, speed up daily performance monitoring and detect problems. The difference between XML and JSON will be demonstrated, with an in-depth look at the SQL Server - JSON integration. During the session, the audience will be provided with plenty of code examples.

Speaker(s):

Alex Grinberg

Track and Room: SQL Dev - 116

Title: Introduction To Data Governance

Abstract: Data Governance has been seen by many as a very SCARY and BIG thing requiring biblical efforts to understand and more so to implement. Our discussion will provide context for what, why, and how of Data Governance. You will have an understanding of this and more importantly a road map for how to begin to implement and evangelize within the organization.

Speaker(s):

Warren Sifre

Track and Room: DevOps - 211

Title: PowerShell for the DBA

Abstract: PowerShell is a tool used by many people in DevOps and Infrastructure. Should the DBA get on board with using PowerShell? The answer is yes - as a DBA, PowerShell can have a significant impact on tasks that would be long and tedious with just T-SQL alone. Today there are specific modules that can be incorporated into PowerShell to help in automating every-day DBA tasks. Beyond that, PowerShell can be used to do things like automate deployments and audit permissions.

In this session we will explore real-world examples and demonstrate how PowerShell can be leveraged by the DBA to not only improve efficiency but also streamline processes across an enterprise environment.

Speaker(s):

Amy Herold

Track and Room: DBA - 203 Closed Caption

Title: Power BI Dashboard - Creating End to End Solutions

Abstract: We will be discussing the lifecycle of a Power BI Dashboard beginning from Accessing data, Data preparation, and cleansing, consuming the data for reports and deploying the reports to Power BI services, configuring security and making the Dashboards available to end users.

Speaker(s):

Suresh Datla

Track and Room: BI - 104 Closed Caption

Title: Little to Large - How to Scale to Enterprise Analysis Services Solutions

Abstract: In 2018 creating a cube is one of the more common tasks in BI, however what happens when the cube you build/inherit is growing so much? This session shows how to handle tabular models of size and details the fundamental considerations required in order to allow it to continue to scale. It also delves into what to think about when moving or building your cubes in Azure.

Speaker(s):

George Bryant

Track and Room: BI - 215

Title: How do you Azure?

Abstract: Most are talking about it, some have migrated to it and others are just overwhelmed. If you thought Azure was the color of the sky and you are wanting to learn about MS Azure then this is the session for you.

Join me for a fun journey to learn the very basics of Azure. Some how-tos, some whys, and some demos.

This is a level 0 session, #N00b, #Imabeginner

Speaker(s):

Tamera Clark

Track and Room: Azure - 216 Closed Caption

Title: Dynamic SQL: Tables / Parameters DBA Tools

Abstract: Dynamic SQL for the Developer DBA. In this class we will learn how to use Dynamic SQL on a day to day basis. Building Dynamic Tables from a wide variety of parameters passed into your query; Building Dynamic Column headers for those tables and using Pivot to display the results into a grid format. We will also explore passing parameters into and out of your SQL Query, creating dynamic search strings, and creating multiple databases, table structures using cross database scripting and Dynamic SQL.

Speaker(s):

Steven Tidwell

Track and Room: SQL Dev - 116

Title: SQL in Azure 101

Abstract: Want to run SQL in Azure. This session will cover all of your options from running SQL in a Windows or Linux VM to Azure SQL PaaS offerings.

This is an introductory session. At the end of this session you will have a good understanding of what SQL options are available in Azure and how to create and manage each one.

Speaker(s):

Mark Moore

Track and Room: Azure - 104 Closed Caption

Title: Agile Data Warehouse and ETL Design with Biml

Abstract: Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive presentation you’ll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately. Learn how you can use BimlScript to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.

Speaker(s):

David Stein

Track and Room: BI - 215

Title: Scales, Measurements and Encoding Schemes

Abstract: Programmers have learned how to design programs, but they haven’t really thought about how to design data. First normal form requires that the columns in a table be scalar values. But how many database people actually know what a scale is or have any background in measurement theory? Likewise, how many people invent encoding schemes by simply numbering a list of values? This session should make you into a better database programmer.

Speaker(s):

Joe Celko

Track and Room: DBA - 203 Closed Caption

Title: From Zero to Hero: intro to Azure Machine Learning

Abstract: The session aim is to get people excited and curious more about ML without digging in coding or deep concepts.

We will explore ML Azure offering, Some ML concepts, ML Studio, create an experiment from Scratch and show how ML can target common business challenges like demand projection or price targeting

Lots of hands-on

Speaker(s):

Mohamed Mawla

Track and Room: Azure - 211

Title: Building Your First SQL Server Container Lab in Docker

Abstract: A few years back virtualization changed the way to work with SQL and infrastructure. Now the next chapter is opening and it’s all about containers. Containers can make the DBA’s job of creating and deploying servers much easier freeing them up for other tasks such as performance tuning and security.

In this session, we will go over the concepts of containers, their general capabilities, and then build, connect and configure a SQL Server in a container for use as a private lab.

Speaker(s):

Chris Bell

Track and Room: DBA - 214

Title: Ntirety Lunch Session

Abstract: Ntirety Lunch Session

Speaker(s):

Mike Burek

Track and Room: Performance Tuning - 203 Closed Caption

Title: Azure SQL Managed Instance the New Hotness

Abstract: You can’t wait to move your databases to an Azure PaaS offering so you don’t have to patch and maintain an operating system and SQL Server. You looked at Azure SQL DB, but there are some limitations that prevent you from migrating to this service. Don’t worry, you’re not stranded. There is a new option designed to “Lift and Shift” your workload to Azure PaaS. It’s a brand new offering that just came out of private preview and into public preview. We’ll discuss this new offering, its advantages, and how you can migrate with ease.

Speaker(s):

Ryan Adams

Track and Room: Azure - 104 Closed Caption

Title: T-SQL Tools: Simplicity for Synchronizing Changes

Abstract: One of most common problems a data professional may face is finding and syncing data changes efficiently between multiple systems.

In this session we will look into different methods focusing on effective use of T-SQL and explore how these methods can mixed and matched in your workflows.

Target Audience: Any DBA or developer that has ever faced the problem of moving data changes across databases.

Speaker(s):

Martin Perez

Track and Room: SQL Dev - 116

Title: Make Your SQL Server Queries Go Faster

Abstract: Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? In this session, you will learn some T-SQL performance tuning tips that can be used on Monday back at the office. We will cover coding patterns that are developer friendly but are not SQL Server database performance friendly and show you how to rewrite them so they will run faster!

Speaker(s):

John Sterrett

Track and Room: Performance Tuning - 104 Closed Caption

Title: Mastering locks and blocks

Abstract: Is blocking giving you grief? How do you know if locking and concurrency is dragging you down? In this session you’ll learn the master techniques and tips to solving all your blocking and deadlock troubles.

Speaker(s):

Daniel Janik

Track and Room: Performance Tuning - 117

Title: The Future of Database Development with Containers

Abstract: Containers are dramatically changing the way that application developers design and build their systems. Databases will need to be a part of this revolution as every application needs a data store. Come see a future vision of how full stack application development might look in the next few years.

Speaker(s):

Steve Jones

Track and Room: DevOps - 203 Closed Caption

Title: Multidimensional Data Cubes and Data Mining in the Real World

Abstract: In this session, we will build out a multidimensional data cube based on ACH transaction data. The data will be approximately 25 million rows of data. Once we go over the design and load of the data cube, we will look at the data mining capability built into SQL Server to see what kind of insight we can get from the data using SQL Server-based tools. We are going to simulate the data that a financial institution would be receiving in direct deposits and other ACH type transactions. Remember, if your organization is using the enterprise version of SQL Server, all of the associated tools are free to install and use.

Speaker(s):

Robert Stewart

Track and Room: BI - 216 Closed Caption

Title: Building your Microsoft Business Intelligence (MSBI) Career

Abstract: Are you excited to know about the MSBI tools and work as a Business Intelligence Professional, a dynamic and rewarding career in Information Technology? If yes, this is the right time and place for you. In this session, I will give you the overview of the MSBI tools (SSIS, SSRS, SSAS, Power BI, Azure Analytics). I will also provide you some insights to build the MSBI career and to accelerate the learning curve in Microsoft Data Platform, based on my knowledge and experience, the proven strategies and techniques.

Speaker(s):

Ganesh Lohani

Track and Room: Career - 211

Speakers

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

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

Chris Hyde

Twitter: - ChrisHyde325

LinkedIn: Chris Hyde

Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.

Jay Falck

Twitter: - @jayfalck

LinkedIn: Jay Falck

I started as a night shift computer operator out of high school. I moved to applications development after graduation from SAC. After a few years with the State as an applications developer, the manager of Systems Programming decided it would be better to have me on the inside looking out rather than on the outside trying to get in. I spent the next 14 years as a mainframe system programmer for two state agencies. In 1996 I moved to Healthcare IT and have been that ever since. I’ve spent most of the past 14 years doing ETL, performance and HIPAA security. In these various jobs, I’ve used all manner of databases including InfoTec IMP, IBM VSAM and DB2, Interbase, Informix, Universe, Oracle 9i and SQL Server from 6.0 to 2008 R2.

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.

Bob Phillips

Twitter: - @WessexBob

LinkedIn: Bob Phillips

Contact: https://wessexbi.wordpress.com/

I am an independent consultant based in the UK, specializing in all things Excel, especially delivering BI within Excel.

I came to appreciate the power and versatility of Excel as an enterprise tool in the mid-90s when managing the delivery of a data warehouse project.

Now a freelance consultant, I specialize in Excel automation and BI delivered via Excel. An 11 year veteran of Microsoft#39;s MVP program, my life mission is to persuade small and medium corporates that data analysis and BI is important to them too, and that Power BI can help then find that information, in a straight-forward and cost-effective manner.

Edward Whalen

Twitter: - etwhalen

LinkedIn: Edward Whalen

Contact: https://www.perftuning.com

Edward Whalen is an Oracle ACE Director and the Chief Technologist at Performance Tuning Corporation (www.perftuning.com), a consulting company specializing in database migration, security, performance, administration, virtualization, and disaster recovery solutions with over 30 years of experience. He has extensive experience in system architectural design for optimal performance. His career has consisted of hardware, OS, database, and virtualization projects for many different companies. He has written nine books on Oracle products (15 books total), the last four from Oracle Press and several for Microsoft Press. He has also worked on numerous benchmarks and performance tuning projects with Oracle database products. Ed works primarily as

Amy Herold

Twitter: - @texasamy

LinkedIn: Amy Herold

Contact: http://www.sqlkitten.com/

Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQLSaturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.

Jennifer McCown

Twitter: - http://www.Twitter.com/MidnightDBA

LinkedIn: Jennifer McCown

Contact: http://www.MidnightDBA.com/Jen

Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.

Dustin Dorsey

Twitter: - sql_dd

LinkedIn: Dustin Dorsey

Contact: https://dustindorsey.com/

Dustin Dorsey has been architecting and managing SQL Server solutions for companies for well over a decade. While Dustin is skilled in many areas, he has a unique specialization in cost management and architecture around the data platform both on-premise and in the cloud that he has used to provide significant savings for multiple organizations and loves sharing information about this. Dustin is an avid speaker and can be seen writing articles on popular SQL websites, as well as, on his own blog at DustinDorsey.com. He is also active in the Nashville community as a local user group leader and co-organizer of his local SQLSaturday. Dustin currently serves as Director of Data Management at Lifepoint Health.

Alex Grinberg

LinkedIn: Alex Grinberg

I have more than 20 years of IT experience. My primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS and SSIS. I provide services in tuning, optimization, analysis and development for the creation of new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and site training. I have worked for CSC, VerticalNet, IDP, LSAC , and TMNAS (to name a few) and I am currently employed with Cox Automotive. I am Apress author book “XML and JSON Recipes for SQL Server”, also wrote number of articles for Simple-Talk and SQLServerCentral.com

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

Suresh Datla

LinkedIn: Suresh Datla

Worked on the Microsoft stack for 19 years now. Built successful Data Analytics Practices before. Currently focused on Data Platform, Data Analytics, Power BI and ML. I do Dashboard in a day sessions at Irvine MTC once every month. I also, conduct OC power BI user group to build a strong Power BI Community. Worked with SQL Server product since it was version 7 and Power BI since its inception.

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.

Paul Stanton

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

LinkedIn: Paul Stanton

Contact: https://www.windocks.com/blog-2

Co-founder of Windocks, Paul is a former Microsoft engineer who is focused on delivering solutions for SQL Server development and test, including SQL Server containers and database cloning.

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.

Ryan Adams

Twitter: - @ryanjadams

LinkedIn: Ryan Adams

Contact: http://www.ryanjadams.com

Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.

Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.

Jamey Johnston

Twitter: - STATCowboy

LinkedIn: Jamey Johnston

Contact: http://STATCowboy.com

Jamey Johnston is a Senior Data Scientist/Engineer for a large independent OG company. For over 25 years, he has worked for Fortune 500 companies architecting successful platforms in the cloud, on the edge, and on-premises for BI reporting, statistical analysis, ML, and AI. Lately, he spends his time in Azure, Python, R, Power BI, MS SQL, and SAS JMP. He holds a BS in Spatial Analysis from LSU and a Masters of Science in Analytics from Texas AM. He is a professor at the Mays Business School at Texas AM in the MS Analytics program. He is active in his PASS Local Group in Houston, co-leader of the local Power BI users group and data analytics group. He regularly speaks and volunteers at PASS events. He is also a Microsoft Data Platform MVP.

Russel Loski

Twitter: - sqlmovers

LinkedIn: Russel Loski

Contact: http://www.sqlmovers.com

Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.

Alex Grinberg

LinkedIn: Alex Grinberg

Joe Celko

Member of ANSI X3H2 Database Standards Committee for ten years, Author of Joe Celko series of books on SQL and databases for MKP/Elsevier. Author of over a dozen columns in the trade press in the US and Europe.

Jennifer McCown

Twitter: - http://www.Twitter.com/MidnightDBA

LinkedIn: Jennifer McCown

Contact: http://www.MidnightDBA.com/Jen

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com

Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.

Mohamed Mawla

Trilingual Principal Consultant amp; Team Tech lead at a global Tech Consulting Mohamed had worked with large SQL server environments such as financials and gov of hundreds of SQL server instances and enormous amounts of data. His favorite subjects are Cloud Analytics, performance tuning, High Availability, especially Replication and Disaster recovery. Certified Google Cloud and Azure Data Engineer.

When not working, Mohamed carries his cameras and takes a trip somewhere.

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

Leslie Andrews

Twitter: - landrews5807

LinkedIn: Leslie Andrews

Contact: https://www.lace.technology/blog

Leslie Andrews is an IT professional with almost 20 years of experience working with databases, designing databases, as well as designing and developing applications against those databases. 2018-2019 Idera ACE.

Daniel Janik

Twitter: - @SQLSME

LinkedIn: Daniel Janik

Contact: http://www.sqltechblog.com

Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQLSaturdays.

DeNisha Malone

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

LinkedIn: DeNisha Malone

Contact: https://www.denisham.com

DeNisha fell in love with data modeling and management while tutoring T-SQL Querying in college. She self-taught herself Power BI’s functionalities after a Business Intelligence internship in fall of 2015 - and has been sticking with the development of Microsoft’s BI suite ever since; growing tremendously as the application spreads through enterprises.

Outside of BI, her hobbies include mentoring and working with non-profits to enhance IT in the minority communities.

Robert Stewart

I have been using SQL Server since MS split it off from Sybase in 1994. I love data and finding out what ti can tell the business. At 65, I have started a Master’s of Science degree in Business Analytics so I can become even better at making data knowledge.

Toni Haag

LinkedIn: Toni Haag

Toni has a knack for creating fancy-looking, prescriptive dashboards - her preferred languages are R and DAX in Excel. She just recently graduated with her MBA and MS Business Analytics from UTD this past December - WHOOSH. She’s also a proud Texas Tech graduate - WRECK ‘EM; earned her Bachelor of Business back in 2012 and minored in Mandarin Chinese – she finally made it to China this past March! You should check out her Emerging Tech hackathon submission where she won first place and a wicked cool Oculus Quest: https://devpost.com/software/carbon-freightprint-h7a6gx

Hasan Savran

Twitter: - Savranweb

LinkedIn: Hasan Savran

Contact: http://h-savran.blogspot.com/

Hasan Savran is a BI Architect at Progressive Insurance Company. He spends his days architecting cutting edge business solutions by using the latest Web and Database technologies. He is a Microsoft Data Platform MVP, Microsoft Certified Solutions Developer. Hasan has spoken at many SQLSaturdays, Code Camps and User groups. He is an active member of the HTML5 and WebAssembly W3C groups. He likes to write about SQL, CosmosDB, C#, and Front End development on his blog.

Kerry Tyler

Twitter: - AirborneGeek

LinkedIn: Kerry Tyler

Contact: http://airbornegeek.com

Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.

David Stein

Twitter: - @Made2Mentor

LinkedIn: David Stein

Contact: http://www.Made2Mentor.com

David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.

Mark Moore

LinkedIn: Mark Moore

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

Mark Moore is a Cloud Solutions Architect working for Microsoft in North Texas. Mark has been with Microsoft for 25 years serving in various roles in Services and Sales. Prior to Microsoft Mark worked at Digital Equipment Corporation serving Federal and Government customers in San Antonio, Texas. Mark currently resides with his Wife (Deanne) in the DFW area.

David Stein

Twitter: - @Made2Mentor

LinkedIn: David Stein

Contact: http://www.Made2Mentor.com

Daniel Janik

Twitter: - @SQLSME

LinkedIn: Daniel Janik

Contact: http://www.sqltechblog.com

Forrest McDaniel

Twitter: - tsqladdict

Contact: https://www.forrestmcdaniel.com

Simply put, Forrest is a nerd. For over a decade he’s applied his math skills in various industries, and has become specialized in SQL Server performance. His current goal is to animate all the operator algorithms in query plans.

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.

Peter Doyle

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

LinkedIn: Peter Doyle

On Jan 12, 2019, Peter attended his first SQLSaturday and experienced an engaging and uplifting community that encouraged everyone regularly to give back. That experience resulted in teaching eleven sessions and delivering a SQL Fundamentals pre-conference the last six months of the year. He is passionate about sharing knowledge on building a solid T-SQL foundation without wasting time.

Peter’s journey from minimal Excel knowledge to writing Dynamic SQL all started from watching Youtube videos for three hours every morning before work. Managers took notice of the results and transferred him to the reporting department. A few months later, a co-worker suggested he should learn SQL Server and his world of data has never been the same.

George Bryant

Twitter: - Azure_George0

LinkedIn: George Bryant

George has over a decade of experience in the Business Intelligence industry and is an active member of the BI community across the Midwest. His knowledge spans multiple industries including, retail, manufacturing, finance, and medical, however recent years has seen him focus on the analytics in sports.

George specializes in BI architecture and end to end development in order to deliver advanced analytics and metrics to multiple organizations across the country. In recent years George has focused on and worked primarily in the Azure cloud, utilizing both established and recent offerings.

Kevin Hill

Twitter: - @Kevin3NF

LinkedIn: Kevin Hill

Contact: http://www.dallasdbas.com/Blog

I have been working with Microsoft Database technologies since 1994, in Design, Data Modeling, Development and Administration. 18 years of that time have been with SQL Server, going all the way back to 6.5.

I find that I am most passionate about the Admin and HA/DR side, but will still dive into design when called upon.

The Azure cloud is exciting and I believe is the future of SQL Server. I love teaching new and accidental DBAs all of the things I didn’t know when I started.

Shawn Weisfeld

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

LinkedIn: Shawn Weisfeld

Contact: http://www.usergroup.tv

Shawn (http://www.shawnweisfeld.com, shawn@shawnweisfeld.com) is passionate about building awesome applications and websites with .NET technologies and Azure. He is currently a Technical Evangelist for Microsoft based in Austin TX and founder of http://UserGroup.tv. Read his full bio at http://about.me/shawnweisfeld

John Sterrett

Twitter: - JohnSterrett

LinkedIn: John Sterrett

Contact: https://johnsterrett.com/community/

John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John’s community activities can be found at https://johnsterrett.com/community/

Steven Tidwell

Twitter: - @SQLCodeMonkey

LinkedIn: Steven Tidwell

Contact: https://www.sqlcodemonkey.com

I am currently the Technical Lead for Client custom projects. I have been writing SQL Code starting in SQL 7. Over the years I have put on many hats, DBA, Developer, Web Developer, C#, VB.NET, Cold Fusion and Java. But at the end of the day, I prefer to write SQL. Local Chapter Leader for the South Montgomery County SQL Server User Group in Montgomery County, Texas.

John Sterrett

Twitter: - JohnSterrett

LinkedIn: John Sterrett

Contact: https://johnsterrett.com/community/

Mike Burek

Twitter: - mikeburek

LinkedIn: Mike Burek

Contact: http://tikiwiki.mikeburek.com

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

Mike Byrd

Twitter: - ByrdNest_TX

LinkedIn: Mike Byrd

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

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

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

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

Chris Hyde

Twitter: - ChrisHyde325

LinkedIn: Chris Hyde

Martin Perez

Martin Perez specializes in data quality management, SQL tuning and development for SQL Server. Administration Systems adapt and evolve with the company’s needs for day to day operations by efficiently tackling workflow challenges through personal training, trouble shooting, and consultation.

Tamera Clark

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

LinkedIn: Tamera Clark

Contact: http://tameraclark.com

Tamera Clark has been involved in the IT industry for greater than ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter, Co-leading the Nashville BI Chapter, assisting the Nashville PASS Chapter and serving as a Regional Mentor. Tamera is also the event chair of SQLSaturday Nashville.

Melissa Stein

Melissa is a database developer for HealthAxis Group and spends her days doing ETL using SSIS and BIML. She taught David everything he knows.

Chris Bell

Twitter: - @cbelldba

LinkedIn: Chris Bell

Contact: https://www.wateroxconsulting.com/

Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do ‘Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris’ thoughts and technical community activities at WaterOxConsulting.com.

SQLSaturday #890 - Austin 2019

Sessions

Title: SQL DevOps Simplified with Production Databases

Title: The SQL Career Roadmap for Women (and Men)

Title: Successfully Migrating Existing Databases to Azure SQL Database

Title: The Master Stored Procedure Workshop: Part 2

Title: Advanced T-SQL Development with latest features.

Title: The Master Stored Procedure Workshop: Part 1

Title: Overcoming Challenges with Source Control and Continuous Integration.

Title: Make Database Documentation your Minion

Title: Managing Excel Power Query With VBA

Title: Introduction to Linux for SQL Server Professionals

Title: The True Story of Learning Biml

Title: Adopting a Compliant Database DevOps Process

Title: Code Like a Pirate … Intro to R and Data Science Tools in MS

Title: Python in SQL Server 2017 and 2019

Title: Your SQL Servers are Mi$ConFiguReDed

Title: Sharing and Collaborating for the Pro Premium Power BI user

Title: Querying Semistructured Data in Azure Data Lake with USQL

Title: A Primer on SQL Server Clustered Index Architecture

Title: An Animated Look at Query Plans

Title: Not All Data is Relational: An introduction to Cosmos DB

Title: Performance Tune like a Microsoft MVP

Title: Managing the mystery database

Title: A Rocket Scientist Perspective on Index Column Selection

Title: 7.5 Steps to Social Media Marketing Domination for Employees, Ent

Title: Annoyed with a stubborn pivot table? PowerPivot is your answer.

Title: Tuning Like CSS: With These Tools There’s No Need Call Support

Title: CosmosDB is the missing piece to your Data puzzle!

Title: SSIS Performance Tuning with BimlScript

Title: Using Oracle GoldenGate to Replicate SQL Server Data

Title: Azure Databricks (ADB) and the Traditional DBA

Title: A Perfect Ten: The Data Model

Title: XML and JSON, does the DBA need it?

Title: Introduction To Data Governance

Title: PowerShell for the DBA

Title: Power BI Dashboard - Creating End to End Solutions

Title: Little to Large - How to Scale to Enterprise Analysis Services Solutions

Title: How do you Azure?

Title: Dynamic SQL: Tables / Parameters DBA Tools

Title: SQL in Azure 101

Title: Agile Data Warehouse and ETL Design with Biml

Title: Scales, Measurements and Encoding Schemes

Title: From Zero to Hero: intro to Azure Machine Learning

Title: Building Your First SQL Server Container Lab in Docker

Title: Ntirety Lunch Session

Title: Azure SQL Managed Instance the New Hotness

Title: T-SQL Tools: Simplicity for Synchronizing Changes

Title: Make Your SQL Server Queries Go Faster

Title: Mastering locks and blocks

Title: The Future of Database Development with Containers

Title: Multidimensional Data Cubes and Data Mining in the Real World

Title: Building your Microsoft Business Intelligence (MSBI) Career

Speakers

Sponsors