seatedElephant (2/5/2014)
Do you think it's possible/desirable to be a specialist in 'a few' fields i.e. data warehousing/SSRS/SSIS? I suppose it's a yes as long as you put the time and effort in?Dave
Its entirely possible, where I work we used to have a seperate division between warehouse and OLTP DBA's until about 12 months ago.
I had warehouse experience prior to my current employer but for others it was quite a steep learning curve as they had to learn the ETL processes and in particular SSIS as they had limited experience. The same went for the warehouse DBA's who had less experience on the HA \ DR and performance tunning side of things. Most of our OLTP systems are customer facing and drive the company website, any outage and our primary revenue source would be affected so knowing the HA \ DR side of things is essential.
MCITP SQL 2005, MCSA SQL 2012