SQL Server 2019 Reviews & Product Details

It provides highly secure data transfer from source to destination. We can configure access of users in-depth and up to minute level. It is highly compatible with dot net and windows. Review collected by and hosted on G2.com.

Sometimes it hangs a lot. Several times it slowed down just because of VPN connection loss. It should throw an error message instead of hanging while running a script. Review collected by and hosted on G2.com.

I like the folder/directory structure easy to navigate. I also find the formatting part where square brackets get enclosed around names of columns when you hit on "script as" to generate scripts. Review collected by and hosted on G2.com.

There is no feature of rolling back faulty inserts or deletes. Sometimes, I had no way of retrieving accidentally deleted records. Review collected by and hosted on G2.com.

-SQL SERVER 2019 has a data virtualization feature that benefits our improved ETL process. Now can integrate different heterogeneous data sources without moving data.

-SQL Server 2019 big data cluster has advancement with Polybase. Now we can achieve bidirectional integration with the Help of Hadoop and Spark, and Big Data management is straightforward.

-SQL Server 2019 has a vulnerability assessment, which can get a detailed report of vulnerabilities and implement compliance to fix these vulnerabilities.

-SQL Server 2019 has the feature of certificate management in the SQL Server configuration manager; it helps to manage certificates effectively.

-SQL Server 2019 has the feature Always Encrypted with a secure enclave; it secures data from malware

-SQL Server 2019 has the support of Persistent Memory devices. It helps SQL Server to access devices and improve performance directly.

-SQL Server 2019 has a feature to create a resumable online index. With the help of this feature, we can pause and resume online index creation.

-SQL Server 2019 has an improvement to column store indexes, which has benefits of performance.

-SQL Server 2019 has a feature to support UTF-8 character encoding. It helps us to improve the compatibility of database and enhances performance.

-SQL Server 2019 has a feature vulnerability assessment. It helps to track compliance and generate a report. Review collected by and hosted on G2.com.

-SQL Server 2019 is an expensive product as compared with other databases such as MySQL. Due to its high cost, many companies can afford it. To compete with these databases, Microsoft should consider the pricing factor Review collected by and hosted on G2.com.

- Comes in several different sizes for differing requirements, Express, Standard, Developer, Enterprise, etc

- Developer edition is a no-cost set up ideal for building your sandbox system for developing

- Uses SSMS as front end or Visual Studio

- Deemed to be still main choice for any company needing a database that works with other standard Microsoft products Review collected by and hosted on G2.com.

- rumours from seasoned devs there are many bugs, and maybe not a mature product for a mission-critical solution, compared to 2016/2017. Review collected by and hosted on G2.com.

SQL Server is very faster than other databases as performance wise. We are using SQL Server for desktop applications. The most important feature I like in SQL Server is at the time of deployment on production it does not require large space. Review collected by and hosted on G2.com.

Documentation is not as clear as one may expect. You get easily lost between docs for different versions of the database. It is quite expensive. Review collected by and hosted on G2.com.

SQL language, SQL server integrations, external script execution, Regular updates Review collected by and hosted on G2.com.

Nothing significant as of now but lack of scalability. Review collected by and hosted on G2.com.

- Integrate with .NET framework

- It's fast, reliable, secure

- Easy to install

- A lot of features Review collected by and hosted on G2.com.

- Expensive license

- Could be better in scalability

- Created data diagrams need improvement Review collected by and hosted on G2.com.

Microsoft Azure is an effective way to modernize your data warehouse. Businesses use Azure SQL Data Warehouse to create net-new data warehouses in the cloud, extend their existing enterprise data warehouse to the cloud, and/or migrate their on-premises data warehouse to Azure SQL Data Warehouse Review collected by and hosted on G2.com.

Very good datawarehouse cloud based colution Review collected by and hosted on G2.com.

It is easy to use , connect to your different servers, databases and run queries.

A very very useful product to manage Database for any organization. Review collected by and hosted on G2.com.

Might be UI can be little more good , apart from that i found it very useful Review collected by and hosted on G2.com.

In earlier versions of sql server there was no support of big data, SQL-2019 gives us this feature. We can do ETL in very simple way for mongoDB kinds of database. I like its UTF feature most as it has saved my life in current project. I'm using SQL2019 since last 8 months and I'm loving it. Below are the features I like most.

-Multiplatform installation, now we can install it on any os like windows, apache.

-UTF support for multiple characters.

-Build image testing with docker and K8S.

-Integration with most of the development frameworks. Review collected by and hosted on G2.com.

At the moment I didn't found any cons only the prize is expensive for enterprise application. :) Review collected by and hosted on G2.com.