| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 11:00:00 | Markus Ehrenmueller-Jensen | Developers | A Game of Hierarchies: Introduction to Graph Processing with SQL |
| 11:00:00 | Johan Ludvig Brattås | Developers | Don't cross the streams, a closer look at Azure Stream Analytics |
| 12:15:00 | David Williams | ITPRO | SQL Server 2017 New Features (Not Linux support!) |
| 12:15:00 | Henn Sarv | Developers | SQL Graph Database |
| 13:45:00 | Denis Reznik | ITPRO | Hidden gems of SQL Server 2016 |
| 15:00:00 | Cathrine Wilhelmsen | Developers | Biml for Beginners: Speed Up Your SSIS Development |
| 16:15:00 | Markus Ehrenmueller-Jensen | Developers | Create Stunning Visualizations with The Help of R |
| 16:15:00 | Denis Reznik | Developers | Deadlocks. Everything you ever wanted to ask but were too shy. |
Event Date: 18-11-2017 - Session time: 11:00:00 - Track: Developers
Event Date: 18-11-2017 - Session time: 11:00:00 - Track: Developers
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.
Event Date: 18-11-2017 - Session time: 12:15:00 - Track: ITPRO
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
Event Date: 18-11-2017 - Session time: 12:15:00 - Track: Developers
How to play with graphs and how the actually implemented internally
Event Date: 18-11-2017 - Session time: 13:45:00 - Track: ITPRO
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!
Event Date: 18-11-2017 - Session time: 15:00:00 - Track: Developers
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!
Event Date: 18-11-2017 - Session time: 16:15:00 - Track: Developers
Event Date: 18-11-2017 - Session time: 16:15:00 - Track: Developers
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:
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.