SQL Server

Microsoft SQL Server is a relational database management system. SQL Server 2017 brings the enterprise capabilities of SQL to Linux as well as Windows. Equally important, SQL Server 2017 is engineered to handle the fast-evolving needs of modern data developers and administrators.

SQL Server 2017 is available in the following editions:

• Enterprise: SQL Server Enterprise delivers comprehensive datacenter capabilities for mission-critical database, business intelligence and advanced analytics workloads
• Standard: SQL Server Standard provides core data management and business intelligence capabilities for non-critical workloads with minimal IT resources.

SQL Server - Features

Key Features:

• Your choice of language and platforms: Build modern applications using the language of your choice, on-premises and in the cloud, now on Windows, Linux and Docker containers.
• Industry-leading performance: Take advantage of breakthrough scalability, performance and availability for mission-critical, intelligent applications and data warehouses.
• Least vulnerable database: Protect data at rest and in motion with the least vulnerable database over the last seven years in the NIST vulnerabilities database.
• Real-time intelligence: Gain transformative insights for your business with real-time analytics at up to 1M predictions/second.
• End-to-end mobile BI: Turn raw data into meaningful reports that can be delivered to any device—at one-fourth the cost of other self-service solutions.
• Mission-critical availability: SQL Server 2017 is a unified solution for high availability and disaster recovery on Linux and Windows. Gain mission-critical uptime, fast failover, easy setup and load balancing of readable secondaries with enhanced Always On in
• Built-in analytics: Build intelligent applications with SQL Server Machine Learning Services using R and Python. Move beyond reactive and into predictive and prescriptive analytics by performing advanced analytics directly within the database.
• Consistent experience: Develop once and deploy anywhere with our consistent experience from on-premises to cloud.

SQL Server - System Requirements

Hardware and Software Requirements (Windows)

The following requirements apply to all SQL Server 2017 and later installations:

• .NET Framework: SQL Server 2017 RC1 and later require .NET Framework 4.6 for the Database Engine, Master Data Services, or Replication. SQL Server 2017 setup automatically installs .NET Framework.
• Network Software: Supported operating systems for SQL Server 2017 have built-in network software. Named and default instances of a stand-alone installation support the following network protocols: Shared memory, Named Pipes, TCP/IP and VIA.
• Hard Disk: SQL Server 2017 requires a minimum of 6 GB of available hard-disk space. Disk space requirements will vary with the SQL Server 2017 components you install.
• Drive: A DVD drive, as appropriate, is required for installation from disc.
• Monitor: SQL Server 2017 requires Super-VGA (800x600) or higher resolution monitor.
• Internet: Internet functionality requires Internet access.

Processor, Memory and Operating System Requirements (Windows):

• Memory: Minimum: Express Editions: 512 MB, All other editions: 1 GB - Recommended: Express Editions: 1 GB, All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.
• Processor Speed: Minimum: x64 Processor: 1.4 GHz, Recommended: 2.0 GHz or faster
• Processor Type: x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support

Note: Installation of SQL Server 2017 and later is supported on x64 processors only. It is no longer supported on x86 processors.

System Requirements (Linux):

• Memory: 3.25 GB
• File System: XFS or EXT4 (other file systems, such as BTRFS, are unsupported)
• Disk space: 6 GB
• Processor speed: 2 GHz
• Processor cores: 2 cores
• Processor type: x64-compatible only

Supported Platforms (Linux):

• Red Hat Enterprise Linux 7.3 or 7.4 Get RHEL 7.4
• SUSE Linux Enterprise Server v12 SP2 Get SLES v12 SP2
• Ubuntu 16.04 Get Ubuntu 16.04
• Docker Engine 1.8+