| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Martin Cairney | Other | Keynote Session |
| 10:30:00 | Martin Catherall | BI Platform Architecture, Development Administration | A Lap Around Columnstore. |
| 10:30:00 | Allan Hirt | Enterprise Database Administration Deployment | Top 10 Clustering Dos and Don'ts |
| 10:30:00 | Victor Isakov | Strategy and Architecture | SQL Server 2016: A Monster of a Release |
| 10:30:00 | Michael van Halderen | Enterprise Database Administration Deployment | Azure for the SQL Server DBA: What we need to know, and how to get started |
| 10:30:00 | Peter Myers | Advanced Analysis Techniques | Azure Machine Learning: From Design to Integration |
| 10:30:00 | Rob Farley | BI Platform Architecture, Development Administration | MPP - What you should know about Massively Parallel Processing |
| 10:30:00 | Kelly Broekstra | Professional Development | Getting started with Agile Business Intelligence |
| 11:40:00 | Martin Cairney | Cloud Application Development Deployment | Hybrid Solutions with SQL Server 2016 |
| 11:40:00 | Dan de Sousa | BI Platform Architecture, Development Administration | Automated Test Driven Development with SQL Server using nUnit |
| 11:40:00 | Greg Low | Other | I didn't know SSMS could do that |
| 11:40:00 | Reza Rad | BI Information Delivery | Power BI Rises; Wonderful Things You Can Do |
| 11:40:00 | Kristina Rumpff | Enterprise Database Administration Deployment | Securing Data on your terms |
| 12:50:00 | Martin Catherall | Other | Interesting Facts on SQL Server Use |
| 14:00:00 | Rolf Tesmer | Enterprise Database Administration Deployment | Practical Partitioning |
| 14:00:00 | Vijayakumar Thurupathan | Cloud Application Development Deployment | Protecting your data in the Cloud |
| 14:00:00 | Vikas Rajput | BI Platform Architecture, Development Administration | Data Warehouse in Azure - Intro and Demo |
| 14:00:00 | Melody Zacharias | Application Database Development | Distributed Replay: Testing With Your Data, Your Way! |
| 14:00:00 | Johnley John | Information Delivery | An overview of SQL Openquery |
| 14:00:00 | Grant Paisley | Advanced Analysis Techniques | Build an Activity-Based Costing System with Power BI |
| 14:00:00 | Rob Douglas | Application Database Development | Indexing for Optimal Performance |
| 14:20:00 | Hamish Watson | Enterprise Database Administration Deployment | Killing FearOps with a culture of DevOPS |
| 14:40:00 | Manohar Punna | Enterprise Database Administration Deployment | Lightning talk - Live Query Statistics |
| 15:30:00 | Craig Bryden | BI Platform Architecture, Development Administration | Introduction to Biml BimlScript |
| 15:30:00 | Warwick Rudd | Enterprise Database Administration Deployment | How Available is SQL Server 2016 |
| 15:30:00 | Stefan Riedel | Application Database Development | Automated and Repeatable Test Cases for Agile SQL Server Development. |
| 15:30:00 | Leila Etaati | Analytics and Visualization | Being Smarter with Azure Machine Learning and R |
| 15:30:00 | Darren Gosbell | BI Information Delivery | Introduction to Querying Cubes - Swallow the Red Pill |
| 15:30:00 | Allen White | Enterprise Database Administration Deployment | Maintain SQL Server Performance Baseline w/PowerShell |
| 15:30:00 | Marco Russo | BI Platform Architecture, Development Administration | Toolkit for DAX Optimization |
Event Date: 20-02-2016 - Session time: 09:00:00 - Track: Other
Mark will be flying over from the states to give the latest updates from the engineering team with respect to the Microsoft data platform. With the upcoming release of SQL Server 2016 around the corner you will get a drill in on the product including the latest on performance and customer experiences. Mark will also give you an update on the other important pieces of the platform including Azure SQL DB, Azure SQL DW, Data Lake, Hybrid capabilities, etc.
Event Date: 20-02-2016 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration
The technology was designed to give significant performance gains for datawarehouse queries. This initial version required some creative thinking to get all of the promised performance gains. This meant that adoption rates were not that high. However, SQL Server 2014 added significant functionality, which SQL Server 2016 builds upon. Come along and get a lap around this feature and find out how its adoption could help your organisation. Attendees should leave this session will enough knowledge about the storage, architecture and query enhancements to implement a successful columnstore feature and administer it.
Event Date: 20-02-2016 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 20-02-2016 - Session time: 10:30:00 - Track: Strategy and Architecture
In this session we will examine SQL Server 2016 and have a look at what's new in the Database Engine, Analysis Services, Reporting Services and Integration Services. We will highlight the "big ticket" items and discuss the business cases for using the technology and features. We will also discuss Microsoft's vision for the Data Platform and how SQL Server will evolve in the future.
Event Date: 20-02-2016 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 20-02-2016 - Session time: 10:30:00 - Track: Advanced Analysis Techniques
This session has been specifically designed to describe machine learning fundamentals, and to help enable and inspire existing developers 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 in which it can be accomplished.
Event Date: 20-02-2016 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 20-02-2016 - Session time: 10:30:00 - Track: Professional Development
Join me to discuss how to implement Agile principles into your project. We will discuss: • Gathering requirements, quickly designing a solution and start building • Tracking your progress, risks and issues without Microsoft Project • Handling scope creep • Continuously improving your efforts to get better and faster
Event Date: 20-02-2016 - Session time: 11:40:00 - Track: Cloud Application Development Deployment
Event Date: 20-02-2016 - Session time: 11:40:00 - Track: BI Platform Architecture, Development Administration
So can you validate the numbers in your BI solution? And can you do it quickly and easily?
In this session we will cover an approach for automating the validation of your BI solution covering multiple scenarios with a hand full of demos. We will be using nUnit as a framework and some free codeplex tools, so we can run a suite of tests every time we load data into our BI platform. This is not continuous integration, and it is not unit testing in the true sense either. It is, instead, "continuous validation", and it can provide you with an awful lot of assurance for not very much extra effort.
Event Date: 20-02-2016 - Session time: 11:40:00 - Track: Other
Event Date: 20-02-2016 - Session time: 11:40:00 - Track: BI Information Delivery
In this session you will learn through many live demos how to get most of Power BI for real world scnearios. You will be amazed with features of Power BI and what you can do with this toolset.
Event Date: 20-02-2016 - Session time: 11:40:00 - Track: Enterprise Database Administration Deployment
Event Date: 20-02-2016 - Session time: 12:50:00 - Track: Other
Event Date: 20-02-2016 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
In this session we’ll initially talk to the basics of how partitioning works, and why it may be beneficial to your database. We’ll then demonstrate real practical methods to show how partitioning techniques can be applied to tables and the positive and negative impacts partitioning will have to your database queries and design. We’ll then wrap up with a demonstration on leveraging partitioning for database maintenance operations such as optimisations and the implementation of partial database backups. This session will have a strong focus on real, practical, and hands-on partitioning methods and key concepts that DBA’s can apply from Day 1.
Event Date: 20-02-2016 - Session time: 14:00:00 - Track: Cloud Application Development Deployment
The session will cover the following topics with demos. Introduction to cloud adaptation of the organizations, - how enterprises adopt to the cloud and how startups are moving to the cloud. SQL relational store options in Azure. Security features of SQL Databases Cloud demanded security features of SQL Servers Using Azure Key Vault to secure data in SQL Server
Event Date: 20-02-2016 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 20-02-2016 - Session time: 14:00:00 - Track: Application Database Development
Event Date: 20-02-2016 - Session time: 14:00:00 - Track: Information Delivery
In this session, we'll look into the following
Event Date: 20-02-2016 - Session time: 14:00:00 - Track: Advanced Analysis Techniques
We will use a real-world health care model to show how we replaced an expensive, difficult to understand and maintain SAS system, with a simple, elegant, and auditable solution based on the Microsoft stack. The rules are table-driven with allocated costs handling built in.
Event Date: 20-02-2016 - Session time: 14:00:00 - Track: Application Database Development
You'll leave this session with a much better understanding of how your indexes work, and the knowledge and confidence to streamline your current Index optimization procedures to take your applications to new heights of performance.
Event Date: 20-02-2016 - Session time: 14:20:00 - Track: Enterprise Database Administration Deployment
DevOPs is about breaking down the silos of mistrust between development and operations teams and aligning the two teams around delivering a product to market faster. It is about a cultural shift as much as a process and technological one. In this session we will look at some of the challenges implementing DevOps, the benefits of it, and how it can help you remove FearOps from your organisation.
Event Date: 20-02-2016 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment
Event Date: 20-02-2016 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration
With Microsoft SSIS out-of-the-box, you are forced to create multiple individual packages which is very time consuming due to the lack of easy code reuse. In a typical BI project, the ETL implementation can easily take up 60% of the project time, so it is beneficial if the development time of similar SSIS packages can be cut down. Business Intelligence Markup Language (Biml) is an XML dialect for defining Business Intelligence assets across the Microsoft SQL Server platform In this session Craig will introduce you to Biml BimlScript, providing those new to Biml with a foundational understanding of what BIML is and what the benefits of using Biml are.
Event Date: 20-02-2016 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
In this session we will look at the options available to you currently to meet your Availability requirements using features being released in SQL Server 2016 to better provide high availability
Event Date: 20-02-2016 - Session time: 15:30:00 - Track: Application Database Development
Event Date: 20-02-2016 - Session time: 15:30:00 - Track: Analytics and Visualization
Event Date: 20-02-2016 - Session time: 15:30:00 - Track: BI Information Delivery
Being able to write your own queries is an important skill to know for the following reasons: • It makes it a lot easier to identify issues with your data, • It can provide a much faster way to test and develop measures, • It's an extremely effective way of doing performance tuning • It can extended your reporting capability by providing a means of extracting data that is difficult or impossible to do with GUI tools.
As in the Matrix movie I'm inviting you to take the red pill and come with me on a journey. At the end of our session you should have an understanding of the basic concepts of querying cubes and how to get started writing your own queries.
Event Date: 20-02-2016 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 20-02-2016 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration