| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:45:00 | Manjot Kaur | Application Database Development | DW SuperHero-Columnstore Index |
| 08:45:00 | Guy Glantser | Enterprise Database Administration Deployment | How to Use Parameters Like a Pro and Boost Performance |
| 08:45:00 | Matt Masson | Advanced Analysis Techniques | [The Power of Power Query |
| 08:45:00 | Adam Cogan | Analytics and Visualization | Power BI – Finally I can make decisions based on facts |
| 08:45:00 | Bernard Spence | Analytics and Visualization | Excel Tips and Tricks for the Data Professional |
| 10:00:00 | Craig Bryden | Analytics and Visualization | An Introduction to R and R Services |
| 10:00:00 | Rob Douglas | Enterprise Database Administration Deployment | Hitting the SQL Server "Go Faster" Button |
| 10:00:00 | Marco Russo | BI Platform Architecture, Development Administration | Handling Relationships in DAX |
| 10:00:00 | Grant Paisley | Analytics and Visualization | [Power BI for Enterprise, safely sharing your data |
| 10:00:00 | Grant Paisley | Other | SQL Server 2016 - What module to use and why |
| 11:30:00 | Manohar Punna | Enterprise Database Administration Deployment | Plan, Design and Implement a HADR Solution - a Journey |
| 11:30:00 | Nagaraj Venkatesan | Enterprise Database Administration Deployment | R for Database Administrators |
| 11:30:00 | Hamish Watson | Enterprise Database Administration Deployment | DevOPs and the DBA |
| 11:30:00 | Peter Myers | BI Information Delivery | Reports on the Run: Mobile Reporting with SQL Server 2016 |
| 11:30:00 | Greg Low | Strategy and Architecture | What on earth are all the Azure* and Power* services and why would I want them? |
| 12:45:00 | Iman Eftekhari | Other | Data Analytics in the Cloud: Real-life Examples |
| 12:45:00 | Grant Paisley | Other | A three day Power BI strategic project - lessons learnt |
| 12:45:00 | Sunil Agarwal | Other | PANEL - "What's hot" for your data career |
| 13:30:00 | Mike Byrd | Application Database Development | A Rocket Scientist View on Indexes |
| 13:30:00 | Adam Gilmore | BI Information Delivery | Automate Data Warehouse build and deployment (db,SSIS SSAS) with Visual Studio 2015 and TFS |
| 13:30:00 | Reza Rad | BI Platform Architecture, Development Administration | 10 Amazing Things About Power BI You Don't Know |
| 13:30:00 | Allen White | Enterprise Database Administration Deployment | Maintain SQL Server Performance Baseline w/PowerShell |
| 13:30:00 | Sunil Agarwal | Enterprise Database Administration Deployment | [How SQL Server 2016 SP1 changes the game |
| 14:45:00 | Victor Isakov | Application Database Development | Query Store: A (R)evolution in Query Tuning |
| 14:45:00 | Matt Allington | BI Platform Architecture, Development Administration | Power Query is more than just a desktop BI ETL tool |
| 14:45:00 | Warwick Rudd | Enterprise Database Administration Deployment | 2016 – The Rise and Fall of DBM |
| 14:45:00 | Leila Etaati | Analytics and Visualization | Treasure Map: Choosing the Right Algorithm in Azure ML |
| 14:45:00 | Ajay Jagannathan | Enterprise Database Administration Deployment | Become a Troubleshooting Ninja with PowerBI SQL Extended Events |
| 15:45:00 | Tobias Koprowski | Strategy and Architecture | AD 2015. 2 AM. A Disaster just began... |
| 15:45:00 | Kevin Boles | Application Database Development | Common TSQL Mistakes |
| 15:45:00 | Patrick Flynn | Enterprise Database Administration Deployment | Adding Power to the DBA toolkit! |
| 15:45:00 | Iman Eftekhari | BI Information Delivery | Power BI Governance and Enterprise-wide Deployment Options |
| 15:45:00 | Martin Catherall | Enterprise Database Administration Deployment | In memory OLTP - what can it do for me? |
Event Date: 18-02-2017 - Session time: 08:45:00 - Track: Application Database Development
Event Date: 18-02-2017 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment
Does your query sometimes run fast and sometimes slow – even when nothing’s changed? Did it happen to you that a stored procedure, which had always been running for less than a second, suddenly started to run for more than 5 seconds consistently – even when nothing had changed? In this session we will learn about plan caching and how the query optimizer handles parameters. We will talk about the pros and cons of parameter sniffing (don’t worry if you don’t know what that means) as well as about simple vs. forced parameterization. But most important – we will learn how to identify performance problems caused by poor parameter handling, and we will
Event Date: 18-02-2017 - Session time: 08:45:00 - Track: Advanced Analysis Techniques
Event Date: 18-02-2017 - Session time: 08:45:00 - Track: Analytics and Visualization
Many companies have valuable data, but the challenge is being able to easily visualize it in a way that allows you to make decisions.
He will show in a live demo how Power BI allows even non-technical users to produce and share invaluable reports and dashboards.
Event Date: 18-02-2017 - Session time: 08:45:00 - Track: Analytics and Visualization
Event Date: 18-02-2017 - Session time: 10: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: 18-02-2017 - Session time: 10:00: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: 18-02-2017 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 18-02-2017 - Session time: 10:00:00 - Track: Analytics and Visualization
Event Date: 18-02-2017 - Session time: 10:00:00 - Track: Other
Event Date: 18-02-2017 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Over the years, HA and DR has been a challenge with SQL Server. As the product evolved so did the options simplified for achieving a feasible HADR solution. In this session I will walk you through various projects I have worked on in past 8 years. I will start with the basic DR solution built using Log shipping, an alternate to AGs in SQL 2008 using Powershell/.NET and SAN Replication and the latest 4 node, two site cluster built with Availability Groups.
Event Date: 18-02-2017 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 18-02-2017 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
In this session I will demystify the concepts of DevOps and we will look at two aspects of DevOps - Continuous Integration Continuous Delivery.
Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team.It also involves automating tests around the integrated work
Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to test, staging, and production environments.
Database migrations/changes are an area that may not be typically automated or utilise Continuous Delivery.
Through the use of a comprehensive live demo to a running production database the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline.
Event Date: 18-02-2017 - Session time: 11:30:00 - Track: BI Information Delivery
This session will describe and demonstrate how to prepare data for mobile reporting, and also how to develop and publish mobile reports. In addition, it will describe the architecture of the engine, and how to manage mobile reports.
This session will be of interest to a full range of professionals, including analysts, report developers, IT managers, and data architects.
Event Date: 18-02-2017 - Session time: 11:30:00 - Track: Strategy and Architecture
Event Date: 18-02-2017 - Session time: 12:45:00 - Track: Other
Event Date: 18-02-2017 - Session time: 12:45:00 - Track: Other
Event Date: 18-02-2017 - Session time: 12:45:00 - Track: Other
SPEAKERS - Your are all invited
Event Date: 18-02-2017 - Session time: 13:30:00 - Track: Application Database Development
Event Date: 18-02-2017 - Session time: 13:30:00 - Track: BI Information Delivery
It's not enough to 'do' Agile you must 'be' Agile...
This means modifying, building and deploying your DW/BI solution, on a daily/weekly basis. Achieving this without automation is very difficult.
Topics include:
Grab a free script at the end to get you started.
Event Date: 18-02-2017 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
In this session you can expect many live demos and to be impressed by the extraordinary things you can do with Power BI. You will learn tips and tricks to empower your Power BI solution. Tips and tricks that you learn in this session helps you to make your Power BI solution more scale-able, robust, and high performance.
Event Date: 18-02-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 18-02-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 18-02-2017 - Session time: 14:45:00 - Track: Application Database Development
Event Date: 18-02-2017 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
• Use Power Query as a data provider for traditional Excel Pivot Tables without using Power Pivot.
• Building a Power Pivot calendar table from scratch using pure Power Query steps.
• Add commentary to bank statements and make those comments "stick" using self-referencing tables.
• Using Power Query as an auditing and exception management
• Using Power Query as a pure ETL tool and exporting more than 1 m rows of transformed data to a file.
Event Date: 18-02-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 18-02-2017 - Session time: 14:45:00 - Track: Analytics and Visualization
Event Date: 18-02-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 18-02-2017 - Session time: 15:45:00 - Track: Strategy and Architecture
Event Date: 18-02-2017 - Session time: 15:45:00 - Track: Application Database Development
Event Date: 18-02-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
By adding a little "Power" to your DBA toolkit you can!
By combining PowerShell and PowerBi with the more traditional DBA tools I will show how to query and document your entire environment and produce rich interactive reports that can be consumed by all levels of your organisation.
Event Date: 18-02-2017 - Session time: 15:45:00 - Track: BI Information Delivery
In this presentation Iman will use his experience in implementing and rolling out Power BI for numerous organisations to share some tips and options for governance and deployment approaches at enterprise level.
Event Date: 18-02-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
It was still really useful – as long as your use case suited the limitations. SQL Server 2016 removes several of these limitations and widens the use cases of in-memory OLTP. For example, even if you are not taking advantage of in-memory tables, you can probably leverage performance improvements by replacing traditional table variables and both local and global temporary tables with in memory implementations. Now you’ll be able to say that table variable is truly in memory! Come along to this session and learn about some of features of in memory OLTP - or Hekaton as a lot of people refer to this - and how you may be able to leverage these high performance features in both new and existing applications.