As we might find SQL Server 2008 on our horizon, still for years to come we will be working on SQL Server 2005. This is not only because the use of SQL Server has increased by leaps and bounds with SQL Server 2005 in almost all application in most of the domains, but also because there is lots still to be explored in MS SQL Server 2005. I am quite sure the development team at the Microsoft-end did not anticipate this overwhelming response to the product and the power they have unleashed. On another point of view, with the release of SQL Server 2008, I am sure, there is quite a lot of difference that is going to be brought about about how we anticipate its features, specially virtualization.
Also, there are few places, like the replication, where the team can work out to avoid re-initialization of the whole publication for a few articles, and a bit of care for prevention of errors due to setup of replication with scripts.
It is evident, from the above points that, there are few places which can be improved, to make it better in it's version. This will not only help us DBAs, but will also appease the requirements of the companies, so as to retain customers who would prefer to migrate to any other RDBMS than to MS SQL Server 2008, speaking from business point of view.
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.