SQL Server 2005 Support Ends Today

Its Time To Upgrade!

rip-sql-server-2005-time-to-move-on-1-638

As announced by Microsoft, support for SQL Server 2005 ends today. This means that Microsoft is no longer releasing any security updates, hotfixes and patches for SQL Server 2005. For organizations this means that when support is stopped it becomes increasingly risky to keep storing important mission critical data on an unsupported platform. Hence its time to upgrade to SQL Server 2014 and here are a few reasons to do so.

1. Options. Modernizing your data platform is not an all-or-nothing venture. Microsoft offers a unique level of flexibility — you can update your existing servers, run SQL Server 2014 on virtual machines in the cloud, or implement a combination of both. SQL Server 2014 is designed to work the same on-premises or in the cloud, creating consistent hybrid environments. New tools in SQL Server make it even easier to build backup and disaster recovery solutions with Microsoft Azure. These tools also provide an easy on ramp to the cloud for on-premises SQL Server databases, enabling customers to use their existing skills to take advantage of Microsoft’s global data centers. For more about the pros and cons of different migration options, download Migrating from SQL Server 2005.

2. ROI. You may think the least expensive option is sticking with what you’ve got. Not so. Modernizing your data platform is a wise business investment. According to a July 2014 Microsoft commissioned study from Forrester on the Total Economic Impact of SQL Server, businesses achieved a 9.5-month payback when migrating to SQL Server 2014 and a 113 percent ROI, in part from a 20 percent improvement in IT resource productivity.

3. Performance. SQL Server 2014 has been benchmarked to be 13 times faster than SQL Server 20051 and 5.5 times faster than SQL Server 2008.2 And that’s before the incredible performance gains available with in-memory technology. In-memory OLTP delivers, on average, 10 times faster transaction processing — and in some cases up to 30 times faster. For data warehousing, the new updatable in-memory columnstore can query 100 times faster than legacy solutions. And, SQL Server 2014 is better together with Windows Server 2012 R2, which allows scale up across computing, networking and storage — up to 640 logical processors.

4. High availability. In SQL Server 2014, AlwaysOn availability groups are better than ever with up to 8 readable secondaries and synchronous or asynchronous commit modes. When it comes to high availability, SQL Server 2014 delivers the high 9s you need for your mission-critical applications.

5. Security and compliance. When it comes to data security, there have been significant changes since 2005. SQL Server 2014 was engineered for security from the ground up. Features such as security roles for separation of duties, full-featured auditing and transparent data encryption make it possible for any organization to meet its regulatory compliance standards, such as PCI-DSS for credit card transactions, HIPAA for medical patient privacy, and GLBA for financial institutions. SQL Server has had the least vulnerabilities of any major database the past six years running, as tracked by the National Institute of Standards and Technology.

Do You Require Training?

At LGIT Smart Solutions, we offer both instructor-led and virtual on-demand training for SQL Server 2012, Sql Server 2014 and a Preview of the soon to be release SQL Server Server 2016.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s