CEI Expert Breaks Down SQL Server 2016

SQL Server 2016 is the latest addition to Microsoft’s data platform with a variety of new features, enhancements and benefits. Whether you are using SQL Server on-premises or in the cloud, CEI’s SQL Architect, Steve Grier, breaks down everything you need to know about the major changes in the data platform.

Introducing Microsoft SQL Server 2016 – get your free e-book today!

SQL Server 2016

  • Performance benefits over previous SQL Server versions for the same workloads
  • New features added to greatly improve performance for some specific workloads (In memory table optimizations, columnstore indexes, temporal tables, JSON support, R services)
  • New hybrid features to extend on-prem solutions without significant migration costs (PolyBase, Stretch db, managed backups, snapshot backup to blob storage, striped backup to blob storage, azure credential improvements)
  • Better maintainability (Query Store, live query statistics, system view improvements)
  • Better security (Always Encrypted, better performing transparent data encryption, database scoped credentials)
  • Significant improvement to SSRS (cross browser support, mobile reporting, KPI tiles, PowerBI integration*)

SQL Azure

  • Most database features available in SQL Server 2016 also available in SQL Azure
  • PaaS for the database significantly reduces cost and cost scaling
  • Geo-Redundant as a check-box
  • Available in minutes
  • Minimal cost at bottom tiers for testing, scale up to production whenever
  • DTU’s are confusing at first, but provide a measure of scale that is predictable in large or small quantities
  • Great for rapid prototyping and per developer databases.

Support Matrix for end of support:


  • SQL Server 2005 – Completely out of support now
  • SQL Server 2008 – Extended support ends in July 2017
  • SQL Server 2012 – Mainstream support ends July 2017; Extended support ends July 2022
  • SQL Server 2014 – Mainstream support ends July 2019; Extended support ends July 2024
  • SQL Server 2016 – Mainstream support ends July 2021; Extended support ends July 2026

End users must make sure production workloads are migrated prior to end of extended support!  Assistance is not available from Microsoft after that date. CEI’s recommendation is to migrate before end of mainstream support.

Essentially, anyone that isn’t currently on 2014 should be talking to someone about migrating.  CEI can give an order of magnitude of your potential migration costs.

Introducing Microsoft SQL Server 2016 – get your free e-book today!


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 )

Connecting to %s