THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Greg Low (The Bit Bucket: IDisposable)

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

SQL Server 2008 R2 Idea: Data Profiling of any table in SSMS

I love the data profiling task that was added to SSIS in SQL Server 2008. It allows you to get a profile of the data in a table - this includes things like what are potential candidate keys, what length are the data values in each column, what percentage of rows in a table are null in each column, what is the distribution of values in the data, etc. etc.

If you haven't used it, I'd suggest taking a look at it. It's a real hidden gem in the product.

However, I think they missed the #1 place that this sort of functionality would be useful. Imagine if you could just right-click a table in Object Browser in SQL Server Management Studio and say "Profile this table...". That would be so insanely cool.

If you think so too, you know you want to vote for this at:

Published Wednesday, October 6, 2010 11:56 AM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


This Blog



No tags have been created or used yet.


Privacy Statement