Product: SQL Server 2016

Published 
1 min read

Microsoft releases the latest update of Analytics Platform System 

Microsoft is pleased to announce that the Analytics Platform System (APS) appliance update 7 (AU7) is now generally available. APS is Microsoft’s scale-out Massively Parallel Processing (MPP) system based on SQL Server for data warehouse specific workloads on-premises. Customers will get significantly improved query performance and enhanced security features with this release. APS AU7 builds on appliance update 6 (APS 2016) release as a foundation.
Published 
1 min read

SQL Server 2016 Service Pack 2 is now available 

The SQL Server team is excited to bring you the second service pack release for SQL Server 2016. The service pack is now available for download on the Microsoft Download Center and will be coming soon to Visual Studio Subscriptions, MBS/Partner Source, and VLSC.
Published 
1 min read

Keeping freight moving in Denmark with SQL Server 2016 

Efficient data management keeps goods flowing smoothly in Denmark. Danske Fragtmaend, the country’s largest national transport and distribution firm, has been moving freight for more than a century. Today, Danske Fragtmaend delivers more than 40,000 consignments each day throughout Denmark, and businesses from small mom-and-pop operations to factories rely on its services.
Published 
4 min read

Five reasons to run SQL Server 2016 on Windows Server 2016 – No. 4: Reach insights faster by running analytics at the point of creation 

This is the fourth post in a five-part blog series. Keep an eye out for upcoming posts and catch up on the first, second, and third in the series. In addition, join us for Microsoft Data Amp on April 19 at 8 AM PT. The online event will showcase how data is the nexus between application innovation and artificial intelligence.
Published 
6 min read

Five reasons to run SQL Server 2016 on Windows Server 2016 – No. 3: database uptime and reliability 

This is the third post in a five-part blog series. Keep an eye out for upcoming posts and catch up on the first and second in the series. In addition, join us for Microsoft Data Amp on April 19 at 8 a.m. PT. The online event will showcase how data is the nexus between application innovation and artificial intelligence.
Published 
4 min read

Five reasons to run SQL Server 2016 on Windows Server 2016 — No. 1: Security 

This is the first blog in a five-part series. Keep an eye out for upcoming posts, which will cover cutting costs and improving performance of storage, BI, and analytics; improving uptime and reliability; reaching data insights faster by running analytics at the point of creation; and maintaining a consistent data environment across on-premises, hybrid, and cloud environments.
Published 
1 min read

SQL Server named DBMS of the Year by DB-Engines 

SQL Server was recently named DBMS of the Year by DB-Engines. DB-Engines is an initiative to collect and present information on database management systems, and provides a widely accepted popularity ranking of database management systems, and has been created and maintained by solid IT, an Austrian company with a special focus on database consulting and software development.
Published 
1 min read

Announcing Columnstore Indexes and Query Store support in Database Engine Tuning Advisor 

The latest version of Microsoft SQL Server Database Engine Tuning Advisor (DTA) supports two new features: (a) Ability to recommend columnstore indexes in addition to rowstore indexes, and (b) Ability to automatically select a workload to tune from the Query Store. These new features are available when tuning for SQL Server 2016 Database Engine (or later) versions.