| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 10:45:00 | Alex Whittles | Cloud (Application Development Deployment) | Introduction to U-SQL and Data Lake [EN] |
| 10:45:00 | Niko Neugebauer | Development | Worst Practices Less Known Limitations for Columnstore Indexes [DE/EN] |
| 10:45:00 | Frank Geisler | BI (Advanced Analysis, Visualization, Information Delivery) | Power BI Server - On Premises [DE / EN] |
| 10:45:00 | Karol Papaj | Administration (Platform, Architecture) | SQL Server Availability Groups Configuration, Maintenance and Troubleshooting [EN] |
| 10:45:00 | Michael Saß | Administration (Platform, Architecture) | SQL Server auf Linux: Benchmarking und Tuning [DE] |
| 10:45:00 | Markus Ehrenmueller-Jensen | Lightning Talks | Lightning Talks (5 speakers, 5 talks, 10min each) [EN] |
| 13:00:00 | Johan Ludvig Brattås | Cloud (Application Development Deployment) | Implementing a hybrid data warehouse [EN] |
| 13:00:00 | Björn Peters | Cloud (Application Development Deployment) | Einstieg in Azure SQL Databases und Powershell Automation [DE] |
| 13:00:00 | André Melancia | Administration (Platform, Architecture) | Hacking SQL Server [EN] |
| 13:00:00 | Oliver Engels | BI (Advanced Analysis, Visualization, Information Delivery) | Champions League Final Battle - Tableau vs. Power BI [EN] |
| 13:00:00 | Michael Roedeske | Administration (Platform, Architecture) | SQL Query Performance Monitoring und Analyse [DE] |
| 14:15:00 | Uwe Ricken | Administration (Platform, Architecture) | Advanced insides into System Versioned Temporal Tables [DE/EN] |
| 14:15:00 | Ben Weissman | BI (Advanced Analysis, Visualization, Information Delivery) | Biml: I got the basics - what's next? [DE/EN] |
| 14:15:00 | Thomas Grohser | Development | Shaving of Microseconds [DE / EN] |
| 14:15:00 | Gabi Münster | BI (Advanced Analysis, Visualization, Information Delivery) | Azure Analysis Services - An important step for BI in the cloud? [DE / EN] |
| 14:15:00 | Sergiy Lunyakin | Cloud (Application Development Deployment) | Azure SQL DW: Optimization technics to maximize performance [EN] |
| 14:15:00 | Tomaž Kaštrun | BI (Advanced Analysis, Visualization, Information Delivery) | Data Science for beginners [EN] |
| 15:30:00 | Kasper de Jonge | BI (Advanced Analysis, Visualization, Information Delivery) | Understanding the Power BI data model [EN] |
| 15:30:00 | Mark Broadbent | Development | Lockless in Seattle: Using In-Memory OLTP Transaction Processing [EN] |
| 15:30:00 | Denis Reznik | Administration (Platform, Architecture) | Deadlocks. Everything you ever wanted to ask but were too shy. [EN] |
| 15:30:00 | Dean Savović | Administration (Platform, Architecture) | Cardinality Estimator with SQL Server 2014 and 2016 [EN] |
| 15:30:00 | Alex Yates | Development | Adopting Database Lifecycle Management (DLM) at a large Viennese software house [EN] |
| 15:30:00 | Alexander Klein | Cloud (Application Development Deployment) | Build your next BI solution in azure [DE/EN] |
| 16:45:00 | Dejan Sarka | BI (Advanced Analysis, Visualization, Information Delivery) | Comparing Predictive Mining Models from R, Python, SSAS, and Azure ML [EN] |
| 16:45:00 | Rainer Stropek | Cloud (Application Development Deployment) | DB Application Monitoring with Azure Application Insights [DE / EN] |
| 16:45:00 | William Durkin | Administration (Platform, Architecture) | PowerShell for the DBA: Why I love my inner pig-dog [DE/EN] |
| 16:45:00 | Gianluca Sartori | Administration (Platform, Architecture) | Benchmarking like a Pro [EN] |
| 16:45:00 | Tillmann Eitelberg | Development | Industry 4.0 in a box [DE] |
| 16:45:00 | Reza Rad | BI (Advanced Analysis, Visualization, Information Delivery) | M and Power Query Beyond Limits [EN] |
Event Date: 19-01-2018 - Session time: 10:45:00 - Track: Cloud (Application Development Deployment)
Event Date: 19-01-2018 - Session time: 10:45:00 - Track: Development
Setting the wrong expectations (it won’t run 100 times faster on EVERY query), selecting the wrong architecture (partition by 100s of rows instead of millions), using and aggregating by the large Strings in the fact tables – this list is actually quite large.
What about some of the less known limitations for building Columnstore Indexes? The ones that will bite you suddenly in the middle of the project – when you do not expect it at all?
Let me show you how to achieve those painful mistakes and you will surely know how to avoid them :)
Event Date: 19-01-2018 - Session time: 10:45:00 - Track: BI (Advanced Analysis, Visualization, Information Delivery)
Event Date: 19-01-2018 - Session time: 10:45:00 - Track: Administration (Platform, Architecture)
This session is useful for DBA’s that are using or considering Availability Groups for high availability in SQL Server 2016/2017.
Event Date: 19-01-2018 - Session time: 10:45:00 - Track: Administration (Platform, Architecture)
Event Date: 19-01-2018 - Session time: 10:45:00 - Track: Lightning Talks
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
Event Date: 19-01-2018 - Session time: 13:00:00 - Track: Cloud (Application Development Deployment)
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.
Event Date: 19-01-2018 - Session time: 13:00:00 - Track: Cloud (Application Development Deployment)
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.
Event Date: 19-01-2018 - Session time: 13:00:00 - Track: Administration (Platform, Architecture)
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.
Event Date: 19-01-2018 - Session time: 13:00:00 - Track: BI (Advanced Analysis, Visualization, Information Delivery)
Event Date: 19-01-2018 - Session time: 13:00:00 - Track: Administration (Platform, Architecture)
Der Vortrag gibt Antworten auf die Fragen: Wie identifiziert man schnell unter abertausenden SQL-Abfragen die Wesentlichen hinsichtlich CPU, logischem bzw. physischem IO zu einem spezifischen Zeitpunkt oder über Zeit? Wie lassen sich verändernde Ausführungsplänen auffinden und über Zeit historisch analysieren? Welche Abfragen wurden heute erstmalig ausgeführt bzw. sind für eine Lastspitze zu einer bestimmten Zeit verantwortlich? Welche Abfragen greifen auf eine bestimmte Tabelle zu? Wie kann ich in Sekunden Lastprofile historisch vergleichen und visualisieren? Und wie geht das überhaupt bereits ab SQL Server Version 2005 ohne den Query Store, Instanzweit und Datenbankübergreifend und ohne T-SQL in einer intuitiven grafischen Oberfläche?
Event Date: 19-01-2018 - Session time: 14:15:00 - Track: Administration (Platform, Architecture)
This session takes you behind the basics of Temporal Tables and answers - after a short introduction - the following questions:
You are interested in the answers to all the above questions (and more). This session will answer EVERY question about Temporal Tables.
Event Date: 19-01-2018 - Session time: 14:15:00 - Track: BI (Advanced Analysis, Visualization, Information Delivery)
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.
Event Date: 19-01-2018 - Session time: 14:15:00 - Track: Development
Event Date: 19-01-2018 - Session time: 14:15:00 - Track: BI (Advanced Analysis, Visualization, Information Delivery)
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.
Event Date: 19-01-2018 - Session time: 14:15:00 - Track: Cloud (Application Development Deployment)
Event Date: 19-01-2018 - Session time: 14:15:00 - Track: BI (Advanced Analysis, Visualization, Information Delivery)
We will focus on answering 5 simple questions.
Session we will look into technologies that can be tackled using SQL Server 2016 and ML Azure.
Event Date: 19-01-2018 - Session time: 15:30:00 - Track: BI (Advanced Analysis, Visualization, Information Delivery)
Event Date: 19-01-2018 - Session time: 15:30:00 - Track: Development
In this session, we will understand how In-Memory OLTP architecture is implemented and how its mechanics function. We will learn what transactional bad dependencies and other considerations are introduced by its use and what capabilities are provided by SQL Server 2016.
Event Date: 19-01-2018 - Session time: 15:30:00 - Track: Administration (Platform, Architecture)
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 secon
Event Date: 19-01-2018 - Session time: 15:30:00 - Track: Administration (Platform, Architecture)
Event Date: 19-01-2018 - Session time: 15:30:00 - Track: Development
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
Event Date: 19-01-2018 - Session time: 15:30:00 - Track: Cloud (Application Development Deployment)
Event Date: 19-01-2018 - Session time: 16:45:00 - Track: BI (Advanced Analysis, Visualization, Information Delivery)
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.
Event Date: 19-01-2018 - Session time: 16:45:00 - Track: Cloud (Application Development Deployment)
Event Date: 19-01-2018 - Session time: 16:45:00 - Track: Administration (Platform, Architecture)
In this session we will learn to embrace the power in PowerShell to allow us to sit back and relax..... or rather focus on the real work of designing better, faster systems instead of fighting for short time slots when we can do actual work.
Along the way we will see that we can benefit from the wide world of PowerShell expertise and avoid re-inventing the wheel, again!
Event Date: 19-01-2018 - Session time: 16:45:00 - Track: Administration (Platform, Architecture)
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.
Event Date: 19-01-2018 - Session time: 16:45:00 - Track: Development
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.
Event Date: 19-01-2018 - Session time: 16:45:00 - Track: BI (Advanced Analysis, Visualization, Information Delivery)