Training Days

A choice of full day expert led training sessions.

Training Days - Wednesday 4th, Thursday 5 March
Wednesday 4 March 2015
Become an Enterprise DBA with Sean McCown and Jennifer McCown

Managing hundreds of servers is difficult if you haven’t been shown how. You need to change the way you think about your environment. Learning syntax isn’t enough. You have to put the different strategies together to be able to exercise your vision.

SQL Server Reporting Services with Chris Testa-O'Neill

This precon will explore the creation of reports, through to the deployment and management of reports into production. Providing you with the ability to work productively with Reporting Services after completing the precon

Mastering T-SQL Querying Fundamentals with Itzik Ben-Gan

T-SQL is rooted in mathematics. Mastering it can take a lifetime. In order to write correct and robust code the most critical thing is to learn the fundamentals correctly. This seminar provides you with strong foundations to build your knowledge on.

Understanding Execution Plans with Hugo Kornelis

Reading and understanding execution plans is key to understanding and fixing ill-performing queries. This full-day seminar will teach you everything you need to know about execution plans. Attend this seminar if you want to hone your tuning skills!

Upgrading to Microsoft SQL Server 2014 with John Q Martin

With Microsoft SQL Server 2005 going End Of Life in early 2016 it is vital to start planning your migration to a supported version of Microsoft SQL Server. let me help you get ready for this by helping you understand the process and tools available.

Storage and Virtualisation for DBAs with Denny Cherry

This session will be a two part session in which we will be focusing on two of the biggest topics in the DBA field. How to properly design your SAN storage solution and how to properly design your virtualization solution.

Optimize “All Data” with a modern data warehouse solution with Adam Jorgensen

Most of the world’s data exists in a combination of on premise, cloud and non-relational forms. This session will teach you the options, best practices, and patterns to acquire, store, process and analyze all forms of data in a modern solution

A practical guide to using charts & graphs! with Dan Bulos

Choosing between the multitudes of chart types can be challenging. The session will cover how to select the right style of chart to accomplish your purpose, whether that is analyzing data to gain insights or producing a dashboard.

Better Performance Through Parallelism with Adam Machanic

This full-day seminar will teach you the ins and outs of Windows scheduler internals, SQLOS, intra-query parallelism, and patterns that can make your parallel queries many times faster. After attending you will be in full control of your CPUs.

Data Wars: The Cloud Awakens with Matt Masson

Come to this session to see the forces of business and IT armed with Power BI for Office 365 and Azure Data Services do battle with an increasing number of challenges in the workplace. Who will win?

A Day Inside SQL Server with Bob Ward

If you want to know the internals of SQL Server then this is the session for you. Prepare to have your brain melt in this deep session from the man who knows.

Thursday 5 March 2015
Understanding SSIS internals and performance tuning with David Peter Hansen

You have worked with SQL Server Integration Services (SSIS) for a few years, but more often than not, you see performance problems with your packages. Some packages are running slow, while others are taking up more memory and CPU than before.

Designing For Performance: Myths and Misunderstandings with Thomas LaRock and Karen Lopez

Everyone agrees that great database performance starts with great database design.

SQL Server For Developers: Database is no dumping ground! with Mladen Prajdić

Come to this all day session to learn everything you as a developer need to know about SQL Server. We'll look at structuring data, isolation levels and attack vectors to name just a few things.

Index Magic: Rowstore, Columnstore and NoStore with Kalen Delaney

Indexes allow SQL Server to access your data in the most efficient manner and improve performance by orders of magnitude. This seminar looks at 3 kinds of index structures: B-Tree indexes, columnstore indexes, and indexes used for in-memory tables.

Performance Tuning When You Can't Fix the Queries with Brent Ozar

Your users are frustrated because the app is too slow, and you have to fix it. Brent Ozar will share his proven methodologies to tune with indexes, SQL Server settings, and hardware.

NoSQL and Relational in the Modern Data Architecture with Lara Rubbelke and Allan Mitchell

Demystify the new world of Azure-based relational and NoSQL data platforms! By combining lecture and code-camp style labs you will gain a better understanding of the new, emerging cloud data platforms to support modern application scenarios.