SQL Server 2017

SQL Server 2017
Name	SQL Server 2017
Developer	Microsoft
Released	2017
Written in	C++
Operating system	Windows Server 2016, Linux (kernel), Ubuntu, Red Hat Enterprise Linux, SUSE Linux Enterprise Server
Platform	x86-64
Genre	Relational database management system
License	Proprietary commercial software

SQL Server 2017 Microsoft's 2017 release of its flagship relational database product brought cross‑platform support and integrated advanced analytics to enterprise storage and processing. The release built on prior work from Microsoft SQL Server 2016 while positioning against technologies from Oracle Corporation, IBM Db2, PostgreSQL, MySQL and cloud offerings such as Amazon Relational Database Service, Google Cloud SQL and Microsoft Azure SQL Database. Leveraging components and partnerships across Red Hat, Canonical (company), SUSE, Docker, Inc. and the Open Source Initiative, the product targeted on‑premises, virtualized and cloud deployments.

Overview

SQL Server 2017 continued Microsoft's lineage originating from products influenced by Sybase and early Microsoft database efforts, offering a combination of transactional (OLTP) and analytical (OLAP) capabilities. The release emphasized hybrid scenarios relevant to enterprises using platforms like VMware ESXi, Hyper-V, Kubernetes, Microsoft Azure Stack and heterogeneous stacks incorporating Hadoop distributions from Cloudera and Hortonworks. Marketing and technical positioning referenced competitive dynamics with Oracle Database 12c, IBM DB2 11, and the growing adoption of PostgreSQL in cloud and on‑premises environments.

Editions and Licensing

Microsoft offered multiple editions reflecting enterprise, developer and embedded use cases, aligning with longstanding SKU strategies used by Microsoft and paralleled by vendors such as Oracle Corporation and SAP. Typical editions included Enterprise, Standard, Developer and Express, with licensing models based on core licensing and server + CAL options comparable to legacy approaches used for Windows Server and Microsoft Exchange Server. Volume licensing, Software Assurance and licensing alignment with cloud services referenced programs familiar to enterprises that also negotiate with vendors like IBM and VMware, Inc..

Key Features and Enhancements

Major enhancements included native support for running on Linux (kernel) distributions like Ubuntu, Red Hat Enterprise Linux and SUSE Linux Enterprise Server, reflecting Microsoft's collaboration with Canonical (company and Red Hat. The release integrated the Python (programming language) runtime alongside existing R (programming language) support for in‑database analytic extensions, appealing to teams using toolchains from Anaconda (company), NumPy, Pandas and visualization platforms such as Tableau and Power BI. Graph database extensions, adaptive query processing and enhanced columnstore indexes targeted workloads that previously required blending with systems like Apache Spark and Hadoop. Integration with container ecosystems via Docker, Inc. images enabled deployment patterns similar to microservices architectures supported by Kubernetes and orchestration solutions from Red Hat OpenShift.

Platform Support and Deployment

The cross‑platform capability marked a strategic shift enabling deployments on major distributions used in enterprise datacenters and cloud providers including Amazon Web Services, Google Cloud Platform and Microsoft Azure. Support for platform virtualization technologies aligned with VMware ESXi and Hyper-V, while containerized packaging allowed integration with Kubernetes clusters managed by vendors such as Rancher Labs and Red Hat. Tooling compatibility with development environments like Visual Studio and continuous integration systems from Jenkins and TeamCity streamlined DevOps practices used by teams at companies such as GitHub and Atlassian.

Security and Compliance

Security improvements continued Microsoft's emphasis on enterprise controls found in prior Microsoft server products, with features addressing encryption, authentication and auditing compatible with compliance regimes administered by organizations like ISO, NIST and regulators in industries that engage with Deloitte and PwC. Row‑level security, dynamic data masking and Always Encrypted key management integrated with existing identity systems such as Active Directory and supported secure deployment patterns used by financial institutions and healthcare organizations that reference standards upheld by HIPAA and PCI DSS. Enhanced auditing and integration with SIEM tools from vendors like Splunk and IBM Security facilitated incident response and monitoring.

Performance and Scalability

Performance improvements focused on adaptive query processing, batch mode on rowstore, and enhancements to columnstore index performance to close gaps with analytic engines such as Vertica and Amazon Redshift. Scalability features targeted multi‑core, NUMA architectures common to servers from vendors like Dell Technologies, Hewlett Packard Enterprise and Lenovo, enabling OLTP throughput and BI query concurrency demanded by enterprises comparable to those served by SAP HANA and Oracle Exadata. Integration with in‑memory OLTP and enhancements to tempdb contention addressed high‑concurrency workloads frequently encountered in large retail, finance and telecom deployments working with partners like Accenture and Capgemini.

Lifecycle and Updates

As part of Microsoft's mainstream and extended support lifecycle policy consistent with other Microsoft server products, the release received cumulative updates, Service Packs and security patches distributed through channels used by enterprise IT organizations. Update cadence and servicing aligned with practices familiar to customers managing systems from vendors such as Red Hat and Canonical (company), with guidance for in‑place upgrades, side‑by‑side migrations and cloud migration paths to Azure SQL Database Managed Instance or managed services provided by Amazon Web Services and Google Cloud Platform. The product's lifecycle planning intersected with ecosystem roadmaps from major hardware and software partners and consulting firms that help enterprises plan long term migrations.

Category:Microsoft database software