THE SQL Server Blog Spot on the Web

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

The Bit Bucket (Greg Low): IDisposable

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

Denali: Note the small but important things in SSIS

With SQL Server, there often seems to be an over-emphasis on the items that provide bullet points for the marketing brochure. Yet, small but useful changes to the product can make a more profound impact on DBAs/developers than the new items that are highlighted by those bullet points.

One of the things I loved about Reporting Services in SQL Server 2008 R2 is the amount of focus they provided on ease of use. In particular, the addition of data bars, lookup functions, pagination control, rendering targets in expressions, domain scope, etc. made a huge difference to anyone that really needs to build reports.

For Denali, Integration Services has me similarly excited. I've just completed prepping and presenting a session on the Denali enhancements to SSIS (and on the introduction of Data Quality Services) for TechEd Australia. It was interesting to note, though, that the biggest reactions I received from the crowd were for the "little" improvements, not for the big ticket items. Some of the best examples of these are:

  • Zoom control, general UI improvements and the Fit to Window
  • Improvements around the display of precedence labels (great for those who are color blind and struggle with the standard red/green/blue)
  • Toolbox groupings
  • Ease of integrating new items into the Toolbox
  • Reliability and performance improvements around Merge/Merge Join

And there are many more. The two biggest woohoo moments though, came for:

  • Multi-level undo and redo
  • Remapping work that has been done in the data flow (remapping GUI is great but the way that so many mapping issues are automatically fixed is awesome)

I want to congratulate the team on spending time making these type of "less visible" improvements.

Published Sunday, September 11, 2011 2:49 PM 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

Comments

 

Kevin McGuire said:

Thanks Greg!  As one of the folks involved in this work, it's really satisfying to see such a great response. Quality is in the details.

September 15, 2011 4:07 PM
 

amit chauhan said:

Now clicking the errors opens the dialogbox,which is awesome...!!

I think if i copy code block from other package and paste here now variables are also imported(automatically,previously it used to throw error)!

September 26, 2011 4:16 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement