Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 30
Have you been watching SSAS Tabular develop? What about the new Azure Analysis Services product? Or you've looked at these and like what they can add in Power BI or classic BI scenarios, but haven't had a chance to dive in and figure all of this out? Now is the time!
SSAS Tabular is a new-ish form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, in addition to the various options for deployment, before exploring the development process of creating a tabular model ready for ad-hoc querying through Excel or Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Administration, Development & Analytics

Level: Beginner

Session Code:

Date: July 22

Time: 11:00 AM - 12:00 PM

Room: Roush 'Fisher 1'

One of the most anticipated new features in SQL Server 2016 is Query Store. It's referred to as the "flight recorder" for SQL Server because it tracks query information, namely query plans and runtime statistics. If you've ever had to drop everything to troubleshoot a sudden change in performance, then you've probably already realized the value of this feature. 

In this session, we'll step through how Query Store works - you’ll understand what information it captures and how to access the historical data through the UI and the system views. We'll look at the data collected to identify queries that don't perform well and those that have regressions in performance due to different plans. Finally, we'll see how to force a specific plan for a query, discover what happens when the optimizer cannot use that plan, and examine how plan forcing compares to using plan guides. Expect to learn how to make troubleshooting easier with this feature that’s included in all editions of SQL Server 201
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: July 22

Time: 2:15 PM - 3:15 PM

Room: Roush 213

Are you a frustrated DBA trying to improve performance on an application you didn’t write? Or perhaps you’re an application developer struggling to understand why your queries run slowly on someone else’s database? This talk will cover practical techniques to help developers and DBAs work together efficiently to troubleshoot poorly performing applications. 

Beginner/Intermediate software developers and DBAs will learn: when you need the actual query execution plan (and how to get it), why queries executed from SSMS perform differently than they do in the application, and how you can improve an application to make database troubleshooting easier. When the DBA and Developer join forces, there’s no problem they can’t solve!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 22

Time: 2:15 PM - 3:15 PM

Room: Roush 'Fisher 1'

How do you know when your server is on fire?  Without a set known-good measurements to compare against to look at you don’t.  This session will show you how to capture a performance baseline for a SQL Server instance. The session will help you decide what and when to capture data and where to store it. Then we will walk through different tools and scripts to use.  Then walk you through a scenario of using that data to identify a problem.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 22

Time: 9:45 AM - 10:45 AM

Room: Roush 116

SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 22

Time: 8:30 AM - 9:30 AM

Room: Roush 118

We have more information available to us today than ever before.  So much so that we run the risk of not being able to tell concise stories.  There's a lot more to creating that story than just getting the correct information.  Come learn not just the do's and don'ts, but the whys…
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Administration, Development & Analytics

Level: Beginner

Session Code:

Date: July 22

Time: 9:45 AM - 10:45 AM

Room: Roush 118

The war between DBAs and developers has been raging since the dawn of relational databases. One reason for disagreement comes from developers who want to store their data in JSON because it is fast, standard, and flexible. DBAs cringe when they hear of long text strings being stored in their SQL databases; they cry with concern, “No data validation? No schema binding?”. Is there any hope for these two warring factions to see eye-to-eye?

This session will explore the new JSON functionality introduced in SQL Server 2016. We will use T-SQL examples to learn how these functions can be used to parse, create, and modify JSON data. More importantly, we will discuss how to optimize performance when using these functions.

By the end of this session DBAs and developers will know how to efficiently work with JSON in SQL Server 2016. It will also usher in an era of peace between DBAs and developers…

… at least until someone brings up the topics of cursors, NOLOCKs, or Entity Framework.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 22

Time: 3:30 PM - 4:30 PM

Room: Roush 116

Before you go and move that mission critical application to a new version of SQL or new hardware you are probably creating some sort of testing and benchmarking scenarios to ensure a smooth upgrade.  Right?  Come learn how distributed replay can capture your workload and play it back on your new instance. Be it an upgrade of SQL or hardware we can review all sorts of scenarios to help make your upgrade a smooth process.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 22

Time: 11:00 AM - 12:00 PM

Room: Roush 118

Most of the time pilots are learning to fly, they're actually learning how to recover from emergency conditions. While we as Database Administrators focus on taking backups, how much time do we actually spend practicing recovering with those backups? This session will focus on the kinds of situations that can dramatically affect a data center, and how to use checklists to practice recovery processes to assure business continuity.

Learning objectives:
1 Understand the kinds of issues that can arise in critical data environments
2 Understand the expectations for performance and recovery of those data environments
3 Define a Personal Minimums contract for meeting the data availability expectations of the business
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 22

Time: 8:30 AM - 9:30 AM

Room: Roush 213

Ethics, Morals, and Laws each aspects of our behavior as people and DBAs. They govern which actions we take and which actions we avoid.

Understanding the basics of these guides and how they coordinate (and sometimes conflict) with each other helps you to make choices you can live with from both a personal and professional perspective.

This session presents basic definitions, ideas, and discussion points. It is intended to be an interactive presentation where the audience contributes to the discussion, so no two presentations are exactly the same!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 22

Time: 1:00 PM - 2:00 PM

Room: Roush 'Fisher 1'

Working in the tech industry often involves spending long hours sitting down, staring at a screen, consuming copious amounts of pizza and caffeine. The work is mentally demanding and can be stressful. In the rush to get everything done, it can be easy to neglect our health. But a healthy body and mind are necessary for effective performance. Based on HR training, research, and personal experience, this session provides realistic suggestions for managing your well-being at work. It covers the connection between physical and mental health, as well as how to discuss these topics with your employer. You’ll leave with a better idea of how to take care of yourself and be a happier, healthier, more productive person.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 22

Time: 8:30 AM - 9:30 AM

Room: Roush 116

Most people don't like to speak in public and technical folks are certainly no exception.  Yet, you've got some ideas for a great presentation but just don't know how to go about putting it all together.  On top of that, how do you go about giving the presentation itself?  This session will cover how to pull your material together in an organized fashion and present it such that your audience can follow along and get the message you want to relay.  We'll also discuss how to deal with issues that cause presenters stress to help you to make the process enjoyable and rewarding for all.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 22

Time: 9:45 AM - 10:45 AM

Room: Roush 213

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 22

Time: 1:00 PM - 2:00 PM

Room: Roush 213

Azure SQL Databases are still something that is new and not completely understood by many data professionals. There is a definite shift from installing SQL Server on a machine to creating and using a Microsoft's Platform-as-a-Service database. This session will cover the basics of what an Azure SQL Database is, how we create one, and what it takes to access and use this database. After attending this session, you will have a solid understanding of what Azure SQL Database is, how to configure it, and how to use in your own environment.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: July 22

Time: 3:30 PM - 4:30 PM

Room: Roush 213

This session will cover what is Streaming Analytics and the various use cases.  We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review.  The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: July 22

Time: 11:00 AM - 12:00 PM

Room: Roush 117

Many times developers have to support users by answering the “What happened to the data?”  The task of retrieving data from a specific point in time is not an easy one.  Often this involves retrieving a backup and restoring the data in question (hopefully!).  SQL Server 2016 introduced Temporal Tables, allowing a developer to retrieve data from a specific point in time, without backups.  With a few TSQL commands a historical table can be created, automatically updated, and readily accessed.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 22

Time: 2:15 PM - 3:15 PM

Room: Roush 117

Unit testing allows database code to be consistently tested during the development process, but it can be challenging to get unit testing setup for database development. This session will give an overview on the purpose of unit testing, the installation of the tSQLt framework, and the design of unit tests. I will use general concepts of test driven design to create and run unit tests to confirm that objects exist and to test single and multiple test cases. Learn how to implement unit testing in a development environment and create and run your own units tests.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 22

Time: 3:30 PM - 4:30 PM

Room: Roush 'Fisher 1'

Polybase is Microsoft's newest way of integrating SQL Server with external systems such as Hadoop and Azure Blob Storage.  In this talk, we will get an overview of the Polybase technology and then implement it to work with an on-premises Hadoop cluster as well as Azure Blob Storage.  We will then dive into the mechanics of how Polybase works, using packet captures to understand the cross-network communication.  Finally, we will look at ways of tuning common Polybase scenarios and look at a few less-common scenarios.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: July 22

Time: 8:30 AM - 9:30 AM

Room: Roush 117

There has been a lot of interest in the analytics community in visualizing the output of an Azure Machine Learning model inside Power BI. To add to the challenge, it would also be great to operationalize Azure ML models through the Power BI service. Imagine if you could have Power BI regularly bring in the latest output of your fraud model or the sentiment for recent Tweets about your products. This session will outline and demonstrate a proposed approach for doing just that.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Administration, Development & Analytics

Level: Intermedia

Session Code:

Date: July 22

Time: 11:00 AM - 12:00 PM

Room: Roush 213

When people talk about Power BI, it can be all sizzle and no steak. Instead, we are going to take a slightly deeper dive into the inner workings of PowerBI. We will cover the different components of the Power BI ecosystem: PowerQuery, DAX, Power BI visuals, Data gateways, and the Power BI service. Instead of just showing off pretty graphs, we will focus on a more fundamental understanding of these tools.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Administration, Development & Analytics

Level: Intermedia

Session Code:

Date: July 22

Time: 2:15 PM - 3:15 PM

Room: Roush 118

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