SQL Server 2019 is now here!
Access mission-critical capabilities to achieve unparalleled scale, security, high availability, and leading performance for your Tier 1 database, business intelligence, and advanced analytics workloads.
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.
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.
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-fifth the cost of other self-service solutions.
SQL Server Enterprise delivers comprehensive data center capabilities for mission-critical database, business intelligence, and advanced analytics workloads.
Microsoft SQL Enterprise 24 Core license comes with unlimited users and can be enhanced by speeding up storage and memory.
Mission Critical Performance
§ Operating system max cores and memory
§ Enhanced in-memory OLTP performance
§ Operational analytics
§ Enhanced Always On with no domain join (WS 2016)
§ Query Store
§ Always Encrypted
§ Row-level security
§ Dynamic data masking
§ Enhanced separation of duties
§ Enhanced SQL Server auditing
§ Transparent data encryption
§ Policy-based management
§ Enhanced in-memory ColumnStore
§ PolyBase in scale-out configuration (head and compute nodes)
§ License rights to (the APS) MPP appliance
§ Distributed query processing
§ Support for JSON
· End-to-end mobile BI on all major platforms
· Enhanced DirectQuery
· In-memory analytics
· Advanced data mining
· Advanced tabular
· Web portal experience (all reports in one place)
· Modernized reports
· Pin reports to Power BI
· Enhanced multidimensional models
· 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
· Stretch Database
· Enhanced backup to Azure
· Enhanced HA and DR with Azure – ease of use, no domain join (Windows Server 2019)
· SSIS integration with Azure Data Factory and Azure SQL Data Warehouse
The following requirements apply to all SQL Server 2019 installations:
o SQL Server 2019 requires .NET Framework 4.6 for the Database Engine, Master Data Services, or Replication. SQL Server 2019 setup automatically installs .NET Framework. You can also manually install .NET Framework from Microsoft .NET Framework 4.6 (Web Installer) for Windows.
Windows 10, and Windows Server 2019:
o Require KB2919355 before installing .NET Framework 4.6.
Supported operating systems for SQL Server 2019 have built-in network software.
o Note: Shared memory and VIA are not supported on failover clusters.
- Also note that the VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
o SQL Server 2019 requires a minimum of 6 GB of available hard-disk space.
- Disk space requirements will vary with the SQL Server 2019 components you install.
o A DVD drive, as appropriate, is required for installation from disc.
o SQL Server 2019 requires Super-VGA (800×600) or higher resolution monitor.
o Internet functionality requires Internet access (fees may apply).
The following memory and processor requirements apply to all editions of SQL Server 2019:
o 512 MB
All other editions:
o 1 GB
o 1 GB
All other editions:
o At least 4 GB and should be increased as database size increases to ensure optimal performance.
o Minimum: x64 Processor: 1.4 GHz
o 2.0 GHz or faster
o x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support.