SQLSaturday #909 - San Diego 2019

Event Date: 09/21/2019 00:00:00

Event Location:

UCSD Extension - University City Center
6256 Greenwich Dr.
San Diego, California

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: Automate tests in your database with tSQLt

Abstract: tSQLt is an easy-to-use database unit testing framework for Microsoft SQL Server. It is ideal for the database developer because tests are written in T-SQL.

This session explores how and why application unit testing is performed, and then focuses on unit testing database code with tSQLt. We will learn how tests are structured, and how to set up realistic tests. We will talk about how much testing coverage is enough and when you can stop.

Even if you aren’t able to fully implement Test Driven Development tomorrow, you’ll walk away knowing how to future-protect that next tricky bit of logic with tests that will ensure your code produces desired results, not only the first time, but with all future modifications as well.

Speaker(s):

Janice Gerbrandt

Track and Room: Application Database Development - 311

Title: Data Modeling Trends for 2019 And Beyond1

Abstract: It is so difficult to model data today. The number of products the average company uses to store data has exploded. The database vendors are competing and releasing features at an astounding rate. The cloud vendors have also accelerated the pace of change. In analytics, some people say there is no need for a star schema. In transactional systems, some people say that the EF Codd era is over and we can repeat data as often as we want. One blog writer says one thing, while another contradicts them. These things are creating a confusing atmosphere for the data modeler.

It is true that data modeling has changed, but there is no need to throw out great practices that have served us for years and can continue to do so. This session will cover what has changed for data modeling, why it changed, and how to take advantage of those changes. Combine new thinking with classic data architecture and you will create great analytic and transactional systems for your data.

Speaker(s):

Ike Ellis

Track and Room: Data Science, Analytics and Visualization - 309

Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming

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

Speaker(s):

Diane Schuster

Track and Room: BI Architecture, Development Administration - 317

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: Enterprise Database Administration Deployment - 311

Title: What just happened? Creating your own real-time dashboard with Grafana, Influx, and Telegraf

Abstract: You wear many hats, know your KPI, fight those fires, and are used to – but still scared of – “hey, what just happened?”

As a DBA, you very likely have SQL Server well covered, but what about if/when you support Cassandra? Mongo? MySQL? What if you’re DevOps and need something from ASP .Net? IIS? Nginx?

In this interactive session, we’ll go over show you how to locally install and configure InfluxDB to store your data, get Telegraf to pull, and with Grafana, create some quick dashboards. Time permitting, we can set some thresholds, and send them to Slack.

All of these tools are completely free, and if you don’t have the right monitoring, or any, this is perfect for you.

Speaker(s):

Patrick Partin

Track and Room: Enterprise Database Administration Deployment - 111

Title: One key to rule them all - how to effectively destroy data consistency, and ruin query performance

Abstract: Every beginner knows that every table has an identity primary key, supported by a clustered index. If I told you that these keys that you take for granted, are the primary factor that destroy your database’s consistency, performance, scalability, and modularity, you’d probably think I’m crazy. But what if I can prove it, scientifically, and beyond any reasonable doubt? “It ain’t what you don’t know that gets you into trouble. It’s what you know that just ain’t so…” Join me on this fascinating journey down the rabbit hole, where we will shed new light on some of the most fundamental aspects of database design. You will experience hands-on how you can drastically improve your database consistency, simplify your queries, improve performance by orders of magnitude, allow for unprecedented scalability, and modularity. Prepare for a paradigm shift. By the end of this session, you will chant with me: “The key, the whole key, and nothing but the key, so help me Codd”.

Speaker(s):

Ami Levin

Track and Room: Application Database Development - 111

Title: Reporting Services: A Smart Migration Strategy

Abstract: With Power BI Report Server, you can host traditional paginated reports alongside Power BI analytical reports, KPIs, and mobile reports. This session will show how to use the data in the ReportServer database to determine a smart migration strategy for upgrading to a new SSRS or Power BI Report Server. Starting with the new features of Report Manager, Mobile Reports, KPIs, and the Mobile Report Publisher app. The session will then focus on how to utilize the report meta data in the ReportServer database, combined with the transaction log table, to show how to determine which reports, data sets, and data sources are being used and determine what objects to migrate.

Learn how to use PowerShell to extract the reports and data sets from the database, instead of downloading them, to facilitate an easy migration to a new implementation. Also, discover a way of determining all TSQL used by the reports. This session is particularly useful for migrating from 2008, but applicable to any migra

Speaker(s):

Ted Stathakis

Track and Room: PASS Summit Preview - 316

Title: The Master Stored Procedure Workshop: Part 1

Speaker(s):

Sean McCown

Track and Room: Application Database Development - 311

Title: Confidence – The Best Super-Power

Abstract: Have you thought about wanting to do something and thought you may not be successful at it, so it then became too much work to try? The American Pastor Robert Shuler famously asked a very powerful question: “What would you do if you knew you could not fail?” Confidence allows us to dream big and gives us the fuel to escape from a world of apathy. It gets us out of bed ready for action; ready to do something that will move us towards achieving whatever goal we set for ourselves. Without the confidence to at least try, we are sure to fail. If we try, but only half heartedly because we lack confidence, we will likely fail. Confidence will improve your odds of success in any endeavor.
Confidence is only 25% genetic. Let’s improve the other 75%.

Speaker(s):

Melody Zacharias

Track and Room: Professional Development/Other - 315

Title: Reporting Services Introduction

Abstract: This introduction to Reporting Services is for the novice user with no previous exposure to Reporting Services. This session will walk through getting data for the report though publishing and using the report.

Do you wish you could quickly and easily get some or your data into the hands of your end users? Well… SQL Server Reporting Services (SSRS) is part of SQL: You’ve already paid for it, so put it to use! In this introductory level session designed for users with no exposure to SSRS we will cover the basics of developing, publishing and using SQL Server Reporting Services. From building a data set through automating report delivery you will learn how you can return to the office and present meaningful data to your end users with minimal time and effort. Come learn how this very powerful and easy to use tool can relieve you from data delivery tasks and thrill your end users all at the same time.

Speaker(s):

Ted Stathakis

Track and Room: BI Architecture, Development Administration - 112

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/Other - 113

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: Data Science, Analytics and Visualization - 112

Title: Using Columnstore indexes in Azure DevOps Services. Lessons learned

Abstract: The Analytics service in Azure DevOps Services provides all-over insights to your DevOps data: work item tracking, CI/CD pipelines, testing process etc. Built on top of columnstore indexes, the Analytics service has to deal with 100s of millions records and daily growth in 10s of millions, only a few minutes delay from operation store, sub second query performance for in-product experiences as well as 3rd party extensions, Power BI integration and ad-hoc queries. Working on it, I’ve learned a lot of DOs and DON’Ts about columnstore indexes. Session covers how to:

partition columnstore indexes in a multitenant environment
maintain columnstore indexes in case of updates and/or purge to keep segment elimination possible
evolve database schema without downtimes and maintenance windows
design to benefit from predicate and aggregation pushdown
deal with edge case like ad-hoc queries for raw data and paging
choose between CCI and NCCI based on usage patterns

Speaker(s):

Konstantin Kosinsky

Track and Room: Application Database Development - 316

Title: Assessing and Planning SQL Database Migrations to Azure

Abstract: Today’s enterprise is evolving at a rapid pace by taking advantage of what cloud services can offer. By leveraging cloud’s scalability, companies are re-architecting their data centers while doing cost optimization. In this presentation, we will do assess the on-premises environment and determining what workloads and databases are ready to make the move and what can you do to improve their Azure readiness while reducing downtime during the migration. Planning and assessment plays a critical role in moving to the cloud. We would see wide range of resources and tools to get assessment completed with ease while identifying workload dependencies with practical tips and tricks focusing on sizing and costs. And finally, we’ll assess the SQL instances and identify their readiness for Azure as well. By the end of this presentation , you’ll be able to confidently identify your on-premises workloads and databases that are Azure-ready, or almost ready.

Speaker(s):

Manguirish Sardessai

Track and Room: Cloud Application Development Deployment - 111

Title: From the Trenches - Case Study of a Data Warehouse Migration Upgrade

Abstract: There’s an old adage about rebuilding the airplane while you’re flying it. That sounds a bit like our recent project - planning executing a hardware migration, and SQL/OS upgrade, of a complex Data Warehouse environment. The components include: multi-TB DBs, SSIS (mix of SSISDB Catalog old-school Pkg Store), SSRS (via SharePoint integration), SSIS, SSAS (mix of MDX Tabular), WhereScape, DNS Aliases, multiple job schedulers, various drivers/scripts/apps, and implementation of an AlwaysOn AG.

We’ll outline pitfalls to avoid, and walk you through hard-won lessons and strategies for success. We’ll discuss our automated process for continuous deployment, which greatly reduced downtime and risk. Of course, we’ll share relevant technical tips tricks. Possible guest-starring appearances from Chris and Dan, who were key players in the success of this project.

Speaker(s):

Thomas Hull

Track and Room: Enterprise Database Administration Deployment - 113

Title: Big Data, Big Dupe: A little session about a big bunch of nonsense.

Abstract: If data is the new oil, then Big Data is the new snake oil. For over a decade, Big Data has managed to delude far too many smart, honest, hard-working data practitioners, with nothing but the best intentions. This session is a plea for your common sense and decency. Together, we will use history, facts, authority, and logic to expose it for what it really is. Layer by layer, we will peel off the Confusion, Illusion, Deception, Distraction and the Regression that is “Big Data”. You will realize just how much progress and value Big Data has bestowed on us over the past decade. But more importantly, we will see what we can and must do to make data practice, and consequently the world, a better place. Brace yourself for a thought-provoking session, filled with “Aha” moments. I promise that after this session, you will never look at big data the same way as you did before you stepped into the room.

Speaker(s):

Ami Levin

Track and Room: BI Architecture, Development Administration - 111

Title: Dive into the Query Optimizer - Undocumented Insight

Abstract: This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.

Speaker(s):

Benjamin Nevarez

Track and Room: Application Database Development - 309

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: Enterprise Database Administration Deployment - 317

Title: Table Diaspora - A Tale from the Trenches

Abstract: Have you ever needed to migrate a table from one database to another with zero downtime? Or perhaps needed to do an operation that would normally require an aggressive/long-duration lock? What if you needed to do the same thing to dozens of tables‽

You’ll never believe it - this happened to me! In this session, I’ll outline how I did it. You’ll learn about triggers, computed columns, module signing, SSIS, and just enough BIML to be dangerous.

Speaker(s):

Ben Thul

Track and Room: Enterprise Database Administration Deployment - 301

Title: Setting up a test lab with Hyper-V

Abstract: So, you want to play with SQL server and/or Windows Server but you don’t have extra hardware lying around. In this session I’ll go over creating the necessary virtual networking and virtual machines to allow you to do this and protect your local network from possible harm.

Speaker(s):

Jay Falck

Track and Room: Professional Development/Other - 113

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 Architecture, Development Administration - 112

Title: How to build a T-SQL Framework

Abstract: What is a T-SQL framework and how will it help you as a developer.

In this session we will create a framework that we can leverage through a template that will take care of the tedious tasks that come with development. These tasks or features include audit logging, designing a dynamic data driven error handling process, and control level batching in order to document, troubleshoot, and base line your code base. Once these features are developed you can spend more time in doing what really needs to happen like developing logic to perform processes while allowing the framework to control the necessary error handling tasks for you so you can continue to produce rapid development code.

Speaker(s):

Jared Kirkpatrick

Track and Room: Professional Development/Other - 112

Title: Getting Started with Azure Databricks Delta

Abstract: Databricks Delta is a single data management tool that combines the scale of a data lake, the reliability and performance of a data warehouse, and the low latency of streaming in a single system for the first time. This session will go over the basics of what Databricks Delta is and how it can be used as part of your Data Platform.

Speaker(s):

Andrew Karcher

Track and Room: Data Science, Analytics and Visualization - 316

Title: SQL Query Foundations

Abstract: Prerequisite: None. Some prior experience with SQL will be helpful. This tutorial will focus on crucial foundational knowledge needed to retrieve data from SQL tables, i.e., the “R” (Read) in CRUD. Throughout, the emphasis is on concepts, rules, and avoiding “gotchas” - not on syntax. Topics covered will include: A review of SELECT statement, Logical Execution Order of SQL SELECT’s clauses, How SQL JOINs work, NULL values, etc.

Speaker(s):

Amod Singhal

Track and Room: Application Database Development - 311

Title: ETL, Introduction to SSIS, and third-party tools like MelissaData and CozyRoc

Abstract: We will discuss ETL software, have an intro to SSIS basics, create a basic package, and implement third-party tools like MelissaData and CozyRoc

Speaker(s):

Steve Rezhener

Track and Room: BI Architecture, Development Administration - 301

Title: Power BI Dataflows and How to Leverage for Data Science

Abstract: This session will give you an introduction to Power BI dataflows and how to leverage the data for data science. Power BI dataflows allow for self service data migration into Azure Data Lake Services gen 2 utilizing Power Query. This session will show how to user dataflows and how to connect to the resulting data in the Azure Data Lake Services gen 2 to do Data Science with tools like Azure Databricks.

Speaker(s):

Jamey Johnston

Track and Room: Data Science, Analytics and Visualization - 301

Title: Pure Storage: How Fast Can You Restore Your Database?

Abstract: Availability Groups and Clustering are great but they only protect you against hardware failures. DBA’s still need to rely on backups to set up AGs, initialize replication, recover from data corruption and more. Join us to discuss how you can restore your database in minutes and not hours.

Speaker(s):

Marsha Pierce

Track and Room: Enterprise Database Administration Deployment - 309

Title: Getting started with Azure Database for PostgreSQL

Abstract: Azure Database for PostgreSQL is a relational database service based on the open-source Postgres database engine. It’s a fully managed database as a service offering that can handle mission-critical workloads with predictable performance, security, high availability, and dynamic scalability. This session will take you through the basics of Azure Database for PostgreSQL, setting it up, connecting, and building applications on it.

Speaker(s):

Andrew Karcher

Track and Room: Application Database Development - 113

Title: How to Be an MVP (in Life and a Microsoft MVP)

Abstract: Many times we look at the success of others and think it is beyond us. In this session, 12 time Microsoft MVP and author of How to Be an MVP in Life, David Lundell, will share stories from fellow Microsoft MVPs, and some sports MVPs illustrating key attribute in professional and personal development relating to becoming a Microsoft MVP, and even more importantly becoming an MVP in Life.

Speaker(s):

David Lundell

Track and Room: Professional Development/Other - 317

Title: Utilizing AI to Predict Customer Churn

Abstract: theDevMasters, an AI Company will host a hands-on workshop on how employers can use AI to help predict customer churn. The session is open for all knowledge levels.

In this session theDevMasters will take you on a journey into AI and machine learning algorithms. We will not go into much of the math behind them, but instead learn what each algorithm is good for, and how to train them.

Speaker(s):

Zia Khan

Track and Room: Data Science, Analytics and Visualization - 316

Title: Azure Data Lakes and Data Warehouses:

Abstract: This session will break down the options you have in Azure to build a data analytics ecosystem, and explain why everyone’s talking about data lakes and where’s best to build your data warehouse. We will cover the fundamentals of data lakes and modern practices in cloud data warehousing on Azure.

Speaker(s):

Dustin Vannoy

Track and Room: PASS Summit Preview - 309

Title: Know What Your Code is Doing to SQL Server!

Abstract: ORMs - oh how I LOVE them! As a consultant, when I see them in play at a client I go KACHIIINNNNGGGG!! :-D Seriously though, they can provide some substantial benefits for coding throughput. But if you don’t Read The Fine Manual and do some things right and avoid some major gotchas, you will fall prey to one of my favorite Guruisms: “Anything that allows developers to slap code together more quickly is inversely proportional to the performance, concurrency and scalability you will get from that code”! Although this talk is based on Entity Framework, all ORMs suffer from the same flaws.

Speaker(s):

Kevin Boles

Track and Room: Application Database Development - 317

Title: Azure SQL Database Edge - Tiny but mighty

Abstract: Have you ever thought what would it be like to run SQL Server engine in a small footprint? Well, wait no more.

Running on Arm and x64 architecture with a reduced footprint, the proven performant and most secure Microsoft SQL engine is coming to the Edge in interactive devices and edge gateways. Combining new capabilities on data streaming and time-series, with in-database machine learning (ML), Azure SQL Database Edge is optimized for low-latency analytics right on the Edge. This session will showcase the scenarios Azure SQL Database Edge can enable.

Speaker(s):

Julie Koesmarno

Track and Room: Enterprise Database Administration Deployment - 301

Title: T-SQL Tools: Using JSON as a Data Source

Abstract: In this session we will look into different methods focusing on effective use of T-SQL to ingest JSON data and explore ways to bridge the gap between structured and semi-structured data.

We will look at the benefits of a loosely defined schema and how to transform the data to work in a relational model.

Speaker(s):

Martin Perez

Track and Room: Application Database Development - 111

Title: Virtualizing SQL Server

Abstract: An overview of what you need to do to virtualize SQL Server

Speaker(s):

Marsha Pierce

Track and Room: Enterprise Database Administration Deployment - 301

Title: Basic Windowing Functions

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

Speaker(s):

Mike Burek

Track and Room: Application Database Development - 112

Title: How to Get SQL Server to Run Better on Crappy Hardware.

Abstract: Many of us have to deal with hardware that doesn’t meet our standards or contributes to performance problems. This session will cover how to work around hardware issues when it isn’t in the budget for newer, faster, stronger, better hardware. It’s time to make that existing hardware work for us. Learn tips and tricks on how to reduce IO, relieve memory pressure, and reduce blocking. Let’s see how compression, statistics, and indexes bring new life into your existing hardware.

Speaker(s):

Monica Rathbun

Track and Room: Enterprise Database Administration Deployment - 309

Title: T-SQL Tools: Change Automation with Change Data Capture

Abstract: Target Audience:

Data professionals interested in reducing development time for ETL or Reporting work.

In this session we will introduce you to Change Data Capture set up, usage and administration exploring different ways you can audit data changes, populate a reporting database all while saving time.

Speaker(s):

Martin Perez

Track and Room: BI Architecture, Development Administration - 311

Title: Columnstore Indexes for Everyone

Abstract: Columnstore indexes are available to all SQL Server editions, Express to Enterprise, starting with SQL Server 2016 Service Pack 1. They can save disk space, increase query performance, and combine OLTP and OLAP workloads. Should you change all your tables to columnstores? Let’s find out!

Speaker(s):

Mike Burek

Track and Room: Application Database Development - 315

Title: Tune Like a Guru - The Big Three!

Abstract: EVERY client I engage with is taught to RUN 3 SCRIPTS IMMEDIATELY, WITHOUT THOUGHT AND WITHOUT DELAY as soon as a performance problem is noted. I am exceptionally good at performance tuning and forensics, but I (nor anyone else out there) cannot get at the root cause of a problem without information about the occurrence. These scripts will give you said information, which is very often transient in nature! I could be putting myself out of work teaching stuff like this! :-D

Speaker(s):

Kevin Boles

Track and Room: Application Database Development - 317

Title: Not Your Grand Mother’s AI

Abstract: What was AI in the past, what is it now and where will the future take us? Data Science, Azure Machine Learning, and Analytics are all becoming core pieces of a many successful businesses. What are people doing with it and how can it be used in all aspects of business. As data professionals, we need to know how these core pieces will affect what we do, and how we can use the Azure AI suite to help our clients. Using an easy to follow example, I will show the flow from problem to solution. A demonstration of AI used in the real world.

Speaker(s):

Melody Zacharias

Track and Room: Data Science, Analytics and Visualization - 315

Title: I’m It - Survival Techniques for the Lone DBA

Abstract: Are you the only database person at your company? Are you both the DBA and the developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering.

This session will cover how you can keep your sanity, get stuff done, and still love your job. We’ll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you’ll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.

Speaker(s):

Monica Rathbun

Track and Room: Professional Development/Other - 317

Title: Women in Technology Panel Discussion

Abstract: Join this panel to discuss the state of diversity in our industry and agents for change.

Speaker(s):

Melody Zacharias

Track and Room: Professional Development/Other - 316

Title: Running SQL Server on AWS

Abstract: Learn how Amazon Relational Database Services (RDS) helps SQL Server DBAs focus their time where it matters most. We will cover Amazon RDS for SQL Server features and the key differences between running deployments on Amazon Elastic Cloud Compute (EC2) and Amazon RDS. This will include HA/DR and performance monitoring.

Speaker(s):

Richard Waymire

Track and Room: Cloud Application Development Deployment - 309

Speakers

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

Jared Kirkpatrick

My life in the tech world started at Dell a little before the Windows 95 release. I started my MCSE there and took the Database track toward a MCDBA and never looked back. I’ve been head down in data ever since. My first exposure to SQL Server was with SQL 6.5. In addition to schooling at Wentworth Military Academy and two years at Southwestern University in San Marcos, Texas, my certifications are MCP, MCP+I, MCSE (NT 4.0), and MCDBA (2000). During my SQL journey, I have been a Supporting Author of SQL Server 2000 Blackbook, presenter at several PASS Chapters and at SQLSaturday, when it was still in the single digits! I was the IBM Principal Consultant for Honeywell and HR Logic, and Senior Developer for Match.com.

Benjamin Nevarez

Twitter: - @BenjaminNevarez

Contact: http://www.benjaminnevarez.com/

Benjamin Nevarez is a SQL Server independent consultant based in Los Angeles, California, who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning amp; Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals.quot; Benjamin has also been a speaker at many SQL Server conferences, including PASS Summit, SQL Server Connections, and SQLBits. His blog can be found at http://www.benjaminnevarez.com.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

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.

Melody Zacharias

Twitter: - SQLMelody

LinkedIn: Melody Zacharias

Contact: http://sqlmelody.com

Melody is the Sr. Microsoft Solutions Manager at Pure and has been in love with data since 1991. She has been sharing her passion with the community in technical sessions and blogs since 2014. She has been a Microsoft MVP since 2016, including winning Rookie of the year for Canada that year. This last year, she was elected to the board of directors for PASS.org, the professional association for SQL Server and was awarded Regional Director by Microsoft. She has co-authored 3 books, including, SQL Server 2019 Administration inside out by Microsoft Press.

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.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

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.

Andrew Karcher

Twitter: - @akarcher

Contact: http://www.andrewkarcher.com

Andrew is a Data Professional that is super passionate about the ability of data to drive change in our world, work, and personal lives. He has over 15 years of experience across multiple roles, companies and technologies. A passion for learning is core to how I approach life. Over 10+ years I have spoken at User Groups, Code Camps, SQLSaturdays and Conferences along with supporting my local community as a SQLSaturday Organizer, User Group leader, and advocate for community involvement for all technology professionals. I was also recognized by Microsoft as a four-time SQL Server MVP for my technical community contributions.

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.

Mike Burek

Twitter: - mikeburek

LinkedIn: Mike Burek

Contact: http://tikiwiki.mikeburek.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.

Steve Rezhener

Twitter: - SteveRezhener

LinkedIn: Steve Rezhener

Contact: https://www.datasteve.com

Steve Rezhener is a database professional most enthusiastic about Microsoft BI stack. He started his IT career trying to outsmart Excel using VBA, moved to VB 6.0, VB.NET, C# and suddenly got addicted to SQL Server 2005 and related tools. His lunch menu for 10+ years consisted of SSIS SSRS with some occasional SSAS for breakfast. Steve is super excited about the innovation baked into AWS, Azure, PowerBI, and SQL Server 2017. Steve is a holder of relics such as DBA Microsoft certifications on SQL Server 2005 and SQL Server 2008. He is an organizer of SQLSaturday in Los Angeles (#SQLSatLA), LA Data Platform (aka SQLMalibu) and is an SQLSaturday speaker. When he isn’t dealing with data, he fixes a kitchen, plays an XBOX and enjoys his kids.

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.

Janice Gerbrandt

Twitter: - @gerbyj

LinkedIn: Janice Gerbrandt

Contact: https://islandsql.com/

Janice has been designing and implementing database solutions to improve business functionality since 2001. She is an active PASS member and leads her local user group and a virtual group, as well as organizing SQLSaturday Victoria.

Andrew Karcher

Twitter: - @akarcher

Contact: http://www.andrewkarcher.com

Jay Falck

Twitter: - @jayfalck

LinkedIn: Jay Falck

Richard Waymire

Twitter: - rwaymi

LinkedIn: Richard Waymire

Richard Waymire is a technical expert on Microsoft SQL Server. He has been involved in numerous Microsoft early adaptor projects and new technologies. Richard has broad ranging experience from the relational data modeling phase through the production implementation of database solutions built with SQL Server, including data loading, monitoring, and performance tuning. Richard has worked on SQL Server for more than 26 years, including 12 years as part of the SQL Server team at Microsoft. In his role with Amazon Web Services, Richard is the Americas specialist for SQL Server, as well as for Amazon Aurora.

Martin Perez

Leslie Andrews

Twitter: - landrews5807

LinkedIn: Leslie Andrews

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

Amod Singhal

LinkedIn: Amod Singhal

I am an independent IT Consultant with over 20 years of experience in different roles, most recently as a Technical Business Systems Analyst. I enjoy making complex technical material easy to understand.

Melody Zacharias

Twitter: - SQLMelody

LinkedIn: Melody Zacharias

Contact: http://sqlmelody.com

Ike Ellis

Twitter: - @ike_ellis

LinkedIn: Ike Ellis

Contact: http://blog.ikeellis.com

Ike Ellis is a Senior Data Architect and partner for Crafting Bytes. He has designed and implemented data solutions for many well-known organizations. He has been a Microsoft Data Platform MVP since 2011. He co-authored the book “Developing Azure Solutions,” now in its second edition. He is a popular speaker at SQLBits, PASS Summit, and SQL in the City. He speaks at user groups, code camps, and SQLSaturdays. He has written courses on SQL Server for developers, Power BI, SSRS, SSIS, and SSAS for Wintellect. He has an upcoming course on CosmosDB. He founded the San Diego Tech Immersion Group, a technical book club based in San Diego and is the co-chair of the San Diego Software Architecture Group.

Manguirish Sardessai

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

LinkedIn: Manguirish Sardessai

Manguirish is a Microsoft Certified Professional with 12 years’ experience in IT Industry specializing in Web Development, Database Development /Administration and Data Reporting. He provides efficient management and optimal performance for Datavail customers with health check analysis, installations and configuration of SQL Server plus automation of DBA tasks, disaster recovery solutions and providing customers with day-to-day comprehensive solutions to manage databases. He also undertakes business assessments and does project planning to deliver high-end pragmatic solutions for each client environment. When he’s not looking to play with databases, he enjoys traveling to new places and reading fiction literature.

Konstantin Kosinsky

Twitter: - kkosinsky

LinkedIn: Konstantin Kosinsky

Konstantin is an industry expert who loves optimizing the performance at least in 10x. More data - more fun. Konstantin is a Principal Software Engineer at Azure DevOps Services, where he works on moving the Analytics for software engineering to a completely new level.

Konstantin was born and had been working in Ukraine for a long time, passionately sharing his knowledge with Ukrainian and other European data communities. Before joining Microsoft in 2012, he was a Data Platform MVP for many years.

Ted Stathakis

Twitter: - fishheadted

LinkedIn: Ted Stathakis

Contact: http://fishheadted.com

Ted Stathakis is a data professional passionate about the presentation layer. He has worked with SQL Server since the turn of the century, has mastered Reporting Services since he began working with it when it was released in 2004, and is super excited about Mobile Reports and Power BI. Ted hosts the local PASS user group, is the organizer of SQLSaturday Orange County and presented on SSRS at Summit in 2019. As a 40+ year veteran of the restaurant industry, he is been an advisor, speaker and panelist at national trade shows. When he isn’t consulting on Business Intelligence projects he can be found presenting at a conference, enjoying some live music or teaching kids, both young and old, fishing and archery at a nearby Scout camp.

Dustin Vannoy

Dustin Vannoy has spent a decade on solving business problems with analytics and big data solutions. He is passionate about all aspects of data work, including modeling, building scalable data pipelines, and creating intuitive dashboards. He is experienced in transitioning legacy ETL jobs into streaming pipelines with Spark and Kafka. He started his career with SQL Server Integrations Services, but currently focuses on using Python and Scala with cloud data services. Dustin is a technical leader in San Diego and the co-founder of the San Diego Data Engineering Group. He now encourages others to grow their data skills by speaking at user groups and conferences, particularly around Southern California and Baja California.

Ami Levin

Twitter: - ami_levin

LinkedIn: Ami Levin

Contact: http://www.amilevin.com

Ami is a data nerd that has been designing, consulting, training, writing, and speaking about SQL, relational modeling, and data platform architecture for more than 20 years. Currently works as a freelance consultant, senior SQL instructor at O’Reilly Media, as an author for PluralSight and LinkedIn Learning.

Patrick Partin

Twitter: - @GingerDBA

LinkedIn: Patrick Partin

Like most, Patrick accidentally found his way into SQL Server because MS Access couldn’t handle Real Estate, even if it was Connecticut. After discovering that DBAs can get paid pretty well to drink coffee and argue all day, a career was born. 20 something years later, Patrick has been fortunate to Administer, Architect, Develop, and Manage Databases, Networking, Storage, and Linux/Windows Systems of all shapes and sizes, covering companies in Accounting, Finance, Higher Education, Radio, Real Estate, Payroll, and now, Transportation Analytics.

Monica Rathbun

Twitter: - SQLEspresso

LinkedIn: Monica Rathbun

Contact: http://www.sqlespresso.com

Monica Rathbun lives in Virginia, is a Microsoft MVP for Data Platform and Microsoft Certified Solutions Expert. She has nearly two decades of experience working with a wide variety of database platforms with a focus on SQL Server and the Microsoft Data Platform. She is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group and a Mid‐Atlantic PASS Regional Mentor. She is passionate about SQL Server and the SQL Server community, doing anything she can to give back. Monica can always be found on Twitter (@sqlespresso) handing out helpful tips. You can find Monica blogging at sqlespresso.com

Melody Zacharias

Twitter: - SQLMelody

LinkedIn: Melody Zacharias

Contact: http://sqlmelody.com

Zia Khan

Twitter: - dataadvocate

LinkedIn: Zia Khan

Zia is an experienced professional with many years of experience in advising and helping customers develop data driven solutions for their business challenges using machine learning and artificial intelligence. He has worked with companies to implement solutions involving online and offline recommender systems, natural language processing (NLP) projects including conversation summarization, chatbots for lead generation and customer segmentation for targeted marketing. Zia has a passion for data driven decision making and believes strongly in driving value from data.

Julie Koesmarno

Twitter: - @mssqlgirl

LinkedIn: Julie Koesmarno

Contact: http://www.mssqlgirl.com

Julie Koesmarno, MCSE Data Platform, and MCSE Business Intelligence, MCT, is a Senior Program Manager at Microsoft, with a Bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her past projects include delivering a SQL Server 2012 data warehouse and BI solutions in the US and Australia. She now works with hybrid, cloud and on-prem SQL projects.

Marsha Pierce

Twitter: - MarshaPierceDBA

LinkedIn: Marsha Pierce

Marsha Pierce lives in Nashville, TN. She studied Computer Science, Mathematics, and French at Belmont University. She has 23 years of experience as a DBA, which means she has broken and fixed a lot of stuff. Before joining Pure Storage, she was an architect at HCA and Asurion. She is passionate about DevOps, Storage, Performance Tuning, and Standardization.

Ami Levin

Twitter: - ami_levin

LinkedIn: Ami Levin

Contact: http://www.amilevin.com

David Lundell

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

LinkedIn: David Lundell

Contact: http://Blog.ilmbestpractices.com

Author of How to Be an MVP in Life, Author of FIM Best Practices Volume 1, Microsoft MVP, Speaker, Entrepreneur and Consultant. 20+ years in IT. MBA, BS Computer Engineering both at University of Arizona. Helped establish database care and feeding best practices among Microsoft Identity Management professionals. Created unique SSIS and SSAS based solutions to problems in the Identity Management area.

Thomas Hull

Twitter: - @sdsql

LinkedIn: Thomas Hull

Thomas AJ Hull is a database professional based in San Diego, with 20+ years of SQL Server experience (since v6.5). AJ has worked as a consultant in the financial and biotech industries, and is currently a DBA Team Lead at Union Bank. He earned a BS in Engineering at Cornell University, and a master’s at Rochester. His certifications include MCSE: Data Platform MCSE: Data Management and Analytics. AJ enjoys mentoring developers and junior DBAs, and is always striving to learn more through continuing education and involvement in the SQL Server community. His goal is to pass along hard-earned knowledge with practical actionable advice, and believes that the best way to learn something is to teach it.

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.

Ben Thul

Twitter: - @spartansql

Contact: http://www.spartansql.com

Born naked and defenseless, he overcame these obstacles to become a mender of broken things, seeker of magic rings, and occasional watcher of slow pings.

Monica Rathbun

Twitter: - SQLEspresso

LinkedIn: Monica Rathbun

Contact: http://www.sqlespresso.com

Diane Schuster

LinkedIn: Diane Schuster

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

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

Sean McCown

Twitter: - @KenpoDBA

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

Ted Stathakis

Twitter: - fishheadted

LinkedIn: Ted Stathakis

Contact: http://fishheadted.com

Marsha Pierce

Twitter: - MarshaPierceDBA

LinkedIn: Marsha Pierce

Jamey Johnston

Twitter: - STATCowboy

LinkedIn: Jamey Johnston

Contact: http://STATCowboy.com

SQLSaturday #909 - San Diego 2019

Sessions

Title: Automate tests in your database with tSQLt

Title: Data Modeling Trends for 2019 And Beyond1

Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming

Title: The Master Stored Procedure Workshop: Part 2

Title: What just happened? Creating your own real-time dashboard with Grafana, Influx, and Telegraf

Title: One key to rule them all - how to effectively destroy data consistency, and ruin query performance

Title: Reporting Services: A Smart Migration Strategy

Title: The Master Stored Procedure Workshop: Part 1

Title: Confidence – The Best Super-Power

Title: Reporting Services Introduction

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

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

Title: Using Columnstore indexes in Azure DevOps Services. Lessons learned

Title: Assessing and Planning SQL Database Migrations to Azure

Title: From the Trenches - Case Study of a Data Warehouse Migration Upgrade

Title: Big Data, Big Dupe: A little session about a big bunch of nonsense.

Title: Dive into the Query Optimizer - Undocumented Insight

Title: Introduction to Linux for SQL Server Professionals

Title: Table Diaspora - A Tale from the Trenches

Title: Setting up a test lab with Hyper-V

Title: A Perfect Ten: The Data Model

Title: How to build a T-SQL Framework

Title: Getting Started with Azure Databricks Delta

Title: SQL Query Foundations

Title: ETL, Introduction to SSIS, and third-party tools like MelissaData and CozyRoc

Title: Power BI Dataflows and How to Leverage for Data Science

Title: Pure Storage: How Fast Can You Restore Your Database?

Title: Getting started with Azure Database for PostgreSQL

Title: How to Be an MVP (in Life and a Microsoft MVP)

Title: Utilizing AI to Predict Customer Churn

Title: Azure Data Lakes and Data Warehouses:

Title: Know What Your Code is Doing to SQL Server!

Title: Azure SQL Database Edge - Tiny but mighty

Title: T-SQL Tools: Using JSON as a Data Source

Title: Virtualizing SQL Server

Title: Basic Windowing Functions

Title: How to Get SQL Server to Run Better on Crappy Hardware.

Title: T-SQL Tools: Change Automation with Change Data Capture

Title: Columnstore Indexes for Everyone

Title: Tune Like a Guru - The Big Three!

Title: Not Your Grand Mother’s AI

Title: I’m It - Survival Techniques for the Lone DBA

Title: Women in Technology Panel Discussion

Title: Running SQL Server on AWS

Speakers

Sponsors