2018-07-19T09:31:00Z
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)
  • 2
  • 254

What needs improvement with SQL Server?

Please share with the community what you think needs improvement with SQL Server.

What are its weaknesses? What would you like to see changed in a future version?

94
PeerSpot user
94 Answers
PJ
Professional Services Manager at Business Intelligence DA
Real User
Top 5
2022-02-16T21:13:36Z
Feb 16, 2022

Oh... a chance to say what would be better in SQL Server? This is Data warehouse-related only.

1. Have more than 1 column as the partitioning column. We implement partitioning manually to be able to get 90% of the EE performance on SE because SE is so much cheaper.

2. Have materialised views able to be created on top of views and not on top of the underlying tables. We use meaningless table names and we have virtual tables co-habit physical tables. So materialised views requiring the table name to be used is way too much work and maintenance for how we build models. So we are maintaining our multi-level data using our ETL software. But Materialised views, implemented over views, would remove the need to maintain those levels in code.

3. Proper bit-mapped indexing to be able to perform vector joins on dimensional models on SE. That would be nice. Query plan resolution at detailed level results in slower queries so we do 95%+ of all queries on summary data that we maintain through our ETL software.

Those are the "big 3" that would make our life easier for dimensional modeling on top of SE.

Search for a product comparison
Don Ingerson - PeerSpot reviewer
QA Automation Engineer at Precise Circuits, Inc.
Consultant
ExpertTop 5
2021-05-02T19:32:20Z
May 2, 2021

My experience with SQL Server has been doing database testing with UFT. The main challenge we encountered is finding the correct connection string to use when performing database testing. Other than that, we encountered no issues.

DG
Information Systems Manager at a aerospace/defense firm with 51-200 employees
Real User
Top 20
2021-03-30T19:25:39Z
Mar 30, 2021

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.

RogerMorera - PeerSpot reviewer
Digital Transformation Architect at Comdata
Real User
Top 5Leaderboard
2021-03-11T01:58:50Z
Mar 11, 2021

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.

Tushar Rahatekar - PeerSpot reviewer
Sr. Systems Analyst at a maritime company with 10,001+ employees
Real User
Top 5Leaderboard
2022-03-30T11:32:00Z
Mar 30, 2022

Performance-wise, SQL cannot handle large amounts of data. In the next release, I would like them to commission SQL Server on Linux, as has been announced in the past but has not yet happened.

MakhosonkeMatshoba - PeerSpot reviewer
ESM Specialist at LetsCloudIT
Real User
Top 5Leaderboard
2022-03-29T17:56:28Z
Mar 29, 2022

The solution could have additional security.

Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: October 2022.
653,522 professionals have used our research since 2012.
MB
Sr. Training Manager with 201-500 employees
Real User
Top 5
2022-03-25T20:12:00Z
Mar 25, 2022

When we are talking about event space architecture, scalability generally comes into play. For example, I might have a hundred thousand transactions a second, and then all of a sudden, I build something that everybody in the world wants. The next thing I know is that I have a million transactions a second. So, to be able to process the throughput, I'd have to scale up, and then when the holidays are over, I'm again down to a hundred thousand transactions, and I want to scale back down. SQL Server is not going to do that. In this way, it is not very scalable. One of the reasons why they want us to use Kafka is so that if we need to, we can do that, but our base program is on SQL Server. So, this is where we would use a Kafka event stack so that if I need more servers, I can just write a command, and I can have more consumers, more brokers, and more producers, and when the holiday season is over, it scales right back down again. SQL Server is not going to do that.

MM
Group CEO at Mmusi Group
Real User
Top 5Leaderboard
2022-03-04T23:01:03Z
Mar 4, 2022

I would like Microsoft to evolve SQL Server because stateful databases dying are in a way. We would like to find out if it can absorb Hadoop and other similar things. They should make it useful for data mining. Data is evolving forever, and how we store it is also changing constantly. So, SQL Server also needs to change.

US
Team Lead, Process Improvement at Fidelity Bank Plc
Real User
Top 5
2022-02-18T14:01:59Z
Feb 18, 2022

The pricing could be more affordable. It's like to see less frequent updates. They should be once a month.

VA
Data Analyst at a healthcare company with 10,001+ employees
Real User
Top 5
2022-02-15T12:37:16Z
Feb 15, 2022

SQL Server backups could be better.

PJ
Professional Services Manager at Business Intelligence DA
Real User
Top 5
2022-02-14T15:02:13Z
Feb 14, 2022

There are a lot of things that it doesn't do in terms of business intelligence. However, you can live without a lot of them. A lot of people want AI/ML features, but SQL Server does not really support that space. R is included but it's kind of clunky. That said, you're not going to do AI/ML with SQL Server because you're going to use Synapse, Databricks, or another similar tools. SQL Server doesn't have proper bitmap indexing, a proper columnar database version, or proper implementation of materialized views. For example, if you want to do a materialized view, you can only do one on the base tables. You can't do a materialized view on top of another view. For us that makes materialized views useless.

Alaa T Alhorani - PeerSpot reviewer
Sr. Consultant (Enterprise Architect) at Devoteam
Real User
Top 5
2022-01-25T18:25:48Z
Jan 25, 2022

In my experience, while working with multiple sectors, such as banking, services, et cetera, there are some limitations for some sectors when dealing with the data. It would be great if we were able to run it on multiple operating systems and not only stick with Windows.

DK
Senior Systems Engineer at a energy/utilities company with 201-500 employees
Real User
Top 10
2022-01-24T09:32:37Z
Jan 24, 2022

They need to improve their support. It should be faster.

IH
Advisory Software Engineer at a tech services company with 1,001-5,000 employees
Real User
Top 10
2022-01-13T10:42:00Z
Jan 13, 2022

Other than Synapse and the other version of SQL Server, they face some problems while processing the data. For example, the one issue we face is that when we need to process the queue, it's costly with Azure and SQL Servers. We also face some memory issues with that.

AJ
Data Analyst
Real User
2021-12-27T19:55:11Z
Dec 27, 2021

The way SQL Server pivots data could be improved. For example, I would like built-in comma-separated pivot and unpivot functions.

Amir Saudi - PeerSpot reviewer
Business Intelligence Manager at a consumer goods company with 10,001+ employees
Real User
Top 10
2021-12-08T01:24:00Z
Dec 8, 2021

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.

AK
System Architect, SCRUM Product Owner at a tech company with 10,001+ employees
Real User
Top 5Leaderboard
2021-11-24T10:40:22Z
Nov 24, 2021

SQL Server could improve by having better usability or user guidance.

VC
Sr. Solution Architect at Cybage Software Pvt Ltd
Real User
Top 5Leaderboard
2021-11-08T10:28:00Z
Nov 8, 2021

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.

ThembaNhlapo - PeerSpot reviewer
System engineer at a financial services firm with 51-200 employees
Real User
Top 20
2021-10-29T15:40:18Z
Oct 29, 2021

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.

Satyam Saxena - PeerSpot reviewer
Senior Software Developer at Birlasoft
Real User
Top 5Leaderboard
2021-10-28T18:15:10Z
Oct 28, 2021

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.

EM
Enterprise Solutions Architect at a comms service provider with 501-1,000 employees
Real User
2021-10-28T15:10:37Z
Oct 28, 2021

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.

MR
IT Developer at a financial services firm with 10,001+ employees
Real User
Top 5
2021-10-11T21:54:00Z
Oct 11, 2021

SQL Server could integrate better with other platforms.

MJ
Senior Database Administrator at a government with 11-50 employees
Real User
Top 5
2021-09-21T19:40:20Z
Sep 21, 2021

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.

Santosh Kurakula - PeerSpot reviewer
Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa
Real User
Top 5Leaderboard
2021-09-20T10:53:41Z
Sep 20, 2021

SQL Server could improve by enhancing the integration abilities, adding more inbuilt data security features, and simplifying the maintenance.

Roman Zubrytsky - PeerSpot reviewer
Principal, Sr. IT Consultant at a consultancy with 51-200 employees
Consultant
Top 10
2021-09-17T18:45:00Z
Sep 17, 2021

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.

Faruk Kutlu - PeerSpot reviewer
Managing Partner at Veribir Ltd
Real User
Top 5
2021-08-25T16:10:51Z
Aug 25, 2021

The solution could improve by being more user-friendly.

AL
Senior Service Architect at a tech services company with 501-1,000 employees
Real User
2021-08-21T09:02:59Z
Aug 21, 2021

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.

PS
Project Manager at a comms service provider with 51-200 employees
Reseller
Top 10
2021-08-19T14:50:58Z
Aug 19, 2021

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.

MC
Engineer at a manufacturing company with 10,001+ employees
Real User
Top 5
2021-08-18T12:34:26Z
Aug 18, 2021

It could be more stable.

FZ
Principal Database And Cloud Architect at a financial services firm with 10,001+ employees
Real User
2021-07-31T01:45:43Z
Jul 31, 2021

The price could be better. It costs a lot, and competing databases like Postgres are free.

VG
Regional Head Customer Experience at a financial services firm with 10,001+ employees
Real User
Top 5Leaderboard
2021-07-16T12:04:20Z
Jul 16, 2021

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.

RV
2de Solution Engineer - storage & compute at a financial services firm with 10,001+ employees
Real User
2021-07-13T16:18:52Z
Jul 13, 2021

We'd like the deployment process to be better in the future. The licensing is pretty expensive.

Manjunatha OK - PeerSpot reviewer
Marketo Consultant at Webtech software servies
Real User
Top 5
2021-07-11T12:39:11Z
Jul 11, 2021

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.

MS
Head of Technical Support at a real estate/law firm with 51-200 employees
Real User
Top 5
2021-07-09T10:16:58Z
Jul 9, 2021

They could improve by adding the SQL format.

RP
IT Specialist at a government with 1,001-5,000 employees
Real User
Top 5
2021-06-18T07:34:42Z
Jun 18, 2021

It would be better if it had more integration with other systems.

Tim Platson - PeerSpot reviewer
Solutions Architect at One Click
MSP
Top 5
2021-06-03T09:43:04Z
Jun 3, 2021

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.

SM
Global Head ICT (CITP & MIE) at The Aga Khan Academies
Real User
Top 5
2021-06-02T15:44:56Z
Jun 2, 2021

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.

MG
CEO at a tech services company with 11-50 employees
Real User
Top 20
2021-05-31T15:41:02Z
May 31, 2021

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.

Mohamed_Farouk - PeerSpot reviewer
Information Technology Manager at OrchidaSoft
Real User
Top 5
2021-05-29T17:22:34Z
May 29, 2021

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.

MY
IT at a financial services firm with 201-500 employees
Real User
Top 5
2021-05-27T21:04:00Z
May 27, 2021

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.

YT
Information Security Manager at a financial services firm with 501-1,000 employees
Real User
Top 5
2021-05-27T15:16:00Z
May 27, 2021

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.

Ossama Benaziz - PeerSpot reviewer
Operations Director at ALTERSIS Performance
Real User
Top 5
2021-05-13T12:18:00Z
May 13, 2021

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.

EN
Head of Data Analytics at a tech services company with 11-50 employees
Real User
Top 20
2021-05-08T15:48:08Z
May 8, 2021

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.

MP
Database Administrator at a computer software company with 10,001+ employees
Real User
2021-05-07T23:13:07Z
May 7, 2021

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.

CL
Data Analyst at a tech company with 51-200 employees
Real User
Top 5
2021-05-05T14:15:13Z
May 5, 2021

The installation process should be simplified. The configuration could be easier.

MP
CEO at SkyNet
Real User
Top 20
2021-04-06T13:38:19Z
Apr 6, 2021

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.

RB
Software Engineer at a comms service provider with 51-200 employees
Real User
Top 5Leaderboard
2021-04-01T10:10:32Z
Apr 1, 2021

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.

Alberto Geminiani - PeerSpot reviewer
Technical Director at Progetti e Soluzioni
Real User
Top 5
2021-03-27T19:05:32Z
Mar 27, 2021

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.

Lional Angelo - PeerSpot reviewer
Manager Digital Technologies at a real estate/law firm with 51-200 employees
Real User
Top 20
2021-03-06T07:29:37Z
Mar 6, 2021

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.

KH
Program Solution Architect at a tech services company with 11-50 employees
Real User
Top 5
2021-03-05T16:15:31Z
Mar 5, 2021

In my experience, I've found that scalability can be improved.

Prashant Baste - PeerSpot reviewer
Solution Architect at Team Computers
Real User
Top 5Leaderboard
2021-03-05T09:38:33Z
Mar 5, 2021

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.

ST
Director at Exela Technologies
Real User
Top 5
2021-02-24T11:06:46Z
Feb 24, 2021

Indexing, as well as integration, are areas of this product that need improvement.

VP
Chief Information Officer at a financial services firm with 501-1,000 employees
Real User
2021-02-18T14:03:20Z
Feb 18, 2021

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.

Yasin Bin Wasim - PeerSpot reviewer
Information Security Engineer at a security firm with 11-50 employees
Real User
Top 5
2021-02-18T09:56:02Z
Feb 18, 2021

I would like to see more integration with other products and it needs to be more secure.

Mike  Sax - PeerSpot reviewer
Vice President, Product Engineering at Logitix
Real User
Top 5
2021-02-14T14:42:24Z
Feb 14, 2021

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.

JJ
Business Solutions Architect at a real estate/law firm with 501-1,000 employees
Real User
Top 10
2021-02-12T14:21:00Z
Feb 12, 2021

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.

SL
Enterprise Architect at a educational organization with 10,001+ employees
Real User
2021-02-11T18:46:53Z
Feb 11, 2021

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.

SS
Software Engineer at a tech services company with 10,001+ employees
Real User
Top 5
2021-02-11T11:56:34Z
Feb 11, 2021

Better integration with other platforms would be an improvement.

RP
Project manager at a tech services company with 11-50 employees
Real User
2021-02-09T19:41:58Z
Feb 9, 2021

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.

SK
Senior Architect at a computer software company with 10,001+ employees
Real User
Top 5Leaderboard
2021-02-08T09:45:20Z
Feb 8, 2021

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.

RS
Business Analytics Manager at a transportation company with 201-500 employees
Real User
Top 20
2021-02-02T07:46:00Z
Feb 2, 2021

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.

Karel Van Der Walt - PeerSpot reviewer
Data Architect at ACPAS Loan Management Software
Real User
Top 5
2021-01-27T11:24:04Z
Jan 27, 2021

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.

WL
Senior Programmer at a tech services company with 51-200 employees
Real User
Top 20
2021-01-26T08:40:56Z
Jan 26, 2021

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.

HarkamalSingh - PeerSpot reviewer
User at a manufacturing company with 10,001+ employees
Real User
Top 5Leaderboard
2021-01-23T13:47:39Z
Jan 23, 2021

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.

SB
Software Manager at a computer software company with 1-10 employees
Real User
2021-01-06T07:14:00Z
Jan 6, 2021

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.

Reza Sadeghi - PeerSpot reviewer
Software Development Team Lead at asa com
Real User
Top 5Leaderboard
2020-12-30T13:34:32Z
Dec 30, 2020

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.

JP
Analytics Manager - Data and Capability at a financial services firm with 1,001-5,000 employees
Real User
2020-12-29T10:05:47Z
Dec 29, 2020

The solution could use better governance on the management side, especially around data governance. The product could do better at allowing for integrations.

DB
Sr Tech Business Analyst, Group Data Projects & Ventures at a financial services firm with 10,001+ employees
Real User
Top 20
2020-12-28T10:53:51Z
Dec 28, 2020

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.

Meindert Van Der Galiën - PeerSpot reviewer
Information Technology Software Developer at a financial services firm with 501-1,000 employees
Real User
Top 5Leaderboard
2020-12-24T07:39:41Z
Dec 24, 2020

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.

MM
Director of Data Analytics at a insurance company with 1,001-5,000 employees
Real User
2020-12-09T17:43:34Z
Dec 9, 2020

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.

Victor Sokolov - PeerSpot reviewer
DWH Architect at B2BSoft
Real User
2020-12-08T18:22:46Z
Dec 8, 2020

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.

NS
Network Engineer at IRPC PCL
Real User
Top 5Leaderboard
2020-12-08T15:13:05Z
Dec 8, 2020

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.

MartinAnderson - PeerSpot reviewer
Owner at BNS
Real User
Top 5
2020-12-06T10:59:48Z
Dec 6, 2020

Price could be cheaper, and access to reporting tools should be better.

Rafael Keller - PeerSpot reviewer
IT Manager at Pluris Midia
Real User
Top 5
2020-12-03T12:47:24Z
Dec 3, 2020

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.

Rmegio Lawag - PeerSpot reviewer
Technical Department Manager at Direcbusiness Technologies, Inc.
Real User
Top 5Leaderboard
2020-11-30T11:06:00Z
Nov 30, 2020

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.

SA
Enterprise Solutions Department Manager at Smart Vision
Real User
Top 20
2020-10-28T19:12:04Z
Oct 28, 2020

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.

KG
Lead Data Architect at a financial services firm with 1,001-5,000 employees
Real User
2020-09-03T07:49:44Z
Sep 3, 2020

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.

Girish Vijay - PeerSpot reviewer
Deputy Manager IT at Carl Bechem Lubricants India Pvt Ltd
Real User
Top 20
2020-08-06T12:29:00Z
Aug 6, 2020

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.

SashisekharPanda - PeerSpot reviewer
General Manager/MVP at Yotta Infrastructure Solutions LLP
Real User
2020-08-02T08:16:00Z
Aug 2, 2020

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.

BL
Certified Adjunct Faculty, School of Engineering and Computing at a university with 1,001-5,000 employees
Real User
Top 5
2020-07-26T08:18:59Z
Jul 26, 2020

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.

Aditya Sawant - PeerSpot reviewer
Assistant Manager at ECU
Real User
2020-07-22T08:17:25Z
Jul 22, 2020

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.

MD.SIHAB TALUKDAR - PeerSpot reviewer
System Engineer at asa
Real User
Top 5Leaderboard
2020-07-16T06:21:10Z
Jul 16, 2020

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.

Shanti Sahu - PeerSpot reviewer
Cloud Data Architect (Data service Team) at NTT Data India Enterprise Application Services Pri
Real User
2020-07-16T06:21:00Z
Jul 16, 2020

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.

AM
Sr. DBA/Developer at a financial services firm with 5,001-10,000 employees
Real User
2020-06-15T07:33:50Z
Jun 15, 2020

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.

Johan Malan - PeerSpot reviewer
System administrator at a mining and metals company with 10,001+ employees
Real User
Top 20
2020-04-19T07:40:00Z
Apr 19, 2020

In terms of improvement, it could use more integration with other products.

GhamdanAl-Anesi - PeerSpot reviewer
Member of the Board & Co-Founder, Executive Manager at Networld Systems
Real User
2019-09-22T17:46:00Z
Sep 22, 2019

I would like to have more replication scenarios.

Aju Mathai - PeerSpot reviewer
Database Architect at Huron Consulting
Real User
2019-03-24T08:52:00Z
Mar 24, 2019

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.

reviewer1030020 - PeerSpot reviewer
Programmer Analyst at Cognizant Technology Solutions
Real User
2019-03-07T09:15:00Z
Mar 7, 2019

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.

Lei Liu - PeerSpot reviewer
DBA,data architectuire at LGCNS CHINA
Real User
2019-02-15T03:06:00Z
Feb 15, 2019

Horizontal partitioning. In that case, cold , warm and hot data can be distributed into different database not only table partition located on different FGs .

MR
Cloud DBA at UNIT4
Real User
2019-02-13T15:52:00Z
Feb 13, 2019

I would like a mature real-monitoring built in into SSMS, even a trace file analyzer.

it_user525360 - PeerSpot reviewer
Enterprise Programmes Architect at a logistics company with 10,001+ employees
Real User
2018-11-19T01:28:00Z
Nov 19, 2018

* It does not scale up to a truly global environment. We operate in 220+ countries and territories with data services centralized in three data centers. The ability for MS SQL to operate in this environment is a challenge for anything spanning regions or having a global footprint. * It is best suited to supporting a single functional instance by business domain or a single country. * MS needs to work better at the WAN implementations transoceanic. * It also needs to have a less closed or less MS centric tool dependency as integration with other databases and non-MS development environments is always problematic.

it_user941640 - PeerSpot reviewer
Systems Analyst Developer with 1-10 employees
Real User
2018-11-18T07:31:00Z
Nov 18, 2018

It would be nice to search for specific value across multiple tables. This would save a lot of time.

Rahul Kumar Singh - PeerSpot reviewer
Software Developer at OATI
Real User
2018-08-10T00:57:00Z
Aug 10, 2018

* Third-party services from Redgate should be built-in to it, like SQL Search. * Debugging from the debugger tool functionality should be enhanced.

PF
Engineer / MS SQL DBA at Solvinity
User
2018-07-19T09:31:00Z
Jul 19, 2018

Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions.

Related Questions
CA
It Application Analyst at City of Corpus Christi
Jul 25, 2022
I work as an IT Application Analyst at a governmental organization (size: 1000+ employees). Currently, I'm researching Oracle Database and SQL Server. Which product is better and why?
See 1 answer
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
Jul 25, 2022
Hi @Ariful Mondal, @Anteneh Asnake, @OmidKoushki, @reviewer1488372 ​and @reviewer1362099, Would you have any recommendations for @Celes Agiriga? Thank for sharing your knowledge with PeerSpot community members!​​ ​ ​ ​
Akın Kurtulan - PeerSpot reviewer
System Director at Türkiye İş Bankası
Jun 9, 2022
Hi community members, I work as a System Engineer at a large Financial Services company. Currently, I'm trying to understand the main differences between the two Relational Databases tools: MSSQL and Oracle Multitenant Architecture? Can you share your opinion? Thanks.
2 out of 3 answers
PG
User at rpc relational publishing & consulting GmbH
Jun 7, 2022
Hi Akin, First, both DBs manage your relational data on several operating systems (Linux, Windows Server, ...) and as Cloud Services. The newer architecture of Oracle tries to support you in a mixed environment where you can distribute a large DB over your own servers and cloud services. But as we always saw in the past, if a new feature of Oracle is good, Microsoft will follow. So your main questions should be: -How big is your DB? The bigger, the more I suggest Oracle. -Are you in a mixed world (Cloud and your own servers)? If Cloud is Azure, I think SQL Server is a good choice. -Is the price a topic? The liscence rules of Oracle are sometimes complicated. Hope this helps a little.  
Martin Zwarthoed - PeerSpot reviewer
Freelance Database Specialist at a tech services company with 51-200 employees
Jun 8, 2022
Hi Akin, Without going into the technical details; did you have a look a the pricing of MSSQL and Oracle databases?  I always hear that the Oracle database is better than MS SQL. But I never got to test this myself. What I do know is that when I tell a customer the Oracle pricing, they are usually going in another direction.  You must have a very good functional reason to go for Oracle considering the price difference. As @Patric Gehl ​suggested: a very big database is good but for a good reason. Kind regards, Martin Zwarthoed
Related Solutions
Download Free Report
Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions. Updated: October 2022.
DOWNLOAD NOW
653,522 professionals have used our research since 2012.