Microsoft SQL Server 2019 is released on 04 November, 2019. It's also called as SQL Server 2019 (15.x) or
SQL 2019.
Microsoft SQL Server 2019 Mainstream support ends on 07 January, 2025.
Microsoft SQL Server 2019 Extended support ends on 08 January, 2030.
Microsoft SQL Server 2019 is Compatible with Database Level 150.
Microsoft SQL Server 2019 Mainstream support ends on 07 January, 2025.
Microsoft SQL Server 2019 Extended support ends on 08 January, 2030.
Microsoft SQL Server 2019 is Compatible with Database Level 150.
Microsoft SQL Server 2019 is
Generally available on below Operating Systems:
1. Windows
2. Linux
3. Docker
4. Kubernetes
Below are the list of features that included/upgraded on Microsoft SQL
Server 2019 version:
Intelligence across all your data with Big Data Clusters
Microsoft SQL Server 2019 is providing a complete
environment to work with large number of data sets, it also including machine
learning and AI capabilities as well.
- Its support structured data
and unstructured data
Microsoft SQL Server 2019 helping to combining vast amount of data to
both structured data and unstructured data and allow to access the data using
either Spark or T-SQL.
- AI capabilities for your data
Big Data Clusters provides all the required systems and tools for
store data, ingest data, prepared data for analysis, and also useful to train
data and ope-rationalize machine learning models.
Choice of Language and platform
Run Microsoft SQL Server 2019 with Windows, Linux, Docker and
deployments using Kubernetes.
Industry-leading Performance
Microsoft SQL Server 2019 improved record-breaking performance on Windows platform and Linux platform. Microsoft SQL Server continues improving leads across the real-world application performance benchmarks , TPC-H data warehousing workload, and TPC-E OLTP workload.
- Database Performance
Upgrading and modernize your Microsoft SQL Server database in the
cloud, at the edge and on-premises. With the Database compatibility
certification do away with the risk of application incompatibility. Its help to
use persistent memory support for in-memory database capabilities and memory-optimized
for tempdb to increase performance for your projects and critical data
work loads.
Most Secure Data Platform
Protect data at rest and in motion with a database that has the fewest vulnerabilities of any major platform for nine years running in the National Institute of Standards and Technologies National Vulnerabilities Database.
- Built-in security and compliance
Microsoft SQL Server 2019 provides built-in features for data
protection, data classification, and data monitoring and alerts. Microsoft SQL
Server 2019 identifies activities, monitors logs and provides alerts on
suspicious activity in background, even it identifying malicious activities and re mediating unauthorized configurations and security gaps.
- Always encrypted data enclaves
Microsoft SQL Server 2019 have facility to Encrypt sensitive data
and run rich computations on encrypted data, also it enables customized access
based data on role with complex row filtering.Unparalleled high availability
- Maximum availability
Gain mission-critical up time, fast fail over, and improved TCO
using cloud disaster recovery replicas and always on availability groups.
- Accelerated database recovery
Microsoft SQL Server 2019 nicely improves database availability to
enabling fast and consistent database recovery regardless of the number or size
of active data transactions.End to end Mobile UI
- Self-service BI on any device
With Power BI Report Server Explore visual data and quickly discover
patterns to make better and faster decisions, which is added with your SQL
Server Software Assurance license.
- Connect all your data
Combine data from almost all source using the extensive connector
library and new transformations in SSAS tabular models.
- Visual data exploration
Using SQL Server BI tools you
can find the answers beyond the data with visual data exploration and collective
analysis of data lakes data.SQL Server on Azure
- Highly scalable cloud services
Microsoft SQL Server 2019 allows to Migrate
to Azure without redesigning your applications and increases your existing
applications performance.It provides below type of unified SQL platform built, for industry-leading performance of Microsoft SQL Server.
- Limitless Scalability
- Intelligent Performance
- Built-in Security
No comments:
Post a Comment