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

  I have renamed a table which was involved in table partition, After rename, partition function points to new name. Will there be any issues in long run during switchout or drop old partition when a table is renamed in Partition. I haven't tested it as the table has more than 100 million records Please suggest. Regards Suresh kumar

Dear Sirs I am fairly new to Data Warehouse environment , but was working with Sql Server since long I tried looking for these ans on the web but not getting it pls help me with these with some good example/websites my email: anksin@yahoo.com  What is the size of your datawarehouse ?How many data marts does it contain ?What is the size of ...

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