Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type


Sessions Found: 30
At Greentube business is booming. However, for the last few years they have faced increasing problems scaling their product and headcount.

Like many orgs, Greentube has a complicated SQL Server backend which supports many apps.

In 2016, despite best efforts, the database was not in source control, deployments were manual and the production database schemas were out of sync. The core database team was struggling to keep up with the business’s rapid growth because so much time was wasted firefighting unexpected issues.

The business recognised that the database was a bottleneck on the company’s growth. And that was an expensive problem.

Come and learn from Manoj Lona, the DB Team Lead at Greentube, and Alex Yates, a DLM Consultant from DLM Consultants, about how last year they made the necessary technical and organisational changes that today enable GreenTube to deploy their database at the click of a button - allowing them to scale their product and headcount to meet business
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code:

Date: January 19

Time: 3:30 PM - 4:30 PM

Room: Trivadis

SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time. 

This session takes you behind the basics of Temporal Tables and answers - after a short introduction - the following questions:
- How to handle the change of NULL constraints?
- Can Temporal Tables be renamed and what happens to the System Versioned table?
- What will happen if you change meta data (data length, data type, ...)?
- What happens if you drop a column or add another column to the Temporal Table?
- what about security for the  system versioned table?
- what about calculated columns in the temporal table?
- ...

You are interested in the answers to all the above questions (and more). This session will answer EVERY question about Temporal Tables.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration (Platform, Architecture)

Level: Intermedia

Session Code:

Date: January 19

Time: 2:15 PM - 3:15 PM

Room: Solysion

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 (Advanced Analysis, Visualization, Information Delivery)

Level: Beginner

Session Code:

Date: January 19

Time: 2:15 PM - 3:15 PM

Room: DBPLUS

Azure SQL DW is powerful MPP cluster for processing a big amount of structured data. But, it still requires optimization to maximize performance and optimize resource usage. Some technics almost similar to what we do with our regular SQL Server, some of them not due to MPP architecture. In this session, I will cover next topics:
 - how to minimize the time of data loading
 - how to choose a right distribution type
 - data movement minimization
 - how scaling and resource class could help to improve data processing performance
 - maximize Column Store index performance
 - update statistics
 - partitioning strategy
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud (Application Development & Deployment)

Level: Intermedia

Session Code:

Date: January 19

Time: 2:15 PM - 3:15 PM

Room: SolidQ

Exciting times ahead! You bought a license for SQL Server 2016 and you are going to upgrade to the new shiny version of SQL Server on a beefy new machine!
Fantastic! Except that you have no idea how your application will work on the new version. There’s a new cardinality estimator in 2016: how will it affect performance? The new features in In-Memory OLTP and Columnstore Indexes look really promising, but how will your workload take advantage of these features?
The best way to know for sure is to conduct a benchmark and compare it to your current system.
In this demo-intensive session you will discover how to capture a meaningful workload in production and how to replay it against your test system. You will also learn which performance metrics to capture and compare, and which tools can help you in the task.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration (Platform, Architecture)

Level: Intermedia

Session Code:

Date: January 19

Time: 4:45 PM - 5:45 PM

Room: Quest

So you have made first contact with Biml and are excited? Good!

You're wondering, if Biml can do more than just transfer data from SQL table to another? Great!

Because Biml does so much more than just simple SSIS packages. We'll explore the potential on how to improve your existing packages using BimlScript and LINQ.
Topics covered, amongst others, are derived columns, incremental changes and how to handle flat files. 

You'll leave with sample code and hopefully a couple of ideas on how to bring your Biml development to the next level.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI (Advanced Analysis, Visualization, Information Delivery)

Level: Intermedia

Session Code:

Date: January 19

Time: 2:15 PM - 3:15 PM

Room: Trivadis

Azure bietet eine Vielzahl von Diensten und Services an, die man zu einer BI Solution in der Cloud zusammenstellen kann. Welche Möglichkeiten bietet aktuell Azure um eine zeitgemäße BI Architektur zu erstellen? Die Komponenten, die derzeit angeboten werden reichen von Azure SQL DB und SQL DWH über Data Factory, Stream Analytics, Logic App bis hin zu Analysis Services und Power BI um nur ein paar zu nennen. Das ist eine sehr gute Toolbox, mit der man sehr schnell die ersten Erfolge erreichen kann. Schritt für Schritt wird hier erklärt wie man das klassische ETL in der Cloud erstellt und die Ergebnisse in Power BI analysieren kann.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud (Application Development & Deployment)

Level: Beginner

Session Code:

Date: January 19

Time: 3:30 PM - 4:30 PM

Room: SolidQ

Cardinality Estimator had a major upgrade in SQL Server 2014 version and 2016. After a few introductory words, I will speak about model assumptions of Cardinality Estimator, calculation direction, model selection of Cardinality Estimator and improvements in SQL Server versions 2014 and 2016. I will also have a few demos where I will demonstrate how to optimally use the new features.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration (Platform, Architecture)

Level: Intermedia

Session Code:

Date: January 19

Time: 3:30 PM - 4:30 PM

Room: Solysion

If you look into the Gardner Quadrant you will see two major players in Self-Service BI: Tableau and Power BI.  Of course there is a lot in the press, but hey, here are two guys one Microsoft MVP and a Tableau Expert and these to will hold a final of these massive competitors battling on a real world exercise. If you are interested to see the differences in playing skills, tackling, pressing and how the goal keepers handle penalties. have a look. After that session you are prepared and know whether a Tableau or Power BI come in and says: I can do this in my tool better... and we can tell you: It will be fun as well to see the battle.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI (Advanced Analysis, Visualization, Information Delivery)

Level: Intermedia

Session Code:

Date: January 19

Time: 1:00 PM - 2:00 PM

Room: Idera

There is a lot of overlapping in Microsoft BI suite. For advanced analytics, like data mining, you can use SQL Server Analysis Services (SSAS), or R, or Python, or Azure ML. The question arises which tool to use. The answer is simple, through another question. Why not all of them? 
In data mining, you typically create multiple predictive models for the same task, and then evaluate them to select the best one. So why wouldn’t you even use different tools for different models? You will learn how to evaluate the predictive models. Then you will see how to bring all of the mining models together and compare them no matter of the source they come from. You will see how you can use SQL Server Integration Services, Excel, and other tools for this task.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI (Advanced Analysis, Visualization, Information Delivery)

Level: Advanced

Session Code:

Date: January 19

Time: 4:45 PM - 5:45 PM

Room: Solysion

Data science can be hard to grasp, complex and big, but making data science easy to understand and bringing it closer to all who want to tackle this new emerging field is an important task in world of data.  Exploring, extracting and finding hidden gems  from data using statistical and mathematical methods, computer science and several different technologies is essentially what data science is doing. In practice this means, data science is an iterative process of harvesting data, managing and cleaning the data,  performing analysis and and at the end interpreting, visualizing and using information  that will bring insights to end-user, business people and making decisions much easier.
We will focus on answering 5 simple questions. 

1) is this weird? 
2) is A better than B, respectively? 
3) how much / many of this is needed? 
4) this belong to group A? 
5) what is next?

Session we will look into technologies that can be tackled using SQL Server 2016 and ML Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI (Advanced Analysis, Visualization, Information Delivery)

Level: Beginner

Session Code:

Date: January 19

Time: 2:15 PM - 3:15 PM

Room: Idera

Modern cloud-based applications consists of many different services, databases, apps, websites, etc. Application monitoring is crucial because without it, it nearly impossible to quickly find the root cause of problems. Microsoft offers the PaaS offering Application Insights for this use case. In this session, long-time Azure MVP Rainer Stropek introduces Application Insights. He will focus on those features that are relevant for data-driven applications. You will see dependency tracking for SQL Server, performance monitoring, App Insights Analytics, Power BI integration and many other features.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud (Application Development & Deployment)

Level: Advanced

Session Code:

Date: January 19

Time: 4:45 PM - 5:45 PM

Room: Trivadis

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 secon
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration (Platform, Architecture)

Level: Advanced

Session Code:

Date: January 19

Time: 3:30 PM - 4:30 PM

Room: Quest

Einstieg in das Thema SQL Datenbanken in der Microsoft Cloud, von A wie Allgemeines, nach B wie Backup, dann über P wie Powershell nach R wie Restore. 
Ich gebe einen Überblick, welche Möglichkeiten es gibt eine Azure SQL Database zur Verfügung zu stellen, wie höhere Anforderungen realisiert werden können, ebenso gehe ich auf das Thema Kostenersparnis ein. 

Wir werden uns verschiedene Deployments anschauen, auf das Thema Backup und auf die unterschiedlichen betrieblichen Leistungsanforderungen eingehen.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud (Application Development & Deployment)

Level: Beginner

Session Code:

Date: January 19

Time: 1:00 PM - 2:00 PM

Room: Trivadis

In this session you will learn about a typical challenge in legal information management: how to determine whether two (or more) offers to sell, or purchase, products (or services) represent the basis of a legally binding contract.
You will learn which techniques are used to correlate the data in terms of the range of objects, their quantities, their qualitative properties, while also taking into account the temporal properties of the offers.
You will also learn how clustered columnstore indexes can be used to improve the efficiency of the queries needed to solve this important legal problem.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Advanced

Session Code:

Date: January 19

Time: 1:00 PM - 2:00 PM

Room: Solysion

How easy is it to hack a SQL Server?
In this session we'll see examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace.
We'll start by gaining access to a SQL Server (using some "creative" ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), hacking DDM, RLS, and more. 
More important, we'll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016.
This is a demo-driven session, suited for DBAs, developers and security consultants.
Disclaimer: No actual crimes will be committed. Please do not send agents to my house again.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration (Platform, Architecture)

Level: Intermedia

Session Code:

Date: January 19

Time: 1:00 PM - 2:00 PM

Room: Quest

The last couple of years have seen the emergency of "Big Data", "Cloud" and "Internet of Things".  Subsequently, Gartner at the 2016 Gartner Summit in Barcelona declared the Enterprise data warehouse (EDW) as dead. 
Which of course is silly. Sensible companies don't just throw money out of the window.
But they need to adapt and change when new opportunities arrive.
Enter the hybrid data warehouse. Combining the power of big data and cloud with your trusty EDW.

This session will take a look at a few different approaches to a hybrid data warehouse, with components such as SQLServer 2016, Azure Data Lake, HDInsight, Azure Analysis Services, Azure SQL Data warehouse and Polybase, with some scenarios where the approaches might become
 relevant. And some pitfalls you need to know about along the way.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud (Application Development & Deployment)

Level: Intermedia

Session Code:

Date: January 19

Time: 1:00 PM - 2:00 PM

Room: SolidQ

IoT is often associated with developer boards such as the Raspberry PI or Arduino. However, IoT has not only played an important role under the slogan "Industry 4.0", many industry companies are using IoT in their production lines since years.

To show the potential of the Azure IoT in connection with industry components, we have took a conveyor belt, a sorting unit and sensor technologies built-in in a small flightcase. All these industry components are communicating directly to an Azure IoT Hub. 

See how we can analyze the generated data with Stream Analytics and building Power BI dashbaords with streaming data. We will also show how we can interact with the components via cloud 2 device messages if the analysis shows errors or disfunctionalities and how Cortana Analytics can help minimize errors.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code:

Date: January 19

Time: 4:45 PM - 5:45 PM

Room: SolidQ

U-SQL is the new kid on the SQL language block. In this session we'll look at the what, where, why and how of the language. Is it a query language? Is it a data transformation language? Will it replace T-SQL? Should you learn it? Where is it? What is Data Lake? We'll discuss all this and more.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud (Application Development & Deployment)

Level: Beginner

Session Code:

Date: January 19

Time: 10:45 AM - 11:45 AM

Room: Trivadis

Alexander Arvidsson - Speak Your Hands
Asgeir Gunnarsson - Analysis Services Documentation Solution
Erik Monchen - Sharing in Power BI 
Marcos Freccia - My 5 favorite Powershell commands
Jan Mulkens - Data Science, easy until it's not
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (10 minutes) (10 minutes)

Track:
Lightning Talks

Level: Intermedia

Session Code:

Date: January 19

Time: 10:45 AM - 10:55 AM

Room: Solysion

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