| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | John Martin | Enterprise Database Administration Deployment | Being a DBA - A day in the life. |
| 08:30:00 | Dave Ballantyne | Application Database Development | Query Processing Internals |
| 08:30:00 | Mladen Prajdić | Application Database Development | SQL Server for Developers: Database is no dumping ground! |
| 08:30:00 | Stacia Varga | BI Platform Architecture, Development Administration | Building Blocks of BIML |
| 08:30:00 | Tobias Koprowski | Cloud Application Development Deployment | Windows Azure SQL Database - A Journey from Zero to be Hero |
| 08:30:00 | Neil Hambly | Enterprise Database Administration Deployment | Load Testing With SQL Server Tools |
| 08:30:00 | David Williams | SQL Server 2016 New Features | SQL Server 2016 New Feaures (Not Query Store!) |
| 08:30:00 | Dr. Subramani Paramasivam | Cloud Application Development Deployment | Tired of connecting on-prem cloud data? Take a DB stretch |
| 08:30:00 | Eric Lawson | BI Platform Architecture, Development Administration | Click Clone - a simple model for managing data quality and scaling out |
| 08:30:00 | Emanuele Zanchettin | Cloud Application Development Deployment | Implementing and Maintaining an Azure SQL Database project |
| 08:30:00 | André Melancia | Data Platform Security Compliance | MI6 Secrets - Data Security For Developers |
| 09:45:00 | Alex Whittles | BI Platform Architecture, Development Administration | Data Warehouse modeling, for data analysis and cubes |
| 09:45:00 | Lord Richard Douglas | Enterprise Database Administration Deployment | Understanding the Transaction Log, Your Key to Unlocking Greater Throughput |
| 09:45:00 | David Conlan | BI Platform Architecture, Development Administration | SSRS - The Dark Side: Custom Rendering |
| 09:45:00 | Prathy Kamasani | BI Platform Architecture, Development Administration | Dive into SSISDB Catalog using PowerBI |
| 09:45:00 | Dave Ballantyne | Application Database Development | Query Optimizer internals |
| 11:00:00 | Tobias Koprowski | Enterprise Database Administration Deployment | SQL Server Backup in the Era of the Cloud |
| 11:00:00 | Christopher Adkin | Application Database Development | Super Scaling Clustered Index Inserts |
| 11:00:00 | Mike Hillwig | Enterprise Database Administration Deployment | Do More With Less: Inside SQL Agent Multi-Server Administration |
| 11:00:00 | Annette Allen | Application Database Development | The What, Why and How of Unit Testing SQL Server |
| 11:00:00 | Simon Whiteley | BI Platform Architecture, Development Administration | ETL in the Clouds |
| 11:00:00 | André Kamman | Enterprise Database Administration Deployment | No stress with OSTRESS, Lessons Learned from a high traffic Replay attempt |
| 13:15:00 | Allan Mitchell | BI Platform Architecture, Development Administration | Azure DocumentDB |
| 13:15:00 | David Postlethwaite | Professional Development | Beware of the Dark Side - A Guided Tour of Oracle for the SQL DBA |
| 13:15:00 | Mladen Prajdić | Application Database Development | SQL Server and Application Security for Developers |
| 13:15:00 | Al Eardley | Enterprise Database Administration Deployment | SharePoint Databases - What you need to know |
| 13:15:00 | Rob Sewell | Enterprise Database Administration Deployment | Using Power BI with my DBA Database |
| 13:15:00 | Niall MacLeod | Application Database Development | Microsoft SQL Server Data Warehouse Fast Track – Understanding th |
| 14:30:00 | John Tunnicliffe | BI Platform Architecture, Development Administration | Continuous Integration and the Data Warehouse |
| 14:30:00 | Andreas Bergstedt | BI Platform Architecture, Development Administration | 10 Things that you already knew about SSIS |
| 14:30:00 | n/a n/a | Cloud Application Development Deployment | Session Details not available |
| 14:30:00 | Bob Duffy | Application Database Development | When good SQL design goes bad |
| 14:30:00 | Kenneth Nielsen | Application Database Development | SQL Server 2016 - Always Encrypted - secure your data from the prying eye |
| 14:30:00 | Justin Langford | Enterprise Database Administration Deployment | Performance troubleshooting SQL Server |
| 14:30:00 | John Martin | Enterprise Database Administration Deployment | Building Configuring SQL Server : Recommended Practices |
| 15:45:00 | Stephanie Locke | Application Database Development | Anchor Modelling: Sixth normal form databases! |
| 15:45:00 | Jen Stirrup | Advanced Analysis Techniques | What a boozy day at the Guinness factory teaches us about Analytics |
| 15:45:00 | Mike Hillwig | Enterprise Database Administration Deployment | Maintenance Plans: Planning to Fail |
| 15:45:00 | Alex Yates | Application Database Development | State-based or migrations-based database development? The pros and cons... |
| 15:45:00 | Stacia Varga | Cloud Application Development Deployment | Building a BI Solution in the Cloud |
| 15:45:00 | Mike Boswell | BI Platform Architecture, Development Administration | Changing the face of your desktop with PowerBI |
Event Date: 05-12-2015 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
!! Please note Pre-Conference sessions are available for an additional registration of #163;150+fees !!
This is a PAID FOR session hosted by SQLSoton which you must have signed up and paid before you can attend.
To view full details of this session book please go to - http://bit.ly/1KtBdsW.
Being a DBA, you are the one responsible for helping to protect some of the most important assets that a business has, namely the data. In this pre-conference session we will look at some of the tasks that you as a DBA will likely encounter and need to deal with in order to maintain a fully functional and efficient SQL Server Environment, including;
Full Details: http://bit.ly/1PiLtY8
Event Date: 05-12-2015 - Session time: 08:30:00 - Track: Application Database Development
!! Please note Pre-Conference sessions are available for an additional registration of #163;150+fees !!
This is a PAID FOR session hosted by SQLSoton which you must have signed up and paid before you can attend.
To view full details of this session book please go to - http://bit.ly/1KtBdsW.
In this precon, we will be looking at the processes involved of taking a simple statement and forming a workable well performing execution plan.
Firstly, we will be looking at Execution plans themselves and picking them apart to describe the physical actions that are executed by the engine to perform the required statement. This will be followed by statistics, estimation and caching and the role that they play in forming and costing execution plans. We will see how SQL Server 2014 has new functionality and the problems that they are designed to resolve, we will finish with query optimizer internals.
Full Details: http://bit.ly/1NGjd2P
Event Date: 05-12-2015 - Session time: 08:30:00 - Track: Application Database Development
!! Please note Pre-Conference sessions are available for an additional registration of #163;150+fees !!
This is a PAID FOR session hosted by SQLSoton which you must have signed up and paid before you can attend.
To view full details of this session book please go to - http://bit.ly/1KtBdsW.
In this pre-conference session we'll go over what every developer dealing with SQL Server and .Net has to know to be as effective and productive as possible. Because speed is important too, we'll also focus on areas where you as a developer can contribute most.
We'll cover:
Full session details at: http://bit.ly/1Jk3HU5
Event Date: 05-12-2015 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
!! Please note Pre-Conference sessions are available for an additional registration of #163;150+fees !!
This is a PAID FOR session hosted by SQLSoton which you must have signed up and paid before you can attend.
To view full details of this session book please go to - http://bit.ly/1KtBdsW.
In this full-day workshop, you’ll learn about Business Intelligence Markup Language (Biml), your secret weapon for saving time on SSIS package development. We’ll start by learning about the history of Biml, the tools you can use to work with Biml, what it looks like, and the problems it’s designed to solve.
Then we’ll dive into the syntax of Biml by building out a simple SSIS package step by step. You’ll learn the structure of a Biml file and how to generate a package that you can view in Business Intelligence Development Studio (BIDS) or SQL Server Data Tools for BI (SSDT-BI).
Full details: http://bit.ly/1Kr1SIZ
Event Date: 05-12-2015 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
!! Please note Pre-Conference sessions are available for an additional registration of #163;150+fees !!
This is a PAID FOR session hosted by SQLSoton which you must have signed up and paid before you can attend.
To view full details of this session book please go to - http://bit.ly/1KtBdsW.
Four years in the market, continuously changing, but still not understood. In AD2015 is it the right time to change this. With a full day Pre-Conf we start with our on-premises instances, next we touch the Sky, and as masters we will parachute back to the Earth.
In my Pre-Conf I want to show you how we can work with Windows Azure SQL Database (formerly known as SQL Azure) focused on;
Full Details: http://bit.ly/1FYbFC6
Event Date: 05-12-2015 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools – including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler – we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.
Event Date: 05-12-2015 - Session time: 08:30:00 - Track: SQL Server 2016 New Features
Event Date: 05-12-2015 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
Event Date: 05-12-2015 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
This is a key consideration when designing the operational characteristics of your backroom ETL subsystems, that stage and transform sales data into usable FACTs.
Cloning of key tables and utilising a parallel processing ETL stream, enables cookie cutter software development and controlled, synchronised loading of FACTs into the data warehouse presentation layer. The use of dynamically created table clones can reduce database entity clutter, optimise the development and execution of Fact Creation SSIS packages and improve data quality auditing.
These elements are crucial to scaling out the data warehouse solution as the business grows.
In this session I will review the design, describe the basic components and demonstrate the core functionality.
Event Date: 05-12-2015 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
Event Date: 05-12-2015 - Session time: 08:30:00 - Track: Data Platform Security Compliance
Here is your chance to learn how to turn business logic into database objects. Learn about SQL Server's data security mechanisms and implement multi-tiered data access with business rules and roles, make your app/database immune to infrastructure changes (like scaling from single server into clustered or cloud) and your boss' moods in the future, and avoid SQL injection and other security and app coding bugs using stored procedures and database server side logic. Session suited for developers and students (padawan level). Disclaimer: No actual state secrets will be revealed. Please do not send agents to my house again.
Event Date: 05-12-2015 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
In this session we’ll look at a number of different data scenarios that we encounter and explore ways of remodelling the data within the data warehouse to optimize it for cubes and MDX. We’ll see how adding functionality into the ETL layer and data warehouse can have a dramatic effect on the functionality and simplicity of the cube.
Event Date: 05-12-2015 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
There's no doubt about it, the transaction log is treated like a poor cousin. The poor thing does not receive much love. The transaction log however is a very essential and misunderstood part of your database. There will be a team of developers creating an absolutely awesome elegant design the likes of which have never been seen before, but the leave the transaction log using default settings. It's as if it doesn't matter, an afterthought, a relic of the platform architecture. In this session you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices.
Event Date: 05-12-2015 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
The first part of this session will focus on how reports are rendered. David will describe the Report Definition Language Specification and how to access the Report Object Model .NET API.
However, creating an individual custom rendering engine is a mammoth task. Therefore the second part of of this presentation focuses on how to leverage Microsoft's existing HTML renderer to deliver enhanced reporting capabilities. By taking a short-cut you will be able deliver some quite impressive new features and breathe life back into those online reports.
Event Date: 05-12-2015 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
However, have you ever wondered how to design an SSIS Project so we can take maximum benefit of SSISDB Catalog? How to troubleshoot SSIS Project executions from the Catalog? How to navigate your way around the built-in catalog reports? How to design a dashboard with SSIDB Catalog data? This session will focus on these scenarios by diving into SSISDB catalog views using PowerBI.
Event Date: 05-12-2015 - Session time: 09:45:00 - Track: Application Database Development
Much of the optimizer's internal workings are hidden from the user, but can be revealed by using a selection of undocumented trace flags to gain further knowledge and insight into how your queries and data are processed to create a plan.
This session will be a deep dive into the optimizers' internals and not for the feint of heart.
Event Date: 05-12-2015 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-12-2015 - Session time: 11:00:00 - Track: Application Database Development
Event Date: 05-12-2015 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-12-2015 - Session time: 11:00:00 - Track: Application Database Development
Event Date: 05-12-2015 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
In this session I'll run through how to architect your BI solution on Azure. We'll discuss some general principles of cloud architecture, look at the new azure pricing calculator, then dive into demonstrations of automation services and how to turn any traditional on-premise solution into a Platform-as-a-Service cloud app.
SSIS in the cloud is actually more possible than you think!
Also there may be some terrible jokes. I make no apologies for this.
Event Date: 05-12-2015 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
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: 05-12-2015 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 05-12-2015 - Session time: 13:15:00 - Track: Professional Development
This talk sets out to explain some of the terminology, the differences and the similarities between Oracle and SQL Server and hopefully make Oracle not look quite so intimidating.
At the end of this session you will have a better understanding of Oracle and the differences between the Oracle RDBMS and SQL Server. Although you won’t be ready to be an Oracle DBA it will give you a foundation to build on.
Event Date: 05-12-2015 - Session time: 13:15:00 - Track: Application Database Development
In this session we'll look at a few attack vectors that can be used against your company, and what you as a developer can and should do to protect against them. It will involve a good mix of security conscious SQL Server and application development, because you care about your work and nobody messes with you.
Event Date: 05-12-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-12-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-12-2015 - Session time: 13:15:00 - Track: Application Database Development
Event Date: 05-12-2015 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 05-12-2015 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration
Delta management, Project recovery, Best and Worst practice and more.
Session is recommended for the intermediate to advanced but the beginner will also gain from this.
Event Date: 05-12-2015 - Session time: 14:30:00 - Track: Cloud Application Development Deployment
Event Date: 05-12-2015 - Session time: 14:30:00 - Track: Application Database Development
In this humorous session I’ll be debating many of the so called "best practices" in SQL Server and demonstrating counter arguments. Come along to see how so called "pillars" of design are starting to break down. •When you should NOT use stored procedures. •When we don’t need indexes. •When Clustered Tables are bad. •When Identity Columns should not be Primary Keys. •When we don’t care about fragmentation. •When good naming convention’s go bad. •Why Partitioning often makes your queries slower. •Why do ORMs really makes sense when they make all your parameters nvarchar (max)
Health Warning: These may not be the design tips you should be using on your production OLTP.
Event Date: 05-12-2015 - Session time: 14:30:00 - Track: Application Database Development
Event Date: 05-12-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
This session presents an approach and tools to consistently troubleshooting performance problems with SQL Server.
Event Date: 05-12-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-12-2015 - Session time: 15:45:00 - Track: Application Database Development
This session deep dives into all the concepts behind Anchor Modelling (and indeed databases generally!) and then takes you through how Anchor Modelling uses these concepts to move away from the traditional data warehouse paradigm to deliver a purely additive, agile database.
Event Date: 05-12-2015 - Session time: 15:45:00 - Track: Advanced Analysis Techniques
Drinking Guinness is optional, but admittedly might be preferred for this intensive session.
In this session, we will look at modeling techniques in Predictive Analytics using R, using our boozy day at the Guinness factory as a backdrop to understanding why statistical learning is important for analytics today.
Event Date: 05-12-2015 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
The dirty little secret is that anything you can do with a maintenance plan can be done with T-SQL. And by leveraging several community-based solutions, you can accomplish anything without maintenance plans.
Event Date: 05-12-2015 - Session time: 15:45:00 - Track: Application Database Development
At the same time, leaders and shakers of our industry including ThoughtWorks, Pramod Sadalge and Paul Stovell promote an iterative, migration script driven approach asserting that deployment scripts should be tested early and not generated by a tool.
I'm irritated that whenever I go to a “how to do database continuous delivery” session, the speaker invariably believes in one approach or the other and present their way as good and the other as bad. It irritates me so much I want to do something about it.
I’ll discuss scenarios from projects I’ve worked with to explain the pros and cons of each approach. I’ll describe which projects are better suited to state or migrations and I’ll discuss whether it’s possible to get the best of both worlds.
Event Date: 05-12-2015 - Session time: 15:45:00 - Track: Cloud Application Development Deployment
In this session, you will learn about the available Microsoft Azure components and services that support a BI ecosystem. In addition, you learn how to properly configure your solution, whether it’s a completely cloud-based solution or a hybrid solution that includes on-premises data sources and on-premises client tools. You will gain an overview of Azure networking, and how it works in Azure VMs as well as for Office 365.
Event Date: 05-12-2015 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration