For the past two years, I have had the honor and privilege or authoring SSIS Design Patterns alongside Jessica Moss, Michelle Ufford, Tim Mitchell, and Matt Masson. Publication of the book – like many projects of this scope – has been delayed. The current publication date is 27 Aug 2012 and I have high confidence in this date. I take ...

In the third part of our series on building a scalable, enterprise-class data warehouse for SQL Server, expressor's (blog | @expressor) Mike Ruland (@mruland) and I present Why Consider Semantic Integration Thursday 29 Sep 2010 at 12:00 PM EDT. Semantic rationalization is a natural progression from metadata management; ...

In the second part of our series on building a scalable, enterprise-class data warehouse for SQL Server, expressor's (blog | @expressor) Mike Ruland (@mruland) and I present the importance of good metadata management tomorrow at 12:00 PM EDT. Metadata is important and hard to manage. Mike and I define metadata and talk about the many places ...