SQL Server Room for Improvement
President at a consultancy with 1-10 employees
Somebody who knows it would easily say, "No problem," because we set up our log shipping in about three hours. We sometimes have challenges with it in terms of timing, of getting it out, backing it up, and sending it to the cloud. There are always the glitches, but I get a daily report on what's going on. Around 30 backup jobs are running at all times, because it is a big company. It's a 200 person company.
In the next releases, I would only like more enhanced backups and more restore points. Data backup and cyber protection are the number one things everybody should be thinking about now. They may not be, but they should be. We're going to go to the Azure environment because that really is a duplicate of the on-premise environment, just somewhere else.View full review »
There are a lot of improvements in the cloud space about which we open a case with Microsoft every now and then. These improvements are not in terms of features or functionality. They are more related to their own compatibility or connectivity on which they keep on working to improve the product.
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 »
They could increase the intelligence of SQL Server. That would be good for us. There are some good intelligent features in SQL Server. However, they need to increase the intelligence because people switching to SQL Server from other solutions are not so familiar with it. I've been working with SQL Server for the last six years, but people are coming from MySQL or Oracle, so it will take one or two months to adjust. Still, they could add some intelligent tools to convert Oracle into SQL Server something like that.
And sometimes when I'm writing a function, there is already a predefined structure available. So if they defined their structure more precisely, that would be good for us. And the last thing I would like to add is that SQL Server should handle queries more like Oracle does. For example, you submit a query in Oracle, and the whole table comes up. In SQL Server, you go to the table, right-click, and it lets you see the first 200 rows. Then on top of that, you can add 200 more rows.
So in place of those 200 rows, if I can update all my table records or search my table record without a new search query, it'll be very beneficial. That functionality exists in Oracle, but this feature is not available everywhere in SQL Server. So if SQL Server had the feature, it'd be great because SQL Server is lacking only on this point. For example, one of my clients is a semi-technical person, so I have to train them to file a query in SQL. And they say that Oracle is much better. Say, for example, that I wanted to query a particular employee from a list of all staff. So the query output comes, and they can directly filter out the data by just applying the filter. They don't have to use the drop-down menu and search for all the employees with a given name.
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 »
Performance could be improved. There could be more support toward PHP-based websites and toward providing direct plugins for connections, and the related services or application services could be improved. The user interface could be improved so that someone with less knowledge could easily integrate and use that particular module software.
In the next release, I would like to see a separate tool provided to schedule backup or implement backup solutions on any of the servers that Microsoft has installed. This would be a small utility which I could open and point out the backup parts as well as the type of backup I want. Once I decide the time and set it up, it should be able to connect everything and then accordingly run that back up on an automated basis.
Right now, people are making their own utilities to do that same thing, but it would be helpful if we could get it directly from Microsoft. Apart from this, it would be helpful to have small plugins or API-based connections, which could be used for integrating MS SQL with different platforms.View full review »
Business Analytics Manager at a transportation company with 201-500 employees
It's night and day if you compare it to Oracle, and I am an Oracle fan.
Their datatypes need improvement. The SQL Server language in itself, its datatypes, seem like they are stuck in the eighties. Even companies that work with an SQL Server, experts on J.D. Edwards that sits on SQL Server that handles all the data transformation, they've actually converted the SQL Server datatypes so that they are more useful and easy to handle on their solutions. That tells you right then and there that their datatypes must improve.
When you run your SQL optimizer there, on the datatypes, it's very costly because it's just this level of conversion that needs to happen as opposed to just calling it numeric, or as opposed to calling it something else. Their datatypes technically work. If you know what you're doing, it really can give you all that. However, on the optimization side, on the performance side, it does struggle.
The datatype conversion to push my data to an enterprise data warehouse is difficult. I can tell you Oracle data is so much easier to ingest into it and it easier than doing it on a SQL Server.
There are many issues that I face when I'm pulling data straight from a SQL Server agent. There are more collections that I need to do or handle before it hits my target table. I noticed that due to the fact that I've been working on different databases and ingesting everything in a data warehouse. It just doesn't flow properly.
Even on their SQL Studios, that Master Studio tools, even if you try to do your conversions on their own, even though this is their native tool, you're always going to have some problems and it's always going to give you some type of error. It is just difficult to tell you what the error will be. You have to dig in and figure it out. Most of that is due to datatypes. It's just not easy. It's like pulling teeth. Especially if you have had experience using a tool, like Oracle, that is just not that painful.
There seems to be a lot of patching, which leads me to believe there may often be stability issues.View full review »
Senior Service Architect at a tech services company with 501-1,000 employees
If it would be more powerful it would be pretty nice. The performance is not always the best.
Whenever we were setting up the databases, there were some character problems that did not exist on some of the other solutions. However, the exact issues are hard to recall and list. I prefer Linux solutions. That said, when we began the previous project, Microsoft SQL Server was not available for Linux platforms yet.
Nowadays, it's my understanding that there are different versions. I haven't been checking if the current versions are supporting Transact-SQL and stuff like that. I remember that when we had the first Linux-based SQL Servers were introduced, they were, of course, a bit limited from the feature point of view. Whenever it is Unix or Linux or whatever platform, it's easier to manage them and to handle them whenever you are doing remote work.
I'm not so big fan of the Microsoft platforms as a server. However, whenever it's needed then it's needed. If you are a consultant, you need to adjust your whole mindset to whatever it's needed.
If SQL Server could perhaps run on Linux, that would be good. Most of us prefer Linux and I've used a lot of Linux. I understand that SQL Server is quite powerful, but I'm not sure if the functionality is there, but if it could be used in an open-source type of environment, it would be very good.
Microsoft doesn't have active-active load balancing scenarios. It's always a failover cluster. There is no active-active cluster, which other tools, other database providers like Oracle, provide. If Microsoft can consider or probably come up with an active-active cluster, then it would be good. It will be more powerful in a scenario like that.
The pricing, while not the most expensive, is still quite high.
They have something called Parallel Queries, however, I don't know how it works. I've never tested it in a horizontal way. I'd like to understand a bit more about it and be able to use it horizontally.View full review »
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 »
Information Systems Manager at a aerospace/defense firm with 51-200 employees
They can build more performance-tuning tools in it. They can also make the stuff a little more user-friendly and provide the ability to schedule jobs.
They can perhaps also streamline it a little bit so that it is not so resource-intensive, which would be helpful. SQL Server has a tendency to consume all the memory you allow it to. If you are not careful, you can basically break your server. I would like to see it having a smaller footprint in terms of system resource consumption.
They might want to consider re-evaluating their pricing. It is expensive.View full review »
Senior Programmer at a tech services company with 51-200 employees
The licensing costs are very high.
I would like the scaling process to be more transparent and obvious.
There's a lot of documentation on the web, and it is quite extensive, and yet it isn't very well organized which makes it hard to find items often.View full review »
Business Solutions Architect at a real estate/law firm with 501-1,000 employees
It is costly to implement high throughput systems, beyond millions of transactions per second. The hardware to run the systems, especially for high availability deployments is expensive, i.e. more resources to run.
Linux-based editions are not yet proven to be on par with Windows deployments.
Row-level security is obscure to implement.
Running cloud offerings are expensive; for example, the Instance as a Service offering.
Third-party tooling is required to manage code version control.
Managing BLOB data is not equally simple to implement.
The engine that implements query plans was updated in the 2012/2014 refresh that could necessitate a costly rewrite of queries.View full review »
Something that could be improved is the cost because it's very high. That's the only thing I'm concerned about but the technology is good. We are looking forward to getting some discounts because we have a large amount of data.
Senior DBA & IT Consultant at MA Consulting
Database support could be improved. Oracle provides better support.
While the price of the solution is comparatively cheaper, people are paying to Microsoft, in any event, for other things that they're using.
Thoughs the licensing cost could be cheaper, this depends, as there is nobody who only uses the database with Microsoft. Every company has Windows, Office, Active Directory and all the security features of Microsoft. This means that, overall, when one buys these licenses together, he also gets the database. The focus is not on the price of the database, but what is actually being paid to Microsoft.
The licensing price could be better, more user-friendly. Things should be be moved from the enterprise to the standard edition.View full review »
We're quite satisfied with the solution. There aren't any outstanding features we would like to add.
The interface could be updated to make it slightly more user-friendly.View full review »
If you work with more than 50 gigs of data, it will run slower than Oracle.
Security is an area that can be improved. It could be more secure; more security is needed.
We have some clients who have been exposed to the SQL injection virus.
We would like SQL to be able to manage this problem or to come up with an alerting system to alert the user that the server has been exposed. This has become more of an issue because of the Corona Virus and people are working from home.
Some have been infected by the SQL injection Virus and will lose their data.View full review »
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 »
Owner at 2 Bit
I could use some more guidelines about making the correct queries to understand the structure better. I'd like to have a better idea and to understand how to make a nice query, which is good for the system and good for the hardware.
Sometimes you have to have different data in different tables and you want to merge them into something together. I'd like to be able to do this in a different way.
Sometimes I need to have more optimization. I want to understand how can I optimize this or that? Especially now, when we're working with a lot of camera information, where we are using a lot of cameras for photogrammetry, we need to take this data and put it into the SQL Server and we would like to be more flexible with the data.
With so much data, things can get slow, which is why I would like to be able to understand how to better optimize queries.
Those who are not familiar with the solution can find the initial setup intimidating and difficult.View full review »
I would like to see better integration between their link server and other platforms, such as IBM, due to the fact that, a lot of times, you want to set up a linked server so you can be on SQL and pull data off of another server using that link server. Sometimes they don't play well together. There just needs to be better integration for those types of situations.View full review »
Principal Database And Cloud Architect at a financial services firm with 10,001+ employees
The price could be better. It costs a lot, and competing databases like Postgres are free.
Senior Database Administrator at a government with 11-50 employees
Its ability to handle certain kinds of large data could be improved. Its high availability, segmentation, and disaster recovery features can be improved upon also.
There are not really any significant features that I'd like to see added to it.View full review »
The Message Broker portion of the solution is not very scalable in comparison to the rest of the solution. The problem is, you can exclude that portion.
The Task Scheduler has a lot of shortcomings. This could be improved quite a bit.
The enterprise version of the product should be more cost-effective.View full review »
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.
Software Engineer at a comms service provider with 51-200 employees
The solution was delivered to us, and we really don't interface with the solution directly. I can't speak to any features that are missing.
The only people that can use it directly are developers. It's not for everyday users.
The pricing in general could be better.View full review »
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 »
I don't have a deep technical knowledge of the solution. It's hard to discuss features that may be lacking.
The solution could be better integrated with the SQL Server Studio tool.
There are some complexities with the initial setup sometimes as there are a lot of options.View full review »
I think the treatment of database storage could be improved. There is also an intermediate locked file that prevents users from inserting or writing something in the database that slows things down. I'd like to see the Perform Volume Maintenance Task made available for locked files. It would mean that the SQL server can directly grow files. Without it, you have to go to the local system account, which can disrupt users. It's connected to the local security policy.
Global Head ICT (CITP & MIE) at The Aga Khan Academies
They have too many licensing options. They may want to simplify its licensing and bring it down to two, three, or four categories from ten to fifteen categories. Having so many different licensing options makes it difficult to decide which one to choose from. They can club things together. This is an area where they can make things easier for customers.
Every time Microsoft comes out with a new version, they like to move everything around. Updates are a bit intrusive. For example, it used to be in a certain place and then they update it, and now I can't find it.
Technical support could be better.View full review »
I would like to have a more directed modeling, to have the flexibility to design all databases using a graphic interface. In other words, the interface integration could be better.
To avoid the need to write code, many users like to use the database diagrams as an overall tool and, as such, the solution should be more flexible and user-friendly.
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 »
The solution is very expensive.
Technical support could be faster.View full review »
Senior Manager at a financial services firm with 201-500 employees
We may use different levels of SQL Server when it comes to licensing. We have some Enterprise and some Standard services. They can improve the recovery processes of the replication or disaster recovery scenarios for the lower-tiered version, such as the Standard server.
While we have many options in Enterprise, it's expensive for most companies.
The configuration process can be a little complex.
Technical support can take a while to respond in Turkey.
The solution may be better with some integration with some factory cloud software. With the standard version, the lodgement process is never enough. We are replicating near real-time to make recovery easy and to make all the RPO targets as expected.
You cannot recover SQL Servers, especially for big financial companies like ours. It's not easy to erect SQL Servers on any other site, and with an acceptable data loss in the foundations.View full review »
IT at a financial services firm with 201-500 employees
The Standard Edition and Enterprise Edition have certain limitations. While the latter is clearly more expensive than the former, it would be nice to see some of the features in the Enterprise Edition be moved to the Standard Edition. This will encourage many more people to use that solution.
If we were discussing the 2000 edition in respect of the SQL Server, I would probably cite security and performance as issues. However, nowadays, when it comes to an application connected to their databases, there is no real difference between MS SQL Server and Oracle. As a consequence, it would be nice to see the application be made more cost-effective. I am aware of much database self-management in respect of Oracle. I know that the last time a colleague of mine used this solution in California, he informed me that the application itself was managing the database.
At present, the solution uses the older connection and the schema is designed in such a way that it can actually provide a very low level of virtualization. Since the security is also hierarchical within the system, they've really done a very good job.
This said, I would like to see the database become fully automated.
BI Developer at a manufacturing company with 1,001-5,000 employees
The issue is that Microsoft is not really supporting the Multi Dimensional Analysis Services feature any longer and it's looking very obsolete. We're looking at replacing it.
SSAS-MD is difficult to make changes. It's a very complicated product in general — that's the issue. It is too complicated for most. It's too difficult to change. It's too difficult!View full review »
Information Security Manager at a financial services firm with 501-1,000 employees
The solution should be more secure and stable and have better performance, particularly as concerns the endpoint operating systems. I would like to have a better operating system that links the CPU and the RAM efficiently.
For the majority of our servers we have not used other operating systems, although there are certain features or requirements that necessitated their use, such as Red Hat. This was rare. Mostly, we used Windows OS.
As for the performance issue, we have recently encountered situations in which everything would fail in spite of the CPU and memory being 100 percent operable.View full review »
The IT and digital transformation department are a bit fresh in this company that I am working for. They have a lot of plans, a lot of visions. I don't know how are they are going to do the infrastructure. I don't know their vision.
So far, the solution fits the scope of our company. We aren't missing any features.
The integration could be better. They are not open-source, so the integration with other platforms is not that easy.
They do not offer the SQL Server Management tool via the installation. It is a separate tool I use when I'm trying to configure the mirroring with SQL Server Mirroring. This is not supported and I'm getting some errors on the database mirroring. So sometimes I use the 2014 management console and the 2017 server for that. If the customer does not agree to that, I use a query for the database mirroring connections.
Additionally, I think some kind of machine learning related feature should be included. This is because technology is moving fast and all of the customers are getting it easier. So developers are making machine learning products. That's why they should include some kind of a machine learning feature here, too.View full review »
You do need to have technical knowledge in order to install the solution. It's not something a layperson can do.
The scalability can always be improved.View full review »
Database Administrator at a computer software company with 10,001+ employees
Primarily, the data replication and the backup areas can be improved. It should have data replication capabilities and uptime capabilities. The native SQL Server Backups take more time than do the backup processes from LiteSpeed, and the backup compression is a little less.View full review »
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 »
The solution has legacy issues when it comes to compatibility. If you have older technology, you may run into compatibility problems with SQL.
The solution is rather expensive.View full review »
The price could be better:
Compare to Oracle it is cheaper but with the existence of many open source databases currently in the market, consider reducing the Licensing cost. Secondly, with the Core-based Licensing since SQL 2012 Version, the SQL Licensing price has substantially increased.
Postgres Extensions is a concept in Postgres to extend the Postgres features that are very useful for Performance Monitoring & Optimizations. Similarly option to extend the features as necessary.View full review »
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 »
Data Architect at a computer software company with 1,001-5,000 employees
One thing I don't like about SQL Server is the way they've set up security with users and groups. It just doesn't seem that intuitive to me. Adding some more explanatory information might help some. Sometimes the documentation is a little thin, but the same could be said about a lot of products.View full review »
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 »
The solution needs to be more secure. It's lacking, compared to, for example, Oracle.
The product needs to work on its scalability. Oracle can scale a bit more effectively.
Sometimes we have some performance issues. It's not like Oracle. Oracle is more powerful in terms of performance.View full review »
Technical Specialist at a media company with 10,001+ employees
The documentation could be much better. It's lacking right now. If there are better help pages, for even complicated queries and stuff like that that would be quite a help for users.
There were times where it was not working all the time, however, that could be due to some issues on our network side as well. I'm not really sure of that, and therefore can't blame the solution. However, I do remember experiences where, when I tried something, it didn't work.
Information Technology Administrator at a tech services company with 51-200 employees
More things in SQL Server need to be automated. We need to do a lot of things, especially on the cloud, and Oracle has better automation for handling these kinds of tasks. Automation is the key, these days.View full review »
SQL Server Senior Architect at a computer software company with 1,001-5,000 employees
SQL Server could improve the integration with nonrational database solutions, such as MongoDB.View full review »
In terms of exceptionally large databases, it doesn't scale as well as Oracle. It scales excellently and it's flexible and it can provide a solution for exceptionally large databases, but it doesn't work as well as Oracle does for this particular use case. The performance starts to drag in the case of exceptionally large databases; especially where there's a lot more feature functionality. With Oracle, there's a lot more tunability.View full review »
Software Manager at a computer software company with 1-10 employees
Our customers are willing to pay less. For SQL server they have to buy it, they have to purchase the license. So, if we can get some free open source, like Firebird, InterBase, Firebase, or something like MySQL and also PostgreSQL, whichever one is suitable for us, we'd like to pick one.
Additionally, in some cases it is quite difficult, like the lack of ease of the replication and other issues. They have to improve on that. They do not have features like "always on," which is complicated.
One feature which we don't like is that they are providing CLR, and CLR can only be written in dot net, C sharp. But actually it should be open for all languages to write CLR so that we can hide our code. The next thing is that the tangent PSQ is encryptable but it is decryptable, as well. From the developer's point of view, all procedures are exposed.
The solution is very different from Oracle, which is a product we also use.
Mainly the data capacity needs to be improved. The data values are limited. They are smaller or medium scale. The MySQL is working fine, however, when it comes to large data sets or large data volumes, Oracle can handle them better. The backup capacity needs to be bigger.View full review »
The solution should work to improve its search functionality.
It would be ideal if the solution offered better integration capabilities. In the future, we expect that our company will need to make more integrations with other systems.View full review »
Systems Engineer at a tech services company with 11-50 employees
For now, we've found the features to be sufficient. I cannot recall feeling anything is actually missing.
The pricing of the product could be better. They could make it more reasonable or more competitive.
Microsoft's technical support could be better.View full review »
Technical Content Writer at a computer software company with 51-200 employees
You need an experienced person to use that piece of technology so that you can store everything in a logical manner. We'd like it to be easier to store in a logical manner.
The scalability could be better.View full review »
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 »
Database Administration Team Leader at a transportation company with 10,001+ employees
Analysis services have a lot of room for improvement. Basically, manageability on the available tools. They should have improved them already. They are not very efficient. My main headache is with the analysis service, and it would be really good if Microsoft developed some additional tools that are more user-friendly to manage the analysis. This is both from the perspective of management, users' roles, and performance analysis. My main wish for SQL Server would be that management tools for analysis services grow and mature a bit.View full review »
2de Solution Engineer - storage & compute at a financial services firm with 10,001+ employees
We'd like the deployment process to be better in the future.
The licensing is pretty expensive.View full review »
IT Service Manager at a financial services firm with 1,001-5,000 employees
The solution could offer more integration with other platforms.View full review »
ICT Consultant at a tech services company with 11-50 employees
The product can cost a bit, however, it depends on how you use it.
The solution could be more secure.View full review »
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 »
Manager at a pharma/biotech company with 10,001+ employees
There are newer models that are available on the market. The agility of the non-SQL-based features is relevant on the market.
Integration is one thing but it's making use of all the iterations or the new cloud data result.
Today's architectures are in many different directions. Not always via SQL relational databases, but also NoSQL databases, and they have a pretty good Java database as well.View full review »
The solution could be better when it comes to security.
The solution is part of Windows services, which means that if these should stop running, the database system, too, would be affected. This makes it very crucial to constantly monitor the SQL Server, something which reflects on cheap personnel time.
Scalability could be better.
Although it comes with a cost, using the most recent version is highly advisable, since it would ensure a certain measure of bug fixes and stability. The sole issue would involve the cost, as this is expensive.
When it comes to integratable features, the monitoring should be addressed.
CTO at a tech services company with 11-50 employees
The solution is expensive. The licensing costs are high.View full review »
Chief Information Officer at a financial services firm with 501-1,000 employees
We had some difficulty doing the performance tuning when we migrated from the 2008 version to the 2016 version. We experienced a drop in the performance. We could not understand or figure out what caused the drop in performance. We did not change any settings to cause this effect. We tried to keep the same settings.
We feel that when running the 2008 version, it was much quicker in terms of performance.
That is an area of SQL Server that can be improved. Moving to a new version, you shouldn't have to change the configuration.
We have not been able to utilize it fully because it is not straightforward.
I would like to see the performance improved. Migrating should be easier and the scalability needs improvement.View full review »
SQL Server needs to improve in performance and monitoring because there are no specific monitoring solutions to detect and analyze events for issues in the database. You have to use another monitoring solution. If Microsoft could provide an update to this solution or provide a monitoring solution specifically for SQL Server, it would be very valuable.View full review »
On the SQL Server Management Studio (SSMS) side, I have noticed more bugs in terms of being able to connect to our SQL servers. I can't tell how many times my recent server list got dropped or cleaned out. It is a pain, and it would be nice to have that recent connect list when you connect in. For whatever reason, once in a while, I get a hard error, and it'll close. When I go back in, everything is cleared out. It is annoying when you are working with more than a hundred database instances.View full review »
Project manager at a tech services company with 11-50 employees
There should be more tools and documentation for tuning the performance of Microsoft SQL Server. It would be nice to have more tools for tuning because currently, all the tuning that we have to do with our databases is almost manual. We have to read a bunch of knowledge base articles, and this information should be better documented.
Its free text search should also be improved. It is quite important for us. Currently, we're developing our own free text search because of the lacking flexibility in Microsoft SQL Server. Therefore, we're kind of using elastic search and making different implementations in order to reach our targets. Using just the native free text search of Microsoft SQL Server is not enough for us. It should have more flexible features as compared to the current version.
Founder and Managing Director at a tech services company with 11-50 employees
I would like to see SQL Server add the ability to write to multiple sites or support replication between multiple sites at the transaction level. If we can have data available on multiple sites as quickly as possible, that would be a great feature.View full review »
Data Solution Architect at a comms service provider with 1,001-5,000 employees
Its security can be improved. When you look at the Windows environment, it isn't the most secure environment. It is exposed to so many attacks. They continuously need to improve the security of the platform on which it sits.View full review »
Domain architect at a financial services firm with 10,001+ employees
They could improve the solution by allowing more portability between on-premise and the cloud.
More improvements can be brought around hyper-threading. Like we see in work engines of hyper-threading. It is very complex in terms of the way they do it. If it was via CPU or something else, it would be much easier.
In a future release, they could improve by expanding their form base capabilities.View full review »
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 »
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 »
Head of Technical Support at a real estate/law firm with 51-200 employees
They could improve by adding the SQL format.View full review »
Chief Technology Officer & Vice President, Delivery at a recruiting/HR firm with 1-10 employees
Its support for JSON should be improved. It does support JSON, but the support is not good enough currently.
They should also improve the way indexes work. Its performance can also be improved because sometimes it becomes very slow for certain table designs.
It cannot have more than a certain amount of data. As compared to other databases, its capability to handle large volumes of data is not very good.View full review »
Head of Data Analytics at a tech services company with 11-50 employees
I think the scalability of the database could be improved if it could handle increased volumes of data. I'd also like to see improvement in performance when you are loading big amounts of data. Integration with other solutions would be a nice additional feature.View full review »
Enterprise Architect at a educational organization with 10,001+ employees
We have had problems implementing a data warehouse using SQL Server. It may be because the data is too big, although it claims to be able to handle the amount of data that we have. Perhaps there are some technical issues because there is something weird going on. It cannot find the correct IP address.View full review »
Assistant Vice President Global IT at a insurance company with 10,001+ employees
I want to see one improvement and this involves the replication between the DC and DR. We have limited options at the moment and it does not lend sufficient support for the number of databases. This means we have a huge number of databases, topping approximately 2,000. For the moment, this particular replication is not supported by SQL.
The support number of databases needs to be increased, as well as the database number of databases that it supports. That support cannot be found when it comes to the replication between the DC and DR.View full review »
CEO at SkyNet
Security is an issue. This is an area that needs to be improved.
There is security built-in, but most of the developers don't emphasize the security enough. When they are building the products or databases, they don't focus on the security of the database.View full review »
We are using an older version of SQL Server and the migration to a newer version could be made easier.
If you are a new user then this solution could be difficult, they could improve by making the overall usage easier.
In an upcoming release, they could improve the ability to customize the solution.View full review »
Director at a tech services company with 10,001+ employees
Indexing, as well as integration, are areas of this product that need improvement.View full review »
The way to make cursors and manage raw data in rows can be improved. Currently, the way to construct or build these cursors is very hard, and you can waste memory. You need a highly skilled person to make it more efficient.
It can also have support for Cubes, which is the organization of data in different dimensions by using MDX languages.View full review »
SQL Server is technically good. For questions or other queries, we go through the internet and they explain it there. I think the structure of their product is good.View full review »
Although I am satisfied with the solution, some clients have asked us to resolve technical issues, such as those involving silver solution and replication.
Associate Manager at a consultancy with 501-1,000 employees
You need to be careful if you have a very large amount of data, because the platform can be degraded if you're not on top of it. Oracle handles that issue better and it's the main problem I have with SQL Server. The performance should be better.
Sr. Solution Architect at a computer software company with 5,001-10,000 employees
If I compare the solution with current technology needs, like NoSQL, that have been prevailing now, they could improve it so there could be a single solution, where we could deal with a single database for both transactional as well as for the in-memory needs that we have.
For the integration part, additional interfaces would be an improvement. If SQL Server could expose certain APIs or certain interfaces which can be used for integration with the warehouse solution, then it would be great.View full review »
Enterprise Solutions Architect at a comms service provider with 501-1,000 employees
While this is a reliable product, it has room for improvement.
Although Microsoft SQL was accessible in some projects, we did not use it everywhere. It is determined by the project. It's quite beneficial in some circumstances, but it couldn't support SQL databases in others, consequently, we used other suppliers like Oracle, Informix DB, PostgreSQL, MySQL, and others.View full review »
System Analyst and Team Lead at a tech services company with 11-50 employees
The solution could improve by having more integration with other operating systems and other platforms.View full review »
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 »
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.
SQL Server could improve by enhancing the integration abilities, adding more inbuilt data security features, and simplifying the maintenance.View full review »
SQL Server could improve by providing something similar to an interface or dashboard where a developer can do debugging, this would make a developer's work easier. Additionally, the optimization could be better. If there was an interface showing information needed for the optimization it would help because there can be some data loss making it difficult to optimize the SQL Server.View full review »
The Management Studio is a pretty heavy piece of software, and it's sometimes slow. I would recommend making an express version of the Management Studio, which is lighter and has fewer features but is a little faster.View full review »
Price could be cheaper, and access to reporting tools should be better.View full review »
SQL Server consumes a lot of resources. You need to keep an eye on the number of resources involved. It expands and uses all of the memory available on the server. For this reason, I install it on separate machines.
Also, the ability to connect with other environments needs to be improved.View full review »
ASM at a healthcare company with 51-200 employees
Performance could be better. But I don't know if it's a problem with my application or with my database. Maybe it can have the capability, but I may not be using it to the extent that it could be used, or the configuration is not as per the standard.View full review »
The maintenance and tasks should be improved so as to reduce database files.
The complexity of the database should also be reduced, so that its size can be diminished.View full review »
The way SQL Server pivots data could be improved. For example, I would like built-in comma-separated pivot and unpivot functions.View full review »
The solution could improve by being more user-friendly.View full review »
Deputy Manager at a computer software company with 10,001+ employees
I would like to see improvements made to the stability of SQL Server, as well as more analytics requirements.
Senior BI Consultant at a tech services company with 11-50 employees
If this solution could provide an automatic indexing feature it would be very useful.
In the next release, there could be better integration with Power BI or other tools.View full review »
Software Engineer at a tech services company with 10,001+ employees
Better integration with other platforms would be an improvement.View full review »
I would like to see more integration with other platforms.View full review »
Regional Head Customer Experience at a financial services firm with 10,001+ employees
SQL Server could improve by increase the performance, it cannot handle large amounts of data. I did not find any additional features compared to others solutions.View full review »
senior system integrator at a retailer with 10,001+ employees
The stability of the product needs to be improved. It's really not stable enough.
In Microsoft, the Active-Active options are not available. There are a lot of requirements that are coming right from the customer, which may not be provided by Microsoft. There are a few use cases where we do need the Active-Active options instead of Active-Passive, yet those kinds of options are not available for Microsoft.View full review »
CEO at a tech services company with 11-50 employees
The stored procedure integration with our development could be better. Things are always changing very fast at Microsoft, and it takes a lot of resources to get on top of it. We're struggling with version control.
In terms of new features, we don't have any feature requests. We are not focusing on the database.View full review »
Data Analyst at a tech company with 51-200 employees
The installation process should be simplified.
The configuration could be easier.View full review »
In terms of improvement, it could use more integration with other products.View full review »
Program Solution Architect at a tech services company with 11-50 employees
In my experience, I've found that scalability can be improved.View full review »
CEO at a tech services company with 51-200 employees
There is room for improvement in performance when managing a large quality of data and a high number of active users.View full review »
Project Manager at a comms service provider with 51-200 employees
For small-scale businesses, Microsoft could improve by removing some limits in SQL Express.
In the future, it would be a benefit to have web-based management capabilities.View full review »
Senior Architect at a computer software company with 10,001+ employees
The performance could be better. When we pump in millions of records, we start struggling, and that's why we want improvement in those areas.View full review »
I would like to see more integration with other products and it needs to be more secure.View full review »
Engineer at a manufacturing company with 10,001+ employees
It could be more stable.View full review »
SQL Server could be improved with cheaper licensing because it's very expensive.View full review »
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 »
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 »
Chief Technology Officer at a financial services firm with 11-50 employees
I would like the SQL Server to be able to provide cloud support. We use the solution with a Korean provider supporting only MySQL rather than Microsoft SQL Server, which would be preferable and cheaper. This would prevent us from having to pay for troubleshooting and hosting the server.View full review »
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees
It would definitely be better if SQL Server were free.View full review »
Managing Director at D3
We want to move to Azure, and the solution could be made better to make the process easier for the migration from on-premise to the cloud.View full review »
Chief Engineer at a tech services company with 51-200 employees
The solution could improve by having better integration.View full review »
It will be very useful to have high-level database monitoring. It should also have built-in business intelligence reporting.View full review »
IT Specialist at a government with 1,001-5,000 employees
It would be better if it had more integration with other systems.View full review »
Technical Director at a security firm with 51-200 employees
It would be nice if they can reduce its price.View full review »
IT Developer at a financial services firm with 10,001+ employees
SQL Server could integrate better with other platforms.View full review »
Modern Data Center and Cloud Engineer II at a tech services company with 51-200 employees
The performance could improve.View full review »
System Architect, SCRUM Product Owner at a tech company with 10,001+ employees
SQL Server could improve by having better usability or user guidance.View full review »
Consultant at a tech services company with 11-50 employees
I would like to see the integration with other platforms improved in the future.View full review »