SQL Server Valuable Features

reviewer1460082
Information Technology Software Developer at a financial services firm with 501-1,000 employees
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 »
reviewer1389651
Certified Adjunct Faculty, School of Engineering and Computing at a university with 1,001-5,000 employees
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 »
Shanti Sahu
Cloud Data Architect (Data service Team) at NTT Data India Enterprise Application Services Pri
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 »
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: December 2020.
455,301 professionals have used our research since 2012.
reviewer1473555
Sr Tech Business Analyst, Group Data Projects & Ventures at a financial services firm with 10,001+ employees
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 »
Aju Mathai
Database Architect at Huron Consulting
* 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 »
Aditya Sawant
Assistant Manager at ECU
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 »
reviewer1359642
Sr. DBA/Developer at a financial services firm with 5,001-10,000 employees
The performance is a very valuable aspect of the solution. SQL is very easy to manage. View full review »
reviewer1187943
Director of Data Analytics at a insurance company with 1,001-5,000 employees
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 »
reviewer1413750
Lead Data Architect at a financial services firm with 1,001-5,000 employees
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 »
Girish Vijay
Deputy Manager IT at Carl Bechem Lubricants India Pvt Ltd
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 »
reviewer1478481
Senior Developer at a non-profit with 10,001+ employees
One of the big advantages of this product is its performance, where it works well when the data is not complex. View full review »
reviewer1470330
Analytics Manager - Data and Capability at a financial services firm with 1,001-5,000 employees
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 »
Navee Srichaiyanont
Network Engineer at a pharma/biotech company with 1,001-5,000 employees
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 »
Rafael Keller
IT Manager at a consumer goods company with 1,001-5,000 employees
What I like best about this product is the environment. The documentation and manuals are very good. View full review »
MD.SIHAB TALUKDAR
System Engineer at a non-profit with 10,001+ employees
The most valuable feature is the system architecture. View full review »
Lei Liu
DBA,data architectuire at LGCNS CHINA
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 »
Rmegio Lawag
Technical Department Manager at Direcbusiness Technologies, Inc.
We have been using SQL Server from the start, so it's a stable product. View full review »
SashisekharPanda
General Manager/MVP at Yotta Infrastructure Solutions LLP
The features that we have found the most valuable are reliability, availability perspective, and current scalability. View full review »
MartinAnderson
SQL Developer, Data Analyst, and BI Reporting Engineer at BNS
The most valuable features are programmability and reliability. View full review »
Daniel Du Toit
Systems Analyst Developer with 1-10 employees
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 »
Johan Malan
System administrator at ZEST WEG Group
The availability is the most valuable feature. It has high availability. It also has good performance. View full review »
Victor Sokolov
DWH Architect at B2BSoft
The columnstore index feature is useful for us, and we also use the integration services. It is also very stable. View full review »
reviewer1030020
Programmer Analyst at a tech services company with 10,001+ employees
* Creating and executing SQL queries, transactions, ACID properties * Creating and implementing stored procedures. View full review »
GhamdanAl-Anesi
Member of the Board & Co-Founder, Executive Manager at Networld Systems
The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations. View full review »
Menoj-Roekalea
Cloud DBA at UNIT4
* SSMS * SSIS * Reporting services * FCI clustering * AlwaysOn * Basic availability groups. View full review »
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: December 2020.
455,301 professionals have used our research since 2012.