Microsoft SQL Server

"Overall I had an amazing experience. It is very powerful and useful for scalable enterprises."
"I have had a good experience with SQL Server as it has proven itself to be reliable, secure and efficient."
"Microsoft SQL Server is a great data management, analyzing and reporting tool which helps in day to day running of a business. The very powerful features it posses makes data analysis easy."
"One of the most popular database plaform gives you a perfect visibility of the tables. Easy client connection allows you to manage your database from any place."

Cons

"Pricing is quite confusing and costly, and performance can be sluggish at times when dealing with low RAM."
"The lack of reporting services is a terrible shortage. It could have an alternative in Apache, or even allow integration with Windows servers for this demand."
"The least thing i found about the software is error statement , some times an extra space can cause a huge problem , and throwing the error which is not likely understandable."
"Licensing is confusing, whenever you have license by call or by CPU core, it's a bit hard to understand how they apply the prices."

Pros

"Overall I had an amazing experience. It is very powerful and useful for scalable enterprises."
"I have had a good experience with SQL Server as it has proven itself to be reliable, secure and efficient."
"Microsoft SQL Server is a great data management, analyzing and reporting tool which helps in day to day running of a business. The very powerful features it posses makes data analysis easy."
"One of the most popular database plaform gives you a perfect visibility of the tables. Easy client connection allows you to manage your database from any place."

Cons

"Pricing is quite confusing and costly, and performance can be sluggish at times when dealing with low RAM."
"The lack of reporting services is a terrible shortage. It could have an alternative in Apache, or even allow integration with Windows servers for this demand."
"The least thing i found about the software is error statement , some times an extra space can cause a huge problem , and throwing the error which is not likely understandable."
"Licensing is confusing, whenever you have license by call or by CPU core, it's a bit hard to understand how they apply the prices."

Write a Review

Read All 1770 Reviews

Most Recent Video User Review for Microsoft SQL Server

SEE ALL VIDEO REVIEWS

Altaf A.: My name is Altaf. I'm an Integration Architect. I give Microsoft SQL Server four out of five stars. For more reviews, click below. We evaluated Oracle, Microsoft SQL Server, and Amazon RDS. And Amazon RDS being on the cloud, we cannot put it in our internal VPN, so we did not consider RDS. And then, for Oracle, it does not come with some of the tools that Microsoft Server provides. So, that was the reasoning behind choosing Microsoft SQL Server. Microsoft SQL Server comes with many other useful tools to speed up database design development, troubleshooting, and maintenance. These tools include Microsoft SQL Server management studio, Azure data hub, SQL Server data tools, and SQL Server profiler. So, if you are a company that have a data warehouse running on Microsoft platform, then you can easily integrate with the analyzer services and Power BI without needing to buy third-party softwares. So, that was the reasoning behind us going with Microsoft SQL Server. Microsoft SQL Server comes with a free developer version. So, no licensing required for getting the Microsoft SQL Server management studio installed. Installation is pretty straight and pretty straightforward and quick. And then, there are no coding skills required. So, if you are the developer is starting with Microsoft SQL Server, selecting, inserting, deleting, and updating [inaudible 00:01:47] into the table are straightforward. The UI is pretty user-friendly, so no coding is required to get started with Microsoft SQL Server. If you're thinking about getting onboard with Microsoft SQL Server, it provides some of the powerful tools to manage your databases. But it comes with some of the disadvantages as well, where the query optimization and performance training can be difficult for data specialists who don't have deep or specialized knowledge. And then, partitioning that comes with Microsoft SQL Server is not as powerful as Oracle, like foreign key partitioning, or list partitions, hash partitioning, or sub partitions.

Top choose for relational database

4.0

Posted on September 28, 2021POSTED BY:

Altaf A.

Integration Consultant•Government Administration

Most Helpful Reviews for Microsoft SQL Server

Shaunak P.

Data Platform Engineer

Information Technology and Services, 10,001+ employees

Used the software for: 2+ years

Overall Rating

Ease of Use

Customer Service

Features

Value for Money

Likelihood to Recommend

Reviewer Source

Source: Capterra

November 13, 2022

"Best, well-known and wide-spread product for SQL."

Overall: There are lots of benefits to using MS SQL Server.1) Secure data storage.2) SSMS for data exploration on desktop.3) Awesome public documentation by MS.

Pros: Little can I write about this vast product, but to brief each which I find insightful are below:1) Fine-grained role and attribute-based access control. 2) Highly secure and robust ways for authorization and authentication.3) Sync with Active Directory authentication.4) Awesome connectors with data warehousing tools.5) Best data at rest and in transit encryption.6) Dedicated support and advisory.

Cons: Almost nothing to be pitched here, it is continually being developed and refined for adding better features.My advice would be to learn T-SQL for best usage.

Reasons for Choosing Microsoft SQL Server: MS SQL Server is enterprise-level software, and cannot be overshadowed.

Reviewer Source

Source: Capterra

November 13, 2022

juan jose v.

ANALYST PROGRAMMER "A"

Aviation & Aerospace, 501-1000 employees

Used the software for: 2+ years

Overall Rating

Ease of Use

Customer Service

Features

Value for Money

Likelihood to Recommend

Reviewer Source

Source: Capterra

November 17, 2022

"Microsoft SQL Server for Business"

Overall: I have 5 years working with Microsoft SQL Server, I have adapted well, I like the functionality it has, the practical way in which you can perform queries, scheduled tasks for my daily and weekly backups are excellent, accompanied by the crystal report, works great, I tried to try other database managers like ORACLE, but I think it is better Microsoft SQL server, to this day, I prefer to work with it.

Pros: Personally, I like that the application is easy to use, obviously if you already have time using it and you are familiar with the concepts and terms used, the tools to create backups or schedule tasks to run on specific dates and times is quite good, the price is affordable not too expensive unlike oracle.

Cons: to install it is a bit time consuming, since you have to configure it on the fly, it does not bring any preconfigured default settings, this takes a little time to the user, to migrate to other operating systems other than windows, you have to make other extra configurations.

Alternatives Considered: MySQL

Reasons for Choosing Microsoft SQL Server: It is the manager used by the company for which I work, since it adapts better to their needs, for this reason we have always worked with Microsoft SQL Server.

Reviewer Source

Source: Capterra

November 17, 2022

Wilmer Josué G.

Computer Science Engineering

Libraries, 1-10 employees

Used the software for: 2+ years

Overall Rating

Ease of Use

Features

Likelihood to Recommend

Reviewer Source

Source: Capterra

June 18, 2021

"SQL Server as a primary tool for developers"

Overall: I have been using SQL server since the first periods of college in my programming classes, as a storage of information I have been taught its practical use both personally and for program development in companies. I find it a very useful and versatile tool, it is used with ease as long as the developer has studied enough information about sql server because a novice and a pro can delete by mistake a whole database, you have to be careful because there are no request messages to deny the deletion. To use the tool I recommend to practice a lot and to comment the coding.

Pros: What I liked about the tool is the practical use it has, it can be used by novices in an easy way, as long as someone teaches them the basics, it is very useful on a daily basis due to the management of databases and their respective migration to other platforms. The management of the information becomes useful, it is versatile to changes before, during and after the development of the project.

Cons: What I liked least is the interface and the work area because when moving a part of that interface it is not very intuitive to place it to the default place, I have had problems with that and also that for processes of adding data I find the work space very small.

Reviewer Source

Source: Capterra

June 18, 2021

Guillermo B.

Owner

Marketing and Advertising, 1-10 employees

Used the software for: 1-2 years

Overall Rating

Ease of Use

Customer Service

Features

Value for Money

Likelihood to Recommend

Reviewer Source

Source: Capterra

November 9, 2022

"A good choice as a database manager, but it can be improved."

Overall: It is good software, as I mentioned before. It syncs well with other Microsoft tools. In almost 2 years of use, I feel comfortable when working with this software. I hope that the improvements I mention in the negative points will be included. Otherwise excellent.

Pros: I like that it allows me to use my Windows login credentials as user authentication to connect to the server. Plus it integrates easily with other Microsoft programs such as Visual Studio 2022, Business Intelligence tools, etc. I am a Software Engineering student, and I have been testing many database managers. Of all the ones I have used Microsoft SQL Server is the easiest to install and very intuitive regarding the use of its tools. In addition to being a student, I give small tutorials on how to use the software, such as tips for new users, and database backup.

Cons: I don't have much to criticize in this space. For me, the Software is very complete. But if I would like you to implement a dark theme throughout the interface, it would be very helpful to rest your eyes and avoid fatigue after hours of work.

Switched From: MySQL

Reasons for Switching to Microsoft SQL Server: I changed the product because I was asked to do so at my place of work and the truth is that I am satisfied with the performance.

Reviewer Source

Source: Capterra

November 9, 2022

Olivier S.

Software Architect

Information Technology and Services, 51-200 employees

Used the software for: 2+ years

Overall Rating

Ease of Use

Customer Service

Features

Value for Money

Likelihood to Recommend

Reviewer Source

Source: Capterra

November 9, 2022

"The default database for Windows development"

Overall: This is the base storage for many of our applications, allowing to handle millions of rows without a single failure.

Pros: This is the database that I grew up with, and it's never disappointed me over all these years.It keeps compatibility between versions and has a nice documentation about migrating.

Cons: There has been situations where we hit a roadblock and the documentation for it was a bit lacking.

Alternatives Considered: SQLite, PostgreSQL, Oracle Database and MySQL

Reasons for Choosing Microsoft SQL Server: This is the one our client are used to, and it's tightly integrated with Active Directory

Reviewer Source

Source: Capterra

November 9, 2022

Read All 1770 Reviews

Compare Alternatives

Microsoft SQL S...

Starting from:

$13748.00/One-Time

Pricing Model:

Flat Rate

Starting from:

Not provided by vendor

Starting from:

$25.00/Per-Month

Pricing Model:

Per User

Overall Rating:

4.6 (1770)

Ease of Use
4.3
Customer Service
4.3
Features
4.6
Value for Money
4.3

Overall Rating:

4.8 (33)

Ease of Use
4.2
Customer Service
4.8
Features
4.8
Value for Money
4.3

Overall Rating:

4.3 (135)

Ease of Use
4.0
Customer Service
4.0
Features
4.2
Value for Money
4.3

4/11

10/11

11/11

Popular Comparisons

Microsoft SQL Server Pricing

Starting From:

$13748.00 one-time

Pricing Model: Flat Rate

Yes, has free trial
Yes, has free version

Pricing Details (Provided by Vendor):

SQL Server offers a 180-day free trial for new users, after which the software is available across various pricing tiers Enterprise - $13748 Standard (per core) - $3586 Standard (server) - $899 Standard (CAL) - $209 Developer - Available to users for free Express - Available to users for free Additional cost for subscriptions and add-ons include - SQL Server Enterprise - $5434/year SQL Server Standard - $1418/year Big data node cores - $400/year

Pricing Resources:

Be an Informed Buyer: Understanding the True Cost of Business Software

Database Software Pricing Guide