skip to main content

Introduction

The release of a Linux version of SQL Server marks a milestone. It places SQL Server in the database mainstream, as Linux is where most of the competing open source and enterprise platforms lie.

Highlights

  • Analyzes Microsoft SQL Server 2017.

Features and Benefits

  • Analyzes how Microsoft delivered a native Linux version of its database.
  • Analyzes how cloud convergence is a major underlying theme that will drive the future product roadmap.

Key questions answered

  • Is the Linux edition of SQL Server 2017 a native implementation?
  • What is the significance of the merging of the SQL Server and cloud-based Azure SQL Database, and what does it mean for SQL Server's future roadmap?

Table of contents

Summary

  • Catalyst
  • Ovum view
  • Key messages

Recommendations

  • Recommendations for enterprises
  • Recommendations for vendors
  • Scope

The big picture

  • SQL Server’s evolution
  • Multiplatform is the headline, but cloud convergence is the sleeper
  • Multimodel extensibility and advanced analytics

SQL Server goes multiplatform

  • At long last, Linux
  • Feature comparison between Linux and Windows editions
  • Don’t forget Docker

Convergence with Azure SQL Database

  • Rejoining twins separated at birth
  • Azure SQL Database Managed Instance introduces middle ground for SQL Server users

Analytics

  • Graph table support
  • Making Python a first-class citizen
  • Scoring predictive analytics models in T-SQL

Performance enhancements

  • Adaptive query processing
  • Automatic tuning and query plan correction
  • Resumable index rebuilds
  • Enhancements to SQL Server ancillary services

Appendix

  • Methodology
  • Further reading
  • Author