Less than two years after the release of SQL Server 2012, Microsoft is offering SQL Server 2014. The latest SQL version is an improved database with numerous features and enhancements, including increased availability and scalability, streamlined cloud integration and columnar indexes. One of the most talked-about features is its expanded in-memory OTLP capabilities which “turbo boost” transaction speeds. Despite all the enhanced features of Microsoft SQL Server 2014, many database administrators (DBAs) are still considering whether or not they should upgrade. Read on to learn more about the concerns and benefits they have for migrating to Microsoft SQL Server 2014.
DBAs cite cost and support as key factors when considering Microsoft SQL Server 2014
Depending on the size and complexity of their existing environment, DBAs need to factor in budget and resources to upgrade to SQL Server 2014. And as one DBA succinctly put it, “Microsoft needs to remember that a lot of decision makers who control corporate budgets aren’t database administrators.”
Other DBAs who are still using an older version of SQL Server may not know which upgrade is the best fit for their organizations. Those who operate with lean IT departments may also be concerned about how much training will be necessary to get their teams up to speed on the latest features of SQL Server 2014.
As a result, many DBAs are sticking with their tried-and-true SQL Server 2000 and SQL Server 2012 environments. But here’s the thing – SQL Server 2000 is completely out of support and SQL Server 2012 will be out of support soon. And this is where Murphy’s Law comes in – as soon as a DBA’s SQL Server environment is no longer supported, something will go wrong – and it will be expensive to fix.
Successful databases require upgrades
Whether or not DBAs agree with Microsoft’s aggressive release-and-improvement cycle, holding off on implementing upgrades and improvements can be detrimental to the performance of any database. DBAs should also keep in mind that the effort to upgrade from SQL Server 2000 to 2014 will entail a lot more time and resources than upgrading from SQL Server 2012 to 2014. And if they need to outsource database expertise, they will have an easier time finding the right experience, support and documentation if they are upgrading from a more recent version.
Microsoft SQL Server 2014 combines high performance with faster data insights
As we discussed in our previous blog, 4 Reasons to Deploy Microsoft SQL Server 2014, SQL Server 2014 delivers numerous features to help companies realize mission-critical performance across all workloads including:
In-memory built-in across all workloads
- In-Memory OTLP – provides up 30x faster transactions
- In-Memory Column Store – provides over 100x query performance gains
- In-Memory Analytics – processes billions of rows in seconds
Robust hybrid cloud platform
Microsoft SQL Server 2014 from HOSTING supports hybrid IT environments with common tools and the ability to extend applications directly to HOSTING public and private cloud offerings, including those built on the Microsoft Azure Pack. High speed In-Memory processing, available for both hosting private and hybrid cloud environments, accelerates data-driven applications and reduces latency.
Combined with HOSTING’s world-class infrastructure and support services, Microsoft SQL Server 2014 from HOSTING delivers AlwaysOn access 24 x 7 x 365. Database access and resiliency is assured with failover clustering, active/passive secondary instances and rapid recovery from scheduled or unscheduled downtime. HOSTING backs this solution with industry-leading service level agreements (SLAs).
Microsoft SQL Server expertise from HOSTING
HOSTING Microsoft SQL Server Database experts offer a full suite of database migration and integration services including upgrades and improvements to hardware, applications, operating systems and database management systems. HOSTING database experts seamlessly integrate with organizations’ existing IT resources to help them upgrade their databases while ensuring maximum performance.
Have questions about Microsoft SQL Server 2014? HOSTING stands ready to help. Contact us anytime to talk about your data management goals. Download our complimentary report, The Disruption Epidemic: How Poor Microsoft SQL Server Deployments Put Businesses at Risk . . . and What You Can Do About It, to get you on the right track.