Build Schedule

This session is an introduction to tuning backups.  Learn how to take those backup jobs to disk and change them from running for hours to running in minutes.  We’ll be discussing the advantages & disadvantages of using the following parameters: COMPRESSION, BUFFERCOUNT, & MAXTRANSFERSIZE.  We’ll also be covering the concept of striping database backups.

Mike Hays

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 22

Time: 10:10 AM - 11:25 AM

Room: 2520C

Add to Schedule

New in SQL Server 2019, Accelerated Database Recovery (ADR) completely redesigns the SQL Server database engine recovery process.  This allows the time spent recovering from a crash or rolling back a transaction to be greatly reduced.  ADR also prevents the transaction log from growing during a long-running transaction.  Join me for this session to learn about ADR architecture and to see demonstrations of what it can do.

Frank Gill

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 22

Time: 12:50 PM - 2:05 PM

Room: 2520D

Add to Schedule

If you took a look at Always Encrypted in SQL Server 2016, you may have had some reservations about it. It was a great concept, but because the database engine could no longer access the data, a lot more of the data processing was pushed to the clients. For many companies, that was far from ideal.

Enter SQL Server 2019. With Always Encrypted with Secure Enclaves, the benefits of Always Encrypted are retained, but the SQL Server engine gains the ability to carry out operations on the data - without the data ever leaving the server, and without decryption. How is this possible? Does it live up to its promises? Come to this session to find out and to see how to use it in your applications.

Ed Leighton-Dick

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 22

Time: 2:15 PM - 3:30 PM

Room: 2520D

Add to Schedule

Have you used SSAS before? Have you created reports using T-SQL and Group by? Are you interested in or currently using Power BI? Do you you have a need for Analysis  Services but don't want to have to deal with the hassle of buying and installing a server? Are you dreading having to upgrade your hardware for your current SSAS Tabular instance?  Is your organization using Office 365?  If you answered yes to any of these questions, you might need Azure Analysis Services.  The wait is over! Azure Analysis Services is the platform as a service version of the wildly popular Analysis Services Tabular product. 

This demo heavy session will be focused on setting up Azure Analysis Services, deploying a model, loading the model with data and finally reporting from your Azure Analysis Services instance.

Prerequisites: Prior knowledge of SSAS or Power BI

Phillip Labry

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 22

Time: 3:40 PM - 4:55 PM

Room: 2390

Add to Schedule

Azure Data Factory V2 is relatively new in Azure and has a lot of great new SSIS-like features but is it good enough to replace SSIS? In this session we will go over some of the new control flow, branching, and scheduling features in Azure Data Factory and see how to make a fully cloud capable data orchestration engine. As a bonus we'll also show how you can run SSIS packages directly in Azure!

Joshuha Owen

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: June 22

Time: 8:45 AM - 10:00 AM

Room: 2390

Add to Schedule

Interested in learning text mining techniques but not sure where to start?  Want to learn more about SQL Saturday presentations but haven't dug into the details?  This is the presentation for you!  This is an introduction to text mining techniques that will use the SQL Saturday abstracts as examples.  We will look at how to analyze data to find the most commonly used words and patterns and how to do sentiment analysis.  Is "database" the most commonly used word in SQL Saturday abstracts?  Come and find out!

Lynn Ballard

Session Type:
Regular Session (75 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: June 22

Time: 10:10 AM - 11:25 AM

Room: 2390

Add to Schedule

CosmosDB is Microsoft’s globally distributed, massively scalable, cloud based database that is hosted in AZURE.  Who cares?  You should if you need to support thousands of transactions a second, global distribution and redundancy, and different consistencies.  

Do you need to support JSON, Graph, et al?  Done.  Join me and see how easy it is to get started.  We will set up a local instance of CosmosDB, load JSON data and build a PowerBI visualization. Along the way I’ll point out a couple of things to watch out for.  At the end of the session you will then learn how, with a couple of commands, to switch your visualization to the cloud.

Jim Dorame

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: June 22

Time: 3:40 PM - 4:55 PM

Room: 2520B

Add to Schedule

Data breaches are now a when, not an if. Yet despite years of reading about data breaches in the news, very few companies are ready to weather the storm.  This course will provide a general primer on data breach incident response and the parallels between the IT and Legal response cycles.  At the end of this course, you will have the baseline knowledge of data breach responses and legal aspects your company needs to know.

Wm Bruce Wray

Session Type:
Regular Session (75 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: June 22

Time: 12:50 PM - 2:05 PM

Room: 2520C

Add to Schedule

You know how locking works in SQL Server, but now you are tasked with diagnosing and fixing deadlocks. How do you take the knowledge you have and apply it to address deadlocks in your production database?

In this session, we will discuss how you can use free tools to detect and analyze deadlocks in your system. We will do a deep dive on deadlock XML with an eye toward interpreting the information automatically collected by SQL Server when the free tools fall short. 

Attendees will leave with the understanding they need to develop solutions to deadlocks in their systems.

Jake Manske

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 22

Time: 2:15 PM - 3:30 PM

Room: 2520B

Add to Schedule

Ever considered giving a presentation of your own? Pondered how your favorite speakers got their start? Contemplated whether you could ever do that too, but were not sure where to begin?

Well I say you can and will show you how to get started! In this session, I will teach you how to develop your idea and create session content, and share tips & tricks that I have learned along the way. 

You will leave armed with a wealth of resources (and hopefully some inspiration) to venture forth and develop your first presentation.

Andy Yun

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 22

Time: 2:15 PM - 3:30 PM

Room: 2523

Add to Schedule

Social science has shown that people tend classify one another by gender, race, or other physical characteristics and instinctively react based on stereotypes and cultural norms.  These automatic prejudices (often called unconscious bias) contribute to the disproportionate success of white men in STEM when compared to equally qualified women or minorities.  The difference between unconscious bias and intentional discrimination is that the people that participate in it are often motivated to end these behaviors when they're brought to their attention.

This discussion will cover some common patterns of unconscious bias that occur in the workplace and offer real, concrete actions to intervene as an employee, a manager, or an organization.

Andrea Mascher

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 22

Time: 12:50 PM - 2:05 PM

Room: 2520B

Add to Schedule

Completing a full assessment on a SQL Server is essential to learning about not only the current state of the server, but also any area that may be impacting performance or security.  If you have more than one DBA, it is also important to have all the DBA team members review the same areas when completing an assessment.  During this session we will discuss when assessment are useful, what should be included in the assessment as well as how to interpret the results.  We will use a SQL script that will capture all the data needed.  This script will more than 88 data points, including fragmentation of indexes, performance counter values, server and database security information, queries that consume the most CPU time including execution plans as well as many other data points. This session will also cover to document your findings and recommendations.

Dave Bland

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 22

Time: 10:10 AM - 11:25 AM

Room: 2520D

Add to Schedule

One of the best starting places for performance tuning is the execution plan.

But in the real world, execution plans become complicated very quickly and it can be difficult to know where to start.

This session will demonstrate how execution plans can be interpreted to explain performance, including details on how SQL Server retrieved the data.

Arthur Daniels III

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 22

Time: 8:45 AM - 10:00 AM

Room: 2523

Add to Schedule

As we all know, SQL Server loves memory and will use as much as it can get.  However, when there is memory pressure we need to use our DBA skills to identify what is causing the pressure.  During this session we will explore how SQL Server uses memory and how to properly configure memory settings.  We will discuss the use of DMVs and other tools to help us find what is consuming the most memory and some potential solutions.

Dave Bland

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 22

Time: 8:45 AM - 10:00 AM

Room: 2520D

Add to Schedule

Think infrastructure in the cloud is still just for sysadmins? Think again! As your organization moves into the cloud, infrastructure architecture skills are more important than ever for DBAs to master. Expert knowledge of cloud-related infrastructure will help you maintain performance and availability for databases in the cloud. For example, know what an IOP is? Should you use a database-as-a-service or provision a cloud-based VM? How many compute resources does your database consume during a given day? Can you secure it properly? Come learn many of the key cloud infrastructure points that you should master as the DBA role continues to evolve!

David Klee

Session Type:
Regular Session (75 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: June 22

Time: 3:40 PM - 4:55 PM

Room: 2520D

Add to Schedule

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

George Bryant

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 22

Time: 2:15 PM - 3:30 PM

Room: 2390

Add to Schedule

Modern CPU architectures are complex and misunderstood, especially as they relate to SQL Server instance configuration and database usage patterns. Default values in virtualization and the SQL Server instance can cause misalignments and improper balance in the way the SQL Server lines up with the CPUs and memory, which results in an immediate (and silent) performance penalty. Come learn as we discuss topics such as physical and virtual NUMA, hyperthreading, query parallelism, public cloud CPU selection, and SQL Server instance settings, and show you how to validate your SQL Server architecture and improve the performance of your critical SQL Servers for both on-prem and cloud-based SQL Servers.

David Klee

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 22

Time: 12:50 PM - 2:05 PM

Room: 2523

Add to Schedule

When you're performance tuning queries that request memory grants, you want to know where, how and why the memory is granted and used in your query.

In this session, we'll cover query memory grants through examples. We'll also demonstrate the problems that memory grants can cause, and a variety of solutions to use when performance tuning.

Arthur Daniels III

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 22

Time: 10:10 AM - 11:25 AM

Room: 2523

Add to Schedule

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

Gina Meronek

Session Type:
Regular Session (75 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: June 22

Time: 3:40 PM - 4:55 PM

Room: 2523

Add to Schedule

Your application developers benefit from Continuous Integration and Continuous Deployment practices to accelerate feature deployment and catch regression issues up front, but your database deployments are still stuck in the proverbial dark ages. The build scripts might be in source control or even an SSDT project already, but deploying is still an exercise in creating the perfect script, and don't even think about making a data (or data type) change!

SSDT and Azure DevOps can solve some of these problems, and even give us a window into the world of automated testing. In this talk, we will explore how to automate your database builds and deployments using SSDT and Azure DevOps, and we will explore automated testing using tSQLt and Docker. Lastly, we will check up on some tasks that you cannot (or should not) automate and talk about how to make sure your application developers are not left behind.

Dan Mallott

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: June 22

Time: 2:15 PM - 3:30 PM

Room: 2520C

Add to Schedule