Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 56
R is one of the fastest growing programming languages, useful for data analysis and visualization. You've been able to connect to SQL databases to work with large data sets before using R packages. But now, with the upcoming SQL 2016 release, R will be included as an Advanced Analytics Extension. You'll be able to run the same R scripts right in your database. 

In this beginner session we will look at how to set up R on your SQL instance. We'll work with some sample data to show how R works with SQL inside and outside the database with some basic R commands. And we'll create some graphs and charts for use in some SSRS reports. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: March 05

Time: 2:30 PM - 3:30 PM

Room: Room 208

This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the "noteworthy" query plan patterns that go beyond the normal areas that customer tend to investigate. This session covers SQL Server 2005 forward and includes the new SQL Server 2016 Query Store and Live Query Statistics. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: March 05

Time: 10:45 AM - 11:45 AM

Room: Room 214

In this session, we look in depth at how the query processor architecture and show what operations it performs during query optimization to generate equivalent query plans and find a “good enough” plan with limited time during query optimization, explain query optimization phases and show a few DMVs that are useful when diagnosing optimizer behavior
We will also explore the differences between In-Memory OLTP tables vs Disk based tables, and have a look at some considerations when you use the new cardinality estimator
We explain why query optimization complexity increases exponentially with the number of tables included in the plan, and how to diagnose and remedy issues that relate to bad query plans
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: March 05

Time: 9:30 AM - 10:30 AM

Room: Room 218

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 05

Time: 12:10 PM - 1:10 PM

Room: Room 217

Everyone knows that Azure SQL Database only supports a small subset of SQL Server functionality, small databases, and has really bad performance. Except, everyone is wrong. In fact, Azure SQL Server Database is ready to support many, if not most, databases within your enterprise. This session reintroduces Azure SQL Database and shows the high degree of functionality and improved performance that is now available. You’ll leave this session with a more thorough understanding of the strengths and weaknesses of Azure SQL Database so that you can make a more informed choice over when or if you should use it within your environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: March 05

Time: 1:15 PM - 2:15 PM

Room: Room 216

Have you wanted to start giving back to our amazing SQL Community through writing, but are not sure how to start? Do you want to start blogging, but are anxious about criticisms? Are you unsure what to write about? I’ll walk through how to find topics to start writing about. I’ll go over tools to help you blog, and websites that you can start blogging about. We’ll discuss why it’s import to be a woman blogger, and I’ll share with you my experience over the last three years as a woman blogger in our community. Role models are needed for women in tech. They need to know that they are wanted in the community and that they have a voice. Be that role model through blogging.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 05

Time: 12:10 PM - 1:10 PM

Room: Room 214

You're a DBA/Dev/BI Professional (delete as appropriate), what will your role be like in five years time? In this session we will talk about how the industry has changed over the last couple of years and hypothesize on where it is going and the type of work we might be doing and technologies that we will be dealing with.

Will the traditional developer, BI and DBA roles that we know so well today be the same, or will we need to diversify and look at expanding into other areas to stay ahead of the curve?
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 05

Time: 3:45 PM - 4:45 PM

Room: Room 217

BIG DATA!  There, I've said it.  But, what exactly does it mean for YOU?

This session will help to dispel some of the Big Data confusion.  This session will focus on HD Insight, Microsoft's Hadoop based cloud implementation.  Loading data and querying a database is one thing and that will certainly be covered. Exploring how we can integrate data from HD Insight into our existing analytic solutions is one of the real world implementations this session will be focused on.  This is one of the keys to successfully selling management on the needs for a Big Data solution. It's not just another database, it's a tool to enhance existing analytic structures.

During this session, we'll start with a brief overview of Hadoop and HDFS. Next we'll take a look at HDInsight, and explore some of the features therein.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: March 05

Time: 2:30 PM - 3:30 PM

Room: Room 207

'Big Data' has been the buzzword of the past few years. With the exception of a few niche verticals and use cases, it's often been a solution in search of a problem, as well as a word in search of a definition. With decision makers excited to push big data and predictive analytics solutions within organizations, data architects and developers must quickly understand its strengths within an enterprise BI architecture.

This session aims to define big data from the perspective of the enterprise data warehouse, while also arguing that both big data and data warehouses compliment one another perfectly. By using Google's big data analytics platform (BigQuery), SSIS, and a data warehouse built in SQL Server, we will illustrate how big data can best serve your organization, while also combining cloud and on-premise solutions across competing technology platforms.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: March 05

Time: 12:10 PM - 1:10 PM

Room: Room 215

SSIS is a powerful tool for extracting, transforming and loading data, but creating and maintaining a large number of SSIS packages can be both tedious and time-consuming. Even if you use templates and follow best practices you often have to repeat the same steps over and over and over again. Handling metadata and schema changes is a manual process, and there are no easy ways to implement new requirements in multiple packages at the same time.

It is time to bring the Don't Repeat Yourself (DRY) software engineering principle to SSIS projects. First learn how to use Biml and BimlScript to generate SSIS packages from database metadata and implement changes in all packages with just a few clicks. Then take the DRY principle one step further and learn how to update all packages in multiple projects by separating and reusing common code. 

Speed up your SSIS development by using Biml and BimlScript, and see how you can complete in a day what once took more than a week!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: March 05

Time: 9:30 AM - 10:30 AM

Room: Room 217

You're looking to protect your SQL instance from a machine failure.  Or maybe your storage budget and tight and you don't want to have your databases in two places with one of the other highly available options that SQL provides.  Let's learn what a cluster is and why it might be the right thing for you.  We'll explore the system, network, storage and database administration sides of the equation.  And, when it's all said and done we'll even have built a SQL clustered instance!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 05

Time: 3:45 PM - 4:45 PM

Room: Room 214

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance.  I have given this talk over SEVENTY times now and it is always very highly rated!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 05

Time: 1:15 PM - 2:15 PM

Room: Room 209

The learning curve for DAX isn't a straight line - it starts off gradual and quickly gets steep.  With a syntax similar to Excel, DAX seems easy enough for an Excel power user but things quickly get confusing without a good foundation in the basics of DAX.  Those basics - context and calculation - are the topic for this session.

This session is for the intermediate DAX user who has produced some quality data models and DAX calculations but who is still having difficulties with functions around filtering, time intelligence, and complex calculations.  We'll go through a number of practical examples that show that DAX at a fundamental level is a combination of creating filter and row CONTEXTS and then using those contexts to produce CALCULATIONS.  Understanding this concept is a must to produce more complex code in DAX and it's also a very useful framework for someone just getting started.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: March 05

Time: 10:45 AM - 11:45 AM

Room: Room 207

DevOps is a word that gets thrown around a lot these days and is the way most shops will operate in the future. In my presentation I'll show you how to fast forward to the future by automating your deployments from SSDT using Powershell and SQLPackage.exe.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 05

Time: 9:30 AM - 10:30 AM

Room: Room 214

As DBAs, we are asked all sorts of impossible questions.  Who dropped that important table last month?  Why was everything slow last week?  Who made that user a sysadmin?  You’d have to be a mind reader to know the answers to some of those, right?  Not necessarily!  SQL Server can help you find information about these and other common problems with its default trace and system_health Extended Events session, but you have to know how to collect and interpret the data they provide.  In this session, we’ll explore what system_health and the default trace are, what information they contain, and how to use them to find the answers you’re searching for.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 05

Time: 10:45 AM - 11:45 AM

Room: Room 216

This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!

This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 05

Time: 10:45 AM - 11:45 AM

Room: Room 218

Understanding how SQL Server organizes your data under the hood can seem like a daunting task. In this session we’ll take a look at how objects such as tables and indexes are stored in the data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions.

We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: March 05

Time: 10:45 AM - 11:45 AM

Room: Room 208

TBA
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: March 05

Time: 12:10 PM - 1:10 PM

Room: Room 209

Once you agreed to an SLA for the databases you manage its time to deliver on this promise
This session will show how to select from the many HA/DR features you have in SQL Server to pick the ones that will help you meet the SLA and most important will tell you how you must combine them to be successful.
For each one of the solutions we discuss we will define a series of failure modes and then check if the solution actually can fulfill the SLA as promised or if it needs more
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 05

Time: 2:30 PM - 3:30 PM

Room: Room 217

Dimensional modeling is arguably one of the most important
fundamentals of business intelligence.  It is still relevant even as
new technologies like PowerPivot and SSAS Tabular Models are becoming
more popular.  Correctly modeling your organization's data not only
protects the most important asset your company has but ensures that
your data mart or data warehouse will be responsive and capable of
accommodating emerging requirements.

This session provides a deeper dive into 
the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. Finally we will cover  physical design choices.This case study and demo based session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: March 05

Time: 2:30 PM - 3:30 PM

Room: Room 214

Sessions Found: 56
Back to Top