Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type



Sessions Found: 40
High availability is an important goal, not just for the database but for all software services. There's increasing pressure to keep those services online 24/7/365. But there's also pressure to deploy improvements frequently. How can developers change the database schema without interrupting the availability?

In this session, I introduce and describe the "blue-green" continuous delivery technique - a strategy for replacing system components without down time. I explain what it looks like for database changes without sacrificing availability or performance.

I'll also describe how we gradually modified our process in baby steps. Going from maintenance window deployments to fully online deployments.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Admin

Level: Intermedia

Session Code:

Date: March 03

Time: 1:15 PM - 2:15 PM

Room: 219

What if we could analyze a single query with thirteen different performance problems? In this session we’ll explore a query, understand and fix all thirteen problems. 

1- There is a nonsargable filter
2- An index is missing
3- It is a query optimizer mistake
4- The subquery is unnecessary
5- Query join order is incorrect
6- A filtered statistic is missing
7- Scalar functions are running twice per each row
8- High number of reads on worktable
9- An unknown syntax could be used
10- Memory grant wasn’t enough
11- Distributed query doesn't look good
12- Residual predicates
13- Avoid window spool ondisk
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Dev

Level: Intermedia

Session Code:

Date: March 03

Time: 1:15 PM - 2:15 PM

Room: 227

SQL Server 2017 being released brings to the table some new features and improvements in quick succession from SQL Server 2016. In this session we will look at a subset of the new &/or improved features that SQL Server 2017 brings to the table.

From Analytics, Availability, Configuration and Performance there is something for everyone in this session to introduce you to the latest version of SQL Server.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Admin

Level: Beginner

Session Code:

Date: March 03

Time: 9:30 AM - 10:30 AM

Room: 211

In today's fast-paced world, businesses require up to the minute information to support critical decisions. Traditional business intelligence solutions, however, are not able to keep up with this demand and a new approach is required. Azure Stream Analytics is a real-time event processing engine capable of analyzing millions of events every second. During this session, you will learn some of the key concepts needed to work with streaming data before stepping through an end-to-end streaming data solution.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: March 03

Time: 3:45 PM - 4:45 PM

Room: 217

Since April 2017 another fascinating PaaS in the Microsoft Cloud reached general availability: Azure Analysis Services. 
But why should you switch from your existing on-premise solution to the cloud or plan your new approach with it? What are the big advantages of Azure Analysis Services? And what actually are the differences to PowerBI? Why is Azure Analysis Services an important step to enhancing the possibilities for BI in the cloud? 
This session offers answers to your questions and provides insight to support the positioning of Azure Analysis Services in your Business Intelligence strategy.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: March 03

Time: 1:15 PM - 2:15 PM

Room: 216

The primary goal of a DBA is being able to restore a database when needed.

In this session you will learn about data files and transaction logs, RTO and RPO, and how to choose the right recovery model for your environment.

You will be able to go back to work on Monday with a better understanding of database backups, and how to automate any database restore task.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Admin

Level: Beginner

Session Code:

Date: March 03

Time: 10:45 AM - 11:45 AM

Room: 227

2 text transaction files, a pivoted excel budget file, 20 Power Queries, 6 dimensional tables, and one interactive Excel dashboard = mind blowing awesomeness in under 60 minutes.  But while the analysis is important, the real value in the refresh.  Can your model pull in another 22 text files and next year's budgets in less than a minute?  This model can.
Come and see how Excel 2016 gives us the ability to not only rapidly create business intelligence, but also allows us to build engaging and interactive models that can be quickly updated and shared via Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: March 03

Time: 9:30 AM - 10:30 AM

Room: 217

Want to get more out of your SSIS development efforts? The SSIS Productivity Pack is a collection of premium SSIS components which enable an improved SSIS ETL development experience with greater potentials. These SSIS components for connectivity and productivity offer more features and bring new enhancements to SSIS to enable integration scenarios not once possible without custom scripting.

In this session we will introduce you to our collection of 150 SSIS components. We will demonstrate some of our most popular offerings including our JSON & XML components for integrating with REST APIs, Premium Derived Column with over 225 functions, and unique components such as Duplicate Detector and Diff Detector. 

In additional to performing advanced transformations you will also find codeless and feature-rich solutions for integrating with virtually any application or database system including leading enterprise applications such as Microsoft SharePoint, Dynamics 365 and more.
Speaker:

Session Type:
Sponsor Lunchtime Session (30 minutes)

Track:
Dev

Level: Beginner

Session Code:

Date: March 03

Time: 12:30 PM - 1:00 PM

Room: 219

The world of Data Warehousing and Business Intelligence has changed drastically over the last years, with the introduction of the Columnstore Indexes,
by the most Database Providers (Relational and Non-Relational). This new type of the Indexes (Columnstore) and the way of working with data (Batch Mode),
allows to improve performance of the massive workloads in 10s of times.
Microsoft has introduced the Columnstore Indexes for the relational engines in their appliance Parallel Data Warehouse, and in SQL Server 2012 the first version became available for the general database market. Since that version, a huge number of changes has been made to ensure the capacity and the performance of the Columnstore Indexes would be on the top.
In this introduction session I will show how the Columnstore Indexes achieve this performance, what are their essential internal elements and how can you get the best performance out of them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Admin

Level: Beginner

Session Code:

Date: March 03

Time: 10:45 AM - 11:45 AM

Room: 216

There are many Data Platform offerings available on Azure and new ones are introduced regularly and evolved. In this session we will cover various offering and what scenarios are most suitable for. We will also discuss whether it makes sense to make use of this services or roll your own on-premise or hybrid solutions
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code:

Date: March 03

Time: 2:30 PM - 3:30 PM

Room: 227

You may have heard the word "DevOps" and wondered whether it is just another buzzword and/or what it can do for you.

In this session I will demystify the concepts of DevOps and we will look at two aspects of DevOps - Continuous Integration & Continuous Delivery.

Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team.It also involves automating tests around the integrated work

?Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to  test, staging, and production environments.

Database migrations/changes are an area that may not be typically automated or utilise Continuous Delivery.

Through the use of a comprehensive live demo to a running database hosted in Azure the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Admin

Level: Intermedia

Session Code:

Date: March 03

Time: 10:45 AM - 11:45 AM

Room: 217

Dynamic SQL is a scripting language that helps you design flexibility into your code. It allows you to design solutions, pass parameters and allows you build a single query on values passed.  Dynamic SQL has both pros and cons to it's design, but can also be a helpful tool. This presentation will walk through the steps of building dynamic tables, aggregating data in a pivot format and give you the first steps of writing a Dynamic Query.  We will also see how to use Dynamic SQL to build multiple databases across servers, alter a single table in multiple servers and add columns to a table, all through the magic of Dynamic SQL.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Dev

Level: Beginner

Session Code:

Date: March 03

Time: 1:15 PM - 2:15 PM

Room: 220

Do you want to turn your SQL knowledge into a possible career? 
This session will show you what options are available to learn about MS SQL Server and make you more knowledgeable about the product
This session will show the many different options available to learn MS SQL Server ranging from free events thru to international conferences
It will also show how to make any conference more affordable and justify the benefits
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: March 03

Time: 9:30 AM - 10:30 AM

Room: 219

Linux has come to Microsoft! Do you want to gain the knowledge that Oracle DBAs have been using for years to manage their databases on this valuable OS?
This session is taught by a multi-platform DBA who specializes in Oracle and SQL Server with almost two decades on Unix/Linux experience.  The goal is to give you the most valuable fundamentals and commands that are important to the DBA when managing a database in a Non-Windows environment. 
We’ll learn:
1.    Linux history and concepts.
2.    Important differences between systems
3.    Crucial commands to get around 
a.    Navigating, searching and managing
b.    Monitoring, tracing and updating
c.     Editing and scripting

You’ll leave feeling more at ease with Linux and have plenty of content and links to continue the learning after the session!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Admin

Level: Intermedia

Session Code:

Date: March 03

Time: 2:30 PM - 3:30 PM

Room: 216

Which visuals from the custom visuals free gallery can be the most useful and the prettiest to look at? What are the limitations?
When would we choose to create a custom visual? What would be the business case and how should I start?
Comparing the free solutions in the PowerBI visuals Gallery. Given in the PowerBI Vancouver user group (https://www.meetup.com/Vancouver-Power-BI-User-Group/events/240243704/), YouTube (https://www.youtube.com/watch?v=aigmvBp-uX4&t=10s) the session assumes a basic understanding of PowerBI concepts. This session is targeted to business users, admins, BA's and everyone who enjoys the visual power of PowerBI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: March 03

Time: 2:30 PM - 3:30 PM

Room: 211

Are you interested in adding artificial intelligence to your apps but you are worried that you do not have the required skills within your organization? Have you heard about Microsoft Cognitive Services?

Come join us for this exciting presentation and  demo in which you will learn about Microsoft Cognitive Services and see a live demo of Dynamics CRM enhanced with Facial Recognition and Power BI.

You will not be dissappointed.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Lunchtime Session (30 minutes)

Track:
Cloud

Level: Beginner

Session Code:

Date: March 03

Time: 12:30 PM - 1:00 PM

Room: 211

Do you have a lot of legacy applications using your SQL servers? Do you still have to run older versions of SQL server, because the app vendors are slow to upgrade? Are you rightfully worried that one day, you too will suffer a malicious attack on your precious data?

This session covers the essentials on starting to harden your SQL servers so they can have a much better chance of withstanding attacks - such as the currently popular Ransom Ware wave.

We will be looking at the basic strategies of keeping your backups truly safe, how to successfully monitor for anomalies, and also how to incrementally implement basic in transit encryption (IPSEC).
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Admin

Level: Beginner

Session Code:

Date: March 03

Time: 3:45 PM - 4:45 PM

Room: 201

Are you a DBA or Developer and would like to get started with AzureML the EASY WAY?
AzureML isn't just for "data scientists"... Anyone can use it! And after this session you'll be using it too...
Disclaimer: Sadly, AzureML still can't predict what's on your girlfriend's mind. Nothing ever will.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: March 03

Time: 2:30 PM - 3:30 PM

Room: 201

A look at the intersection of hardware, software, and internet. See what it takes to bring your next workshop project to life including stories about the success and failures of creating a Smart Mirror. We will take a look into hardware including that from the hardware store and the software required to make the magic happen.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Dev

Level: Beginner

Session Code:

Date: March 03

Time: 3:45 PM - 4:45 PM

Room: 227

Azure Cosmos DB is Microsoft's globally distributed, multi-model database. With the click of a button, Azure Cosmos DB enables you to elastically and independently scale throughput and storage across any number of Azure's geographic regions. It offers throughput, latency, availability, and consistency guarantees with comprehensive service level agreements (SLAs), something no other database service can offer.

In this session, we'll get an overview of Azure Cosmos DB. And we'll see live demos of Cosmos DB in action, including its multi-model capabilities using MongoDB and Gremlin APIs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Intermedia

Session Code:

Date: March 03

Time: 9:30 AM - 10:30 AM

Room: 216

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