| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:15:00 | Alexander Arvidsson | Enterprise Database Administration Deployment | Unicorn safari - alleviating consolidation pains with SQL Server 2016 |
| 09:15:00 | Emanuele Zanchettin | Azure and Cloud related | Implementing and Maintaining an Azure SQL Database project |
| 09:15:00 | Stijn Wynants | BI Platform Architecture, Development Administration | Real-Time Analytics: OLAP OLTP in the mix! |
| 09:15:00 | Daniel Hutmacher | BI Platform Architecture, Development Administration | We need to go deeper: Exploring CTEs |
| 10:30:00 | Dr. Subramani Paramasivam | BI Platform Architecture, Development Administration | Think work like a Data Scientist with SQL 2016 R |
| 10:30:00 | Uwe Ricken | Professional Development | Mastering DML Operations like a master |
| 10:30:00 | Mike Byrd | Enterprise Database Administration Deployment | SS2014/2016 In-Memory Tables --Formula One Performance Unleashed??? |
| 10:30:00 | David Postlethwaite | Enterprise Database Administration Deployment | SQL 2016 New features |
| 11:45:00 | Mark Broadbent | Enterprise Database Administration Deployment | Schizophrenic High Availability with SQL and Windows 2016 |
| 11:45:00 | Mike Boswell | Azure and Cloud related | Configuring SQL Server Analysis Services for use with Azure SQL DW |
| 11:45:00 | Arne Bartels | Professional Development | Shadow prediction: SQL spatial data types and astronomy well mixed |
| 11:45:00 | Erland Sommarskog | Enterprise Database Administration Deployment | GIving Permissions through Stored Procedures |
| 14:00:00 | Asgeir Gunnarsson | BI Platform Architecture, Development Administration | Who, What, When. Monitoring usage of your MS BI stack |
| 14:00:00 | Cathrine Wilhelmsen | BI Platform Architecture, Development Administration | Tools and Tips: From Accidental to Efficient Data Warehouse Developer |
| 14:00:00 | Tillmann Eitelberg | Azure and Cloud related | Bioinformatics on Azure |
| 14:00:00 | Håkan Winther | BI Platform Architecture, Development Administration | SELECT TOP 5 Feaures FROM SQL 2016 ORDER BY Coolfactor DESC |
| 15:15:00 | Magnus Ahlkvist | Enterprise Database Administration Deployment | Statistics, an unreliable friend. |
| 15:15:00 | John Martin | BI Platform Architecture, Development Administration | Making Row Level Security and Dynamic Data Masking work for you! |
| 15:15:00 | Bjorn D. Jensen | Professional Development | Why (data) quality matters |
| 15:15:00 | Jens Vestergaard | Azure and Cloud related | Azure IoT, Windows 10 Core Raspberry PI |
| 16:30:00 | Bent Pedersen | BI Platform Architecture, Development Administration | Hybrid BI |
| 16:30:00 | Jason Horner | BI Platform Architecture, Development Administration | Dimensional Modeling Design Patterns: Beyond the Basics |
| 16:30:00 | David Söderlund | Azure and Cloud related | Streaming data: from signal to query |
| 16:30:00 | Markus Winand | Professional Development | Indexes: The neglected performance all-rounder |
Event Date: 27-08-2016 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment
This presentation will outline the classic issues with consolidation of small and medium-sized databases and explore what new pain relief SQL Server 2016 brings to the table. At the end of this session you will have a good understanding of the challenges and solutions available in SQL Server for solving consolidation workloads.
Event Date: 27-08-2016 - Session time: 09:15:00 - Track: Azure and Cloud related
Event Date: 27-08-2016 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 27-08-2016 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 27-08-2016 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration
You now have answers to these questions and thanks to Microsoft for integrating R Revolution within new SQL Server 2016. We all now have the opportunity to use R packages and see the results within SQL 2016.
In this session, you will definitely take away a breakthrough concept of Advanced R Analytics within SQL 2016 and get ready to kick your creative horse, and go beyond your imagination on how you can build advanced analytics and impress your employers/customers.
Event Date: 27-08-2016 - Session time: 10:30:00 - Track: Professional Development
Come and learn the differences of space allocation/deallocation between Clustered Indexes and Heaps in this demo oriented session. It will answer these questions:
What is the difference of data page allocation for heaps and clustered indexes? What is the amount of transaction log when you update data in a heap and/or in a clustered index? What are the differences when data are delete from a heap and clustered index? Can ETL processes be improved by usage of the right strategy for INSERTS and DELETES? What performance drawbacks have Page Splits and Forwarded Records for my application design?
Event Date: 27-08-2016 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
This session is all about when and how to apply in-memory tables in a production environment. After this session you will
Event Date: 27-08-2016 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 27-08-2016 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment
In this session we will take a look at some of the new features provided by SQL Server and Windows 2016, how existing high availability solutions can benefit from their adoption and when schizophrenic HADR can be bad idea!
Event Date: 27-08-2016 - Session time: 11:45:00 - Track: Azure and Cloud related
Session objectives: #183; Enable OLAP and tabular analytics against SQL DW #183; Provide technical configuration to get the best from SSAS when connecting to SQL DW #183; Recommendations for process and approach #183; Optimize OLAP and SQL DW for performance
Event Date: 27-08-2016 - Session time: 11:45:00 - Track: Professional Development
This session is supposed to be a more entertaining then practical exercise to combine scarsely used data types in unusual fashion, combined with a bit of astronomy and math, to calculate and visualize the relationship between sun and wind turbine purely by using SQL2016 Management Studio.
The calculation of the daily path of a shadow can be seen as a rather complex three-dimensional problem. By turning around the perspective and 'painting' the picture of turbines in the sky this can be decribed as a much simpler two-dimensional problem on a sphere. For this the geography data type will be used and in turn the richness of its functionality demonstrated. Even a sufficient visualisaton is included in SSMS 2016. Apart from 2-3 formulas everything will be handeled in SQL and no complex math is needed.
Event Date: 27-08-2016 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment
In this session you will learn why it is so and techniques how you can use to overcome this. You will also learn that the same techniques can be to permit users to perform specific actions they need to do without granting them general high-level permissions on database or server level by packaging these actions into a stored procedure. You will also learn why should should be careful with setting a database TRUSTWORTHY.
The session should be of interest both to DBAs and application developers that need to consider advanced permissions in their stored procedures.
Event Date: 27-08-2016 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration
We will talk about how to collect the data, how to build something meaningful from the data and how you can report on top of the data. We will do this for OLAP cubes and for Reporting Services Reports and we will explore ways you can further develop this for your own organization.
At the end of the session all participants will leave with all the code as well as the know how to get started with the collection of usage statistics for their Microsoft BI Solutions
Event Date: 27-08-2016 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration
You might not be able to rewrite your entire Data Warehouse or change your team's processes over night, but there are many things you can do to increase your own productivity and become a more efficient Data Warehouse developer.
In this session I will show you some of what I have learned and discovered that has made me exclaim "Oh wow! Why did I not know this yesterday!?" - including SSMS features, tools for query analysis and tuning, free tools and scripts, Biml for SSIS and even a couple of things I used to think were only useful for those scary DBAs.
Event Date: 27-08-2016 - Session time: 14:00:00 - Track: Azure and Cloud related
Event Date: 27-08-2016 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration
QueryStore, Temporal, Stretch, Row level security, Dynamic data masking
Event Date: 27-08-2016 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
Join me on some head-ache, a dive into statistics histograms, trace flags and some proof to why the terrible sentence "It depends" always applies.
Event Date: 27-08-2016 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration
These new features have the potential to really improve application security, especially in compliance scenarios. Pushing the security restrictions down into the database layer has many benefits, notably only the data needed leaves the database. But there are a number of gotchas that you need to be aware of that can really mess up performance if you get them wrong.
In this session we will look at how you can get the most out of these features and retain the performance of your system.
Event Date: 27-08-2016 - Session time: 15:15:00 - Track: Professional Development
Examples of data quality challenges and their impact. Having correct data is very important to make correct decisions. Data quality goes hand in hand with proper data modelling. Knowledge about use cases and workload is important input to your data modelling. Different kinds of compression can be relevant depending on your usage scenario. Storing data economically also means that data should be easy to use. Having focus on deadlines whithout having (data) quality in mind will hit you hard at an later point in time.
Delivering good query performance and reports in time is important to business users, but how to measure it from their perspective?
And obviously the features you provide should work. This is where you benefit from unit testing. (Demo of unit testing with SSDT.)
Event Date: 27-08-2016 - Session time: 15:15:00 - Track: Azure and Cloud related
Event Date: 27-08-2016 - Session time: 16:30:00 - Track: BI Platform Architecture, Development Administration
When working with a hybrid platform your organisation will be able to select strategy and features based on the highest ROI. During this session I will go through three different aspects of Hybrid BI which is infrastructure, data-storage and reporting.
As part of this i will go through the advantages and disadvantages of each area to supply you with the information you need to choose the right direction for your platform.
Event Date: 27-08-2016 - Session time: 16:30:00 - Track: BI Platform Architecture, Development Administration
In this session, we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, Including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to help make this an interactive and engaging session.
Event Date: 27-08-2016 - Session time: 16:30:00 - Track: Azure and Cloud related
We will use example data coming from a mock-up parking garage and send it to SQL Server leveraging in-memory objects. We will also let our data streams leverage Azure Stream Analytics and Azure Machine Learning.
Event Date: 27-08-2016 - Session time: 16:30:00 - Track: Professional Development