Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type




Sessions Found: 39
Are you familiar w/ SSAS Multidimensional and curious about Tabular? Having trouble deciding between cubes and tabular models? Then this is your session!

Analysis Services Tabular was introduced back in 2012, and yet it has only just started to emerge from the Proof-Of-Concept phase to a legitimate production alternative in most IT departments. Based on xVelocity, a highly compressed in-memory technology, Tabular models provide considerable performance improvements over Multidimensional models in many scenarios. And with major advancements in 2016, Tabular has never been a more appealing solution. But, as is the case with any new technology, there are certain limitations of which to be aware. 

Join me in this session and learn what a Tabular model is, how it fits into the Microsoft BI stack, the major factors to consider when choosing between Tabular and Multidimensional technologies, and finally a live step-by-step demo where we'll build and deploy a Tabular model.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI & DW

Level: Beginner

Session Code:

Date: September 17

Time: 11:30 AM - 12:30 PM

Room: 1237

Let’s face it, using SQLPS prior to SQL Server 2016 was like installing training wheels on a Ducati.   Then, some community feedback was incorporated before SQL 2016 shipped and presto, SQLPS is actually useful all of a sudden.

There is a faster way to manage and even SQL Servers using PowerShell.  I will show you what the new features in SQLPS and why you will probably find it useful, even if you aren't a "DBA".
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: September 17

Time: 9:00 AM - 10:00 AM

Room: 1237

Make your SSIS Life easy by learning SSIS administration.  There is lots of new stuff to learn in SSIS 2012 and 2014, to name a few: SSIS Catalog, Environmental Parameters, Encrypting passwords.   We will cover new upcoming features in 2016. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise DBA

Level: Intermedia

Session Code:

Date: September 17

Time: 9:00 AM - 10:00 AM

Room: 1236

"It's Slow!" are probably the two most dreaded words for any database professional (right behind "You're fired!") 

What's slow? Since when? Compared to what?

Join me in this "something-everyone-should-be-doing-but-isn't" session, where we will discuss baselines and performance monitoring for your SQL Server Analysis Services (SSAS) environment. We'll cover what a baseline is, what information it needs to include, and how it can help you troubleshoot immediate problems and proactively avoid them in the future. Walk away from the session with a plan that you can implemented next week to help avoid being caught off guard by SSAS performance issues and to make troubleshooting a breeze.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI & DW

Level: Intermedia

Session Code:

Date: September 17

Time: 9:00 AM - 10:00 AM

Room: 1223

This presentation covers massive waves of change throughout the analytics industry. We discuss how to keep track of key changes, planning or adapting your analytics career, and then we explore many "blue ocean" career opportunities in a new world of data. Cool topics such as Virtual Reality, Robotics, Automation, Predictive and Prescriptive Analytics, Internet of Things, Big Data, Cloud and Hybrid are explored.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 17

Time: 9:00 AM - 10:00 AM

Room: 2215

Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: September 17

Time: 3:00 PM - 4:00 PM

Room: 1225

The breadth of options available to data professionals today is staggering:  between relational, object, graph, and document databases, we have a wide array of storage options, as well as a huge number of access and analysis tools.  This talk will walk you through data platform, data analysis, and data processing options.  We’ll discuss when to use (and when not to use) Spark, R, Storm, and SSAS, as well as a range of other tools and technologies.  By the end of this talk, you may not have MongoDB or Neo4J, but you will know where they might fit.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: September 17

Time: 11:30 AM - 12:30 PM

Room: 1236

You’ve probably heard that it’s a data integration best practice to build small, unit-of-work SSIS packages. You’ve heard that with Biml you can create a lot of SSIS packages in very little time. You follow this advice and end up with dozens of SSIS packages. Now what? A metadata-driven SSIS Execution Framework will simplify the execution of several SSIS packages down to a simple, one-line stored procedure call. But then, how does one manage all the metadata required to populate the SSIS Execution Framework? Biml to the rescue!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
BI & DW

Level: Advanced

Session Code:

Date: September 17

Time: 11:30 AM - 1:00 PM

Room: 2218

Join us for a practical look at the components of Cortana Intelligence Suite for information management, data storage, analytics, and visualization. Purpose, capabilities, and use cases for each component of the suite will be discussed. Expertise required for implementation of each component will be covered as well. If you are a technology professional who is involved with delivering business intelligence, analytics, data warehousing, or big data utilizing Azure services, this technical overview will help you gain familiarity with the components of Cortana Intelligence Suite and its potential for delivering value.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Data Platform

Level: Beginner

Session Code:

Date: September 17

Time: 10:15 AM - 11:15 AM

Room: 1225

Recovery in the cloud is now easier and more convenient than ever.  This session describes some common scenarios and reviews the steps needed to prepare for a disaster with a recovery in Azure.  We will focus on the IAAS offerings.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise DBA

Level: Beginner

Session Code:

Date: September 17

Time: 3:00 PM - 4:00 PM

Room: 1223

The importance of proper table design cannot be underestimated. Misconceptions could lead into serious problems not only in terms of database performance, but also it can effect disk space management and interactivity of user interface as well. In this session the audience will have a sensible walk-through of database and table design in detail, encompassing a number of key areas of focus ranging from Data Types to FILESTREAM implementation. Discuss most common a table design mistakes. Find out efficiency of one type over another, IDENTITY vs. SEQUENCE vs. GUID to support PK uniqueness, pros and cons of using composite Primary Key and SPARSE column, and more.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise DBA

Level: Intermedia

Session Code:

Date: September 17

Time: 9:00 AM - 10:00 AM

Room: 1233

Data breaches abound!  Sql Server has several options to encrypt the data, Transparent Data Encryption, Cell Level Encryption and Sql Server 2016 Always Encrypted.  Let’s review each option to hide the encrypt the data.  Let’s also look at new options to hide data with Always Encrypted.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise DBA

Level: Beginner

Session Code:

Date: September 17

Time: 11:30 AM - 12:30 PM

Room: 1233

R is a pure data science and statistics scripting language. It is considered the best fit for Machine Learning. With more than 5000 packages all machine learning algorithms are covered and improving. R packages help you prepare the data, e.g.: packages for cross validation with N folds, build machine learning models, validation, create plots and to generate predictions. SQL Server 2016 and R Server are a perfect match for building enterprise grade solutions that support deployments for real time predictions and continuous model updates. Join this session for an overview based on sample cases about how to build enterprise grade machine learning solutions with SQL Server and R.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analytics

Level: Intermedia

Session Code:

Date: September 17

Time: 3:00 PM - 4:00 PM

Room: 2215

With so many languages around to extract, transform, analyze, and visualize data, Microsoft introduced yet another language : U-SQL.  In this session, we'll take a look at what U-SQL is, what it brings to the table, and how it differs from (or overlaps with) the existing constructs (T-SQL, SQL CLR, DAX/MDX, PowerQuery/M, R etc.,).  We'll go over step-by-step in getting started with U-SQL, and review some use case scenarios.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Data Platform

Level: Beginner

Session Code:

Date: September 17

Time: 11:30 AM - 12:30 PM

Room: 1225

We will go through Clustered and Non Clustered index internals. How Indexes are allocated and how SQL Server uses indexes in Select operations.

In that session we will use DBCC IND and DBCC PAGE and dig into pages' binary code to understand how SQL Server uses different kinds of Indexes.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise DBA

Level: Intermedia

Session Code:

Date: September 17

Time: 9:00 AM - 10:00 AM

Room: 2214

From the basics to the advanced, we will explore techniques that will ensure you leave a positive impression and help you land that role!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 17

Time: 1:45 PM - 2:45 PM

Room: 1237

One of the most common problems I have encountered as a DBA is the complaints from users that a particular query is slow, just one query.  Many times one that used to run in acceptable time, but now has slowed down substantially.

In this session we will show some of the causes for this, with emphasis on I/O requests being too high for the query.  

First part of the session will explain how to find these numbers, looking at a few queries with some major performance issues, including explaining why they have a problem.

The second part will focus on how to reduce I/O requests.

All of t his can be done without the need for any 3rd party tools, all within the scope of what is available to SQL Server, all versions, all editions, including Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise DBA

Level: Beginner

Session Code:

Date: September 17

Time: 1:45 PM - 2:45 PM

Room: 1236

This session will consist of two 15 minute "Lightning Talks" from two different presenters:  Geoff Hiten & William Assaf.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise DBA

Level: Beginner

Session Code:

Date: September 17

Time: 9:00 AM - 10:00 AM

Room: 2218

Microsoft’s Visual Studio 2013 provides a great way for database project teams to manage databases within the Software Development Lifecycle.  Learn how it enables you to create, manage, source control, schema compare, and deploy database objects.  In this presentation, I will break down the feature set of database development in Visual Studio 2013 then walk through a demo and offer some tips for SQL database developers to effectively manage their databases.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: September 17

Time: 1:45 PM - 2:45 PM

Room: 1223

If some of your databases have grown to over 1TB and it has become a challenge to maintain them - or if you are anticipating what to do in the future when they do - then this talk is for you! In this session, I will provide some practical advice on managing VLDBs with SQL server, focusing on common problem areas for new and experienced DBAs alike, including index maintenance, integrity checks, archival, backups and restores.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise DBA

Level: Intermedia

Session Code:

Date: September 17

Time: 1:45 PM - 2:45 PM

Room: 1233

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