Microsoft Community Launch Greenville, SC

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.

1. http://blogs.conchango.com/jamiethomson/archive/2008/03/02/ssis-data-profiling-task-part-1-introduction.aspx


2. 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 Tablix
http://prologika.com/CS/blogs/blog/archive/2007/08/12/tablix-the-crown-jewel.aspx