Microsoft SQL Server Reviews & Product Details

SQL Server 2017 brings the power of SQL Server to Windows, Linux and Docker containers for the first time ever, enabling developers to build intelligent applications using their preferred language and environment. Experience industry-leading performance, rest assured with innovative security features, transform your business with AI built-in, and deliver insights wherever your users are with mobile BI.

Seller

Microsoft

Discussions

Microsoft SQL Server Community

Languages Supported

German, English, French, Italian, Japanese, Korean, Portuguese, Russian, Spanish, Chinese (Simplified)

Overview by

Microsoft Team

Value at a Glance

Averages based on real user reviews.

Time to Implement

3 months

Return on Investment

18 months

View More Pricing Information

Top-Rated Alternatives

View All Alternatives

Microsoft SQL Server Integrations

(27)

Integration information sourced from real user reviews.

Microsoft SQL Server Media

SQL Server

G2 reviews are authentic and verified.

Here's how.

Verified User in Information Technology and Services

Small-Business (50 or fewer emp.)

7/31/2018

"IT's SQL.."

5/5

What do you like best about Microsoft SQL Server?

the management studio, it makes life so much easier for moderate intermediate users like me.

I like that it allows you to debug a table for any errors. You can set it up to use TSQL queries as well, either from the GUI or from the command line query. I have also used the backup database/detach/attach functionality and it allows you to go through these procedures with proper instructions. I just had a small background, but the rest of it is clearly indicated in the instructions provided while you do the procedure. Big credit for that. Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server?

There is still some work around that needs to be done, I can mainly say my inexperience with SQL would account for it. Review collected by and hosted on G2.com.

Recommendations to others considering Microsoft SQL Server:

Read up as much as possible from the internet, they have books, manuals.

If you know how to write queries already that's great, other wise use management studio to help you write difficult queries .

If you feel that you need more information there are tons of websites that allow you to write dummy queries that allow you to write it against their dummy databases instead of you having to run it against your and going through the trouble of backing up and restoring databases. Review collected by and hosted on G2.com.

What problems is Microsoft SQL Server solving and how is that benefiting you?

running jobs automatically with job activity monitor, Creating data through multiple tables and managing and encrypting that information. Review collected by and hosted on G2.com.

Stephan U.

COO

Financial Services

Small-Business (50 or fewer emp.)

11/15/2018

"SQL Server with Performance optimizations"

4/5

What do you like best about Microsoft SQL Server?

Performance optimizations of TSQL for complex queries. SSRS for reporting services and automated report generation to email. Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server?

Sometimes the user security combined with the role based security on tables can take a bit of thought. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

2/21/2019

".Net Professional"

5/5

What do you like best about Microsoft SQL Server?

Great software for storing data.

Rich function library,

Easy to learn & use ,

Evolving new features Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server?

Installation is a bit long and cumbersome,

Perhaps, too many updates & releases Review collected by and hosted on G2.com.

Verified User in Food Production

Enterprise (> 1000 emp.)

1/4/2019

"Microsoft SQL review"

4/5

What do you like best about Microsoft SQL Server?

its an easy to use platform. Its fast and reliable. Making backups is easy and configuring new servers, tables, and databases pretty easy. Managing the systems are also easy. Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server?

The pricing could be better. Nowdays, with all the open source options, better pricing could be something that microsoft could improve upon. Review collected by and hosted on G2.com.

Verified User in Food & Beverages

Enterprise (> 1000 emp.)

12/27/2018

"Awesome compatibility with MS Products"

3.5/5

What do you like best about Microsoft SQL Server?

Microsoft SQL server easy connectivity with most of the third party tools e.g SAP DATA Services etc. Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server?

Microsoft SQL server is having performance with large datasets Review collected by and hosted on G2.com.

Jessica G.

Helpdesk Technician

Information Technology and Services

Enterprise (> 1000 emp.)

12/4/2018

"Meh"

2.5/5

What do you like best about Microsoft SQL Server?

It's very well balanced and not too use unfriendly Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server?

Nothing bad just middle of the road. I would like more features that help define certain queries so I can make a better decision which will be more concise in getting the job done and not conflicting with other queries Review collected by and hosted on G2.com.

Diego V.

Senior Software Developer & Team Lead

Enterprise (> 1000 emp.)

2/27/2018

"A robust transactional database, tried and true"

4.5/5

What do you like best about Microsoft SQL Server?

If you are working from scratch, it's relatively easy to set up a new database server and connectivity between clients. Everything is pretty much straightforward, given that you have some database knowledge. The DBMS allows you to easily create several things entirely in design (tables, views, etc) - which is a big plus when you don't know the entire syntax. Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server?

Some of the setups of older versions (2008 - 2012) are rather clunky and not very well made - I have had several instances of my installer being corrupt and having to redownload. The database administrator is, at some times, slow to load. Review collected by and hosted on G2.com.

Recommendations to others considering Microsoft SQL Server:

Consider all available replìcation scenarios, as newer versions contain even better features (SQL Always On, comes to mind) where log shipping or others may not be necessary. Review collected by and hosted on G2.com.

What problems is Microsoft SQL Server solving and how is that benefiting you?

All the transactional data for our customer is handled in Microsoft SQL. The customer requires a high availability and quick response system; where SQL helps in. Review collected by and hosted on G2.com.

Verified User in Information Services

Mid-Market (51-1000 emp.)

3/24/2019

Business partner of the seller or seller's competitor, not included in G2 scores.

"To Manage large no. of data"

4.5/5

What do you like best about Microsoft SQL Server?

Yes it is very usefull to manage large no. website data in database and other details of website as well. Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server?

Need to store credentials in encrypted form and reporting of website data. Review collected by and hosted on G2.com.

Verified User in Government Administration

Enterprise (> 1000 emp.)

7/31/2018

"Microsoft SQL"

4.5/5

What do you like best about Microsoft SQL Server?

Microsoft is the industry standard when it comes to relational database management systems. This product is mature, stable and well known by most experienced DBA’s. Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server?

Cost and understanding licensing are the thing I dislike about it. The enterprise version is very expensive. Microsoft licensing had become very difficult to understand, especially with using VM’s. There are 2 models: Server + CAL’s and Per Core. Then if you want to be able to move your VM from 1 physical host to another you need to purchase Software Assurance on top of that. Gets very confusing. Review collected by and hosted on G2.com.

Recommendations to others considering Microsoft SQL Server:

Suggest you consider and compare MS SQL to any existing database engine to see if it has any additional features that might be an improvement. Review collected by and hosted on G2.com.

What problems is Microsoft SQL Server solving and how is that benefiting you?

Management is great. Setting up maintenance plans keeps your database backed up properly and compacted for maximum efficiency. If we have needs outside our in house staff, we have no issue finding DBA's that are able to step right and and assist us. Review collected by and hosted on G2.com.