Microsoft SQL Server 2017

Your Complete Data Estate on Any Environment with Any Data

SQL Server 2017 has everything built-in—industry-leading in-memory performance, trusted security, game-changing in-database Advanced Analytics, and the flexibility to run your complete data estate on any environment with any data. All of this comes for less, thanks to unmatched TCO.

Industry-leading performance

Perform queries up to 100x faster than disk with in-memory columnstore, and transactions up to 30x faster with in-memory OLTP.

Least vulnerable

Use layers of protection, including innovative features such as encryption at rest and in motion, all from the least vulnerable database over the last seven years.

Real-time intelligence

Gain transformative insights with up to 1 million predictions per second using built-in Python and R integration, and get end-to-end mobile BI on any platform.

Any application, anywhere

Build modern applications using any data, any language, any platform—on-premises and in the cloud.

Power your entire data estate with SQL Server 2017 (Source: Microsoft)

Breakthrough features of SQL Server 2017

  • Speed query performance without tuning using Adaptive Query Processing

  • Faster transactions with In-Memory OLTP and to 100x faster analytics with in-memory Columnstore

  • Real-time operational analytics when you combine in-memory technologies

  • Fewest NIST vulnerabilities over the last 7 years

  • Encrypt data at rest and in motion with Always Encrypted

  • Dynamic Data Masking conceals sensitive data

  • Control access to database rows with Row-Level Security

  • Scale and accelerate machine learning by pushing intelligence to where the data lives with in-database R and Python analytics

  • Analytics are parallelized and at scale

  • Leading AI innovation to discover insights faster

  • Advanced machine learning algorithms with GPUs

  • Built-in advanced analytics provide scalability and performance for building and running your advanced analytics algorithms directly in the core SQL Server transactional database.

  • Transform complex data from multiple sources into trusted data models using the most popular statistical modelling language

  • Process analytics in-place, reducing latencies and operational costs

  • Write models once and deploy anywhere: in-database, to the cloud, or to Linux, Hadoop, and Teradata

  • Support for Windows and Linux operating systems and Docker container

  • Any cloud, any platform including OpenShift, Red Hat, OpenStack, Kubernetes, Docker Swarm and Pivotal

  • License Mobility enables on-premise licenses to be used in the cloud

Editions

SQL Server 2017 is available in two editions: Standard and Enterprise.

  Standard Enterprise
Maximum number of cores 24 unlimited
Mission-critical performance
  • Disk-based OLTP
  • 24 cores max and 128 GB max memory
  • 2-node single database failover (non-readable secondary)
  • Query Store
  • Temporal
  • Operating system max cores and memory
  • Enhanced in-memory OLTP performance
  • Operational analytics
  • Enhanced AlwaysOn with no domain join (WS2016)
  • Query Store
  • Temporal
Security
  • Row-level security
  • Dynamic data masking
  • Basic auditing
  • Separation of duties
  • Policy-based management
  • Always Encrypted
  • Row-level security
  • Dynamic data masking
  • Enhanced separation of duties
  • Enhanced SQL Server auditing
  • Transparent data encryption
  • Policy-based management
Data Warehousing
  • PolyBase (compute node only)
  • Support for JSON
  • Enhanced in-memory ColumnStore
  • PolyBase in scale-out configuration (head and compute nodes)
  • License rights to (the APS) MPP appliance
  • Distributed query processing
Business Intelligence
  • Basic tabular (16GB memory per instance)
  • Web portal experience
  • Modernized reports
  • Pin reports to Power BI
  • Enhanced multi-dimensional models
  • End-to-end mobile BI on all major platforms
  • Enhanced direct query
  • In-memory analytics
  • Advanced data mining
  • Advanced tabular
  • Web portal experience (all reports in one place)
  • Modernized reports
  • Pin reports to Power BI
  • Enhanced multi-dimensional models
Advanced Analytics
  • Single-threaded for RRE
  • Connectivity to R Open
  • In database advanced analytics
  • R integration with massive parallel processing for performance and scale
  • Works with in-memory technology
  • Run in database or standalone
  • Connectivity to R Open
Hybrid Cloud
  • Stretch Database
  • Backup to Azure
  • Stretch Database
  • Enhanced backup to Azure
  • Enhanced HA and DR with Azure – ease of use, no domain join (WS2016)
  • SSIS integration with Azure Data Factory and Azure SQL data Warehouse

Related News

Enterprise-scale Backup for SQL Server Databases

Leipzig, 04/24/2019 – Enterprise Agreement customers will be able to benefit from a new bundle that Microsoft will start to offer in May 2019. While the standard  Visual Studio products will remain available, new bundle SKUs will be added: Visual Studio Professional Subscription with GitHub Enterprise and Visual Studio Enterprise subscription with GitHub Enterprise.

Read the full article

End of Support for Windows Server 2008/2008 R2 and SQL Server 2008/2008 R2 

Leipzig, 02/01/2019 – Extended support for Windows Server 2008/2008 R2 is ending on 14 January 2020. However, in just six months – on 9 July 2019 – extended support ends for Windows Server 2008/2008 R2. Microsoft will no longer offer regular feature and security updates for these versions. What do you need to do?

Read the full article

New Additions to the Cloud Solution Provider Program

Leipzig, 07/10/2018 – Microsoft has announced the immediate release of Azure Reserved Virtual Machine Instances (RI), as well as Windows Server and SQL Server subscriptions via the  Microsoft Cloud Solution Provider (CSP).

Read the full article

COMPAREX Blog

There will be no more security updates for Windows Server 2008 in future. So do you have to worry about the next cyberattack? Not at all! Our experts outline the pros and cons of various solutions and explain why you do not necessarily have to bid farewell to your current version. Read the full article ...

 

Users may encounter problems when working with SQL Server, but they can be avoided with the right know-how. This blog article investigates serious problems of the type “My application has stopped working.” Read the full article ...

Many IT administrators struggle repeatedly with similar problems when dealing with SQL Server. It’s time to put an end to this predicament! Read the full article ...

 

COMPAREX – Gold Data Platform Partner of Microsoft

News & Promotions

 Request Information