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.
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-fifth the cost of other self-service solutions.
Enterprise Edition:
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
§ Temporal
Security
§ Always Encrypted
§ Row-level security
§ Dynamic data masking
§ Enhanced separation of duties
§ Enhanced SQL Server auditing
§ Transparent data encryption
§ Policy-based management
Data Warehousing
§ 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
Business Intelligence
· 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
Advanced Analytics
· 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
· 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:
.NET Framework:
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.
Hard Disk
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.
Drive
o A DVD drive, as appropriate, is required for installation from disc.
- Monitor
o SQL Server 2019 requires Super-VGA (800×600) or higher resolution monitor.
Internet
o Internet functionality requires Internet access (fees may apply).
The following memory and processor requirements apply to all editions of SQL Server 2019:
Express Editions:
o 512 MB
All other editions:
o 1 GB
Recommended:
Express Editions:
o 1 GB
All other editions:
o At least 4 GB and should be increased as database size increases to ensure optimal performance.
Processor Speed
o Minimum: x64 Processor: 1.4 GHz
Recommended:
o 2.0 GHz or faster
Processor Type:
o x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support.
Reviews
There are no reviews yet.