About Microsoft SQL Server

Microsoft SQL Server Business Intelligence (BI) Edition is a database management and BI software solution designed for companies of all sizes. The system offers relational database management, which allows users to access enterprise data using structured query language. The solution allows users to perform complex analysis on the database. The product also features a BI Semantic model that allows users to extract and analyze data from heterogeneous sources.

Microsoft SQL Server features "in-memory analytics," which allows users to perform queries and analytics while the data is in the RAM, thereby improving the speed of access. The software has scalable and corporate reporting features that help management to make decisions that are more inform...


Read More

Supported Operating System(s):

Windows 7, Windows Vista, Windows XP, Mac OS, Linux, HP-UX, AIX, Solaris, Unix, IBM OS/400, Web browser (OS agnostic), Windows 2000, Windows 8, Windows 10

1,555 Reviews of Microsoft SQL Server

Average User Ratings

Overall

4.59 / 5 stars

Ease-of-use

4.5

Value for money

4.5

Customer support

4.5

Functionality

4.5

Ratings Snapshot

5 stars

(986)

986

4 stars

(541)

541

3 stars

(44)

44

2 stars

(3)

3

1 stars

(1)

1

Likelihood to Recommend

Not likely

Very likely

Showing 1 - 5 of 1555 results

June 2021

User Profile Picture

Hasan from Khushhali Microfinance Bank Limited

Verified Reviewer

Company Size: 501-1,000 employees

Industry: Banking

Time Used: Less than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

4.0

Functionality

5.0

June 2021

SQL Server

Overall experience is just amazing. I have been using it for almost 2 years and it helped my organization a lot during release upgrade and it made database migrations so smooth.

Pros

Microsoft SQL is quite simple to install and configurations are also easy. As it is a relational database management system, it is a perfect tool for data analysts. As it enable users to filter and extract required data in a few seconds. The product comes with a lot of features like Query analyzer, Integration services, Job scheduler and Reporting services as well. Restoration and backup of multiple databases is a great advantage and I found this feature very useful because it helps a lot in restoring databases in case of any disaster. Also, one can easily schedule tasks in job tools section which is also a very helpful feature of this tool.

Cons

Well, it occupies more data storage in order to install database engine as compared to other SQL databases. Also, support is pretty much expensive and requires a lot of maintenance. It consumes too much resources to load and start.

Reasons for Switching to Microsoft SQL Server

As Microsoft SQL Server is not an open source product it means it has more extra features that open source tools do not provide. I had to use some advance features in modern databases for better optimization of queries that is why I preferred to switch to Microsoft SQL Server.

July 2021

Anthony from Six Hat Solutions

Verified Reviewer

Company Size: 2-10 employees

Industry: Computer Software

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

3.0

Value for money

5.0

Customer support

2.0

Functionality

5.0

July 2021

The Only Enterprise Level DBMS I Use

We build enterprise level SAAS, Desktop, Web and Mobile applications and API's. I've been SQL Server for over a decade mainly as a DB Developer but at times as an administrator as well.

Pros

A mature DBMS with no limits. Anything we or our customers wanted has always been possible with SQL Server. First class security, speed, and connection capabilities have enabled us to create world class applications for desktop, mobile, and web. The SQL Server community is huge which is critical for those new or rarely used features. I've been working in SQL Server for over a decade and still haven't touched many of the features available. Having a robust community makes learning any new feature quick and easy!

Cons

It's not a SQL Server thing per se... but Microsoft's support in general is weak at best. I've never really had a good experience using Microsoft support as it is slow and cumbersome and many times the reps don't communicate well. The huge community is what really what makes all Microsoft products manageable as most anything you want to learn or figure out is a quick browser search away.

Reasons for Choosing Microsoft SQL Server

Since I develop on the Microsoft stack it goes hand in hand.

Reasons for Switching to Microsoft SQL Server

MySQL worked for single standalone web apps. But when it came to generating a full scale relational model we needed to step it up to SQL Server.

November 2021

Anonymous

Verified Reviewer

Company Size: 501-1,000 employees

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

3.0

Customer support

4.0

Functionality

4.0

November 2021

Corporate relational databases

Its interface is so complete that any query and data transformation task can be carried out. As well as procedures and functions. It is a tool that combined with other systems such as SSIS can become vital for the BI of a company.

Pros

Being a software with so many years of experience, it has the solidity and stability of a highly efficient and corporate platform.

Cons

It is not a platform that is easy to implement and use for small or medium-sized companies. Its use would be very expensive and exhausting.

Reasons for Choosing Microsoft SQL Server

For its stability and support as it is a highly efficient and corporate platform. For large companies it is the most successful option.

June 2021

Wilmer Josué from One Click

Company Size: 2-10 employees

Industry: Libraries

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

3.0

Functionality

3.0

June 2021

SQL Server as a primary tool for developers

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.

August 2021

User Profile Picture

Mir Fida from Fiverr

Verified Reviewer

Company Size: 2-10 employees

Industry: Information Technology and Services

Time Used: Less than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

4.0

Customer support

4.0

Functionality

4.0

August 2021

Best database management tool for relational databases

I would recommend it to all low-scale and small organizations that are already using MS Office products or subscriptions. Its interface is similar to learn and use like other Microsoft software. Enterprise and large corporates can look into Oracle services if they require specific Oracle-made enterprise functions and features to handle very complex data.

Pros

First and foremost, it has all the features and functionality from the basics to advanced users for relational database management. Can be integrated well with other Microsft software especially Visual Studio code for a smooth development experience. Along with data storage management, professional performance analysis can be performed through GUI server management studio tools like Database Tuning Advisor. Data Analysts will find data extraction and filtration as well as visual & interactive report generation quite beneficial in their routine tasks. Backup and restore from one SQL server to another is fairly simple. Pricing is very reasonable according to the DBMS system and tools that are provided.

Cons

One of the main issues is that licensing price packages are difficult to choose due to confing choices for common users. One other limitation is that a backup made in a newer version of MS SQL server is not compatible with an older version of SQL Server. For large volumes of data records and for complex data it becomes slower to process queries. Taking backup of a very large number of records also takes time. Sometimes difficult to debug syntax errors.

Reasons for Choosing Microsoft SQL Server

We decided to use an MS SQL server as it suits our needs in pricing, features, and performance. Also, it is easier to use for development teams that are already using Microsoft products like MS Office. Students should also use it to learn the basics of SQL through a GUI environment. Oracle database service is more expensive due to the fact it handles complex & large-scale enterprise data. We did not require those enterprise features.