Sessions & Schedule Builder

Create your own customized schedule. You can browse all sessions or use keyword, category, track, speaker, skill level, and learning path filters. If you have already created a list of favorite sessions, use the 'View my favorites' button to retrieve and add them to your schedule. You can then view and send your schedule to your email.

Building your schedule online assists with room allocation, but please note that adding a session to your schedule does not guarantee entry. Take note of sessions showing this symbol , these sessions are popular - arrive early to avoid disappointment!

Please Note:  Pre-Conference Sessions (on Nov 3rd & 4th) are available at an additional fee of $495 per day. If you would like to add one or two days of Pre-Conference sessions to your registration please contact Shannon Cunninngham.

View Session Schedule

Advanced Filters:
















Historically, users have been constrained to consume data in fixed platforms, with one specific dimension for digital viewings and a couple of printed layouts. Nowadays, with the ubiquitous mobile devices available, Management expects to know key business indicators and day-to-day operation performance on the go. Using well-designed data models and visualization techniques, Power View can leverage timely and quick dashboards for analysis on the go.   
  
This session will discuss how to design the appropriate data model to enable self-service data exploration and insightful analysis in Power View, and how to create pixel perfect visualization for mobile devices. You will also learn how the techniques differ from traditional platforms. Using live demo, we will walk through ways to channel users focus on actionable analytics.  
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Information Delivery

Level: 100

Session Code:
BID-101

Date: November 06

Time: 1:30 PM - 2:45 PM

Room: 607

Add to Schedule

In the spirit of the popular book "Seven Databases in Seven Weeks", we will explore the emerging NoSQL and NewSQL data platforms and how they apply in the cloud.  This session will demystify this new world of data platforms and arm you with an understanding of their strengths and weaknesses and typical application scenarios. 

Learn more about the new data platform categories like document, key/value, columnar, and graph.  We'll discuss where ACID is king, and when BASE rules, and how the CAP theorem is applied with more common NoSQL implementations like HBase, MongoDB, Cassandra and Hadoop.
Speaker:

Session Type:
General Session (75 minutes)

Track:
Application & Database Development

Level: 200

Session Code:
AD-211-M

Date: November 05

Time: 3:00 PM - 4:15 PM

Room: 609

Add to Schedule

Would you like to know how to keep end users and management happy? Then join us in this session where we discuss data quality and data cleansing. For those of us who have dealt with Data Profiling Tasks in SQL Server 2008, we were shocked, yet pleasantly surprised, with the great advances that Microsoft made with the advent of Data Quality Services in the SQL Server 2012 release. In this hands-on presentation, we will look at how to set up a new knowledge base based upon an existing one, set up rules, do knowledge discovery within the new knowledge base, and, finally, cleanse the data through a data quality project. 
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: 300

Session Code:
BIA-301

Date: November 05

Time: 10:45 AM - 12:00 PM

Room: 613-614

Add to Schedule

Testing is critical to managing a high-quality data lifecycle. Unfortunately, SSIS has no built-in support for test authoring and the tools for relational database testing are limited. As a result, most organizations forgo automated testing and focus entirely on manual user testing, which is both expensive and often occurs too late in the process to address all of the issues discovered.  

In this session, a new approach to unit testing (focusing on verifying the correctness of individual packages, tasks, or dataflows) and integration testing (focusing on validating that the data produced by an entire sequence of transformations) will be discussed. This approach uses metadata authored by analysts in Excel to automatically generate testing logic within the corresponding packages or to automatically generate standalone test packages that contain all of the necessary validation logic. All code will be shared with attendees for free and unrestricted use within their own projects.
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: 300

Session Code:
BIA-312

Date: November 07

Time: 4:15 PM - 5:30 PM

Room: 613-614

Add to Schedule

What is the Microsoft Azure SQL Database all about? What does this mean for me as a DBA? What is the process for setting up a Microsoft Azure database? How would I go about migrating one of my databases to the cloud? How do I possibly leverage this new technology in my production environment? 

If you are a production DBA and have contemplated one or more of these questions, this session is for you! Maybe you have been tasked with finding out about the cloud. Join me in exploring the cloud where I will show you how SQL Server works in the Microsoft Azure SQL Database world. We will run through the simple process of configuring a Microsoft Azure SQL database, and then we’ll discuss the similarities and differences between on-premises SQL Server and Microsoft Azure SQL Databases. We will even look into the DR, HA, monitoring and performance tuning options available with Microsoft Azure.

Speaker:

Session Type:
General Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: 100

Session Code:
DBA-101

Date: November 05

Time: 10:45 AM - 12:00 PM

Room: 3AB

Add to Schedule

A good understanding of join algorithms is essential in diagnosing and fixing issues related to bad query plans. However, one of today’s realities is that a lot of database professionals do not have a computer science degree and didn’t sit through a formal “Introduction to Relational Databases” course. 

This session seeks to fill in some of the gaps that might exist by looking in-depth at the three types of join operations. We’ll visualize how the join operations’ algorithms work so you can understand how query plans are computed, and then we’ll look at why these join operations have very different performance characteristics and why the optimizer chooses a specific join operator to use in a query plan. You’ll see through demonstrations that empirical cost calculations are similar to what the query optimizer actually returns.
Speaker:

Session Type:
General Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: 200

Session Code:
DBA-209

Date: November 07

Time: 9:45 AM - 11:00 AM

Room: 608

Add to Schedule

Your SQL Servers are probably virtualized by now, but are they running at their absolute peak performance? How can you tell? When properly configured and maintained, a virtualized SQL Server will be at least as fast as the system that it came from, if not better. If not properly configured, silent performance killers can wreck your virtualization experience. This session will give you tips and tricks to maximize performance while giving you talking points so you can convince your infrastructure engineers to design the virtualization stack your way. This session goes deep into the architecture and methodology for squeezing the best possible performance from your virtualized SQL Server, and includes valuable tips on topics such as host-level over-commitment, storage performance, In-memory OLTP, and more!
Speaker:

Session Type:
General Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: 200

Session Code:
DBA-218

Date: November 07

Time: 4:15 PM - 5:30 PM

Room: 401

Add to Schedule

Power BI for Office 365 is Microsoft's new self-service BI offering. Just because it emphasizes self-service doesn't mean a system administrator isn't an important role!

In this session, we will discuss the overall system components and how a Power BI site in SharePoint Online differs from an on-premises SharePoint BI site. We will walk through how to best handle setting up connectivity to data sources, when a gateway is needed, and what data refresh capabilities exist. We will also consider how and when to create OData feeds from your corporate on-premises data sources and how those OData feeds affect Enterprise Data Search functionality.
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: 100

Session Code:
BIA-101

Date: November 07

Time: 4:15 PM - 5:30 PM

Room: 618-620

Add to Schedule

Disasters happen, plain and simple. When disaster strikes a database you're responsible for, and backups and repair fail, how can you salvage data, and possibly your company and your job? This is where advanced data recovery techniques come in. Using undocumented tools and deep knowledge of database structures, you can manually patch up the database enough to extract critical data. 

This demo-heavy session will show you never-seen-before methods the speaker has used extensively in the last year to salvage data for real-life clients after catastrophic corruption. You won't believe what it's possible to do!
Speaker:

Session Type:
General Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: 500

Session Code:
DBA-502

Date: November 06

Time: 1:30 PM - 2:45 PM

Room: 6E

Add to Schedule

This session goes beyond the classical star schema modeling, exploring new techniques to model data with Power Pivot and SSAS Tabular. You will see how brute-force power in DAX allows different data models than those used in SSAS Multidimensional. You will see several practical examples, including creating a virtual relationship (without a physical relationship in the data model); a dynamic warehouse evaluation without a snapshot; dynamic currency conversion; a number of events in a particular state for a given period; surveys; and basket analysis. The goal of this session is to show you how to solve classical problems in an unconventional way.
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: 300

Session Code:
BIA-310

Date: November 06

Time: 3:00 PM - 4:15 PM

Room: 602-604

Add to Schedule

Are you finally ready to unlock the power in your spatial data? In this session, we will explore some advanced spatial analysis techniques, including clustering, binning, and the basic use of spatial statistics. We will then discuss several options for visualizing the results in SQL Server Reporting Services and PowerPivot. Get ready to go beyond bars and bubble charts!
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Information Delivery

Level: 300

Session Code:
BID-304

Date: November 07

Time: 4:15 PM - 5:30 PM

Room: 2AB

Add to Schedule

Agile methodologies, such as Scrum and Extreme Programming, are popular and effective approaches to software development that focus on creating a high value, maintainable product quickly though iterative development and close collaboration between the team and the customers. These approaches enable rapid delivery and development, along with flexibility and a focus on delivering high value features.  These methodologies work great for standard software development… but what about Business Intelligence projects?  

This session will cover an introduction to Agile methodologies (with a focus on Scrum), what you will need to do to make it work for Business Intelligence projects, and common challenges that you will need to consider.  This “from the trenches” presentation will also cover real world examples of projects where this approach was extremely successful, and a few that weren't.

Speaker:

Session Type:
General Session (75 minutes)

Track:
Professional Development

Level: 200

Session Code:
PD-200

Date: November 07

Time: 4:15 PM - 5:30 PM

Room: 609

Add to Schedule

BI and DWH is all about trust. Business users will use delivered data and information if, and only if, they trust them. But they also ask for frequent changes, and how one can be sure not to introduce bugs and errors that will compromise that trust?

Test-driven development and Continuous Integration are two extremely interesting processes that are used in software development, and they can be also applied to BI solutions in order to bring Agility into the BI field. In this session, we'll see which tools can be used to unit test your solution, how data can be unit tested, and how we can automatically start and test the ETL phase, or a cube process, each time someone checks in a change made to the solution.
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: 300

Session Code:
BIA-309

Date: November 06

Time: 1:30 PM - 2:45 PM

Room: 618-620

Add to Schedule

The Data Warehouse plays a central role in any BI solution: it's the back end upon which everything in the coming years will be created. It must be capable of being flexible in order to support the fast changes needed by today's business, but also with a well-know and well-defined structure in order to support the "engineerization" of its development process, making it cost effective. In this full-day session, we will discuss architectural design details and techniques, Agile Modeling, unit testing, automation, and software engineering applied to a Data Warehouse project.

The only way to do this is to have a clear idea of its architecture, understanding the concepts of measures and dimensions, and a proven engineered way to build it so that quality and stability can go hand-in-hand with cost reduction and scalability. This will allow you to start your BI project in the best way possible avoiding errors, making implementation effective and efficient, building the groundwork for a winning Agile approach, and helping you to define the way in which your team should work so that your BI solution will stand the test of time.
Speaker:

Session Type:
Pre-Conference Session (full day)

Track:
BI Platform Architecture, Development & Administration

Level: 300

Session Code:
BIA-399-P

Date: November 04

Time: 8:30 AM - 4:30 PM

Room:

Add to Schedule

Self-Service BI functionality is one of the big goals of the modern Microsoft BI stack. But with the ability to bring business intelligence functionality to a much broader audience the danger of inconsistency, redundancy of information and accountability as well as security concerns and data quality problems can increase. 

In this session, we will show data governance best practices and what capabilities for data governance Power BI has in place. In addition, we’ll discuss how you can enhance your self-service BI landscape with Master Data and Data Quality Services for improved governance.
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Information Delivery

Level: 300

Session Code:
BID-306

Date: November 07

Time: 1:00 PM - 2:15 PM

Room: 2AB

Add to Schedule

The Microsoft Analytics Platform Systems is Microsoft's foray into on-premise big data appliance business. The appliance has evolved from simply a collection of on-premise servers to an integrated hybrid (on-premise/cloud) appliance that enables customers to gain valuable insight no matter where the data lives. This session will dive deep into the Analytics Platform System appliance - covering the architecture, components and design of the appliance while modeling a real-world customer case.
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: 300

Session Code:
BIA-315-M

Date: November 06

Time: 5:00 PM - 6:15 PM

Room: 602-604

Add to Schedule

The Microsoft Appliance Platform Systems is Microsoft's foray into on-premise big data appliance business. The appliance has evolved from simply a collection of on-premise servers to an integrated hybrid (on-premise/cloud) appliance that enables customers to gain valuable insight no matter where the data lives. This session will cover the new hybrid features in APS and how to migrate an existing SMP data warehouse to an APS appliance.
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: 200

Session Code:
BIA-211-M

Date: November 05

Time: 10:45 AM - 12:00 PM

Room: 618-620

Add to Schedule

SQL Server is often I/O bound, but why? Do you feel lost when talking to your storage administrator?  Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. 

You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.
Speaker:

Session Type:
General Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: 200

Session Code:
DBA-211

Date: November 05

Time: 4:45 PM - 6:00 PM

Room: 6C

Add to Schedule

Take advantage of HDInsight to tap into a stream of millions of Tweets. Then use Excel and Power BI to visualize your data, create dashboards and unlock insights from your social media interactions. This session will introduce you to the tools and steps to get you started on analyzing large sets of unstructured data.
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Information Delivery

Level: 300

Session Code:
BID-314-M

Date: November 06

Time: 10:15 AM - 11:30 AM

Room: 607

Add to Schedule

Come explore how to integrate SQL Server tooling in Visual Studios with Team Foundation Server to enable continuous integration and database unit testing.  Getting SQL Server database projects to work with Team Foundation Server (TFS) has been a challenging task until now. Come and see how easy this process has become and how to integrate SQL Server database projects, database unit testing and continuous integration. This talk will cover setting up SQL Server database project builds on TFS, adding database unit tests and running unit tests using continuous integration.
Speaker:

Session Type:
General Session (75 minutes)

Track:
Application & Database Development

Level: 300

Session Code:
AD-320-M

Date: November 07

Time: 9:45 AM - 11:00 AM

Room: 606

Add to Schedule