SQL Server Valuable Features

The solution is very easy to use for me. SQL is the most user-friendly system for databasing aside from Postgres. Due to the financial costs of Postgres, the SQL system is a good alternative as the product can be utilized free of charge. It's a good learning environment, it's easy enough to learn and understand. Anybody that picks up the language early on will be able to develop in it. View full review »

The most valuable aspect of the solution is that the metadata is just generalized. Metadata is the way that data is described both for technical aspects of building a database and for the user interfaces. Our metadata is the objects attached to the database, not in the software. It helps with moving the design of the database into reality. View full review »

The feature that I have found most valuable is that it is easy to code. You can very easily get a resource to work on that. For example, if we have a big project it's hard to get a good resource in the IT industry. However, since SQL Server is the most popular solution, you can easily get resources to use it so the risk factors are very, very low. Even if someone leaves the company, you can easily replace them. Additionally, it is very stable. You don't need to struggle for anything. Most of the codes are there. View full review »

SQL SSIS is the most useful aspect of the solution. We find the product to be relatively stable. The solution seems to be pretty flexible. View full review »

* Performance-wise, it is an excellent tool. * It is a Microsoft product, so there's a lot of support. * It's not a new tool; it has been around for a while. * It is one of the top five relational databases in the market. * It is very user-friendly. * There are a lot of resources available for it. View full review »

Security is obviously the most valuable feature because I can provide certain logins for a particular level of security and I can provide specific permissions for certain logins. That's a very good feature. I like the user interface as well, it's easy to use. The SSMS Management Studio, which we use to do some work in database file query is a recent feature from 2018 and the SSMS is quite good. It has many features and it also shows the query statistics which I was not getting previously. The other feature I like is the query store which helped me a lot to analyze the data getting hit on the database. View full review »

The performance is a very valuable aspect of the solution. SQL is very easy to manage. View full review »

That question is not that easy to answer, to say that there is a feature in a database that you like more than others. When you are running a database, you expect it to do many different things, and if fails in one area, it basically takes it out of the picture completely. View full review »

The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products. View full review »

The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python involves aggregation, batch mode - which processes rows of data several at a time, can be very helpful. Two other new batch mode features, memory grant feedback, and adaptive joins will enhance SQL Server's performance and efficiency as well. It is good to move from Microsoft to deal with big data analytics View full review »

One of the big advantages of this product is its performance, where it works well when the data is not complex. View full review »

The analytics are pretty good. As a data warehouse and storage solution, it's quite good. It's easy to put the data back onto the SQL Server or Oracle. The solution is pretty fast. We find it to be responsive. There are a lot of services, such as the SSISS, SIS, and SSI's that work quite well. View full review »

The pricing of the product is very good. We've found the stability to be very reliable. The initial setup isn't too complicated. It's pretty straightforward. View full review »

What I like best about this product is the environment. The documentation and manuals are very good. View full review »

The most valuable feature is the system architecture. View full review »

table partition options, that is very useful to separate unnecessary cost. For legacy data, we can do partition swith out and store into flat files or old tables. When it necessary, we can switch in back. View full review »

We have been using SQL Server from the start, so it's a stable product. View full review »

The features that we have found the most valuable are reliability, availability perspective, and current scalability. View full review »

The most valuable features are programmability and reliability. View full review »

It is widely used and we never have problems with it. It can handle a PC, and it can also handle huge data. It is fast and efficient. It is something unique that tracks reporting of records, personnel, finances and more. It also integrates well with everything, not just Microsoft tools. View full review »

The availability is the most valuable feature. It has high availability. It also has good performance. View full review »

The columnstore index feature is useful for us, and we also use the integration services. It is also very stable. View full review »

* Creating and executing SQL queries, transactions, ACID properties * Creating and implementing stored procedures. View full review »

The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations. View full review »

* SSMS * SSIS * Reporting services * FCI clustering * AlwaysOn * Basic availability groups. View full review »