Gonna get trained!

I received an invite the other day to a SQL Server 2008 Fast Track Data Warehousing Technical Training Workshop over at the MTC – Microsoft Technology Center in Irving, TX. Sounds pretty cool, so I said sure thing…I always enjoy gorging myself with cookies and coffee for a few days.  Here’s the skinny and the agenda, copied from my invite:

During this workshop, you will learn the following:

  • Design a cost-effective, balanced system for Data Warehouse workloads
  • Reduce Hardware costs by using commodity reference hardware configurations
  • Reduce costs by leveraging prescriptive guidance and best practices for data layout, loading
  • Reduced risk by leveraging Microsoft reference tested data warehouse architectures

Day 1

Module 1: Overview of Fast Track DW Set Up

Module 2: Setting up the Infrastructure

Videos on setting up the infrastructure

Module 3: Validating the Infrastructure

Lab: Validate storage with SQLIO

Module 4: Configuring the installation

Lab: Implement the SQL Server trace flags

Lab: Altering the Tempdb database

Lab: Validating the installation

Day 2

Module 5: Setting up the production database

Lab: Creating the Production Database

Lab: Creating the Production Tables

Module 6: Loading the data

Lab: Loading data using a staging database

Lab: Loading data without using a staging database

Module 7: Using the database

Lab: Executing scan-centric queries

Module 8: Loading incremental data

Lab: Loading incremental data

Module 9: Maintaining the data

Lab: Database Maintenance

 

I’ve been working with SQL Server 2008® R2 but haven’t looked at all of the features, so I’ll be interested in what they have to say, and as always, I’ll try to post some blogs on the material.

Lee

 

--------------------------------

Little known fact - St. Patrick was a Catholic priest who lived in the 4th century. Word up.

smileyhat

 

 

 face


Posted in:   Tags:
blog comments powered by Disqus

by Lee Everest, M.S.

Poll

Do you use Azure or cloud in your organization?



Show Results

Ads

Search


Month List

Calendar

«  February 2012  »
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
2728291234
567891011
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2012 Lee Everest's SQL Server, etc. weblog