Microsoft SQL

4.3
(1,261)

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.

Work for Microsoft SQL?

Learning about MS SQL?

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

Microsoft SQL Reviews

Chat with a G2 Advisor
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • For Category
  • Industry
Ratings
Company Size
User Role
For Category
Industry
Showing 1,269 MS SQL reviews
LinkedIn Connections
MS SQL review by Rick K.
Rick K.
Validated Reviewer
Verified Current User
Review Source
Sign in to G2 Crowd to see what your connections have to say about Microsoft SQL
MS SQL review by Ravi K.
Ravi K.
Validated Reviewer
Verified Current User
Review Source

"SQL 2016 - Support for HealthCare Apps"

What do you like best?

With thousands of claims we receive every day, SQL handles the claims load, validation and applying business rules like a pro.

Also, with the help of SSRS we deliver a lot of reports to our clients on a daily basis.

What do you dislike?

Not much of dislikes but one thing that my client is worried about is Enterprise edition licensing cost.

Recommendations to others considering the product

If your application wants to use the latest parallelism concept then the Microsoft SQL Server max degree of parallelism configuration option controls the number of processors that are used for the execution of a

query in a parallel plan. We have implemented this on a 10 core machine which boosted to 20 core.

With InMemory online transaction processing and AlwaysOn Availability my client is very happy with the performance issues.

Also, the PowerBI tool gives a great option of showing the real time reporting.

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

WIth SQL fail over server we are pretty sure that the database is never down.

SQL helps querying the data for millions of records

SQL IDE makes every developer job easy

What Relational Databases solution do you use?

Thanks for letting us know!
MS SQL review by arsh d.
arsh d.
Validated Reviewer
Verified Current User
Review Source

"Best database software in enterprise environment for window platforms clients"

What do you like best?

easy to use.

contained inbuilt tools like sql profiler for performance monitoring and debugging.

security updates are easy to apply.

we can check query execution plan, helps in improving production system performance.

easily able to import and export data to excel word or any text document.

we can easily take network backups of database.

Differential backups are very easy and helpful.

we can store very large archive dta, data even older than 10 years old or more.

As interface with each sql server version 2008 , 2012 , 2014 all new ones is similar.User can easily work with new version without difficulty.

Deadlocks queries are best traceable using this software

What do you dislike?

required licensing from Microsoft.

Required good hardware for long-running queries otherwise results into sql server is busy and software lag.

take a lot of CPU resources.

Recommendations to others considering the product

for secure and reliable database environment this is one of the best software currently present in industry.

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

All our production system using sql server for database management.

we are using this for daily deployment and upgrades of releases.

MS SQL review by Nihir S.
Nihir S.
Validated Reviewer
Verified Current User
Review Source

"SQL Server : Excellent Data Storage And Analyzing Tool"

What do you like best?

The ease of integration with any application. The ease of data access and usability. The ease of adding of removing users. Securing different access levels for each user. Ease of training for new employees.

What do you dislike?

Nothing I can think of right now. Overall really good experience.

Recommendations to others considering the product

Overall an excellent tool for data gathering and visualization. Excellent support and large user community.

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

Microsoft SQL Server is an excellent tool for any sort of applications. I have used it extensively for multiple web applications where relationships between the tables is needed. Overall capability of the server is very extensive and deep. The Analysis services feature is so great, it allows us to analyze more than Terabytes of data within seconds. The in-built user management system is great too, very few lines of personal code needs to be written to use that. In early days we used to leverage DTS processes too, which helped us analyze large chunks of data. The ease of use and access is peerless. Most the time we have to transfer data between multiple servers and the concept of Linked servers have helped us to achieve that.

MS SQL review by Scott H.
Scott H.
Validated Reviewer
Verified Current User
Review Source

"Microsoft SQL Database"

What do you like best?

The ability to have the product provide the t-sql for actions when you may want to run a process multiple times and would just rather automate it with a maintenance plan. The ability to integrate with other products is a great plus and being able to provide users with reports that they can understand.

What do you dislike?

Performance monitoring is sometimes vague, and slow. Some details can be confusing when first working with the product. It would also be nice if the SQL Management studio install did not feel like it was buried or hidden away and had a simpler installer for when not working on the actual SQL box.

Recommendations to others considering the product

MS SQL is a great tool and there are a lot of resources on the web that can be used when first getting into it. Since the community behind the application is so larger 9 times out of 10 users of MS SQL can find answer rather quickly or work together to find a solution.

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

SQL is used in the background of applications that I use at work. Just having the ability to use the enterprise version helps with speed and being able to provide a faster response to certain queries.

MS SQL review by Juan C.
Juan C.
Validated Reviewer
Verified Current User
Review Source

"The best and safest complete database engine"

What do you like best?

sql server is my database par excellence, what I like the most is its ide to do everything in design view, the creation of customized views, stored procedures I think it is its strength today we can also have sqlserver is linux distributions, and The confidence that a tool created by Microsoft offers us.

What do you dislike?

rather high price, the ide can consume enough resources.

Recommendations to others considering the product

if your environment is window and you want a full secure fast native database sqlserver is the product you are looking for.

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

The first thing we look for in the company is the security for anyone is a secret stability and how much sqlserver has grown as much as remotely as well as locally and in the cloud, it is a scalable professional data base and the most complete in the market. We need to feel that we were going the right way and sqlserver us god that security.

MS SQL review by Mauricio A.
Mauricio A.
Validated Reviewer
Verified Current User
Review Source

"One of the best solutions for database management system. "

What do you like best?

-His compatibility with enterprise software that needs DB integration, this environment allows us to integrate (locally or cloud) all our solutions on the main server with cluster functionality.

-As a Microsoft product, it’s easier to upgrade on Windows Server versions, even security patch is compatible with OS environment.

-SQL Server Management Studio it’s a great solution to DBA or IT departments, his GUI allow less known users to do tasks like backup, restore, change passwords or change security settings.

-If you want to run some test, there is a free version with some limitations like database size (10GB for SQL Server 2016, SQL Server 2014 & SQL Server 2012).

-As a massive product, it’s easy to implement security solutions compatible with any version of SQL and any version of Windows Server.

What do you dislike?

-As other Microsoft products, SQL Server price it’s huge compared against other similar products. They have two options for licensing (Core or CAL).

-In my company the customer support it’s not the best of all the Microsoft products, sometimes they solve the problem only with a patch and do not help with a temporary solution.

-If you have more than 10 instances on the same server running at the same with a high rate of transactions per second it’s important to work with a Microsoft Partner. There is a high RAM consumption that needs to be customized and adapted.

Recommendations to others considering the product

It’s important to configure all the details available, if you need contact a DBA or train you IT personal with Microsoft certifications.

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

As IT department we use SQL as the main database software for all our products (CRM, Financials, HR, security, etc).

MS SQL review by Charlon B.
Charlon B.
Validated Reviewer
Verified Current User
Review Source

"Endless Opportunities and High Availability"

What do you like best?

The best features of SQL Server is the amount of flexibility one can implement. With such high flexibility, once can assure business that SQL Databases will "Always" remain available without any/very minimal downtime. With the implementation of Always On High Availability groups, log shipping and replication, one can rest assured that data loss will be very minimal even in case of heavy disasters. Being a Microsoft Development House, SQL Server also suits our needs very well providing easy and maintainable data management.

What do you dislike?

Administering SQL Server can be quite difficult at first, especially If you would like to build a top notch platform and not just deploy a single server. Fortunately, there is a lot of documentation available on the web for guidance and advise.

Recommendations to others considering the product

Ensure that at least one dedicated person in your team has a good knowledge of SQL Server administration as it can be quite difficult to maintain a healthy and secure server for an inexperienced user.

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

Basically it provides a data management platform where all our applications (both built in house or purchased from a third part supplier) store and mange their data. We can ensure that such data is kept available to the business at all times.

MS SQL review by Al W.
Al W.
Validated Reviewer
Verified Current User
Review Source

"Microsoft SQL Server Serving the Masses"

What do you like best?

MS SQL Server is a robust, well-established relational database manager. Support for it exists in so many forms. Microsoft of course provides the primary source as the producer and ultimate authority on the product. However, there is an abundance of forums, blogs and users groups with a wealth of information, whether you need to troubleshoot an error, solve a problem or what tips and shortcuts for everyday tasks.

What do you dislike?

It's a Catch-22. For all of the prestige of being so feature rich and robust, it is a complex product with many nuances that differ from the version in the year 2000 to today. Managing the change and keeping up require real effort and occasionally it's best just to pay an expert.

Let's talk about licensing. If major re-sellers have people whose title and sole purpose is Microsoft Licensing Specialist, then things have gotten out of hand.

Recommendations to others considering the product

If you don't have the expertise in house, look carefully bringing in a consultant to set it up right the first time. It will work with default settings but a few hours with an expert can save a lot of time

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

Our primary line of business programs run on Microsoft SQL Server. It is a foundational component of our IT infrastructure and is not implemented to solve problems so much as it carries the load. You could say it solves the problem of needing a fully stable platform upon which to run the business.

MS SQL review by Diego V.
Diego V.
Validated Reviewer
Verified Current User
Review Source

"A robust transactional database, tried and true"

What do you like best?

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.

What do you dislike?

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.

Recommendations to others considering the product

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.

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

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.

MS SQL review by Mayank N.
Mayank N.
Validated Reviewer
Verified Current User
Review Source

"Excellent RDBMS"

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.

MS SQL review by Sara  A.
Sara A.
Validated Reviewer
Verified Current User
Review Source

"From a Beginner's Perspective: Great Software to use when Dealing with databases"

What do you like best?

I am just beginning to learn, but there are so many things I like. Mainly, the ability to extract the precise data I need has been the best part so far.

What do you dislike?

For a beginner it can get confusing, it takes a while to really get a good handle on it and be able to really use it to its maximum potential.

Recommendations to others considering the product

You definitely need to have knowledge of how to use SQL in order to get the benefits of this program. The more you learn, the more effective your use of this program will be.

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

We are able to produce reports using stored procedures for our company. In the past this was only possible with extremely time consuming manual excel reports. I use it now on a daily basis to do different queries for things that come up. Now i can find that information in minutes versus, before when it would take days or weeks.

MS SQL review by Taylor C.
Taylor C.
Validated Reviewer
Verified Current User
Review Source

"The industry standard"

What do you like best?

Works as advertised. Easy to manage. Pretty solid GUI. We've been running a SQL DB for around 8 years with minimal maintenance and headache. We do the SQL Server updates when needed, but rarely have to touch it otherwise.

What do you dislike?

In the rare instance that there is an issue, they can be difficult to solve without getting Microsoft Support on the phone.

Recommendations to others considering the product

I would advise others to go with SQL over any of the alternatives, if nothing else, for the superior company running the development of the program and the very good support that Microsoft provides. I have always been able to get them to fix whatever issue, over the phone, and usually within an hour or so.

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

MS SQL stores all our databases for our CRM engine, which allows us to work more efficiently.

MS SQL review by Prashansa K.
Prashansa K.
Validated Reviewer
Verified Current User
Review Source

"SQL Server developer"

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.

MS SQL review by Brandon M.
Brandon M.
Validated Reviewer
Verified Current User
Review Source

"Microsoft SQL - Excellent DB Platform"

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.

MS SQL review by Cesar G.
Cesar G.
Validated Reviewer
Verified Current User
Review Source

"Database manager easy to use"

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

MS SQL review by Guillermo V.
Guillermo V.
Validated Reviewer
Verified Current User
Review Source

"SQL Server with SAP Business One"

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.

MS SQL review by Derek J.
Derek J.
Validated Reviewer
Verified Current User
Review Source

"My Go-To Traditional SQL Solution"

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.

MS SQL review by Harshiv P.
Harshiv P.
Validated Reviewer
Verified Current User
Review Source

"Positive experience in Data Analysis using Microsoft SQL."

What do you like best?

The simplicity of the language makes it easier to understand and implement statements like joins or procedures in high-level programming language. Hence, it appeals more to beginners as well.

Using other add-ins can greatly extend the features of SQL and make the work easier for the users. This helps in just SQL SSMS as well as for SSRS or other branches of SQL. I would really prefer using Microsoft SQL for performance tuning using Indexing as well for increasing the speed and efficiency in obtaining results.

What do you dislike?

Sometimes, if not handled properly with a predefined schema, relations and maintenance of data becomes an issue. This mainly happens only when it comes to new users or with people who aren't working as a part of a bigger man-force handling the system.

Certain add-ins give useful features as well, but if SQL were to add these themselves it would save the users the trouble of finding and installing them.

Recommendations to others considering the product

Some of the extra add-ins will help in improving the speed and efficiency whilst using the software. ApexSQL is a good example of such.

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

I've been using Microsoft SQL with SQL Server reporting services(SSRS) and also I've been performing data analysis with SQL. And I've found out that segregation of data for analysis is done really well using the SQL concepts. This is really required when working with SSRS to obtain only the required data for reporting. I would also recommend using Aspose Total for Reporting Services (SSRS) for more added functionality if at all required.

MS SQL review by Sandeep S.
Sandeep S.
Validated Reviewer
Verified Current User
Review Source

"Microsoft SQL Server"

What do you like best?

Excellent relational database with extensive SQL query support.

Depending on the need there are different flavors of SQL to choose, like SQL Express, Developer, Standard, Enterprise etc. Express and Developer edition is specially quite useful if you want to try out the product and/or doing development.

SQL database can hold a large amount of data and SQL server can efficiently structure the query.

SQL server management studio is quite useful for debugging purpose. SQL profiler can be used for optimising the SQL queries.

Its highly secure database and DB admin can control who has access to the databases. There are different access levels also.

It has excellent integration with Microsoft technologies like .Net framework, LINQ queries, Visual Studio, Web application etc.

What do you dislike?

SQL server consume lots of memory and needs a high performing multi-core machine especially if the database size is big. Inefficient SQL queries can impact the performance of SQL. Unnecessary locks on SQL operations can also impact its performance.

If your DB size grow (>20GB) then its performance is not up to the mark.

MS SQL is not a good choice if you DB size is huge (like in tera bytes).

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

We use Microsoft SQL server as database for our product. Its used for storing all configuration data and activity data. Its also used for storing user sensitive data like passpords, pins, phone no. email address etc.

We also have some internal websites which use MS SQL server Express as its database.

MS SQL review by Scott S.
Scott S.
Validated Reviewer
Verified Current User
Review Source

"Easy to administer, even for non-db specialists"

What do you like best?

Many IT professionals tend to shy away from database management as they feel it to be tedious and require special knowledge. MSSQL, while complex, gives a UI that makes the system much easier to use. What I truly like best is the idea of what SQL supports, being able to create applications that run off of a SQL database, that streamline business operations. Often times, many businesses have a very manual way of doing things, but a simple C# (or other language) application can increase efficiency, visibility, and profitability very quickly. It is applications like Microsoft SQL that make these applications possible.

What do you dislike?

The non-intuitiveness of security, or managing multiple users. For a company without a dedicated IT staff, scripting may be tedious. When I have came into an organization that had already or was currently adopting Microsoft SQL, the headache they experienced when managing the security of multiple (and new) databases was great. The previous statement rings true more so in an environment lacking active directory and containing a substantial amount of users. However, through building SQL statements, creating databases and copying security settings becomes a non-issues. All that to say, without someone who is familiar with databases

Recommendations to others considering the product

I would recommend Microsoft SQL Server (or SQL Express for those with less of a need).

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

There are many, many business problems that can be solved through database programs. We have implemented numerous C# programs that run from SQL.

MS SQL review by Alexander Marra M.
Alexander Marra M.
Validated Reviewer
Verified Current User
Review Source

"SQL is very usefull with All versions"

What do you like best?

The Express version is flexible enought to attend a number of small companies, and can be use as BI tool storage for this companies also. The easy way to connect the database to another tool, like Excel, PowerBI or any kind of BI tool like Qlik View, Tableau etc. The version of Microsoft SQL Express is very complete and attend many sizes of business.

What do you dislike?

The database is target of many attacks from it's SA account, this must came disabled by default and just after the instalation, some of 30 seconds, the attacks starts, with many requests per second, need to improve the firewall to prevent these attacks, or put the SQL Server inside of a VPN and local network to avoid these attacks.

Recommendations to others considering the product

Pay attention to indexes, and types of relations, try to keep the KPI's well identified, with the dimensions and facts tables well directed and considering to use some procedures as part of solution to business layers. Some programs have to transfer large number of rows instead to take some filters before request the results and this is very usefull when you build web and mobile applications.

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

Many things are developed with Microsoft SQL, from simple database management to CRM and BI, many solutions are develop connecting SQL Express to Excel, Power BI, Tableau or Qlik View. The vast information on internet and collaborator are good also.

MS SQL review by Chris Y.
Chris Y.
Validated Reviewer
Verified Current User
Review Source

"A Powerful Relational Database Server"

What do you like best?

If configured correctly with the proper hardware, SQL Server can be incredibly powerful, delivering millions of data points in the blink of an eye. Even poorly constructed schema can be arranged in views to allow developers to harness SQL's performance benefits.

What do you dislike?

When developing queries with complicated schema, it can be helpful to visualize how the tables are arranged. While SQL Server Management Studio does supply a visual query designer, it can be frustrating to use as (1) it doesn't store your arrangement in memory and will reset if you re-open the designer and (2) can generate some really messy queries using some strange things like RIGHT joins.

Recommendations to others considering the product

If you're just starting with relational databases, you would probably be fine with opting for an open source solution. However, if you need a solution that can handle an enormous number of requests and return results with considerable speed, SQL is worth researching to see if it fits your needs.

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

We use SQL Server to deliver large amounts of data to our clients. As some have moved away from stored procedures and views in favor of technologies that are faster to develop, such as LINQ with Entity Framework, we've noticed that data load time performance has degraded. To fix this, we've taken slow applications and moved querying logic into stored procedures and views to maximize performance.

MS SQL review by Adam W.
Adam W.
Validated Reviewer
Verified Current User
Review Source

"Indispensable and Powerful "

What do you like best?

We've been using MS SQL for many years now and I honestly don't know how we could run our business with out it. The best part of it is how it integrates seamlessly with Windows Server products and makes configuration and updating so easy. If you're running Windows OSs you really need MS SQL.

What do you dislike?

SQL is a complicated system and I wished MS SQL had more learning tools integrated in it. I've had to rely on 3rd party sources just to figure out how to perform backups or database maintenance.

Recommendations to others considering the product

You really need someone with technical and/or database skills to properly maintain and protect your SQL database. If you don't have that you may struggle more than necessary in getting this setup and keeping it working properly.

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

As our business grew we needed a more robust shop control system. The package we settled on employed MS SQL. We haven't encountered a lick of issues when we started using it, and as our database has grown in size (now standing at about 10 GB) there has been almost no performance drop. It's truly amazing.

MS SQL review by Jaya Krishna T.
Jaya Krishna T.
Validated Reviewer
Verified Current User
Review Source

"Sr. SQL Database Engineer"

What do you like best?

Managing database using SQL Server Management studio provides very good flexibility

What do you dislike?

There isn't as much that I dislike with SQL Server. It will be good to have features where we have fine grain control over internal things. For example, it would have been a good feature to have historical tracking of the metrics as opposed to we setting up custom metrics. Overall SQL Server made my life easy to manage lot of databases and ease of use while migration projects.

Recommendations to others considering the product

Microsoft SQL Server is a great product. Ease of use of this product is unprecedented and comfortable.

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

We are using SQL Server right now to support the Lynda.com OLTP OLAP And reporting databases.

we are solving the reporting problems and data warehouse issues. We are also finding it easy to solve the Audit and SOX Controls using SQL Server.

Auditing and Encryption are two areas we are exploring right now to add more value to the usage of the product.

It is also easy to setup database refresh across all the non-production databases using the SQL Server Agent to setup automatic jobs to run on a schedule without manual intervention. Using this we are able to save lot of time in setting this up.

MS SQL review by Ravi Ranjan S.
Ravi Ranjan S.
Validated Reviewer
Verified Current User
Review Source

"Very powerful database "

What do you like best?

Intellisense support for writing efficient queries very quick. Help (F1) functionality for selected word to get to know anything. SQL Job scheduler is great and able to every kind of job from executing a simple query or performing complex logic and sending notificatio email after process. Control transactions using activity manager. Gives ability to create custom sql app using SSIS and reporting services using the SSRS.

What do you dislike?

Do not automatically clears the internal logs to free the unnecessary space. Data shrinking gets hung for large table. Identity reset has the issues if some of data not matching on the query, You have to recreate the table to change it.

Recommendations to others considering the product

Very nice performance in most of the areas. This is one of my the best RDBMS among multiple I used.

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

Data management and utilisation for various kind of custom tools/reports using SSIS and SSRS.

MS SQL review by Matt F.
Matt F.
Validated Reviewer
Verified Current User
Review Source

"It just works"

What do you like best?

You can protype and test a complete system using SQL Express (free) and Visual Studio Code (free) and when you are ready, just upload your tables to SQL Server and go. It's awesome. I've been a user of SQL for years, and they simply keep improving the product with each release. I've yet to come across something it wouldn't handle - and handle well.

What do you dislike?

It DOES require some serious horsepower. The more memory and CPU's you throw at it, the better the performance. I wish it did a little better job at lower memory/CPU's.

Recommendations to others considering the product

If you need a commercially based product, this is definitely worth a look. Much less expensive then Oracle, but all the features and then some.

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

We use it for both data storage/retrieval/reporting as well as for analytics. Although our analytics are pretty primitive compared to some organizations - but it does handle OLAP well.

MS SQL review by Sara N.
Sara N.
Validated Reviewer
Verified Current User
Review Source

"SQL Server Review"

What do you like best?

I like that it helps me control the permissions granted to any user, also I like that I can query any tables in any DB easily, also I like that I can verify my script before executing it, also that I can shrink the database to save space, also I can generate a script with either the structure or the structure with the data for any table or list of tables and execute it in any other SQL DB, also I like the feature of of exporting tables data from SQL DB to another easily, I like the stored procedures, views, it really saves a lot of efforts.

What do you dislike?

Security should be enhanced please, I don't like its level of security and it sometimes hangs while big queries.

Recommendations to others considering the product

I recommend SQL to any company uses Microsoft's programming languages..

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

Client's data storage and data analysis.

MS SQL review by Andrew T.
Andrew T.
Validated Reviewer
Verified Current User
Review Source

"SQL Server 2016"

What do you like best?

What's best is the ability for seamless auto encryption for passwords. Today with data hosted in azure, security is of utmost importance.

I like it's capability for Automatic database tuning, New graph database capabilities, In-memory enhancements.

What do you dislike?

The aggravating part is where SQL Management Studio has been split apart from the database engine at installation. We would have to search around searching for the right version compatible with it's corresponding database engine version.

Recommendations to others considering the product

Careful planning is required on whether to choose between on-site database vs azure database. Differences are significant in terms of management.

According to microsoft site: "The Database Engine is the core service for storing, processing, and securing data. The Database Engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications within your enterprise.

Use the Database Engine to create relational databases for online transaction processing or online analytical processing data. This includes creating tables for storing data, and database objects such as indexes, views, and stored procedures for viewing, managing, and securing data. You can use SQL Server Management Studio to manage the database objects, and SQL Server Profiler to capture server events. "

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

Cloud deployment instead of inhouse.

MS SQL review by Roberto C.
Roberto C.
Validated Reviewer
Verified Current User
Review Source

"Very Robust relational database"

What do you like best?

The robustness of the database, the easy migration path to new versions, the management console is very helpful and easy to use.

The language is very easy and there are a lot of developers out there, so for new projects is easy to get new developers for the team.

The analytics product has a lot of features and it is easy to implement.

The security management is very straight forward and easy to mantain.

The level of integration with other system is high and very well documented.

What do you dislike?

The price for the server license is very high.

Recommendations to others considering the product

It is an excellent product, just check how will impact your budget.

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

We build different kind of transactional application for our core services, and also use Microsoft SQL for third party applications we bought.

The benefits is that the server is easy to deploy and very stable.

MS SQL review by Alejandro E.
Alejandro E.
Validated Reviewer
Verified Current User
Review Source

"Powerfull tool"

What do you like best?

There a lot of features that I really like, every new version have new stuff that makes easier the management of the data, instances, backups, cloud services, users and others, but the features that I treasure more are:

- Azure deployment

- Windows authentication

- Backups

- Role based user management

What do you dislike?

Some years ago it was complex to setup a new instance of SQL Server, newer versions and wizards has made it easier but there are some configurations that are difficult to understand and configure, even more if you have issues with some library or DLL at the installation.

Recommendations to others considering the product

There are a lot of training videos that allows you to understand the extended functionalities of SQL Server, every new version includes new powerful features that make easy the management of the organization needs and also the management of the data in general.

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

This is a Database engine, so common database behavior is not really different than others but, in terms of users management, infrastructure management and cloud based operation SQL Server is an awesome tool.

MS SQL review by Pedro G.
Pedro G.
Validated Reviewer
Verified Current User
Review Source

"Great DataBase "

What do you like best?

I like that it is very easy to create tables from the interface and with code, also it is great that. It is a really powerful database, it is stable and it is fast. Another good thing SQL has is that there is a lot of documentation on the Microsoft websites so if you face an issue, it is likely that there you will be able to easily find the solution or you can create your question on the Microsoft website, and there are a lot of sql communities. Permissions are really easy to assign as they are based on the user role. Doing backups, restorations is really easy on SQL compared to other platforms out there.

What do you dislike?

It is one of the most expensive data storage platforms in the market. Also requires a lot of optimization, if your database isn't well optimized it can run very slow.

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

Creating query's, jobs and stored procedures for the company, also creating reports for the financial team and other departments of the company

MS SQL review by S S.
S S.
Validated Reviewer
Verified Current User
Review Source

"Database Giant - Microsoft SQL"

What do you like best?

Easy User administration, migration, upgrade options in SQL.

Accessing of the database anywhere. Connectivity to any sort of applications .net, mobile apps, database archiving etc.

What do you dislike?

The mail issue is the generation of temp files, which is greater than the DB itself. which is causing the slowness or lagging sometimes. And also the login in to the system sometimes took time. Update package implementation also takes time.

Recommendations to others considering the product

Its the best database which you can use for the production environment. It will improve the efficiency of the application performance. backup is also very easy. Hence this is the best DB.

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

We are maintaining our data in SQL database, from the DB we have created many applications as .net, Mobile apps which is increasing the productivity of our employees

MS SQL review by Anthony G.
Anthony G.
Validated Reviewer
Verified Current User
Review Source

"Hands Down Best Database!"

What do you like best?

Ok, maybe I am a little biased because I develop on the Microsoft stack. But I have developed a lot of applications using other databases as well including: Oracle, MySQL, and Access. I was really surprised about how much Oracle was lacking as it seems to be one of the top Databases these days. I really don't see Oracle really being that far off from MySQL and MySQL is free! SQL Server is by far the best... most feature rich database in the world. I would take a free SQL Server Express instance over any Oracle database any day of the week

What do you dislike?

HUGE learning curve. I've been developing with SQL Server for years and must admit that I am very good, but know I still have much to learn... especially when it comes to administration. Granted, I am a applications developer who integrates with SQL Server almost daily... I am not a DBA.

Recommendations to others considering the product

I get it every body is "The Cloud" this and "The Cloud" that. Azure SQL is ok, but expensive. When it comes to cost and performance nothing can beat an on-premise SQL Server. I hope Microsoft stays just as devoted to SQL Server as it does the cloud... because without SQL Server the world would collapse!

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

What business problems do you have? I've worked as a consultant for years so have created many different solutions using SQL Server as a backend.

MS SQL review by Greg G.
Greg G.
Validated Reviewer
Verified Current User
Review Source

"A solid and much improved platform for data storage"

What do you like best?

Very fast and very stable. It is a feature rich data system and with updated tooling (SSMS, SSIS), discovering and remediating issues in the data storage environment is becoming easier to do which lets me focus on improving things rather than always playing catch-up. I like the disaster recovery options that I have available. I have the choice of making anything from a very basic backup to disk up to and including a robust DR strategy that can restore to any point in time in the last two weeks that is stored both on-premise and in the cloud.

What do you dislike?

One of the most expensive data storage platforms around. Can be a resource hog if your designs aren't smart. Becoming very good at performance tuning requires some effort. The fact that Excel and MSSQL (both Microsoft products), can be flaky when used together.

Recommendations to others considering the product

This isn't MSSQL from back in the day. It has improved greatly over the last 15 years that I've been working with it. The tooling is better, the ease of use has improved, and performance has sped up, and running on VMWare makes it much easier to manage and deploy.

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

We need a place to store data that complies with the software we use at our company. It needed to be something robust, easily supportable, and has a good track record of stability.

MS SQL review by Gagandeep G.
Gagandeep G.
Validated Reviewer
Verified Current User
Review Source

"Easy, Simple, Scale able, robust Database "

What do you like best?

Being as consultant and more inclined towards functional side of application, its not easy to handle the database activities. SQL server is one of the powerful database server which is easy to learn and quick to understand for a normal technical guy. Database restoration, backup, security policies, role mapping is simplest compared to other database applications available in the market.

I am using SQL server since 2008 onward for Dynamics ERP and other related add-ons, tools and interfaces. Query writing has been improved a lot compared to earlier versions of SQL.

What do you dislike?

Nothing much is there which you can say that this is not good in SQL server. However reporting services of SQL server still need improvement to have better performance. Using SQL server with Dynamics AX and where database size is 100GB plus, reporting services become dead slow or very less responsive.

Recommendations to others considering the product

Improvement is must for reporting services for large size databases especially to handle applications like Dynamics AX.

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

I am using SQL server as database server for Dynamics NAV and LS Retail. I have used it in past for staging to integrate ERP with Oracle DB based application, e-commerce, payment gateways.

In addition to this, SQL database is getting used for Jet reporting and other BI applications like Target.

Data replication, backup policy management is awesome in recent releases. On my location machine, for demo and testing purpose, I have more than 10 databases related to different versions of ERP. Managing multiple DBs is not an issue on SQL server.

MS SQL review by Rasha A.
Rasha A.
Validated Reviewer
Verified Current User
Review Source

"The most productive DB engine"

What do you like best?

I like its easy way to connect to any SQL server around the world, also I like the feature to extract data from live client's SQL tables to our testing server which save a considerable amount of time to backup and restore, also I feel very comfortable while querying data, I like also the verify "Check" feature before execute any query so I'm confident that my query will succeed before I executing it, It is very easy to connect to SQL and manage data from most of programming IDEs, also DB shrinking always save us to free big space for new clients

What do you dislike?

It really needs to be more secured as before we deleted the data by mistake and finally we lost a client because we couldn't recove the deleted data completely.

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

CRM and .Net products programming work

MS SQL review by Joseph H.
Joseph H.
Validated Reviewer
Verified Current User
Review Source

"Microsoft SQL - Why SQL is better"

What do you like best?

SQL provides more speed, security and more advanced database features in later releases... it's amazing. I love mostly the new features that 2016 brings to the table of increased database query functionality. It brings the database searches to a whole new more in depth meaning

What do you dislike?

What's not to like about SQL - it's so amazing! The database has come a long way - sure 2008 was a pain but SQL as a whole is a lot better than some companies storing their entire database in access or excel! :)

Recommendations to others considering the product

Go with 2016! SQL 2016 is literally one of the most easy to use. Cannot go wrong with this implementation.

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

Database driven solutions - SQL Server provides an efficient database to run. SQL has been a great benchmark for me to build part of my DB Admin skills upon and learn more functions that help my organization run smoother.

MS SQL review by Mike D.
Mike D.
Validated Reviewer
Verified Current User
Review Source

"Microsoft SQL"

What do you like best?

The full capabilities of all MSQL and being able to set up in a short time. We use this across multiple servers and services. It is a good and stable product and can easily be backed up and restored when needed. I know there are other database solution available and cheaper but for us it is seamless with all of our front end solutions.

What do you dislike?

Like most people the cost of having a full version up and running, because of the need and support for this product we have to pay for our use of the product. This is really the only think at this time that I do not like about this product.

Recommendations to others considering the product

Just be prepared for the sticker shock of using it for large database. It definitely is the cost of doing business. It is a good and stable product and can easily be backed up and restored when needed.

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

We have 40 SQL servers up and running. We have been using a single instance of SQL to run multiple Smaller databases without impact. We have been able to backup and move databases in MSQL flawlessly with out having to have more support than needed.

MS SQL review by Lucas G.
Lucas G.
Validated Reviewer
Review Source

"El mejor servidor de bases de datos"

What do you like best?

Las consultas son muy fáciles de ejecutar. Lo mejor es que las consultas se pueden ejecutar incluso si la base de datos no está conectada al servidor, de esa manera evitas errores y la velocidad es mucho mayor.. Incluye una gran cantidad de herramientas para trabajar con datos que incluyen importación, exportación. Se pueden construir tus propios módulos personalizados que se integrarán directamente en el servidor. Los usuarios pueden escribir sus propias aplicaciones a su alrededor, aunque a menudo se usa para admitir otro software disponible donde se requiere una base de datos. Pero sin duda, lo mejor es la integración con la mayoría de los productos de Microsoft, entre ellos .NET, hacen que la configuración sea muy sencilla.

What do you dislike?

Una base de datos SQL es algo extremadamente complicado, por lo que hay mucho que aprender tanto para utilizarla como para administrarla de la manera más efectiva. Esto requiere mucho tiempo de aprendizaje, puesto que no es algo sencillo.

Recommendations to others considering the product

Mi recomendación para cualquier persona que busque realizar un cambio o utilizar un motor de base de datos por primera vez es que utilice Microsoft sql, puesto que se han simplificado todas las cosas en un paquete limpio y ordenado. Hacer este cambio será más fácil, más productivo, permitirá una mejor recuperación ante desastres, y además podrás obtener sorprendentes informes frontales y posteriores.

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

Soy un trabajador autónom y necesito algo donde se organicen y se almacenen mis datos muy fácilmente. No me gusta tener muchos archivos de tipo .csv / .txt por todos lados, así que uso SQL Express para almacenar mis datos y luego poder acceder a ellos de manera rápida y fácil. Por lo tanto puedo manipular los datos muy fácilmente más adelante.

MS SQL review by Suso N.
Suso N.
Validated Reviewer
Review Source

"The microsoft SQL Solution"

What do you like best?

To grow ground-breaking web applications in .net is unmistakably outstanding amongst other alternatives. The speed of association and the power and flexibility of the put away techniques make it simple to deal with it. Its very easy to start using it. It incorporates the Microsoft Sql Server Management Studio which is the instrument with which to interface both the neighborhood server or remote and with which to work outwardly on the database. It likewise joins many produced reports, reports to see the status of databases and make auspicious move.

What do you dislike?

The most noticeably awful thing is the establishment, it is extremely lumbering and convoluted on the off chance that you don't know how to do it or in the event that you don't have a guide, it is anything but difficult to design some angle seriously and have issues later on.

Recommendations to others considering the product

Great for all kinds of .NET developments as it belongs also to Microsoft and has total integration with each other.

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

In our association it is the work framework for the .NET works, we have a few servers in with their particular databases for the elaboration of different tasks.

MS SQL review by Julio G.
Julio G.
Validated Reviewer
Review Source

"Work with Microsoft SQL"

What do you like best?

It is compatible with most of the systems, you don't have to worry about that.

There is a lot of information in the internet if you have any problem, so it's very easy to solve your unknown issues.

Once you go live with one of these solutions, the procedure is quite similar in other servers.

Everyone in our environment knows how to use it as a user, so you have less tasks to do.

The language you use for quering is the same as other platforms.

I don't know what else can I say, it's very early in the morning and I don't have more ideas to share with you.

I encourage you to start using it right now, you won't regret al all.

All of my partners prefer Microsoft SQL rather than other solutions, btoh free and paid ones.

I think it worth it, give it a chance, don't hesitate.

What do you dislike?

When the data amount is too big, the sytem becomes slower and slower.

The free disk space decreases very quickly in your server using Microsoft SQL.

Sometimes you get random errors that can make you loose your marbles.

Recommendations to others considering the product

Think about it before considering free solutions.

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

I use Microsoft SQL in every server I deploy. In the whole, thera are more pros than cons.

In several clients, the price of the solution is an issue for them to deploy it, we have to persuade them.

MS SQL review by Marce d.
Marce d.
Validated Reviewer
Review Source

"This is an excellent software for the proper use of database"

What do you like best?

I like this software one of the things that I like the most is that it allows me to take advantage of time a lot. One of the great advantages is that in a certain way it allows several users of Microsfoft SQL to connect in a certain way to time and observe the information of the other members of a work team, also cade destacr that SQL allows administering access permissions, to determine who can see some and do other things and who on the other hand no, I think a good software has been quite helpful

What do you dislike?

I believe that the disadvantage of this Software (SQL) has been its price which is not accessible to all companies and additional to implement the software in a proper way is necessary to have good equipment otherwise the program will be a little slow

Recommendations to others considering the product

I would give as a recommendation that they first relate to the software and in this way determine if it really is feasible enough for the company, be it big or small, it is important to know that not everyone is good at investing in certain software, in the same way I consider that is excellent and that their results are good

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

Well thanks to SQL I have been able to optimize the time of work because it is easier to work with a good database and additional that everyone has the respective access to each tool, it is easier to determine the improvements that should be applied to each product

MS SQL review by Kristen N.
Kristen N.
Validated Reviewer
Verified Current User
Review Source

"Microsoft SQL Server Review"

What do you like best?

Powerful SQL Profiler provided by MS Sql server. SQL editor is more efficient for writing high performance queries.Centarlized sql service to control the server processings. Data backup can be automated and controlled through custom commands. SSRS, SSIS and SSAS are the really very good in BI related tasks.

What do you dislike?

Need to be more scalable to challenge the latest RDBMS in market. Multiple editors opening together causes slow performance. Debugging cannot be performed on remote server.

Recommendations to others considering the product

SQL Server has a rich and configurable offerings for every projects. This gives you easy access to every aspect of a RDBMS.

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

SQL data storage and retrieval. Very efficient database server with unlimited functionalities and cutomisations.

MS SQL review by Bridget B.
Bridget B.
Validated Reviewer
Verified Current User
Review Source

"Microsoft SQL Server Review"

What do you like best?

MS Sql Server provides a complete package for all database tasks. Nice Sql editor with large in built library. Creating Sql job agent is very easy. Provides many options to configure and schedule a automated sql job. Command based control for automated tasks. Restoring and replicating database back up is also seamless. Provides query optimiser for selecting best possible query plan and write efficient query.

What do you dislike?

handling update and insert on Large data is a little bit challenging. Sql server becomes unresponsive sometime and you have to kill the process.

Recommendations to others considering the product

Nice RDBMS to support the multiple languages. Great for mid size data and application.

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

Data storage, retrieval and data replication.

MS SQL review by alfredo p.
alfredo p.
Validated Reviewer
Review Source

"Panoramica Sql Server "

What do you like best?

Seguramente el punto fuerte de SQL Server es su facilidad de instalación y su IDE muy amigable. Por esto es bastante sencillo empezar a trabar en SQL Server sin tener un conocimiento avanzado y simplemente siguiendo guías y tutoriales que hay en la red.

What do you dislike?

Respecto a otras Bases de datos relacionales, necesita de muchos recursos de maquina para funcionar de forma fluida. Esto es un problema sobretodo para aquella personas que no disponen de un servidor dedicado y que utilizan su ordenador para instalar las instancias y el motor de SQLServer

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

Es una herramienta potente para almacenar datos, y sobre todo fiable, esto permite centralizar la información fácilmente, y con el apoyo de las herramientas de BI, tratar la información, integrarla o generar cubos. los beneficios para las empresas con la que he colaborado se traducen en tiempos rapidos para la gestion de la informacion corporativa

MS SQL review by Administrator
Administrator
Validated Reviewer
Review Source

"Potencia Microsoft"

What do you like best?

Sistema gestor de bases de datos propietario de mircrosoft. La potencia de este sistema radica en su optimización y fácil integración con proyectos de desarrollo. Para desarrollar aplicaciones web potentes en .net es sin duda una de las mejores opciones. La rapidez de conexión y la potencia y versatilidad de los procedimientos almacenados hacen que sea muy sencillo trabajar en esta plataforma. Además es muy visual y el lenguaje de consultas que incorpora es muy intuitivo. El propio editor de consultas te va sugiriendo ayudas para las tablas y los campos de las mismas, lo cual facilita mucho la labor de realizar consultas, actualizaciones y tareas de mantenimiento. Incluye el Microsoft Sql Server Management Studio que es la herramienta con la que conectar tanto al servidor local o remotos y con la que trabajar de forma visual sobre la base de datos. Además incorpora muchos generados de informes, reportes para poder visualizar el estado de las bases de datos y tomar medidas oportunas.

What do you dislike?

lo peor es la instalación, es muy engorrosa y complicada si no se sabe hacer o si no se tiene una guia, es muy facil configurar mal algún aspecto y tener problemas más adelante.

Recommendations to others considering the product

si estas desarrollando .NET, sin duda una solución Microsoft es la que mayor potendial y nivel de integración te puede aportar, tanto a nivel de código como a nivel de IDE (Visual Studio)

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

En nuestra organización es el sistema de trabajo para los desarrollos .NET, tenemos varios servidores en local con sus respectivas instancias de bases de datos para la elaboración de los proyectos de clientes e internos.

MS SQL review by Mike K.
Mike K.
Validated Reviewer
Verified Current User
Review Source

"My favorite DBMS hands down"

What do you like best?

Being able to visually manage databases, backups, maintenance plans, and user security.

What do you dislike?

I wish restoring backups between different versions was possible. There are times where I want to restore a production backup on a development machine and cannot due to the versions of SQL Server being different. I know that there are difference s between the actual formats, but I wish SSMS had ways of migrating those differences during restore.

Recommendations to others considering the product

It provides an intuitive interface to something that on its own is very complicated. It is the best DBMS I've used in my 10+ years in the industry.

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

We use it as the client tool to manage databases for 95% of the software we develop for our clients. Trying to manage it SQL through command line would be tedious, so SSMS saves us a ton of time.

MS SQL review by Administrator
Administrator
Validated Reviewer
Verified Current User
Review Source

"Review from a Legacy User"

What do you like best?

The Microsoft database has matured very well in the last decade, from being a simple basic repository to being one of the most complete information storage engines, with development tools, business intelligence, data synchronization, reporting, among others that help in the day to day for the administration within a typical company

We have been pleased to work with Microsoft for many years. We have worked together in numerous workshops and have been eagerly adopting and testing new features in the preview phase. The technical support and guidance we get from the product team from Redmond has exceeded our expectations.

What do you dislike?

The slow pace of development of new features, is much slower than its competition, although considering the product in the state that can be found the reason can be understood.

Recommendations to others considering the product

Just Buy it, easy in all the ways, cheaper than ORACLE, more stable and you actual can recover from a big crash something that ORACLE can't

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

Centralization of Database without requiring a giant server, as well as the simplification of tasks attached backups reports etc

The only problem we found was the migration of data from different engines to SQL

MS SQL review by Aitor G.
Aitor G.
Validated Reviewer
Review Source

"The best SQL software on the market."

What do you like best?

I have tried a lot of SQL software and this is definitely the one that convinced me the most. It is easy to use, it manages RAM memory very well, it has a large community behind it, the possibility of installing dozens of plugins to improve the use of the tool and many other things, without doubt Microsoft SQL is one of the best tools that exist. You also get annual updates.

What do you dislike?

The only thing that bothers me is that there is not the famous option of warning you when you delete without where'. I could add this possibility as an option in the program to avoid major disasters that have ever happened to all of us.

Recommendations to others considering the product

I recommend using it because it's an easy to use tool but it's a constant learning tool because it's very deep, it's very stable and that's the most important thing in any SQL software.

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

Thanks to Microsoft SQL we can generate queries and procedures of a large amount of information. In addition all our new employees have started to use Microsoft SQL and have learned in record time due to the ease of use of the software, but still every day we continue to learn because in addition to facial is a very deep tool.

MS SQL review by Ashok K.
Ashok K.
Validated Reviewer
Verified Current User
Review Source

"Great database with best features"

What do you like best?

Window based sql services to stop and start the sql server process.

Sql profiler and Sql job Scheduler are very good features of Microsoft sql server.

Sql editor has nice support to validate queries, debug, execute queries, Check the performance plan of queries using query analyzer.

Writing queries is easy with intellisense support.

Bulk data delete and generating database scripts is really easy.

Plugin with other third party tools is easier.

Sql server has the inbuilt CLR support to execute C#/VB or any dll code.

What do you dislike?

Database Restore and Restart process stuck when the database is in use. Sql server needs to restart to complete these tasks.

Recommendations to others considering the product

Great database with so many great features.

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

Database server to process the application data and display on screens.

MS SQL review by Aishwarya A.
Aishwarya A.
Validated Reviewer
Review Source

"The best RDBMS to work with being a Database Administrator!"

What do you like best?

Its super easy to use and management. I use the SQL Server Mangement Studio and once you create your tables, you can be rest assured.

What do you dislike?

Sometimes it is a little clumsy when taking in queries. For instance, I do not like referring to the master db again and again when I have already written the query to use it. Every time we have to refer to the main db.tablename which gets redundant.

Recommendations to others considering the product

Go for it! It is the most obust and simple tool available on the internet. Best way to start learning and building up your SQL Relational databased skills. Very good compatibility with other software types and IDEs and satisfies your solutions and problem needs.

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

I am working a website in ASP.Net Razor with SSMS and hosting it on Azure Portal. The website comprises of 2 parts to it where one is in which the teachers and clerks enter the student details that comprises of both demographics and classroom attendance and the other application uses .rdlc to generate reports for client side based on the data entered and requirements.

MS SQL review by alex S.
alex S.
Validated Reviewer
Verified Current User
Review Source

"Easy Fast and Effective"

What do you like best?

Easy software no gimmicks outstanding graphics and chats. Very easy to understand use and publish helps great with video conferencing. amazing speed hardly ever any fixes or bugs no shut downs either. The speed at which the thing goes is absolutely amazing great for video calling overseas also the ability to screen share and other neat fixes.

What do you dislike?

There is nothing to dislike everything works exactly as it should no issues. Better than any other software out there.If any other thing that it might need help is that the soft ware for the charts and pies is a little slow maybe the colors could be more bright as well.

Recommendations to others considering the product

I absolutely recommend this product even if its just for video conferencing. If not that just the simple use of the calendar and organization of the data charts and patient consumption its like having a secretary it does everything for you. There is hardly any fixes or bugs to deal with just amazing software.

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

Dimensional analysis such as project managing growth charts. Sales as well incline of decline of consumers or reviews. Benefits other than more consumers is the ability to connect with them and our schedule that it puts together gets the product out faster as well as organizing patient charts to better determine the usage of the product and how well. I know many who swear behind other products as well but there is none other.

MS SQL review by Mostafa H.
Mostafa H.
Validated Reviewer
Verified Current User
Review Source

"Microsoft SQL review"

What do you like best?

I like best querying data from more than one table using the SQL, I like also the syntax checking and I like opening more than one tab for different queries a lot, also I like easy import and export structure or\and data between more than databases, I like also the object explorer as it list all servers, databases, views, SPs, tables, etc in one place, I like also script generation, it helps me a lot copy a big script with structure and data and execute it easily in another SQL server without backup and restore, also I like the accessing control.

What do you dislike?

Not easy to setup and it hangs sometimes

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

Data storage and business logic stored procedures to be used by our developers

MS SQL review by George G.
George G.
Validated Reviewer
Review Source

"Robust & Easy to use"

What do you like best?

The SSMS in general (e.g. IntelliSense, tools for Tasks)

What do you dislike?

Lack of proper support for spatial data.

Recommendations to others considering the product

It's a very easy to setup and use database. The Microsoft SQL Server Management Studio is in my opinion not just a big plus but the main selling feature. Easy to get into and use. Robust toolkit that never failed me when I had to setup and execute tasks. The execution times are completely acceptable if you take into account the size of our Database reached 1,5 TB. Coming from a PostgreSQL, Spatialite, SQLite background it is now hard to go back to them when it is required (mostely for spatial data operations and/or for more compact results). A perfect solution for a company enviroment if you don't want to handle spatial data, you don't need a compact solution and you can afford the licence fees.

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

Storing Data from User Data Entry front end, correlate and serve or export them.

MS SQL review by Anthony J.
Anthony J.
Validated Reviewer
Review Source

"MS SQL is the best RDBMS"

What do you like best?

What I like best in MS SQL, like any other Microsoft product, is the simple and easy to use user-interface (I guess most of us are familiar with Windows). I can make queries and scripts easily and without any trouble. Basic SQL knowledge is required.

What I love most about MS SQL is the Profiler. It's very handy and it helped me a lot when debugging apps. It allows you to see what's "happening" on the server, what scripts are executed, along with the parameters, which does not seem to be supported by other RDBMS..

What do you dislike?

It sometimes lags. It doesn't paginate result sets which could be problematic when searching millions of record. It needs more RAM utilization and conservation.

Recommendations to others considering the product

MS SQL provides top of the lines features for all your RDBMS needs. From development to deployment and support, this software can help you finish your jobs.

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

MS SQL has been always our first option for data storage. I helped us to make decision on purchasing server machines to meet specs accordingly.

MS SQL review by User in Wholesale
User in Wholesale
Validated Reviewer
Verified Current User
Review Source

"SQL makes it much easier"

What do you like best?

I like that SQL makes it much easier to pull up the reports I need for a customer or employee. For many of the queries I run on SQL, I had to run as many as 6 or 7 queries on our cyberquery program to get all the information I needed.

What do you dislike?

Sometimes, the join conditions when designing the query automatically link up with whatever SQL thinks the tables should be linked up by but is almost always wrong. We have to remove the connection and join with another part of the table. It isn't hard but just kind of annoying for very large tables we have set up.

Recommendations to others considering the product

I would highly recommend Microsoft SQL especially if your company has to generate several reports from multiple programs and locations.

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

We mostly generate reports that have anything from sell reports, to item information, and whatever information we need to put together for several different types of requests from within our organization and our customers.

MS SQL review by Ryan J. H.
Ryan J. H.
Validated Reviewer
Verified Current User
Review Source

"SQL Rules the Roost!"

What do you like best?

Standard across all platforms, simple to use- and support is world wide. If you have questions, you can always google and find the answer

What do you dislike?

It can be tedious for new users, esp if limited in background of Queries or Scripting. I wish MS Would offer a SQL 101 class to all users whom purchase a software license

Recommendations to others considering the product

Be sure to check all variants of your data, and that it it can be converted. Data implementation can be expensive, or lackluster of cost- all depends on if your information can be adapted to SQL Schema with ease. Be sure as well, to remember your tables and locations of data for reporting.

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

ERP system runs in the background with SQL, and using reporting services instead of Crystal for reporting.

MS SQL review by Christopher K.
Christopher K.
Validated Reviewer
Verified Current User
Review Source

"SQL Server is a trusted platform that is slowly growing into a new data landscape."

What do you like best?

Having worked with SQL server for over a decade, I have come to rely on its simplicity over some database systems, as well as the well established education and support system Microsoft has in place.

What do you dislike?

SQL Server is unfortunately slow to adapt to the changing requirements of the IT and data landscapes, lagging behind in high availability and compatibility areas.

Recommendations to others considering the product

SQL Server is not always the fastest to adapt new technologies and methodologies, but they are moving in the right direction with high availability, scaling, and cloud solutions. SQL Server on Linux support promises to make SQL server a more affordable option in the future, I highly recommend staying educated with the great support community online.

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

SQL Server allows us to reliably serve data to our products with trusted framework that has been in use across the organization for many years.

MS SQL review by Administrator
Administrator
Validated Reviewer
Verified Current User
Review Source

"MS SQL SERVER "

What do you like best?

Management of very large volumes of data such as bulk loading , Is one of the best (if not the best) relational database ,It brings you great ETL tools and data warehousing such as SSIS and SSAS

What do you dislike?

The cost of Microsoft SQL Server is often not feasible for smaller businesses. I'd like to see source control integrated into SQL Server, so that all changes to the database objects are automatically versioned and stored for reference or retrieval.

Recommendations to others considering the product

It's stable and reliable - a mature product and known industry leader.

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

partitioning the huge tables and retrieving the data easily. Good query optimizer. For complex a query it provides helpful tools like Query Tuning Advisor.Good additional out-of-box features like Integration services, Analysis services and Reporting services.SQL Server is highly scalable. With correctly designed databases and well-tuned queries, we're able to store and retrieve data at almost any scale.

MS SQL review by Merlys H.
Merlys H.
Validated Reviewer
Review Source

"SQL.(Structure Query Language)"

What do you like best?

SQL propociona metodos para definir la base datos, para manipular la información y para gestionar los permisos de acceso a dicha información.

What do you dislike?

Este lenguaje es increible pues tiene un grupo de Palabras Clave

Las palabras clave son identificadores con un significado especial para SQL, por lo que no pueden ser utilizadas para otro proposito distinto al que han sido pensadas.

SQL dispone de muy pocas órdenes, pero de multiples pálabras clave, lo que le convierten en un lenguaje sencillo pero tremendamente potente para llevar a cabo su función.

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

este lenguaje ayuda a que la nomina de empleados de una empresa sea mas compacta y fácil de buscar un registro de un empleado. Cambien funcionaria para una zapatería y sus innumerables modelos de zapatos, ademas de clasificaros por talla, color, etc. Es increíblemente versátil el lenguaje SQL, lo que hace aplicable a cualquier tipo de escenario.

MS SQL review by Jan Marie A.
Jan Marie A.
Validated Reviewer
Verified Current User
Review Source

"Great for database work"

What do you like best?

I enjoy using Microsoft SQL Server because it's very well documented and supported, and the software is used by a large number of people so there is a big support community. When I have a question about how to do something it's easy to find information either in the documentation or online.

What do you dislike?

I really don't like that I can't use it with my Mac. I have a Windows machine and a Mac at work and I have to do all of my SQL Server stuff on the Windows machine. It would be nice if it were supported on Macs as well.

Recommendations to others considering the product

If you need a professional SQL database and have the funds to purchase MS SQL and the majority of your users are using Windows machines, I recommend this product. If you use mostly Macs and/or Linux or need cross platform compatibility it may not be for you.

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

All of our descriptive analytics is currently done with SQL Server. We store all of our data on databases and manipulate it using MS SQL Server Management Studio.

MS SQL review by Denis V.
Denis V.
Validated Reviewer
Verified Current User
Review Source

"SQL Server RDBMS"

What do you like best?

Works on cloud and on-premises servers.

Deep integration with another Microsoft and not only products.

It is cross platform RDBMS can be run as on Windows and on Linux.

It is very fast and stable.

It got good security with data encryption and another options.

It provides multiple high availability solutions to choose from.

What do you dislike?

Not very easy to conduct performance tuning, need to use multiple tools, there is no any native good graphical tool from the box.

Not very easy and fast to perform migration from instance to instance.

Not cheap solution.

Recommendations to others considering the product

Recommend to use.

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

To keep and access data for different purposes.

You can test many features of the product by using free developer version before pay it.

MS SQL review by Tracey M.
Tracey M.
Validated Reviewer
Review Source

"the best database server."

What do you like best?

Queries are easy to execute and it is very convenient to create new servers. The best thing is that the queries can be executed even if the database is not connected to the server. It includes a large number of tools to work with data that include import, export, SSIS, SSMS, TSQL and more. You can build your own custom modules that will be integrated directly into the server. Users can write their own applications around them, but it is often used to support other available software where a database is required. The best part is how it integrates seamlessly with Windows Server products and makes configuration and updating so simple.

What do you dislike?

The process of configuring access ports can be confusing and is not easily accessible after installation.

Access control is very rigid in its configuration, which means that its configuration requires greater knowledge.

Recommendations to others considering the product

Detailed description of any execution execution. Different types of security controls.

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

The sql server is a complete solution for storing persistent data. It is complete and reliable and allows you to focus on the application and not on how the data should be stored.

MS SQL review by shikha a.
shikha a.
Validated Reviewer
Review Source

"A Versatile SQL Database With Great Performance and Rich Feature Set"

What do you like best?

Microsoft SQL Server offers a lot of flexibility in terms of the data manipulation, relational joins, search criteria etc that make it very versatile for a variety of applications. It offers a lot of design options spanning from multiple indexes, foreign keys, rich transact sql, jobs, service broker for messaging, user and role management which give the user myriad of options to select the best possible fit for their individual need. With the right design it gives you a very robust platform with amazing performance! Its latest offerings in the form of integration with R and Python shows the commitment of Product Team to continually enhance it with the upcoming features like machine learning.

What do you dislike?

One option that I seem to be missing is the sequnce generator, like if I wanted a running number for each of the transactions, and I did not want any number to be lost if a transaction rolls back, I would want an automated mechanism for that. I would also want SQL to enforce good design decisions like enforcing acquiring locks in a particular order.

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

We are using SQL to serve as backend for multiple large products one of them being a multi tenant ERP Application. It has been instrumental in facilitating developemnt of such a lage application in minimal time. Also the tools and basic architecture of the SQL lead to maintaining data consistency and fast data retrieval a very manageable task.

MS SQL review by Donald H.
Donald H.
Validated Reviewer
Review Source

"Easy to use with tons of features"

What do you like best?

I've used a number of DBMS tools but the thing that stands out to me in regards to SSMS is the ability to analyze execution plans. Not very many DBMS tools have this and the ones that do are not as good.

Along with that, having code complete is another awesome feature. As long as it isn't an Azure SQL db, code complete works really well and is very fast.

What do you dislike?

Without a 3rd party add on, there is no code complete when working with an Azure SQL cloud database. Also, unless you are running a new version, it doesn't support connecting to an Azure SQL db using Azure credentials. You need to be sure to have a newer version for this to work.

Recommendations to others considering the product

If using this to connect to an Azure SQL database, check out the free SQL Complete tool from DB Forge. It will give you back auto complete.

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

Besides general querying of our data, being able to analyze execution plans and get insights into how to make our queries more efficient is awesome. It has helped us find specific bottlenecks and improve our application performance.

MS SQL review by Anirudh P.
Anirudh P.
Validated Reviewer
Review Source

"One of the Best ETL Tools for SMBs"

What do you like best?

The top point that comes to my mind about SQL Server Integration Services is that it is a part of the SQL Server Data Tools which can be downloaded for free as mentioned here: https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017

+ I was able to download the SQL Server Data Tools for Free, and connect to our SQL Server Enterprise Edition and we never had to worry about the extra cost for buying an ETL Tool.

What do you dislike?

I don't actually dislike anything in the tool in itself. However, as I've read in many online blogs, many of the ETL jobs break in SQL Server Integration Services when the datasets that we deal with are too large in size. I faced a similar issue during my graduate degree when I was using SSDT to connect to a remote server on a University of Cincinatti server. The jobs break from time to time but I felt most of the times, this was caused due to server disconnection. So, I cannot vouch for any cons of the Integration Services at least now.

Recommendations to others considering the product

If you already have a SQL Server Express or SQL Server Enterprise Version running in your company, you should probably go with SSDT and SQL Server Integration Services might meet your need without fail.

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

We are designing ETL Workflows to automate and manage our daily inflow of Projects, Services and Performance data into our SQL Server database, instead of creating SQL Procedures and importing raw text files and Excel files on an ad-hoc basis.

MS SQL review by harshendra a.
harshendra a.
Validated Reviewer
Review Source

"Best database tool "

What do you like best?

Easy to install and troubleshoot problems. Training materials are easily available on docs.microsoft.com.

Never crashes if you have minimum system requirement. Querying on multiple database is easy .Works flawlessly with other applications example visual studio. Even for practicing purpose can be installed on personal computers. Ability and power to work on ssrs ,ssas ,ssis is very helpful.

What do you dislike?

Compatibility with lower versions of windows is a factor . working with big data sets may cause performance issues. Some updates on windows may turn of services and which may cause an error for that every time have to enable services in services.msc.Working in cluster environment is a challenge .Could be more smooth and more user friendly.

Recommendations to others considering the product

It is very easy to maintain and as per security point of view quite trustworthy.

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

I am working on clients database in healthcare domain . Benefits are countless but worth mentioning is configuring etl jobs and database architecture . It is very easy to restore database and recover it.

MS SQL review by Jose Leandro M.
Jose Leandro M.
Validated Reviewer
Review Source

"Sql Server es uno de los mejores manejadores de bases de datos."

What do you like best?

El Sql es muy fácil de usar, su sistema gráfico le permite crear una base de datos en segundos.

Puede diseñar tablas, colocar datos sin la necesidad de códigos.

De la misma manera, puede realizar todas las operaciones mediante comandos, que pueden ser muy útiles según la experiencia que tenga.

Sql permite trabajar en alta disponibilidad para tener siempre tus datos disponibles.

Tiene un gran sistema de respaldo el cual puede ser configurado para hacer backup diarios, semanales o mensuales.

What do you dislike?

Cuando las bases de datos son muy grandes, el servidor del servidor se vuelve muy inestable.

Se requiere mucha memoria RAM.

Recommendations to others considering the product

Es recomendable realizar un curso basico de sql para poder tener el mejor provecho de la herramienta.

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

Hemos podido guardar toda la información que se requiere en una o varias bases de datos y buscar la información fácilmente con querys.

MS SQL review by Ratnesh M.
Ratnesh M.
Validated Reviewer
Verified Current User
Review Source

"Super Efficient RDBMS"

What do you like best?

Activity manager to control locks and transactions, Profiler to get the query running on database, Query analyser to analyse the best performance management, Sql job agent to schedule the various kind of jobs, Executing sql queries from command prompt, features to create generate sql queries of various kinds, pre-build sql library to write efficient queries are all good features.

What do you dislike?

Running alter/update quires on high size database takes lot of time and eventually cause to restart the DB to abort the job. CPU usage used by sql server is very high all the time. Takes time in exit the SSMS.

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

Data management. SQL Server has given us all the capability to handle the large size data.

MS SQL review by Nick S.
Nick S.
Validated Reviewer
Verified Current User
Review Source

"Unless you are massive, this is the way to go"

What do you like best?

It is easy to implement and has a huge install base with corresponding online support and help sites. The user interface is fairly slim and very functional.

What do you dislike?

Configuration is a little tricky, but not bad. Obviously it is designed for SQL Server. If you are using Oracle, then Toad is probably more appropriate. The download file is large.

Recommendations to others considering the product

Just do it. Furthermore, teach your employees how to properly code in SQL. Any application that provides a point-and-click interface for generating SQL is simply limiting your ability to extract data. Invest in the education to empower your employees to be better.

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

SSMS is the basis for submitting SQL commands, so it is the beginning of virtually everything.

MS SQL review by Felipe A.
Felipe A.
Validated Reviewer
Review Source

"El mejor motor de bbdd"

What do you like best?

Es el mejor motor de bbdd que conozco. Mejor que oracle y mejor que muchos otros. Rapidez, facilidad de uso y soporte excelentes. Me encanta poder crear tablas y procedimientos de una manera sencilla. Los jobs que tiene son bastante buenos y se pueden utilizar para casi cualquier cosa.

What do you dislike?

Nada, todo es perfecto. Es un producto que es espectacular. Lo utilizamos como motor de base de datos en muchas de nuestras aplicaciones y funciona perfectamente. A veces tarda en conectar mucho si vas por VPN

Recommendations to others considering the product

Debéis de usarlo puesto que es muy eficiente. Todo lo que diga es poco, estamos ante uno de los mejores productos de Microsoft

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

Todos los problemas con BBDD los he resuelto gracias a esta maravillosa herramienta. La idea es que sigan mejorando, pero yo creo que el camino que llevan es bastante bueno

MS SQL review by Mark V.
Mark V.
Validated Reviewer
Verified Current User
Review Source

"SQL Server"

What do you like best?

The use of SSMS to interact with SQL from on it resident box or across the network is very easy. It help with building scripts from templates makes them quick to build.

What do you dislike?

That the reporting services is a different module that requires a license. When you have SharePoint and have a SQL license it should be included. It makes writing reports on SharePoint easy and should be included in the basic installation .

Recommendations to others considering the product

its products are good for hybrid maintenance with Azure SQL and on prem SQL. The combination of site administration with a web screen and using the SsMS tool allows for fast development, testing, and analyzing.

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

Business intelligence/ reporting from SQL server and SharePoint lists/document libraries.

MS SQL review by Administrator in Libraries
Administrator in Libraries
Validated Reviewer
Verified Current User
Review Source

"SQL Server"

What do you like best?

Works well enough like any other relational database, though I always love using Microsoft native tools. I think that I would specifically choose to use a Microsoft SQL database over a MySQL just for the known brand/name and the expected stability and vendor support.

What do you dislike?

The built-in management tools are too bloated. It takes a while for them to load up, and when they do often they feel more clunky than they should for such an enterprise product. I also feel the security, while important and tight, is often too difficult to navigate based on roles, users, etc. It may be more suited to larger deployments with dozens of unique roles and users within them.

Recommendations to others considering the product

Use a third party tool such as Heidi SQL to manage .

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

We host our public website, intranet, fine/fee management, and help desk ticketing system with the help of Microsoft SQL server. We also run our Finance server software through Microsoft SQL, though it is more heavily managed by the vendor.

MS SQL review by Rakesh K.
Rakesh K.
Validated Reviewer
Review Source

"Microsoft SQL Review"

What do you like best?

Microsoft SQl is great for small school projects to small-time businesses to huge multi-million business applications. It is useful to store, modify, delete data within a matter of minutes. After storing this data, searching for it is probably the simplest, amongst all its other competitors. It is also great when multiple applications are asynchronously accessing this data. Security permissions are great in Microsoft SQL.

What do you dislike?

Installation is a little cumbersome, and also ends up consuming a lot of RAM. Also, I feel UI can be improved to give more useful messages to the SQL operator. Also, I feel performance is hampered slightly for huge tables.

Recommendations to others considering the product

I think it is still the best product in the market for storing structured data. It is far ahead of all its competitors. So, go for it!

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

We used to use Microsoft SQL for lot of testing simple databases to storing billions of lines of customer data.It is great for storing structured data, and retrieving them with simple queries.

MS SQL review by Consultant
Consultant
Validated Reviewer
Verified Current User
Review Source

"SQL: It's quick and easy"

What do you like best?

SLQ 2012R2 is what I have been using and makes my life really easy to run queries on database to analyze complex data.Easy to build your own query to fetch any sort of data. Quick response and capable of pulling large data from the database. You can keep creating and running queries and would be able to run only the one which is highlighted which gives you a capability to store your queries on the same screen. You can even run queries to update entries in your database and the confirmation of the success can be easily observed in the bottom part of the screen.

What do you dislike?

The interface should be more user friendly and built in a way to to predict formulas like MS Excel. The user interface should be more easy to read interactive.

Recommendations to others considering the product

Its a very good product and easy to use.

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

We fetch information for a large chain of hotels building complex queries for analysis and fixing some functional problems. We run queries to update entries in your database and the confirmation of the success can be easily observed in the bottom part of the screen. I have observed several benefits like if you have the knowledge of the database which means all the tables then it is very easy to find the cause of several issues and fixing/updating the database with custom queries. I really like the speed with which you are able to complete your tasks.

MS SQL review by Richard W.
Richard W.
Validated Reviewer
Review Source

"Microsoft SQL Server"

What do you like best?

Microsoft SQL Server client software seems to be the easiest software available for creating complex SQL Queries visually. I love its drag and drop capability for linking tables and views and for creating stored procedures for automatic code execution.

What do you dislike?

The only problems I have with it is that it take a lot of system RAM to operate and it's a little slow with remote database connections.

Recommendations to others considering the product

Although its' system overhead and hard disk space requirements are high, the software is really easy to use and easily connects with remote MS SQL Servers. It's also free to use the client version of this software.

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

I'm able to set up SQL queries easily and visually - a lot like Microsoft Access - without having to learn or memorize a lot of complex SQL code. The main benefit is the ability to create stored procedures, again visually, which allows me to run specific code at any time of the night and allows code from my other applications to connect and run queries all without my intervention.

MS SQL review by Patrick J. R.
Patrick J. R.
Validated Reviewer
Review Source

"Getting Better With Open-Source Support"

What do you like best?

SQL Server provides an easy-to-use enterprise-level SQL environment. The ability to create separate schemas in a particular database sets it apart from the open-source alternative MySQL (although the same feature is available in PostgreSQL, as well). It provides fairly intuitive GUI tools for importing and exporting data, and it is easy to replicate or backup existing databases.

What do you dislike?

For Linux users, it can be a bit tedious at times, since there is currently no Linux support for SQL Server Management Studio, but available drivers work generally work well with open-source alternatives to SSMS.

Recommendations to others considering the product

It can be a bit costly, depending on your use case, but it provides a great deal of functionality that is easier to implement than it often is with open-source alternatives

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

We use SQL Server for most of our structured data needs. It is easy to create databases and attach via Python, and it is generally easy to recover from backup after errors.

MS SQL review by Jeremy M.
Jeremy M.
Validated Reviewer
Verified Current User
Review Source

"Sql Server"

What do you like best?

SQL Server is the go to database server that will work with almost any software and is widely support by Microsoft and a legion of professionals. It is a very mature and established product that shows the refinement of being fine tuned for years. It is easy to use and can be learned quickly.

What do you dislike?

There can be options you are completely unaware of that need to be engaged to operate. While you can be bombarded by the number of options available that you will never need.

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

We use it to host our data used for student education management.

MS SQL review by Brent Q.
Brent Q.
Validated Reviewer
Review Source

"The real deal for business DB - not only option but for most the best."

What do you like best?

Consistent UI and configuration that means multiple generations of product don't require relearning to transition. Huge community and history of people finding the same problem you have encountered so fixes are often easy to find.

What do you dislike?

SQL script is not programing and despite everyone's best efforts to convince me otherwise it is not. Some of the concepts of the product, backup recovery models, backup types, and more are not as intuitive or "consistent" with industry terms.

Recommendations to others considering the product

The MySQL and other open source RDMS systems have a place but for business (SMB & SME) SQL is the best choice with the most resources and information. If you are running websites, applications needed unique operational requirements, or large unstructured data then no SQL is not the best choice of course.

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

Anything needed a structured and relational backend is perfect for SQL. If you need unstructured data or not normalized data sets I understand why other product are used but all of our client are using MS SQL for their ERP, BI, reporting, and core business systems.

MS SQL review by Nate H.
Nate H.
Validated Reviewer
Verified Current User
Review Source

"Proven solution for 5+ years"

What do you like best?

We have been using SQL Server for different projects since about 2010. Even though we are a small business, we still have a big need for an enterprise level DBMS. We have some business management systems and even our website using SQL Server Standard. I do like that SQL server is very easy to manage and there's a lot of tech information out there to fix any issues that come up. The updates are easy and I don't really have to worry much about reliability or speed because if those issues do come up, I get notified immediately if utilization is higher than it's supposed to be.

What do you dislike?

Cost, I just wish that it was a little bit less expensive, especially when you're using multiple servers with the same product for redundancy only. I do wish that we could run SQL server on Linux but I know this is coming sometime in 2017, so that is good news.

Recommendations to others considering the product

If you're on Linux, I think it will be exciting when MS SQL comes as the cost of running Linux as a webserver is so much less than running Windows.

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

We had a lot of issues with speed and reliability when it came to using previous "free" products like MySQL, but it required a lot of maintenance and hands on time to get running right and that's time I didn't have. We had some serious speed issues and moving to Microsoft SQL Server and being able to using a GUI to control everything made life a lot easier. We have been able to now run multiple servers using SQL Server Replication (one server is on site, pushing distribution to the production servers). This has reduced the amount of processing time it takes to serve information to both our customers and our employees, whether it be our website or our in house business management system.

MS SQL review by User in Higher Education
User in Higher Education
Validated Reviewer
Verified Current User
Review Source

"This database management engine works on cloud-based servers as well as local servers"

What do you like best?

It is very fast and stable.

The engine offers the ability to adjust and track performance levels, which can reduce resource use.

You are able to access visualizations on mobile devices.

It works very well with other Microsoft products.

What do you dislike?

Enterprise pricing may be beyond what many organizations can afford.

Even with performance tuning, Microsoft SQL Server can gobble resources.

Many individuals have issues using the SQL Server Integration Services to import files.

Recommendations to others considering the product

Not long after the release of Microsoft SQL Server 2016, Microsoft made it available on Linux as well as Windows-based platforms.

Some of the standout features for the 2016 edition include temporal data support, which makes it possible to track changes made to data over time. The latest version of Microsoft SQL Server also allows for dynamic data masking, which ensures that only authorized individuals will see sensitive data.

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

Ingest large datasets(member, provider, claims, pharmacy data) from healthplans on a monthly basis. Automate that process using SSIS and formatting that into our EPIC central data warehouse.

MS SQL review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"SQL review by developer"

What do you like best?

SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database. This tutorial will provide you with the instruction on the basics of each of these commands as well as allow you to put them to practice using the SQL Interpreter.

What do you dislike?

Many problems with SSIS. It's a nice framework, but there are some big things missing that they haven't bothered changing. Working with xml isn't easy, neither is having reusable components. One of the biggest things that's just ridiculous is that you can't reasonably import a simple csv with SSIS. CSV is the most common form of text export on the planet yet SSIS seems to blog up when it comes across embedded text qualifiers. DTS handled it just fine, but the SSIS folks have seen fit to remove that troublesome feature from the product. I don't know if they're trying to teach us all a lesson about how to form text files properly or what, but we can't always control the feeds we receive. I've recently had to spin up a 2000 instance for the sole purpose of handling an embedded text qualifier because SSIS is too big and enterprisey to deal with it. There are some other things that are wrong with it too but I can't spill them all here. I could write an entire essay on what's wrong with SSIS though.

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

solving very critical problems

MS SQL review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"SQL Serve for Database Management,Data Ware Housing, Business Intelligence, GIS, Reporting"

What do you like best?

It have lot of new features which are growing with passage of time, ETL packages make it best tool for business intelligent, its management studio allow it to use for database management operation, it profile is best for monitoring and optimization, Perfect for data ware housing and for GIS now it is good choice.

Reporting is also very good and easy to manage.

What do you dislike?

Sometime SQL Server service hang and we need to restart it either by restarting system or through configuration manager, I face some issue as well for remote access, but overall its good product. might be some issue because of firewall security , i solved it by opening 1433 port on firewall.

Recommendations to others considering the product

It cover all the areas what are required for database management, it has reporting systems as well which is really good. Management studio is easy to use, monitoring tools are also very helpful, data comparison, schema comparison even lot of other plugins are available in Visual Studio, Integrated server explorer of visual studio allow us to perform several operations on database from there.Its business intelligent is great by using ETL packages , their work flow management through UI, its make a great tool,you can do a lot..

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

Database Management

Database Design (ERD)

Data Ware Housing

Business Intelligence

GIS Spatial Data Management

SQL Server Reporting Services

It have lot of benefits, Surprising that we can run C# code from stored procedure :)

MS SQL review by Hao Q.
Hao Q.
Validated Reviewer
Verified Current User
Review Source

"Great database tool"

What do you like best?

Encryption and compression for backups to saves money on the third-party tools previously. Database performance on SQL 2014 is better than previous version. Integrated, encrypted backup to Azure automatically.

What do you dislike?

SQL Server is big so you need someone to know what they are doing so dedicated IT guy is required. Also the interface of the SQL Server authoring and management tools hasn't been updated not as we expected before.

Recommendations to others considering the product

SQL Server 2014 is a major upgrade that also has a host of invaluable smaller improvements. You can get performance improvements by adding SSDs to your database server.

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

We use SQL to support Finance Department as well as Engineering and Development. No complain so far.

MS SQL review by Dan H.
Dan H.
Validated Reviewer
Review Source

"As a Business Intelligence Consultant, MS SQL is the core of all I do"

What do you like best?

I don't know where to begin. The sheer number of MS SQL developers means we're not investing in a non-supportable solution. The support is top notch. The reliability, scalability, and performance. Actually, I like it *all* the best.

What do you dislike?

I would say the licensing is difficult, but that was changed years ago. I can't say there's anything I dislike about MS SQL.

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

MS SQL is the core of our Data Warehouse, a piece of our Business Intelligence solution which is all Microsoft, and all plays so well together. We moved from numerous on-location installations to a cloud based solution with 14 virtual servers, a Production, Test, and Dev Data Warehouse, as well as Prod, Test, and Dev servers for 56 databases all together. Administration overhead is low, leaving us free to develop.

MS SQL review by Stefania S.
Stefania S.
Validated Reviewer
Review Source

"Good program for data manipulation"

What do you like best?

I extremely like the simplicity with which you can roll out table improvements, take a gander at the information put away inside table, and utilize SQL to do everything. Likewise, SQL profiler has been so useful in explaining many issues. I am working a lot with SQL and I can't stop utilizing it.

What do you dislike?

A few choices have a substantial expectation to absorb information, and sporadically it will bolt up for no clear reason. Else, I have no issues with SQL Server.

Recommendations to others considering the product

The familiar interface is nice to use, and enable all entry levels to begin to deal with a database. I can say that Microsoft SQL instrument is exceptionally straightforward, and import/trade devices extremely basic and valuable.

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

We utilize this to deal with all our corporate databases, it makes that activity substantially less demanding. I can't see another instrument that can give as much data, as fast as it does, with the same number of choices as it has.

MS SQL review by Jason B.
Jason B.
Validated Reviewer
Review Source

"Mastering the Relational Database Elephant in the Room"

What do you like best?

For me, my use of understanding SQL and cracking the efficiency of learning how relational databases are put together and used happened only after I began using SSMS and began to understand and see the data structure dependencies that were exposed to me in my use of SSMS.

What do you dislike?

It's not so much a dislike as just being a dose of reality. A SQL database is an extremely powerful thing, as such there is much to learn about it and how to most effectively manage the database itself. Really diving in and getting a deep understanding of all the tools and features can be a pretty daunting task.

Recommendations to others considering the product

Be prepared, and then do, invest the time it takes to learn the details of what you should be doing to manage a database on a daily, weekly and monthly basis. It will pay off in the end by you understanding more of how things connect and work better when effectively managed.

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

We would frequently convert a businesses custom Access database solution into a more efficient and visual web-enabled solution with a SQL or SQL Express backend for the database component. More effectively separately the data from the interface provided lots of opportunity for feature expansion and improvement across user groups.

MS SQL review by Luca C.
Luca C.
Validated Reviewer
Review Source

"A complete reliable and stable RDBMS"

What do you like best?

The license of Microsoft Sql Server allows you to have (in addition to an excellent engine of Relational DB) a complete package of tools that can develop ETL, reporting and multidimensional OLAP structures. Database skills must be very specific and people who need to work seriously on SQL Server must be passionate about data analysis, data manipulation, constant and careful monitoring of performance and Sql Server really makes available all the tools that can to do this.

What do you dislike?

It requires a knowledge and in-depth technical skills to make complex processes truly performing, especially if we are in very complex infrastructures. Raramenti is faced with problems that someone else has not already addressed and already solved, so (except for very rare cases) it is possible to go back to solving problems by documenting carefully, in cases where there is no documentation you need to contact Microsoft's support.

Recommendations to others considering the product

Always rely on an expert DBA and avoid the cheap and "quick and dirty" solutions that only lead to problems in the future.

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

For what it is my job, as DBAdministrator i manage to the big number of Databases, through SQL Server it is possible to create different data architectures designed ad hoc for different needs (such as applications, websites, intranets, very high frequency transaction processes etc. ). The benefits are many, especially for the solutions developed independently, having personnel who have full knowledge of the data architecture (both in terms of storage and transactional / application) is an added value that is not easy to estimate but that certainly does not price.