Webinar Schedule
Webinar Series: Data Warehousing
Review SQL Server authors and MVPs on demand webinar series and get the latest on Microsoft Business Intelligence inside your environment. If you are in any stage of a data warehouse design, administration or planning these webinars on demand are a must. This series is brought to you by SQLServerCentral.com, in partnership with Wrox and
Pragmatic Works.
In these sessions you will learn how to design a data warehouse, load it using SSIS, place a cube on top of it using SSAS and report against it using SSRS. Finally, you'll see how to performance tune and scale the data warehouse using common techniques. All speakers have authored many of your favorite books from Wrox.
|
Download
Slides
View Recording
|
Designing a Data Warehouse
Featuring: Joy Mundy

|
Topic Summary:
Improve the speed of your production can be as easy as giving your users a new
place to report against. In this session, you'll learn how a data warehouse can
benefit your organization and how to design one for SQL Server. You'll also see
at a high level how the data flows into the warehouse in a Microsoft data
warehouse ecosystem. |
|
Download Slides
View Recording
|
Loading a Data Warehouse with SQL Server Integration Services (SSIS)
Featuring: Brian Knight
 |
Topic Summary:
Now that you have a data warehouse designed, how would you go about loading the
warehouse from your relational database that has been in production for years.
Join Microsoft MVP and author Brian Knight in this session on how to use SSIS to
load and synchronize a data warehouse. |
|
Download Slides
View Recording
|
Introduction to Analysis Services (SSAS)
Featuring: Siva Harinath
 |
Topic Summary:
Tired of having to write hundreds of one-off reports? SQL Server Analysis
Services (SSAS) can help clear your report backlog by giving your users the
ability to perform ad-hoc reporting with pivot tables. Learn how to create a
SSAS cube, how to process it and finally view quick reports to answers questions
you didn't even know you had about your business. |
|
View Recording
Download Slides
|
Introduction to Analysis Services (SSAS)
Featuring: Denny Lee
 |
Topic Summary:
Tired of having to write hundreds of one-off reports? SQL Server Analysis
Services (SSAS) can help clear your report backlog by giving your users the
ability to perform ad-hoc reporting with pivot tables. Learn how to create a
SSAS cube, how to process it and finally view quick reports to answers questions
you didn't even know you had about your business. |
|
View Recordings
Download Slides
|
Reporting against a Data Warehouse with SSRS
Featuring: Paul Turley
 |
Topic Summary:
In this session, you'll learn how to report against your data warehouse and SSAS
cubes by using Reporting Services 2008. Learn what's new and easy ways to
visualize data warehouse data in this comprehensive session for beginners. |
|
View Recording
Download Slides
|
Performance Tuning and Scaling a Data Warehouse
Featuring: Adam Jorgensen

|
Topic Summary:
Some of the largest databases in the world are data warehouses, scaling to
dozens (or hundreds) of terrabytes in some cases. In this session, you'll
explore how to make your SQL Server 2008 database scale and easy ways to
diagnose and troubleshoot problems. You'll learn how to performance tune and
scale the hardware to the OS in this vital session for most organizations. |