Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 44
If you have an online presence, you have a personal brand. Most of us didn’t intend to create a brand when we made our first websites and social media profiles. They were just fun ways to share our lives and meet people. Now, they’re networking and career growth tools. In this talk, you’ll hear about people whose brands helped them become respected developers, managers, and community leaders. You’ll learn how to use your online presence to advance your career. You’ll also pick up best practices, common mistakes, and tips for balancing professional and personal content. Intentional personal branding opens the door to endless opportunities. Come see how to make that happen!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 28

Time: 11:00 AM - 12:00 PM

Room: Roush 116

This topic sounds scary, but it’s not. Regardless of whether you have a small database with only a few users, or a large multi-tenant system, you have Locking, Blocking, Latches, and Spinlocks. Understanding what they are and how they work is the first step in understanding how to troubleshoot them. Deadlocks are a problem, but they are a problem we can fix. In this session, we will explain and investigate how to find and fix the problems that we see in our database every day.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: July 28

Time: 2:45 PM - 3:45 PM

Room: Roush 210

Over the past few years R has been popping up in several areas within the Microsoft ecosystem. It was first introduced in Azure ML then later appeared in Power BI and SQL Server. Unfortunately, the benefits of the R programming language are not understood by many Microsoft professionals so these tools are not being fully utilized. I hope to change that for some with this talk.

In this session we will take a tour of R in the Microsoft ecosystem. We will show the different ways R can be leverage and present compelling reasons why it is a very valuable tool that you should add to your data analytics arsenal. No R experience is needed for this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: July 28

Time: 2:45 PM - 3:45 PM

Room: Roush 117

I've said it before and I'll say it again: Query Store is a game-changer for troubleshooting query performance. Yet when I ask people who are running SQL Server 2016 or higher if they're using Query Store, less than half say they are.  If you fall into that category, this session is for you.
We’ll start by discussing Query Store configuration. Sound a little boring? It won't be. There are multiple settings that affect how information is captured and you need to understand them. Next, we'll look at the data. Definitely not boring, as it's imperative you understand exactly what gets stored (and what doesn't) so you can find problematic queries quickly.  
Lastly, we'll mine the data in Query Store, and mining is more than just finding queries that use a particular index, or those that access a specific table. We’ll discuss different workload characteristics and how they affect system performance, and how to use Query Store to better understand your own workload.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 28

Time: 9:45 AM - 10:45 AM

Room: Roush 114

Forensic accountants and fraud examiners use a range of techniques to uncover fraudulent journal entries and illegal activities. As data professionals, most of us will never unravel a Bernie Madoff scheme, but we can apply these same techniques in our own environments to uncover dirty data. This session will use a combination of SQL Server and R to apply these fraud detection techniques, which include Benford's Law, outlier analysis, time series analysis, and cohort analysis.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: July 28

Time: 8:30 AM - 9:30 AM

Room: Roush 114

While Azure SQL Database provides the full feature of the SQL Server database engine, it is designed primarily for newly developed, cloud-based applications.  For existing applications running on traditional SQL Server instances, the cost and complexity of migration can be prohibitive.  With the release of Azure Managed Instances, much of the cost and complexity have been removed.  Join me for this session to learn about the differences between Azure SQL Database and Azure Managed Instances. Additionally, discover methods for migrating existing instances to Azure.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: July 28

Time: 11:00 AM - 12:00 PM

Room: Roush 117

SQL Server 2016 and Azure SQL Databases both contain JSON features that allow data to be accessed for either reading or writing JSON documents.  This combined with REST APIs make it easier than ever for applications to exchange data directly with the database.  We'll demonstrate this feature using SQL Server's built-in JSON support.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: July 28

Time: 4:00 PM - 5:00 PM

Room: Roush 118

Sponsor Session from Cardinal Solutions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: July 28

Time: 12:15 PM - 1:15 PM

Room: Roush 118

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 28

Time: 1:30 PM - 2:30 PM

Room: Roush 114

Since data compression is now a standard level feature (2016 SP1+) learn how to squeeze a little extra performance out of your databases for free!  We’ll cover the types of compression available, the costs and benefits and how to determine good candidates for compression. Once we know what we want to compress we’ll cover three ways to apply it, including the easiest way to compress your whole database to meet best practices with just one line of code!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 28

Time: 11:00 AM - 12:00 PM

Room: Roush 118

Sometimes a data professional will find themselves in need of a large demonstration data set.  However, non-proprietary options are few and usually lacking.  This session will educate attendees in how to get around these obstacles by creating their own data.  We'll talk about the process of using real-world variability, creating inconsistency that leads to insight using some basic statistical concepts, the process of putting everything together, and getting the data set into SQL Server.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: July 28

Time: 11:00 AM - 12:00 PM

Room: Roush 213

The job of a data professional is evolving rapidly, driving many of us to platforms and technologies that were not on our radar screen a few months ago. I am certainly no exception to that trend. Most of us aren't just monitoring backups and tuning queries - we are collaborating with teams throughout the company to provide them data and insights that drive decisions. This presentation walks you through how a silly idea from a soccer podcast got me thinking about how Azure Logic Apps, sentiment analysis, and Azure SQL DB combine to provide potentially powerful insights to any company with a social media and sales presence. Join me as I walk you through building a solution that can impact your company's bottom line - and potentially yours too!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: July 28

Time: 1:30 PM - 2:30 PM

Room: Roush 118

There are many ways of detecting and capturing changes to the data in your business system in order to populate your data warehouse.  In this session we will compare and contrast several methods for loading slowly-changing dimensions in your ETL solutions, including SSIS design patterns, T-SQL code, change data capture (CDC) and temporal tables.

Attendees will gain a full understanding of the pros and cons of each of these solutions and become confident in choosing and implementing them in their own ETL solutions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: July 28

Time: 11:00 AM - 12:00 PM

Room: Roush 114

Do you have a query that you want to tune, but don't know where to start? Execution plans can be a great starting point for understanding what your query is doing under the hood. This course covers the bare bones basics: what an execution plan is, how to run them, how to read them, and additional features.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 28

Time: 1:30 PM - 2:30 PM

Room: Roush 117

Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them.  This session will cover the basics of Extended events as well as an introduction to the system_health session.  This session will give someone who has never used Extended events before the skills to start using them!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 28

Time: 8:30 AM - 9:30 AM

Room: Roush 118

Did you throw your data in a lake, specifically an Azure Data Lake?  Are you now wondering what to do with all of that data?  Microsoft provides Azure Data Lake Analytics (ADLA)  “An on-demand analytics job service to power intelligent action.”  
We will take a look at U-SQL, the big data language, which will empower you to leverage the T-SQL you know to extract meaningful insights from your big data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: July 28

Time: 1:30 PM - 2:30 PM

Room: Roush 210

If you manage code, you understand the struggle of choosing how you source control it. While there are many choices out there, Git has become a popular option for many development teams. While it has many strengths, understanding Git can be a struggle for developers who are not used to distributed source control. In this session, we will go over the basic concepts of Git, from building and cloning a repository to branching, forking, and code merges. We will use real world examples of how Git and GitHub can be used to manage global development teams. Attendees will leave with a solid understanding of how Git works, how to get started with their own GitHub repository, and some tools that can be used to manage their code.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 28

Time: 4:00 PM - 5:00 PM

Room: Roush 213

Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore.
In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible.
By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: July 28

Time: 9:45 AM - 10:45 AM

Room: Roush 116

One of the most popular libraries in R is ggplot2, a graphics library built on a concept called the grammar of graphics.  In this example-heavy talk, we will learn about the grammar of graphics through ggplot2.  We will start by building a series of simple visuals using ggplot2.  Then, we will show how easy it is to add more and more complex functionality to our visuals, showing that we can incrementally add polish to our visuals.  By the end of the talk, you will have the tools to build professional-quality visuals in R.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: July 28

Time: 2:45 PM - 3:45 PM

Room: Roush 117

What do you want to be when you grow up? I want to be a DBA, a teacher, a blogger, and a world-traveler. I'm living my dream. 

In this session, we'll talk about how I got where I am, and how you can get to where you want to be. In addition to sharing my journey, I'll give some helpful tricks to getting your next job. You'll learn how to write a resume that gets you noticed, how to navigate interviews, and learn how to decide if a potential job and employer is right for you. 

Bring your own resume to this session, and I'll provide you some personal (and private) feedback on what I would do to help improve your resume so you can land your Dream Job.

Slides & handouts available on GitHub: http://am2.co/dream-job-ppt
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 28

Time: 1:30 PM - 2:30 PM

Room: Roush 114

Sessions Found: 44
Back to Top cage-aids
cage-aids
cage-aids
cage-aids