Microsoft SQL

(703)
4.3 out of 5 stars

Microsoft SQL enables the user to build mission-critical applications using high-performance, in-memory security technology across OLTP, data warehousing, business intelligence and analytics.

Work for Microsoft SQL?

Learning about MS SQL?

We can help you find the solution that fits you best.

Find the Right Product

Microsoft SQL Reviews

Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • User Industry
Ratings
Company Size
User Role
User Industry
Showing 711 MS SQL reviews
LinkedIn Connections
MS SQL review by <span>Mayank N.</span>
Mayank N.
Validated Review
Verified Current User
Review Source

Excellent RDBMS

Reviewed On
Validated Review
Verified Current User
What do you like best?

Integration of other monitoring software like fog light is very easy without time consumption. Great capability to handle all complex queries requirements. Suite of advance sql functions. Provide all excellent functionalities like Reporting Services, Integration Services, Job Scheduler, Resource manager, Query analyser and Profiler etc. Each of these modules are build perfectly and handles the tasks effectively. Configurable at each level. User permission is at every objects and other higher levels. Changes can be done for specific privileges at user level. Window service based Control to the server for starting and stopping the service.

What do you dislike?

Scalability is great but not the best like other new Database there in the market. CPU memory consumption is always more than normal on production specifically by the sql server. Scope of improvement in profiler for most frequently used options.

Recommendations to others considering the product

Sql server has always fulfilled the new requirements and has great features to utilize. This will always exceed your expectation for sure.

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

We are using it as backed of application. This is perfect for all kind of client requirements and always meets the expectation.

0 of 0 found this helpful.
Helpful?
Sign in to G2 Crowd to see what your connections have to say about Microsoft SQL
Headshots
MS SQL review by <span>Prashansa K.</span>
Prashansa K.
Validated Review
Verified Current User
Review Source

SQL Server developer

Reviewed On
Validated Review
Verified Current User
What do you like best?

Performance while retrieving the data.

Compatible with several on the shelf products.

Storing the data is easier.

Support for the Kerberos and other security products.

It is useful to manage and obtain data from the network of networks.

It allows us to forget about the files that make up the database.

Asynchronous filling of objects, with the possibility of filtering objects according to their metadata.

Access to the SQL Server Agent in the replication servers for administration.

A new interface for viewing XML results.

What do you dislike?

uses a lot of RAM memory for installations and software.

Difficult to setup permissions and roles.

Support for writing and modifying queries or scripts without the need to connect to a server.

Archieving data is not easier.

Recommendations to others considering the product

If you care about the fast retrieval of the data then MS Sql Server is best product in the market.

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

Using for the backend database support.

Archieval of the data.

0 of 0 found this helpful.
Helpful?

What Relational Databases solution do you use?

Thanks for letting us know!
MS SQL review by <span>Brandon M.</span>
Brandon M.
Validated Review
Verified Current User
Review Source

Microsoft SQL - Excellent DB Platform

Reviewed On
Validated Review
Verified Current User
What do you like best?

I think one of the best things about Microsoft SQL (currently using 2012) is the Developer Network and helpful resources that are available. Thanks to the developer network, I’ve been able to learn much more about querying and build more useful and advanced queries over time. Things such as Transact-SQL (T-SQL) come in handy a lot of the time due to the vast amount of new queries you can build after learning T-SQL.

What do you dislike?

I dislike that sometimes the developer network resources can be much more complex than I anticipated. Sometimes you just need a simple answer and not a lecture on every argument that can be used. I would also say that understanding certain failures or issues with SQL could by better documented by Microsoft instead of other community forums i.e. Stack Overflow. It would be nice if Microsoft had an error mapping for each SQL error and what the resolution for it might be. As far as I know, the easiest way to troubleshoot a query on runtime is to paste a portion of the error in to a search engine and then start going through the form pages. Usually within the first several web links, someone will have found a resolution that works.

Recommendations to others considering the product

Microsoft SQL is a great solution and the updates only continue to make it better. Be sure to stay on top of SP updates but make sure the next version (2008, 2012, 2016, etc..) will have everything that you need.

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

Financial Inaccuracies, ETL errors (SSIS), IIS Application issues.

0 of 0 found this helpful.
Helpful?
MS SQL review by <span>Cesar G.</span>
Cesar G.
Validated Reviewer
Verified Current User
Review Source

Database manager easy to use

Updated On
Validated Reviewer
Verified Current User
What do you like best?

Compatibility with most SQL Server administrative tasks, a single integrated environment for the administration of the SQL Server database engine and creation and a common programming dialog that allows you to perform actions in the administration dialog boxes in another moment.

If we work in a social network it allows us to add other SQL Server servers. For example, two people who work with SQL Server, one of them can connect to the server of their other partner and thus you can see the databases of the other partner with SQL Server.

SQL allows you to manage permissions to everything. It also allows someone to connect your SQLO to ours but nevertheless we can tell you that you can not see this database but another yes.

It is useful to manage and obtain data from the network of networks.

It allows us to forget about the files that make up the database.

Asynchronous filling of objects, with the possibility of filtering objects according to their metadata.

Access to the SQL Server Agent in the replication servers for administration.

A new interface for viewing XML results.

Support for writing and modifying queries or scripts without the need to connect to a server.

A large set of templates and the ability to create custom templates.

What do you dislike?

It uses a lot of RAM memory for installations and software

Recommendations to others considering the product

improve RAM consumption of software utilization

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

Soport online and soport telephone

0 of 0 found this helpful.
Helpful?
MS SQL review by <span>Guillermo V.</span>
Guillermo V.
Validated Reviewer
Verified Current User
Review Source

SQL Server with SAP Business One

Updated On
Validated Reviewer
Verified Current User
What do you like best?

It is very easy to perform queries with Microsoft SQL Server because of the simplicity of a high level programming language. The trace functionality is really good and provides a really excellent audit tool on the fly. The tools for recurring backup are really easy to use. If you get stuck, there is a lot of information you can find online and in the Microsoft online help.

What do you dislike?

Sometimes the performance when executing some long queries is not what you would expect. Although CPU power is important for this part, but in the company we have really state of the art servers in the NAP of the americas, so it looks like a software issue rather than a hardaware issue.

Recommendations to others considering the product

I would recommend Microsoft SQL Server for anyone looking for a relational database management system with a really easy installation, setup and maintenance and a really easy programming language that let you perform complex queries in matter of minutes. It is compatible with Windows based servers, i would not recommend it with other operating systems.

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

We use SQL Server in the company mainly as the Database of the SAP Business One application across all of Latin America. We manage several instances for our different types of ambiences. We currently use three of them: Production, User Acceptance Testing and Development, and the software is capable of managing all of them without any problem, with multiple BD's in each of them.

0 of 0 found this helpful.
Helpful?
MS SQL review by <span>Derek J.</span>
Derek J.
Validated Review
Verified Current User
Review Source

My Go-To Traditional SQL Solution

Reviewed On
Validated Review
Verified Current User
What do you like best?

Microsoft SQL is supported by countless software solutions; most scripting and programming languages. Standard edition licensing for academic institutions is cheap. The free edition limitations are not too stringent, making it very useful for small projects. SQL Management Studio is my favorite query editor and database management tool, and works even with the free SQL editions.

What do you dislike?

Performance of editions prior to 2016 seems lackluster. Query responsiveness will eventually slow to a crawl until you restart the server process. This can be avoided with proper db design and maintenance, but shows that the product can sometimes require extensive knowledge and experience to fully appreciate. I feel it should be better at self-maintenance and optimization.

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

We use MSSQL on everything from our most business critical applications to small staging databases. It operates as or data warehouse, reporting solution, and all-around go-to affordable database server. It's a wonderful product that can be properly attuned to many needs.

0 of 0 found this helpful.
Helpful?
Kate avatar
Kate from G2 Crowd

Learning about Microsoft SQL?

I can help.
* We monitor all Microsoft SQL reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.