SQL Server 2005 was a huge leap forward in manageability and features when it was released 10 years ago. Microsoft's Corporate Vice President, Data Platform, T.K. Rengarajan, posted a friendly reminder this week that extended support for SQL Server 2005 will end on April 12, 2016 - less than 12 months away.
What does that mean? SQL Server 2005 instances will continue to run. However, there will be no new hotfixes and no more security updates. Any vulnerabilities discovered will not be patched. That alone is reason to consider upgrading, but also think about all of the new features available to you in newer versions of SQL Server.
Since 2005, SQL Server has debuted
- Extended Events
- Policy-Based Management
- Resource Governor
- AlwaysOn Availability Groups
- In-Memory OLTP
- Buffer Pool Extensions
- Backup compression
- Data compression
- SSISDB catalog
- A constantly-evolving set of business intelligence tools
- ...to name only a few!
Now is the time to identify your remaining SQL Server 2005 instances, review the application and database requirements, and being working on your upgrade plan. Need help? Contact the SQL Server experts at Concurrency today.