02 February,2013 by Jack Vamvas
Justifying a SQL Server version upgrade is easy from a technical perspective. Justifying a an upgrade from a business perspective is more difficult. As a DBA , you need to convince the business of the upgrade value. Keeping up to date with SQL Server version support levels is one tactic to convince business of the upgrade value
A SQL Server upgrade involves costs such as – infrastructure, licensing costs for SQL Server and supporting software such as monitoring agents and skills training for support staff. One method to assist the DBA is to detail the support levels on SQL Server.
The current support level status for SQL Server 2000 and SQL Server 2005 is :
SQL Server 2000 – Extended support will finish on April 19th,2013. This includes no more software updates and security updates
SQL Server 2005 – Extended support started on April 12th ,2011. Security update support remains without any extra cost. Non security hotfixes require an Extended Support Agreement.
Depending on the organisation and the standards they maintain , these dates are important and have cost implications for support. Depending on the application criticality using a product which is completely out of support or has limited support can have cost and reputation implications.