Subscribe: Search results matching tags 'SQL Server 2008' and 'Business Intelligence'
http://sqlblog.com/search/Searchrss.aspx?o=DateDescending&tag=SQL%20Server%202008,Business%20Intelligence&orTags=0
Preview: Search results matching tags 'SQL Server 2008' and 'Business Intelligence'

Search results matching tags 'SQL Server 2008' and 'Business Intelligence'



Search results matching tags 'SQL Server 2008' and 'Business Intelligence'



 



Speaking at Philly Code Camp 2008.2 Saturday

Thu, 15 May 2008 06:31:00 GMT

I will be presenting Change Data Capture, Incremental ETL, and SSIS 2008 to Philadelphia Code Camp 2008.2 Saturday, 17 May 2008!

The good folks in Philadelphia always do a great job with Code Camps and the attendance numbers are growing to reflect that! They're sold out again. Great job!

:{> Andy




SSIS 2008 Data Profiling Task

Thu, 13 Mar 2008 06:01:00 GMT

Jamie Thomson has posted a great series on the SSIS 2008 Data Profiling Task.

The Data Profiling Task allows developers to quickly assess key statistics about data in a database table. When I say "statistics" I mean things like column value and length distribution, column null ratio, column patterns, and functional dependencies. You can learn more in Jamie's series or at MSDN.

One very cool feature is the ability to set up a Single Table Quick Profile to quickly configure and capture desired statistical data.

Once you capture the data, you use a separate stand-alone tool for viewing the results: the Data Profile Viewer.

SQL Server 2008 CTP6 (February 2008) includes a functioning version of the Data Profiling Task in SSIS 2008.

:{> Andy