SQL Server 2008 R2 and Data Warehouse

  • I have been working with Data Warehousing and Oracle for many years as both a DBA and ETL developer. This year I've started working with Data Warehouse on SQL Server 2008 R2. And I have just been asked to perform some database administration for the data warehouse. I'm working my way through a Microsoft Press SQL Server database administration book. I've been searching the internet for best practices regarding implementing, monitoring, maintenance and backup/recovery of SQL Server to achieve optimum performance and reliability of a data warehouse. There is a lot of good information out there however I'm not finding much specific to data warehouse. Would any of you have suggestions of books, whitepapers, websites or training where I can get data warehouse specific database administration knowledge.

    Thanks!

    Nancy

  • Hi,

    To get the right solutions you just need to get the Certified training and certifications. You can find the bookmybootcamp for IT training courses.

    thanks

    karam

  • Most of what you need you can find @BOL

    you could also checkout

    http://www.ssas-info.com

    Analysis Server administration resources are rare compared to SQL engine administration most of it was trail and error for me.

    Jayanth Kurup[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply