SQL Server Reviews

We use the solution to install different databases.

We were using SQL Server as a major database in our organization. We partitioned the data in such a way for a more extended period, and our archival process may manage that.

We mostly use linking servers and several applications; one pulls data from another. Thus, we created a Linked Server and implemented a replication algorithm to facilitate data transfer between different sources.

The solution’s pricing and integration could be improved.

I have been using SQL Server for 20 years.

The product is stable.

I rate the solution’s stability a 9 out of 10.

More than 1000 concurrent users are using this solution. We use horizontal and vertical data partitioning, allowing us to manage and distribute data across tables efficiently. Additionally, we use sharding for certain databases to handle large datasets effectively.

Support is good. We never had any problem with the support.

Compared with other databases like Oracle, SQL Server stands out due to its robust parallel processing capabilities. It is well-suited for handling large volumes of data. Oracle is preferred in enterprise scenarios with big databases because of its support.

The initial setup is easy and takes around 15-20 minutes.

We use data instances to deploy SQL Server in some cases. We had the static deployment.

We used Windows authentication to ensure more secure communication with the server. The entire request was encrypted with a server certificate, providing point-to-point security for our application. Additionally, when storing sensitive information such as credit card details or specific premises, we ensured it was encrypted in transit and at rest.

The SQL Server interface is better than that of Postgres.

We needed query optimization and data analysis to enhance query performance. Based on the database, there were many stable participants when the load was very high. We marked some of the queries for optimization to achieve better performance. We devised a plan, including creating more indexes, to improve the overall performance of the SQL Server. These were the steps we took to enhance the performance of the SQL server.

It is more compatible with customer service than any other database.

Overall, I rate the solution a 9 out of 10.

Most of our clients use SQL Server as a back-end source.

Agent service is a good feature of SQL Server, where you can schedule certain tasks. The solution's encryption feature allows the data to be encrypted while transferring from one place to another. The solution's performance and speed are also good. Indexing and Magic Tables are very good features of SQL Server. We have a different transition style with the solution.

SQL Server is an expensive solution, and its pricing should be reduced.

I have been using SQL Server for 18 years.

SQL Server is a highly stable solution.

The solution’s performance and scalability are very good. Our clients for SQL Server are enterprise businesses.

I rate the solution a 9 out of 10 for scalability.

The solution’s initial setup is easy.

The solution can be deployed within a few minutes.

SQL Server is an expensive solution.

On a scale from 1 to 10, when one is cheap and ten is expensive, I rate the solution's pricing a 9 out of 10.

The solution has a good data recovery feature. There are a lot of ways you can recover data. You can manage the recovery, resilience, and disaster management with SQL Server. I would recommend SQL Server to other users because it's easy to use, stable, and has a lot of features. The solution is suitable for different types of companies as per the requirement, including small, medium, and large enterprises.

Overall, I rate the solution 10 out of 10.

We use Microsoft SQL Server as our main database. We implement our solutions to the client site, providing the machines and the SQL Server license depending on their requirements.

The SQL Server is being deployed on-prem. Most of our clients are from the pharmaceutical industry. If there is a physical database, they want a self-hosted server always on-premises. However, the market is slowly adapting to cloud servers. Scalability and security have increased, so now people are going with cloud servers like AWS, Azure, and Google Cloud. Most of our clients are hosted on-premises and they have their own server, so we don't go with any cloud server. However, we are planning to move ahead with cloud servers for many of our clients.

The replication feature, user interface, reporting services, and notification services are really good. They are providing SQL Profiler and sqlcmd as their integrated software, so we don't find it difficult to integrate any of our third-party applications with MS SQL because all of them support MS SQL very clearly. As a part of optimization, it is good for processing huge amounts of data.

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.

I have been using MS SQL Server for 11 years, from the very first day of my job. MS SQL is widely used because its compatibility is good, especially with the .NET Framework because most are Microsoft products. The integration and the response are good, especially if you have huge amounts of data.

Now in the market, there are NoSQL options like MongoDB and Hadoop. Previously, there were pretty much three main databases: MS SQL, Oracle, and MySQL. MySQL was mostly used for small software, but many enterprise software were using MySQL because of the configuration, the compatibility, and the performance.

If you're using platforms like ASP.NET and C#, then you will want MS SQL Server because enterprise-level Microsoft provides many features like analytics services, reporting services, notification services, and now they're providing Microsoft Azure integration services.

MS SQL is very stable. However, the corruption of databases needs to be handled more accurately. If I'm using MS SQL Server and my server accidentally restarts or one of my machines restarts accidentally, then usually the MDB or the MDF file is corrupted. That corruption of files should be handled more efficiently because the client loses most of the data. Of course, the backup plan should be more efficient, putting less load on the server. That needs to be improved and more optimized.

Scalability is good. We have worked on almost 25 loads of data and 35 loads of records in a month. Most were working fine, but after time the process slows down a bit. In MS SQL, the initial 70% would work fine, but when the database starts and the load gets full, it causes slow processing. But considering the cost, features, and compatibility with Microsoft, it's a very stable database.

I have not been in a situation where I required help directly from MS SQL Server because we have our own service team that handles those issues.

Initial setup was a bit complex, but it's doable because it has improved a lot. Previously, it was very hard to install MS SQL. If I had the 2016 version already installed, it allowed me to install 2018 as well. The report features were distributed between two services, and that's where it causes problems.

We implement our solutions to the client site.

For personal websites and personal software that isn't used by more than 100 people, I will always go for MySQL for two reasons: MySQL is free and the enterprise is very low in cost.

Oracle Enterprise is another option, but the cost is high when you consider that MySQL is free.

I would rate this solution 7 out of 10. 

Microsoft's modules are really good. The syntax used for running the query is really easy. Their options for concurrency and locking are good, as well as their prices. They have created separate models such as distribution services and replication services. They are really good options so that if I want to take that service, I pay for it. If I don't want to, then I don't install it and I don't use it. Modular installation is something that I like about MS SQL Server.

If you have a lot of knowledge about MS SQL Server, you will be able to handle huge amounts of data very efficiently. However, you should make sure that you have regular backup protection. 

The servers which you have to purchase for installing, implementing, or managing MS SQL Server need to be optimized in a better way so that you get optimized performance from MS SQL.

Our correlation and relational databases are on Microsoft SQL Server.

The company uses two platforms: MySQL and Microsoft SQL Server. Some applications are on MySQL, and some applications are SQL Server. 

I have pretty much worked all my life in Microsoft SQL Server.

I am in the process of creating a data strategy to consolidate multiple siloed data centers. Once my plan is finalized and approved, then we are going to execute it on the Microsoft platform.

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

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.

It is one of the most stable relational databases out there.

With the new versions and Azure, which is in the cloud, these do accommodate scalability. Until the 2014 version, the scalability wasn't there, but from the 2016 version and above, I think they have taken all these scalability features into consideration.

I have not used technical support for Microsoft with my current company. I have used them in the past. It depends on the tier of support that was purchased by the company as to the level of support that you receive.

Our company has probably been using this solution since it was released.

It is expensive, but you get what you pay for.

Since we are a cloud-based company, there is AWS pricing on top of the SQL Server pricing. The Enterprise Edition can typically sell from around $1000 dollars a month, which is not cheap. Then, there is an additional one-time Windows cost, based on the code, which can go anywhere from $30,000 to $40,000 for the license.

From my perspective, the two vendors for this are Microsoft and Amazon (AWS).

They are working on making it better with every release, compared to Oracle Db2 and IBM.

I would definitely recommend SQL Server. It's not cheaper any more, like it used to be, but if you can afford it, then it's the best.

When I select a vendor, from a tool perspective, I make sure that they have full support available, have been in the market for awhile, and the solution/application is stable.

From an open source perspective, like MySQL, Aurora, and MongoDB, they have done a great job in making a robust database container.

We use SQL Server to store applications. The SQL Server manages various functions, such as digital innovation projects, document storage, handling login credentials, and maintaining authentication and authorization through the database.

Unlike MySQL, SQL Server is advantageous because it allows the execution of stored procedures and commands. It's easy to understand, run, and manage. Also, Microsoft frequently updates SQL Server, quickly resolving issues in new versions.

I have been working with the product for three years. 

My team has five users. 

The tool's deployment is easy. 

SQL Server offers three versions. You can get a free trial for 30 days. 

The solution is easy to understand if you know basic queries. I rate it a nine out of ten. 

SQL Server is essentially the backbone of every microservice. From a developer's perspective, it is the backbone of all microservices. The tool enables data retrieval, set data, and essential operations, ensuring the smooth functioning of applications. In essence, it is the integral part that keeps applications operational.

The solution's security features are good. 

The GUI  needs improvement. From a technical perspective, it's quite complex, which may not be a problem for individuals with technical backgrounds like ours, especially since we've encountered similar interfaces. However, navigating the GUI can be challenging for newcomers or product owners without technical experience. For example, as someone transitioning from a developer role to a product management role, I find it relatively easy to use the GUI. But for those without a technical background, it's much more challenging to grasp what's happening. 

I have been using the product for six years. 

I rate the tool's stability a nine out of ten. 

The solution's scalability and performance depend on application size and data size. Overall, the performance is pretty good and decent. My company has 20-30 users. 

I haven't contacted the technical support. Our DBA manages it. 

SQL Server is easy to deploy. A five-member technical team maintains it. 

I rate SQL Server a nine out of ten. It is robust, secure, scalable, and can store data. It can handle multiple users with good customer support. We have integrated it with IDE and Git. 

We use it for warehouse data management, as well as for statistical reports. It facilitates tabling and query processing while supporting multiple database operations. 

The solution is valuable because it seamlessly extracts reports and enables the collection of information from different tables.

There is a lot of room for improvement when it comes to limited compatibility across the platform and restricted performance with massive data sets. Enhancing those two areas would significantly improve the operation. It is important to mention the licensing cost, as well. Optimization of the licensing options to fit different needs and businesses would be of great benefit. 

I have used this solution for ten years. 

It is a robust and stable solution. Its tracking record is reliable and it can handle large volumes of data.

SQL Server offers easy scalability, allowing databases to grow as the data and user base expand. 

Their customer service is great. When we faced certain issues, they solved them fast. There were no problems with communication.

Positive

The initial setup is easy, and integrating the system is okay. The only issue is regarding the customization of the business process of the organization, it might take some time. Ultimately, it depends on the client's specific needs.

SQL Server is an expensive solution. Their pricing structure and licensing options are not budget-friendly, so I believe it is an essential factor to consider when choosing the right product.

It proved to be a great fit for medium-sized enterprises, in terms of the variety of the tools it provides. For bigger projects and specific needs, there might be a need to employ different solutions such as Oracle, and ERP systems. But overall, it works great as a relationship database management system. I would rate it eight out of ten. 

Out of all the tools in the complete SQL Server package, I'm mainly using Toolbox and SQL Profiler because I'm using SSIS packets, so we're using job scheduling a lot. And sometimes we are creating the SSIS packages, so I'm using SQL Server for MSD for maintenance purposes. SQL Server is quite user-friendly. I have experience with Oracle and PostgreSQL, so out of three, I like SQL Server a lot.

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. 

I've been using SQL Server for the last six years. I'm working with SSIS, SSRS, or MDS. These tools are part of SQL Server, and the back-end queries are developed in SQL Server. 

SQL Server is stable. SQL Server has crashed only two times in six years, but it wasn't a major system error. 

It may be a licensing issue, but sometimes its operating speed becomes slow if we have multiple users. It's lacking some performance, but it's acceptable because we have a heavy load. And I would like to add that we're running SQL Server and SSIS at the same time. So while I've found that SQL Server is quite fast, SSIS is a part of SQL Server. It is just for data testing in India. But if a person knows SSIS, then they usually have very little knowledge about SQL and vice versa.

I know both of them. I found that maybe it's a bad habit, but I'm using SSIS packages. And in the SSIS package, I'm using Toolbox from SQL Server to improve the latency. Implementing both together takes a little time. And one more point is data handling. I am just forwarding the error names, and there are multiple errors in the SQL Server tool, but what if a person comes to work under me and has only one or two years of experience?  Sometimes it might be difficult for them to understand what the errors mean. For example, when joining data, it's easy to implement the inner joint. In the inner joint, there are two columns, so when there's an output error, someone who is inexperienced with SQL Server might not understand. Error messages should be a little more precise and defined, so it's easy to understand.

Setting up an individual SQL Server is pretty straightforward, but when you are implementing multiple tools, it's more complicated. In terms of maintenance, for the DBA part, there are two based in my company because I am on a master device, so they don't allow me to maintain the server part. So one person is from South Korea, and the other is from China. They are handling my SQL Server. So maybe there are multiple teams, but I am contacting these two guys, the DBA. And I'm MDS, so I'm a single person. There are two people on my team, and I have one junior staff member. So I have a three-person team, and there are two DBA sites because I'm discussing my master team. I am deployed on the business side, and there are more than 80 people who are end-users of SQL.

If you're using SQL Server along with SSIS and SSRS tools, it works pretty smoothly and all. When working with Oracle SQL, PostgreSQL, MySQL, etc, there are a few problems with the connection.

Overall, SQL Server is good, but sometimes, optimization becomes a little bit tricky when you're using SQL Servers in place of Oracle. For example, while I was implementing two queries one time, the SQL Server gave me the wrong results. This wasn't because of their internal modules. So there may have been some missing data, but SQL Server failed to identify those issues. SQL Server needs to improve there.

For example, say there is a line with a value of 136 or 137. The second value is a space, and the third value is null. And the last one is space. So a space means this is also null. So you are comparing these four values, and if you don't have any idea about data, it's a little problematic. So cases like this, we can deal with such queries using syntax, but if a person has no idea how to deal with this, they'll face an issue.

Here's another example. Say there's a team query that means we are erasing data from the teams, and some people are just analyzing the string. So I see data from it, which means the calling system is there. In the calling system, we receive the data to call anyone, and that type of wire call setup is there. So I am receiving a full-text format from the file I have to upload in the SSIS package. And some cells have a null value. It's a text file, so you can understand there are blanks in some places. I don't know the file type, so I am just trying to dump it into our SQL Server. But when I have time to get to that table, I realize that some values are null, space, and blank. So these four values make problems for me.

I rate SQL Server nine out of 10. I would recommend SQL Server to anyone because you can use cloud-based services, so it's very beneficial. If you install SQL Server on-premise and on the Azure cloud, it is much more advantageous for you.