Day 20 of my virtual advent calendar, about stuff I like in SQL Server 2008..
The accidental DBA is a DBA who ends up looking after SQL Server as part of a number of other duties e.g. Exchange admin, developer etc. This often occurs because SQL Server can survive pretty well despite long periods of neglect, but then suddenly something goes wrong and then someone gets nominated to look after it post fix.
As databases grow in complexity and size they do eventually need some attention, and some tasks can be bit daunting if you not immersed in SQL Server every day. There are excellent add on tools from the likes of Idera, Quest and Redgate to ease the management burden, but SQL Server 2008 itself has a few things to help with this:
A lot of this stuff (Policy Management, Central Management Servers, Powershell) will work against SQL Server 2000/2005 so all you need to do get started is to have one instance of SQL Server 2008 as a base (for the Central Management Server) or just the client tools for the rest.