Product: SQL Server 2016

Published 
3 min read

Five reasons to run SQL Server 2016 on Windows Server 2016 – No. 2: Performance and cost 

Imagine you’ve just bought a super powerful car with built-in advanced technology to make it perform at its highest. You want to take full advantage of all that horsepower and even turbocharge it, while at the same time get great mileage. That’s what you get when you run SQL Server 2016 on Windows Server 2016: unmatched performance at the lowest cost.
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.
Published 
2 min read

Microsoft releases the latest update to Analytics Platform System 

Microsoft is pleased to announce that the appliance update, Analytics Platform System (APS) 2016, has been released to manufacturing and is now generally available. APS is Microsoft’s scale-out Massively Parallel Processing fully integrated system for data warehouse specific workloads. This appliance update builds on the SQL Server2016 release as a foundation to bring you many value-added features.
Published 
7 min read

SQL Server as a Machine Learning Model Management System 

This post was authored by Rimma Nehme, Technical Assistant, Data Group Machine Learning Model Management If you are a data scientist, business analyst or a machine learning engineer, you need model management – a system that manages and orchestrates the entire lifecycle of your learning model.