some DW links:
MSDN Dimensions (http://msdn.microsoft.com/en-us/library/aa905979(v=sql.80).aspx)
Channel 9 Video (http://channel9.msdn.com/Blogs/rdoherty/Presentation-Loading-Fact-and-Dimension-Tables-in-a-SQL-Server-2008-R2-Integration-Services-Package)
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at: