| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Benjamin Nevarez | DEV (Animals) | SQL Server Query Tuning Optimization |
| 09:00:00 | Niko Neugebauer | BI (Wish You Were Here) | A Day with Columnstore Indexes |
| 09:00:00 | Penelope Coventry | SharePoint (Dark Side of the Moon) | Automating business processes with SharePoint, Office 365 and Azu |
| 09:00:00 | Mark Broadbent | SharePoint (Dark Side of the Moon) | Implementing Business Intelligence SharePoint High Availability |
| 09:00:00 | Rasmus Reinholdt | BI (Wish You Were Here) | Building tomorrows ETL architecture with BIML and MDS today |
| 09:00:00 | Kennie Pontoppidan | DEV (Animals) | SQL Anti-Patterns |
| 09:00:00 | Microsoft and Guests | DBA (The Wall) | Microsoft – Building a Data Driven Strategy |
| 08:30:00 | John Martin | DBA (The Wall) | Availability Group Maintenance Operations |
| 08:30:00 | Terry McCann | BI (Wish You Were Here) | SSRS Inception: Reporting on Reporting services. |
| 08:30:00 | Kennie Pontoppidan | Other (A Momentary Lapse of Reason) | Ask the CEO - Infrastructure for your new business |
| 08:30:00 | André Kamman | Cloud (Piper at the Gates of Dawn) | How to be a Cloud DBA |
| 08:30:00 | Frank Geisler | DEV (Animals) | Testing T-SQL Code with tSQLt |
| 08:30:00 | Ryan Yates | SharePoint (Dark Side of the Moon) | Using SharePoint as a Service Delivery Platform |
| 08:30:00 | Andy Talbot | SharePoint (Dark Side of the Moon) | SharePoint Enterprise Platforms: Build Run Lessons Learnt |
| 10:00:00 | Boris Hristov | Cloud (Piper at the Gates of Dawn) | Securing your SQL Azure Database. How? |
| 10:00:00 | Chris Webb | BI (Wish You Were Here) | Common Analysis Services Multidimensional Design Mistakes And How To Avoid Them |
| 10:00:00 | Denis Reznik | DEV (Animals) | SQL Server Performance Tuning. Practical Guide. |
| 10:00:00 | Johan Ludvig Brattås | BI (Wish You Were Here) | Performance tuning a PowerPivot and Tabular model, notes from the field |
| 10:00:00 | Kenneth Nielsen | Cloud (Piper at the Gates of Dawn) | Azure Big Data Solution – automation of deployment |
| 10:00:00 | Peter Baddeley | SharePoint (Dark Side of the Moon) | Understanding SharePoint reporting options for SQL Server |
| 10:00:00 | Uwe Ricken | DBA (The Wall) | Efficient Index maintenance through DMVs |
| 10:00:00 | Al Eardley | SharePoint (Dark Side of the Moon) | SharePoint Databases - What you need to know |
| 11:15:00 | Denis Reznik | DBA (The Wall) | Hidden gems of SQL Server 2014 |
| 11:15:00 | Jens Vestergaard | BI (Wish You Were Here) | Introduction to MDX |
| 11:15:00 | Uwe Ricken | DEV (Animals) | Building abstract layers for data protection and business logic |
| 11:15:00 | Ruben Pertusa Lopez | BA (The Division Bell) | AzureML: Welcome to the future of predictive analytics |
| 11:15:00 | John Tunnicliffe | DEV (Animals) | Continuous Integration and the Data Warehouse |
| 11:15:00 | David Dye | BI (Wish You Were Here) | Dealing With Errors in SSIS 2012 |
| 11:15:00 | Sonja Madsen | SharePoint (Dark Side of the Moon) | Quick Start Guide to JavaScript Frameworks for SharePoint Apps |
| 12:20:00 | James Rowland-Jones | Cloud (Piper at the Gates of Dawn) | Introducing Azure SQL Data Warehouse |
| 12:55:00 | James Rowland-Jones | BI (Wish You Were Here) | Scale Out Data Warehouse QA with Big Bang Data Co |
| 13:30:00 | Enrico van de Laar | DBA (The Wall) | Efficient Indexing Strategies |
| 13:30:00 | Regis Baccaro | SharePoint (Dark Side of the Moon) | SharePoint as a Business Intelligence platform |
| 13:30:00 | Kennie Pontoppidan | Other (A Momentary Lapse of Reason) | How to build an IT operations expert |
| 13:30:00 | Mladen Prajdić | DEV (Animals) | Digging Into the .Net SqlClient |
| 13:30:00 | Frank Geisler | BI (Wish You Were Here) | Datazen - An overview |
| 13:30:00 | David Dye | BI (Wish You Were Here) | Creating Dynamic Packages |
| 13:30:00 | Corey Burke | SharePoint (Dark Side of the Moon) | Re-engineering the SharePoint Migration |
| 13:30:00 | André Kamman | DBA (The Wall) | No stress with OSTRESS, Lessons Learned from a high traffic Replay attempt |
| 13:30:00 | Allan Mitchell | BA (The Division Bell) | Azure Data Factory - The New SSIS? |
| 14:45:00 | Niko Neugebauer | DBA (The Wall) | Understanding Solving Columnstore Problems |
| 14:45:00 | John Martin | Cloud (Piper at the Gates of Dawn) | Building your first Microsoft Azure IaaS infrastructure |
| 14:45:00 | Jens Vestergaard | BI (Wish You Were Here) | Scaling out Analysis Services |
| 14:45:00 | Rasmus Reinholdt | DEV (Animals) | Taking your application to memory |
| 14:45:00 | Tomaž Kaštrun | BA (The Division Bell) | Benefits of analytics using Microsoft Azure Machine Learning |
| 14:45:00 | Penelope Coventry | SharePoint (Dark Side of the Moon) | Extending SharePoint solutions: Without spending money |
| 14:45:00 | Ruben Pertusa Lopez | BI (Wish You Were Here) | A journey through the Modern Data Warehouse |
| 14:45:00 | Al Eardley | SharePoint (Dark Side of the Moon) | Office 365 - The Art of the Possible |
| 16:00:00 | Benjamin Nevarez | DEV (Animals) | Dive into the Query Optimizer-Undocumented Insight |
| 16:00:00 | Christopher Adkin | DEV (Animals) | SQL Server Batch Mode and CPU Architectures |
| 16:00:00 | Rasmus Reinholdt | BI (Wish You Were Here) | Optimizing BI with SQL2014 In-Memory tables |
| 16:00:00 | Thomas Sykes | Cloud (Piper at the Gates of Dawn) | Blue Sky Thinking: SQL Azure Geospatial Mashup |
| 16:00:00 | Mladen Prajdić | BI (Wish You Were Here) | Visualizing streaming data in real time |
| 16:00:00 | Anthony Obi | SharePoint (Dark Side of the Moon) | SharePoint - Migrating Databases and Farm Configuration using PowerShell |
| 16:00:00 | David Parker | SharePoint (Dark Side of the Moon) | Visualising SharePoint and SQL Data with Visio Professional |
| 16:00:00 | Allan Mitchell | BA (The Division Bell) | HBase on HDInsight |
Event Date: 12-09-2015 - Session time: 09:00:00 - Track: DEV (Animals)
This full-day seminar will show you how to optimize SQL Server queries and create high-performance applications. You will learn about the inner workings of the query processor so you can write better queries and provide the query processor with the quality information it needs to produce efficient execution plans. You’ll also get tips for troubleshooting under-performing queries. In-Memory OLTP (Hekaton), a key new feature of SQL Server 2014, will be covered as well. Topics include:
How the query optimizer works Troubleshoot queries using extended events, SQL trace, dynamic management views (DMVs), the data collector, and other tools Work with query operators for data access, joins, aggregations, parallelism, and updates Speed up queries and dramatically improve application performance by creating the right indexes Understand statistics and how to detect and fix cardinal
Event Date: 12-09-2015 - Session time: 09:00:00 - Track: BI (Wish You Were Here)
Make sure you spend the whole day learning about the most important technology Microsoft has launched since the beginning of SQL Server – Columnstore Indexes. We will investigate how you can optimise your BI DataWarehousing solutions and take the advantage of the modern Columnstore Architecture significantly boosting your query performance and analytics reporting.
Learn how to get the very best out of your existing database environments and how you can monitor, optimise, implement and solve many Columnstore Indexing problems.
Discover how to take the full advantage of the Batch Processing mode for Columnstore Indexes, which can significantly accelerate your query processing by hundreds of times, and learn about its limits.
Through the use of Dynamic Management Views, Extended Events and Traceflags we shall analyse traditional Rowstore tables and turn them into highly
Event Date: 12-09-2015 - Session time: 09:00:00 - Track: SharePoint (Dark Side of the Moon)
Many people are forced to use Microsoft#174; SharePoint#174; because it is already there or part of the Office 365™ ecosystem; therefore many users see it just as another task to add to their burgeoning workload of tasks they have to complete in their busy working day. When any technology is introduced into a business it should help not hinder users. It should enable users to do more, not less. Technology should meet business needs and not be focused around a single product.
With this in mind, Penny will look at automating business processes using out-of-the-box functionality of SharePoint and with the use of Azure™ Logic Apps outside SharePoint, beyond firewalls and beyond even your own datacentre. You can create these workflows using no-code visual designers.
SharePoint topics that will be cover
Event Date: 12-09-2015 - Session time: 09:00:00 - Track: SharePoint (Dark Side of the Moon)
High Availability solutions have been around for nearly as long as SQL Server and with “Maintenance Windows” becoming an increasingly rare luxury, businesses are relying more and more on their Data Warehouse and Business Intelligence reporting platforms being available 24 hours a day for 365 days a year.
In this pre-conference session we shall explain how to design, plan, implement and maintain an end-to-end Highly Available Business Intelligence and analytic platform laying not only the conceptual foundations for your learning, but providing the practical technical hands on know-how for Business Intelligence professionals, Database (and Windows) administrators, and Technical Architects.
For more detail about this session please visit http://sqlcambs.org.uk/precon6/
Event Date: 12-09-2015 - Session time: 09:00:00 - Track: BI (Wish You Were Here)
In this hands-on / bring your own laptop pre-con, Rasmus will show how you can take your ETL to the next level. You will go from “Zero to BIML to BIMLScript” in the duration of the day. That means, that leaving the pre-con, you will never ever again have to go over hundreds of packages to change a datatype or add a column, all you’ll need to do, is to change your meta-data and you are home free.
As our meta-data repository, we will use SQL Servers built-in Master Data Services. You will be given a thorough introduction to this component and learn how to use and administer it. Besides getting a working knowledge of BIML AND MDS, and become able to use that in your ETL development, you will also get an overview of, and get to work with, the following advanced ETL concepts:
Early arriving facts Slowly Changing Dimensions (SCD) with script task Least interdependent structu
Event Date: 12-09-2015 - Session time: 09:00:00 - Track: DEV (Animals)
You can learn the basics of SQL in three days but it’ll take you 10 years to become good at it.
In this full training day we will take a look at a range of common design and coding mistakes to get an idea of the patterns and practices that absolutely do not work well for optimum performance, scale and design.
Anti-patterns are a way of naming these common design mistakes in order to make them easier to identify and remember (and correct!). Sooner or later as the demands on your database performance increase, so will the need to identify and resolve your anti-patterns.
During the day we will grow acquainted with anti-patterns on a physical level, a logical level, a SQL Query and application level, and spice it them up with some seriously foolish errors made by both myself, my colleagues and the industry at large!
Examples of SQL Anti patterns that we will address dur
Event Date: 12-09-2015 - Session time: 09:00:00 - Track: DBA (The Wall)
IDC research, commissioned by Microsoft, shows that better outcomes from data and analytics projects correlate with greater competitiveness of an organization in its industry or a better ability to fulfil its mission in the public sector. Although correlation does not equate to causation, a growing body of research shows financial and productivity benefits directly linked to better data-driven decision making enabled by business analytics solutions.
Four characteristics distinguish leaders in analytics—the use of more diverse data types and sources beyond social media to include the Internet of Things (IoT), adoption of more diverse analytical and self-service tools, methods, and metrics suited to broad range of users from data scientists to business analysts and executives, distribution of insights to a more diverse audience of business users, and the right-time application of most timely data.
Event Date: 12-09-2015 - Session time: 08:30:00 - Track: DBA (The Wall)
Event Date: 12-09-2015 - Session time: 08:30:00 - Track: BI (Wish You Were Here)
Wouldn't it be great if you could see who is viewing a report, in what format and how often, all inside your current SSRS environment? With this data wouldn't it then be even better if we could automate a process to email the owner of that report to say "HA! I told you no one looked at this report!". In this session we will look at how we can do all of this and more by mining the SSRS DB.
Event Date: 12-09-2015 - Session time: 08:30:00 - Track: Other (A Momentary Lapse of Reason)
Event Date: 12-09-2015 - Session time: 08:30:00 - Track: Cloud (Piper at the Gates of Dawn)
Event Date: 12-09-2015 - Session time: 08:30:00 - Track: DEV (Animals)
Event Date: 12-09-2015 - Session time: 08:30:00 - Track: SharePoint (Dark Side of the Moon)
Without the right management tools and software, tracking and delivering service request resolutions can be a resource intensive task in itself and does not bode well for the quality of service to the end-user.
If your organisation has a SharePoint deployment, it doesn't have to be this way.
In this session we will utilise SharePoint's Out-Of-The-Box functionality and through a selection of customisations and technical know how, we will lay the foundations so that you may implement your own Service Delivery platform and enable your organisation to provide the type of efficient service delivery your end users expect.
Event Date: 12-09-2015 - Session time: 08:30:00 - Track: SharePoint (Dark Side of the Moon)
In this session, Andy will address some of the common challenges that can take some enterprises by surprise, lessons learnt by large organisations, factors that we should have planned for, and common failure points. Attendees will benefit from this discussion regardless of if you are just starting out with your deployment, or you’re already in production. Although this is mainly targeted at the IT PRO audience, key points are made that very relevant to business users too.
Event Date: 12-09-2015 - Session time: 10:00:00 - Track: Cloud (Piper at the Gates of Dawn)
Event Date: 12-09-2015 - Session time: 10:00:00 - Track: BI (Wish You Were Here)
Event Date: 12-09-2015 - Session time: 10:00:00 - Track: DEV (Animals)
Event Date: 12-09-2015 - Session time: 10:00:00 - Track: BI (Wish You Were Here)
But modeling for the xVelocity/Vertipaq engine is a completely different beast than modeling for your trusty multi-dimensional SSAS cubes.
Join me on a session of improving a malfunctioning PowerBI Excel sheet and pick up handy tips and tricks you will need to tune your xVelocity models.
Event Date: 12-09-2015 - Session time: 10:00:00 - Track: Cloud (Piper at the Gates of Dawn)
Show how to make creation and deletion of AZURE elements automatically as part of your ETL process or by Powershell, automate the trivial procedures and work on the interesting parts This session will show you how : • Downloads and prepares several years of demo data and storing it in a dedicated Azure Blob Storage account. • Create a storage account and container for the HDInsight Cluster. • Create a SQL database server instance and a SQL database for the Hive Metastore. We will also setup the necessary firewall rules so that you can access the server directly. • The HDInsight cluster is provisioned and configured for access to the sample data. • A partitioned Hive table is created over top of the sample data • Exploration of the result • And how to automate these task either in Powershell or SSIS.
Event Date: 12-09-2015 - Session time: 10:00:00 - Track: SharePoint (Dark Side of the Moon)
Event Date: 12-09-2015 - Session time: 10:00:00 - Track: DBA (The Wall)
We will take a deep look into the dmos for the new Column Stored Indexes too!
Event Date: 12-09-2015 - Session time: 10:00:00 - Track: SharePoint (Dark Side of the Moon)
Event Date: 12-09-2015 - Session time: 11:15:00 - Track: DBA (The Wall)
Event Date: 12-09-2015 - Session time: 11:15:00 - Track: BI (Wish You Were Here)
Aspects covered in the session: • Select, From and Where clauses • Sets, Tuples, Members • Period, Hierarchy, String, Math and Filtering functions
Event Date: 12-09-2015 - Session time: 11:15:00 - Track: DEV (Animals)
This session demonstrates the protection of data by using schemata for data protection and implementation of business logic for multiple applications. I will demonstrate the usage of schemata in an application life cycle to reuse codes for reporting in the same way as for the web application or the fat client application.
Event Date: 12-09-2015 - Session time: 11:15:00 - Track: BA (The Division Bell)
Real machine learning solutions and some best practices when integrating ML on Apps and websites.
Event Date: 12-09-2015 - Session time: 11:15:00 - Track: DEV (Animals)
Event Date: 12-09-2015 - Session time: 11:15:00 - Track: BI (Wish You Were Here)
You will learn: •To identify the different error handling methods in control flow, data flow, and script tasks •Be able to utilize event handlers to proactively handle errors •Be able to redirect data error and proactively handle data flow errors •Be able to identify error descriptions and log error details
Event Date: 12-09-2015 - Session time: 11:15:00 - Track: SharePoint (Dark Side of the Moon)
Apps and the cloud app model have brought not only new ways to interact, send, write, and receive data from SharePoint. Apps have also brought JavaScript frameworks into SharePoint development. JavaScript frameworks are right there as part of the app template when you start a SharePoint hosted or a Cloud app. In this session, I'll show what you can do with JavaScript frameworks that are part of the app template. I'll show jQuery, Bootstrap, and modernizr.
Event Date: 12-09-2015 - Session time: 12:20:00 - Track: Cloud (Piper at the Gates of Dawn)
Event Date: 12-09-2015 - Session time: 12:55:00 - Track: BI (Wish You Were Here)
Please join us! Ask a question or just sit in, learn and share your experiences on Microsoft's distributed data platform. It's all good!
Event Date: 12-09-2015 - Session time: 13:30:00 - Track: DBA (The Wall)
Event Date: 12-09-2015 - Session time: 13:30:00 - Track: SharePoint (Dark Side of the Moon)
In this session we will walk through the configuration of a complete on-premises BI platform with SharePoint. We will configure different scenarios, and the technologies necessary for building the infrastructure. After this session you will be able to setup the applications and all the supporting services to make SharePoint a successful and performant BI platform. From Excel services to Kerberos delegation.
Event Date: 12-09-2015 - Session time: 13:30:00 - Track: Other (A Momentary Lapse of Reason)
Specifically I worked on the following three research questions:
Come and hear about my results and how to make your IT operations professionals grow
Event Date: 12-09-2015 - Session time: 13:30:00 - Track: DEV (Animals)
Event Date: 12-09-2015 - Session time: 13:30:00 - Track: BI (Wish You Were Here)
Event Date: 12-09-2015 - Session time: 13:30:00 - Track: BI (Wish You Were Here)
Use expressions within SSIS packages
Use variables to dynamically create SQL statements
Configure custom dynamic logging
Use package configurations and parameters and environments to make packages more portable at execution
Event Date: 12-09-2015 - Session time: 13:30:00 - Track: SharePoint (Dark Side of the Moon)
Event Date: 12-09-2015 - Session time: 13:30:00 - Track: DBA (The Wall)
I'll show you how to do that amongst a bunch of other things that I learned and would love to share with you. If you are thinking about using OSTRESS / RML Utilities to analyse your system and stress test it on a different machine to find bottlenecks, then this session is for you.
Event Date: 12-09-2015 - Session time: 13:30:00 - Track: BA (The Division Bell)
Event Date: 12-09-2015 - Session time: 14:45:00 - Track: DBA (The Wall)
Look into some of the Columnstore Indexes myths, understand more complex concepts of Batch Mode Query Processing with another depth.
Can you make your Columnstore queries ran even faster ? Can you actually lower the Degree of Parallelism and get a better performance ? How much memory does Columnstore Index actually use when working with queries ? How can you test your Columnstore queries in Row Mode and what is the actual difference between Row Batch Modes.
The answers on those questions are to be revealed at this session.
Event Date: 12-09-2015 - Session time: 14:45:00 - Track: Cloud (Piper at the Gates of Dawn)
Event Date: 12-09-2015 - Session time: 14:45:00 - Track: BI (Wish You Were Here)
How to accommodate for: A) A large number of Business Users simultaneous hitting the servers B) Keeping a high frequency processing/synchronization pipeline C) Ease of management
Event Date: 12-09-2015 - Session time: 14:45:00 - Track: DEV (Animals)
You will therefore be taken through the concept of in-memory tables and what to be aware of when considering converting your database tables and code to In-Memory tables and through a life migration demo be given all the tips and tricks I picked up while doing so. After attending this session, you will be able to leverage on the new concepts and work your way around its current limitations to gain enormous speed increase and a lock-free environment.
Event Date: 12-09-2015 - Session time: 14:45:00 - Track: BA (The Division Bell)
This session will be focused on benefits of building a predictive model using Azure Machine Learning (ML) studio and exploring its capabilities. We will cover from 1) Quick introduction to ML to 2) creating ML workspace with data upload, 3) training the data-set and evaluating the solutions/models and 4) using this solutions with ML API Service. With a great support to R language in Azure ML, we will also explore the usage of R script in Azure ML.
Event Date: 12-09-2015 - Session time: 14:45:00 - Track: SharePoint (Dark Side of the Moon)
Event Date: 12-09-2015 - Session time: 14:45:00 - Track: BI (Wish You Were Here)
Which is the best architecture in order to get over these new challenges? Join this session and learn how to enable the Modern Data Warehouse in your organization using Cubes, HDInsight, AzureML, Stream Analytics and DocumentDB. All through a continuous example using a retail shop scenario.
Event Date: 12-09-2015 - Session time: 14:45:00 - Track: SharePoint (Dark Side of the Moon)
This session will explain some of the ways that Office 365 is being used and demonstrate some of the capabilities that convince millions of companies to invest in Office 365 to replace existing products with a single unified environment making the most of the familiar business critical tools from Microsoft.
Event Date: 12-09-2015 - Session time: 16:00:00 - Track: DEV (Animals)
Event Date: 12-09-2015 - Session time: 16:00:00 - Track: DEV (Animals)
Event Date: 12-09-2015 - Session time: 16:00:00 - Track: BI (Wish You Were Here)
This demo intensive session takes you through the new possibilities In-Memeory tables and Native Compiled Stored Procedures opens up to us from a BI point of view - covering both the ETL and (R)OLAP angels of the BI process.
Event Date: 12-09-2015 - Session time: 16:00:00 - Track: Cloud (Piper at the Gates of Dawn)
Event Date: 12-09-2015 - Session time: 16:00:00 - Track: BI (Wish You Were Here)
that has to be refreshed on an interval. And those are very important visualizations. But sometimes you just have to have a real time view of your data streams and snapshots aren't enough. What if you could monitor multiple servers with SQL Trace or Extended Events or had some other source of streaming data and be able to see it all happening live on a central monitoring website? This is a scenario we'll take a detailed look at and build a system for such monitoring. We'll do this by using Extended Events .Net provider to get the live data stream, SignalR to get the live stream from the server to the website and the D3 javaScript library for actual real time visualizations on any device. After seeing all this in action, you'll definitely get a few ideas on where you could use this in your company.
Event Date: 12-09-2015 - Session time: 16:00:00 - Track: SharePoint (Dark Side of the Moon)
It will then move on to cover the often manual task of replicating Service Application Configurations between SharePoint Farms and demonstrate how this can also be simplified and automated with the use of PowerShell.
Event Date: 12-09-2015 - Session time: 16:00:00 - Track: SharePoint (Dark Side of the Moon)
Event Date: 12-09-2015 - Session time: 16:00:00 - Track: BA (The Division Bell)