This is a very exciting/confusing/glooming period for SQLServer Developers/DBAs
On one hand there is the ‘cloud’ which will take our precious boxes away from us and we won’t be needed to manage it anymore.
On the other hand is an avalanche of technologies bundled with every release of SQL Server.
Back in the 2000 days all you really needed to know was
Profiler/QA and other tools
I can just see the skills required for a SQL Server DBA these days
SSMS/ Profiler/QA/BI Studio and other tools
With Kilimanjaro this list will only get longer.
Soon your IT shop will look like a hospital.
You need some SSIS with C#? Talk to DBA A
You need some Powershell automation with SMO? Talk to DBA B since DBA A doesn’t know Powershell
You need some DTS? Talk to DBA C because DBA A and DBA B started to use SQL Server with version 2005 (9) and don’t know anything about DTS
Is there really one super DBA who knows all these technologies? I don’t think so; it is time to start specializing. Besides the stuff you absolutely need to know like T-SQL, the internals and maintenance, you will have to pick your direction.
So I ask you the reader: what brings the future for the SQL Server DBA?