SQLSaturday #411 - Cambridge 2015

Event Date: 09/12/2015 00:00:00

Event Location:

The Møller Centre
Churchill College, Storey’s Way
Cambridge, , United Kingdom

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: SQL Server Performance Tuning. Practical Guide.

Abstract: Nothing is perfect, which means that your database may be not perfect as well. And one day you may decide that your database is slow and it’s time to optimize it. But.. Where to start? When to end? What to look at? Which queries are slow? How to identify the real bottleneck? And so on, and so on. There are a lot of questions that should be answered in process of performance tuning. And in this session, we will find answers to all these questions going from collecting data for analysis, through identifying bottlenecks to optimization of the particular queries. On this way we will learn practical techniques of performance tuning and solve bunch of issues. All this will be done using tools, which are installed on your system by default. Minimum of theory and a lot of practice.

Speaker(s):

Denis Reznik

Track and Room: DEV (Animals) - Sabre Wulf room

Title: Azure Big Data Solution – automation of deployment

Abstract: By now you’ve probably heard about Big Data 1.000 times or more so why a new session about big data you might ask. 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.

Speaker(s):

Kenneth Nielsen

Track and Room: Cloud (Piper at the Gates of Dawn) - Boulderdash room

Title: Dive into the Query Optimizer-Undocumented Insight

Abstract: This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.

Speaker(s):

Benjamin Nevarez

Track and Room: DEV (Animals) - Elite room

Title: Taking your application to memory

Abstract: Based on our work with converting an existing application to memory optimized tables and natively compiled stored procedures this session, will take you through this journey and show you the (large) gaps between what we have in our normal SQL belt and what is possible in Natively compiled stored procedures. I will show how to overcome all the gaps and get all out normal stuff to work in these monster fast procedures – even the things that the documentation says cannot be done.

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.

Speaker(s):

Rasmus Reinholdt

Track and Room: DEV (Animals) - Chuckie Egg room

Title: Understanding SharePoint reporting options for SQL Server

Abstract: The SharePoint landscape has changed dramatically over the last few years, and this session is designed to help Business Decision Makers, IT Managers and SQL Professionals understand what it offers as reporting platform. Exploring the different options, benefits and considerations for using SharePoint to report on data in SQL Server. Explaining that there are important decisions to make about which platform to use, and whether cloud based services should be considered. It will show a number of SharePoint options including Business Connectivity Services, Reporting Services, Excel Services and Power BI. It will consider the differences in functionality and configuration for different versions of SharePoint and SQL. Including comparing the platforms of SharePoint Server, SharePoint Foundation and Office 365. Finally it will challenge attendees to think about the purpose of the solution being delivered, who it is for and the long term strategy.

Speaker(s):

Peter Baddeley

Track and Room: SharePoint (Dark Side of the Moon) - Jetpac room

Title: SSRS Inception: Reporting on Reporting services.

Abstract: Still using Reporting Services? Yeah me too! Does this scenario sound familiar? You already have a large SSRS environment but the users still want more reports. You create a new, all singing, all dancing dashboard that removes the need for a bunch of reports, awesome. You launch it and explain to the business that you are deprecating the old reports. “WAIT! We still need that for Jill in HR to do her end-of-month”, or “We might still need that” - these types of comments are what leads to having a load of reports that are not being used.

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.

Speaker(s):

Terry McCann

Track and Room: BI (Wish You Were Here) - Chuckie Egg room

Title: Visualizing streaming data in real time

Abstract: We’re all familiar with reports or dashboards that show you a static snapshot of the data 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.

Speaker(s):

Mladen Prajdić

Track and Room: BI (Wish You Were Here) - Sabre Wulf room

Title: SharePoint as a Business Intelligence platform

Abstract: SharePoint – let’s admit it – is here to stay; It has become the business collaboration platform of choice for the enterprise and the binding element in the Office family of tools. However deploying and configuring can be a challenging task for the IT pro. 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.

Speaker(s):

Regis Baccaro

Track and Room: SharePoint (Dark Side of the Moon) - Jetpac room

Title: Testing T-SQL Code with tSQLt

Abstract: Unit-Test are a mature tool in traditional programming languages like C# and meanwhile accepted as de-facto standard. Using Stored Procedures and Functions you can put much programming logic right into the database. This logic has to be tested too. SQL Server Data Tools from Microsoft are one possible approach to generate unit tests for T-SQL Code. One of the disadvantages of SSDT is that the tests are implemented as C# or VB Solutions outside of the database. An alternative to these approach is using tSQLt, a Testing-Framework that is written entirely in T-SQL and is run completely in the database. So you are able to write unit tests in SQL Server Management Studio. In his talk SQL Server MVP Frank Geisler will show how the tSQLt Framework is set up and how it works and how you can write Unit Tests for different SQL Server Objects. Besides the free Version of tSQLt you can buy SQL Test from Redgate which is a very useful GUI for tSQLt and is demonstrated as well.

Speaker(s):

Frank Geisler

Track and Room: DEV (Animals) - Sabre Wulf room

Title: Creating Dynamic Packages

Abstract: In a perfect world an ETL solution would only have to import data from a single file that always had the same name deliver it to a single already existing table. Unfortunately this case is the exception rather than the rule. How can you use SSIS to:

Iterate through all files in a folder and import their content into SQL
Dynamically create and name table based on a data source
Dynamically create a T-SQL statement at runtime based on run time conditions This session focuses on how to create SSIS packages that can change to meet runtime events dynamically based on the environment. Each attendee will leave with the knowledge and toolset necessary to:
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
Replace dynamic SQL using expressions in SSIS

Speaker(s):

David Dye

Track and Room: BI (Wish You Were Here) - Chuckie Egg room

Title: SQL Anti-Patterns

Abstract: [ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ] 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

Speaker(s):

Kennie Pontoppidan

Track and Room: DEV (Animals) - Wizball room

Title: Automating business processes with SharePoint, Office 365 and Azu

Abstract: [ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ] 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

Speaker(s):

Penelope Coventry

Track and Room: SharePoint (Dark Side of the Moon) - Pyjamarama room

Title: Implementing Business Intelligence SharePoint High Availability

Abstract: [ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ] 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/

Speaker(s):

Mark Broadbent

Track and Room: SharePoint (Dark Side of the Moon) - Pyjamarama room

Title: Dealing With Errors in SSIS 2012

Abstract: Errors can occur anywhere within an SSIS package and the cause and error message can be somewhat cryptic. This session focuses on identifying error causes and handling them dynamically and proactively. The means of dealing with errors is defined by where the error occurs and we will cover error handling in control flow, data flow, and script tasks in great detail.

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

Speaker(s):

David Dye

Track and Room: BI (Wish You Were Here) - Sabre Wulf room

Title: A Day with Columnstore Indexes

Abstract: [ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ] 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

Speaker(s):

Niko Neugebauer

Track and Room: BI (Wish You Were Here) - Wizball room

Title: Availability Group Maintenance Operations

Abstract: AlwaysOn Availability Groups provide an excellent way to build a High Availability platform with SQL Server at its core, however with these new capabilities come new and interesting maintenance requirements. In this session we will look at a number of the things you must do when making use of Availability Groups, and some of the things that you can do in order to ensure that you have a stable, reliable platform.

Speaker(s):

John Martin

Track and Room: DBA (The Wall) - Manic Miner room

Title: SharePoint Enterprise Platforms: Build Run Lessons Learnt

Abstract: To point and click our way through a SharePoint installation is relatively easy, but will more than likely result in some form of disaster. Join SharePoint expert, Andy Talbot for a detailed discussion on building and running SharePoint platforms fit for enterprise customers.

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.

Speaker(s):

Andy Talbot

Track and Room: SharePoint (Dark Side of the Moon) - Impossible Mission room

Title: Microsoft – Building a Data Driven Strategy

Abstract: For more details visit http://sqlcambs.org.uk/precon7/ 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.

Speaker(s):

Microsoft and Guests

Track and Room: DBA (The Wall) - Dropzone room

Title: Building tomorrows ETL architecture with BIML and MDS today

Abstract: [ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ] 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

Speaker(s):

Rasmus Reinholdt

Track and Room: BI (Wish You Were Here) - Jet Set Willy room

Title: Benefits of analytics using Microsoft Azure Machine Learning

Abstract: Data mining on-premises has a long tradition with Microsoft SQL Server and Machine learning in Azure is the cloud based brother, both supporting a hand-full of great algorithms for your business to grow. 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.

Speaker(s):

Tomaž Kaštrun

Track and Room: BA (The Division Bell) - Elite room

Title: Using SharePoint as a Service Delivery Platform

Abstract: Large organisations usually have their own dedicated Service Delivery IT platform for tracking and managing “Service Requests”, but what happens in smaller organisations? 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.

Speaker(s):

Ryan Yates

Track and Room: SharePoint (Dark Side of the Moon) - Jetpac room

Title: Building your first Microsoft Azure IaaS infrastructure

Abstract: Want to get your systems to the cloud, not entirely sure how to go about it? Let me guide you through the design considerations and process for building a Highly Available and resilient SQL Server infrastructure, looking at entirely cloud based and hybrid options. By the end of this session we will not only have discussed, but actually built and deployed a HA/DR SQL infrastructure and website that accesses it.

Speaker(s):

John Martin

Track and Room: Cloud (Piper at the Gates of Dawn) - Sabre Wulf room

Title: Re-engineering the SharePoint Migration

Abstract: This session will discuss a high level overview of the migration process, the steps involved, and examine the many ways in which PowerShell can help reduce the time and pain associated with large scale Farm migrations. This will include live PowerShell demonstrations of the concepts being discussed throughout the session.

Speaker(s):

Corey Burke

Track and Room: SharePoint (Dark Side of the Moon) - Impossible Mission room

Title: SharePoint - Migrating Databases and Farm Configuration using PowerShell

Abstract: The session will first cover how to go about transferring SQL Databases between SharePoint Farms using PowerShell. Including common scenarios, approaches and potential gotchas, as well as some example scripts.

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.

Speaker(s):

Anthony Obi

Track and Room: SharePoint (Dark Side of the Moon) - Jetpac room

Title: Visualising SharePoint and SQL Data with Visio Professional

Abstract: David will demonstrate how easy it is to not only visualise data from SQL Server and SharePoint, on-prem. or in the cloud, with Visio 2013+ Professional , but how you can use structured diagrams and validation rules to create data for your database from a drawing. He will also demonstrate how Visio diagrams stored in SharePoint 2013+ can be become interactive dashboards available on any modern device and in any modern browser.

Speaker(s):

David Parker

Track and Room: SharePoint (Dark Side of the Moon) - Impossible Mission room

Title: Understanding Solving Columnstore Problems

Abstract: Dive deep into Columnstore Indexes and discover their advantages and some of the limitations. 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.

Speaker(s):

Niko Neugebauer

Track and Room: DBA (The Wall) - Paradroid room

Title: SQL Server Query Tuning Optimization

Abstract: [ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ] 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

Speaker(s):

Benjamin Nevarez

Track and Room: DEV (Animals) - Jet Set Willy room

Title: Quick Start Guide to JavaScript Frameworks for SharePoint Apps

Abstract: Learn about JavaScript frameworks and new developer practices in SharePoint and on Office 365. JavaScript frameworks are there for you to help you develop faster and easier. You don’t need to do your apps from scratch. 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.

Speaker(s):

Sonja Madsen

Track and Room: SharePoint (Dark Side of the Moon) - Impossible Mission room

Title: Performance tuning a PowerPivot and Tabular model, notes from the field

Abstract: In-memory means blazingly fast, at least most of the time. 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.

Speaker(s):

Johan Ludvig Brattås

Track and Room: BI (Wish You Were Here) - Chuckie Egg room

Title: Extending SharePoint solutions: Without spending money

Abstract: This back to basics demo rich session shows visualization you can add to your pages, using embedded links, Microsoft Visio#174;, Microsoft Excel#174; and Office apps, and shows you how these visualizations can work together using JavaScript and Web Part connections to provide an interactive dashboard. The solutions uses SharePoint lists and libraries and external data sources by directly connecting to them or by using Business Connectivity Services (BCS). Penny will highlight any limitations between the visualization when using Office 365™ or an on-premises installation of Microsoft SharePoint#174;.

Speaker(s):

Penelope Coventry

Track and Room: SharePoint (Dark Side of the Moon) - Impossible Mission room

Title: Securing your SQL Azure Database. How?

Abstract: Do you think that your data is not secured in the cloud? Is that one of the reasons for you to not migrate at least some workloads there? Things changed in the last few months in terms of Azure database security. In this session we will take a closer look at what the features Row Level Security(RLS) and Dynamic Data Masking can do for your business and how they can help you secure your data.

Speaker(s):

Boris Hristov

Track and Room: Cloud (Piper at the Gates of Dawn) - Paradroid room

Title: SharePoint Databases - What you need to know

Abstract: An introduction to the different databases that SharePoint uses, with recommendations for High Availability, Disaster Recovery and configuration settings for SQL Server, including the constraints imposed in a single farm, a stretched farm between data centres and a separate DR farm.

Speaker(s):

Al Eardley

Track and Room: SharePoint (Dark Side of the Moon) - Impossible Mission room

Title: SQL Server Batch Mode and CPU Architectures

Abstract: This has a simple demonstration using two columns stores created on the same data, but with the larger one out performing the smaller one when used in the same query, this ‘Hook’ leads onto a deep dive into how modern CPU architectures are designed how they work and how batch mode leverages these, culminating in where the batch mode CPU pressure point is.

Speaker(s):

Christopher Adkin

Track and Room: DEV (Animals) - Elite room

Title: Introducing Azure SQL Data Warehouse

Abstract: Microsoft recently launched a new service into Azure; SQL Data Warehouse. SQL Data Warehouse is a scale out, distributed database that can scale its compute resources on demand. Come to this session and learn all about it from the co-author of the official documentation https://azure.microsoft.com/en-gb/documentation/articles/sql-data-warehouse-overview-develop/

Speaker(s):

James Rowland-Jones

Track and Room: Cloud (Piper at the Gates of Dawn) - Elite room

Title: No stress with OSTRESS, Lessons Learned from a high traffic Replay attempt

Abstract: One of my client engagements lately was about replaying a workload. The system had so many batches per second that I couldn’t actually do a replay but had to run in stress mode and try to slow down the replay in such a way that it resembled the production system.

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.

Speaker(s):

André Kamman

Track and Room: DBA (The Wall) - Boulderdash room

Title: Building abstract layers for data protection and business logic

Abstract: Many developers are working with direct access to the data layer of a database (tables) by ORM or .NET, Access, … This access methode maybe a good choice for small applications which use a dedicated database where no security or business requirement is needed.

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.

Speaker(s):

Uwe Ricken

Track and Room: DEV (Animals) - Boulderdash room

Title: How to build an IT operations expert

Abstract: My thesis in the Master of IT management program was about the life of IT operations people and how they learn.

Specifically I worked on the following three research questions: 1) What is the difference between a normal IT operations professional and a true expert 2) How can you make your IT operations professionals better 3) What can you do to make your experts thrive

Come and hear about my results and how to make your IT operations professionals grow

Speaker(s):

Kennie Pontoppidan

Track and Room: Other (A Momentary Lapse of Reason) - Paradroid room

Title: Continuous Integration and the Data Warehouse

Abstract: Continuous Integration is not normally associate with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply continuous integration techniques to data warehouse projects. In particular, the session will cover:

Automating your build and deployments with SQL Server Data Tools
Harnessing the power of BIML
Automated Integration and Regression testing of your Data Warehouse
Deploying and on-going management of OLAP databases using the OlapPartitionManager

Speaker(s):

John Tunnicliffe

Track and Room: DEV (Animals) - Paradroid room

Title: Ask the CEO - Infrastructure for your new business

Abstract: Want to start a new business? You have the great idea, but what about creating a business plan, web site, invoicing, CRM, social media and all the other infrastructure you need to operate that great startup. Come and spend an hour with me and see how we did it with our new company Effektor. Ask all the questions you have. I might even be able to answer them.

Speaker(s):

Kennie Pontoppidan

Track and Room: Other (A Momentary Lapse of Reason) - Paradroid room

Title: How to be a Cloud DBA

Abstract: Traditional DBA’s do not just take care of making sure the backups work. We help teams promote their databases from DEV to Production, we make copies from Production to Dev and perhaps anonimize some data on the way. In this session we will look at a bunch of our tasks that are traditionally the domain of the DBA and we will look at how to perform these tasks in a cloud or hybrid cloud situation.

Speaker(s):

André Kamman

Track and Room: Cloud (Piper at the Gates of Dawn) - Elite room

Title: Common Analysis Services Multidimensional Design Mistakes And How To Avoid Them

Abstract: When you’re starting out on your first Analysis Services Multidimensional cube project it’s very easy to make design mistakes that can cause problems for you later on. In this session you’ll learn about the mostly frequently made Analysis Services design mistakes, what the consequences of making them are, and how to fix them.

Speaker(s):

Chris Webb

Track and Room: BI (Wish You Were Here) - Elite room

Title: Introduction to MDX

Abstract: Multi Dimensional eXtension (MDX) query language is still the most prominently used language, used to query Multi Dimensional Cubes. If you are ventouring into the world of MOLAP or taking over projects that contains cubes, this will bring you a basic understanding of the MDX language and hopefully give you a good platform to advance from.

Aspects covered in the session: • Select, From and Where clauses • Sets, Tuples, Members • Period, Hierarchy, String, Math and Filtering functions

Speaker(s):

Jens Vestergaard

Track and Room: BI (Wish You Were Here) - Chuckie Egg room

Title: Efficient Index maintenance through DMVs

Abstract: Indexing is the most important task for a good performing database. An optimized database need to be checked regularly for all kind of index problems. This session will Show the usage of DMV (dynamic management objects) for the maintenance of indexes. Get familiar with the physical thresholds for optimal Indexes; approve the usage of Indexes within a few minutes and demonstrate the results to the vendors! We will take a deep look into the dmos for the new Column Stored Indexes too!

Speaker(s):

Uwe Ricken

Track and Room: DBA (The Wall) - Manic Miner room

Title: Digging Into the .Net SqlClient

Abstract: The prevailing opinion is that the optimizations for SQL Server are usually only done on the server itself. But is there anything we can do on the client to gain more speed? In this session aimed at .Net and SQL developers, we’ll dive into the workings of the .Net SqlClient and give you insight into way more than just SqlCommand.ExecuteReader() and SqlCommand.ExecuteNonQuery().

Speaker(s):

Mladen Prajdić

Track and Room: DEV (Animals) - Sabre Wulf room

Title: Office 365 - The Art of the Possible

Abstract: Office 365 has many different capabilities that have historically been separated into different products. The convergence of the products on one platform is opening up new possibilities for collaborating in new, more effective ways.

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.

Speaker(s):

Al Eardley

Track and Room: SharePoint (Dark Side of the Moon) - Jetpac room

Title: Azure Data Factory - The New SSIS?

Abstract: For a long time people have been asking where is SSIS for the cloud. Truth is it was never going to happen. Azure Data Factory has been designed from the ground up. It is designed for moving data at scale and with agility. Come to this session to learn about this new service and how it come provide value to your business processes

Speaker(s):

Allan Mitchell

Track and Room: BA (The Division Bell) - Elite room

Title: AzureML: Welcome to the future of predictive analytics

Abstract: Predictive analytics is touching more and more lives every day. Machine Learning lets you predict and change the future. Do you know that Microsoft products like Xbox and Bing integrate some machine learning capabilities in their workflows? Come to the session and take a look of the new cloud-based machine learning platform called AzureML from a BI architect perspective, without all the data scientist knowledge. Real machine learning solutions and some best practices when integrating ML on Apps and websites.

Speaker(s):

Ruben Pertusa Lopez

Track and Room: BA (The Division Bell) - Elite room

Title: Blue Sky Thinking: SQL Azure Geospatial Mashup

Abstract: In this session we’ll be integrating a variety of geospatial data sources to provide a scalable website using a Windows Azure SQL Database and it’s built in Geospatial features such as nearest neighbour. Then we’ll take this a step further and introduce another live data stream, finally rendering it all using Bing Maps to an Azure Website. The presentation is targeted at individuals wanting a quick overview of the rapidly evolving Azure Service offerings for today’s cloud ready business.

Speaker(s):

Thomas Sykes

Track and Room: Cloud (Piper at the Gates of Dawn) - Manic Miner room

Title: Hidden gems of SQL Server 2014

Abstract: SQL Server 2014 is full of new features and improvements. Some of them are “Killer” features like InMemory OLTP, Clustered Columnstore Indexes, Buffer Pool Extensions, etc., which are discussed a lot and we always can get a lot of information about them. And in the same time, SQL Server 2014 have several fantastic features and improvements, which are more hidden from our sight. In this session we will talk in details about these features and improvements. Query Fingerprints, Cardinality Estimator, Tempdb improvements, and more features will be covered in this session.

Speaker(s):

Denis Reznik

Track and Room: DBA (The Wall) - Manic Miner room

Title: Scaling out Analysis Services

Abstract: Experience how Maersk Line implemented a best practice installation on the SQL Server Stack. Focus in this session will be on three major aspects of delivering a smoothly running platform, from an IT perspective. 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

Speaker(s):

Jens Vestergaard

Track and Room: BI (Wish You Were Here) - Manic Miner room

Title: Datazen - An overview

Abstract: Recently, in April 2015, Microsoft aquired the company Datazen a specialist for mobile BI. This aquisition enables Microsoft to offer mobile, self service BI tools for Windows, iOS, Andorid and HTML. Besides using BI solutions on mobile devices online it is also possible to use these BI solutions offline. SQL Server MVP Frank Geisler will give insights into how Datazen works and how you can build BI Dashboards on different Datasources. He will show how a Datazen Server is installed and configured and how the Datazen Apps work on Windows 8.

Speaker(s):

Frank Geisler

Track and Room: BI (Wish You Were Here) - Manic Miner room

Title: HBase on HDInsight

Abstract: Microsoft have made available HBase on HDInsight. Use HBase when you need random, realtime read/write access to your Big Data. host very large tables – billions of rows X millions of columns on your HDInsight cluster. Come to this session to find out more.

Speaker(s):

Allan Mitchell

Track and Room: BA (The Division Bell) - Chuckie Egg room

Title: Efficient Indexing Strategies

Abstract: Indexes are incredibly powerful objects to optimize your database performance. However, when not implemented optimally, indexes can also have a negative impact on your queries! In this session we will take a close look at the different index types, how they work and how we can use that knowledge to design an efficient indexing strategy for your databases. We will also spend time analyzing existing indexes. Are those indexes being used? Can we combine indexes? Those are some of the questions you will learn to answer in this session.

Speaker(s):

Enrico van de Laar

Track and Room: DBA (The Wall) - Chuckie Egg room

Title: Scale Out Data Warehouse QA with Big Bang Data Co

Abstract: Got a question about Azure SQL Data Warehouse (SQLDW), Analytics Platform System (APS) and/or Parallel Data Warehouse (PDW)? Then this is the session for you! Big Bang Data Co are hosting an open QA session about these technologies where we aim to answer your questions. We will also have some fun give-aways too!

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!

Speaker(s):

James Rowland-Jones

Track and Room: BI (Wish You Were Here) - Elite room

Title: A journey through the Modern Data Warehouse

Abstract: The traditional data warehouse has been the key of our business analytics architecture for many years. In a world ruled by the data culture concept, new challenges are emerging: data growth; unstructured data; hidden patterns and cloud-born data. 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.

Speaker(s):

Ruben Pertusa Lopez

Track and Room: BI (Wish You Were Here) - Boulderdash room

Title: Optimizing BI with SQL2014 In-Memory tables

Abstract: Well - they named it SQL2014 In-Memory OLTP tables - BUT that does not mean we can’t optimize our BI solutions with this new feature.
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.

Speaker(s):

Rasmus Reinholdt

Track and Room: BI (Wish You Were Here) - Paradroid room

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Niko Neugebauer

Twitter: - NikoNeugebauer

LinkedIn: Niko Neugebauer

Contact: http://www.nikoport.com

Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.

James Rowland-Jones

Twitter: - https://twitter.com/jrowlandjones

LinkedIn: James Rowland-Jones

James Rowland-Jones (JRJ) is a Principal Program Manager at Microsoft. He is currently part of the SQL Server team working on SQL Server 2019 Big Data Clusters and data virtualization. Prior to joining SQL Server, JRJ worked extensively on Azure SQL Data Warehouse. He helped the team launch Gen 1 of the service and led the product management effort to bring Gen 2 into preview.

Kenneth Nielsen

Twitter: - https://twitter.com/DoktorKermit

LinkedIn: Kenneth Nielsen

Contact: http://funkylab.com

Kenneth M. Nielsen currently work at Microsoft as Data Platform Solution Architect, focusing on data services on Azure. Previously worked as managing consultant and teamlead for the company Rehfeld Partners in Denmark. He has worked at various consulting firms and worked on many small/large/very large bi installations in Denmark over the last 12 years. He really likes to advice the customers to take the right decisions, but also maintains a high technical knowledge, so he can act at both architect and developer.

Jens Vestergaard

Twitter: - @vestergaardj

LinkedIn: Jens Vestergaard

Contact: http://www.t-sql.dk

Jens performs the traditional BI disciplines from imports in Integration Services through data consolidation in Analysis Services, to report in Power BI or Reporting Services. Jens has worked with The Stack since SQL 2000 and has a core competence in Integration Services and Analysis Services. Along with the certified skills in Microsoft SQL Server, Jens has also worked with Microsoft .Net platform for more than 15 years and currently manages a BI Platform in Azure for the CatMan Solution application(s).

Benjamin Nevarez

Twitter: - @BenjaminNevarez

Contact: http://www.benjaminnevarez.com/

Benjamin Nevarez is a SQL Server independent consultant based in Los Angeles, California, who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning amp; Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals.quot; Benjamin has also been a speaker at many SQL Server conferences, including PASS Summit, SQL Server Connections, and SQLBits. His blog can be found at http://www.benjaminnevarez.com.

Terry McCann

Twitter: - @SQLShark

LinkedIn: Terry McCann

Contact: https://www.advancinganalytics.co.uk/blog

Microsoft MVP. Principal Consultant and Owner of Advancing Analytics Limited, an Advanced Analytics consultancy in the UK. Advancing Analytics helps businesses advance their analytical capabilities. Our focus is on Data Science, Data Engineering, DataOps and applied AI. Terry holds a Master’s degree in Data Science - with a focus on DataOps for Machine Learning. Speaker at conferences across the world and the host of the Data Science in Production Podcast.

Benjamin Nevarez

Contact: http://www.benjaminnevarez.com/

Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning Optimization”, “Inside the SQL Server Query Optimizer” and has contributed to other SQL Server books including “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits.

Mladen Prajdić

Twitter: - @MladenPrajdic

LinkedIn: Mladen Prajdić

Contact: http://weblogs.sqlteam.com/mladenp

Mladen Prajdić is a Data Platform MVP from Slovenia. He’s been programming for 20 years, developing diﬀerent types of applications in .Net (C#) and SQL Server, ranging from standard line-of-business, image-processing applications to high performace and IoT applications. He’s a regular speaker at various conferences and usergroup meetings, really likes to optimize slow SQL statements, analyze performance, and find unconventional solutions to difficult SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com).

Sonja Madsen

I#39;m SharePoint MVP and my blog on SharePoint 2013 has well over 1 million hits. I own Sonjasapps with over 20 apps in Microsoft SharePoint App Store. I#39;m both Microsoft Partner and Microsoft vendor.

I started with SharePoint with MA degree in Multimedia and Information Science and as a .NET developer back in 2004.

Ruben Pertusa Lopez

Twitter: - @rpertusa

LinkedIn: Ruben Pertusa Lopez

Contact: http://www.sqlpass.es

Ruben is a Global BI/BigData Manager and Global Data Lead Architect at DUFRY HQ, member of PASS Spanish Group and founder of SQLSaturday Barcelona and Madrid. MCP and MCSA in SQL Server 2012 and also awarded with Microsoft MVP Data Platform. With more than 9 years of experience, he has been working in top projects for leading worldwide companies and teaching in the SolidQ BI Master. He has presented at the SQL Server 2008 R2 and 2014 Spanish launch event, PASS BA Chicago, TechNet Webcasts, Microsoft Partner Program and SolidQ Summit events.

Corey Burke

Corey Burke is a Principal Architect with Rackspace Hosting, a Managed Cloud Hosting provider located in Hayes, London in the UK. He is a contributing author for the Professional SharePoint 2013 Administration book, and a Technical Editor for Beginning SharePoint 2013: Building Business Solutions. Corey has presented at various SharePoint Saturday events as well as User Group Meetings and Microsoft TechEd Europe. He is a huge fan of SharePoint and using PowerShell for automation.

Al Eardley

Twitter: - https://twitter.com/al_eardley

LinkedIn: Al Eardley

Contact: http://blog.eardley.org.uk

Alan Eardley is a Solution Architect at Corporate Project Solutions (CPS) specialising in Office 365. He has worked with SQL Server since version 7 and with SharePoint and associated products for the last seven years. He has been involved in the planning and delivery of on-premises and on-line solutions for a wide variety of clients ranging in size from small to global.

John Tunnicliffe

Twitter: - Dr_John_T

LinkedIn: John Tunnicliffe

Contact: https://devops-your-dwh.com/

Dr John Tunnicliffe is a well-respected designer and architect of business intelligence solutions who likes nothing more than getting his hands dirty with real life coding problems. John is a recognised expert in applying continuous integration techniques to data warehouse projects, thereby ensuring code is automatically built, deployed and tested as changes are made by the development team. As a regular speaker at the SQLBits conference and PASS SQLSaturday events, John has covered topics such as building an infrastructure to support real-time OLAP and continuous integration and the data warehouse.

Anthony Obi

Twitter: - https://twitter.com/obilogic

Contact: http://community.obilogic.co.uk/blogs/

Anthony Obi - Independent SharePoint Consultant - Obilogic LtdWorking with SharePoint since Portal Server 2001 (10 years+)MCITP / MCTS SharePoint 2010

David Parker

My background is in data visualisation ever since as a building architect in the 80s I struggled to produce lists of equipment from CAD models. I moved into building and infrastructure asset management in the late 80s using Unix systems, and gradually moved into Windows-based systems throughout the 90s. I became a European Business partner of Visio Corporation in 1996, and presented the database-linked Visio solutions that I was providing to the merchant banks in London and New York at several i

Uwe Ricken

Twitter: - https://twitter.com/dbBerater

LinkedIn: Uwe Ricken

Contact: http://www.sqlmaster.de

Uwe Ricken is working with IT systems since the 90’s. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. In the same year he earned his first award as a Data Platform MVP for his support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken is a speaker on many international conferences and events and preferred topics are “Database Internals”, “Indexing” and “Development”.

Rasmus Reinholdt

Twitter: - @RasmusReinholdt

LinkedIn: Rasmus Reinholdt

Contact: http://rasmusreinholdt.wordpress.com

Rasmus is the Data Warehouse architect at UNOPS, the implementation arm of the UN, based in Copenhagen, Denmark. He has worked with Microsoft BI since 2005 both as a developer and architect, building large solutions on every release from sql2005 and onwards. Rasmus is certified is MSCE SQLServer (Data platform amp; BI), a long time speaker at various SQLSaturdays, PASS SQLRally Nordic and SQLBits. He also co-organizes SQLSaturday Copenhagen and blogs at http://rasmusreinholdt.wordpress.com.

Ruben Pertusa Lopez

Twitter: - @rpertusa

LinkedIn: Ruben Pertusa Lopez

Contact: http://www.sqlpass.es

Andy Talbot

To point and click our way through a SharePoint installation is relatively easy, but will more than likely result in some form of disaster. Join SharePoint expert, Andy Talbot for a detailed discussion on building and running SharePoint platforms fit for enterprise customers.

Penelope Coventry

Twitter: - @pjcov

LinkedIn: Penelope Coventry

Contact: http://www.sharepointdesignerstepbystep.com/Blog/

Penelope Coventry, MVP SharePoint Server, MCSE: SharePoint 2013 and MCITP: SharePoint Administration 2010, is an author and consultant based in the U.K., with more than 30 years of industry experience. Penny has authored and co-authored more than 10 SharePoint-related books. Penny has spoken at a number of conferences, including TechEd North America, SharePoint Conferences in United States, Canada, Australia, New Zealand, Sweden and the UK and at SharePoint Saturdays and user groups.

Peter Baddeley

Contact: http://www.baddaz.com

Peter is a Solution Architect focusing on delivering Microsoft solutions including SharePoint, Dynamics CRM and Office 365. He has been working with SharePoint since 2004, lives in Cambridgeshire (United Kingdom) and can often be found on Twitter (@Baddaz) or his blog (www.baddaz.com). Peter is one of the organisers of East Anglia Region of the SharePoint User Group UK. His working life is spent leading a team of consultants delivering Microsoft Solutions to companies across UK and Ireland.

Mladen Prajdić

Twitter: - @MladenPrajdic

LinkedIn: Mladen Prajdić

Contact: http://weblogs.sqlteam.com/mladenp

Ryan Yates

SharePoint Enthusiast working currently at a leading UK University

Love of automation via Powershell and currently a CSOM enthusiast - Combine the two and thats where i come in :-)

Denis Reznik

Twitter: - https://twitter.com/DenisReznik

LinkedIn: Denis Reznik

Contact: http://reznik.uneta.com.ua

Denis Reznik is a Data Architect at Intapp, Inc. He has more than ten years experience in software development, database design, and performance tuning for cloud and on-premises solutions. In 2010 Denis became Microsoft Data Platform MVP and maintains MVP status today. Apart from his professional career, Denis actively participates in the development of the Ukrainian Data Community.

Niko Neugebauer

Twitter: - NikoNeugebauer

LinkedIn: Niko Neugebauer

Contact: http://www.nikoport.com

Rasmus Reinholdt

Twitter: - @RasmusReinholdt

LinkedIn: Rasmus Reinholdt

Contact: http://rasmusreinholdt.wordpress.com

Tomaž Kaštrun

Twitter: - @tomaz_tsql

LinkedIn: Tomaž Kaštrun

Contact: http://www.tomaztsql.wordpress.com

Tomaž Kaštrun is BI developer and data analyst. His main focus are data mining, T-SQL development, programming and query optimization. He has been working with SQL server since version 2000. He is Microsoft Certified Professional, Microsoft MVP for data platform and Microsoft trainer.

Chris Webb

Twitter: - @cwebb_bi

LinkedIn: Chris Webb

Contact: https://blog.crossjoin.co.uk/

Chris Webb is a member of the Power BI CAT team. He is the author of “Power Query for Power BI and Excel” and a co-author of “SQL Server Analysis Services 2012: The BISM Tabular Model”, “Expert Cube Development with SQL Server 2008 Analysis Services”, and “MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase”.

Kennie Pontoppidan

Twitter: - @KennieNP

LinkedIn: Kennie Pontoppidan

Contact: http://www.pontop.dk/

Kennie Nybo Pontoppidan is a senior program manager in Microsoft working in the Dynamics NAV server backend team. He has worked in the dangerous field between developers, dbas, customers and project managers for many years and done his part of mistakes as a developer before that in his 15+ years in the it industry. He enjoys working with databases and really, really enjoys his daily dose of sql. Kennie has no humor.

Uwe Ricken

Twitter: - https://twitter.com/dbBerater

LinkedIn: Uwe Ricken

Contact: http://www.sqlmaster.de

Rasmus Reinholdt

Twitter: - @RasmusReinholdt

LinkedIn: Rasmus Reinholdt

Contact: http://rasmusreinholdt.wordpress.com

James Rowland-Jones

Twitter: - https://twitter.com/jrowlandjones

LinkedIn: James Rowland-Jones

Denis Reznik

Twitter: - https://twitter.com/DenisReznik

LinkedIn: Denis Reznik

Contact: http://reznik.uneta.com.ua

Penelope Coventry

Twitter: - @pjcov

LinkedIn: Penelope Coventry

Contact: http://www.sharepointdesignerstepbystep.com/Blog/

Jens Vestergaard

Twitter: - @vestergaardj

LinkedIn: Jens Vestergaard

Contact: http://www.t-sql.dk

Kennie Pontoppidan

Twitter: - @KennieNP

LinkedIn: Kennie Pontoppidan

Contact: http://www.pontop.dk/

John Martin

Twitter: - SQLDiplomat

LinkedIn: John Martin

Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/

John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK.

John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.

David Dye

David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa

David Dye

Kennie Pontoppidan

Twitter: - @KennieNP

LinkedIn: Kennie Pontoppidan

Contact: http://www.pontop.dk/

Microsoft and Guests

Jon Woodward is the BI and Analytics Lead for Microsoft UK. Stuart Aston is the Chief Security Officer for Microsoft UK. Stuart has been with Microsoft in the UK since 1998 and is the National Security Officer for Microsoft in the UK. Gary Richardson is the Director of Analytics Engineering for KPMG. Anthony Marzetti is the Director of Data Integration at Tagetik. Ric Howe works for Microsoft UK as a technical consultant. Anthony Saxby is the Data Platform Lead for Microsoft UK.

Allan Mitchell

Twitter: - @allanSQLIS

Contact: https://onlysearch.wordpress.com/

Allan Mitchell is a SQL Server MVP and runs elastio, a small consultancy helping customers to make informed decisions about their data storage and integration. His focus is on enterprise search as well as real-time data integration.

Regis Baccaro

Twitter: - @regbac

LinkedIn: Regis Baccaro

Contact: http://theblobfarm.wordpress.com

Regis has more than 15 years of experience with SQL Server, SharePoint and .Net as an architect and developer. R#233;gis is a SQL Server MVP since 2014 and a frequent speaker at SQL conferences, a PASS Regional Mentor and the founder of SQLSaturday Denmark community event. He is also a certified industry trainer on the APS/PDW platform. In his freetime he is an avid runner, cook and farmer.

John Martin

Twitter: - SQLDiplomat

LinkedIn: John Martin

Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/

Frank Geisler

Twitter: - @Frank Geisler

LinkedIn: Frank Geisler

Contact: http://www.gdsbi.de

Frank Geisler is owner and CEO of GDS Business Intelligence GmbH. He is SQL Server MVP, MCT, MCSE – Business Intelligence, MCSE – Data Plattform and MCSE - Azure Solutions Architect. In his Job he is building Business Intelligence Systems based on Microsoft Technology, mainly on SQL Server and SharePoint.

Thomas Sykes

Twitter: - @sqltomato

LinkedIn: Thomas Sykes

Contact: http://sqltomato.com/

Tom is a Senior SQL Server consultant for Quorum Network Resources, a Microsoft Gold Data Platform Partner based in Edinburgh. He is a MCT in addition to being multiple MCSE in Data and Cloud. Current projects include SQL Infrastructure and Performance Tuning, Hybrid Azure SQL Solutions and SQL 2014 migrations.

Kennie Pontoppidan

Twitter: - @KennieNP

LinkedIn: Kennie Pontoppidan

Contact: http://www.pontop.dk/

Allan Mitchell

Twitter: - @allanSQLIS

Contact: https://onlysearch.wordpress.com/

Johan Ludvig Brattås

Twitter: - intoleranse

LinkedIn: Johan Ludvig Brattås

Contact: http://brattas.org/sqlmusings

Johan Ludvig Brattås is a managing consultant at Capgemini, and a dedicated community guy. He has worked with MS SQL server since late 1999, mostly with BI in one form or another. The last 6 years, most of his work has been in Azure working on data platforms, Power BI and the last three years expanding to Azure IoT and Stream Analytics.

Combining his passion for Microsoft SQL Server with his passion for sharing knowledge, he has spoken at various events in the SQL Community. This is also a way to give back to the community for all the things he has learned over the years. When not working, Johan Ludvig either spends his time with his kids, playing with new technology, or teaching coeliacs how to bake glutenfree food.

Kennie Pontoppidan

Twitter: - @KennieNP

LinkedIn: Kennie Pontoppidan

Contact: http://www.pontop.dk/

Boris Hristov

Twitter: - https://twitter.com/BorisHristov

LinkedIn: Boris Hristov

Contact: http://borishristov.com/blog/

Boris is a SQL Server Consultant, but also an Author for Pluralsight and a SQL Server MVP. He is frequently speaking at conferences all accross Europe and is heavily involved in training students and organizations in what he calls quot;The Art of SQL Serverquot;. Boris is frequently blogging and is the host of SQLHangouts.

André Kamman

Twitter: - @andrekamman

Contact: http://andrekamman.com

André Kamman is a DBA and SQL Server Solutions Architect for CloudDBA. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML). He also likes to work with MPP platforms APS and AzureDW. André is a Data Platform MVP, Dutch PASS Chapter Leader and organiser of SQLSaturday Holland.

Enrico van de Laar

Twitter: - twitter.com/evdlaar

LinkedIn: Enrico van de Laar

Contact: https://www.enricovandelaar.com

Enrico has been working with data in all kinds of formats and sizes for over 15 years. He is a Data Advanced Analytics Consultant for Dataheroes where he helps organisations take their first steps in the world of Advanced Analytics. Enrico is a Data Platform MVP since 2014 and a frequent speaker on various data related events all over the world. He authored the book “Pro SQL Server Wait Statistics” and blogs about technologies like Microsoft SQL Server and Azure Machine Learning on his blog at www.enricovandelaar.com

Al Eardley

Twitter: - https://twitter.com/al_eardley

LinkedIn: Al Eardley

Contact: http://blog.eardley.org.uk

Mark Broadbent

Twitter: - retracement

LinkedIn: Mark Broadbent

Contact: http://tenbulls.co.uk

Mark Broadbent is a Microsoft Certified Master in SQL Server, Chapter Leader, Virtual Chapter Leader, SQLSaturday Cambridge and SharePoint Saturday Cambridge founder (the UKs first SQLSaturday) and awarded Microsoft#39;s Community Contributor award in 2011 and the PASS Outstanding Volunteer award in 2012. Mark is a regular speaker at both International and National events and is an expert in HADR solutions, SQL Server migration, and SQL Server Concurrency control.

Christopher Adkin

Twitter: - ChrisAdkin8

LinkedIn: Christopher Adkin

Contact: http://www.chrisadkin.io

Chris is a freelance SQL consultant who has been working with SQL Server since 2000, his passion is for squeezing every last drop of performance out of SQL Server and understanding the database engine at a level which conventional tools cannot provide any insights on.

Frank Geisler

Twitter: - @Frank Geisler

LinkedIn: Frank Geisler

Contact: http://www.gdsbi.de

André Kamman

Twitter: - @andrekamman

Contact: http://andrekamman.com

SQLSaturday #411 - Cambridge 2015

Sessions

Title: SQL Server Performance Tuning. Practical Guide.

Title: Azure Big Data Solution – automation of deployment

Title: Dive into the Query Optimizer-Undocumented Insight

Title: Taking your application to memory

Title: Understanding SharePoint reporting options for SQL Server

Title: SSRS Inception: Reporting on Reporting services.

Title: Visualizing streaming data in real time

Title: SharePoint as a Business Intelligence platform

Title: Testing T-SQL Code with tSQLt

Title: Creating Dynamic Packages

Title: SQL Anti-Patterns

Title: Automating business processes with SharePoint, Office 365 and Azu

Title: Implementing Business Intelligence SharePoint High Availability

Title: Dealing With Errors in SSIS 2012

Title: A Day with Columnstore Indexes

Title: Availability Group Maintenance Operations

Title: SharePoint Enterprise Platforms: Build Run Lessons Learnt

Title: Microsoft – Building a Data Driven Strategy

Title: Building tomorrows ETL architecture with BIML and MDS today

Title: Benefits of analytics using Microsoft Azure Machine Learning

Title: Using SharePoint as a Service Delivery Platform

Title: Building your first Microsoft Azure IaaS infrastructure

Title: Re-engineering the SharePoint Migration

Title: SharePoint - Migrating Databases and Farm Configuration using PowerShell

Title: Visualising SharePoint and SQL Data with Visio Professional

Title: Understanding Solving Columnstore Problems

Title: SQL Server Query Tuning Optimization

Title: Quick Start Guide to JavaScript Frameworks for SharePoint Apps

Title: Performance tuning a PowerPivot and Tabular model, notes from the field

Title: Extending SharePoint solutions: Without spending money

Title: Securing your SQL Azure Database. How?

Title: SharePoint Databases - What you need to know

Title: SQL Server Batch Mode and CPU Architectures

Title: Introducing Azure SQL Data Warehouse

Title: No stress with OSTRESS, Lessons Learned from a high traffic Replay attempt

Title: Building abstract layers for data protection and business logic

Title: How to build an IT operations expert

Title: Continuous Integration and the Data Warehouse

Title: Ask the CEO - Infrastructure for your new business

Title: How to be a Cloud DBA

Title: Common Analysis Services Multidimensional Design Mistakes And How To Avoid Them

Title: Introduction to MDX

Title: Efficient Index maintenance through DMVs

Title: Digging Into the .Net SqlClient

Title: Office 365 - The Art of the Possible

Title: Azure Data Factory - The New SSIS?

Title: AzureML: Welcome to the future of predictive analytics

Title: Blue Sky Thinking: SQL Azure Geospatial Mashup

Title: Hidden gems of SQL Server 2014

Title: Scaling out Analysis Services

Title: Datazen - An overview

Title: HBase on HDInsight

Title: Efficient Indexing Strategies

Title: Scale Out Data Warehouse QA with Big Bang Data Co

Title: A journey through the Modern Data Warehouse

Title: Optimizing BI with SQL2014 In-Memory tables

Speakers

Sponsors