Thanks for the reply Jason. I'm kind of following that advice already so it's good to here I'm on the right track. I'm making sure I try to keep an idea of what is happening and what is possible in as many aspects of SQL Server as possible through PASS, etc. but more about a few elements mainly data warehouse related, as this is my role mainly. I think going as deep as possible into SSIS and SSRS may be the way to go for me as I will be able to get practical experience of these as well.

The funny thing (if that's the right word for it) is as we are such a small department I'm also tasked with backup and recovery of the warehouse, so I do definitely need a more rounded knowledge.

Cheers,

Dave