Pre Conference full day training seminars. We have 10 seminars to choose from this time. Click one for more information. See also Booking & Pricing.
Thursday 29th September 2011, with registration opening at 08:30 and sessions starting at 09:30, and finishing at 17:30.
|
Automate and Manage SQL Server with Powershell
with
Allen White
You have a lot of servers to manage, and less time to focus on each one. You've heard about PowerShell but don't know where to start. In this pre-conference session you'll learn PowerShell, how to write and manage your scripts and your environment, and how to manage SQL Server using this powerful tool. You don't need any knowledge of PowerShell, as the session starts with the basics of the language, but experienced PowerShell users will also learn the methods the experts use to manage SQL Server
|
|
A Day of SSIS
with
Andy Leonard
A Day of SSIS was developed by Andy Leonard to train technology professionals in the fine art of using SQL Server Integration Services (SSIS) to build data integration and Extract-Transform-Load (ETL) solutions. The training is focused around lectures and emphasizes a practical approach. The target audience for this training is database professionals, application developers, and business intelligence practitioners interested in acquiring or expanding their existing SSIS skill set
|
|
Upgrading your DBA Skills to SQL Server Denali
with
Christian Bolton
Future proof your career by getting a head start on what you need to know about the next version of SQL
Server Denali.
In this full-day, level 300 workshop you will learn:
- Introducing SQL Server Denali end-to-end
- Inside AlwaysOn and why it will change how you think about High Availability
- Core engine changes you need to know about like Column Store Indexes
- Enhancing your troubleshooting toolkit with Extended Events and XEProfiler
- Test your critical workloads with
Distributed Replay (DReplay)
|
|
End to End Business Intelligence Using Microsoft Sharepoint
with
Duncan Sutcliffe
Delegates who attend this one-day end-to-end workshop will learn how to build a complete Microsoft Business Intelligence solution with SharePoint, starting from scratch! With an emphasis on practical demos, this workshop will focus on progressively building a Microsoft Business Intelligence environment from the underlying SQL Server base right through to the user-oriented presentation layer, using SSRS, Excel and PowerPivot. In particular, this workshop will focus on technical architecture, the installation and configuration using Kerberos, right through to using every part of the SQL Server and SharePoint stack effectively to deliver really meaningful information to users
|
|
Master your data with MDS
with
Jeremy Kashel
An end to end look inside Master Data Services, this full day course will
begin with a synopsis of Master Data Management before moving on to an overview
of Microsoft SQL Server 2008 R2 Master Data Services (MDS) and then looking in
detail at topics such as:
- installing, configuring, and maintaining Master Data Services
- creating and using models
- version management
- business rules and workflow
- importing data into Master Data Services
- Integrating with other systems
- Security.
It will also take a brief look at what’s coming next for MDS in the SQL
Server Denali.
This course is for anyone who wants to manage and maintain
their business master data and improve data quality with Microsoft SQL Server
Master Data Services. A basic understanding of Microsoft SQL Server is
required.
|
|
Controlling and Optimising Execution Plan Compilation, Recompilation and Caching
with
Maciej Pilecki
Avoiding unnecessary compilation and recompilation can literally make or break your application performance – especially for high throughput workloads. Still, this area is often overlooked in the overall performance tuning strategy. In this very detailed and fast-paced seminar we will look at ways to improve your server and application performance by carefully controlling when and how your queries undergo optimization and compilation. That includes how different coding patterns affect execution plan caching, options that improve plan reuse, controlling size and composition of the execution plan cache, avoiding recompilation in stored procedures, knowing when to recompile and when to reuse, optimizing the Optimizer (yes, that’s possible!) and more
|
|
DAX Deep Dive
with
Marco Russo
During this workshop the authors of the best seller “PowerPivot for Microsoft Excel 2010: Give Your Data Meaning” will cover all of the aspects of this programming language, starting from the basic concepts and going through the most complicated aspects of evaluation context interactions, exploiting the full power of DAX. The focus of the course is not on PowerPivot functionalities but only on the DAX programming language
|
|
SQL Server Storage Engine and MDF File Internals
with
Mark S. Rasmussen
Join me for a journey into the depths of the SQL Server storage engine. Through a series of lectures and demonstrations we'll look at the internals of pages, data types, indexes, heaps, extent & page allocation, allocation units, system views, base tables and nightmarish ways of data recovery. We'll look at several storage structures that are either completely undocumented or very scarcely so. By the end of the day, not only will you know about the most important data structures in SQL Server, you'll also be able to parse every bit of a SQL Server data file yourself, using just a hex editor! There will be lots of hands on demos, a few of them performed in C# to demonstrate the parsing of data files outside of SQL Server.
|
|
Data Vault in a day
with
Martijn Evers
In the Datawarehouse arena, Kimball and Inmon approaches have dominated Datawarehouse implementation for decades. Now a refreshing and different approach for data warehousing is presenting itself. Created by Dan Linstedt during the '90 Data Vault was not widely known in the past decade. As of 2011 Data Vault is presenting itself to the large data warehousing and BI public, showing its success with its easy, agile, functional and flexible approach. Data Vault is a practical hands-on approach to creating your Central Enterprise Datawarehouse that does not rely on finding truth or performing complex ETL or modeling approaches
|
|
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? By selecting the right design, 90% of SSIS customers will achieve their ETL performance goals with little to no performance tuning. This session will teach you how to pick that design! Targeted at intermediate to advanced SSIS users, Matt Masson - a developer on the SSIS team - will guide you through a series of proven SSIS design patterns, and teach you how to apply them to solve many common ETL problems. We’ll start off with an overview of the Data Flow internals, and review the SQLCAT team’s Top Ten Best Practices for achieving optimal performance. We’ll then dive into a series of design patterns, including Advanced Lookup Patterns, Parallel Processing, Avoiding Transactions, handling Late Arriving Facts and multiple ways to process Slowly Changing Dimensions. If you’re looking for ways to maximize your SSIS ROI, then you won’t want to miss this!.
|