SQL SERVER UPGRADE AND CLOUD STRATEGIESData Management (SQL Server)
1 out of every 2 SQL Server instances will lose extended support in April 2016.
82% of small and midsize organizations are running at least one occurrence of SQL Server 2005. Avoid the business disruptions caused by slow-performing databases and downtime.
End of support can present risks as there will be no new security updates, non-security hot fixes, free or paid assisted support options or online technical content updates. SQL Server offers you a fast, highly available database—and a cloud-ready data platform that will grow with your business. SQL Server 2014 brings in-memory capabilities that dramatically speed transactions, while cloud capabilities make it easy for you to choose where you want to deploy your applications – whether on-premises, in the cloud, or a combination of both.
Migrating to SQL Server 2014
Microsoft SQL Server 2014 has great features that makes upgrading a compelling choice.
Features in Microsoft SQL Server 2014 are a compelling reason to upgrade.
- Resource Governor for I/O. In addition to governing and managing CPI and memory, the Resource governor now manages I/O requests
- Backup enhancements. With this release, backups can be encrypted. Azure can also be used as a target for backups.
- Managed backups. Small and medium-sized businesses will find this new capability beneficial. It offers a simple “set it and forget it” model of backing up and eliminates the need for a backup expert.
- Increased resource limits. In the Standard edition support doubles from 64 GB to 128 GB.
- In-memory OLTP Engine. Certain tables and stored procedures can be moved into RAM to improve performance. Introduced with SQL Server 2012, this high-availability and disaster-recovery solution improves upon what database mirroring and failover clustering offer.
- Azure integration. Move all your data to the cloud, or choose a hybrid solution.
- Updateable columnstore index. Improving upon the memory-optimized columnstore index feature introduced in SQL Server 2012, this feature offers the same query performance improvements, but the columnstore is now a pure columnar store, so indexing is no longer required.
- Buffer pool extensions. In some cases, SSDs can be used to expand the buffer pool when systems run out of memory.