SQL Server 2005 – End of Support
Extended support for SQL Server 2005 is ending on the 12th of April 2016. At this point, all support for SQL Server 2005 will stop.
This blog takes a look at the impact this could have on your business and also the benefits of migrating to SQL Server 2014. The end of support of SQL Server 2005 is a great opportunity to modernise your data platform and infrastructure.
Risks of SQL Server 2005
The end of support means no more security updates, higher maintenance costs and potential compliance concerns:
No security updates: many critical updates were released with SQL Server 2005 under support. No updates will be developed or released after end of extended support.
Higher maintenance costs: staying put could cost more in the long run. There will be additional costs, for example, intrusion detection systems, more advanced firewalls and network segregation, all in order to isolate SQL Server 2005 databases.
Compliance concerns: lack of compliance with various standards and regulations can have an adverse effect on your business. This could include regulatory and industry standards no longer being achieved.
If you haven’t already, now is the time to start planning your migration. You will benefit from the security features and reliability that you have experienced over the last decade with SQL Server 2005 along with the added functionality available in SQL Server 2014.
Benefits of SQL Server 2014
If you are running on an earlier version than SQL Server 2014 then here are some of the benefits you can achieve by upgrading-
- Performance gains: benchmarks show SQL Server 2014 performs 13x faster compared to SQL 2005 and 5.5x faster compared to SQL Server 2008.
- Additional speed: using in-memory technologies for OLTP, data warehousing and analytics.
- Patching and maintenance: simplified process with greater online operations.
- High Availability: easier than ever before.
- Business Intelligence: number of enhancements have been made since SQL Server 2005.
- Scalability: scale across compute, networking and storage with Windows Server.
- Security: encryption, key management, auditing and separation of duties.
- Manageability: improved with policy based management, distributed replay, improved performance tuning and Windows PowerShell support.
Speak to a member of the Frontline Team today to find out more.