Microsoft SQL Reviews & Product Details

Microsoft SQL Overview

What is Microsoft SQL?

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.

Microsoft SQL Details
Languages Supported
German, English, French, Italian, Japanese, Korean, Portuguese, Russian, Spanish, Chinese (Simplified)
Product Description

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 Details
Seller
Microsoft
Ownership
NASDAQ:MSFT
Company Website
Phone
+1 (877) 276-2464
Year Founded
1975
HQ Location
Redmond, WA
Total Revenue (USD mm)
$125,843
Twitter
@Microsoft
9,300,495 Twitter followers
LinkedIn® Page
www.linkedin.com
193,766 employees on LinkedIn®
Description

Microsoft Corporation develops, licenses, and supports software products and services; and designs and sells hardware worldwide. Flagship products include Windows, Office, Azure, SQL Server, Exchange, SharePoint, Dynamics ERP and CRM, as well as Xbox; Skype; and Windows Phone.


Overview Provided by:
Show More

Microsoft SQL Screenshots

Answer a few questions to help the Microsoft SQL community
Have you used Microsoft SQL before?
Yes

Microsoft SQL Reviews

Write a Review
Filter reviews

LinkedIn®
Connections
Popular Mentions
Showing 1,986 MS SQL reviews
Popular Mentions
Showing 1,986 reviews
Filter Reviews
Filter Reviews
Sort by
Ratings
Company Size
User Role
For Category
All Industries
Review Type
Region
Already have Microsoft SQL?
Write a Review
Project Leader
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

Powerful Database application, user friendly.

IntelliSense feature, easy database data and logs configuration.

Query and database optimization features. Review collected by and hosted on G2.com.

What do you dislike?

Platform dependency and expensive license.

Database replication, mirroring and table portioning features still need improvement and to be made easier for users. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Excellent tool for data management, simple and powerful.

Easy to understand and operate.

Very helpful is application development. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

I am using Microsoft SQL from last 16 years from SQL 2000 to SQL 2017. Most of software we developed in our company has MS SQL Server on backend (Desktop Applications, Web Applications and Mobile Applications). It is very powerful tool and easy to use with Visual Studio languages and also easily configurable with multiple reporting tools like Crystal Report, Microsoft Reporting and other advance reporting tools. Over the years MS SQL has increase the data security, improved data optimization (which is always the issue in comparison with Oracle & other databases). Review collected by and hosted on G2.com.

Show More
Show Less
SQL and dotnet Developer
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

As I am using this product from last 6 years I am very much happy with the features that SQL provides some of them are:-

1. SQL is best for managing data in the relational forms so that the data integration and consistency maintain properly.

2. As SQL supports most of the data types like (int, char, varchar, float etc..) which makes developer life easy to integrate with and application and language.

3. SOL also provides the bulk insertion and extraction of data and also supports the different data source like excel , notepad and all..

4. SSIS and SSRA are the best and ever green feature of the SQL. Review collected by and hosted on G2.com.

What do you dislike?

I do not have much complaints on dislike about the product .But just wanted to highlight one observation

Error handling mechanism can be much better so that the developer can get to know exact issue in SQL scripting.

Because most of the time SQL compiler not showing expected error message and no suggestion as well.

This is the only one I would like to highlight in dislike section. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We are providing the database solution to the different application owner so that the application data become more secure and also can maintain and store for required period of time based on the requirement and application needs.

As its stored the data in the tables and relational form it is becoming very helpful and easy to generate reports based on the SQL commands in very less effort.

We can also easily extract the required data in any required format too and can share it with management to take the required decisio. Review collected by and hosted on G2.com.

Show More
Show Less
Small-Business(50 or fewer emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

Microsoft SQL Server is a long and well established database product that provides complete relational db possibilities for integrating into cloud, web, and windows projects. In addition it's connectors have the ability to relate to the full microsoft ecosystem of products which comes in handy setting up power platform apps, workflows, and sharepoint sites. microsoft has taken great pains to continually improve performance, indexing and integration abilities over the years. The product enables us to provide best in class relational database management capabilities to all over our client's websites. Review collected by and hosted on G2.com.

What do you dislike?

it is large scale so if you are looking for something lightweight for smaller websites it is probably not for you. it also takes some learning curve and is helpful to have a dedicated admin in full IT environments. however this can be overcome by the wealth of information available out there due to it's longevity as a product. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Find an admin familiar with setup and best practices Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

microsoft sql server serves as the backbone behind our 300+ client websites. Each site can have it's dedicated single tenant database while administration is conducted equally over them. Developers and designers can be give permissions as needed and security can be setup as robustly as needed to protect client data. We are also able to develop automated stored procedures and run via server agents that pull data and send to executive leadership as needed. Review collected by and hosted on G2.com.

Show More
Show Less
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

It is a powerful relational database that projects a sophisticated scope in the analytical areas of each document or in the information sources of a particular department, highlighting that I love its flexibility to an environment that is easy to use and understand once that its servers are installed on a platform, logically being one of my favorite aspects in relation to the system, mentioning that it maintains extraordinary access for users and its proper administration in general areas, since they are very simple in their entirety. Review collected by and hosted on G2.com.

What do you dislike?

One of the most outstanding nonconformists of this system is related to payments for its support, which is somewhat incoherent, in which most similar systems proceed to establish these free services, highlighting that it is a very nefarious quality, since on occasions it tends to fail frequently, and requires the use of its support, being a very high economic commission, when it comes to constant use, without excluding that you must acquire more capabilities for generating reports. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

If you are a developer and do constant work to retrieve or update data in a consecutive and guaranteed way, Microsoft SQL is the best option you can have in mind, highlighting that it is quite simple to use and acquires a learning curve for a use correct in its entirety, which is not so steep, and presents flexibility, guaranteeing extraordinary adjustments in the performance of your organization and providing best practices throughout the life cycle of these operations based on information essential for the success of your work processes to a business environment. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Our company uses SQL to execute jobs in an extremely fast way, including the safe storage of data and the prudent and constant generalization of reports, for an intelligent conclusion in each strategy in which it is planned to establish, precisely it is used by our team specialized in quality control, in order to verify with certainty the expected result of the operations we wish to carry out, especially when it comes to informative environments for well-structured reports, for the different work areas. Review collected by and hosted on G2.com.

Show More
Show Less
Software Developer
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

Helpful in performing database operations. The scripts for CRUD operations are built in which saves some time

It is faster compared to other database tools I’ve used Review collected by and hosted on G2.com.

What do you dislike?

It is quite slow for huge data operations which includes multiple joins and multiple conditional statements. Not much disadvantages as such Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

I’m using MS SQL to connect to the database which is hosted on azure and perform various day to day Database operations. Myself being a Backend (.NET Core Developer), database is a mandatory software for me for the basic CRUD operations Review collected by and hosted on G2.com.

Show More
Show Less
Student
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

The ease of management of databases is really good. And the updates application is good Review collected by and hosted on G2.com.

What do you dislike?

Sometimes performance issues occur and restart is required Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Ease of access is awesome. The management of database is easy Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Management of database

Schedulings jobs

Storing sensitive data Review collected by and hosted on G2.com.

Show More
Show Less
Systems Analyst
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

I like that the suggestions offered when I begin to type a column, table, or database name within a query, etc.. Review collected by and hosted on G2.com.

What do you dislike?

I don't have experience with other SQL programs, so I have nothing to compare to. However, there is nothing I currently dislike. I have been using this for work for over 2 years now. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

I solve 20-100 data-related issues at work every day. We recently implemented a new program, and I am able to help users with scripted work around and other things while waiting for a code fix in a build. Review collected by and hosted on G2.com.

Show More
Show Less
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

It contains various functionalities that are quite necessary when carrying out work development on this platform, we can mainly highlight that the user interface is very easy to use, which facilitates the configuration of our environment in large quantities, I like this sector of the software already which is quite colorful and innovative, offering the necessary information for a very convincing development, mentioning that it is quite striking, in other aspects, it should be noted that it does not need additional storage when changing our workstations, allowing to manage data in an extraordinary way. Review collected by and hosted on G2.com.

What do you dislike?

This software simplifies security configurations towards other platforms, which can be annoying since it can sometimes restrict access to these other integrated systems for greater ease, which is a large-scale flaw, causing a low work performance when implemented in the digital servers of a company, in other relevant aspects the price of the business version could be a little lower in the same way its licenses, which should be more understandable. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

For the manipulation and cleaning of basic data, but necessary utility for the company, we can determine that Microsoft SQL is one of the best tools available in the digital market, making it ideal for various scenarios and solutions, since it is a database of general purpose relational documents, that is, all kinds of information you need, with access to navigation to these notes added to any platform to get the best possible out of it, able to easily and efficiently meet the needs of your website or application , being a high grade software to be recommended. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

In our main department of safeguarding essential information, very necessary for our company, we use Microsoft SQL to store data, add it and manipulate it for our benefit, to obtain a greater benefit in a formal way, since we use reporting service tools to create , manage and implement analysis highly demanded by our clients, because to make this possible, this software offers us the necessary options, including its great main functionalities, which are of equal essential utility, this is the administration process. Review collected by and hosted on G2.com.

Show More
Show Less
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Microsoft SQL has provided our organisation with an intelligent and efficient data integration tool that works across platforms and has a strong 3rd party applications support. Review collected by and hosted on G2.com.

What do you dislike?

Microsoft SQL is highly technical and has a steep learning curve for new users and it is also harder to manipilate cloud data than on-premises data. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Microsoft SQL is excellent for processing, transforming and reporting large tracks of data. And is an asset to any organization who choose it. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Microsoft SQL has amazing data scalability which makes it easy to manipulate large volumes of information efficiently. Review collected by and hosted on G2.com.

Show More
Show Less
Project Manager
Small-Business(50 or fewer emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

It is the database software (Database Management System or DBMS) that actually does all the work of storing, retrieving, managing, and manipulating data in a database. Review collected by and hosted on G2.com.

What do you dislike?

Transactional Replication

Bidirectional Replication

Merge Replication. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Performance, Trusted, Integration, Simplicity Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Fast installation

Automatic installation/deploy

Cloud-ready

Cheap

Testing against different servers/version

Isolation

Resetting

Transparent configuration

Cross-platform Review collected by and hosted on G2.com.

Show More
Show Less
Quality Engineer
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Microsoft SQL is quite an easy system to set up and start going and the tool has several different commands which enables the user on providing the best results possible.

Its the perfect RDBMS platform with high ability on solving various data issues, creating of new tables, procedures storing and to upgrade this system is also very easy.

Microsoft SQL has made it simple for many different organizations to be able to maintain and creating of customers data. Review collected by and hosted on G2.com.

What do you dislike?

Microsoft SQL is the best and its interface is not so that complicated to scare the new users. With just little training your ready to go. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Great data management and record management system with unique functionalities and quality services production. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Solving various data problems, easy management of different clients data and keeping of various records. Review collected by and hosted on G2.com.

Show More
Show Less
Business Process Lead
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Costs are competitively cheaper than other vendors. Easy to install and great customer support. Review collected by and hosted on G2.com.

What do you dislike?

Nothing much on the features side. Looks promising. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Business that needs to build small to medium sized databases can leverage SQL Server. Although it can handle any amount of data, it is not advisable to bring in more than some terabytes. Querying time depends on how efficiently the DB is optimized. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Ingest data into SQL server from different sources and build data models to support BI applications. Review collected by and hosted on G2.com.

Show More
Show Less
Software Engineer
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

very decent user interface, easy restore database, fast enough, gives proper error message, can be embed with visual studio Review collected by and hosted on G2.com.

What do you dislike?

Sql server version are not compatible with other version, relatively expensive, doesnt runs on linux works only on windows Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

using with web applications, used for ETL operations, database management system . Review collected by and hosted on G2.com.

Show More
Show Less
UH
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

I feel this is the easiest querying tool to learn if you are just starting out and has the best layouts and options with tables and views and switching over to databases that you can link to and pull data out of. Review collected by and hosted on G2.com.

What do you dislike?

Nothing, it is easy to download and store on your computer, there is nothing to dislike about how it functions. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We are easily able to query large mass amounts of data as we work in healthcare. We are able to quickly pull PHI from the system and in large differing groupings/filters as our contracting needs see fit. Review collected by and hosted on G2.com.

Show More
Show Less
Analista de sistemas de información
Small-Business(50 or fewer emp.)
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

It`s usefull for little companies and great to little companies Review collected by and hosted on G2.com.

What do you dislike?

Create users and roles might be complicated Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

I have created databases to little companies Review collected by and hosted on G2.com.

Show More
Show Less
Data Warehouse Analyst/Programmer
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Superb platform that is now tried and tested. Brilliant licencing costs that are far cheaper than alternatives. Review collected by and hosted on G2.com.

What do you dislike?

No new features of interest added to core product for many years yet we continue to pay for upgrades and maintenance. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Great platform with a solid reputation. Fantastic discounts for education sector meaning it is incredibly affordable also. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Storage or data across all of our corporate information systems. Review collected by and hosted on G2.com.

Show More
Show Less
UH
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Let me start by saying, I am NOT a SQL developer, however I'm a business systems/data analyst that uses SQL on a frequent basis so take this with a grain of salt; I have used Heidi SQL, a little bit of Toad and primarily this. So far, I really like MS SQL mostly because it's just easy. Anytime I have an issue with a query, I can google and find out and those queries always work. Review collected by and hosted on G2.com.

What do you dislike?

One thing I do not like is that when I used Heidi SQL which is mysql I believe, it had group concatenation, so when I wanted to use HAVING and GROUP BY it was a lot simpler.In MS SQL you have to do a subquery or a more complex option. Again, as an analyst, not a developer, I need this to be as easy as possible. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Pulling data for the business, querying results to get data ingested into our core system, using SQL to pull reports instead of the clunky core system. Review collected by and hosted on G2.com.

Show More
Show Less
AH
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

Microsoft SQL is easy to install and manage. Creating and Managing databases is straight forward and can be manages by SQL scripts. Even person without database experience can use Microsoft SQL. The performance is faster and I would definitely recommend it. Review collected by and hosted on G2.com.

What do you dislike?

None. I like everything about it and how it works Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Microsoft is a great option to look for those who are planning to work with geodatabases Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

I am using it for creating many geo-spatial databases. These databases server as a back end supporting many mapping applications. Review collected by and hosted on G2.com.

Show More
Show Less
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

it has management, tuning, modelling and debugging functions, it has all the features and functions I need. It has very good documents I can look up. Review collected by and hosted on G2.com.

What do you dislike?

It is too powerful for junior database guys to use advanced tools. and it has long learning curve to master the tuning skill. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

It works well with microsoft ecosystems. if your company will use other MS products, such as SSIS, SSRS, SSMS will work with them very well. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

I use it on daily base to create complicated sql query and custom reports. it is very handy when I am familiar with many functions, store procedures. Review collected by and hosted on G2.com.

Show More
Show Less