SQLSaturday #867 - Baton Rouge 2019

Event Date: 08/17/2019 00:00:00

Event Location:

LSU Business Education Complex
501 South Quad Drive
Baton Rouge, Louisiana

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: A Map To Success: Functional Programming For Database Developers

Abstract: Over the past several years, we have seen a resurgence of interest in functional programming languages, particularly with the success of Scala and R in the marketplace. Although object-oriented (oo) design remains the dominant software development paradigm, even oo-first languages have seen a shift toward the functional mindset with the emphasis on LINQ in C# and lambdas in Java. This move toward a functional style should be particularly welcome for data platform specialists, who already have a leg up in understanding functional programming concepts thanks to their work with SQL.

In this talk, we will focus on one functional programming language, F#. We will look at some of the basics of the language and see how you can translate knowledge of SQL into a pipeline-driven functional programming language. We will also see areas where F# integrates smoothly with SQL, creating a powerful way to extend your SQL skills beyond queries.

Speaker(s):

Kevin Feasel

Track and Room: .NET Dev - 1700 (SQL Dev)

Title: Approaching Zero: Minimizing Downtime During Deployments

Abstract: Negotiating a downtime for a release can be difficult in this modern, 24x7 world. When downtime means lost revenue, the price of taking a downtime to deploy code can run up quickly. This talk will show you a way to reduce the cost of deployment by reducing or even eliminating required downtime for database code deployment. We will show how to release new database code, update existing stored procedures, refactor and restructure tables, and even perform systemic re-architecture with no downtime and minimal blocking. We will use as a case study one release in which we modified the primary key column on 180 tables and updated over 550 stored procedures without end users noticing a thing. If you want to hit that three nines (or better) service-level agreement, this talk will help get you on the road to reduced downtime.

Speaker(s):

Kevin Feasel

Track and Room: SQL Server Development - 1745 (SQL Admin)

Title: Climbing the SQL Server Index B-Tree

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

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

Speaker(s):

Mike Byrd

Track and Room: SQL Server Development - 1620 (SQL Beginner)

Title: Taming of the Shrew - Optimizing Power BI

Abstract: No one wants to tell a report user that while running a report in Power BI they have time to go get a cup of coffee…in another town. Although data sets will often be the focus of performance issues, it’s important to know how to locate performance problems in Power BI and how to eliminate them.

This session will take the Power User through how to identify time consuming processing in Power BI and how to address it through step-by-step and proven methods used to optimize in multi-tier environments. This method removes frustration and finger-pointing and gets to the heart of the problem with a goal of correcting performance challenges. The results are satisfied end users who get the information they need, when they need it.

Take Aways: Learn how to identify what is taking the time in a Power BI data set and report. Understand the logging and tracing mechanisms and capabilities in the environment. Understand when a problem is really a problem.

Speaker(s):

Kellyn Pot’Vin-Gorman

Track and Room: PowerBI - 1845 (Big Data/PowerBI)

Title: Be Part of the Solution with Automation

Abstract: DevOps automation can be intriguing to learn and overwhelming to implement. This session will take a real life use case of a multi-tier and complex environments, with various stake holders to a successful conclusion. Unlike a session on concepts, this session surrounds itself with a real-life situation and how automation was used with DevOps practices to build a solution. The session will demonstrate the reasons to automate, along with the steps required to make it possible, offering insight into concepts that are often too vague to employ. The attendee will see multi-platform and cloud tool demonstrations on how to take the DevOps methodology and continuous delivery to actuality in their own projects, no matter if small or large.

Speaker(s):

Kellyn Pot’Vin-Gorman

Track and Room: Agile - 1920 (Agile)

Title: Designing Data Intensive Cloud Native Applications

Abstract: Cloud is rapidly changing the way modern day applications are being designed. Data is at the center of multiple challenges while architecting solutions in cloud.

With technology changing rapidly, there are new possibilities for processing data efficiently. Come join me in this session to learn more about the tools and technologies that will help you to design data intensive systems. We will take a structured approach towards architecting data-centric solutions, covering technologies like message queues, data partitioning, search index, data cache, event sourcing and NoSQL solutions.

If you are a Data professional, Software Engineer or Architect, come join me in this session to understand the high-level design principles that will help you build scalable, resilient and maintainable systems in cloud.

Speaker(s):

Samir Behara

Track and Room: SQL Server Development - 1700 (SQL Dev)

Title: Monster Text Manipulation: Regular Expressions for the DBA

Abstract: Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures filled with table variables instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cuts that work from hours to seconds. I use regular expressions all the time and I have taken many tasks down from several days to just a few minutes. Stop writing code manually and let regular expressions do it for you. Here you’ll learn: • The most useful regular expression commands. • The appropriate times to use regular expressions. • How to use regular expressions to write code for you. • How to incorporate regular expressions into large tasks and combine them with other methods.

Speaker(s):

Sean McCown

Track and Room: SQL Server Development - 1510 (Auditorium)

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: Professional Development - 1735 (Prof Dev 2)

Title: 3 Keys to Successful Consulting

Abstract: Interested in becoming a consultant? Think it’s too overwhelming? Want to be your own boss? Wish to expand your clientele?

The hardest thing about being your own boss is getting in the right mindset and to truly understand that your past doesn’t equal your future.

In this 60 minute session, I cover 3 keys to being a successful consultant. I share techniques used to help others get in the right mindset and tackle the mental blocks to achieving success in their entrepreneurial pursuits.

Whether you are interested in starting your own business, or a consultant wanting to expand your clientele, this session will position you for future success as an entrepreneur.

Speaker(s):

Mohammad Darab

Track and Room: Professional Development - 1720 (Prof Dev 1)

Title: PowerShell + SQL Server = Better Together

Abstract: As a SQL Server professional, are you able to make a rhyme or reason to this thing called PowerShell? Need to accomplish something? Do you use Windows PowerShell or PowerShell Core? How will you interface with PowerShell? With the PowerShell console, ISE, VSCode, SAPIEN PowerShell Studio, or something else? Will you use Cmdlets from one of the various SQL related PowerShell modules? If so, which one? SQLPS, SQLServer, DBATools, etc. Or maybe you should use the SQL PS provider? What about SMO? Or write your own custom .NET code that can be executed with PowerShell? With it being so difficult to determine how to go about running something in PowerShell, it’s no wonder that most people resort to searching the Internet to figure it out. The sad thing is that most of the PowerShell code you’ll find on the Internet is less than optimal to say the least. I’ll demonstrate how and when to use different approaches along with adhering to the community’s best practices for writing PowerShell code.

Speaker(s):

Mike Robbins

Track and Room: PowerShell - 1305 (PowerShell)

Title: Using Open Source Software to Collect Performance Metrics

Abstract: Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? If only you knew what performance metrics to collect and had them for your existing instances to answer these questions.

In this session, we will discuss sp_whoisactive and Query Store to track what queries are running. Then we will be combining three open source tools – Telegraf, InfluxDB, and Grafana – into an inexpensive and easy to set up system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances, Azure Managed Instances and Azure SQL Databases.

Attendees will see how easy it is to get good performance data and visualize it interactively and combine with other tools to troubleshoot issues. Finally, we will look at problem I solved using this solution as an example.

Speaker(s):

Tracy Boggiano

Track and Room: SQL Server Administration - 1745 (SQL Admin)

Title: Database People and DevOps: The Fundamentals

Abstract: DevOps is a software delivery philosophy that focuses on delivering quality, faster. The purpose of this session is to cover some of the basic principles of DevOps and how they apply to database development and administration. Everyone’s environment is different, but the strategies discussed within can be translated into basic tactical gains that are easy to implement.

Topics covered include:

a (VERY) brief history of DevOps
why DBA’s make the best DevOps engineers
what admins can teach developers, and what developers can teach admins

Speaker(s):

Stuart Ainsworth

Track and Room: Agile - 1920 (Agile)

Title: Containers - You Better Get on Board!

Abstract: Containers are taking over, changing the way systems are developed and deployed…and that’s NOT hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, leveraging containers! In this session, we’ll get you started on your container journey learning container fundamentals in Docker, then look at some common container scenarios and introduce deployment automation with Kubernetes.

Speaker(s):

Anthony Nocentino

Track and Room: Windows Server/Virtualization - 1700 (SQL Dev)

Title: Building Quality Web APIs with Asp.Net Core

Abstract: We’ve all done “dotnet new webapi” and got our values from the ValuesController. Now what do we do next? In this talk we will discuss how to structure our project(s), create good api urls, handle versioning, unit test our api, and secure our endpoints. There are plenty of examples of best practices for .Net Core Web APIs. We will look at them and figure out why we would want to implement these practices. We will also identify the benefits for doing so.

Speaker(s):

Bryan McCoy

Track and Room: .NET Dev - 1425 (.NET Dev)

Title: Common SQL Server Mistakes and How to Avoid Them

Abstract: Making mistakes is human nature, avoiding them comes from experience and shared wisdom from others. In this session, Tim Radney will share experiences he has encountered supporting multiple fortune level companies. Tim will share real world experiences of environments he has worked on and the impact he has seen from administrators not knowing how to properly configure and administer SQL Server. In this session you will learn many accepted best practices for installing, configuring and supporting SQL Server to help your environment run as smooth as possible. When you leave this session you will have a checklist of items to take back to your shop to make sure your environment is configured properly.

Speaker(s):

Tim Radney

Track and Room: SQL Server Administration - 1510 (Auditorium)

Title: Azure for the Production Data Professional

Abstract: Microsoft Azure is an open, flexible, scalable, enterprise-grade cloud computing platform. This full day class will teach you why migrating to SQL Server running in Azure is secure, reliable, easy, as well as how to do it.

The Azure platform is vast with many services to choose from. You will get a high level overview of the various services with a focus on SQL Server running in Azure Infrastructure as a Service (Iaas) and Azure SQL Database as a Platform as a Service (PaaS).

You will see how easy it is to build a virtual machine in Azure running SQL Server and how to migrate your data. You will gain insight into licensing, security, pricing, and networking.

You will learn all about Azure SQL Database, its features and limitations for Singleton and Elastic databases as well as Managed Instances.

If you are interested in learning about Azure for your SQL Server environment, this session is for you.

Speaker(s):

Tim Radney

Track and Room: SQL Server Administration - 1620 (SQL Beginner)

Title: Careers in IT - Baton Rouge 2019

Abstract: Careers in IT will feature a panel of industry leaders and experts who directly interact with participants in a moderated question and answer session. This will allow participants to gain insight into what the IT community sees as valuable (skill-sets, certifications, experience, and etc) so that they can be better prepared for a career transition or to start work in the IT field for the first time.

Speaker(s):

Michael Viron

Track and Room: Career - 1720 (Prof Dev 1)

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 - 1735 (Prof Dev 2)

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, Machine Learning and Power BI.

Speaker(s):

Rodney Landrum

Track and Room: Business Intelligence - 1800(Analytics/BI)

Title: All (Data) Things Considered: The Lean Coffee Workshop

Abstract: Collaboration is the heart of SQLSaturday’s, but too often attendees move from session to session in a passive learning mode. This session is based on the Lean Coffee model, and is a structured workshop with no pre-planned agenda. The goal is to involve YOU in the conversation; bring your questions, your answers, your business cards, and your desire to learn. YOU set the agenda, YOU decide when to move on, and YOU engage and learn.

Speaker(s):

Stuart Ainsworth

Track and Room: Professional Development - 1735 (Prof Dev 2)

Title: Building, Debugging Deploying Containerized .NET Apps in Visual Studio

Abstract: Containers is the new buzz word going around. This session, we will discuss what a Container is. We will see how to add Containers to your current or new application, and how to debug inside a Container. We will also look at deploying Containers to Azure and Kubernetes.

Speaker(s):

Jeremy Cronan

Track and Room: .NET Dev - 1425 (.NET Dev)

Title: The Game Master’s Guide to People Management

Abstract: The dust settles from the massive blow dealt by Erin’s quick and, in your opinion, very creative thinking. A monster has been looming over your crew for weeks and it’s now on its last legs. All eyes make their way across the table and over to Jim, who is eager to roll the dice and deal the final blow. A final few clicks from the conference room mouse and the beast is felled. The room erupts in celebration as Jim logs into the new environment, spun up entirely by their efforts and investments in “Infrastructure as Code”.

As much as some might want to draw a line between work and play, there is much that they can have in common. In this session we’ll take a look at what we, as people managers, can learn from role playing games and the relationship that evolves between a game master and their players. We’ll talk about identifying what motivates our team members and tools and strategies we can employ to create an environment that keeps them challenged, interested, and engaged.

Speaker(s):

Stacy Vicknair

Track and Room: Professional Development - 1920 (Agile)

Title: TDD With No Tears

Abstract: Unit testing is hard to get right. Are you testing too much? Too little? How do you write tests that aren’t a waste of time? Isn’t testing supposed to enable refactoring? Then why do they seem to be in the way? What’s this BDD thing I keep hearing about? Do we need to learn yet another tool?

This talk goes deep into the philosophy behind unit testing in general and test-driven development in particular. We will discuss how to keep things simple yet useful and showcase a strategy for writing tests that achieve our goals without wasting everybody’s time.

Speaker(s):

George Mauer

Track and Room: Agile - 1920 (Agile)

Title: Goodbye Classes: Writing React the Functional Way

Abstract: Whether you are new to React, or a veteran, there is plenty to gain from this talk.

In this session you will learn techniques using higher order functions to keep your React and JavaScript code functional and maintainable. The recompose library is going to be used to accomplish this in React.

We will be referencing a full front end stack utilizing the most up to date modern web stack for Single Page Application (SPA) development: Webpack 4, React 16, Redux, Bootstrap 4, ESLint with StandardJS, Sagas, and Jest.

A reasonable familiarity with JavaScript is expected, as well as Node and npm are prerequisites to running this locally.

Speaker(s):

Alexander Lemkin

Track and Room: .NET Dev - 1425 (.NET Dev)

Title: Simple_Safety™ > $0 Tools-n-Tips for Non-Techies and Techies

Abstract: After the surge of ransomware in 2016, coupled with the telemetry leaks in Windows 10, I launched my Simple_Safety™ series with $0 Tools-n-Tips carved out from the commercial Hybrid Decisions® Safer_Computing™ Platform, to help our Family-n-Friends stay reasonably safer online. We will Talk-n-Demo $0 Tools-n-Tips for Windows 10 (version 1903 aka 19H1 that was released as the May 2019 Update).

AUDIENCE: Anyone wanting to stay reasonably safer online PRE-REQ: Anyone using Windows 10

TAKEAWAYS: For those who want more via community, sign up https://www.HybridCloudGroup.org
~AND~ for those who want to adopt NOW, welcome to Hybrid Decisions® Corp (https://www.HybridDecisions.com/connect)

SPEAKER DISCLOSURE: https://www.linkedin.com/today/author/ZaneMoreign ~AND~ {Tex} Founder⋮Advisor⋮Speaker⋮Technologist, https://www.linkedin.com/in/AnthonyTexM «±»

Speaker(s):

Zane Moreign

Track and Room: CIO/Executive - 1325 (CIO)

Title: Azure Automation with PowerShell: Scripting Away the Problems of Yesterday

Abstract: In your day to day job, how many times do you find yourself interrupted to complete a task you’ve done a thousand times? The repetitive work not only takes resources from more important work but also costs time to ramp up/down. What if you could automate the operation? Better yet, what if you could give approved access to that automation to those that request it, execute it on a regular schedule, or have it react to some event? In this session, we will explore Microsoft’s Azure Automation Runbooks, its capabilities, and even demo a few use-cases. This should give you a feel for how this service can help free you from tedious duties and empower the rest of your team!

Speaker(s):

Kevin Cefalu

Track and Room: PowerShell - 1305 (PowerShell)

Title: T-SQL Tips Tricks to Make Your Life Easier!

Abstract: Do you spend your days slinging T-SQL code? Want to improve your T-SQL game? If you answered yes, then this session is for you.

This demo-intensive session will showcase a collection of my favorite beginner and intermediate level tips and tricks. We will explore how to identify and fix some common T-SQL anti-patterns, my favorite SSMS productivity tricks, and clever solutions to some common but not easily-coded challenges.

This session targets both developers and DBAs; the only prerequisites are the desire to write better T-SQL code and aim of living an easier life!

Speaker(s):

Andy Yun

Track and Room: SQL Server Beginner - 1700 (SQL Dev)

Title: PrequelSaturday - How the SQL Server community is about to make your job easier

Abstract: Welcome! You’ve already discovered the best value anywhere in SQL training; here’s how to make the most of it. We’ll talk about what to do while you’re here and ways to keep up the learning momentum afterward.

You’ll also be introduced to several invaluable (and not just because they’re free) tools that anyone working with SQL Server needs to be familiar with.

If you’re new to SQL Server, when you get back to work on Monday you’ll know how to attack the problem you’ve been struggling with, you’ll solve the next problem faster, and you’ll know how to find help if you get stuck. Oh, and you’ll know about six other problems that used to be hiding from you.

Speaker(s):

Scott Minar

Track and Room: SQL Server Beginner - 1620 (SQL Beginner)

Title: How to index, win friends, and influence people.

Abstract: In this session, we’ll discuss performance benefits of indexes and compare index types. If you’re new to indexes in SQL Server or just in need of a refresher, this session should help.

Speaker(s):

Jonathan Jefferson

Track and Room: SQL Server Beginner - 1620 (SQL Beginner)

Title: Feeling SETSy?

Abstract: ‘SETS’ are a powerful tool in Tableau that are often not used to their fullest potential. In this working-session, we will see how sets can be used for answering various deep analysis cases such as Segmentation, Grouping, Benchmarking, Market Basket Analysis, Cohort Analysis, Conditional Suppression, Comparative Ranking etc. Hoping you will leave this session ‘Feeling SETSy’!

Speaker(s):

Balaji Nedurumalli

Track and Room: Business Intelligence - 1800(Analytics/BI)

Title: Lightning Fast Backups

Abstract: How to make your backup lightning fast.

Speaker(s):

Robert Canzonire

Track and Room: SQL Server Administration - 1745 (SQL Admin)

Title: Why There are No Code Problems, Only Organizational Culture Problems

Abstract: Everyone is fascinated by startups. We watch in awe at the market disruption that some technology companies can create. The most successful of these plucky, fast-moving startups may grow into large companies.

The quickest and most disruptive companies may soon struggle under the weight of the increasing scale, expectations, and a shifting organizational culture. Solving code problems is suddenly no longer the most difficult issue.

Have you ever been frustrated at how long it takes to be able to change something in your job, product or organization? Have you ever measured how long it takes to get a change that’s only a few lines of code into production? Have you ever wondered why the chat service Slack doesn’t have a “dark mode”?

Join to discuss • how organizations (some real, some apocryphal) deal with product and technology changes • how you fit in as a developer, DBA, manager or other consultant, and • what we can all do about it when we get back to work on Monday

Speaker(s):

Andrew Barefield

Track and Room: Agile - 1920 (Agile)

Title: Monitoring SQL Server with Telegraf/InfluxDB/Grafana – Lessons from the Trenches

Abstract: Following Tracy Boggiano’s presentation to the BRSSUG about using open source tools to monitor SQL Server, I tried it myself. Now I can’t imagine doing my job without it. But getting to this point required a significant amount of research and trial and error. In this presentation I would like to share some of the lessons learned in this process, so you can get your monitoring solution running and tailored to your needs efficiently.

The topics I will address include:

What data is captured by the SQL Server Telegraf plugin
Querying Telegraf data on InfluxDB
Writing InfluxDB queries for Grafana panels
Grafana panel/dashboard configuration options
Grafana permissions authentication
Querying SQL Server directly from Grafana

Speaker(s):

Tom Shaw

Track and Room: SQL Server Administration - 1800(Analytics/BI)

Title: Improve Dist`d System Web App Performance Using In-Memory Cache

Abstract: Applications often integrate with APIs for the purpose of retrieving data from a disk-based storage system like SQL Server. This poses challenges due slow queries and amount of data sent down the wire. In this presentation, we discuss the performance concerns with this type of architecture especially for big data scenarios. Oscar Garcia shows how to address those concerns by following a series of steps in which an application is refactored with minimum changes to support an in-memory data store and data streaming. We start by discussing the challenges when using data queries. We structure the data for in in-memory storage. We replace the API requests with real-time data streaming.

Learning Objectives:

SQL Server Query Challenges

Redis Cache Basic Operations and Structure

Angular App with Socket.io integration

Node.js Backend with Socket.io and Redis support

Real-time data integration

Speaker(s):

oscar garcia

Track and Room: .NET Dev - 1745 (SQL Admin)

Title: Employee On-boarding - building business solutions in modern SharePoint

Abstract: What’s the big deal with modern SharePoint, anyway? In this session, learn how to use a combination of tools from the Microsoft Office 365 stack, including modern SharePoint, to create a business solution for new-hire on-boarding. Topics covered will include Microsoft Forms, PowerApps, Flow, and modern lists and libraries

Speaker(s):

Cody Gros

Track and Room: Office 365/SharePoint - 1321 (Modern Azure Apps)

Title: Consumer Bill of Rights: Your Data and Changing Privacy Laws in 2020

Abstract: Sweeping privacy changes are moving through state legislatures across the country. California’s new law is set to take effect January 2020 and it has far reaching impact across the country. An additional 14 states are right behind them. The US Congress is considering a federal version that gives consumers the right to view their data in your organization. How will these laws impact you? Will you be ready?

Speaker(s):

Aaron Kruger

Track and Room: CIO/Executive - 1325 (CIO)

Title: Serverless Cloud Computing: Promises and Pitfalls

Abstract: You’re hearing more and more about serverless computing, but is it really the panacea that cloud vendors make it out to be? Come learn about the promises and pitfalls of serverless cloud computing based on real-world use.

In this session we will:

Discover where all the cloud servers disappeared to
Define what “serverless” actually means
Discuss use cases that are a good fit for serverless (there will be code!)
Drive through a top ten list of pitfalls to look out for, and how those pitfalls can enable us to design more resilient applications

This session will provide useful insights for IT decision-makers exploring where serverless fits in their enterprises and for developers who want to go out and quickly build something.

Speaker(s):

Jonathan Schellack

Track and Room: CIO/Executive - 1325 (CIO)

Title: Inside Kubernetes - An Architectural Deep Dive

Abstract: In this session we will introduce Kubernetes, we’ll deep dive into each component and its responsibility in a cluster. We will also look at and demonstrate higher-level abstractions such as Services, Controllers, and Deployments and how they can be used to ensure the desired state of an application and data platform deployed in Kubernetes. Next, we’ll look at Kubernetes networking and intercluster communication patterns. With that foundation, we will then introduce various cluster scenarios and high availability designs. By the end of this session, you will understand what’s needed to put your applications and data platform in production in a Kubernetes cluster.

Speaker(s):

Anthony Nocentino

Track and Room: Windows Server/Virtualization - 1510 (Auditorium)

Title: Extend Azure DevOps with a Custom PowerShell-based Pipeline Task

Abstract: There are times where the Azure DevOps pipeline tasks that are available in the marketplace are not meeting your needs and you wished that you knew how to create your own. After attending this session, you’ll be able to do just that. In this session you’ll learn how to create your own deployable pipeline task with logic written using PowerShell. We’ll craft a custom design time form with a our own service connection, develop a PowerShell script that interacts with an external service, deploy to the marketplace as a private link, and install into an Azure DevOps collection.

Mike Huguet is a Senior Software Engineering Lead on the PowerApps product development team at Microsoft. He and his team focus on features and tooling that aid customers and partners in improving the quality of their PowerApps and customizations to their Common Data Services and Dynamics 365 CE solutions. Mike has been a software professional for over twenty years.

Speaker(s):

Mike Huguet

Track and Room: PowerShell - 1305 (PowerShell)

Title: Customizable User Interfaces with Dynamic Components in Angular

Abstract: Modern component-based design has brought developer productivity to new heights, but most are unaware that this pattern can be taken even further. Designers, admins, and users alike could all benefit from additional steps which make these components truly dynamic. New abilities can be unlocked, such as combining components to suit your need or personal preference, even faster development cycles, and lazy-loading components which have not yet been created. While this talk will focus on applying this technique in Angular, the concepts are universal and can be brought to any framework or language. Learn how making your components dynamic is surprisingly easy, and be left wondering why you have not done this sooner.

Speaker(s):

John Harvey

Track and Room: .NET Dev - 1425 (.NET Dev)

Title: A Beginner’s Guide to Seven Practices that Kill Performance

Abstract: Are you a relative newcomer to SQL Server and want to get into performance tuning? Or maybe you just want to expand your knowledge of hidden performance killers?

Then join me for a survey of seven worst practices that kill performance in SQL Server. In this demo-filled session, we will cover a mix of administrative and T-SQL development practices, making this session suitable for DBAs and developers alike! Topics include server configuration mistakes, T-SQL parallelism, and TempDB headaches.

When you leave, you’ll be armed with knowledge and tools to tackle your current workloads and hit the ground running.

Speaker(s):

Andy Yun

Track and Room: SQL Server Beginner - 1510 (Auditorium)

Title: Managing ETL Change using BIMLScript

Abstract: Change is constant, especially with source files. Health care claims data files change at least yearly. You develop an SSIS package to load the source file. You meticulously identify each of the columns and map them to the targets. Your package runs fine for months. Then the file format changes. Again, you tediously select each column, etc. Wouldn’t it be nice to simply document the structure of the file, the file’s metadata, and generate the SSIS from that metadata? Your users demand the documentation anyway. If the file changes, you simply change the metadata. To demonstrate such an approach, I import some US census data. I create the SSIS package using BIMLScript and metadata. When the format changes, I change the metadata and generate a whole new package. And if your whole ETL approach changes to say Azure Data Factory? I will demonstrate how to generate an Azure Data Factory pipeline from the same metadata.

Speaker(s):

Russel Loski

Track and Room: Business Intelligence - 1845 (Big Data/PowerBI)

Title: Communicating with Non -Techies

Abstract: This information provides a better understanding of tactics and methods to better allow IT Professionals and those with technical expertise to better connect with those without technical expertise - often users, customers and others, requiring technical support services. Also provides tips and methods to eliminate barriers in communicating. This presentation is augmented with You Tube Video to provide insight and perspective from IT expert and trainer.. This session is designed to be interactive to Technical professionals required to provide timely and effective Customer Service Support and Problem Resolution.

Speaker(s):

David Reid

Track and Room: Professional Development - 1735 (Prof Dev 2)

Title: How to Develop Without a Designer

Abstract: No designer? No problem! Get insight from a product designer on how to create visual consistency with front-end development. Learn tips on how you can create reusable components and styles that can be globally updated so your whole team can stay aligned. In the end, you are sure to have cleaner code and a final product that keeps both your internal team and users happy.

Speaker(s):

Rebecca Milazzo

Track and Room: Professional Development - 1720 (Prof Dev 1)

Title: A Self-Tuning Fill Factor Technique for SQL Server

Abstract: Have you ever created an index and wondered what to specify for fill factor? Usually I’ve never ever given it a worry and just left it at the default value = 0 (actually this is a synonym for 100). But recently I’ve stumbled on a technique that will determine a “near” optimum fill factor value for every index in a database. I say “near” because it won’t always derive the perfect fill factor, but will get you close. We will look closely at the TSQL for this technique to see how the proof of concept was developed for a very active OLTP database. I’ve observed a decrease in overall database wait times of 30% after the tuning. The tuning is continuous and allows for changes in data skew as well as evolving application interactions with the database. IMHO this is a real break-through for making your indexes perform even better. All code will be available for download.

Speaker(s):

Mike Byrd

Track and Room: SQL Server Administration - 1745 (SQL Admin)

Title: The Latest SharePoint Features: What They Are and Why They Matter

Abstract: Keeping Modern SharePoint fresh and current involves feature additions, updates, and enhancements. In this interactive session, we will examine the value, benefits, and impact of recently released features for Modern SharePoint Online sites. Concurrently, we will discuss best practices for testing, implementing, and adopting new features. The session will conclude with demonstrations based on customer applications.

Speaker(s):

Theresa Eller

Track and Room: Office 365/SharePoint - 1321 (Modern Azure Apps)

Title: Catching up with Angular 7

Abstract: If you are new to Angular, or still working on an older version, then it’s time to catch up with Angular 7. In this session, we will review a simple Single Page Application (SPA) built with the Angular 7 framework, TypeScript and Bootstrap. We will also look at the Angular Command Line Interface (CLI), used to create and manage Angular applications.

Speaker(s):

Ryan Richard

Track and Room: .NET Dev - 1425 (.NET Dev)

Abstract: Data privacy regulations in Europe and California are forcing companies to take a closer look at their personal data protection measures or face serious fines. With the potential for more regulations looming, many companies are using the framework of recent regulations to improve their data protection, regardless if they are subject to specific laws.

Speaker(s):

John Graff

Track and Room: CIO/Executive - 1325 (CIO)

Title: Intro to Query Store

Abstract: In this session, we will look at the new Query Store feature in SQL Server 2016 and 2017. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse in 2016.

Then in 2017, Microsoft added wait stats per query plan and Automatic Plan Correction capabilities. Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.

In this session, we will walk through the features of Query Store, so you can understand how to use them in SQL Server 2016 and 2017.

Speaker(s):

Tracy Boggiano

Track and Room: SQL Server Administration - 1620 (SQL Beginner)

Title: Birds of a Feather Conversations in the Auditorium

Abstract: Not hungry? This session will start during lunchtime. Come in and start up a discussion or use this time to continue your lunch discussions and meet new people that are interested in the same topics as you!

Azure BI and ML All things Containers PowerShell Mobile Dev .NET Core PowerApps

**Please note: This session will LSU does not allow food or drinks in the classrooms and auditorium.

Speaker(s):

Mike Huguet

Track and Room: Professional Development - 1510 (Auditorium)

Title: Big Data Clusters for the Absolute Beginner

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

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

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

Speaker(s):

Mohammad Darab

Track and Room: SQL Server Administration - 1745 (SQL Admin)

Title: Everything I know about UX I learned at Disney

Abstract: Walt Disney. Dreamer. Animation Pioneer. Filmmaker. UX Designer. This talk introduces the beginner (or beginner-at-heart) to lessons learned from the Disney, such as storytelling, understanding users, and data-driven design, in creating user experiences for guests and how they can be used to create better experiences for users of websites, applications, and other digital products.

Speaker(s):

Ricky Tucker

Track and Room: Professional Development - 1720 (Prof Dev 1)

Title: Ethical Computing

Abstract: This interactive discussion on Ethical Computing will inspire you to think about the cultural, social, and legal contexts of the digital experiences we create for humanity. Computing technologies including intelligent software and hardware artifacts are increasingly integrated into most aspects of our professional, social, and private lives. Intelligent Data technologies are running well in advance of public awareness, ethical reflection and regulatory frameworks. What will prevent the technological imperative from pushing us into places we don’t want to go?

Speaker(s):

Shermaine Haymer

Track and Room: AI and Machine Learning - 1845 (Big Data/PowerBI)

Title: Become a T-SQL Pivoting Ninja in 59.9 Minutes Or Less

Abstract: Would you like to create Pivot Tables in SQL with ease?

Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight. In this demo-heavy presentation, you will learn how to create pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator.

Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris. *Not Possible

Speaker(s):

Peter Doyle

Track and Room: SQL Server Development - 1700 (SQL Dev)

Title: Loading SQL Server Data with Powershell

Abstract: Powershell has become the defacto standard for scripting Microsoft products. However, putting data in text files doesn’t scale. Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections. We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting. This is a no holds barred session taught by an enterprise SQL Server scripting expert. You can’t afford to miss this session if you do any level of scripting in your shop.

Speaker(s):

Sean McCown

Track and Room: PowerShell - 1305 (PowerShell)

Title: Developer’s Intro. to Cosmos DB

Abstract: Introduction to Cosmos DB including database features and Azure setup. Will discuss major concepts like partitions, indexing, provisioned throughput, and more. The presentation includes a SQL Server comparison and a demo of the C# SDK using an ASP.NET application. Will explore modeling data in code and the SQL API for the document database model.

Speaker(s):

Brandon Brockhoeft

Track and Room: .NET Dev - 1510 (Auditorium)

Title: Mastering your Resume Interview: Tips to Get Hired

Abstract: Looking for a job? Learn trade secrets from a Recruiter! Resume blunders and interview tips, this session will focus on ten most important things you can do to get hired.

Speaker(s):

Christine Assaf

Track and Room: Professional Development - 1735 (Prof Dev 2)

Title: Microsoft Teams: Building a Project Management Solution in Office 365

Abstract: Looking to build a solution to streamline your company’s project management process? Need a collaboration solution for storing project artifacts, correspondence, and tasks? If so, then this session is for you. Join me as we step through a project management solution developed using SharePoint Online, Microsoft Teams, and Azure.

Speaker(s):

Cody Gros

Track and Room: Office 365/SharePoint - 1321 (Modern Azure Apps)

Title: Writing Award Winning PowerShell Functions and Script Modules

Abstract: Transitioning from writing PowerShell one-liners and basic scripts to creating reusable PowerShell tools with advanced functions and script modules can be a daunting task and with all the different ways that you’ll find on the Internet to accomplish the same task, it can definitely seem overwhelming. During this session, I’ll demystify many of the intricacies of toolmaking while demonstrating the best practices for using parameters, parameter validation, cmdlet binding, supports should process, pipeline input, error handling, module manifests, and custom formatting.

Speaker(s):

Mike Robbins

Track and Room: PowerShell - 1305 (PowerShell)

Title: Let it Flow: Data Flows in Azure Data Factory

Abstract: Azure data factory has been the main tool for copying data from one source to another. But it doesn’t do a good job transforming the data, relying on tools like DataBricks, U-SQL or stored procedures for data transformation. In May 2019, Microsoft made Azure Data Factory Data Flows available in public preview . This tool, which in some ways is as powerful or more so than the SSIS equivalents makes it possible to edit the data as it comes from a source to a destination. No more do you have to process the data to a file in order to change it in flight.

Speaker(s):

Russel Loski

Track and Room: Business Intelligence - 1321 (Modern Azure Apps)

Title: STEMupBR Kid’s Showcase

Abstract: Questions? Email sqlpassbr@gmail.com

Speaker(s):

Kenneth Neal

Track and Room: STEMupBR Kid’s Track - 1835 (Kids’ STEM Room)

Title: How to become a SQLSaturday Presenter, Step-by-Step

Abstract: In this hands-on interactive presentation you will learn how to plan and execute the strategies and tactics to become a SQLSaturday presenter sooner than you think.

Speaker(s):

Peter Doyle

Track and Room: Professional Development - 1845 (Big Data/PowerBI)

Title: Giving Feedback: How to Effectively Communicate to your Employees

Abstract: As a manager or team leader giving effective feedback is vital to the success of projects. In this session we will discuss soft skills and best practices to give feedback, performance improvement, and even disciplinary actions. Learn how to handle confrontation tactfully.

Speaker(s):

Christine Assaf

Track and Room: Professional Development - 1800(Analytics/BI)

Title: Documentation: A Habit and a Culture

Abstract: Documentation: Nobody writes it; nobody reads it; when you need it, it doesn’t exist. Learn how to break this cycle by identifying sources of documentation and compiling them into a knowledge base.

Speaker(s):

Jay Bienvenu

Track and Room: Professional Development - 1720 (Prof Dev 1)

Title: STEMupBR Track for Kids

Abstract: REGISTRATION REQUIRED http://bit.ly/SQLYouth

PARENTS MUST REMAIN ONSITE.

Questions? Email sqlpassbr@gmail.com

Want to volunteer? https://foundationebr.org/brstem/volunteer.html

Speaker(s):

Kenneth Neal

Track and Room: STEMupBR Kid’s Track - 1835 (Kids’ STEM Room)

Title: Azure Data Factory Ingestion Framework

Abstract: This session will teach you how to create an enterprise grade ingestion framework for a Data Lake using Azure Data Factory. We will walk through modeling the Data Factory Vault using Data Vault modeling as well as building fully dynamic pipeline to ingest metadata and data from multiple source types.

*Data Factory the right way.

Speaker(s):

Sean Forgatch

Track and Room: Business Intelligence - 1800(Analytics/BI)

Title: Are You Ready for the Modern SharePoint Experience?

Abstract: Are you ready for the Modern SharePoint experience? In this session, you will discover what Modern SharePoint is. Learn how to build Communication and Team sites, as well what their differences are. Explore modern document libraries, lists, and web parts. Customize SharePoint list forms with PowerApps. Add an interactive Power BI to a modern SharePoint site. Live demos included!

Speaker(s):

Theresa Eller

Track and Room: Office 365/SharePoint - 1321 (Modern Azure Apps)

Title: Organizational Behavior Voodoo! Learn how to get more effort out of your team.

Abstract: Feel like your team has a gris-gris (curse)? Motivating employee’s to care about their work and put effort into their jobs is hard. How do managers and team leads effectively guide employees in a way that makes them more engaged and productive? Learn some organizational behavior theory voodoo that can help ignite your team and maybe even yourself!

Speaker(s):

Christine Assaf

Track and Room: Professional Development - 1325 (CIO)

Title: Beginning T-SQL

Abstract: If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!

Speaker(s):

Jennifer McCown

Track and Room: SQL Server Beginner - 1620 (SQL Beginner)

Speakers

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

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

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

John Graff

LinkedIn: John Graff

Contact: http://www.sparkhound.com/blog/gdpr-does-your-organization-need-to-comply

John is the Director of Business Transformation for Sparkhound, a consulting company located in Baton Rouge.. He has over twenty years of combined experience in the banking, information technology, and consulting industries.

Over the years, John has successfully led projects for domestic and international companies. Examples of projects include financial software implementations, creating Project Management Office (PMO) strategies, and most recently data privacy initiatives.

Although John enjoys his professional career, the center of his life is his wife, Renee, and their two beautiful daughters, Gabrielle and Natalie. They are active parishioners of St. Aloysius Catholic Church and reside just on the outskirts of the LSU campus.

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.

Stacy Vicknair

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

LinkedIn: Stacy Vicknair

Contact: http://www.stacyvicknair.com

As the Software Engineering Manager at Netchex, Stacy focuses on two main things: people and process. In both responsibilities Stacy believes that he acts in service to those he works with throughout the organization and hopes that he helps shape an environment that his team members are proud to be a part of.

Stacy is certified as a Professional Scrum Master (PSM-I), Distinguished Toastmaster (DTM) and has numerous Microsoft certifications for software development and application life cycle management. Stacy was also awarded the Microsoft MVP award six years in a row from 2009 to 2015 based on his contributions to the tech community both locally and online.

George Mauer

Twitter: - @togakangaroo

Contact: https://github.com/togakangaroo/Blog

George Mauer is a software developer, speaker, teacher, writer, and comedian with an interest in the various techniques that can make software simple, extensible, and communicative. He is the owner of Humble Pi Software and currently a senior developer with Surge Consulting. He speaks regularly on Javascript, C#, Agile and other subjects, at usergroups, and to his cat.

Alexander Lemkin

LinkedIn: Alexander Lemkin

Contact: https://alemkin.com

Developer at Netchex

Bryan McCoy

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

LinkedIn: Bryan McCoy

Contact: http://bryanmccoy.rocks

Bryan is a Software Developer whose primary focus is on the web side of development. He has worked for the City of Baton Rouge, various consulting companies both locally and out of Chicago, and currently works for BCBSLA. By day his focus is on Microsoft stack, but by night he love all things Linux. He spends much of his time programing in C# and/or Javascript with frameworks such as Asp.Net Core, AngularJs, and React. Bryan’s newest passion is speaking and teaching others what he has learned over his career as a developer. He’s always looking for opportunities to get in front of people and share!

Kevin Cefalu

Twitter: - kevincefalu

LinkedIn: Kevin Cefalu

Contact: https://www.psibitdevelopment.com/blog/

Born on New Year’s Day, Kevin is a DevOps Engineer who spends his days improving life for his fellow developers and system administrators through automation for Netchex, a cloud-based human resource and payroll management solution. His passion motivates him to continually learn new concepts and technologies in order to apply them to the betterment of his colleagues. Outside of work, Kevin is a loving husband and dad to his dogs: Ajax (yes, that stands for Asynchronous Javascript and XML) and Callie. Kevin brings his love of development into projects like IoT devices or chatbots used in “pen and paper” style tabletop games. He is a capable chef, carpenter, electrician, and plumber who hopes to someday personally build a home for his family.

Cody Gros

Twitter: - codygros

Cody Gros is a Master Solutionist at Rogue Services and Solutions (“Rogue”), a consultancy founded to provide an expert level of service in leveraging the SharePoint platform to solve specific business problems. Certified by Microsoft as an MCITP, MCPD, MCTS, Cody served as a network administrator, SharePoint developer, principal consultant, and practice director before joining Rogue.

In his twelve years of SharePoint experience, he has served as an authority in custom development, configuration, and infrastructure. Cody has led SharePoint envisioning and roadmap planning initiatives, architecting designs and solutions, developing and implementing solutions, completing installs, migrations, and upgrades.

Aaron Kruger

Aaron Kruger serves as the Compliance Coordinator for Netchex. He has over 30 years of experience in securing classified and sensitive information in the military, public and private sectors. He is a certified HIPAA Compliance Officer and worked as a compliance consultant in the healthcare industry until he joined Netchex in 2018.

Jonathan Schellack

Twitter: - schellack

LinkedIn: Jonathan Schellack

Contact: https://schellack.net/jonathan

Jonathan has worked in IT for twenty years, from small software startups to large, billion-dollar companies. He recently started a new business called Salus Facilities, which builds software and systems that connect people and places to make them safer and more efficient.

Andy Yun

Twitter: - SQLBek

LinkedIn: Andy Yun

Contact: http://sqlbek.wordpress.com

Andy Yun is a SentryOne Principal Solutions Engineer and a former Microsoft MVP. He has been working with SQL Server for nearly 20 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQLSaturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQLSaturday Organizing Committee.

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.

Samir Behara

Twitter: - samirbehara

LinkedIn: Samir Behara

Contact: https://dotnetvibes.com/

Samir Behara is a Solution Architect with EBSCO Industries and builds software solutions using cutting edge technologies. He is a Microsoft Data Platform MVP with over 13 years of IT experience working on large-scale enterprise applications involving complex business functions, web integration, and data management in various domains like Insurance, Manufacturing and Publishing.

Samir is a frequent speaker at conferences such as PASS Summit, IT/Dec Connections, CodeStock, SQLSaturdays and CodeCamps. He is the Co-Chapter Lead of the Steel City SQL Server UserGroup, Birmingham, AL. He is the author of www.dotnetvibes.com

Tracy Boggiano

Twitter: - TracyBoggiano

LinkedIn: Tracy Boggiano

Contact: http://databasesuperhero.com

Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC.

Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com.

Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.

Andy Yun

Twitter: - SQLBek

LinkedIn: Andy Yun

Contact: http://sqlbek.wordpress.com

Scott Minar

Twitter: - SQLFox

Across 20 years of varying jobs in diverse industries, Scott always finds problems that can be solved by getting the right data in the right place. He currently serves as the T-SQL and SSIS SME for a small team of developers at a public school district and enjoys volunteering with the Houston SQLSaturday.

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Robert Canzonire

Twitter: - @sqltigers

LinkedIn: Robert Canzonire

Contact: http://www.sqltigers.com

Robert Canzonire is an Advisory Database Administrator for Blue Cross Blue Shield of Louisiana. He is the chair leader of the Virtual Chapter of Data Architecture for PASS. He holds several certifications including MCSE, MCSA and MCITP. He started with SQL Server in 1995.

Tom Shaw

LinkedIn: Tom Shaw

Tom has more than 30 years of IT experience with private- and public-sector organizations, including 8 years on the faculty at LSU. In his current position with GCR, Inc., he works on the Louisiana Secretary of State project as a Senior SQL Developer and DBA.

Valentino Moreign

Twitter: - ValMoreign

LinkedIn: Valentino Moreign

✥ Data Science ❲Applied AI/ML + Quant❳ ✥ Speaker ✥ Polyglot ❲English + semi-fluent Chinese/Mandarin, German, French❳… more info: https://www.linkedin.com/in/ValentinoMoreign «±»

Stuart Ainsworth

Twitter: - @codegumbo

LinkedIn: Stuart Ainsworth

Contact: http://codegumbo.com

Stuart Ainsworth (MA, MEd) manages a team of Service Reliability Engineers for the Gladiator Enterprise Information Security Services section of Profitstars, a division of Jack Henry and Associates. He’s a former DBA, developer, consultant, and public speaking professor. He’s one of the chapter leaders for AtlantaMDF, and a long-time organizer of SQLSaturday’s. He tweets infrequently (@codegumbo) and blogs even less often at http://codegumbo.com.

Michael Viron

Twitter: - mviron

LinkedIn: Michael Viron

Michael Viron has a wide range of experience as a senior IT manager amp; business owner. As Director of IT amp; Software Engineering at KAMedData, Inc, he has been heavily involved in coordinating numerous product launches amp; both company amp; division startups. A key team member, his main responsibilities include technical operations, project management, security, short and long range technical planning, and development. As owner of General Education Online, he handles both IT and business operations.

Shermaine Haymer

LinkedIn: Shermaine Haymer

Contact: http://neophyteprogrammer.blogspot.com/

Shermaine S. Haymer is a developer, problem solver, mentor and Technical lead. She has over 18 years’ experience working with government, contractor and private sector software implementations. She has a Master’s degree in Computer Science and currently works as a Technical Lead with Enterprise Content Records Management Software implementations and support for Access Sciences Corporation. Shermaine has a singular obsession with privacy, the consequences of rogue AI and the future of biometric facial recognition. In her spare time, she teaches coding and designs websites with Empower IT, a local IT services company. Shermaine is also passionate about encouraging girls to pursue STEM related disciplines.

David Reid

LinkedIn: David Reid

Biography of: Dave Reid, M.S, PHR, SHRM-CP, DTM, SSGB Management Instructor at The University of Louisiana at Lafayette, HR Professional, Distinguished Toastmaster Former District Leader. Expertise - Zenger-Miller leadership development modules, and Six Sigma Green Belt . Education - Bachelor and Master degrees from The University of Maryland and Indiana Wesleyan University respectively, majoring in Management Science. Prior to his HR career in Corporate America, he was a professional soldier leading globally in the U.S. Army, and Gulf War. His awards include: Toastmasters Area Governor of The Year and Excellence in Training and Education and as Outstanding Professional - Indiana Wesleyan University.

Rebecca Milazzo

LinkedIn: Rebecca Milazzo

Rebecca is a User Experience Designer at Netchex by day, Trekkie by night. She is fascinated by unique, memorable experiences both in person and digitally. This lead her to pursue a career in UI/UX where she focuses on users and how they interact with technology. Today, she manages a team that designs enhancements and new features for the Netchex product. Outside of work, Rebecca enjoys craft cocktails, live music, and kayaking the bayou.

Stuart Ainsworth

Twitter: - @codegumbo

LinkedIn: Stuart Ainsworth

Contact: http://codegumbo.com

Cody Gros

Twitter: - codygros

Tracy Boggiano

Twitter: - TracyBoggiano

LinkedIn: Tracy Boggiano

Contact: http://databasesuperhero.com

Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com.

Theresa Eller

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

LinkedIn: Theresa Eller

Contact: http://www.techresa.com

Theresa Eller is a SharePoint and Office 365 Administrator with a passion for customer success. Her diverse background includes degrees in Public Relations and Teaching and Learning with Technology, as well as 20 years of experience providing technical support, training, and project leadership. Theresa is a leader, speaker, and blogger in the SharePoint and Office 365 Community.

Jay Bienvenu

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

LinkedIn: Jay Bienvenu

Contact: http://bienv.com

Jay has worked in IT for almost two decades. He has developed software for a casino, an EMR software company, multiple manufacturers, and various government entities. He develops desktop applications, databases, websites, and retail software. He has worked with the Microsoft stack as well as JavaScript and other open technologies.

In his spare time, Jay works on personal projects that exercise his creativity, problem-solving skills and unique thinking. These projects include such varied things as an online role-playing system, a constructed written language, and a card game. He studies programming, linguistics, modern and archaic languages, politics and religion.

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.

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.

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.

Kenneth Neal

Twitter: - KennyNeal

LinkedIn: Kenneth Neal

Kenneth Neal is a SQL Server DBA with a background in business intelligence and just enough development experience to be dangerous. He focuses on process improvement and automation as part of his day job.

Kenneth is a member of the Baton Rouge User Groups Board and the scheduler for SQLSaturday Baton Rouge.

Zane Moreign

Twitter: - @ZaneMoreign

LinkedIn: Zane Moreign

Contact: https://zane.moreign.com

burgeoning Technologist, Speaker, Polyglot {English, Chinese/Mandarin, French, German, some Spanish} … more info https://www.linkedin.com/in/ZaneMoreign/ «±»

Russel Loski

Twitter: - sqlmovers

LinkedIn: Russel Loski

Contact: http://www.sqlmovers.com

Ryan Richard

I am currently a software developer in Baton Rouge, LA. I have worked in the IT industry for the past 18 years, including stints as a systems engineer, a DBA, and most recently as a software developer. My current interests include web applications, Internet startups, and neural networks.

Mike Robbins

Twitter: - @mikefrobbins

LinkedIn: Mike Robbins

Contact: http://mikefrobbins.com/

Mike F Robbins is a Microsoft MVP on Windows PowerShell and a SAPIEN Technologies MVP. He is a co-author of Windows PowerShell TFM 4th Edition and is a contributing author of a chapter in the PowerShell Deep Dives book. Mike has written guest blog articles for the Hey, Scripting Guy! Blog, PowerShell Magazine, and PowerShell.org. He is the winner of the advanced category in the 2013 PowerShell Scripting Games. Mike is also the leader and co-founder of the Mississippi PowerShell User Group. He blogs at mikefrobbins.com and can be found on twitter @mikefrobbins.

Christine Assaf

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

LinkedIn: Christine Assaf

Contact: https://www.hrtact.com

Christine Assaf is an experienced HR pro who is passionate about the mental health of employees, leadership, and organizations. She is a leadership development professional with over 15 years experience in human resources and 20 years in business management. She holds a BS in Business Management, received her HRM certification at LSU, and is finishing up her master’s degree at Colorado State University in Industrial and Organizational Psychology. She is a certified DDI Trainer, experienced public speaker, and is dedicated to teaching others about ways to support a culture of “expressiveness” in the workplace that creates connectivity.

Ricky Tucker

Twitter: - tucktales

LinkedIn: Ricky Tucker

Ricky Tucker is the Program Manager and Associate Professor in the Entertainment Technologies department at Baton Rouge Community College where he teaches Interactive Development and Digital Film Production courses. A native of New Orleans, he has been a part of numerous projects ranging from stage productions to video games. In his free time, he is a Disney/ Marvel/ Star Wars fanatic and enjoys spending time with his wife and two kids.

Anthony Nocentino

Twitter: - nocentino

LinkedIn: Anthony Nocentino

Contact: http://www.centinosystems.com/blog/

Anthony Nocentino is the founder and President of Centino Systems as well as a Pluralsight author, Microsoft Data Platform MVP, Linux expert, and corporate problem solver. Anthony designs solutions, deploys the technology, and provides expertise on business system performance, architecture, and security. Anthony has a Bachelors and Masters in Computer Science with research publications in high performance/low latency data access algorithms and spatial database systems.

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

Sean Forgatch

Twitter: - 4gatchsql

LinkedIn: Sean Forgatch

Contact: https://www.modern-dataengineering.com

Sean Forgatch is a Manager in Data Engineering consulting Avanade\Accenture based out of Chicago, IL focusing on Data Strategy, EIM , and Data Archtiecture. Serving multiple Fortune and Global 500 companies he has helped push the limits of Azure and is working on some of the largest Azure Data Lake and Analytics implementations in the industry. He has spoken at over 25 conferences across the United States since 2016, was the President of the Northeast Wisconsin PASS, and served on the board for SQLSaturday Madison.

Originally from Southern Illinois, Sean enjoys running and lifting, as well as casual conversations with coffee, and spending time with his dog Sailor, an all white Siberian Husky.

Jonathan Jefferson

Twitter: - @BRSQLBlerd

LinkedIn: Jonathan Jefferson

SQL enthusiast and amateur DBA on occasion. I’m currently working to remove the amateur part.

Theresa Eller

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

LinkedIn: Theresa Eller

Contact: http://www.techresa.com

Tim Radney

Twitter: - @tradney

LinkedIn: Tim Radney

Contact: http://www.timradney.com

Peter Doyle

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

LinkedIn: Peter Doyle

Sean McCown

Twitter: - @KenpoDBA

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

Kenneth Neal

Twitter: - KennyNeal

LinkedIn: Kenneth Neal

Kenneth is a member of the Baton Rouge User Groups Board and the scheduler for SQLSaturday Baton Rouge.

Christine Assaf

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

LinkedIn: Christine Assaf

Contact: https://www.hrtact.com

Mike Robbins

Twitter: - @mikefrobbins

LinkedIn: Mike Robbins

Contact: http://mikefrobbins.com/

Balaji Nedurumalli

LinkedIn: Balaji Nedurumalli

Balaji’s role at his company is to drive strategic decisions based on data and intel. He started his career as a systems programmer and gradually wore multiple hats in IT department before taking focus on Business Development, Strategy and Business Intelligence. He has Masters degrees in Business Administration, Engineering, Analytics that allows him to see things in different perspective.

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

Christine Assaf

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

LinkedIn: Christine Assaf

Contact: https://www.hrtact.com

Peter Doyle

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

LinkedIn: Peter Doyle

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.

Kellyn Pot’Vin-Gorman

Twitter: - DBAKevlar

LinkedIn: Kellyn Pot’Vin-Gorman

Contact: http://dbakevlar.com

Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and an Idera ACE and Oracle ACE Director alumnus. She is a Data Platform Architect in Power BI with AI in the EdTech group at Microsoft. Kellyn is known for her extensive work with multi-database platforms, DevOps, cloud migrations, virtualization, visualizations, scripting, environment optimization tuning, automation, and architecture design.

Kellyn has spoken at numerous technical conferences for Oracle, Big Data, DevOps, testing, and SQL Server. Her blog (http://dbakevlar.com) and social media activity under her handle, DBAKevlar, is well respected for her insight and content.

oscar garcia

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

LinkedIn: oscar garcia

Contact: https://ozkary.com

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

Andrew Barefield

Twitter: - abarefieldsays

LinkedIn: Andrew Barefield

Andrew Barefield is an Engineering Manager at CGI where he works to build sustainable teams that deliver value. He has worked as an IT project manager, Scrum Master, and a even a sales manager (in a prior life!). He founded and facilitates a Scrum Master community of practice at CGI, and is always looking for ways to strengthen relationships across the enterprise.

Most recently, Andrew leads teams that innovate and transform the delivery of an ERP system, and accelerate the development of a new greenfield, Cloud-native application and service.

Andrew lives in Lafayette, LA with his wife and their two daughters.

Anthony Nocentino

Twitter: - nocentino

LinkedIn: Anthony Nocentino

Contact: http://www.centinosystems.com/blog/

Mohammad Darab

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

LinkedIn: Mohammad Darab

Contact: https://mohammaddarab.com

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

Mike Huguet

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

LinkedIn: Mike Huguet

Mike Huguet is a Senior Software Engineering Manager at Microsoft focusing on features that aid customers and partners in improving the quality of their PowerApps and customizations to their Common Data Services and Dynamics 365 CE solutions. He has been a software professional for nearly twenty years.

Mohammad Darab

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

LinkedIn: Mohammad Darab

Contact: https://mohammaddarab.com

John Harvey

LinkedIn: John Harvey

Contact: https://www.sparkhound.com/blog?author=5d01007b6ca3610001bf7548

John Harvey is a Senior Application Development Consultant at Sparkhound in Baton Rouge. In 2011 he earned a M.S. in Computer Engineering at LSU. Since then he has worked on a variety of projects spanning embedded systems, healthcare, and eCommerce. He is currently interested in Angular, .NET Core, and maybe Rust (if only he could find a good excuse to use it).

Mike Huguet

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

LinkedIn: Mike Huguet

Brandon Brockhoeft

Twitter: - @bbrockhoeft22

LinkedIn: Brandon Brockhoeft

Brandon Brockhoeft is a career software engineer working primarily with Microsoft solutions with over 15 years of professional experience. He is an LSU alumnus and native of the Baton Rouge area. Brandon is employed as a Principal Consultant for Austin-based Headspring custom software consultancy. He has provided development and architecture technology solutions in the finance, state government, energy, and aerospace industries. Brandon’s functional expertise includes: full-stack development, distributed architecture, real-time communication, DevOps and agile transformation, mentoring.

Jeremy Cronan

I have been a developer for over 10 years. I am currently the Application Developer at the Alliance Safety Council. I am proficient in ASP.NET using VB.NET and C#.

Jennifer McCown

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

LinkedIn: Jennifer McCown

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

Kellyn Pot’Vin-Gorman

Twitter: - DBAKevlar

LinkedIn: Kellyn Pot’Vin-Gorman

Contact: http://dbakevlar.com

SQLSaturday #867 - Baton Rouge 2019

Sessions

Title: A Map To Success: Functional Programming For Database Developers

Title: Approaching Zero: Minimizing Downtime During Deployments

Title: Climbing the SQL Server Index B-Tree

Title: Taming of the Shrew - Optimizing Power BI

Title: Be Part of the Solution with Automation

Title: Designing Data Intensive Cloud Native Applications

Title: Monster Text Manipulation: Regular Expressions for the DBA

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

Title: 3 Keys to Successful Consulting

Title: PowerShell + SQL Server = Better Together

Title: Using Open Source Software to Collect Performance Metrics

Title: Database People and DevOps: The Fundamentals

Title: Containers - You Better Get on Board!

Title: Building Quality Web APIs with Asp.Net Core

Title: Common SQL Server Mistakes and How to Avoid Them

Title: Azure for the Production Data Professional

Title: Careers in IT - Baton Rouge 2019

Title: 7.5 Steps to Social Media Marketing Domination for Employees, Entrepreneurs and Aspiring Influencers

Title: Azure Databricks (ADB) and the Traditional DBA

Title: All (Data) Things Considered: The Lean Coffee Workshop

Title: Building, Debugging Deploying Containerized .NET Apps in Visual Studio

Title: The Game Master’s Guide to People Management

Title: TDD With No Tears

Title: Goodbye Classes: Writing React the Functional Way

Title: Simple_Safety™ > $0 Tools-n-Tips for Non-Techies and Techies

Title: Azure Automation with PowerShell: Scripting Away the Problems of Yesterday

Title: T-SQL Tips Tricks to Make Your Life Easier!

Title: PrequelSaturday - How the SQL Server community is about to make your job easier

Title: How to index, win friends, and influence people.

Title: Feeling SETSy?

Title: Lightning Fast Backups

Title: Why There are No Code Problems, Only Organizational Culture Problems

Title: Monitoring SQL Server with Telegraf/InfluxDB/Grafana – Lessons from the Trenches

Title: Improve Dist`d System Web App Performance Using In-Memory Cache

Title: Employee On-boarding - building business solutions in modern SharePoint

Title: Consumer Bill of Rights: Your Data and Changing Privacy Laws in 2020

Title: Serverless Cloud Computing: Promises and Pitfalls

Title: Inside Kubernetes - An Architectural Deep Dive

Title: Extend Azure DevOps with a Custom PowerShell-based Pipeline Task

Title: Customizable User Interfaces with Dynamic Components in Angular

Title: A Beginner’s Guide to Seven Practices that Kill Performance

Title: Managing ETL Change using BIMLScript

Title: Communicating with Non -Techies

Title: How to Develop Without a Designer

Title: A Self-Tuning Fill Factor Technique for SQL Server

Title: The Latest SharePoint Features: What They Are and Why They Matter

Title: Catching up with Angular 7

Title: GDPR: Does your organization need to comply?

Title: Intro to Query Store

Title: Birds of a Feather Conversations in the Auditorium

Title: Big Data Clusters for the Absolute Beginner

Title: Everything I know about UX I learned at Disney

Title: Ethical Computing

Title: Become a T-SQL Pivoting Ninja in 59.9 Minutes Or Less

Title: Loading SQL Server Data with Powershell

Title: Developer’s Intro. to Cosmos DB

Title: Mastering your Resume Interview: Tips to Get Hired

Title: Microsoft Teams: Building a Project Management Solution in Office 365

Title: Writing Award Winning PowerShell Functions and Script Modules

Title: Let it Flow: Data Flows in Azure Data Factory

Title: STEMupBR Kid’s Showcase

Title: How to become a SQLSaturday Presenter, Step-by-Step

Title: Giving Feedback: How to Effectively Communicate to your Employees

Title: Documentation: A Habit and a Culture

Title: STEMupBR Track for Kids

Title: Azure Data Factory Ingestion Framework

Title: Are You Ready for the Modern SharePoint Experience?

Title: Organizational Behavior Voodoo! Learn how to get more effort out of your team.

Title: Beginning T-SQL

Speakers

Sponsors