Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 49
Have you spotted a location on Power BI map without having an exact address (like earthquake location)? Have you looped through source files in your Power Query and applied custom functions on them? Have you changed your data model to help Power Q&A to respond intelligently? Have you used Power BI for real-time data analysis? Have you used Power BI and Azure Data Factory to have an end to end Azure BI solution? Have you done many other amazing things with Power BI?

In this session you can expect many live demos and to be impressed by the extraordinary things you can do with Power BI. You will learn tips and tricks to empower your Power BI solution. Tips and tricks that you learn in this session helps you to make your Power BI solution more scale-able, robust, and high performance.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: October 22

Time: 8:30 AM - 9:45 AM

Room: MMC6

Are you finally ready to unlock the power in your spatial data? In this session, we will explore some advanced spatial analysis techniques, including clustering, binning, and the basic use of spatial statistics. We will then discuss several options for visualizing the results in SQL Server Reporting Services and Power BI. Get ready to go beyond bars and bubble charts!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: October 22

Time: 4:45 PM - 6:00 PM

Room: MMC6

In this session we will look at how you can use Power BI to analyse you company’s online presence. 

We will look at how you can source data from Google Analytics, Facebook, Twitter, LinkedIn and finally from web pages. We will then show how you can work with the data to get some meaningful analysis from it and ask the question: Can you get a holistic view of your online presence?

This is a demo rich session where we will go through getting the data in and looking through how we can extend the model using DAX to get more insight before visualizing the results. 

The participants will leave the session with ideas on how they can use Power BI (or indeed some other BI tool) to start analyzing their company's online presence plus the pbix file used in the session with all the code.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: October 22

Time: 10:15 AM - 11:30 AM

Room: MMC6

Machine Learning is a subfield of computer science concerned with systems that learn from data. So this isn’t about systems that follow explicitly programmed instructions, but rather about systems that find patterns and trends within datasets, and use them to deliver insight and predictions.

In this session, you will learn how an Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with Machine Learning algorithms, and then finally to the integration and embedding of predictive insights into applications.

This session has been specifically designed to describe Machine Learning fundamentals, and to help enable and inspire existing data professionals taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease by which it can be accomplished.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: October 22

Time: 8:30 AM - 9:45 AM

Room: MMC22

Are you tired of creating and updating the same SSIS packages again and again? Is your wrist hurting from all that clicking, dragging, dropping, connecting and aligning? Do you want to take the next step and really speed up your SSIS development?

Say goodbye to repetitive work and hello to Biml, the markup language for Business Intelligence projects.

In this session we will look at the basics of Biml. First learn how to use Biml to generate SSIS packages from database metadata. Then see how you can reuse code to implement changes in multiple SSIS packages and projects with just a few clicks. Finally, we will create an example project that you can download and start with to speed up your SSIS development from day one.

Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 22

Time: 1:30 PM - 2:45 PM

Room: MMC217

Join CTO of DH2i, OJ Ngo, for a live demo and discussion as he builds out a very unconventional SQL Server failover cluster. He will show you how to take standalone SQL Server instances on a mix of different OS and SQL Server versions/editions and transform them into an automated HA cluster with multi-subnet geo-clustering capability—all in just a few minutes.

With speed like that, there will still be plenty of time to show you:
•	QoS controls at the instance level
•	SQL and OS updates as fast as an application stop/start
•	How this solution can save you 30-60% on licensing costs

Stop slaving over your traditional WSFC environments and learn why Global 500 customers have adopted this profoundly simple, Microsoft certified solution.
Speaker:

Accompanying Materials:

Session Type:
Vendor Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 22

Time: 12:00 PM - 1:00 PM

Room: MMC23

Standardizing essential performance health check is the key in responding quickly to production issues and can cut down initial evaluation phase to 1/3rd of the time, whether you have been requested to do health check or you may want to run these due to an alert. These sets of essential checks can be the first major checkpoint for a DBA, they can look quickly on consolidated email stats first to decide if any further action is required to fix an issue or is it feasible to jump into in-depth troubleshooting. This will cut down on time and effort while responding to Production issues.

First part of the email shares some key observations about SQL Server performance which can be the key to quick resolution of the issue. Rest of the email shows different set of stats regarding CPU/Disk IO/Disk Space/Memory/Network/Blocking and database performance which could lead to the slowness observed in the application. This consolidated email can be shared with technical stakeholders to give a snaps
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 22

Time: 4:45 PM - 6:00 PM

Room: MMC16

Cortana Analytics delivers an end-to-end platform with an integrated and comprehensive set of tools and services to help users to build intelligent applications. This session will show Cortana can be used for collecting data from different resources, storing data,  getting insights from collected data, creating analytics services, and finally showing the results through web apps, mobile apps, or rich client apps.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: October 22

Time: 1:30 PM - 2:45 PM

Room: MMC22

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 (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 22

Time: 10:15 AM - 11:30 AM

Room: MMC1

Ever scratched your head in bemusement at how an apparently 'simple' T-SQL query could perform so poorly or erratically? SQL Server's execution plan for the query will likely reveal the root cause. It will tell you exactly which tables and indexes SQL Server accessed, and what operations it performed, in order to return the data that your query needed.
If your query logic confused the optimizer, or if it had inaccurate statistical knowledge of the data, then prepare for some nasty surprises in the plan, such as expensive scans, sort and join operations that spill to disk, and more. We'll examine common causes of these problems, such as use of 'generic' SQL, parameter sniffing, stale statistics, and misuse of functions. We'll cover techniques that will allow you to locate quickly the execution plans for high-cost queries in the workload, and we'll use some of the new execution plan features in SQL Server 2016 to detect and diagnose more easily the underlying query performance issues.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 22

Time: 10:15 AM - 11:30 AM

Room: MMC219

For beginning database professionals, execution plans can be intimidating. This 1-hour session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache. 

Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 22

Time: 8:30 AM - 9:45 AM

Room: MMC219

Azure Data Catalog is a service that helps data producers and data consumers get more value from existing data sources by making them easier to discover and understand. Users can register data sources to add them to the catalog with tags and annotations to share their purpose and intended use, and can discover them through searching, browsing and filtering. 

If you want the data you produce to have more impact, or you want to spend less time looking for the right data to use, please join us for this interactive session. We will cover the capabilities of the Azure Data Catalog, common scenarios for its use, and information about how to get started putting Data Catalog to work for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Information Delivery

Level: Beginner

Session Code:

Date: October 22

Time: 3:15 PM - 4:30 PM

Room: MMC22

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:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 22

Time: 10:15 AM - 11:30 AM

Room: MMC16

Employee/manager relationships, family trees, and the like are all hierarchical data. In this session, we'll look at a common way to represent such relationships, common methods of querying them, and how we can leverage the hierarchyid datatype to make queries go a lot easier and faster!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 22

Time: 4:45 PM - 6:00 PM

Room: MMC214

In Memory OLTP came along in SQL Server 2014 along with several limitations.
It was still really useful – as long as your use case suited the limitations.
SQL Server 2016 removes several of these limitations and widens the use cases of in-memory OLTP.
For example, even if you are not taking advantage of in-memory tables, you can probably leverage performance improvements by replacing traditional table variables and both local and global temporary tables with in memory implementations. Now you’ll be able to say that table variable is truly in memory!
Come along to this session and learn about some of features of in memory OLTP  - or Hekaton as a lot of people refer to this -  and how you may be able to leverage these high performance features in both new and existing applications.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 22

Time: 3:15 PM - 4:30 PM

Room: MMC214

SQLPS has been evolving since 2012 and the SQL Provider/cmdlets have been around since 2008. Have you taken advantage of the PowerShell infrastructure that is on your servers? This session takes you behind the scenes of the SQLPS module that is installed with the tools. We will cover how to get it without the tools, how to use it once you have it and why you will want to use it for simple tasks or complex ones. When you learn how to navigate SQL Server and all its services using Paths, you won't go back. Join me for a fun filled hour and learn how to keep SQLPS from becoming frustrating and a black box. You will be glad you did. Let's continue the journey to becoming a PowerShell DBA.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 22

Time: 1:30 PM - 2:45 PM

Room: MMC16

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:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 22

Time: 3:15 PM - 4:30 PM

Room: MMC1

Take an introductory journey into the world of SSIS through the eyes of a SQL Server DBA as he navigates the Business Intelligence waters.  This is an introductory course for beginners or users without any SSIS experience.  Come learn how to SSIS with me!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 22

Time: 8:30 AM - 9:45 AM

Room: MMC217

It has been a long established practice to keep maintain application code in version control. Versioning your application code allows you to view changes made by several developers working on the same project. It allows the team to get the latest changes in a consistent and reliable manner. It allows you to return your code to a prior state. It even acts as a safety net for when that day comes when your developer’s computer won’t turn on.

So, what about your SQL Objects? 

Join me in this demo heavy session where we will explore the benefits of versioning your SQL Objects and learn how it can enable streamlined database development without sacrificing control and visibility. We’ll be using Red Gate’s SQL Source Control tool for demos, and we’ll see how it integrates with your existing version control software to manage your SQL Objects just like application code.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Vendor Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 22

Time: 12:00 PM - 1:00 PM

Room: MMC16

Pyramid Analytics’ industry-leading Modern BI platform balances IT control and business user success. It offers enterprise capabilities such as advanced data modeling, self-service data discovery, interactive dashboards, and narrative reporting on any device. Here’s what makes Pyramid Analytics unique: (1) A true analytics platform that combines the security and stability of IT governance with the flexibility and utility of user-driven analysis (2) A scalable platform that supports the volume and variety of data, subject areas, and users across the enterprise (3) The BI Office collaboration engine lets users share analysis, comments, and context to bring the power of the collective to every decision (4) Enterprise-grade, role-based security that enables the right access for the appropriate audiences across the platform – even down to the cell level of content (5) Merging advanced visuals and powerful analytics provides real-world utility, and gives users the power to answer challenging
Speaker:

Accompanying Materials:

No material found.

Session Type:
Vendor Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 22

Time: 12:00 PM - 1:00 PM

Room: MMC214

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