August 2008 - Posts

• SSIS Design Pattern - Collect Enterprise SQL Server Database Metadata With SSIS

  Introduction A few months back I received an email from a nice lady who was beginning to work with SSIS. She was trying to use SSIS to automate metadata collection in her enterprise and she had made a good start in the package she attached to the email. Read More... Posted Thursday, August 28, 2008 10:42 AM by andyleonard | 4 Comments Filed under: Design Pattern, SSIS, SQL Server

• Announcing Database Edition CTP16

  Gert Drapers announces the availability of Visual Studio Team System Database Edition CTP 16 ! The Database Edition team is cranking out some cool code - great work team! :{> Andy Share this post: email it! | bookmark it! | digg it! | reddit! | kick Read More... Posted Thursday, August 21, 2008 1:41 PM by andyleonard | 0 Comments Filed under: Database Developer, Visual Studio 2008, Database Edition

• New SSIS 101 Article

  My latest SSIS 101 article - SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers - is live at SQL Server Central today! Enjoy! :{> Andy Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More... Posted Thursday, August 21, 2008 11:20 AM by andyleonard | 0 Comments Filed under: SSIS, Database Developer, SQL Server, ETL

• SQL Server 2008 Management Studio - Function Keys

  F7! The F7 key displays details in SSMS 2008. I'm almost positive SSMS 2005 RTM'd with the same funtionality and it was later removed. F8? I love the F7 key. And I love that it displays details when I highlight something in Object Explorer - which, by Read More... Posted Friday, August 08, 2008 1:17 PM by andyleonard | 9 Comments Filed under: SQL Server 2008