Here are links from my presentation on new features in SQL Server 2008 Business Intelligence.
Data Profiling
For this demo the following blog posts were combined.
- http://blogs.conchango.com/jamiethomson/archive/2008/03/02/ssis-data-profiling-task-part-1-introduction.aspx
- http://agilebi.com/cs/blogs/jwelch/archive/2008/03/11/using-the-data-profiling-task-to-profile-all-the-tables-in-a-database.aspx
From John Welch's post the tables are limited to the following from Jamie's post.
- SSIS: Data Profiling Task: Part 2 - Column Length Distribution
SSIS: Data Profiling Task: Part 8 - Candidate Key
[HumanResources].[Department].[GroupName] - SSIS: Data Profiling Task: Part 3 - Column Null Ratio
[Person].[Contact].[MiddleName] - SSIS: Data Profiling Task: Part 4 - Column Pattern
[Production].[Product].[ProductNumber] - SSIS: Data Profiling Task: Part 5 - Column Statistics
[Sales].[SalesOrderDetail].[UnitPriceDiscount]
Katmai: SSIS: Lookup component gets a makeover
http://blogs.conchango.com/jamiethomson/archive/2007/11/16/Katmai_3A00_-SSIS_3A00_-Lookup-component-gets-a-makeover.aspx
Star Schema Performance
http://technet.microsoft.com/en-us/magazine/cc434693.aspx
Reporting Services
Teo Lachev’s blog: http://prologika.com/CS/blogs/blog/archive/2007/08/29/under-the-hood.aspx
Enterprise Scale Reporting webcast: https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=6082
SQL 2008 BOL
http://msdn.microsoft.com/en-us/library/bb630410(SQL.100).aspx
Analysis Services
What's New (Analysis Services - Data Mining):
http://msdn2.microsoft.com/en-us/library/bb510513(SQL.100).aspx
Introducing the SQL Server 2005 Data Mining Add-ins for Office 2007
http://www.sqlserverdatamining.com/ssdm/Home/DataMiningAddinsLaunch/tabid/69/Default.aspx
Advanced Manageability for Analysis Services 2008 webcast: http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032352698&Culture=en-US
Advanced Manageability for Analysis Services 2008 webcast: http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032352698&Culture=en-US
Teo Lachev’s blog: http://prologika.com/CS/blogs/blog/archive/2007/08/29/under-the-hood.aspx
Enterprise Scale Reporting webcast: https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=6082
Reporting Services Tablixhttp://prologika.com/CS/blogs/blog/archive/2007/08/12/tablix-the-crown-jewel.aspx