| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:45:00 | Rob Douglas | Enterprise Database Administration Deployment | Hitting the SQL Server "Go Faster" Button |
| 09:45:00 | Peter Myers | BI Platform Architecture, Development Administration | Azure Machine Learning: From Design to Integration |
| 09:45:00 | Nagaraj Venkatesan | Application Database Development | SQL Server 2016 - Real Time Operational Analytics - "Real" Game changer |
| 11:00:00 | Hamish Watson | Enterprise Database Administration Deployment | TempDB: The forgotten pillar of performance tuning |
| 11:00:00 | Craig Bryden | Analytics and Visualization | An Introduction to R and R Services |
| 11:00:00 | Dandy Weyn | Enterprise Database Administration Deployment | Building HA/DR Solutions with SQL Server and Azure SQL Database |
| 13:15:00 | Manohar Punna | Enterprise Database Administration Deployment | Boost your SQL Server performance with Delayed Durability and BPE |
| 13:15:00 | Patrick Flynn | Enterprise Database Administration Deployment | Database Corruption - Advanced Recovery Techniques |
| 13:15:00 | Dandy Weyn | BI Information Delivery | Power BI - Getting It Right - A Full Walkthrough |
| 14:30:00 | Amit Arora | Enterprise Database Administration Deployment | Temporal Databases in Microsoft SQL server 2016 |
| 14:30:00 | Reza Rad | Analytics and Visualization | Cortana Intelligence Suite; Where the Magic Happens |
| 14:30:00 | Victor Isakov | Enterprise Database Administration Deployment | Query Store Overview and Architecture |
| 15:45:00 | Dan de Sousa | BI Platform Architecture, Development Administration | Automated Data Validation with SQL Server using nUnit |
| 15:45:00 | Martin Catherall | Enterprise Database Administration Deployment | Moving from Profiler to Extended Events. |
| 15:45:00 | Stefan Riedel | Application Database Development | Automated and Repeatable Test Cases for SQL Server Development. |
Event Date: 28-05-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
In this session we'll look at some of the things you can do to get the best performance out of your SQL Server workload. You'll leave with a shopping list of things to check and options to try in your environments to get the performance you are after.
Event Date: 28-05-2016 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
In this session, you will learn how an Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with Machine Learning algorithms, and then finally to the integration and embedding of predictive insights into applications.
This session has been specifically designed to describe Machine Learning fundamentals, and to help enable and inspire existing data professionals taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease by which it can be accomplished.
Event Date: 28-05-2016 - Session time: 09:45:00 - Track: Application Database Development
regular operations and day to day transactions. SQL Server 2016 has extended its analytic capablities by its enahancements on "In memory tables" and Columnstore indexes."In memory tables" combined with columnstore indexes is a boon for performing analytics on operational data with no impact to regular workload, with no delayed data, no complex ETL tasks and without a need to maintain seperate data warehouse.
The presentation would cover how "In Memory" Columnstore indexes help to perform real time operational analytics and would involve interesting demos show casing the gains using SQL Server 2016 "In Memory" and Column Store Index enhancements. Presentation would also demonstrate and compare the performances of "In Memory" columnstore indexes and disk based columnstore indexes.
Event Date: 28-05-2016 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
In this session we will go over what TempDB is used for, why it is a special and important type of database and how to tune it to enhance the performance of your overall system.
We will start with determining the best configuration of TempDB database files to use, the impact disk configuration has, which trace flags are important and what changes SQL Server 2016 will bring us. We will look at what is stored in TempDB and how both developers and DBA can optimize how TempDB is configured and used.
We will then use these best practices to optimize our instance and performance tune our queries to make the system faster.
Event Date: 28-05-2016 - Session time: 11:00:00 - Track: Analytics and Visualization
In this session I will provide an introduction to the R language as well as discuss how you go about using this inside SQL Server and other Microsoft provided tools.
Event Date: 28-05-2016 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Become the DBA of the future!
Event Date: 28-05-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 28-05-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
In this session we will walk through the techniques required to detect and repair various forms of Corruption Using a number of example corrupted database we will explore how to determine and fix corruption while avoiding some of the common mistakes. Warning: Hex Editors and DBCC Page dumps will be involved!
Event Date: 28-05-2016 - Session time: 13:15:00 - Track: BI Information Delivery
What is it? How is it done? What's in it for me?
By the end of this session you will have a full understanding of the Power BI offering and the tools used to discover data, design dashboards and visualizations , visualize them on all devices , how to optimize your data model for Power BI, and natural language query. You'll learn about sharing and collaborating, and working with multiple datasources to build live interactive dashboards and reports.
Event Date: 28-05-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
More and more organizations are storing archives of data to help them make important business decisions. Traditionally, organizations had to rely on expensive, and tedious methods to go back in time and make sense of growth, negative growth, profit, loss, etc.
Microsoft SQL Server 2016 introduces a new feature called Temporal Databases which essentially solves all the problems mentioned above.
This presentation aims to go deep into Temporal Databases (requirements, use cases, technical know-hows) and present some demo’s in order to gain specific understanding on this new feature which is being called “Time Travel”.
Event Date: 28-05-2016 - Session time: 14:30:00 - Track: Analytics and Visualization
Event Date: 28-05-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
With the release of SQL Server 2016, Microsoft has introduced a feature called Query Store that will help you capture vital query metrics that will help performance troubleshooting and regression detection. In this session we will examine Query Store, examine it's architecture, configuration and how it can be used to solve real-world performance problems.
Event Date: 28-05-2016 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 28-05-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
Profiler is now deprecated and all new work is going into extended events. This means that new monitoring events are constantly being added. These give deeper insights into performance problems withing SQL SERVER and also aid the developer / DBA in understanding the inner working of the SQL SERVER database engine. An understanding of profiler would be advantageous but is definitely not required to get some good insights from this session.
Event Date: 28-05-2016 - Session time: 15:45:00 - Track: Application Database Development