SQL Server Reviews

I love the developer version. Microsoft tells you about all the cool things they provided for everybody. You can develop and do anything with it. It's really good to learn. Oracle will not give you that much freedom, and Microsoft really kills it. 

You don't do anything with it but develop, learn, break, and push it to its limits. If there are problems, you show Microsoft or ask them, "what's going on here?" There is good community support for the developer edition, and that's what I really appreciate. You can teach people about it without limitations. You can have small databases created. You can keep it for a year and then work on it. It's a good thing for learners and developers.

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

I have been using SQL Server for about ten years.

There are problems in all systems, and I don't see any difference between open source and proprietary solutions. SQL Server, Postgres, and Oracle are all vulnerable. There are no known issues per se, but any system can be broken. There is nothing special about this database.

SQL Servers and other databases are all scalable. I just don't see any problem with scalability.

Whenever we have issues, we talk directly with Microsoft. They are responsive, and they help.

I'm more into open source solutions, and I love Postgres. I've worked as a database administrator as well. But I really hate all the tools used to manage performance or backup or just any of those disaster, recovery, and availability solutions. I hate them. They really impose a lot of overhead in a demonstration and aren't really flexible. When you're in the cloud, you don't have to worry about most of those things. 

Some of them still exist, but the cloud providers do provide them and you stick to that. You enhance them or add some more features, but really the most hated feature is, making sure that your database really can recover from many kinds of disasters. Resiliency, the most important part and when that is really managed by the cloud online, the overhead costs  are removed. The rest is really easy. Performance is okay, and there are indicated spots for data because I work with financial data and a lot of it is our important critical data. So, the cloud is really the best thing that happened to us.

When it comes to the initial setup, most of them can be automated. For example, most setup settings for progressions, management, disaster and recovery, failover, and failback. Most of those things can be automated and provisioned into one kind of pipeline. Connecting that data to an application and even provisioning from the code repository through Jenkins. Those things are really easy to automate.

It costs a lot.

I would advise potential users to use SQL Server with Microsoft Azure. I don't recommend managing it locally.

On a scale from one to ten, I would give SQL Server a seven.

There are many applications between Microsoft and SQL. Most are in the legacy direction, but some are more modern databases with those application requirements. We have used it for multi-purposes such as back-office products applications and cloud office environments.

The solution is easy to use, has rich feature sets, and is business-oriented. 

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.

I have been using the solution for a couple of years.

I have found the solution to be very stable.

The solution is scalable.

The support is good for the solution.

We used Oracle and DB2 in the past.

Initially, the installation took a while. We have started deploying configurations that are now standardized. We have automated it, but it can still be problematic. For the most part, the installation is now quite easy. Additionally, The way they have many configurable parameters that influence performance is in a way problematic.

We did the deployment of the solution and we have a team of 15 people doing the deployment and maintenance.

The licenses are really expensive. Their licensing model should be more simplistic.

I would recommend this solution to others and we plan to keep using it in the future.

I rate SQL Server a nine out of ten.

SQL Server is used to establish secure storage and protect databases from potential vulnerabilities, including those originating from Slack.

The most valuable aspect is the ability to use jobs and various functions to accomplish specific tasks, which cannot be achieved with standard procedures alone. This allows for a combination of features and functionalities to be employed.

I have experience working with SQL Server 2016 and older versions, including handling JSON data. Initially, I found the JSON capabilities to be less helpful, but over time, they have greatly improved. 

SQL Server now offers extensive capabilities for working with various forms of data, particularly when communicating with text, such as in JSON format. 

I particularly prefer working with these features on Azure, as it provides numerous possibilities, especially in the field of business intelligence (BI). Additionally, the serverless platform offered by Azure is highly beneficial and makes tasks easier to manage.

I have not seen significant returns thus far, but I am eager to enhance my experience by transitioning to work in Azure. This shift to Azure is something I am motivated to improve upon.

I have been working with SQL Server since 2018.

We have not had any issues with the stability of SQL Server.

Scalability is dependent on memory.

The matter at hand pertains to whether we are discussing an issue in general or specifically in the context of on-premises environments. However, it is clear that memory and capacity are significant factors in both scenarios. 

Proper management of memory and capacity is essential to ensure smooth system operation and prevent any performance or stability issues. 

As a result, it is essential to handle these issues completely and appropriately in order to meet the system's requirements.

I have not contacted technical support.

The installation process is not complex, but it requires attention to detail in terms of selecting the necessary services and configuring the Cisco server. 

This ensures a proper setup and a tangible model for effective management. While it may not be complicated, it is important to choose the appropriate features during installation. 

Working with ID was not my primary focus; however, I have had the opportunity to work with it for several companies.

It can take an hour to an hour and a half to deploy.

Maintaining it is more challenging than the initial setup. One of the main concerns is ensuring sufficient memory allocation. The default capacity is typically set around sixty, but it can be increased if needed. If there is insufficient memory, it can lead to server downtime and cancellation of transactions, as exceeding the memory limit poses a risk. Therefore, it becomes crucial to address this issue by allocating more memory resources. Additionally, backups and restores play a significant role in ensuring data safety and recovery in case of any issues.

For a brief period, approximately one year before 2018, I had experience working with the open-source version of SQL Server. During that time, I found SQL Server to be the preferred choice, in my opinion.

I developed an application for specific purposes related to McDonough. Using Microsoft SQL Server, I constructed the entire database and implemented supporting stored procedures. This application was commissioned by the European Union to enhance government institutions and similar entities.

Additionally, I worked on financial-related stored procedures specifically related to Serbia Card, as part of a project for the USA.

We acted as a subcontractor for S&P within your company. I have extensive experience in SQL Server, particularly within the Microsoft environment.

They should think twice before they do anything and double-check. Definitely.

I have explored different options such as SonicWall and open-source solutions, but my preference lies with SQL Server. I find SQL Server to be fantastic, as it provides comprehensive functionality and makes tasks incredibly easy. 

Working with Postgres is also simpler compared to other databases like Oracle. Perhaps my familiarity with Excel has made SQL Server more intuitive for me. While I understand that Oracle is known for its complexity, I appreciate that its code and syntax bear similarities. 

Overall, I have a strong affinity for Microsoft products.

I would rate SQL Server a ten out of ten.

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.

I've been using SQL Server for thirteen to fourteen years.

SQL is a highly unstable server - there are patch updates on the Windows server every week, which is why we only use it for non-critical systems. 

The initial setup was very easy - much, much easier than Oracle - and took about a day to complete. Microsoft is less demanding because everything is GUI, unlike Oracle, where you need to use command lines.

This is a very cheap product.

SQL's performance is good enough if you have a low amount of data. For those looking into implementing SQL Server, I would advise first analyzing your requirements and whether your system is critical or non-critical. If it is non-critical, go for SQL as it will save you in terms of cost, but if it is critical, avoid SQL as it will bring you down in one day. I would rate this solution as eight out of ten.

This is the main database for our financial system. I'm the IT manager and we are customers of SQL server. 

We've been using this solution for many years.

We're satisfied with the stability.

We have around 100 users. The database isn't used directly, so users are not even aware that there is a SQL Server underneath. 

There are some local companies that have direct relations with Microsoft. We use them regularly when we need some support.

I don't recall, it's been many years since we implemented this product. 

We pay a license fee, it could always be cheaper.

I recommend this solution and rate it 10 out of 10. 

We use this solution to store our data and for running queries, simple select queries that enable me to create the views I need and report from those views. I'm an ESM specialist and we are customers of SQL Server. 

I like the stability of the solution, the fact that you have two, three, four nodes replicating at any given time at different locations, and they're all synchronized; if one is lost it automatically moves to another. The other advantage here is that when it comes to application maintenance, you switch onto another node while you maintain another server and there's no downtime. 

The solution could have additional security. 

The solution is easily scalable because of its flexibility.

I don't do the installation, but it appears straightforward according to those who carried out the implementation. These days deployment takes about an hour. We have 1,200 or so users. With the onboarding of more customers, we'll be increasing our use of SQL Server. For now, we have one person dealing with maintenance. 

I rate this solution nine out of 10. 

We use SQL Server for developing systems.

The most valuable feature of SQL Server is the performance.

I have been using SQL Server for years.

We have approximately three people who are using this solution.

The technical support from Microsoft has been good.

The initial setup of SQL Server is straightforward.

We have two administrators that did the implementation of the solution.

The price of SQL Server could be reduced, the license is expensive. We have an annual subscription.

I would recommend SQL Server to others.

I rate SQL Server a seven out of ten.

We are using SQL Server for data processing.

The most valuable features of SQL Server are the speed, great support, and it is from a known vendor.

The security features of the solution could be better.

I have used SQL Server within the past 12 months.

SQL Server is a scalable solution.

We have approximately 200 users using this solution. We increase the number of users every year.

I have not contacted their technical support.

The process for the deployment is straightforward. It takes approximately four hours to complete.

We did the implementation of SQL Server in-house. We have eight people managing the solution. The team includes managers, technicians, and administrators.

There is a subscription that needs to be purchased to use the solution.

I would advise others this is a good Microsoft solution.

I rate SQL Server a nine out of ten.