SQL Server Reviews

We developed a product that is using five or six databases supported on SQL Server. 

It is a very user-friendly solution. It is easy to manage the databases and troubleshoot any issue. It is a perfect solution for the volume or transactions that we need to manage.

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.

I have been using this solution for ten years.

It is very stable. I would rate it an eight out of ten in terms of stability.

It is scalable. You can get scalability by using the link servers, or you can create another instance in another server and make a link with that server. It is very quick.

We have around 50 users of this solution.

I have not interacted with them.

Its initial setup is easy. It takes a week. One of the things that you need to pay attention to is the collection.

It is a nice product. You can use it as you want. If you don't know how to use it, you will waste it. Oracle is more powerful than this, but it is great for our needs.

I would rate SQL Server an eight out of ten.

We are a company that produces stock market analytics data and we are working on creating an alerting system for our customers. We use Microsoft SQL Server in our development and I have a lot of experience with it.

In my development role, I store about two gigabytes of data every month.

One of the big advantages of this product is its performance, where it works well when the data is not complex.

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.

I have been using SQL Server for the past four years, and my company has been using it for approximately seven.

I have seen that this is a very stable product.

We had trouble scaling the solution to handle larger volumes of data. We have been able to scale out by adding CPU power and RAM, but other than by increasing the physical solution, we have not been able to do it very well. For example, we have not been able to do what we have done using Hadoop.

I used Oracle in the past, approximately four years ago. That was stable, but the performance in SQL is very much better nowadays.

The initial setup is very easy.

Our in-house team deployed it by researching how to perform the setup and configuration. As a developer, I just let them know what I need from the product. For example, for my role, I have a lot of writes and I want them to optimize for that situation.

If there are some simple features that I just want to enable, then I can do that myself.

I would rate this solution an eight out of ten.

The primary use is to maintain my database client.

What I like best about this product is the environment.

The documentation and manuals are very good.

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.

I have been working with SQL Server for more than 10 years.

I use SQL Server on a daily basis.

The scalability is not very good because when you add processors to the machine, the price of the license goes up. Scaling is very expensive. We have approximately 500 people who are using it.

Technical support is very good.

We used the Oracle Database prior to SQL Server.

The initial setup is simple and the deployment took one day.

We had assistance with our deployment and the experience was very good.

This is an expensive product, especially when you need two servers, or for enterprise solutions. We pay approximately $12,000 USD per month for both the server and the license.

At this time, all of my applications are running on SQL Server. However, in the future, if the application can be migrated to Oracle or another database then I may do that because SQL Server is very expensive.

This is a good product, although my advice is that if a company can afford it then they should use Oracle instead.

I would rate this solution an eight out of ten.

There are many, but I would have to say the two most important for me have been SQL Server Profiler -- to run traces and the ability to kill sessions in the enterprise manager tool. This command-based functionality lets you search and sort through processes actively running on the system to find your i/o hog – that is the user that is overloading the database either through a hung query or bad SQL code.

Once the hog user is found, the terminate or “kill” command can be used to shut down the hanging transaction. Similar to how clearing a vehicle crash on the interstate frees up waiting traffic, this kill command gives other users the ability to continue work as normal once the terminated transaction has been killed. This should be used sparingly though since it can cause waiting applications to corrupt data depending on how the application was written, but it is an often used research feature when a system starts to overload or show major signs of slowing.

In an effort to forego a data warehouse purchase, one company I worked with used a second SQL Server instance loaded to separate hardware as a reporting environment avoiding the need to hire additional employees to support a data warehouse. Essentially, the production database was snapshot and copied nightly to the reporting instance where it was restored through automated processes.

All employees who wrote queries and reports against the reporting instance utilized the same knowledge, skillset and tools already used in the OLTP production environment. While it didn’t have all the abilities of a true data warehouse, it was quickly implemented and well served for the desired purpose.

Multiple operating systems support should improve. The ongoing and newly marketed support for Linux and Unix environments running SQL Server is a big win for Microsoft, in my opinion.

Previous hold back related to open source environments stemmed from admins or management who would not run SQL Server for various reasons which many times boiled down to not liking Microsoft as a company.

Open source and Microsoft have conflicted in the open source world for years, but I think Microsoft is finally starting to turn that tide in an effort to compete with other vendors.

20 years. I began as a Microsoft Access database programmer in 1998 connecting early dynamic intranet websites to Access backend databases.

I later progressed to the SQL Server 2000 environment and have utilized SQL Server ever since then.

Issues encountered with stability were always correctable assuming we as a business were willing to spend money. The two major issues that come to mind were slowing of image files loading to disk using SQL Server and lack of proper indexing.

Images were archived for a 30 year legal period at a rate of at least 12 million per year and we eventually just hit a max depth of data where SQL Server had a hard time returning results. Shortening the physical file path structure of how deep SQL Server had to dig through the hard drive in addition to changing to new and improved disk technologies resolved the problem.

After this drive change occurred, a separate problem started where our database came to a crawl which is when we realized our regularly scheduled database index had not been updated to accommodate the new structure changes. A new index was put in place which is when SQL Server started humming along better than ever.

Microsoft makes life easy to expand your environment through clustering tools and after-hours operational scheduling features. SQL Server is easily suited for small businesses where it found huge popularity, but daily operations can sometimes be overlooked as the business grows causing intermittent operational kinks. I have seen a few small businesses determine that a slowing or overloaded SQL Server environment means they should look at more enterprise level databases, which is simply not the case.

Just like a Windows PC needs basic defragmentation maintenance to run effectively, SQL Server needs its own regular maintenance. There are many options available to improve the performance of SQL Server including the simple add-on clustering features which will balance excess load on the server.

In addition, database indexes need to either be created or re-indexed periodically. A database does not automatically know how an application was designed although it’s very good at trying to guess using built-in scheme mapping software. Creating indexes and related maintenance schedules specific to your environment can make a huge difference in how quickly SQL Server responds to data requests.

Disk partitions are another method for improvement. No matter how well SQL Server software is configured, it is limited by the hardware level. Underlying disk usage grows as data grows meaning the more data you add to the database results in the longer it will take for the database to find data on-disk. That’s when it’s time to either spread data across many independent disk sets or move to more expensive flash drives which save time by avoiding read & write disk operations.

These options, of course, require time, effort, and money, but they have been well worth the costs of doing business based on my experience.

I have only had to call Microsoft support 5 times in my nearly 20-year career, but they were extremely helpful. The one frustrating experience was 10 years ago when I worked over the phone 8 hours straight with 3 separate techs from the India location. Keep in mind, these were days pre-remote support meaning I had to verbally translate every diagnostic error I was seeing on the screen and assume the tech was clear on the meaning. The techs I worked with were extremely nice and tried hard to help, but I reached my frustration level due to the verbal language barrier.

The senior tech, who I spent the most time working with, had an extremely thick accent and was hard to understand. I could tell he had hit a dead-end on his knowledge of the product so I finally asked to be transferred to a specialist in America. Once I found the right person in the US, my problem was resolved within an hour.

In hindsight, I knew the senior tech was lost at the 6-hour mark, so I should have spoken up then, but he never complained and kept trying different solutions, which is good on Microsoft’s part.

My team and I have tried many different technologies including MySQL (cheap but effective), Oracle (expensive and effective), PostgreSQL, and DB2. I never jumped on the PostgreSQL or DB2 train, but could not give you a specific reason why due to my limited knowledge of the products. It usually came down to lack of knowledge for available programmers in our area, meaning we would have to train new hires and take a lot of time getting them familiar with a new database structure. That defaulted us to either Oracle or SQL Server since MySQL was not used in production at the time due to limitations surrounding support.

Oracle owns MySQL these days and they, of course, would prefer you run full fledged Oracle database for support needs. Oracle’s supremely expensive licensing has normally pushed me and coworkers to Microsoft SQL Server although every organization I have worked with pays for some form of Oracle even though SQL Server is primarily touching end users.

I personally feel Oracle is a great database but also think Microsoft SQL Server can be configured to run just as well as Oracle in most cases. The problem I normally find is that many bloated applications run SQL Server where more streamlined (and many times less functional) applications run Oracle. For that reason primarily, Oracle has had a better reputation in the pre-Amazon world.

This could all change in the years to come as Microsoft starts to fight Amazon and Google in cloud processing.

Creating a SQL Server instance using the pre-installed GUI setup screen available in either Visual Studio or Enterprise Manager can be very simple to create and maintain database “instances” making it a prime choice for small startup businesses.

In addition, Microsoft has added loads of training videos on their website along with step-by-step instructions for creating and maintaining servers. The user can get as complex as desired in SQL Server by learning all the behind-the-scenes commands the GUI is using. You will start researching commands quickly once the first SQL Server error occurs and the GUI doesn’t know how to resolve it.

For the most part, what you see is what you get with Microsoft’s licensing website. I sat through many hours of negotiations with many database and application vendors. Some application vendors try negotiating a better deal based on their licensed volume, but only twice have I seen Microsoft cater to lower licensing and it was because they wanted to make long-term wins with the customer knowing they had the possibility of gaining market share.

That said, Microsoft is still usually cheaper than Oracle who will sometimes look cheaper to start with but add the possibility of higher long term rates. Asking for a discount can never hurt.

MySQL (now owned by Oracle) is sometimes used internally for dynamic website needs, but Oracle is the only competitor evaluated for SQL Server.

Start in the cloud if feasibly possible and if it makes sense for your business. I have mostly worked with organizations that still don’t trust the cloud for security and legal reasons, but Amazon, Microsoft, and Google are releasing promising products in the cloud that are leaps and bounds ahead of processing power for local servers assuming your organization is willing to pay what it takes. I have priced cloud services enough to know they’re expensive, but they could replace a lot of unknowns for growing businesses or those starting from scratch; mainly network security, redundancy and technical skillset of employees.

Cloud services have full-time employees focusing on those niches meaning you as an employer will have less headaches at night.

According to CNBC and Synergy Research Group as of this writing, Amazon AWS leads 33% of global cloud market share. That may sound like a small number, but it’s by far the majority of customers since Amazon’s AWS cloud revenue is more than the next five providers combined. Two of those 5 providers are Microsoft and Google.

And for those of you new to the cloud, you do have the ability to run Microsoft products, including Microsoft SQL Server, in the AWS cloud.

We do backups or restore or query tables to create the views, create some triggers to send the attachment report files, and to report on data.

It makes managing the database easy. Backups are very quick.

Sometimes we experience issues with its stability.

I have experience with SQL Server for 3-4 years. 

Sometimes we experience issues with its stability.

Five thousand users are using the solution. 

The initial setup is easy. Fifteen twenty minutes required for deployment. 

Overall, I would rate the solution an eight out of ten. 

SQL Server is our primary database for identity access management.

What I find most useful in SQL Server is that it's easier to manage and to query. Its databases are well-designed. It's easy to do any changes, and it's easy to query the database through reports and whatever information you need.

There is always room for improvements. In SQL Server, the databases should be able to deal with more data in a faster way. Sometimes, when you have a lot of information running on the SQL databases, the system hangs. Though there are always improvements being done to SQL Server, there's still a lack of speed in being able to process so much information, so the performance of this solution still needs to be improved.

Another area for improvement in SQL Server is its front end, in terms of running the queries, e.g. it would be better if it could give suggestions. For example: When you write something, this solution could have a feature similar to a dictionary's intelligence that will tell you what to write such as the one you have in Word, or in PowerPoint, for example, you'll have the design suggestions for it. An improvement I'd like to see in SQL Server is for it to suggest what you put next when you are writing SQL codes or queries.

We've been dealing with SQL Server for four years now.

SQL Server is a very stable product.

SQL Server is a product you can scale. You can add and remove modules as needed.

SQL Server is expensive if you use the advanced SQL version. If you use the standard version, it's not expensive, because it's included in Windows, in Microsoft. It's very expensive if you use the advanced version. We're using both. For IBM, we're using the advanced version, but then we use the basic SQL Server for the other platforms.

You just pay for the SQL Server license. There's no additional cost as everything's already included.

We currently don't have any issues with SQL Server. There's nothing that we couldn't solve internally, so I haven't had the chance to contact their technical support team.

I'm giving SQL Server an eight out of ten rating.

I can recommend this solution for medium and large enterprises. For small enterprises, it depends: if they use the standard, free one on Windows, yes. If they don't, I wouldn't recommend the investment.

The solution is very fast. 

The data is reliable and I can normalize the database and normalize the data so that I can collect whatever information I need. If I collect the data correctly, then I can share whatever report I want.

Normally, when the data is in the database, it will always be a long-term information holder, instead of putting it in Excel or something like a spreadsheet or something like that. 

For me, the initial setup is very easy as I have years of experience with the product.

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. 

I've been using the solution for 30 years at this point. 

I don't have so much experience with scaling. It's my understanding that that task is a specialist job.

I have dealt with technical support in the past. I'm happy with them. They have been helpful.

I'm not only working with SQL Server. When I need the database, I will always do it in SQL Server or Maria Database or something like that.

For me, the initial implementation is easy, however, I know a lot of people can't set it up and believe everything is hard. It's difficult if you didn't know how to do it. You have to know, in the beginning, how to define what hardware you need and how many disks, for example. You need to understand if it should be a cluster disk or not. Long ago, it used to be hard disk access only. Things have changed. 

The solution does come at a cost.

I'm a customer and an end-user.

This solution is one of my favorites and I would rate it at a nine out of ten. I'm very pleased with its capabilities. 

Microsoft has a freeware option that might be called something like SQL Server Express. I'd advise new users to try to put that one up. It's easy to implement. If you need more data, then buy the correct server. The SQL Server is expensive, however, when you see how nice data is installed and how easy you can get access to it, it may be worth it. If new users need help, they can always go to YouTube to find answers for the freeware.

SQL Server has a steep learning curve, however, it's worth it to learn about it and understand it. 

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.