skip to main content
Close Icon We use cookies to improve your website experience.  To learn about our use of cookies and how you can manage your cookie settings, please see our Cookie Policy.  By continuing to use the website, you consent to our use of cookies.
Global Search Configuration


SQL Server 2016 highlights encompass advanced analytics leveraging PolyBase and in-database R support; expanded in-memory options; a new phased migration option to the cloud; and several security features that make data protection more granular.


  • The Stretch Database capability represents a breakthrough for phasing migration of individual databases to the cloud, but as a first-generation technology, it is feature-incomplete.

Features and Benefits

  • Provides a first-look assessment of Microsoft SQL Server 2016.
  • Compares new SQL Server 2016 features to those of leading rivals, including Oracle, DB2, and Teradata.

Key questions answered

  • What is the readiness of the new Stretch Database feature?
  • How do new enhancements to analytics and BI compare to what IBM, Oracle, and Teradata offer?

Table of contents


  • Catalyst
  • Ovum view
  • Key messages


  • Recommendations for enterprises
  • Scope

Extensibility is a core theme

  • "Stretching" to the cloud
  • Extending to mobile analytics
  • A new focus on advanced analytics
  • Riding the in-memory wave
  • Extended JSON support: Not a MongoDB killer

Stepping up security

  • Hear no evil, see no evil: Always-on encryption shifts protection to the client
  • Data access getting more granular

Rounding out the platform

  • Scaling
  • Keeping the trail of breadcrumbs
  • Linux will wait


  • Methodology
  • Further reading
  • Author

Recommended Articles

  • Service Provider Markets, Consumer & Entertainment Services,...

    MWC 2018 Highlights

    By Ronan De Renesse 27 Feb 2018

    Over 20 of our senior Ovum analysts and consultants attended this year’s Mobile World Congress in Barcelona at the end of February. In between meetings, briefings and presentations, our analyst team were blogging and tweeting about key developments, trends and rumors. Have a look through our daily MWC 2018 Highlights to find out what happened.

    Topics 5G AI IoT Cloud Payments SDN/NFV Smart home

  • Consumer & Entertainment Services

    US pay TV: Is it facing an existential threat?

    By Adam Thomas 28 Mar 2018

    With US pay TV having endured the worst year in its history, thoughts have inevitably turned to the future. The likelihood remains that the immediate future will remain highly uncomfortable for everyone except the scaled multinational digital platforms.

  • Enterprise Decision Maker, Enterprise IT Strategy and Select...

    2017 Trends to Watch: Big Data

    By Tony Baer 21 Nov 2016

    The breakout use case for big data will be fast data. The Internet of Things (IoT) is increasing the urgency for enterprises to embrace real-time streaming analytics, as use cases from mobile devices and sensors become compelling to a wide range of industry sectors.

    Topics Big data and analytics IoT


Have any questions? Speak to a Specialist

Europe, Middle East & Africa team - +44 (0) 207 017 7700

Asia-Pacific team - +61 (0)3 960 16700

US team - +1 646 957 8878

Email us at

You can also contact your named/allocated Client Services Executive using their direct dial.
PR enquiries - Call us at +44 788 597 5160 or email us at

Contact marketing -

Already an Ovum client? Login to the Knowledge Center now