Product: SQL Server 2016
-
-
Open sourcing the R and Python language extensions for SQL Server
For the past decade, data science has become integral to many enterprise applications. Languages such as R and Python have left the realm of data scientists and are being used more frequently by data engineers supporting them. R and Python are the most popular data science languages currently for creating, training, and scoring models. Modernization -
Modernize your SQL Server at the PASS Summit 2018
Each year thousands of data professionals make the annual visit to Seattle, Washington for the Professional Association for SQL Server Summit. This is a community driven organization and event but Microsoft has been a major contributor, sponsor, and part of this summit since its inception. This is the second post in a series leading up to -
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 -
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. As part of our commitment to software excellence for our customers, -
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. The firm handles -
Five reasons to run SQL Server 2016 on Windows Server 2016 – No. 5: Consistent data environment across hybrid cloud environments
Have you ever seen a tree that simultaneously bears completely different species of fruit? It’s a real thing: apples, plums, oranges, lemons, and peaches all growing on the same tree. The growers have the advantage of a consistent environment (the same tree) that allows them to be efficient with resources, pick the type of fruit -
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 -
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 -
The top 5 reasons to upgrade to SQL Server 2016
Upgrading your software can be daunting, we know. The fast pace of business makes it easy to tell yourself, “I’ll do it later when I have time.” We get it! But here are five key reasons to make time to upgrade to SQL Server 2016, which was named DBMS of the Year in 2016 by -
Five reasons to run SQL Server 2016 on Windows Server 2016 – No. 2: Performance and cost
This is the second blog in a five-part series. Keep an eye out for upcoming posts and read the first post in the series, Five reasons to run SQL Server 2016 on Windows Server 2016, part 1. Imagine you’ve just bought a super powerful car with built-in advanced technology to make it perform at its highest. -
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 -
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 -
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) -
Welcome 2017! Recap of top SQL Server posts of 2016
We start off the new year with a quick recap of our most popular posts on this blog channel from the year just concluded. Here are the posts that got the most number of views from our readers during 2016, in increasing order of readership: 10. SQL Server 2016 Express Edition in Windows containers In