Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type


Sessions Found: 39
Power BI promotes a vision of self-service BI. Successful adoption of the self-service paradigm presents many challenges that must be overcome in order to achieve this vision. 

Microsoft has recently created a Power BI Adoption Framework designed to assist customers overcome the challenges and barriers that impede success. This Framework exposes the critical elements of Power BI adoption and provides a structured approach for driving adoption of self-service BI.

Attend this session and be among the first to be exposed to this new content from Microsoft. The session provides an overview of the Adoption Framework, covering each of the four cornerstones components:

Prove Value (awareness)
•	What are the essential questions?
•	What are the key value drivers?

Governance (understanding)
•	What are the core concerns around security and compliance?

Roll Out (enablement)
•	How to manage frequent changes, licenses, training, …

Support (enablement)
•	What types of support are required?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Evolve

Level: Intermedia

Session Code:

Date: October 28

Time: 8:30 AM - 9:45 AM

Room: Evolve-Perform

You have probably heard the buzz about Azure Machine Learning, aka Azure ML,  over the past few years. It is a surprisingly easy to use predictive analytic tool that you can learn for free. Attend this session to learn how to get started with Azure ML.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Analyze

Level: Beginner

Session Code:

Date: October 28

Time: 12:50 PM - 2:05 PM

Room: Analyze-Build

Are you trying to understand what’s the fuzz around Machine Learning? Are you working with a lot of data analysis and wondered how SQL Server 2016 R Services might be able to help?
 
This session will provide a gentle and fun introduction to SQL Server R Services for SQL Nerds. We will walk through pragmatic examples of using R through demos, to illustrate Machine Learning in boosting your Data Analysis capabilities. The goal of this session is to provide quick tips and tricks for attendees to get started on SQL Server R Services, either for fun or for work.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Innovate

Level: Beginner

Session Code:

Date: October 28

Time: 8:30 AM - 9:45 AM

Room: Build-Innovate

This session will review common challenges encountered when preparing new data sets for use in analytics and reporting. We will look at some tools to open, repair and edit large CSV/TXT files. We will also review tools for building a repeatable cleanup and restructuring process including Talend Data Preparation, Trifacta Wrangler and Power BI on the desktop and available cloud integrations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Analyze

Level: Beginner

Session Code:

Date: October 28

Time: 2:30 PM - 3:45 PM

Room: Analyze-Build

If you are working with SSAS Tabular, Power BI, or good ol' Power Pivot for Excel, you've likely run into a need for DAX, the formula and query language of these tools.  A very common task is to augment, override, or otherwise modify a filter context.  This sounds easy enough, but if you've had experience beyond simple filters, the syntax and behavior may seem confusing, or worse, counter-intuitive. The purpose of this presentation is to discuss the different types of filters, their behavior, and their interactions with other DAX formulas.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Design

Level: Intermedia

Session Code:

Date: October 28

Time: 3:55 PM - 5:10 PM

Room: Design

There are not enough hours in the day to get everything done as a DBA. We need to automate our repetitive tasks to free up time for the important and more fun tasks.
In this session I'll show how dbatools can help you automate and simplify your daily tasks and make your life a lot easier.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Support

Level: Beginner

Session Code:

Date: October 28

Time: 12:50 PM - 2:05 PM

Room: Scale-Support

Transactional Replication gets a bad rap for being fragile and somewhat difficult to manage. Given that reputation, we decided to try to accomplish some of the same things that it does using alternative means. Let me regale you with the tale of that journey. You may come out of it with a newfound appreciation of Replication or you may find yourself asking "that's pretty neat!". Only one way to find out, though…
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Build

Level: Intermedia

Session Code:

Date: October 28

Time: 3:55 PM - 5:10 PM

Room: Build

Do you have trouble remembering common administrative T-SQL commands? Remember when you created a cheat sheet in school to help you study for an exam?  Use that same principle with the DBA Cheat Sheet! The DBA Cheat Sheet is a document filled with some basic administrative TSQL commands you’ll need in your daily work. During the session I’ll show you a few SSMS tricks and review some of the topics in the DBA Cheat Sheet document.  You’ll leave the session with a document that you can use as a reference every day.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Build

Level: Beginner

Session Code:

Date: October 28

Time: 8:30 AM - 9:45 AM

Room: Build

Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Support

Level: Beginner

Session Code:

Date: October 28

Time: 2:30 PM - 3:45 PM

Room: Scale-Support

According to the Economist magazine, data is the world’s most valuable resource.  So, it makes sense that Data Science, Azure Machine Learning, and Analytics are all becoming core pieces to the success of every business.  As data professionals, we need to know how these core pieces will affect what we do, and how we can use this suite to help our clients.  Microsoft’s Cortana suite is the central hub for learning and implementing each of these core pieces.  Using an easy to follow example, I will show the flow from Data to Data Intelligence. The demonstration uses several pieces of the Cortana Suite and brings them together to show how they complement each other.  This overview of Cortana Suite will use the various pieces like a puzzle which, when brought together, will form a seamless picture of the whole so that participants can see that the individual pieces were meant to work together.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Design

Level: Beginner

Session Code:

Date: October 28

Time: 12:50 PM - 2:05 PM

Room: Design

Did you know that there is more than one type of index? Do you know the differences between them? Do you know when SQL Server flat out can’t use an index? Join Jared Karney as he explains the differences between the types of indexes and when they can and cannot be used (SARGability). He will talk about the different ways they are used and how you can make good indexes even better. You will leave this session understanding the basics of indexes and how they work, which is crucial to making your queries and servers perform well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Perform

Level: Beginner

Session Code:

Date: October 28

Time: 8:30 AM - 9:45 AM

Room: Perform

This session will cover the basics of developing, publishing and using SQL Server Reporting Services. You will learn all the steps needed to get started from connecting to the data source, creating data sets through putting the data on the page and publishing the report to the report server. See how easy SSRS is to use and how powerful it can be. The demo will be using SSRS 2016 but the concepts covered are applicable to any version of SQL Server. 
The session will also include: 
A tour of a wide variety of report examples including interactive graphical dashboards that you can do in SSRS, even in older versions. 
A comprehensive discussion of design elements to include and avoid when creating reports. 
Report printing and export considerations for optimal output depending on rendering format.
You will leave this session able to return to the office and present meaningful data to your end users with minimal time and effort with easy to use and powerful BI tool that you already own.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Build

Level: Beginner

Session Code:

Date: October 28

Time: 2:30 PM - 3:45 PM

Room: Build-Innovate

In one small step, SQL Server 2016 has taken a giant leap...to JSON! In this session, we'll launch a probe into a JSON data file containing profiles of NASA astronauts using new JSON T-SQL functions in SQL Server. With each astronaut we meet, we'll learn to validate, read, and manipulate "unstructured" JSON data. We'll get The Right Stuff to start developing, no previous JSON experience required. Let's go where NoSQL has gone before!

Prerequisites:
You should have experience writing queries in T-SQL. No previous knowledge of JSON is needed.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Build

Level: Beginner

Session Code:

Date: October 28

Time: 8:30 AM - 9:45 AM

Room: Build

Times are certainly changing with Microsoft’s recent announcement to adopt the Linux operating system with the release of SQL Server 2017, and you should be prepared to support it. But, what is Linux? Why run your critical databases on an unfamiliar operating system? How do you handle the basics, such as backing up to a network share or add additional drives for data, logs, and tempdb files?

This introductory session will help seasoned SQL Server DBAs understand the basics of Linux and how it differs from Windows, all the way from basic management to performance monitoring. By the end of the session, you will be able to launch your own Linux-based SQL Server instance on a production-ready VM.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Build

Level: Beginner

Session Code:

Date: October 28

Time: 12:50 PM - 2:05 PM

Room: Build

The ability for multiple processes to query and update a database concurrently has long-been a hallmark of database technology, but this feature can be implemented in many ways. This session will explore the different isolation levels supported by SQL Server and Azure SQL Database, why they exist, how they work, how they differ, and how In-Memory OLTP fits in. Demonstrations will also show how different isolation levels can determine not only the performance, but also the result set returned by a query. Additionally, attendees will learn how to choose the optimal isolation level for a given workload, and see how easy it can be to improve performance by adjusting isolation settings. An understanding of SQL Server's isolation levels can help relieve bottlenecks that no amount of query tuning or indexing can address - attend this session and gain Senior DBA-level skills on how to maximize your database's ability to process transactions concurrently.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Perform

Level: Beginner

Session Code:

Date: October 28

Time: 2:30 PM - 3:45 PM

Room: Perform

Power BI makes accessing data from various sources (both on-premise and in the cloud) and building advanced visualizations for analytics easy to do. Behind the scenes Power BI is built on standard technologies and APIs that allow it to be customized in multiple ways to fit in with your environment the way you need it to. In this session we will walk though samples and demos that show how you can extend Power BI with custom visualizations, access custom data sources, embed various Power BI elements in your applications (on-premise and in the cloud), and be able to push your data into a Power BI report/dashboard. Each of these items take advantage of the Power BI APIs in different ways and we will discuss each and provide the code samples for you to take back and get a head start. This session will be showing code to access the Power BI REST API using C# and NodeJS along with some M for accessing and manipulating custom data sources (on-premises or in the cloud).
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Build

Level: Intermedia

Session Code:

Date: October 28

Time: 12:50 PM - 2:05 PM

Room: Build-Innovate

The principles of dimensional modeling for data warehousing, especially the work of Dr. Ralph Kimball, have been enormously successful for many years. But are they still relevant to the world of data lakes and big data? And what is their role in a modern DW of a relational database, even massively parallel databases like Azure SQL DW? 
      
This presentation will explore when the concepts of dimensional modeling are still relevant to give value to your Data Lake and Big Data solutions and then cover the reason why a modern DW on Azure SQL DW is still needed. It will conclude with some implementation details of a Modern DW on Azure SQL DW, that relate to modeling including how to maximize performance by minimizing Data Movement (Shuffle Move and PartitionMove operations).
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Design

Level: Intermedia

Session Code:

Date: October 28

Time: 10:10 AM - 11:25 AM

Room: Design

"If there’s one thing that we, as SQL developers don’t do, it’s use transactions as often as we should.

Transactions are critical when multiple changes need to be made entirely or not at all, but even given that it’s rare to see transactions used at all in most production code

In this session, we’ll look at what transactions are and why we should use them. We’ll explore the effects transactions have on locking and the transaction log. We’ll investigate methods of handling errors and undoing data modifications, and we’ll see why nested transactions are a lie.

1) Understand what transactions are and what they do.

2) Learn how to use transactions in combination with error handling to roll back changes on errors

3) Learn how transactions affect logging and locking.

"
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Build

Level: Beginner

Session Code:

Date: October 28

Time: 2:30 PM - 3:45 PM

Room: Build

SQL Server 2017 is right around the corner, bringing with it a host of exciting new features.  Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem.  This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!

In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services.  We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL.  We'll then discuss some of the powerful open source packages that are available to aid your data analyses.  Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Analyze

Level: Beginner

Session Code:

Date: October 28

Time: 8:30 AM - 9:45 AM

Room: Analyze-Build

When the SQL Server optimizer evaluates a query to determine how best to execute it, the statistics are quite possibly the most important tool at its disposal. But SQL Server statistics objects aren’t perfect because they only contain estimated summary information. In this session, we’ll start with an overview of what the statistics objects are, how the optimizer uses them, and some general guidelines for their maintenance. Then we’ll look at some of the issues, how to find them, and how to solve them, that can arise due to their imperfection: ascending keys (the most prevalent statistics based performance killer?), correlated predicates, skewed distribution, or downright bad summary information. There’ll be many examples, and even a stored procedure to help you find ascending keys. By applying the techniques we’ll discuss, you WILL see improved query performance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Perform

Level: Intermedia

Session Code:

Date: October 28

Time: 12:50 PM - 2:05 PM

Room: Evolve-Perform

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