Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type



Sessions Found: 37
You see others getting great employment opportunities while you are stuck spinning your wheels.  You are willing to put in the work, but don't get the notice you think you deserve.  How can you put yourself in position for some of the great opportunities out there?  Let's talk about 7 actionable steps you can take, starting here in Seattle, to put yourself in the driver’s seat of your career.  We will discuss tools you can use to increase your networking exposure, how to position your yourself to let the correct people know you are interested in working with them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Pro

Level: Beginner

Session Code:

Date: April 30

Time: 2:00 PM - 3:00 PM

Room: Pro - Room 304

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: April 30

Time: 12:55 PM - 1:55 PM

Room: Room 210

This session will go well beyond creating SSAS cubes with the cube wizard.  I'll cover topics such as the pros and cons of ROLAP,  XMLA Processing options, Many to Many Bridge Tables and the use of the DefaultMember and IsAggregatable properties, SSAS Report Actions, Dynamic SSAS Roles with custom MDX code,  Advanced MDX in SSRS, Partitioning and Aggregations,  Data Driven KPIs, and Dimension Attribute Discretization.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Advanced

Session Code:

Date: April 30

Time: 8:30 AM - 9:30 AM

Room: BI 2 - Room 361

While Machine Learning is not new, it has never been easy to implement. Azure Machine Learning (AML) aims to provide a set of tools that are easier to use and once a model is created easier to consume by client applications. At the core of AML is ML Studio. ML Studio provides an easy to use graphical tool that allows you to control the process from pre-processing the data, to applying learning algorithms, testing the model, and finally deploying the model for use by client applications. This session guides you through the process of creating and deploying a ML model. In addition it will demonstrate how client applications can easily use the model once it is deployed.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: April 30

Time: 2:00 PM - 3:00 PM

Room: BI 2 - Room 361

Data partitioning is a valuable technique that simplifies database administration tasks and helps meet availability and performance SLAs. In this session, Dmitri will cover several techniques and architectural approaches you can use to partition data in the different versions and editions of SQL Server. You will learn about partitioned tables, partitioned views and stretch databases introduced in SQL Server 2016. Finally, Dmitri will discuss the practical questions, such as how to move data between filegroups and disk arrays keeping tables online, implement sliding window data purge pattern and benefit from partitioning in the systems with mixed (OLTP/DW) workloads.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: April 30

Time: 2:00 PM - 3:00 PM

Room: DBA - Room 362

We have all encountered difficult managers that leave us stressed out.  They can be micro-managers, bullies, too timid, or even just apathetic.  In any case, you are currently stuck with this manager, and you need coping strategies!
Through case studies and open discussion, we will help you determine if you indeed have a difficult manager.  We will identify and categorize behavior patterns of managers so that you can determine the best strategies to deal with him or her.  In addition, we will also explore the consequences of these actions, and how they can help you to succeed in furthering your career.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Pro

Level: Beginner

Session Code:

Date: April 30

Time: 3:15 PM - 4:15 PM

Room: Pro - Room 304

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 recover in Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: April 30

Time: 9:50 AM - 10:50 AM

Room: Pro - Room 304

Building packages in SQL Server Integration Services is easy. Building good packages takes a bit more effort.
SQL Server Integration Services is deceptively easy to use. With a few hours of instruction or self-study, most data professionals can throw together an SSIS package. However, creating a process that simply runs successfully isn’t the endgame; enterprise-class ETL demands a higher standard. Specifically, well-designed packages will be:
•	Reliable
•	Resilient
•	Reusable
•	Maintainable
•	Well performing
There’s nothing magical about building rock-solid SSIS packages, but it does take some discipline, experience, and a library of best practices. That is exactly the aim of this course: to demonstrate a set of proven practices that help frame the development of enterprise-ready SSIS packages.
In this full-day presentation, we will walk through each of these five facets of well-built packages, discussing and then demonstrating ways of applying these practices.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Half Day Session (240 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: April 29

Time: 8:00 AM - 12:00 PM

Room: 260

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

Level: Beginner

Session Code:

Date: April 30

Time: 11:10 AM - 12:10 PM

Room: BI 2 - Room 361

You know how to do the basics: selects, joins, filtering. What comes next? Sometimes it can be difficult to figure out what comes after SELECT * FROM.  This session covers some of the more advanced features of TSQL that you may not know about. We will cover subqueries and the different ways they can be used. We will cover the different windowing functions and how they can be used. And finally we will cover the MERGE command.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DEV

Level: Beginner

Session Code:

Date: April 30

Time: 8:30 AM - 9:30 AM

Room: Dev - Room 360

This session shows several common mistakes and inefficiencies that can be found in many production systems such as excessive code reuse in the database using the views and multi-statement functions and in the data access code; unnecessary joins and I/O operations in pagination queries; storage of multiple entities in the same tables using XML for entities-specific attributes; usage of the optional parameters in the where clause of the queries; and several others. The session explains the root-cause of performance issues those mistakes introduce and demonstrates how to properly address them in the code and database design.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DEV

Level: Intermedia

Session Code:

Date: April 30

Time: 3:15 PM - 4:15 PM

Room: DBA - Room 362

You’ve read some of the content of well-known Data Warehousing books – now what?  How do you take the structures and disciplines inside such books as the Ralph Kimball series and implement them?  This session will take several of the key concepts in Data Warehousing and demonstrate some implementations using SQL Server Integration Services and Analysis Services.  We’ll look at items such as Type 2 Changing Dimensions, Confirmed Dimensions, Dimension Outriggers, Role-Playing Relationships, Many-to-Many Bridge table relationships, Factless Fact tables, Handling of NULL foreign key values, and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: April 30

Time: 9:50 AM - 10:50 AM

Room: BI 2 - Room 361

Have you ever needed to generate dozens (or even hundreds) of similar SSIS packages? Do you ever find yourself needing to regenerate a lot of packages when some piece of the upstream data format changes? Using native SSIS, this can be a tedious and error prone exercise. However, using Biml (Business Intelligence Markup Language) can greatly increase your productivity as an ETL developer.

In this session, we'll cover the essentials of Biml. I'll discuss what it is and what it can do for SSIS, demonstrating how it can easily generate dozens or even hundreds of packages in just a few minutes. I'll also demonstrate some realistic examples and discuss how Biml fits into the enterprise ETL picture.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: April 30

Time: 9:50 AM - 10:50 AM

Room: Room 210

With examples of real problems and (attempted) solutions, this presentation will examine dimensional modeling techniques which simplify and speed up measure evaluation. A fast-paced and language/tool-agnostic look at some common and uncommon reporting scenarios, including:
•	All manner of date calculations and comparisons
•	Slowly changing dimensions
•	Events in progress
•	Conditional evaluation of measures
 
By the end of this talk, you should have a stronger understanding of the right questions to ask that will make your BI solution simpler for end users and more performant at run-time.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DEV

Level: Beginner

Session Code:

Date: April 30

Time: 2:00 PM - 3:00 PM

Room: BI 3 - Room 359

Whether predicting customers or All Stars, the process and the tools remain the same.  Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships.   Join me to see what data mining is, what data mining is not and how Microsoft's data mining tools can help you analyze your business.  During this session, I will walk us through a start-to-finish data mining prediction project.  It's easier than you might have thought.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: April 30

Time: 11:10 AM - 12:10 PM

Room: BI 3 - Room 359

In the world of extraction, transformation, and loading (ETL), everything we do involves moving data from one point to another. However, very often the focus in SSIS package development is on functionality, not security. When building internal data transformation and movement processes, it is easy to forget that these operations broaden our security footprint, and must be actively managed to ensure that ETL doesn’t become the weak link in the security chain.

In this presentation, we’ll discuss the security features in SQL Server Integration Services, while reviewing best practices for securing your ETL infrastructure while providing enough (but not too much) access to those ETL assets. Among the topics we’ll cover:
?	Properly securing connection passwords in SSIS
?	Using package protection levels
?	Restricting access to deployed packages
?	Using role-based security for SSIS deployment and execution
?	Using execution proxies
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: April 30

Time: 2:00 PM - 3:00 PM

Room: Room 210

Come see Microsoft's Power tools demonstrated for advanced analytics and hear about Microsoft's embrace of Open Source and the Hadoop platform. We'll also present on Microsoft's tools for handling Big Data, such as the Parallel Data Warehouse and HDInsights. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: April 30

Time: 8:30 AM - 9:30 AM

Room: Pro - Room 304

Microsoft Sponsor's Session
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: April 30

Time: 12:55 PM - 1:55 PM

Room: DBA - Room 362

A session full of demos demonstrating how SQL Server startup parameters, trace flags and the create database and alter database command when used correctly for the underlying hardware can make scanning your fact tables much faster.

We will also as a side effect explore the Mary Go Round query feature and find ways to bulk load data faster and how to load from an OLTP system with zero impact to it.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: April 30

Time: 8:30 AM - 10:00 AM

Room: DBA - Room 362

So you jumped on the bandwagon and set up a Hadoop cluster…but now what?  Your database developers and app developers know how to integrate with and develop against SQL Server, but the Hadoop world is a completely different experience.  This talk will help bridge the gap between SQL Server and Hadoop, using tools such as SQL Server Integration Services and Sqoop to migrate data between a Hadoop cluster and a SQL Server instance, as well as PolyBase to integrate the two like never before.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DEV

Level: Intermedia

Session Code:

Date: April 30

Time: 9:50 AM - 10:50 AM

Room: Dev - Room 360

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