It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Sessions & Content

In this purely demo-based session, I will show several real-life attacks, from mere reading up to disrupting service availability via various types of manual and automated SQL Injection, including a broadly unknown elevation of privileges attack.

This session covers all aspects of what you need to do, to enable the storage of card details in SQL Server and achieve PCI certification.
We will deep dive into the solutions for storing the data securely using SQL Servers encryption functionality

This session goes beyond the classical star schema modeling, exploring new techniques to model data with Power Pivot and SSAS Tabular. You will see how brute-force power in DAX allows different data models than those used in SSAS Multidimensional

In this talk, I will share my experience in creating and running Azure SQL Database, a large cloud scale service powered by SQL Server technologies. This presentation will provide an outline of the scenarios and requirements for a database service.

In this session Pyramid analytics will show how to use BI Office to easily build an adhoc Analysis Services Tabular Edition analytic data set and perform associative analysis using the unique features of BI Office.

Everyone wants a job they enjoy and look forward to working at each day. This session will present practical techniques for improving your brand and giving you the chance to interview for the job you want.

Learn how to use performance counters, report execution log data, and trace files to troubleshoot performance problems. Learn how to set up a monitoring solution to capture data and diagnose slow queries.

Information Workers and Data Analysts do “myth busting" on corporate performance and forecasts on regular basis. This session uncovers ways to take advantage of Power BI as Software as a Service (SaaS) for a "myth busting" lab you can try at home!

Sets are king when it comes to SQL Server, but sometimes you need to see data row by row. Window
Functions help you get the best of both worlds. Learn when and where these functions can help you get what you need without compromising performance.

Continuous delivery is an approach that enables new functionality to be delivered as needed. This session will cover how this approach can be applied to data warehouses to enable faster time to value for the consumers of the data.

Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration (CI) has proven to be a valuable technique in improving software quality and this session demonstrates CI for databases.

Everyone knew how to keep data safe and secure, right up until Edward Snowden revealed this error. Learn how to keep the data secure, by identifying and quantifying the risks. Take away practical tips and advice to apply immediately.

This session targets SSAS developers that are already dealing with complex security solutions on a regular basis and want to get more insights on what actually happens inside SSAS when the different kinds of security are applied to their model.

Polybase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and soon Windows Azure Storage Blobs (WASB). See it in action.

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.

In this session we'll look at the things you should and shouldn't be doing now, to protect yourself and your data against the risk of corruption and thing you should and shouldn't do should the database ever become corrupt.

Join me for an hour of playing with different ETL patterns by using Clustered Columnstore Indexes. Using different Hardware might lead you to different conclusions,and the size of the workload is always the paramount of your performance.Loading data first and then creating a Clustered Columnstore or creating Clustered Columnstore and than loading - join me to find the answers!

Microsoft is moving to the cloud and SQL Server 2014 is the first release with features designed specifically to extend your datacentre into the cloud. In this session we'll look at these features with end-to-end demos, discussions and scenarios so you can understand what the future could look like in your own SQL Server environment.

Run by folks heavily involved in the SQL community, this session explores what opportunities are out there for networking, learning and collaborating. Covering local, national, global, & digital communities, we'll put you in the know.

How does SQL Server build results? We'll role play: Brent Ozar will be an end user sending in queries, and you'll be SQL Server. This session is for people who are comfortable writing queries, but not with indexes, statistics, and sargability.

You don't buy a lot of servers, but you're about to deploy SQL Server, and you only get one chance to make it right. Brent Ozar will boil down everything you need to know into just a few simple decisions including SQL Edition, sockets, and RAM.

It's time to take your ad-hoc Powershell scripts turn them into your very own module. And while we're at it we will add proper error handling, parameterization & pipeline support. I will also demonstrate how to build help, force and whatif support.

R was originally for doing stats, but it now does database CRUD, reporting, documentation, and even websites. It can be awkward to know where to start, so this session fast tracks you to the sections you need to know about.

Learn how XLCubed unlocks the value of Multi-dimensional and Tabular SSAS and SQL for power users in Excel; providing pixel perfect delivery of reporting, dashboards for both Web and Mobile and with or without SharePoint.

Big Data has triggered the need for organisations to build real-time Operational Data Store (ODS) layers to feed the ‘Data Lake’ on Hadoop. Attend this lunchtime session to learn why a real-time ODS should be at the heart of your data architecture

In this session we'll look at the structure and basics of MDX, the Multi Dimensional query eXpression language for querying Analysis Services OLAP cubes. We'll start at the beginning, so no previous experience necessary.

Come to this session to learn about the next wave of Microsoft’s analytic capabilities. Big data opens up great possibilities but do you have the right skills as a data scientist? Learn what Microsoft is doing in the analytics space

Firstly we will show off Microsoft's enhancements to the Hadoop open source stack with HDInsight showing you how easy it is to get started with Hadoop. Secondly we'll explore an interesting big data use case

Alberto will start with a simple query and he will perform on stage all the necessary steps to optimize it, showing you the tools ant the techniques used to identify the bottleneck and to fix the performance issues

Because there are always at least two sides of the performance coin, 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()

Patching is often the cause of most of our downtime be it hardware, Windows, or SQL Server. This session will guide you around pitfalls to increase your uptime and reliability while managing your downtime related to patching and updating

This session will discuss the recommended approaches and best practices for partitioning and scaling Windows Azure SQL Database, allowing you to fully leverage the managed relational database service and take advantage of massive scale-out scenarios.

The query optimizer is at the heart of SQL Server. Much of the its' internal workings are hidden from the user, but can be revealed by using a selection of undocumented trace flags. This session will be a deep dive into the these internals.

It's 18:00 o'clock on Friday. You execute a process that usually takes a few minutes and start packing in order to start the weekend. You are already with your bag on your back, but the process doesn't finish. What should you do now?

In this session I will show you how to use Storage Spaces and Auto Tiering and some other features to build a highly available, fast, scale out file server. And then we'll use it to host SQL Server data & log files on it.

More and more senior roles require familiarity with SAN technologies - tricky for us, 'just' the DBA. This '90% practical' session will explore Hue's 2× different SAN in a box'es. Come and gain this much-needed exposure to Enterprise technologies.

In this session we'll take a look at some nice bits of TSQL coding to resolve troublesome coding problems. We'll also look into writing code to make use of some TSQL features that are under used in daily coding.

T4 templating will be a first class citizen in SSDT for SQL Server 2014. This session will show why you should use this technology for SQL code generation and how you can automate the process. The session will be demo rich.

Ensuring top performance is never easy. To maintain performance you need to make sure you’re monitoring the right things. How do you know if the figures you’re seeing are good or bad? Baseline comparisons can help.

Starting at version control, we’ll look at typical patterns and practices, how to tackle known challenges, and the safety checkpoints you should plan for as you work towards continuous delivery for databases, and painless deployments.

So you have heard of SQL Server Data Tools (SSDT), you have started using it but not entirely sure how to use it to it's full potential. This session is perfect for adopters of SSDT and how to get the most out of it.

The plan cache is one of SQL Server's fundamental components. Getting to know it can take you a few steps ahead in optimizing your system.
In this session we will demonstrate ways the Plan Cache can help us identify performance problems.

Management Studio Templates and Snippets make the DBA look like a superstar and in the process makes our lives easier through tapping into the mantra of Work Less - Do More. Join Tim as he shares his shortcuts for optimizing repetitive tasks

This session will focus on 5 great hybrid cloud features available in SQL Server 2014 that show how you can use these features to lower your TCO and leverage the cloud to provide new disaster recovery and backup solutions.

This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well.

In this session we will look at the features which are provided with Microsoft SQL Server 2012 and 2014 as part of the "AlwaysOn" features including site to site configurations to allow of a large scale high availability solution.

Ever wonder how someone else does it? There’s no right way or wrong way, but in this session you can peer over Brent’s shoulder (virtually) while he takes a few Stack Overflow queries and tries various techniques to make them faster.