|Microsoft Data Warehousing and Data Quality|
Microsoft Data Warehousing and Data Quality solutions come from the world-class SQL Server Integration Services (SSIS) technology.
This webpage provides links for videos and other online resources.
|TechNet Webcast: 24 Hours of SQL Server 2008: Streamlining Data Integration (Level 200) -- VISIT|
| Hits: 70||Updated:|
Wed 05/28/2008 @ 12:00
May 28, 2008 (90 minutes)
To load data into the Contoso enterprise data warehouse, Contoso uses Microsoft SQL Server 2008 Integration Services. In this webcast, we review the new features in Integration Services that help Contoso streamline the development and execution of processes to extract, transform, and load data into the data warehouse: ADO.NET connectivity, persistent lookups, pipeline improvements, and data profiling. We also examine alternatives for managing changing data in the data warehouse using the Change Data Capture function and MERGE command. Demonstrations on using an ADO.NET data source, working with lookup caches, identifying dirty data with data profiling, and using Change Data Capture and MERGE for slowly changing dimensions are included in this webcast.
|TechNet Webcast: SQL Server 2008 (Part 2 of 3): Manage Large-Scale Data Warehousing (Level 300) -- VISIT|
| Hits: 34||Updated:|
Mon 05/12/2008 @ 12:00
May 12, 2008 (60 minutes)
Attend this session to learn how to incorporate the new features in Microsoft SQL Server 2008 to manage large-scale data warehouses that can scale to larger number of users and growing volumes of data. In this session, we cover new technologies like Resource Governor, data compression, and enhanced indexed views.
|TechNet Webcast: 24 Hours of SQL Server 2008: Data Warehousing Scale and Performance (Level 200) -- VISIT|
| Hits: 15||Updated:|
Mon 05/05/2008 @ 12:00
May 5, 2008 (90 minutes)
The foundation of [fictional company] Contoso's business intelligence (BI) strategy is the development of a data warehouse using Microsoft SQL Server 2008. Scalability and performance of the data warehouse are important for the successful deployment of Contoso's enterprise data warehouse. In this webcast, we cover the new features in SQL Server 2008 that support Contoso's goals, such as:
- Partition-aligned indexed views.
- Star join query optimization.
- Data compression.
- Partitioned table parallelism.
- Grouping sets.
|TechNet Webcast: SQL Server 2008 (Part 3 of 3): Integrate Growing Data Volumes (Level 300) -- VISIT|
| Hits: 5||Updated:|
Mon 02/25/2008 @ 12:00
February 25, 2008 (60 minutes)
Attend this session to learn how to integrate growing volumes of data with the new enhancements in Microsoft SQL Server 2008. We cover new technologies, like Change Data Capture and MERGE SQL statement, in addition to scalability improvements in SQL Server Integration Services, like lookup enhancements and data profiling.
|MSDN Webcast: geekSpeak Extending SQL Server Integration Services with Reza Madani (Level 100) -- VISIT|
| Hits: 13||Updated:|
Wed 02/13/2008 @ 12:00
February 13, 2008 (60 minutes)
Reza Madani shows you tips for extending Microsoft SQL Server Integration Services (SSIS) with scripts. He also takes your questions about the most effective use of this powerful tool for implementing extract, transform, and load (ETL) processes in Business Intelligence (BI) solutions. Your hosts for this geekSpeak will be Lynn Langit and Glen Gordon.
|TechNet Webcast: SQL Server 2008 (Part 1 of 3): High-Performance Data Warehousing (Level 300) -- VISIT|
| Hits: 4||Updated:|
Thu 02/07/2008 @ 12:00
February 7, 2008 (60 minutes)
Attend this session to learn how to incorporate the new features in Microsoft SQL Server 2008 to provide a high-performance data warehouse that can scale to larger number of users and growing volumes of data. In this session, we cover new technologies like partitioned table parallelism, star join query enhancements, and Grouping Sets.
|TechNet Webcast: Going Beyond Relational Data with Microsoft SQL Server 2008 (Level 200) -- VISIT|
| Hits: 2||Updated:|
Mon 07/30/2007 @ 12:00
July 30, 2007 (60 minutes)
As the data your applications work with changes from "words and numbers" to "sights and sounds," we are evolving our data platform to go beyond relational data, beyond online analytical processing (OLAP), to truly support all of the digital data types of the future. We strive to deliver the best platform for integrated storage and advanced applications, such as spatial data. We also make it dramatically easier for you to build data-driven applications, without needing to invest significant resources to bridge the gap between data and programming language data structures. Join this webcast to learn about the new enhancements in Microsoft SQL Server 2008 that can help you manage all types of data.
|TechNet Webcast: Data Warehousing Enhancements in Microsoft SQL Server 2008 (Level 200) -- VISIT|
| Hits: 4||Updated:|
Thu 07/26/2007 @ 12:00
July 26, 2007 (75 minutes)
Join this webcast to learn about the enhancements for data warehousing in the next version of Microsoft SQL Server. We discuss how Microsoft SQL Server 2008 provides a comprehensive, scalable data warehouse platform that enables you to quickly build a data warehouse. By integrating all relevant data into a comprehensive warehouse platform, SQL Server 2008 empowers you to manage your growing data volumes with an enterprise-ready relational database and deliver actionable insights with the integration of the Microsoft Business Intelligence (BI) platform.
|MSDN Webcast: geekSpeak: Real World SQL Server Integration Services Stories with Matthew Roche (Level 200) -- VISIT|
| Hits: 0||Updated:|
Wed 07/25/2007 @ 12:00
July 25, 2007 (61 minutes)
MSDN geekSpeak is a new kind of webcast series, hosted by Glen Gordon and Lynn Langit from the MSDN Events team. Dispensing with slide decks and scripted demos, geekSpeak webcasts bring you industry experts in a "talk-radio" format. These experts share their knowledge of and experience with a particular developer technology. Hear about industry trends, new technology, real-world experiences, and more. During the webcast, you can have your questions answered in real time, hear a lively discussion and debate, and add your comments to the fray. Who knows, you might even see a whiteboard sketch or an off-the-cuff demo. This is another way for you, the developer, to engage with Microsoft in an interesting and effective way! In this installment of geekSpeak, Matthew Roche shares some real-world stories of using Microsoft SQL Server Integration Services (SSIS).
|Creating a high impact Data Warehouse - II -- VISIT|
| Hits: 6||Updated:|
Tue 07/10/2007 @ 12:00
July 10, 2007 (45 Minutes)
SQL BI Product Manager, Microsoft Corporation
In this session, we'll also show you best practices for upgrading to SQL Server 2005 Analysis Services, and how to design your Analysis Services objects for enterprise scalability and performance. We will also cover a lot of new management abilities introduced in this version that will help you more easily manage your production servers.
|Creating a high impact Data Warehouse - I -- VISIT|
| Hits: 26||Updated:|
Mon 07/09/2007 @ 12:00
July 9, 2007 (45 Minutes)
SQL BI Product Manager
SQL Server Integration Services is a robust, scalable, high performance ETL tool in SQL Server 2005. In this session, we'll show you how you can use Integration Services in a wide range of applications to solve large scale data integration and transformation challenges.