Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!

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 | 14 Comments Filed under: Design Pattern, SQL Server, SSIS

• 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 Read More... Posted Thursday, August 21, 2008 1:41 PM by andyleonard | 0 Comments Filed under: Database Developer, Database Edition, Visual Studio 2008

• 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 Read More... Posted Thursday, August 21, 2008 11:20 AM by andyleonard | 0 Comments Filed under: Database Developer, ETL, SQL Server, SSIS

• 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 | 17 Comments Filed under: SQL Server 2008