I’m really really pleased to announce that it’s possible to register to the Data Warehouse Workshop that I and Thomas Kejser developed togheter.  Several months ago we decided to join forces in order to create a workshop that would contain not only the theoretical stuff, but also the experience we both have and all the best practices and ...

Yesterday has been published my Q&A interview on my Pre-Conference Workshop at SQL Pass 2012. It’s a good way to understand what will be discussed in the workshop, so if you’re interested or you’re into the Data Warehouse / Business Intelligence field and want to understand how the Agile approach can help you, you can read it ...

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 ...

I’m very pleased to announce that I’ll be delivering a Pre-Conference at PASS Summit 2012. I’ll speak about Business Intelligence again (as I did in 2010) but this time I’ll focus only on Data Warehouse, since it’s big topic even alone. I’ll discuss not only what is a Data Warehouse, how it can be modeled and built, but also how it’s development ...

I’m very happy to announce that my proposal for the Spotlight session I’ve been invited to deliver at PASS 2011 has been accepted! Temporal Snapshot Fact Table You are designing a BI Solution and your customer ask you to keep a snapshot of the status of all their documents (orders, insurances, contracts, bills...whatever the word ...

I am honored to present Part 4 of 4 of Building a Scalable, Enterprise-Class Data Warehouse for SQL Server Wednesday, 20 Oct 2010! This presentation features a demo of expressor 3.0 studio by Steve Frechette, expressor's Vice President of Engineering. It's going to be fun and I hope to see you there! :{>

Introduction  The tenth Richmond Code Camp was held today at the J. Sargeant Reynolds Community College campus on Parham Road. It. was. awesome! With 40 sessions and over 400 registered, this #RichCC was arguably the best one yet! There's a lot that goes into planning an event of this magnitude. I commend the Code Camp Leadership Team for ...

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 ...

This came out on the Microsoft website. I have not had time to look over the hardware configuration carefully. Of course the recommended storage is a SAN, vendors love to sell very high margin products when there are perfectly good merely high margin alternatives. Well atleast this one looked at sequential disk IO bandwidth, unlike past ...