Who Uses This Software?

Any company of all sizes, looking for database management software


Average Ratings

776 Reviews

  • 4.5 / 5
    Overall

  • 4 / 5
    Ease of Use

  • 4 / 5
    Customer Service

Product Details

  • Starting Price
    $931.00/one-time/user
  • Free Version
    Yes
  • Deployment
    Installed - Windows
  • Training
    Documentation
    Webinars
    In Person
  • Support
    Online
    24/7 (Live Rep)

Vendor Details

  • Microsoft
  • www.microsoft.com
  • Founded 1975
  • United States

About SQL Server

A relational database management system developed by Microsoft as a database server, designed to store and retrieve different requests. Choose your preferred language and platform and build modern applications creatively. Take advantage of breakthrough performance and availability while turning raw data into meaningful reports that can be delivered to any device or platform.


SQL Server Features

  • Backup and Recovery
  • Data Migration
  • Data Replication
  • Data Security
  • Database Conversion
  • Mobile Access
  • NOSQL
  • Performance Analysis
  • Queries
  • Relational
  • Virtualization
  • Backup
  • Data Migration
  • Database Conversion
  • Monitoring
  • OLAP
  • Performance Analysis
  • Queries
  • Storage Optimization

SQL Server Reviews Recently Reviewed!


SQL Server 2016 - Features Review

Dec 19, 2018
4/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

3 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: In our project we have been migrated from Microsoft SQL Server 2008 to SQL server 2016 directly for all our databases & SSIS packages. There are many features that was available to use for the projects and some of those are:

1. Data was always encrypted, so less vulnerable to SQL injections and useful to take a backup when database is in motion. Prior version (Before SQL server 2016) support only when databases is in Rest.

2. Data/Software Migration is very useful from prior version without any issues or taking any time. It took only set of testing activities and 2 hours of trun around time to get it upgraded.

3. Very simillar like XML TSQL clause created in SQL 2005, in SQL 2016 JSON clause T-SQL has been created for JSON output from querying database objects.

4. In prior versions we have to wait for long running query to capture, however in SQL server 2016 ability to view the execution plan as the query is active on the system.

5. Strecth Database is a new concept that has been created and stored in Azure. However in the background it is shown as single databases for user views.

Cons: Only I know very least number of disadvantages this MS SQL server 2016 is having:

1. Enterprise pricing may be costly as some of the organisation cant afford for the count of data they are having.

2 With the performance tuning, Microsoft SQL Server will be having some gobble resources.

Overall: Overall experience with SQL server 2016 is very nice and excited in my perceptions due to Better support for memory optimzed tables, Built in JSON support, Stretch DB concepts, Query Store and dynamic temp db according to size and presence of CPU in the databases.

Easy to configure, difficult to master

Oct 17, 2018
5/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality

5 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: The most noteworthy features of Microsoft SQL Server are the many tools and wizards that allow even novice users to get started by creating tables and views without extensive knowledge of relational databases. The query wizard can even assist with creating queries with its intuitive IDE. These features lower the intimidating barrier to entry that accompanies other relational database software such as Oracle or MySQL. There is even a free version call Express that allows anyone to dabble in the software before committing to the product.

Aside from the user assisted features, the other appealing aspect of SQL Server is the integration with other Microsoft products that are probably already running in an organization. SQL Server interfaces with Active Directory allowing for easy user management so appropriate levels of database access can be allotted via group membership. This is useful because even something simple like user access management in another RDBMS may present a learning curve for anyone that is not a DBA. With SQL Server a general IT resource could manage user access with an existing knowledge of Active Directory providing more time to focus on core database design.

Cons: SQL Server carries a high cost subscription based licensing cost. The user assistance features provide a great introduction to relational databases, but there is still a significant and continuous learning curve. Databases continue to evolve with industry need. Anyone that interacts significantly with SQL Server during day to day database or application design may need to consider yearly training to keep up with all the changes.

Overall: Easily the most intuitive RDBMS software out of the box.

Capterra loader

I am using SQL server from three years as I am a software developer.

Jul 10, 2018
5/5
Overall

3 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: 1. The capability of extraction and manipulation of data. Using sql server you can fetch or gather data from different file system like excel file csv file etc and then manipulate them according to your need like sort them with name, make the first later of name in capital etc. And then you can print the manipulated data as well.

2. It provides backup for all your stored data into it, by this there is no worry of loosing your data.

3. After making backup obviously they provide the facility to restore those backups.

4. As I mentioned in first point report generation is also its one of the powerful feature.

5. It serves as back end for many programming language. When someone is maintaining his site.

6. Support of different tools like SQL profiler these tools will work as magic when you will be performing complex task.

7. Another tool is tuning adviser that can suggest you different ideas with which you can optimize your sql queries.

8.Gives you ability to run different instance of sql server in one system by this i mean one can have SQL server 2012 and then after that you can also have SQL server 2014 and 2016 parallaly.

9. Debugging tools like debugger.

Cons: There are very few things left about it as it has released its different versions.

1. It is paid

2. It is heavy sometimes it stucks.

3. Takes lot of resources like memory and space.

Overall: I am able to store thousands of users information in a arranged way.

I am able to analyse the data from different sources.

I am able to print report such as pdf file.

I am able to get backup of my data.

I can show the records in any form using SQL queries.

I can fetch details of any number of customer in just a second without going through the bunch.

I can update the data about my customer.

I can delete any unnecessary data.

I can send automatic mails using the sql job.

I can make my data easily accessible by using different index provided by SQL.

I can sort the data in ascending, descending or in alphabetical order.

So bottom line is I am making money by investing some money into SQL server.

Capterra loader

My experience with sql Server has been satisfactory, I have done punctual work.

Jul 07, 2018
4/5
Overall

3 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

3 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: This software has as its first advantage that it is a Microsoft product and has the full support of the company and the stability of a well-tested product. At the basic level, I find it very efficient, the sql responses are fast and there are almost no service interruptions, which is a point in its favor when I use it, I find the Transact-SQL language that is used very powerful, I was able to assign commercial processes of the application in the database that allows multiple applications to use them and it is not necessary to program these functions in each application, the SQL server administration tools are very well thought to be all in a Microsoft environment, the integration is perfect, they are very intuitive to find new functions, they do not require prior knowledge, what is important to train new staff, another thing that I like about this software is the scalability that can start with a small database and grow, in A past project had transactional tables that inserted millions of records daily. I like security, it is possible to assign specific permissions to different users who perform different activities within the same database, this makes me trust the product.

Cons: The least I like is undoubtedly the cost SQL-Server does not have a good cost-benefit ratio, other brands offer better benefits in this regard, another point is the high consumption of RAM, it is necessary to allocate a large amount of resources for this And to guarantee the quality of the service, until now I have not found a hosting provider that offers me a PHP server with Sql-server. This stopped once a new development for a client was disappointing to me. It is difficult to learn in a particular way, the free versions of this software are very limited and the certifications are expensive, which reduces the interest when it is investigated.

Overall: I have worked several times with this software for different reasons I have been able to simplify developments thanks to the Transact-SQL so it has saved me programming time, the services that I have under my responsibility at work are stable, this gives confidence and tranquility for me and for my bosses, I made restorations in record time.

Ridiculously powerful and full of features we do not make use of. We love it, and cannot do without.

Jul 02, 2018
4/5
Overall

2 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: SQL Server is just so incredibly powerful, most users probably do not know how much it can do, or how much it can handle. In our type of organization, we deal with people and animals. We rely on donors and members for funding, we track everything about our animals from health issues, to medications, to physical exercise. Every one of our systems relies on, as the backbone, SQL Server. This software is powerful, versatile, and reliable. With pretty much every department of ours needing some type of database, standardizing to SQL Server was just the best move. It can handle it all. It can track it all. And it can report on it all for us. To date, we use it for: our Accounting software, our donor tracking, our membership tracking, our animal tracking (includes tracking from what zoo or aquarium animals came, their medical history, their exercise history, their diet, their location in our facility, their trainers, their behavioral issues/environmental factors), our vet's digital imaging systems, our guest services scheduling, our security systems (surveillance, door locks), our water quality and hvac sysytems logging and controls, our point of sale system (for admissions and food court and ecommerce), and our facility management software (maintenance and IT requests). This system does indeed handle everything we need it to.

Cons: You need a lot of training to make the most of it. Or it could cost you a lot if you have to pay a developer to help you get the most out of your systems. Luckily a couple of us are really into databases, and we both have a lot of experience with SQL, we can do most things in-house. But still the amount of training we go through to keep current, or to keep learning is probably the biggest "problem" with this software. Most software packages, you can buy, setup, receive a few hours or a few days of training, and you'll be good to go. With SQL, if you intend to use it, to get the most of out it, you will need more extensive training, or to hire people to put in the work. It's not cheap. But it can help you accomplish so much if you put in the time.

Overall: This software practically runs our facility. Without it, we couldn't keep track of our animals or our people (staff, members, donors). To us, this software is well worth the costs involved.

Capterra loader

If you are working from scratch,it is relatively easy to set up a new database server and connectivi

Mar 13, 2018
5/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

3 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: If you are working from scratch, it is relatively easy to set up a new database server and connectivity between clients. Everything is quite simple, given that you have knowledge of the database. The DBMS allows you to easily create several things completely in design (tables, views, etc.), which is a great advantage when you do not know all the syntax.

The integration of other monitoring software such as fog light is very easy without the consumption of time. Great ability to handle all complex query requirements. Suite of advanced functions of sql. Provide all the excellent functionalities, such as Reporting Services, Integration Services, Job Scheduler, Resource Manager, Query Analyzer and Profiler, etc. Each of these modules is perfectly constructed and manages the tasks effectively. Configurable in each level. The user permission is on all objects and other higher levels. Changes can be made for specific privileges at the user level. Window service based on Control to the server to start and stop the service.

I think one of the best things about Microsoft SQL (currently using 2012) is the Developer Network and the useful resources that are available. Thanks to the network of developers, I have been able to learn much more about queries and create more useful and advanced queries over time. Things like Transact-SQL (T-SQL) are useful many times due to the large number of new queries that can be generated after learning T-SQL.Compatibility with most SQL Server administ

Cons: Sometimes, performance when executing some long queries is not what you would expect. Although the power of the CPU is important for this part, but in the company we have state-of-the-art servers in the NAP of the Americas, so it seems a software problem instead of a hardware problem.

Some of the configurations of previous versions (2008 - 2012) are quite clumsy and not very well done - I have had several instances of my corrupt installer and have to re-download. The administrator of the database, sometimes, takes time to load.

Scalability is excellent, but not the best, like other new databases in the market. The memory consumption of the CPU is always more than normal in the production specifically by the sql server. Scope of the improvement in the profile generator for the most used options.

Sometimes, if it is not handled properly with a predefined scheme, the relations and the maintenance of the data become a problem. This happens mainly only when it comes to new users or with people who do not work as part of a larger workforce that manages the system.

Certain add-ons also provide useful features, but if SQL added them, it would save users the problem of finding and installing them. The database is the target of many attacks from your SA account, this should be disabled by default and just after installation, about 30 seconds, the attacks begin, with many requests per second, need to improve the firewall to prevent these attacks, or place the SQL Server inside a VPN

Very reliable, relatively easy-to-use, and reasonably-priced compared to Oracle

Oct 05, 2017
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: As a Systems Administrator, MS SQL Server is one of the easiest DBMS you can use from a management perspective. SQL Server Management Studio is a very robust client, and it allows you to configure everything from either the GUI or SQL scripts. No digging into config files, calling apps from command line, etc. User management in SQL server is easy and straight-forward while being EXTREMELY granular. Plus, it easily connects to Active Directory if you so desire.

The software is very reliable. MySQL can have issues during backups, but not SQL Server. Once you get it set up and configured properly (again, not hard to do), you can leave it running for months without encountering problems.

While SQL Server is by no means cheap, compared to the other enterprise-level DBMS like Oracle, it's quite reasonable. MySQL is free, but it's quite limited when you do a feature-by-feature comparison with SQL Server.

If you're on the fence, install an Express instance (up to 10GB databases with some limitations). You won't be disappointed.

Cons: Like a lot of other Microsoft software, the installer is pretty bloated with prerequisites, components, etc. But that's a fairly small nitpick.

I will also say that RAM management in SQL Server isn't perfect. SQL will, as long as it is regularly used, consume all of the RAM you have allocated it. By default, that setting is 2 petabytes of RAM, so it will slow your system to an absolute crawl, consuming everything it can to the detriment of the OS itself. This means you need to manually allocated a reasonable amount of RAM to SQL knowing full-well that it will likely consume this RAM at all times. That's fine for dedicated database servers, but it's not ideal for people running SQL on laptops.

Aside from that, I have very few complaints about SQL Server.

Overall: Our entire product line (IIS-based web applications) relies on SQL Server. Without it, our business wouldn't function at all.

Capterra loader

Solid relational database ecosystem with useful accessories

Aug 01, 2018
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: I have been using Microsoft SQL Server for about 20 years and have watched the product evolve into a very mature and vibrant offering. SQL Server gives me the flexibility and performance needed for many different relational database solutions ranging from application OLTP databases to enterprise level business intelligence implementations. With my main focus being business intelligence, I have been very impressed with the SQL Server 2016 releases and improvements. It seems the Microsoft is very dedicated to this BI ecosystem and they seem committed to continuity in the products. Some of my favorite things to note are the new SSRS portal interface in 2016, the ColumnStore indexing in Enterprise versions, SSAS tabular models, and the ease of use with Power BI. Overall, I feel extremely confident in this product in terms of its use to solve almost any problem related to data. I find most things very easy to use and due to the wide use of this product, figuring out the more complex issues is not difficult thanks to Google.

Cons: I sometimes don't appreciate the complexities related to transnational logging and the time it takes to roll back large transactions. Purely a performance and optimization issue, but the ambiguities in terms of when a task like this will complete can be frustrating.

Overall: The ability to solve data problems and syndicate actionable information to the right audiences in a timely manner.

Capterra loader

Two words - "Best RDBMS"!

Sep 05, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Microsoft SQL Server is the best RDBMS package I have ever worked on! (Other DBs I have used are - Oracle, Teradata, MySQL, and Redshift)

Just like other Microsoft products; SQL Server is by far the most User-friendly Database Server - best IDE

Lots of wizard features from import, export, backup, query builder etc that anyone can easily learn and do just with few clicks!

Intellisense (like visual studio) to complete code while typing and showing common mistakes before you even execute

Built-in execution plan viewer which is nice enough to start with.

Free Plugins and third-party tools available to make your life even easier like: Poorman SQL Formatter, SentryOne Plan Explorer etc

Integrates very well with other MS products. Full MS BI stack includes SSIS ETL, SSRS BI Tool, SSAS etc.

Cons: No considerable cons. Maybe Microsoft should consider offering built-in features/tools for which developers use third-party tools and plugins. Like builtin execution plan viewer is not as great as SentryOne Plan Explorer.

With so many built-in features one little must have to include is One click code indentation. Until Microsoft can add this feature, we can live with Poorman SQL formatter.

Overall: Highly recommended - The Best RDBMS Package I have worked so far.

Best IDE - let the wizard do basic things with you few clicks so you can focus on actual DB tasks and writing query.

Developers in your team are going to love this Database!

I have been working with this software from last 8 years. I like this software and used its features

May 25, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money

Pros: This software offers a lot of features that are very handy to work with. And frankly it took very less time to understand this software and get used to it. I have used this software for creating stored procedures, functions, views, database schema.

Easy to connect with external database as well. I have heavily used the SQL profiler which again is a very useful feature. SQL profiler let you see the request that SQL receive from a source and it help you debug your code. Generating backup, restoring backup, importing and exporting data tiers all features are so easy to understand. Even I never googled to know how to do it, I just saw the option and start following the instructions and it's done. Its easy to use and all its features are very useful. Even when you didn't saved your file and accidentally your laptop got off,it help recover your files. Easy interface to create database tables even if you do not remember the script syntax.

Cons: There is nothing that I don't like kind of this with this useful software.

Its just if the edit rows option could have been made easy by auto showing the SQL pane to write query while editing the rows. I found it one step extra. It should be like when we select rows. Also running the query on edit rows if could be done via f5 only, then it would be easier for the user.

Capterra loader

Efficient & Affordable RDBMS Product

Sep 29, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Nice GUI & Easy to configure using wizards. Scalable product from midsize to complex solutions. Has come a long way from where it was started back from late 90's to till date. On par with other RDBMS products like Oracle in the market. Microsoft has built nice cluster support especially for redundancy and high availability.. New features such as Dynamic resource allocation, Graphical Query Analyzer, OLAP services are huge win. Additional products to support warehousing & Reporting, Transformation services, Analytics is a huge plus. Lot of performance improvement with 2017 version.Bang for the buck.

Cons: Still there's a concern from consumers perspective that SQL Server is for mid-complex systems. For ERP based systems, IoT use cases users go for No SQL products. Another challenge is for global distributed database solutions there's challenge especially Mirroring of data, synchronization, concurrency it's a huge challenge.

Overall: Great experience using this product back from SQL 2000 days to SQL Server 2017. Have used for both small size applications to big data projects that has data over 100 gb. Partitioning, Indexing, Sprocs, Views are used and taken advantage off. Automatic plan correction, Adaptive Query Processing are improvements in 2017 need to take advantage off. My vote is for this product

Capterra loader

Stable, fast and reliable

Jan 09, 2019
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: As a lot of my development work depends on SQL Server, it is something that I use almost every day. It is extremely stable and reliable and certainly the only database platform that I will ever consider working with. There is still so much I have yet to learn about SQL and so much to explore, but for my current skills and work requirements, it is excellent and always works well. From simple queries to complicated procedures, I always find it a pleasure to work with.

I have worked with other database architectures before, but found that SQL is much quicker, as well as easier to work with.

Cons: My problem is with SQL Management tools and some of their limitations, but not SQL Server itself. One such example would be backing up and restoring of large databases (40GB upwards). While backups are mostly a breeze, restoring becomes extremely challenging and time-consuming as the database grows beyond the 40GB mark. I am not sure if this is because of the limitations on the available management tools, or if it is an actual problem with SQL server, as the large databases I have worked with had no issues with CRUD operations or backups.

Overall: Overall, my experience with SQL Server has been awesome

SQL Server - Keeps Getting Better

Nov 15, 2018
4/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

3 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: SQL Server is an industry standard software. It is highly configurable, capable of multiple setups, and deeply ingrained with the Microsoft Windows platform. Administration is quick, effective, and easier than ever.

Cons: SQL Server 2017 has a weak implementation of Graph databases which will be a much more prevalent database type once big data and IoT really kicks in. In my opinion, Microsoft should be forcing the graph database capabilities forward and trying to match products like NEO4j in performance.

Overall: I have spent more than a decade working with SQL Server and various technologies from a Sys-Admin/Sys-Analyst role in modern day IT organizations. I've had the opportunities to install, maintain, worked on and within, and develop throughout several versions of SQL Server.

I've worked in SaaS and Web App for providers that combined have covered the entire Fortune 50 and more than half of the Fortune 500. I've worked in JavaScript prior to and throughout it's massive growth creating projects in NodeJS using mssql and node-mssql to transform SQL data into useful JSON object sets on the fly since before SQL could even output JSON. I've authored several helpful tools over the years combining SQL Server with bleeding edge platforms to provide tools to previous organizations that were better at the time than even some leading tools performing those functionalities today.

SQL Server in my daily life

Aug 07, 2018
4/5
Overall

5 / 5
Ease of Use

4 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: This is one of the product which I use in my daily life.

1. With this , I check all the data in the tables which show in the front end (display).

2. I use one of the feature i.e. Sql Profiler to get the query, procedure, tables etc which executing while load the display.

3. Get the execution time , CPU time , Reads, Wrtites, etc of the query from profiler with this product.

4. We can make shortcut keys of the query which you use the most like select query, show the columns of particular columns etc.

Cons: Sometimes, I faced the issue while using the WINDOW+R shortcut which toggles the result set. Many times it stucks and then I toggle the result set by dragging it.

For installing it , need compatible software, window version. It took more time to set up . If one of the requirements is not fulfilled then you have to make it compatible and try again the process.

Overall: 70% of my daily office work is depend upon this product. Whenever i need to debug the issue, find the query, procedure executed behind the display then i have to execute on Sql Server. I use to select the data, update, alter , change in any column as per requested by customer. I always check my CPU, Execution time, reads and writes to improve the performance of my product display.

MS SQL Server Perfect Database Management Solution

Apr 05, 2018
4/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Comments: I would definitely recommend that you read the Windows administration book before you start exploring SQL server.

Pros: SQL server is a great database management product. This is a very fast and stable and at the same time cross-platform solution running on both Linux and Windows operating systems, the security of which is implemented at the highest level. It is also gratifying that SQL server works equally well on both physical and virtual servers, both on the ground and in the cloud. Since this product is produced by Microsoft, it integrates well with other products of this company, such as Power BI. This app can provide you with high availability and a wide selection of options available of your choice, though everything will depend on the edition. And most importantly, many features can be tested completely free using Developer Edition.

Cons: Although SQL server is easy to manage through the graphical user interface, but to understand how it works, to fix some problems you need to read a thick book, and even more than one and read ton of documentation. Does not have good monitoring tools out of the box. For some companies will not be a cheap solution.

Capterra loader

SQL Server - Robust application for database storage, analysis and reporting

Dec 09, 2018
4/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Sql server is a powerfull data storage tool and widely used in our organisation. Its enrich with numerous inbuilt features. In sql server backup and restoration task is much easy. Its preety much secure and reliable tool. In sql server there are several security roles to authorize the user, so we use to supply the privilege according to need. Its reporting services are greatly helpfull for us to analyse the data. I can easily monitor the performance / health of the database. Dtabase tuning advisor extremely good in case of performance improvement task as this reveals proper detail of missing items like Index, primary key, stats etc. Easy to review the execution plan of a stored procedure. Data movement from one server to another server is much easy. I can trace the sql statements nicely with the use of trace component.

Cons: Microsoft Sql server setup takes a bit more time but once done then all good.

Overall: We are using Sql server in our organisation to create new databases and maintaining the existing one. Data access is so simple and secure. If there is any sensitive data then we use to encrypt the table columns data. Overall its a great application.

Capterra loader

SQL Server - A RDBMS by Microsoft

Nov 17, 2018
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: SQL Server is the one of the best database management software I have ever worked on. Relational database management system based on relational model. Performance of the SQL Server is also high. It is easy to setup and GUI also provide the user friendly interface to work on it. Integration on SQL Server with non relational data source is also improved compare to the SQL Server 2015. The Best feature in it advance analytics which help you to keep the track of the development. Support and integrity also improve in the SQL Server 2017 with cross-platform as it can now work with Linux as well as Docker container.

Cons: SQL Server is having the large community so the vulnerability and fixing are coming very frequent. Real time intelligence sometime not work as expecting. The SQL profiler should come with more default option and Microsoft should provide the interface where we can develop and design the profiler template.

Overall: Microsoft SQL Server is helping use to find the best programming capacity to match up with the secure and best performance. User interface is also user friendly as it does not need any basic training to under the infrastructure.

Capterra loader

SQL over the time

Oct 23, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: For long time has been the working horse for database oriented applications and corporate data on Microsoft side. Is a highly robust database engine and supports a lot of punishment on production enviroments. Also provides a long standing continuity for older database repositories over from previous versions of the product. The management tools in their several incarnations provided almost all the needed capabilities for developers and database administrators. Also the cross data capabilities and the support for OLAP has been among the stronger points, currently enhanced capabilities for memory oriented data, cloud computing and the newest support for Linux enhance the experience

Cons: I found that a major drawback i found over the time is than usually SQL Server releases are a little behind their competitors in terms of state of the art capabilities and features.

Overall: I have used SQL Server as the weapon of choice for business development and despite some minor product bugs over time, always has been a highly manageable and capable especially for long-standing data, very friendly even with developers who are not familiar with Microsoft technologies

A great database and a data management solution

Nov 21, 2016
4/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

3 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: You can do practically anything with this database because it, has complete solutions integrated into it like SSIS, SSRS, Monitoring, Task Schedule (SQL Agent), alerts, other database connectors, etc.

And currently Microsoft is working to finish his database 2016 version to running on Linux.

Cons: Perhaps the only (at the moment) problem, are the locks management in the database when the update/delete operations are very big. I miss the possibility to auto-partition (internal scripts) of these operations, managed by the database engine.

Overall: I have been working with MS SQL Server from the SQL 2000 version. Currently I work with SQL 2016 (and I am testing SQL 2016 in Linux). In all of these years, I have been using a different solution of the database (clustering, data mirroring, CDC, log shipping, AlwaysOn, etc..), always with a great satisfaction.

A great number of people think that MS SQL Server is a database for small data volumes but, these people are wrong. This database, can manage a big data volume and his management could be very easy if you follow the MS recommendations.

On the other hand, you have a great knowledge base in Microsoft and in a great number of tech portals and blogs. You can find in the Internet, (almost) any T-SQL code to implement with only search it.

Stable, high performance and extremely capable enterprise database software

Jan 28, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Microsoft Ecosystem

SQL management studio

Query Analyser

DB Tuning / Optimization wizard

Estimated Query Results

Ease to integrate with any front end technology

High Performance

High Scalability

Scheduled jobs

Ease of Integration via Visual Studio

Cons: Enterprise License costs

Slight learning curve for advanced features like SSIS, data warehousing.

Performance Tuning of large database would take years of core specialized training and experience

No supporting software like RedGate to performance schema / data comparisons

Overall: This is a very vast and complex software and one has to spend years using this software to summarize its very many benefits.

Having worked in mostly Microsoft development shops for the past 14 years, I have used SQL server in almost every enterprise project that I have worked on.

Ease of use, simplicity to alter schemas, easy TSQL syntax, ability to easily create and manage indexes/stats, reporting services, ease of access control, security via encryption, performance tuning capabilities, always on features, backup and restore capabilities with advanced backup and restore options, cloud capabilities, ease of integration with various front end software are just some of the various benefits of this mammoth software.

It really is a complete DBMS, and easy to use, with very good support and documentation. I recommend

May 11, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money

Pros: That is a relational DBMS that allows programming in hybrid environments, either locally or in the Microsoft cloud. It allows you to transfer databases in a very simple and intuitive way between your local environment and the cloud. It is one of the most secure databases in the world, because it allows transparent data encryption, audits, extensible key management and encrypted backups to protect data in critical workloads, and its storage system allows a query performance much higher than usual. All the processes of analysis, consultation, cleaning, data formatting and access are carried out at a speed that surprises you. It allows to carry out backups and recoveries: they can be configured in advance, which makes their execution carried out in a simple way. It provides extreme compression of tables and indexes and High availability: the downtime caused by updates and revisions disappears or is minimized, in order to guarantee an almost permanent availability. These availability and maintenance status of the databases can be checked easily with a very visual panel. It provides a Task Scheduler which allows you to plan tasks in advance, and they will be executed automatically. It has good documentation. And management of data types and users, which strengthens

Cons: Really as such, there is something that I do not like, in which case what I like the least is the price

"Microsoft SQL server - WHY"

Oct 17, 2016
5/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Data accessing via Excel or Access is very easy.

Reporting services are a really good example to present and analyze the data to management.

We do have an analytics team which does a lot of data modeling and also uses lots of integration services.

Cons: Definitely room for improvement in SQL server reporting services.

Missing the functionality to purge/archive/delete the reports from the server. We have to do it one at a time.

Overall: I prefer SQL Server for SharePoint applications. There are SSIS data sources, destinations that can be used to sync data between SharePoint lists and SQL Server tables. SQL Server is a good choice if you are looking for a solution with quicker time to market. It is simple to use and administer. However, I would prefer something else (like Oracle) for enterprise solutions.

Recommendations to other buyers: I think for any application it really works well. It has lots of features which could help with business requirements. It can easily import the data from different data sources and also can export the data in the required format. It is really good in OLTP transactions too. We will have to use it well to make it more efficient. For ex: if you don't have proper indexing, it might take time to retrieve the data you wanted or you might run into time out situations.

Great data base! Recommended for bussiness or personal use.

Jul 13, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: SQL Server is a data base that is increasing your functionality, features; has a great performance on Windows or Linux, is stable, secure. You can use it for big projects like SAP without any trouble. Highly recommended, you can do a test with the free version of SQL Developer - you will get all the features, but it is just for devoloping, not for production use. You can use the Express edition for free but with the limitation that the dabase file size is just of 10GB.

For example in a company that I give IT services they had SQL Server 2005 with Windows Server 2003 r2 for many years, they moved to SQL Server Standard 2014 with Windows Server 2012 in 2016 because they need to apply an update over a software. So, it is very stable and secure. We didn't have any issue or problem during all the years (and still).

Cons: I don't have any negative comment about SQL Server, because from my point of view it is a very good and stable data base. May the only one could be the price.

Overall: Easy to use, secure, stable, good performance.

Solid Data Consolidation Platform

Sep 10, 2018
5/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: SQL Server continues to get better all the time. I use it for helping SMBs consolidate their data for BI/analytics for both on-premise and Azure. The product is solid and never have a problem (especially Azure). If you have used any of the previous versions. Due to its long history and wide use, resources are always available to support the product. The security continues to get better and integrates well into Power BI. Over the last couple of years, Microsoft has also added additional connector services which is great for many IT shops.

Cons: If Microsoft wants to stay relevant in the SMB world they need to make it more automated, intuitive and dummy proof for individuals in Marketing and other disciplines. The product requires some serious IT support which is not always available. I have never been happy with their Training and certification programs (basically they suck). Microsoft dictates how classes are to be run and lost connection with the evolving world.

Overall: If you are an IT resource, the experience is great.

Capterra loader

So far I enjoy using SQL Server to query databases that our customer have at my job

Apr 17, 2018
4/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: I like that you can upload a database, then immediately start querying the data or altering if needed. There is no waiting afterwards. Our customer at my job have databases that we don't really query on to reduce usage or traffic. So we make backups and upload on our person computers that way we can hit it hard and not have to worry about the customer seeing any issues or if we accidentally mess up, it doesn't shut them down instantly. Once you get used to using select statements, joins, and looking at store procedures, SQL is pretty easy to use.

Cons: My only con is that the learning curve is difficult but I understand why. It would be ridiculous to make it easy and then hackers all over would destroy data or steal it even more. The actual con I have is in the latest release of SQL Server. It is a bit glitchy when it comes to opening the application and waiting for it to fully load after signin. This could be the hardware I am using it on but at times it is the only thing running and still is slow.

Capterra loader

SQL Server is a powerful, fast and feature-rich enterprise database platform

Jun 05, 2018
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: SQL Server is constantly being improved for features, performance, reporting and stability. The SQL Server community is great and Microsoft do a good job at providing information, training and resources to support it. SQL Server is all the tools and features for modern software development against a database platform. The query tuning/profiling continues to improve, as does the database engine itself which allows software developers to gain valuable insight into how the engine works. SQL Server features and components all work together under one management solution which is great.

Cons: SQL Server dependencies can sometimes be painful to deploy and manage correctly. The installer continues to improve, but would be great to have more smarts in this part of the solution. Would be great if SSMS had better support for visualizing which database you're currently working on, when using in a multi-database environment.

Overall: SQL Server is the back-bone of all of our software development and reporting.

DBA's review on SQL Server (v7/2000-2017)

Nov 21, 2018
4/5
Overall

3 / 5
Ease of Use

5 / 5
Features & Functionality

3 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Since the redesign of the database engine in 2005, each new version is enriched with more and more feaures and functionallity, also pushing down more and more Enterprise features to lower editions.

Microsoft took another road a couple of years ago and are now fully embracing other platforms and eco-systems that makes the choice for SQL Server easier (or harder ... :-)).

With R, Polybase, Linux and dockers, SQL Server is definitely on their way to the future.

Cons: It takes some time to figure out which licens model you have to choose.

Even with the assisitence of third parties you hear different suggestions that makes it even harder.

But with some effort and puzzling we were able to come up with a structure that is robust an least expensive, you should closely watch the type of VM's you put on the same host in a VM-cluster and think about the way you (over)provision that host.

The massive amount of new features are hard to keep up with though ...

Overall: Keeps getting better and better!

Enterprise-grade SQL that is polished and with high adoption for the Microsoft eco system

Feb 22, 2018
4/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

3 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: - Support: Well-documented, and is a cornerstone of Microsoft enterprise software, and is well-designed very robust.

- Integration: If you are standing up Microsoft applications that require MS SQL as it's back-end, the process is flexible regarding if you want the SQL server hosted on the same box or on a remote server for design and resilience. The process is generally very well documented and the requirements for the installation are highlighted and straightforward.

- Clustering: It can be complicated to initially setup, but it is worth it. Clustering your SQL servers reduced single points of failure, leveraged our hardware resources more efficiently while also making maintenance and patching more flexible.

Cons: - Pricing confusion for physical vs virtual licensing: Pricing is a moving target with Microsoft, so pay very close attention to your infrastructure, how you use SQL, and work with your reseller to determine the most cost-effective way to move forward.

-Split-permissions: Active Directory is the flagship of Microsoft enterprise software, and it grooms you to understand shared permissions that are integrated around Active Directory, and everything joined to it. MS SQL is not setup this way, they are split out, so to understand the permissions model of MS SQL, you have to invest in the MS SQL eco system.

Capterra loader

The BEST RDBMS for your BUSINESS

Oct 25, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: I have used other open source RDBMS software, but nothing comes close to the ROBUSTNESS and SCALABILITY of Microsoft's SQL Servers. I have been using them in the office for almost ALL of our mission critical applications. What makes it more USEFUL is that it is closely INTEGRATED to the entire Microsoft Developer ecosystem. No matter how BIG the database is, the performance is CONSISTENT but dependent on your HARDWARE, specially the HARD DISK.

Cons: Probably the least liked feature of MSSQL is it is heavily dependent on the Hard disk. Most of the Server hard disks are still MECHANICAL and recently SSDs have been the preferred choice for storage in servers. I just read they have in memory OLTP in Azure which I have yet to explore.

Overall: Overall, the experience with MSSQL over the years when it was version 2000 all the way to its latest version (2016?), it was an AWESOME and continuously LEARNING experience. I would recommend it for its reasonable PRICING and solid RELIABILITY for mission critical application systems.

Capterra loader

My views on Microsoft Sql server

Nov 14, 2018
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: SQL server support numerous data type on a database table column name.

SQL Sever's profiler is a great tool to find out running query on sql instance.

SSMS and SSIS reporting services functionality are easy to generate the data report.

Database tuning is great feature to improve the performance of db as this provides good suggestion during this activity.

Its linked server functionality is great to retrieve data from remote server.

Cons: Sql server constrained to a single cpu. There is a limit on stored procedure's parameter but this is still sufficient number 2100.

Overall: In our organization,, we are using widely this tool to create new database objects like table, stored procedure, function in our existing application.

SQL server's profiler, database tuning functionality a reporting services etc. helped a lot in daily development work.

By creating master key in database used decrypt and encrypt feature on required tables and maintained confidentiality.

Greatly helped in performance monitoring.

I'll say its a great database storage engine.

Microsoft Sql Server

Aug 06, 2018
5/5
Overall

5 / 5
Ease of Use

4 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: it has a great and enriched user friendly UI that makes most of the task to be done easily like backup ,restoration, script out the jobs , procedure ,tables, views etc .we can easily track out which sql query is running at backend through the inbuilt Profiler Tool , through profiler we can also manage the performance and query optimizer .we can track the dependencies of the tables , procedure easily through dependency option .we can also automated some sql query with the help of Job setup . moreover , a separate widow service sql job agent is provided to start/stop jobs.it has different level of security setup and it is very easy to maintain

Cons: it takes most of the memory and CPU utilisation when in use.

we manually need to enable the schedule of the jobs when we create the job from the script despite job is enabled

Overall: as per my usage , i can say that it provide unfriendly UI which helps a lot and make work easier to maintain databases

Microsoft SQL Server - An industry standard database system for a variety of applications

Apr 10, 2018
5/5
Overall

3 / 5
Ease of Use

5 / 5
Features & Functionality

3 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Microsoft's SQL Server database engine is a standard for SQL applications. Users can write their own apps around it, but it is often used to support other off the shelf software where a database is required. It is also the backbone of Microsoft's SharePoint and Reporting Services, yet is used by countless other apps such is its appeal. Queries against data can be made directly inside the database app itself, as well as with countless client apps including many free ones. Permissions access to objects can be local or from Active Directory. Development apps such as Microsoft's Visual Studio can work directly with to create rich database driven applications.

Cons: There can be quite a learning curve with SQL Server, but this is due to its sheer complexity and security. It is well worth it thouh once these obstacles are overcome.

Overall: It supports other apps such as Backup Exec, SharePoint, and our own in-house database driven CRM.

Enterprise software, probably the go to if the company commits to it

Nov 14, 2018
4/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Widely used, google search will almost always come up with high quality results

Stable, trusted

Cons: Infrastructure required, installing tools is a little clunky at times

lots of overhead

Overall: Like many who use SQL Server, it's because it's 'what the company uses', and I don't have a lot of experience with other enterprise level databases, but with the support and attention it gets, it's stable and don't have to worry about it not being able to handle anything we throw at it.

With that said, it does take attention to make sure things are written so it's parsers can interpret things correctly. Very small differences in filters and joins mean the difference between using an index and ignoring it, which can be the difference in milliseconds and minutes for some queries.

Have used MySQL at similar levels of use and that was capable too, but was seen as less 'enterprise' worthy, and maybe missing some features of MSSQL which must have been worth the additional investment from higher up. I would say the toolsets are significantly better, as well as demanding more support, so I've basically benefitted from the upgrade.

Capterra loader

The giant of RDBMS.

Feb 02, 2018
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money

Pros: I am a DBA specialized in using the microsoft platform for several years, even having seen several DBs I can confirm that in this case Microsft has created a complete and really well done product. I believe it is absolutely one of the best RDBMS on the market, since the latest versions have also introduced in-memory technologies is truly a complete product. Obviously we are talking about a "business-enterprise" product, but if you want to play a little with express / developer versions you can also start with simpler and faster implementations.

Cons: The licensing costs are high especially if we are talking about Enterprise versions, it must be said that direct competitors have much higher prices and do not provide complete packages like that of Microsoft that includes everything in the license cost, including the complete package of tools suitable for BI (ETL, REPORTING, OLAP ...).

Database Handler

Dec 05, 2018
5/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: This software has many features through which you can store your information in the form of table and can also access it as per required. I'm using it in my office, to store energy sector data. You can create procedures, functions for complex code. Every dynamic software wants to store their data and SQL Server is the answer. Creation of tables and modification is very easy in this software. You can also create backup of database dumps and can restore it on multiple machines. You can also create jobs for automatically executing of codes.

Cons: You need to be very careful while creating tables, procedures or functions, otherwise your database will be very slow while accessing the data. To avoid this situation, you need to create Indexes.

Overall: My overall experience with this software is very good. I'm using it daily to store and access production data with the help of procedures and functions.

A popular BI platform that makes the implementation of integrated BI services easy.

Feb 06, 2018
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

3 / 5
Customer Support
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Comments: Overall Microsoft SQL Server BI would have a solution for most requirements of a typical BI solution. The look & feel, as well as how the tool interacts with its users can be improved.

Pros: Microsoft SQL Server BI offers a full set of tools and functionalities for different phases of a BI solution. Since it is a very popular and widely being used, there are a lot of resources available. Moreover, Microsoft provides tools and services that serves both the upper stream and lower stream of BI services, making the adoption of Microsoft SQL Server BI seamless on existing Microsoft infrastructures.

Cons: A lot of tools are not smart enough and requires intense manual work. For example, SSMS can't recognize and auto-pop newly-created tables/views without restarting; SSIS is not able to refresh the metadata on its own when there is underlying table changes; SSRS offers very limited format control for Excel/PDF export.

Incredibly stable and robust database platform

Sep 06, 2018
5/5
Overall

3 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: SQL Server is on of the top tier platforms for Database management in the industry. You can go as shallow or as deep as you want with it and still get the benefits you need. Another great thing about SQL Server is that there are so many tools that integrate with it. I can work in Visual Studio and use LINQ to query anything in our database which translates straight to SQL. Or if I need to generate a report quickly I can just directly query the Database through SQL in SQL Server Management Studio.

All around great tools, great management, and great support/integrations.

Cons: SQL Server can be a bit pricey if you aren't understanding your database needs correctly. You can certainly get in the sweet spot pricing wise if you know what you need but sometimes that can be a daunting task.

Overall: We've had a great experience so far, it has been very stable for us.

Easy to use

Jul 26, 2017
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money

Pros: Whether they advertise it a lot or not, Microsoft invests heavily in SQL Server's core database engine in every new version. Back in the old days, a nine-table join was a recipe for disaster; now it's no big deal. The same holds true for SQL Server 2012: You can expect better overall performance when compared side-by-side to older versions, and 'better performance' is always a reason to consider an upgrade.

Cons: Newest versions of SQL Server brings some significant changes, and change isn't always best. For example, your IT team will have to re-think how they engineer database availability given the completely-changed high availability features in SQL Server. Most other administrative tasks will remain significantly unchanged, but if availability is an important concern for your organization, make sure you understand what you're getting into with this new version.

For anyone who maintains small and large servers and staff!!

Oct 17, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: The list can go on and on here. I love this because as a photographer who owns a studio, I have other photographers who work under me and I need to keep an eye on what goes on on my networks during and after office hours. There is a lot of private information regarding my clients, and with a lot of sensitive info, there needs to be a way to manage it as well as monitor those who have access. Beautiful software capable of maintaining your servers bringing you peace of mind. Fully customizable to your business needs and has a ton of security features you can apply to your servers.

Cons: It can be a bit much to learn, but there are so many resources that MS offers and even videos on YouTube.

Overall: So far so good! Depending on your needs will depend on price tag. All in all, I cannot complain about this software and recommend to any business.

Capterra loader

sql server

Dec 31, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: for database creation and management, sql server, is the most secure and robust tool to handle a large amount of data, its interface is simple but it allows quick visualization of all the options of the tools, its protocol of security is the more stable for database, and its server client connection with the aeducada and correct configuration, is approves of errors.

Cons: some versions as sql server 2008, began to have no support or upgrade, so many companies will have to migrate large databases to the most current versions, although the migration is 100% compatible, but this implies internal processes that would affect the operation of the company, it is vital to be updated, unfortunately many companies have the concept that if it works well, why change or improve it.

Overall: Safe, robust, the best to manage database for any company.

Capterra loader

Microsoft SQL Server is very easy and effective RDBMS System.

Aug 22, 2018
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

3 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Microsoft SQL Server provides every feature required for relational database management system. It is mostly used for data storage of Microsoft technologies like ASP.Net but it can also be used by other technologies. It is very secure database system. It is very good in performance as it has capabilities to handle big tables and databases. Data import and export is very easy and user friendly. It is very easy to create and maintain tables, stored procedures, functions, views, jobs etc.

Cons: It requires high speed system and high internal memory to work properly. Its price is bit high, also need a Microsoft server to host SQL Server. Performence is much dependent on user's logic and queries, bad logic and query can degrade its performance.

Overall: It provides me easy to use, secure, easily mantainable, high performance database system.

Best relational database with multiple features

Dec 29, 2018
5/5
Overall

5 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Ms sql server is a best relational database with multiple tools and features. It is easy to use and education version is fully free. With ms sql server development and troubleshooting are not much sophisticated. Some software (other than sql server) in market requires lengthy command line configuration. Consequently ms sql server is easy to install. Therefore beginner level user can use the software conveniently. It offers integration with the .Net framework and provides full support to triggers. Since it is not an open source, database server can be less effected by attacks. The recovery option is available when even data is loses by power lose or other factors.

Cons: It takes much time when opening the software. Installation of sql server also takes long time.Eventhough ms sql server educational edition is free, it's license version is costy. Moreover it is designed only

for windows plateform. It cannot use to develop web base system on unix platefrom.

Overall: Overall ms sql server's user friendly GUI and tools are makes ease of use. As a beginner level programmer it is useful to learnt first due to it's human readable sql queries. My experience with ms sql sever is awesome.

SQL Server great database engine

Sep 19, 2018
5/5
Overall

5 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: SQL sever is easy to use and designing the relational database. It is good for handling large amount of data easily. The various features and compatible to other devices really makes your work done. Some of key features is like indexing, T-SQL really great to implement which makes your data to access easily and fast way. It also features of ETL tool which is really great options for the data analysis and data document.

Cons: I don't find such but yes installing the software really takes time which need to reduce. Some time i find running large amount of data it takes time to complete as performance need to improve.

Overall: Working with SQL is really great experience which solves lots of data handling problems and provides you great way to handle them and access them. With various security features and handling the design is key point for SQL server.

Intuitive tabular database tool that integrates across Microsoft's huge catelogue as well as countless other products

Nov 07, 2017
4/5
Overall

3 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Comments: Despite the above critique, the troubleshooting and development issues become less and less frequent and all of the positives mentioned above become more noticeable than any cons. Also, although the software can be pricey, it is unnecessary to have a large number of licenses for most businesses as long as a handful of professionals have the skills to role it out and manage it, you can get away with limiting the costs.

Pros: For the 90% of businesses that use Excel at the very least, SQL offers seemless integration for compliling, staging, and connecting multiple data sources in an easily accessible format with little or (in the case of dash boarding and automated refreshes) no training.

Cons: Building a database from scratch is tedious, and sql server is granular enough that minor mistakes can cause big problems and can be hard to fix once an instance has 100s of variables, multiple sources, or connections.

Run a true enterprise database management system reliably

Mar 19, 2018
5/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

3 / 5
Customer Support

3 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: We run about 20 SQL servers across the company reliably. We run various editions from Standard to Enterprise. The bulk of the servers host student information systems as well as point of sale systems. This means that data transactions are consistent throughout the day. We're also able to extract and mine data using SSMS for our data warehouse and ad hoc reporting needs. This has allowed our company to increase its business and are looking to expand in the very near future.

Overall: A solid database engine that will run without issues as long as you've got the hardware for it.

The product is great. However, the cost is substantial. The licensing is a bit of a mess depending on what edition you run and varies across yearly editions. One version might be licensed by server while others are licensed by core. We'd like to see all versions licensed in a more standard fashion.

Best RDBMS product in the market

Dec 15, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: I'd been using SQL server for more than 5 years now, I'm still amaze on how reliable is, its very stable and strong to manage large amounts of data. In my organization we manage tables with over millions of rows and the server responds smoothly to all the transactions executed by our applications. it handles multiple instances of databases and serves many users across the organization. securing the data and baking up on regular basis makes SQL server a powerful tool to manage our data and transform it into information when needed.

Cons: implementation may be critical, but if done properly wont give you headaches, you may need to hire consultants or train your IT team in the right way to start the journey with the tool, but one on boarded is a smooth ride

Overall: great, reliable and secure.

Capterra loader

A quite well DBMS

Dec 18, 2018
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: Sql express is fine, very nice for beginners (students or business that need a little database with a couple of tables), and the best, it is FREE.

There is also a couple of official tools, (even installation package whit those) like sql management studio that prepare a visual interface and nice user experience. (if you don't like the console and that geek things).

Azure has its own "ready to use" sql server, if you don't like, you can also install sql server on any server and make the port configuration manually.

Cons: Perhaps Microsoft need to make a new distribution more able to be manage by third party.

The regular tools connect the sql server data base whit other tools, like, .net 4.5 was really easy, but sometimes when some technologies change, like .net core, some functions stuck for a while after Microsoft release updates.

At the end of the day nothing too hard to manage, or problems that maybe you could not see on others DBMS.

Overall: It is a great tool for manage the information, really useful for a very little business( sql express comes to my mind) as for a international company (think to use the sql server of azure), for long time one of the "big guys" on this field.

Capterra loader

I used it for university projects

May 28, 2018
4/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality

3 / 5
Customer Support

1 / 5
Value for Money
Likelihood to Recommend: 6.0/10 Not
Likely
Extremely
Likely

Pros:

*It is a database management system.

*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.

*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.

Cons:

*It uses a lot of RAM memory for installations and software use.

* It can not be used as practices because many things are prohibited, it has restrictions in the particular.

* The relationship, quality and price is very low compared to oracle.

* It has many blockages at the page level, a fixed page size and too small, a terrible implementation of variable data types.

Overall:

Although I use it in university projects, it worked very well for the requirements I had

Capterra loader

I almost use it daily and its very helpful in organizational analytics and business intelligence.

Jul 28, 2018
4/5
Overall

5 / 5
Ease of Use

4 / 5
Features & Functionality

3 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: It's a versatile and functional tool with lots of features, it is robust also and can be easily integrated to multiple platforms and other systems.

The connection is very simple and user friendly.It has a very good interface so that we can manage multiple Database,Sps,Functions and the UI has predefined query and auto generated queries for almost everything.We also get various options to integrated our data from various other sources and we can export our data in many forms and formats as per our requirement.

Cons: It is expensive for the small organizations.The Debugging experience is not that good and should really improve that.It is also very heavy software and consumes lot of RAM which is a major concern.

It is SQL specific,User should have the SQL knowledge.

Good but nothing special

Mar 31, 2018
5/5
Overall

3 / 5
Ease of Use

3 / 5
Features & Functionality

3 / 5
Customer Support

3 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: SQL server has provided us a great security and integrity improvement over our previous software database. We were desperated with DBase constant corruptions. It's been 6 years since we adopted SQL server and never ever had an issue with data. Nothing.

Performance is amazing even with huge databases. It's worth the price.

Cons: Not easy to manage.

Not multiplatform. We bought SQL server because we were "forced" to work in Microsoft ecosystem, and that forced us to pay for Windows licenses, backup software, a more expensive server... We did not like that. We use other database systems like MySQL server or Maria DB with the same good results (and a little more freedom).

Overall: I had bad times with data integrity and corruptions using other database systems. Never had that issue since we started using SQL server.