SQL Server Room for Improvement

reviewer1460082
Information Technology Software Developer at a financial services firm with 501-1,000 employees
With any development language, any programming or software language available, there's always room for improvement. With SQL, it requires the more advanced integrated capabilities of Postgres, however, those capabilities do really come with obvious kinds of costs. For example, if SQL were to improve its functionality to incorporate the functionality that is in Postgres. Obviously, some kind of financial licensing will need to be incorporated. It's a bit of a catch-22 with a system similar to an SQL Server. If we want to avoid costs, we have to take a step back from certain integration capabilities. From a development perspective, the solution needs to be a lot easier to understand or it needs to be easier to implement API packages for connection pooling so we don't have connection interruptions when, let's say, a hundred people simultaneously access the network on a given system, utilizing a specific or single database. Any type of connection pool or connection integration that could increase the total number of users to access simultaneously would be beneficial. That said, I also know there are some security risks involved with that type of connection pooling. However, something from SQL-side that can increase its connection access or its connection stability for multiple user access to a single database system would be great. View full review »
reviewer1389651
Certified Adjunct Faculty, School of Engineering and Computing at a university with 1,001-5,000 employees
The server itself doesn't need much improvement. The product overall would benefit from the addition of better tutorials to help master the skills necessary to actually build a project database. Right now, what is available isn't sufficient. Overall, I would suggest a nice tight integration with the toolset now known as Power BI. It might not even be missing, however, I'm planning to concentrate a lot of my time with the tutorials and I have Power BI loaded onto my HP laptop. bA brilliant student did it for me when she demoed it in a class. I'm going to use that copy of it and have many tutorials to get ready. View full review »
Shanti Sahu
Cloud Data Architect (Data service Team) at NTT Data India Enterprise Application Services Pri
In terms of what could be improved, everything on-premises is now moving to the cloud. Obviously SQL Server has also moved because Microsoft has its own cloud called Azure SQL and azure synapse. Every solution comes with its own advantages and disadvantages. Each cloud has its own way to maintain resources and that plays a major role. But I would say that Azure Clouds are easy to work as compared to others. To Performance-wise it's still not as good as on-premises, but it is easy to work with. For example, if you are familiar with the SQL server then you don't need to put any effort to work on the Azure SQL or Azure Synapse. Your efficiency will not decrease and you can easily manage any projects. Its advantage is that it is very similar. Apart from that, if you moving to any other Warehouse like Snowflake, redshift with existing SQL server resources is a little difficult and organizations need to spend money on their training. Which increases cost. 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,108 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
Due to the fact that I'm dealing with the product more as a data analyst, the SQL Server management studio is really relatively primitive compared to other more advanced tools. There are other tools on the market that are much more advanced. It would be better if they managed to give us a bit more of a user-friendly product with just a bit more meat on the bone. It's a bit basic. There are a number of features that are lacking. Just recently I had to do something and it's not available on the SQL Server. However, it's available on another solution that's actually a much cheaper product. Some areas need improvement. For example, how you deal with the manipulation of data is probably not the best. View full review »
Aju Mathai
Database Architect at Huron Consulting
I would like to see native plugins built for other platforms versus having to buy third-party plugins to tap into S3 buckets and AWS Cloud. Right now, it does not have those built-in plugins. I know that they are building SQL Server for the Unix environment, which is in the beta version, and not out yet. This has been a long time wish for a lot of people. Once that is out, we'll be able to tell how diversified they have become in regards to other platforms. It hasn't 100 percent on scalability and third-party plugins. View full review »
Aditya Sawant
Assistant Manager at ECU
I'd like to see a simplification of the query optimizer and feel that SQL needs to look into the internal processing of the query because the query optimizer sometimes uses a different query plan, which we don't expect. It is similar to the triggers they have which are used after execution and not before. For example, if I'm running a query, my trigger will be run after the query has executed although I sometimes need the trigger before execution. That's a feature not supported by the product. View full review »
reviewer1359642
Sr. DBA/Developer at a financial services firm with 5,001-10,000 employees
Occasionally the performance, as good as it is, is a bit off. We sometimes experience memory spiking. If they could maybe fix that aspect of the solution, that would be quite helpful for our organization. View full review »
reviewer1187943
Director of Data Analytics at a insurance company with 1,001-5,000 employees
Scalability is an area that needs improvement, and the deployment is difficult, which why I'm looking for an appliance to deploy it in a much more scalable way. I would like to know how you can scale to be a large enterprise server. View full review »
reviewer1413750
Lead Data Architect at a financial services firm with 1,001-5,000 employees
The performance needs some improvement and it needs more features integrated into it. Technical support could be better. Scalability could be less costly. One of the conflicts with Microsoft is if you have an enterprise relationship, you have to deal with a third-party offering Microsoft solutions. In the 2016 version, they don't have support for Python. It may be included with the 2019 version but if they don't, I would like to see support for Python implemented. View full review »
Girish Vijay
Deputy Manager IT at Carl Bechem Lubricants India Pvt Ltd
CAL licenses should cost less. Microsoft usually prices high for client access licenses. Server plus user client access license (CAL) licensing requires a separate Server license for each server on which the software is installed, plus a user CAL for each user accessing the server. A SQL Server CAL is required for a user to access or use the services or functionality of either edition of SQL Server and frequent updates to the latest versions will lead to obsolete and discontinuing the security patches has to be improved. View full review »
reviewer1478481
Senior Developer at a non-profit with 10,001+ employees
If you have a lot of data and you want to perform computations on it, you will have problems and the performance will be degraded. There are problems when you are dealing with Big Data and it doesn't scale very well. For example, in Hadoop, you can partition your data very well, but in SQL Server, you can't do that. If it could handle horizontal scaling then that would be an improvement. We experience latency at times when there is a lot of data being processed. In Iran, there is a specific time when all of the markets are open, and a lot of people are using the data to make decisions. Performing actions at that specific time gives us a lot of problems because of limitations in SQL Server. The problem seems to be caused by writing a lot of data to the table at the same time. Improving the intelligence for managing the SQL server would be very good. View full review »
reviewer1470330
Analytics Manager - Data and Capability at a financial services firm with 1,001-5,000 employees
The solution could use better governance on the management side, especially around data governance. The product could do better at allowing for integrations. View full review »
Navee Srichaiyanont
Network Engineer at a pharma/biotech company with 1,001-5,000 employees
Overall, the solution could be improved in future releases. We hope to improve the way we use it ourselves in our next project. The solution could offer better integration with other solutions - specifically Microsoft. View full review »
Rafael Keller
IT Manager at a consumer goods company with 1,001-5,000 employees
The pricing could be improved. I would like to have the option to use fewer processors for certain tasks, thus reducing the licensing fee. That would be great. View full review »
MD.SIHAB TALUKDAR
System Engineer at a non-profit with 10,001+ employees
The number of concurrent users is too limited and other databases are better than SQL in this regard. There are limitations with load balancing. We would like to see support for in-memory processing. View full review »
Lei Liu
DBA,data architectuire at LGCNS CHINA
Horizontal partitioning. In that case, cold , warm and hot data can be distributed into different database not only table partition located on different FGs . View full review »
Rmegio Lawag
Technical Department Manager at Direcbusiness Technologies, Inc.
I think a web console for the management studio, I think that would be a good thing. I think also on load balancing. I think that's something that we can use. View full review »
SashisekharPanda
General Manager/MVP at Yotta Infrastructure Solutions LLP
The scalability and the high availability feature can be expanded or improved. Currently, there is a limitation on scalability. A feature similar to the Oracle Diagnostic feature can be included to provide a better user experience. View full review »
MartinAnderson
SQL Developer, Data Analyst, and BI Reporting Engineer at BNS
Price could be cheaper, and access to reporting tools should be better. View full review »
Daniel Du Toit
Systems Analyst Developer with 1-10 employees
It would be nice to search for specific value across multiple tables. This would save a lot of time. View full review »
Johan Malan
System administrator at ZEST WEG Group
In terms of improvement, it could use more integration with other products. View full review »
Shafeeq Ahamed
Enterprise Solutions Department Manager at a tech services company with 201-500 employees
The time series database could be improved. There needs to be more storage space for large documents. The user interface and the reporting could also be improved. It's not bad, but it could be improved upon. View full review »
Victor Sokolov
DWH Architect at B2BSoft
We would like to have a common storage option in the SQL Server. This option is available in Oracle Database. It would be great if Microsoft could create something like a columnstore that has not only indexing but also tables for common storage. View full review »
reviewer1030020
Programmer Analyst at a tech services company with 10,001+ employees
Every good tool has its own limitations. * First of all its cost. It is very high. * We need a good amount of RAM to properly use this. * Sometimes, query sticks in between. But our organization provides great RAM, so we don't have any issue with its speed. View full review »
GhamdanAl-Anesi
Member of the Board & Co-Founder, Executive Manager at Networld Systems
I would like to have more replication scenarios. View full review »
Menoj-Roekalea
Cloud DBA at UNIT4
I would like a mature real-monitoring built in into SSMS, even a trace file analyzer. 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,108 professionals have used our research since 2012.