4th - 7th May 2016

Liverpool


Seminars

Content TrainingDayListSideBar is missing
Wednesday 4 May 2016
SQL Server Index Formulas: Problems and Solutions with Kendra Little
Advanced Techniques For Super Scaling SQL Server with Chris Adkin
Columnstore Indexes - from basics to optimised analytics with Niko Neugebauer
New features of SQL Server Reporting Services 2016 with Chris Testa-O'Neill
Big Data Made Simple with Guy Glantser
Learn Biml Today: Start Using It Tomorrow with Scott Currie, Andy Leonard and Cathrine Wilhelmsen
Upgrade, Migrate, Consolidate: The SQL Server Lifecycle with William Durkin and Andre Kamman
DBA 2.0--How to Advance Your Career in a Changing Landscape with Joey D'Antoni and Denny Cherry
End to End with Azure Machine Learning with Buck Woody
Dev Ops for Data 101 – Get your database deployed with Simon Sabin and Simon D'Morias
R for the BI Professional with Stephanie Locke and Andrew Fryer
Enlist in the SQL Sentry Bootcamp! with SQL Sentry
Thursday 5 May 2016
T-SQL for the Experienced Practitioner with Itzik Ben-Gan
MPP: Data Warehousing at Scale with SQLDW & APS with James Rowland-Jones
Locking and Blocking in SQL Server with Klaus Aschenbrenner
SQL Server Query Plans --- Reuse or Recompile? with Kalen Delaney
AlmostOn: An Expert’s Guide to Troubleshooting FCIs and AGs with Allan Hirt
Advanced Accidental Database Design for SQL Server 2016 with Thomas LaRock and Karen Lopez
Unleashing the power in Power BI with Alberto Ferrari
SSIS Performance Design Patterns with Matt Masson
SQLCAT: A day in the life of an Azure SQL DB Developer / DBA with Sanjay Mishra, Denzil Ribeiro and Kun Cheng
Microsoft Azure Data Lake and U-SQL Deep Dive (hands on) with Michael Rys
New SQL Server Upgrade and Migration: Project Chinook with Lonny Bastien
Dev Ops for Data Intermediate with Simon Sabin and Simon D'Morias

Training Days

A choice of full day expert led training sessions.

Content TrainingDayListSideBar is missing
Wednesday 4 May 2016
SQL Server Index Formulas: Problems and Solutions with Kendra Little

Every SQL Server Developer needs to know how to design and tune effective indexes. This day of problems and solutions teaches you essential design principles for clustered and nonclustered indexes, filtered indexes, indexed views, and partitioning.Click To Register

Advanced Techniques For Super Scaling SQL Server with Chris Adkin

This session covers techniques and tools for use when every last ounce of performance and scalability needs to be extracted from the database engine.Click To Register

Columnstore Indexes - from basics to optimised analytics with Niko Neugebauer

Learn Columnstore Indexes in just 1 day starting with basics of the structure and stepping into the internal details, learning how to load data into them and finishing with advanced concepts of Batch Mode processing and performance tuning.Click To Register

New features of SQL Server Reporting Services 2016 with Chris Testa-O'Neill

Take a hands on tour with Chris Testa-O'Neill of the new features of Reporting Services 2016Click To Register

Big Data Made Simple with Guy Glantser

This session provides an introduction to the world of Big Data. It covers the challenges and concepts around Big Data, the various data platform types, the major vendors and products in the market, and also some Big Data use cases and scenarios.Click To Register

Learn Biml Today: Start Using It Tomorrow with Scott Currie, Andy Leonard and Cathrine Wilhelmsen

Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your SQL, SSIS, and SSAS development time. In this session, learn everything you need to start using Biml immediately.Click To Register

Upgrade, Migrate, Consolidate: The SQL Server Lifecycle with William Durkin and Andre Kamman

Join André and William and go be lead through the different aspects of SQL Server life-cycle management: How to prepare your systems, what show-stoppers exist, why move to a newer version, best practices for new system installs, cloud vs. on-prem.Click To Register

DBA 2.0--How to Advance Your Career in a Changing Landscape with Joey D'Antoni and Denny Cherry

Some DBAs live in fear of new technologies such as cloud computing and server virtualization. The future will not be kind to their careers. To be successful in modern IT, the Database Administrator needs to understand the full stack.Click To Register

End to End with Azure Machine Learning with Buck Woody

Buck Woody from the Microsoft Machine Learning and Data Science team (MLADS) will show you not only how to use the Azure ML tool to create solutions, but also explain the entire Cortana Analytics Suite and where AzureML fits in.Click To Register

Dev Ops for Data 101 – Get your database deployed with Simon Sabin and Simon D'Morias

This seminar covers the core skills to adopting a Dev Ops practice for your database having a Database Lifecycle Management (DLM) process using SQL Server Data tools (SSDT) and other industry tools;Click To Register

R for the BI Professional with Stephanie Locke and Andrew Fryer

You've got SQL Server and SSRS sorted but your users are wanting a bit more intelligence in their Business Intelligence. Come to this precon and see how Microsoft has you covered.Click To Register

Enlist in the SQL Sentry Bootcamp! with SQL Sentry

Attend this full day pre-con to gain in-depth knowledge of SQL Sentry products and services. Whether you are already a customer or considering adopting our platform, you will learn how to make the most of it directly from our product and sales engineClick To Register

Thursday 5 May 2016
T-SQL for the Experienced Practitioner with Itzik Ben-Gan

This full day seminar covers advanced T-SQL querying and programming topics.Click To Register

MPP: Data Warehousing at Scale with SQLDW & APS with James Rowland-Jones

Massively Parallel Processing (MPP) database systems are designed to deliver analytical performance at scale. This pre-con introduces you to MPP; accelerating your development skills and practical experience using Azure SQL Data Warehouse and APS.Click To Register

Locking and Blocking in SQL Server with Klaus Aschenbrenner

Locks are used by SQL Server to isolate database users from each other. Unfortunately incompatible locks leads to blocking. And blocking situations are always hurting your end users regarding their response time.Click To Register

SQL Server Query Plans --- Reuse or Recompile? with Kalen Delaney

In this seminar, we’ll discuss how SQL Server decides whether to recompile or reuse an existing plan, and how you can tell if that’s a good choice. We’ll also look at how you can ‘encourage’ SQL Server to do what you want it to do. Click To Register

AlmostOn: An Expert’s Guide to Troubleshooting FCIs and AGs with Allan Hirt

Every second counts when servers are down. FCIs and AGs can break for many reasons and you must be prepared to troubleshoot and resolve issues. This full day will teach you the relevant skills to diagnose your clustered SQL Server configurations.Click To Register

Advanced Accidental Database Design for SQL Server 2016 with Thomas LaRock and Karen Lopez

In this advanced workshop we cover enhancements in SQL Server 2016 for building databases in an enterprise environment on modern project teams.Click To Register

Unleashing the power in Power BI with Alberto Ferrari

In this seminar, you are guided in creating a solution using all the features of Power BI. Starting from scratch, you see all what is needed to import and integrate data from many sources and to create a data model following the best practices. Click To Register

SSIS Performance Design Patterns with Matt Masson

Need a fast data integration solution, but don't have the time or budget for heavy performance tuning? Matt Masson – a long time member of the SSIS team - will guide you through a series of proven SSIS design patterns, and teach you how to apply themClick To Register

SQLCAT: A day in the life of an Azure SQL DB Developer / DBA with Sanjay Mishra, Denzil Ribeiro and Kun Cheng

Join the SQLCAT team for a full day Azure SQL DB deep dive on fundamentals, performance troubleshooting, advanced practices, application patterns, customer scenarios and practical learningsClick To Register

Microsoft Azure Data Lake and U-SQL Deep Dive (hands on) with Michael Rys

This seminar will give you an introduction to Azure Data Lake all up, including the Azure Data Lake Storage service and then go deeper into Azure Data Lake Analytics and U-SQL.Click To Register

New SQL Server Upgrade and Migration: Project Chinook with Lonny Bastien

Join the SQL Server product group for an all-day session to learn about the completely revamped and new upgrade and migration experience for SQL Server, codenamed Project “Chinook”.Click To Register

Dev Ops for Data Intermediate with Simon Sabin and Simon D'Morias

This extends the Devops for Data 101 session to enable you to handle more complex, real world problems such as more complex testing, handling different environments or client configurations, data replication, CDC and server level objectsClick To Register