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.
  • - Half-days are listed in the Schedule Builder with 2 parts - to correctly show that you are planning to attend the entire half-day, you must add both parts of the half-day session.

View Session Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type



Sessions Found: 109
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

Room Capacity:

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

Room Capacity:

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

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:

Accompanying Materials:

No material found.

Session Type:
General Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: 200

Session Code: DBA-218

Date: November 07

Time: 4:00 PM - 5:15 PM

Room: 618-620

Room Capacity:

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:00 PM - 5:15 PM

Room: 401

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

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

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: 10:15 AM - 11:30 AM

Room: 401

Room Capacity:

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

Room Capacity:

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: 6C

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: 609

Room Capacity:

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:30 PM - 5:45 PM

Room: 6C

What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012's SNAPSHOT Isolation optimistic?  How can SQL Server 2014's In-Memory OLTP provide truly optimistic concurrency? 

In this session, we'll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!
Speaker:

Session Type:
General Session (75 minutes)

Track:
Application & Database Development

Level: 300

Session Code: AD-307

Date: November 05

Time: 3:00 PM - 4:15 PM

Room: 6E

Queries need your help! Your mission, should you choose to accept it, is to make great decisions about what indexes are best for your workload. In this session, we'll review the difference between clustered and nonclustered indexes, show when to use included columns, understand what sargability means, and introduce statistics. You'll leave this session with the ability to confidently determine why, or why not, SQL Server uses your indexes when executing queries. 
Speaker:

Session Type:
General Session (75 minutes)

Track:
Application & Database Development

Level: 200

Session Code: AD-200

Date: November 07

Time: 10:15 AM - 11:30 AM

Room: 611-612

Room Capacity:

Today's server hardware ships with a truly massive amount of CPU power. And while SQL Server is designed to automatically and seamlessly take advantage of available processing resources, there are a number of options, settings, and patterns that can be exploited to optimize parallel processing of your data. 

This full-day pre-conference session starts with an overview of CPU scheduler internals from the perspective of both Windows and the SQL Server Operating System (SQLOS). Next, you will learn about intra-query parallelism, the method that SQL Server uses to break up large tasks into many smaller pieces, so that each piece can be processed simultaneously. You will come to understand how to read parallel query plans and how to interpret parallel wait statistics, as well as best practices for the various parallelism settings within SQL Server. Finally, you will be introduced to techniques for exploiting parallelism at the query level: patterns that can help the optimizer do a better job of parallelizing your query. 

After attending this pre-conference session, you will be in full control of your CPUs and be able to compel your server to use every clock tick to your end users' advantage.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Pre-Conference Session (full day)

Track:
Application & Database Development

Level: 400

Session Code: AD-499-P

Date: November 04

Time: 8:30 AM - 4:30 PM

Room: 606-607

Attendees will leave with a live-deployed Hadoop environment they can take back to their company and begin using! This session covers the basics, but quickly goes beyond to a hands-on scenario based approach covering something for all attendees. We will be discussing deployment models, best practices, administration and configuration patterns, and more! 

We will do this through a series of labs that the audience can follow along with. These labs and demos will showcase how to make big data real for the enterprise. That means something for the architects with on-demand compute and analysis, something for operations with real time operational streaming and analytics, predictive analytics for the analysts and development, and BI integration for the data developers.

Each student will build a new environment setting up these scenarios so they can take the examples back to their own firm and use them the next day. This is a real development and architecture coaching and training session that will leave attendees excited about all that these technologies can do to modernize their data architecture. 

We will also provide coverage of new innovation areas such as Stinger, Spark, and other new technologies that make this ecosystem more valuable to the modern data professional.

Speaker:

Accompanying Materials:

No material found.

Session Type:
Pre-Conference Session (full day)

Track:
BI Platform Architecture, Development & Administration

Level: 300

Session Code: BIA-396-P

Date: November 03

Time: 8:30 AM - 4:30 PM

Room: 618-620

It's 2:30 a.m., and you've just gotten that call no ETL developer wants to get: an SSIS package has failed unexpectedly. Immediately, you start asking yourself: "What could have caused this?", "What do I do to fix the data from this failed execution?", and, most importantly, "Could I design the package in such a way that this doesn't happen again?"

In this demo-packed session, we will examine the design patterns and logistics of building error-resistant SSIS packages. Starting with the control flow, we'll work through various tools and patterns that can be used to prevent, or at least handle appropriately, task-level errors. We'll then move to the data flow, and discuss and demonstrate how to proactively address problem data to prevent unexpected package failures.
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: 300

Session Code: BIA-303

Date: November 06

Time: 1:30 PM - 2:45 PM

Room: 602-604

Room Capacity:

As organizations look to lower infrastructure costs and increase worker productivity, two industry trends have emerged: the shift to the cloud and self-service. How will these trends change the way we build BI solutions, without compromising on security, manageability and governance? Join this session and find out!

We will explore the following questions: What is Power BI? What do you need to run Power BI? How does Power BI differ to traditional BI? Where does Power BI fit in a broader enterprise BI strategy? And, finally, how can on-premises data sources be used in cloud-based Power BI solutions?

In addition to answering these questions, we will build a Power BI solution from scratch using both on-premises and cloud-based data sources. We will use Power Query, Power Pivot, Power View and Power Map, before deploying the solution to a Power BI site in the cloud, and interacting with it using Q & A, the new natural language query technology.
Speaker:

Session Type:
General Session (75 minutes)

Track:
BI Information Delivery

Level: 200

Session Code: BID-201

Date: November 05

Time: 10:45 AM - 12:00 PM

Room: 611-612

Some of the biggest challenges in any large SQL environment are maintaining consistent configurations and meeting the pressures from the business for rapid server deployments. Join us in this session to learn best practices for system settings, file system layout, and scheduling maintenance tasks. 

By default, SQL Server does not install with best practices for every environment. In this session, we will discuss the best practices for most SQL Server configurations, and how to automate your SQL Server builds in both physical and virtual worlds. As you may know, completely automating the build process has great benefits, but it also has great trade-offs. We will talk about lessons learned from building a private cloud at a Fortune 100 telecommunications company with thousands of servers. 

You will also learn how use these same methods to ensure your own server build consistency, whether your SQL Servers are in the cloud or on-premises.
Speaker:

Session Type:
General Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: 200

Session Code: DBA-201

Date: November 05

Time: 10:15 AM - 11:30 AM

Room: 6A

Performance tuning: it's not just for DBAs!  Many design decisions that are made early in the application lifecycle can have a dramatic impact on performance later on.  Once an application is in production, correcting these issues may be time-consuming or even impossible without a complete re-write!  In this session, we learn some of the considerations that you the developer should keep in mind when designing a new database application.  Learn how things like choice of data type, caching, looping etc. can affect the performance of your application before you even write your first query.
Speaker:

Session Type:
General Session (75 minutes)

Track:
Application & Database Development

Level: 200

Session Code: AD-210-M

Date: November 07

Time: 4:00 PM - 5:15 PM

Room: 607

Room Capacity:

Sessions Found: 109