Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type


Sessions Found: 30
Microsoft VSTS offers cloud based portal and services to fully automate your builds and release processes.

While SSIS is not officially supported we will walk you through the process of setting up VSTS for automated build of your BI projects, leading onto automated release and deployment.

Topics include:
-	VSTS overview
-	Deploying Agents
-	Automating Build
-	Automating Release
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 06

Time: 3:15 PM - 4:15 PM

Room: CUST 0.01M

A lot of new functionality and features have been introduced with Azure Data Factory. Using regular SSIS packages you have great flexibility using BIML.

As part of this session we will be looking into the automation functionality for ADFv2 and how you get started with data extraction and best practices using PowerShell for automation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 06

Time: 3:15 PM - 4:15 PM

Room: CUST 1.11M

Microsoft Cognitive Services (formerly Project Oxford) are a set of APIs, SDKs, and services that developers can use to make their applications smarter, more engaging, and more discoverable. Cognitive Services extend Microsoft's KI platform. 

This is a large playground for young and old. Here you can try out to your heart's content what will be in use tomorrow. With the various building blocks such as Bot Framework, Emotion, Face, Text Analytics or Recommendations, to name but a few, impressive applications can be assembled in a short time.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 06

Time: 4:30 PM - 5:30 PM

Room: CUST 1.02M

In this session let us find about (technical overview)what are the foundations and design goals of Azure CosmosDB.  There are many benefits which will fit for web, mobile and globally distributed applications that need elastic scaling, high availability with a predictable performance which can elevate ease of development with NoSQL capabilities that every developer/architect/DBA should know about.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: October 06

Time: 8:30 AM - 9:30 AM

Room: CUST 1.06M

In many database applications we first log data and then, a few hours or days later, we start analyzing it. But in a world that's moving faster and faster, we sometimes need to analyze what is happening NOW.
Azure Stream Analytics allows you to analyze streams of data while they arrive. In this session you will see how to get started with Stream Analytics. We build and use a real-time application in this session. First we get started with Azure event hubs to collect data, then dive deeper into the temporal queries for analyzing the data.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: October 06

Time: 3:15 PM - 4:15 PM

Room: CUST 1.06M

In order to ascertain the abilities of cloud computing platform, let us overview what is available & offered on Microsoft Azure.

Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: October 06

Time: 10:00 AM - 11:00 AM

Room: CUST 1.02M

Authoring SSAS tabular models using the standard tools (SSDT) can be a pain when working with large models. Tabular Editor is an open-source alternative, that relies only on the Model.bim metadata and the Tabular Object Model (TOM). Compared to SSDT, making changes to measures, calculated columns, display folders, etc. is lightning fast, and the UI provides a "what-you-see-is-what-you-get" experience, making it much easier to manage and author large models. In this session, we will briefly go over the basic features, and then dive into the productivity enhancing features of Tabular Editor, such as scripting, custom actions, the Best Practice Analyzer, command-line build and deployment, and much more. You will never want to use Visual Studio for Tabular Modelling ever again! Attendees will also have the opportunity to ask questions or provide feedback about the tool.
Speaker:

Accompanying Materials:

Session Type:
Extended Session (90 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: October 06

Time: 10:00 AM - 11:30 AM

Room: CUST 1.06M

Azure offers a variety of services that can be combined to form a BI solution in the cloud. What options does Azure currently offer to create a modern BI architecture? The components currently available range from Azure SQL DB and SQL DWH to Data Factory, Stream Analytics, Logic App, Analysis Services and Power BI to name a few. This is a very good toolbox, with which you can achieve your first successes very quickly. Step by step you will learn how to create the classic ETL in the cloud and analyze the results in Power BI.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 06

Time: 3:15 PM - 4:15 PM

Room: CUST 1.02M

Based on real life scenarios, in this audience interactive session we will go through some scenarios you might encounter whilst dealing with SQL Server databases and you will be provided with some options about what to do. Members of the audience will then select from these options what to do and we will follow that path and see what the outcome is from there.

Each selection will have a different outcome, and along the way you will probably learn some new things.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 06

Time: 8:30 AM - 9:30 AM

Room: CUST 1.02M

Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? What information would you use to answer these questions? If only you knew what performance metrics to collect and had them for your existing instances to answer these questions. 

In this session, we will be combining three open source tools - Telegraf, InfluxDB, and Grafana - into an inexpensive system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances. We will learn what metrics to collect, how to use the tools to collect performance metrics and then we'll put it all together in an interactive dashboard for easy visualization.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 06

Time: 3:15 PM - 4:15 PM

Room: CUST 1.01M

If you are releasing new reports, SSAS cubes or SSIS packages on a regular basis, you've probably offered up your share of blood, toil, tears and sweat on getting them delivered into production in working condition.
Continuous Delivery is a way to bridge the gap between developers and IT professionals and for that we need to address the both the toolchain to support the practices as well as the mindset on the team. Microsoft offers a set of tools that'll help you on your journey towards the end goal: Maximize predictability, efficiency, security and maintainability of operational processes.

We will in detail be looking at:

Agile Development Frame of Mind
        The Path Ahead (direction)
	Visual Studio Online (tool)
	Feature/User Story/Work Item (concept)
Team Services
	Code Branching (concept)
	Build Agents (tool)
        Releases (tool)
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 06

Time: 12:30 PM - 1:30 PM

Room: CUST 1.01M

Docker has taken the world of IT by storm and looks to be ushering in the greatest platform paradigm shift since virtualisation and the public cloud. The transient nature of Docker containers makes them the perfect fit for spinning up and then tearing down SQL Server instances as part of continuous integration pipelines. Jenkins is the most popular build automation engine in the open source community, it has phenomenal plugin support, it is used by the likes of Netflix and eBay and excels in its ability to handle build pipelines as code. In this session you will learn how a simple build pipeline that takes a SQL Server data tools project checked out from source code control, built into a DACPAC which is then deployed to a SQL Server instance can be extended to use containers, multi-branch build pipelines, tSQt testing and much much more.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 06

Time: 12:30 PM - 1:30 PM

Room: CUST 1.06M

In this session I will be demonstrating how easy Power BI lets you ingest almost anything; Like
complex multi-file scenarios and tricks to get your data mashed up. While at entry level we would be
spending most time in the GUI we will be spending most of the time in this session in the Advanced
Editor.
In detail we will be looking at these topics:
Variable number of columns in multiple files for same source
Multiple File Formats (think historical changes in format)
Binding Multiple Imports into a single table
Error handling
Dynamic File Format Handling
General Tips ’n Tricks for M

Attending this session, you'll learn the basics of Power BI Desktop, get to see M code in action, as well as learn some neat tricks to get your daily chores done more efficiently.
Additionally, I will demonstrate how to deploy your home-grown model into Azure Analysis Services
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: October 06

Time: 1:45 PM - 2:45 PM

Room: CUST 1.11M

In this session, you will learn how to detect and avoid common problems related to database corruption. There will be a description of the data structures in SQL Server and how it can affect the availability of SQL Server during corruption. On the session, there will be not only theoretical knowledge but many real life examples with demos.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 06

Time: 4:30 PM - 5:30 PM

Room: CUST 1.01M

Get and overview of Dataflows and how it integrates data lake and ETL technology directly into Power BI to enable anyone with Power Query skills. 

Before diving into details we will go through the architecture and demonstrate the bigger picture for Dataflows in Power BI.

We will go through how you can create, customize and manage data within the Power BI experience in a simpler way. Part of this will also be to go through Common Data Models which contains the business entities across your organisation.

This will help your organisation simplifying modeling and is intended to prevent multiple definition for the same data.
Speaker:

Accompanying Materials:

Session Type:
Extended Session (90 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: October 06

Time: 10:00 AM - 11:30 AM

Room: CUST 1.01M

CosmosDB service is a NoSQL is a globally distributed, multi-model database database service designed for scalable and high performance modern applications. CosmosDB is delivered as a fully managed service with an enterprise grade SLA. It supports querying of documents using a familiar SQL over hierarchical JSON documents. Azure Cosmos DB is a superset of the DocumentDB service. It allows you to store and query noSQL data, regardless of schema.
In this presentation, you will learn:
•	How to get started with DocumentDB you provision a new database account. 
•	How to index documents 
•	How to create applications using CosmosDb (using REST API or programming libraries for several popular language) 
•	Best practices designing applications with CosmosDB
•	Best practices creating queries.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 06

Time: 10:00 AM - 11:00 AM

Room: CUST 1.11M

Scaling from a few connected devices while developing a proof of concept to thousands or millions 
of devices deployed in the field is not trivial. 
In the IoT device life cycle, provisioning is key for scaling securely. 
This talk is about main concepts and implementation when we need to provision IoT devices for modern Azure 
IoT Solutions.
During this session, you'll get a sneak peek into how Azure IoT enables seamless, 
zero-touch registration of devices to IoT Hub with security that begins at the device and ends with our cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Advanced

Session Code:

Date: October 06

Time: 1:45 PM - 2:45 PM

Room: CUST 1.06M

You might have heard "don't use cursors, they are slow!". In this presentation, you will learn what actually means: you should normally write set-based statements instead and I will explain why they generally are faster than writing your own loops. But I will also look at situations where using a loop for one reason or another is preferrable, and you will learn that the best way to run a loop in most cases is exactly a cursor, provided that you implement it properly. The presenation also gives some tips how you can troubleshoot performance problems with loops.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 06

Time: 1:45 PM - 2:45 PM

Room: CUST 1.01M

How do you setup and build a complete Microsoft BI solution with only Azure Services? Lessons learned from a project with eleven different source systems in the one end and 12.000 users in seven countries in the other end. 

Extracting, transforming and loading with the help from Functions, Data Factory, Data Lake Store, Polybase, SQL Data Warehouse, SQL Database, Automation Runbooks, Analysis Services and Power BI Embedded.

A look into the overall architecture and the different components and how they work together.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 06

Time: 4:30 PM - 5:30 PM

Room: CUST 1.06M

When I read that Microsoft have added graph data to SQL Server 2017 I was intrigued as to what graph data is so I started doing some research.
This presentation is the culmination of my investigations. 
If you design complex OLTP relational databases or have data that doesn't fit the rigid hierarchy of a relational database then this talk is for you. 
You may be in for a surprise!

Some of the questions we will look at:
What is Graph Data?
Who uses it?
What is it used for?
How does it compare to traditional relational database design?
What other companies support graph databases?
How does it work in SQL 2017?
Is there a new language to learn?
What is the so-called Kevin Bacon problem?

And finally.
Will it replace traditional relational database design within the next 10 years?
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 06

Time: 4:30 PM - 5:30 PM

Room: CUST 1.11M

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