Build Schedule

Advanced Filters:
  • Track

    clear all


  • Speaker


  • Level


  • Session Type

Sessions Found: 8
Hierarchies are the bread and butter of most business applications and you find them almost everywhere:
* Product Categories
* Sales Territories
* Bill of Material
* Calendar and Time
Even when there is a big need from a business perspective, the solutions in relational databases are mostly sort of awkward. The most flexible hierarchies are usually modeled as self-referenced tables. If you want to successfully query such self-referenced hierarchies, you will need either loops or recursive Common Table Expressions. SQL Server 2017 comes now with a different approach: Graph Database. 
Join this session for a journey through best practices to transform your hierarchies into useful information. We will have fun playing around with a sample database based on G. R. R. Martin’s famous “Game of Thrones”.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Developers

Level: Beginner

Session Code:

Date: November 18

Time: 11:00 AM - 12:00 PM

Room: Word

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:

Session Type:
Regular Session (60 minutes)

Track:
Developers

Level: Beginner

Session Code:

Date: November 18

Time: 3:00 PM - 4:00 PM

Room: Word

R is the first choice for data scientists for a good reason: besides accessing and transforming data and applying statistical methods and models to it, it has a wide variety of possibilities to visualize data. As visual perception of data is the key to understanding data, this capability is crucial. This session will give you a broad overview over available packages and diagram types you can build with them on the one hand, and a deep dive into common visualizations and their possibilities on the other hand. Impress yourself and your peers with stunning visualizations which will give you insights into data you could not achieve with other tools of Microsoft’s BI stack.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Developers

Level: Beginner

Session Code:

Date: November 18

Time: 4:15 PM - 5:15 PM

Room: Excel

It's not a secret that a deadlock - it's not very good. Definition of deadlock is very simple and quite clear: This is an exceptional situation when two concurrent queries request same resources but in a different order. 

Classic deadlock can occur when two concurrent transactions are modifying data from the two tables in a different order. Unfortunately, in real life deadlocks often are more complex and unobvious. One of the rules, which I always keep in mind, sounds: "You can not design a database, in which the occurrence of deadlock is impossible". And we should deal with them. The algorithm is simple: 
1. Catch the deadlock
2. Find the root cause
3. Design and implement a solution. 
In practice, these steps can be tricky and may require different types of analysis. 

In this session, we will look at ten various deadlocks scenarios and find the root cause of the deadlocks. Then, you will see how it will be easy to get the solutions for the deadlock issue if we did the second step.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Developers

Level: Intermedia

Session Code:

Date: November 18

Time: 4:15 PM - 5:15 PM

Room: Word

Azure is ready to recieve all your event- and devicedata for storage and analysis.
But which options in the Azure IoT portfolio should you use to recieve and manage your data?

In this session I will explain the different options in the Azure IoT portfolio, take a closer look at how they work and what this means for you.
Furthermore, I will take a closer look at the Azure Stream Analytics (ASA) language. 
You will learn how to develop both simple and complex ASA queries, and how to debug. 
We will look at the possibilities, limitations and pitfalls in the Azure Stream Analytics language.
And finally look at the different input and output choices and when to use which one. This includes a look at how to build a live stream dashboard with Stream Analytics data in PowerBI.

The session is based on real world project experiences and will use real world data in the demos.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Developers

Level: Intermedia

Session Code:

Date: November 18

Time: 11:00 AM - 12:00 PM

Room: Excel

SQL Server 2016 is full of new features and improvements. Some of them are "Killer" features like Query Store, Temporal Tables, R Integration, etc., which are discussed a lot and we always can get a lot of information about them. And in the same time, SQL Server 2016 have several fantastic features and improvements, which are more hidden from our sight. 

In this session, we will learn a lot about these features and improvements. Which features? This is a secret :) Come to the session and discover them with me!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
ITPRO

Level: Intermedia

Session Code:

Date: November 18

Time: 1:45 PM - 2:45 PM

Room: Word

Graph database object in SQL server, Graph Querys. 

How to play with graphs and how the actually implemented internally
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Developers

Level: Advanced

Session Code:

Date: November 18

Time: 12:15 PM - 1:15 PM

Room: Word

This session covers the new features in SQL Server 2017 - apart from Linux support

- Using Query Store for automatic tuning of querys which have bad plans (multiple plans with regressions)

- Additional information stored in actual execution plans

- New DMVs e.g. log information, statistics histograms

- Interleaved Execution for multi-statement T-SQL TVFs

- Adapative joins for queries

- Resumable online index rebuild

- Faster non-cluster index builds on memory optimized tables.

- Additional in-memory SQL Surface Area e.g. Computed columns, JSON, CROSS APPLY,sp_spaceused,sp_rename,CASE,TOP N with TIES

- Parallel Redo for memory optimized tables, increases throughput for Always On Availability Groups

- DTC support for Always On Availability Groups

- Cluster-less Availability Groups 

- Minimum Replica Commit Availability Groups

- New CLR strict security

- Graph database queries

- Running Python scripts in SQL Server

- BULK INSERT directly fro
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
ITPRO

Level: Intermedia

Session Code:

Date: November 18

Time: 12:15 PM - 1:15 PM

Room: Excel

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