Microsoft Announces SQL Server 2016 SP1

Microsoft announced the availability of SQL Server 2016 Service Pack 1 (SP1), today. With SQL Server 2016 SP1, Microsoft is making the key innovations more accessible to the developers as well as to the organizations across SQL Server editions; hence, it will be easier than before to build advanced applications which scale across editions. Developers and application partners will now be able to build to a common programming surface across all editions while creating or upgrading intelligent application.
 
Image Source: blogs.technet.microsoft.com
 
Microsoft states,
 
“With SQL Server 2016 SP1, we want to make it easier than ever for developers and partners to build and upgrade applications that take advantage of advanced performance, security, and data mart capabilities.”
 
SQL Server 2016 with Server Pack 1, now, offers the most consistent platform from on-premises to cloud with industry leading TCO for applications of all size. The standard edition sets the bar for rich programming capabilities, security innovations along with fast performance for mid-tier applications, and data marts. You will also be able to easily upgrade to Enterprise edition, without needing to re-write your app. Microsoft informs that the Enterprise Edition continues to deliver the highest level of mission critical scalability, availability, performance, along with virtualization through licensing rights which come with software assurance.
 
The capabilities in SQL Server 2016 SP1 include the following, as per the official blog:
  • Faster transaction performance from In-memory OLTP, faster query performance from In-memory ColumnStore, and the ability to combine the two for real-time Hybrid Transactional and Analytical Processing, also known as Operational Analytics.

  • Data warehousing or data mart performance features such as partitioning, compression, change data capture, database snapshot, and the ability to query across structured and unstructured data with a single node of PolyBase.

  • The innovative security feature Always Encrypted for encryption at rest and in motion, as well as fine-grained auditing which captures more detailed audit information for your compliance reporting needs. In addition, row-level security and dynamic data masking are being made available to Express edition for the first time.