Average Ratings

240 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
  • Support
    Online
    24/7 (Live Rep)

Vendor Details

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

About SQL Server

Database and analysis offering for rapidly delivering the next generation of scalable e-commerce & line-of-business solutions.


SQL Server Features

  • Ad hoc Analysis
  • Ad hoc Query
  • Ad Hoc Reports
  • Benchmarking
  • Budgeting & Forecasting
  • Dashboard
  • Data Analysis
  • Data Visualization
  • Key Performance Indicators
  • OLAP
  • Performance Metrics
  • Predictive Analytics
  • Profitability Analysis
  • Strategic Planning
  • Trend / Problem Indicators
  • Backup
  • Creation / Development
  • Data Migration
  • Data Replication
  • Data Search
  • Database Conversion
  • Monitoring
  • Performance Analysis
  • Queries
  • Relational Interface
  • Virtualization
  • Backup
  • Data Migration
  • Database Conversion
  • Monitoring
  • OLAP
  • Performance Analysis
  • Queries
  • Storage Optimization

SQL Server Reviews Recently Reviewed!


SQL server is used at my firm for data preparation and filtering

Apr 25, 2018
4/5
Overall
4 / 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: The user interface is very easy to understand and use. Large data-sets are handled quickly. Outputs from processing can be viewed easily.

Cons: Help and documentation is not user-friendly and one may need to use search engines for help. Also, the software setup may be time-consuming for large organizations.

Overall: Data processing

It offers a wide variety of tools for managing databases.

Apr 24, 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: Once you have mastered it, it is easy to create, modify and manipulate with several existing databases, I have been using SQL server since I started working and the truth to me was very easy and fast learning.

Cons: I had many problems installing the software, it takes up a lot of space on the disk and when I achieved the installation I noticed that my computer gets a little slow.

Microsoft SQL Server

Apr 24, 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: Microsoft SQL Server is our database back-end option to use in our systems, from 2005 version to 2016 version. Benefits: Runs on Linux, Job schedule, Task schedule, Email notification, Distribution transaction, good support.

Cons: It does not have a source control, so you have to use a third-party source control like RedGate or APEX.

Capterra-loader

Highly secured software I have used yet...!!!

Apr 23, 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

Pros: The simplicity in table handling is just admirable.
The table joints are really easy and can include number of tables.
Handles big data very easily.
Much more functionalities provided. And giving the best version each and every time they
release new version.

Cons: It takes to too much time load completely.
consumes more ram.
The initial setup is little hard
And when I start a project in perticular Version, it's just gets locked into that version only,
Coz version upgradation takes many dependencies to resolve.
Also after some times, it becomes important to upgrade from old version to new one because of security concerns.

Very Satisified

Apr 21, 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: 8.0/10 Not
Likely
Extremely
Likely

Pros: It is a very easy server to learn how to use. I also like how easy it is to run queries inside of C# code. Very useful.

Cons: Deleting duplicate rows can be a real pain. I usually have to end up copying entire table in excel to delete row easily.

A good server service.

Apr 20, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money

Pros: The ability to connect with workbench helps in better visualizing tables and data, and managing is easier.

Cons: The problem is that is if you have explicitly installed server on your device then you can not use the server which comes inbuilt in some apps due to port issue so it takes time to solve the issue.

Capterra-loader

I've been using MS SQL for the last 11 years and loved how it helped me get the best of RDBMS.

Apr 19, 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: MS SQL is very reliable, efficient and secure. I've been using SQL Profiler for the last 8 years and it made my life easier when searching for specific logs or activities that have taken place on a specific time and date. MS SQL has high security level. With the right settings and configuration, anyone's database will be fully secured.

Cons: I have nothing negative to say about MS SQL. It is simply the best RDBMS I have ever worked on. MS SQL is awesome!

Overall: I have learned everything I know now on RDBMS from MS SQL. I will not trade MS SQL for anything less. It's the best!

Great functionality, speed and overall great RDMS

Apr 19, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
1 / 5
Customer Support
3 / 5
Value for Money

Pros: The functions for manipulating data are great. The speed is ultra fast. If you need a RDMS that is robust and fast SQL Server is the way to go.

Cons: The worst thing I hate about sql server is you need the Enterprise edition for html5 reporting. They should give that in standard.

Excellent DB Platform.

Apr 19, 2018
4/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: It is very easy to perform queries with Microsoft SQL Server because of the simplicity of a high level programming language. SQL database can hold a large amount of data and SQL server can efficiently structure the query. C# (or other languages like Java) applications can increase efficiency, visibility, and profitability very quickly. Even poorly constructed schema can be arranged in views to allow developers to harness SQL's performance benefits. The best part of it is how it integrates seamlessly with Windows Server products and makes configuration and updating so easy

Cons: Difficult to setup permissions and roles. Uses a lot of RAM memory for it's installations and software.

Sql is an excellent database engine, surpasses all my expectations.

Apr 18, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: In general it is an excellent database engine from small to large companies.

Pros: It is a very versatile and functional tool, it is very robust, it is easily integrated to multiple platforms and other systems, the connection is very simple and you find many forums on the internet that help you make the most of it.

Cons: Multiple types of licenses, which in some cases becomes expensive when you must buy to comply with CALS depending on the number of users.

Excellent full of features

Apr 18, 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: A database must for all size businesses. Very easy to configure and the support is amazing from Microsoft.

Cons: Not really any cons other than teaching non tech users takes time and patience which is sometimes difficult in todays market.

Overall: Awesome database management

Simple and Powerful

Apr 18, 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

Comments: Highly recommended

Pros: Easy to maintain, good reporting, good performance, third party integrations (source control, TFS). Simply one of the best database systems.

Cons: It is not the cheapest on the market, but it is one of the best and most powerful data base systems. Definitely worth it.

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.

SQL Server is a good software for database storage.

Apr 16, 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: 8.0/10 Not
Likely
Extremely
Likely

Pros: I have been using SQL Server since I get starting to work with databases and with the need to design a database model that fit our needs.

Cons: SQL Server should get more features from Oracle or try to improve them to become more efficient than a good Orable DB is better.

Overall: The #2 database model constructor.

A great database server!

Apr 16, 2018
5/5
Overall
4 / 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: It's fairly easy to use once you get the hang of it, and it makes storing and retrieving data a breeze!

Cons: At first it seemed a little convoluted, but that can be chalked up to my unfamiliarity with sql servers before using this one.

Capterra-loader

Easy to use, interactive tool

Apr 15, 2018
4/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: Microsoft SQL Server is a great platform to begin with fundamentals of data storage and analysis. The queries are easy to run and it is pretty convenient to make new servers. The best thing is that queries can be run even if the database is not connected to the server.

Cons: I faced some problems while installing the software. Also it occupies a great amount of space in memory.

Overall: I designed a tourism database and integrated it with my website.

A great SQL server solution with a great deal of features and support, but expensive

Apr 13, 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: A very stable environment with clustering, replication, and everything you would expect from an enterprise level product. Includes a huge number of tools for working with data including import, export, SSIS, SSMS, TSQL and more. You can build your own custom modules that will integrate directly into the server. Recent versions allow for installation on Linux. There are user groups.

Cons: Not the most expensive, but still expensive, especially with free alternatives. Some of the Microsoft nomenclature around TSQL can be annoying, such as square brackets. Some features seem unnecessary and ponderous, like XML.

Capterra-loader

If we want a robust database administrator, we need SQL Server.

Apr 12, 2018
5/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: SQL Server, as the administrator of the database, provides all the necessary features to carry out a large project. I worked on interesting projects with this software, what stands out most is security, it provides an excellent security mechanism and data backup.

Cons: The defects that are clearly found are the lack of versatility when it comes to coupling with other databases, developed in commercially free software. It allows little freedom when changing users to manage a database, and executes the corresponding tasks.

The only database tool worth using

Apr 11, 2018
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: I've used SQL for years and I'm always impressed at how each next version takes user feedback and rising industry standards in to account.

Cons: Other than lacking some UI features in the latest releases (i.e., dark mode) there really isn't anything not to like.

MSSQL Server has been my DBMS for some apps on our platform, management is easy

Apr 11, 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: 8.0/10 Not
Likely
Extremely
Likely

Pros: Since We've been using it, MSSQL Server is very reliable, stable, and good performance, and Manage administrative tasks like Backup and Maintenance tasks is very easy with SQL Studio.

Cons: We have to be carefully if new versions release do not support our app. Pricing of Microsoft products sometimes are expensive. Another thing I've had problems is with Transaction Logs backup, that shows errors without any logical reason.

I have used SQL Server all of my professional career and love it

Apr 11, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: It's secure, reliable and stable. I use this daily for data extraction. I've never had any sort of issues.

Cons: It could be more user-friendly. Setting up a SQL server environment can be pretty lengthy. Overall a great product that I will continue to use, though.

I've been able to learn much more about querying and build more useful and advanced queries.

Apr 10, 2018
5/5
Overall
5 / 5
Ease of Use
3 / 5
Features & Functionality
4 / 5
Customer Support
3 / 5
Value for Money

Pros: The DBMS allows you to easily create several things entirely in design. If you are working from scratch, its relatively easy to set up a new database server.

Cons: Sometimes you just need a simple answer and not a lecture on every argument that can be used.

The industry-standard database for Microsoft products

Apr 10, 2018
5/5
Overall
2 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
3 / 5
Value for Money

Pros: Extremely robust and very stable, there's a reason why most Windows software uses this as a back-end.

Cons: You have to be a pro to do anything advanced, and unfortunately most software comes with SQL Express, which is much more difficult to backup.

Powerful Database Engine, Uses Industry Standard SQL

Apr 10, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: Full-featured database engine. Easy to set up replication and clustering compared to MySQL. Less expensive than Oracle. Easy Active Directory integration. No Microsoft-unique language quirks- uses everyday, ordinary, industry standard SQL. An easy choice if you have a Microsoft datacenter.

Cons: More expensive than some other options, such as MySQL. Licensing can be complicated. Customer support should be better for the cost of the software. Native tools GUI not as good as some third party tools are. No Linux option for those who prefer Linux host OS's.

Overall: Our corp IT dept prefers Microsoft platforms, and with our licensing agreement with Microsoft, SQL Server is a pretty easy choice, especially with regards to anything that needs replication or clustering.

SQL Server is a great product

Apr 10, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money

Pros: Microsoft SQL Server is great because it is highly flexible and robust. There are more features in Microsoft SQL Server than other database programs that I am aware of. We use SQL for databases storing line of business application data, website information, and more.

Cons: The main problem with Microsoft SQL server is the cost. Licensing for SQL Server is very expensive and you need client access licenses for each user that connects to the SQL server. Other database programs are much less expensive or even free.

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.

Capterra-loader

It is an excellent relational database management system software developed by Microsoft

Apr 09, 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: 10.0/10 Not
Likely
Extremely
Likely

Pros: It offers scalability, stability and security, at the same time, it has storage and data processing support, it has a powerful graphical environment, a highly intuitive administration, it allows the administration of other database servers, in the same way, if you work with a Social network will allow adding other SQL Server servers.

Cons: The consumption of resources is extremely high, both during the installation and during the execution, you do not have the ease of being able to occupy it to practice, its price is very high and it does not compensate what it offers, it has many blockages at the page level.

Overall: If we work in a local network it allows us to add other SQL Server servers. for example: I have a database on my SQL server on my computer and my partner has another database on his server. I can connect my SQL to yours and so I have their databases in my SQL Server. This is also very comfortable.

Our production environment would be at a loss without SQL server.

Apr 09, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: Our primary ERP relies on Microsoft's SQL server, and it's been running steadily for years. Microsoft makes it easy to install, and easy for anyone to administer.

Cons: The only downside could be for the budget minded, but otherwise I have nothing bad to say about this product.

A powerful relational management system that contains tons of features!

Apr 09, 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: - Far easier to use as compared to Oracle database.
- Has better replication support as compared to MySQL or Oracle

Cons: - Very expensive
- Some of the features are only available in Enterprise edition
- Complex to learn as how SQL server works internally.
- Every new version comes equipped with lots of changes, making upgrade process cumbersome.

Tha most advanced relational database solution in market

Apr 08, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: SQL is a fundamental programming language and this product help support any end users who have the experience to run queries

Cons: It sometimes does not play nice with non-MS systems, but I think that's more to do with the quality of the work the developer does.

Easy to store and retrieve data

Apr 07, 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: 9.0/10 Not
Likely
Extremely
Likely

Pros: It allow to create dynamic queries and build dependency on different tables. Easy to fetch data from database and maintain complex data. Easy to implement with computer programming languages.

Cons: SQL Profiler does not show the complete performance of sql queries. It takes time when we have large amount of data in single table.

Overall: String Client certificate information and their invoice and settlement info.

Easy software to create databases

Apr 06, 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: Great ability to handle all complex query requirements. You can connect to multiple databases at the same time in multiple tabs without interrupting the existing connection.

Cons: My only complaint about this software; sometimes their updates slows the performance. Also it takes a lot of RAM for installations

Capterra-loader

Very good tool

Apr 06, 2018
5/5
Overall
3 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
2 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: What I like most about this software is the powerful graphic interface it has. another feature that I like is that in general customers do not have to install anything to connect if it is Windows

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

I have used SQL server every day for the past 8 years. It is my database system of choice.

Apr 05, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money

Pros: MS SQL Server gives me the ability to easily and reliably store all of the data that I would need to support my applications. It also performs well under load and is extremely robust in enterprise environments.

Cons: SSMS (SQL Server Management Studio) falls behind other similar SQL tools as far as feature set. I would like to see Microsoft add some of the smarter development features from Visual Studio to SSMS.

Capterra-loader

SQL Server for the last 8 years

Apr 05, 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: Solid and efficient relational database provider.
The ability to use Integration Services and Analysis Services very easily.
Installation of software is very easy but it also leaves a lot of room for tweaks and performance improvement for specialised DBA.
There are a lot of MVP's and community where rookies can learn and evolve within the technology.

Cons: Auto update statistics could be optimised, the threshold should be configurable.
SQL Cursors performance could be optimised.

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.

Great database platform. Haven't used others extensively, but perfect for .NET stack.

Apr 05, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Easy to create, backup and manage databases. Great integration with Visual Studio for managing database migrations etc.

Cons: All of our applications are relatively small, in which case it may be preferable to use a more lightweight solution (SQLLite etc.)

Overall: Simple database platform for .NET stack.

I use sql server to store and retrieve data from the product based app using stored procedures .

Apr 05, 2018
3/5
Overall
5 / 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: Open source and
Easy to install and use for a beginner
Good performance and highly secured
Best for huge data storage
Recovery of data in case of any disaster

Cons: It runs only on windows -based servers
Very high licensing fee if used for business purpose
Eats of loads of cpu and requires huge memory space

Overall: It is a best package for data storage and retrieval and also serves a good backend for retrieving data requested by any front-end application running on a server

Powerful, but takes technical knowledge to learn

Apr 04, 2018
4/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality

Pros: The management studio program is extremely comprehensive, and very powerful. Once you've got your head round it, managing databases and queries is a very smooth process.

Cons: Some more detailed user documentation would be helpful as the software has so many levels to it and it feels like you're never using it as effectively as you can.

ADMINISTRATION AND ANALYSIS OF EXCELLENCE

Apr 04, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: For any organization that handles a large amount of data in their files and computer records, it is essential to use this software

Cons: I think that knowing that the SQL code is not completely portable between different database systems, it is important to have knowledge of sql synax

Overall: I feel SQL Server is far superior to other platforms I have worked with. The products we develop have much more flexibility and functionality than previous ones

Great if you have the right training

Apr 04, 2018
4/5
Overall
2 / 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: I watched a more advanced user teach a group of us how to use this and it seemed simple enough. Great to create custom forms for your company, ie: invoices, order entry forms, etc. A big difference from using standard crystal reports.

Cons: Not the easiest to use if you haven't had the best training. Huge learning curve if you have never created custom reports and don't have the knowledge. Takes some testing to get used to it and have it do what you need it to correctly.

Overall: Great to create custom reports.

A database engine that is required by many enterprise software vendors.

Apr 02, 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: 7.0/10 Not
Likely
Extremely
Likely

Pros: It is easy to install and can be templates for consistent deployment throughout an organization.
A free edition is available for small / low-featured deployments.
It is stable and well maintained with frequent patches.

Cons: I don't feel is is inherently better than free/open-source alternatives such as MariaDB or Postgres. Licensing is very expensive and has adapted through the years to mach whatever gets Microsoft the most money per SQL server.

Overall: It does work for all the instances we have. Many applications are single DB dependent and this is a commonly selected vendor.

Capterra-loader

I love working with SQL Server

Mar 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: 10.0/10 Not
Likely
Extremely
Likely

Pros: I love working with SQL Server, I will definitely come back to work with them in the future, the services they offer are really good and they know how to help their clients.

Cons: I really do not have any complaints about this company, quite the opposite. I recommend it to 101%.

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.

Capterra-loader

Excellent Database Server capable of handling mission critical tasks.

Mar 30, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: Microsoft SQL server powers my company's applications perfectly. It's robust and capable of dealing with a heavy workload.

Cons: For smaller applications, you're better off going with MySQL which is free and will have a lot of the features.

It is our main Database manager.

Mar 30, 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: 9.0/10 Not
Likely
Extremely
Likely

Pros: I like how fast the manager is. Its installation is simple to perform. The options available within the menus are placed in a way that makes it easy to find what is needed. The backup and restore options of the BD are very easy to use. Its capacity of operation, depends on the hardware installed, that allows to grow easily.

Cons: I do not like that it only works on Windows Operating Systems. 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.

Overall: We have centralized the data repositories of the different corporate applications.

Capterra-loader

Easy to Run on Windows

Mar 30, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: SQL server is one of the products from Microsoft, from which windows users can benefit easily. There is absolutely no problem setting it up on any of the versions of windows. Provides a wide range of options for data administration. Layout, data retrieved from SQL queries Shown very beautifully. It's easy to use and very fast.

Cons: it doesn't target the business side of database management systems especially. Queries need to be modified to be run on Oracle.

I was always having to reset or correct issues

Mar 30, 2018
3/5
Overall
3 / 5
Ease of Use
3 / 5
Features & Functionality
3 / 5
Customer Support
3 / 5
Value for Money

Pros: The software allowed me to use my home inspections software database. It was necessary and not something I chose.

Cons: It was constantly having an issue where I would have to manually start or stop the server to get my software to function. Eventually I just changed softwares.

Great for advanced features

Mar 30, 2018
5/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: Great software for viewing and extracting data via SQL queries. Easy to schedule back-ups and controll user access with groups

Cons: There are some pretty advanced functionality in this software and you can do some serious damage to database structures if you play around. Luckily there are good training out there support teams are very helpful.

Overall: Advanced data queering. Manage databases and servers. User access permissions administration. Scheduling automated database backups.

Best database tool in the market

Mar 29, 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: 10.0/10 Not
Likely
Extremely
Likely

Pros: The ability to connect to many databases concurrently is outstanding. Very reliable and easy to manage your data. I've only just begun using this tool and it clearly stands out compared to other database engines currently.

Cons: I have yet to see any cons although the price was a concern at first and there was a slight learning curve to it too.

Overall: Great database for enterprise level.

The right tool to data analysis

Mar 29, 2018
4/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Easy to install, this tool from Microsoft let you easily create stored procedures, use simple query structures and functions wich will allow you to get the maximum aproach of your data, either if your job is oriented to data analisys or as a robust database for plenty business needs.

Cons: It's not as powerful as Oracle.
The solution and the related customer support, represent a high cost.

Overall: Fast data analisys.

Easy software to create databases and edit variables

Mar 27, 2018
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: This software has a good tool to understand how to create and edit variables for the database by mean commands.

Cons: It should have a free version for students. It is very important for computer science industry to people know how to manage a database. In the end, Microsoft could have a lot of candidates to give feedback with this powerful software.

Overall: Enterprise level database management platform

In love with SQL Server

Mar 27, 2018
4/5
Overall
4 / 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

Comments: Just the best data base motor for me

Pros: Show you exactly where the error is Has many foros of expert people for every error you can face Have a really fast response Multi user profiles

Cons: You need preview known of database coding Depending on your configuration might need internet conection

Capterra-loader

Best database tool that I have ever worked on

Mar 26, 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: You can connect to multiple databases at the same time in multiple tabs without interrupting the existing connection is the most standout feature. You can read the log files easily in case if some crash occurs. Easy to view 100s of rows at a time.

Cons: There aren't any cons that the tool has as far as performance, concurrency and ease of use is concerned.

Overall: We use it to manage database system in our organisation.

Capterra-loader

I've been using SQL Server since my all professional career and I simply love it.

Mar 26, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
3 / 5
Value for Money

Pros: One of the best if not the best database engine. I've been using SQL Server for all my professional career until now. It's easy to use, admin and learn. And I've a lot of information in all the internet.

Cons: I do not see anything that I do not like in this product. Probably some user experience interfaces could be improved and just it.

SQL has helped us to store critical information in a secure database and we can control it.

Mar 26, 2018
4/5
Overall
5 / 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: The secure way in which we can store and protect the information. Also by doing so we can follow the standards.

Cons: The license sometimes it becomes expensive, especially if we have more processor related to the server. The enterprise version is very expensive.

Overall: Security, centralized information and follows the standard.

It's a good database managament software !

Mar 24, 2018
5/5
Overall
4 / 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: Microsoft SQL Server is reliable and stable, and quite easy to manage your data warehouse. Security is very good too.

Cons: The price of Microsoft SQL Server is higher than other servers, and your system must be strong to run it properly.

Capterra-loader

indispensable to process databases

Mar 23, 2018
5/5
Overall
5 / 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: is one of the leading programs for the management and processing of databases, the search system module is great, the processing of errors in the database saves a lot of time and work, besides this is stable and effective

Cons: When the databases are robust it tends to be a bit slow, the software usually consumes a lot of RAM when you are working with large databases, the learning curve is wide, that is, it is not easy to learn to use

Overall: is the tool that I have used every day for more than 4 years to compile and manage databases of the electoral field

SQL

Mar 22, 2018
5/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: SQL is a fundamental programming language and this product help support any end users who have the experience to run queries

Cons: SQL could use some improvements to make it more user-friendly, easier for non-technical users, and widely adopted.

Capterra-loader

Best program for the administration and management of large databases

Mar 21, 2018
5/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: This program has the advantage of creating, operating and managing large volumes of information in databases, queries are easy to do and allows searches with a multivariable format.

Cons: This program is quite expensive and for large databases it requires a powerful machine, since it requires a lot of memory RAM when processing information, which sometimes causes the program to slow down.

Overall: I use it to manage bases of the territorial political division associated with electoral events.

Its Easy, Friendly and Familiar

Mar 21, 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

Comments: My company is primarily a Microsoft shop, so why not MS BI. Our Govt. has an MOU with MS so we get all the tools and we are trained in most things MS so we are comfortable and satisfied with this product. Even our PeopleSoft solutions run on SQL Server.

Pros: 1. Easy to use even by non-technical users 2. If you know what you are doing you can extend functionality and flexibility for almost anything you want 3. The above leads me to my next pro : stable IDE and flexible integration with SSAS

Cons: 1. A common language to develop and make changes would be nice 2. Its expected that you are an excel expert - but then again who isn't 3. It uses a lot of hardware power - but we have the horses

turns critical applications into intelligent applications with performance

Mar 20, 2018
3/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: Transaction support
Supports stored procedures
It also includes a graphical administration environment, which allows the use of DDL and DML commands graphically.

Cons: If you want it to practice it will not make you useful so the prohibit many things have restrictions in particular I stand more viable using MySQL is much better besides being a free software. The value for money is very convenient with the oracle.

My experience with Microsoft SQL Server and the form to connect across multiple data connectorsmysql

Mar 20, 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: 9.0/10 Not
Likely
Extremely
Likely

Pros: Runs on LINUX
Job and Task schedule and Email Notification
Distribution Transaction
Like to use
Easy to use
Well integrated
Consistent
Quick to learn

Cons: RDMS Database backend for Web Site Application
RDMS Database backend for Reporting Services
RMS Database backend for ERP, CRM etc Software Tool Project

Overall: ease to use

Capterra-loader

Unites Sql with Internet

Mar 20, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
2 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Graphic environment that allows the administration. allows to work in server client mode, where the information and data are hosted on the server and the clients of the network access it. It allows to manage information of other data servers, it supports stored procedures.

Cons: Huge amount of RAM that is used for the installation of and use of Software, is somewhat expensive. My version 2005 does not allow the compression of data, which generates a lot of disk space.

Overall: facilitates the creation of solutions to problems with versions, disaster recovery and backup copies. You can transfer databases in a very simple and intuitive way between your local environment and the cloud.

Capterra-loader

SQL Server is more than just the database

Mar 20, 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 database is outstanding and runs most of our applications. But the additions of SQL Server Reporting Services, Analysis Services, and Integration Services have allowed many user to create their own reports, cubes, and ETL/data flows very quickly.

Cons: The syntax differences, particularly around datetime formatting, can be challenging if you are coming from Oracle or other SQL databases.

It takes a while to learn SQL Server, but it is a stable platform with ongoing support.

Mar 20, 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: 9.0/10 Not
Likely
Extremely
Likely

Pros: The SQL Server Management Studio makes it easy to explore tables, stored procedures, etc.. It also makes it easy to build new tables, procs, functions, triggers and more stuff right there at your fingertips.

Cons: Using it to to pull information is relatively easy. Setting up a SQL Server environment with proper backups, configuration, and disaster recovery takes a lot more homework.

Overall: It's my job. Thanx to the Internet, I've been able to increase my knowledge without having to take classes, which couldn't stay up with the pace of technology, anyway.

Capterra-loader

Microsoft's premier product that comes with loads of documentation

Mar 19, 2018
4/5
Overall
4 / 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: Once you get the software you will find that setting thins up is incredibly easy. If you get lost at one point or need guidance the documentation covers almost everything you can think of. At my job I heavily use XML, and it supports it! Couldn't be happier with this product. Just the ease of use this product provides is unbelievable. On other products I get lost and there is barely any documentation, this software clears all that trouble for you.

Cons: This item is extremely costly. The company should really look into if you want to invest that much. Since there is rapid development to get the newest features you have to make another investment. Since there are also tons of features I kind of get frustrated on which feature to really use.

Overall: I always use the Server Analysis Service tool to build data marts and data cubes. Honestly one of the best reporting tools out there. It is always consistent and reliable.

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.

SQL Server is the best all around relational database

Mar 16, 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 provides easy use for both end users and developers/administrators. It's ability to seamlessly blend in with the Microsoft infrastructure makes it a no brainer to purchase for most businesses.

Cons: It sometimes does not play nice with non-MS systems, but I think that's more to do with the quality of the work the developer does.

The Leader!

Mar 15, 2018
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

Comments: The best by far (obviously)

Pros: Enhancements to Intellisense have been remarkable. Also love that reporting services have been shifted to using Adobe. So clean and simple.

Cons: Only minor improvements. Maybe an automatic "Refresh Local Cache" after adding a table or column. Also, when using built in functions, the system doesn't see the FROM statement automatically.

Capterra-loader

excellent program that serves to load data easy to use

Mar 14, 2018
5/5
Overall
4 / 5
Ease of Use
3 / 5
Features & Functionality
4 / 5
Customer Support
2 / 5
Value for Money

Pros:
it is very easy to manage, you can get data network data because it can be interconnected with several servers with sql server

Cons:
It uses a lot of RAM for installations and software use, it has many restrictions due to that you can not practice

Overall:
I allow myself to create a database with security, stability in my system

Microsoft SQL is the one stop solution for all the Relational Database requirements.

Mar 13, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money

Pros: The best part of this server is the command line. Almost everything is encompassable on the command line which makes db administration much easy.

Cons: The user interface overall can be improved. A better gui range of options can replace the command line wherever required.

Powerful but touchy

Mar 13, 2018
4/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money

Pros: MS SQL server is a well developed GUI for managing and administering databases and cubes with plenty of features.

Overall: While it is a powerful suite, it can be easily broken by compatible issues with several different versions installed concurrently.

Capterra-loader

Sql server is a complete engine to persist your data

Mar 13, 2018
5/5
Overall
5 / 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: * it have a "sql express" edition that allows to use it free * (mem and cpu limits)
* it allows to have a backend data service to retrieve information as you need it
* It have Sql management studio that is a complete suite to make querys, stored procedures and create tables/stored procedures/views/etc

Cons: it is propietary, not like mysql or firebird that are open source,.
It cost money if like the enterprise version

Overall: sql server is a complete solution to store / persist data. It is complete and reliable and allows to focus on the application and not how the data have to be saved.

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

Really good to have knowledge on this

Mar 12, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
3 / 5
Value for Money

Pros: T-SQL remains consistent and SQL server has been evolving rapidly in multiple technologies we can also get good support when needed.

Cons: One has to be in Microsoft's Ecosystem to use SQL Server and Cost is bit high.
Monitoring SQL Server performance.

Super powerful database software

Mar 12, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: Easy to use interface with SQL Server Management Studio, create databases, tables, and automated jobs with ease!

Cons: My only complaint about this software is the newer version of SQL Server Management Studio seem to get hung up in a "Not Responding" state.

Made it very simple to handle my database needs for my application.

Mar 12, 2018
4/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money

Pros: SQL server is the best software to creat best end to end softwares. Also very easy to do the database administration work.

Cons: It has a very boring commandline interface so i would like them to introduce a proper GUI interface to work with

Capterra-loader

It is a very good option to manage databases!

Mar 10, 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: What I like is that can handle large amounts of data without any problems, also can be made simple and important analysis

Cons: It is a program that takes a lot of memory on your computer, and this makes it work in a slow manner

Overall: Is a simple program that allows you to manage a large number of information and that makes it interesting

Excellent database package

Mar 09, 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 same codes can be run on any other platforms with SQL facilities
It is compatible with existing IT infrastructure and facilities

Cons: It is requires sound and solid knowledge of SQL programming
Database connections are fragile i.e. they can be broken easily

Capterra-loader

I use this product on a daily basis for work

Mar 09, 2018
4/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: I like the interface. I like being able to pin the different windows to different areas. I love the registered servers part.

Cons: It takes a decent amount of memory to keep running. I don't like that I can only set the color to the SQL Window at the bottom, I'd love to see the tab at the top in color.

Overall: It makes my job easier.

Sql server management is a complete package provides Database management and development

Mar 09, 2018
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Back up of any existing database. It provides syntax checking and auto completion suggestions of commands. Detailed overview of any execution of run me. Different type of security checks.

Cons: Sometimes it crashes while doing multi tasking. Performance is not very smooth on low end hardware.

Overall: Development procedures and tables of databases applications.

A very good RDBMS

Mar 09, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Easy to use. SQLServer is cheap RDBMS corporate if compared with Oracle. Good integration with other MS applications

Cons: The performance Microsoft SQL Server are poor if compared to Oracle database.
Does not support Linux systems.

Capterra-loader

the best in database management, 100% stable and reliable

Mar 08, 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 functions of handling of errors and processing in row are fantastic, it is stable and simple to use, the storage capacity is impressive and the technical support great. this program is a work of art

Cons: sometimes it is a bit slow, they consume a lot of ram memory and the sizes of the work windows are very small and uncomfortable to use, these are the 2 most important details that should be improved

Overall: I have been using it in the office for more than 2 years to manage large population and electoral databases, it has made it much easier to manage this data

I use Sql Server and SSMS on a daily basis and am able to build the queries that I need.

Mar 08, 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: 7.0/10 Not
Likely
Extremely
Likely

Pros: I like the ability to write complex queries and set up database tables and link servers. I am mainly a user of the product but the administration of our databases is made easier with all the integration packages available. I like the new function additions in the 2016 version.

Cons: There are some functions and features other database systems use that I would like to see in Sql Server, but overall I am not affected too much.

Overall: I am able to write my database queries as well as set up new databases and tables for work using Sql Server.

Good stable database platform for small database systems.

Mar 08, 2018
4/5
Overall
3 / 5
Ease of Use
2 / 5
Features & Functionality
3 / 5
Customer Support
2 / 5
Value for Money

Pros: Easy setup, easy replication management, easy administration via SQL Server Management Studio.

Easy to create scheduled jobs and maintenance tasks without lifting a finger.

Cons: Very closed minded approach to implementation of most features, and some concepts are almost sellotape and string, E.g. logical "Replication" hanging off a long running scheduled task?

Great Experience with a great product from Microsoft

Mar 08, 2018
4/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: I most like this ad-hoc database management, its backup feature, security integrity.its gives better performance while executed the huge amount of query.

Cons: it's too costly for the small organization, it consumes the huge amount of memory while running SQL server.it required hardware upgrades.

Overall: we increase our customer's relation and trust its matter for the organisation

The defacto standard small business sql database.

Mar 07, 2018
4/5
Overall
4 / 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: Excellent integration with other software frameworks and plenty of 3rd party applications and support out there.

Cons: It can be expensive to buy and complicated to setup if you have never done it before. Migration from older version to newer version can be troublesome if you are not careful checking the prequisites.

Exactly what you'd expect from Microsoft

Mar 07, 2018
5/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money

Pros: I'm typically a big fan of Microsoft administration tools, likely because I grew up with them. Some of the tools in the newer versions are slightly more difficult to find, but overall I'm happy with SQL Server.

Cons: There aren't a lot of useful tools when it comes to SQL server management. If you're writing custom scripts, the trace-ability to older revisions are difficult to manage in the software.

I have more than 3 years using this software, it always help me accomplish the tasks that I need.

Mar 06, 2018
5/5
Overall
4 / 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: The "Job" feature. The reason I love this feature, is because it's allow you to schedule task that need to be performed without human intervention.

Cons: It's difficult to install. The installation and un-installation features are kind of difficult to perform.

Capterra-loader

I started using sql server when I created my first interactive web page with Visual estudio net

Mar 05, 2018
5/5
Overall
5 / 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: What I like the most is its ease of use when making queries and being able to visualize the results directly. also offers access security which gives functionality when making an application based on multi-user environment

Cons: it has a lot of consumption of computer resources ram memory and the cost benefit when compared with Oracle and Mysql that is free.

Overall: The security it offers and the compatibility with Microsoft software as a visual study to develop applications.

Capterra-loader

SQL Server: Another Database

Feb 27, 2018
4/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
4 / 5
Value for Money

Pros: Easy to use
Provides various features and services.
One of the important relational database.
Seamless integration with Microsoft products.

Cons: Microsoft SQL Server lacks performance with compared to Oracle database.
Does not support Linux systems.
Transaction handling is very tricky.

Easy to store and maintain business data

Feb 23, 2018
4/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: It provide inbuilt features to create partitions on large data tables. Easy to create dynamic sql queries or procedure. Currently i am using sql server 2014 version which is faster than older version.

Cons: It does not suppot to large sql execution plan. Some time i need to restart sql server if i clicked to stop the executing query.

Overall: Created business logic to parse xml data and save into tables.

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.

Great Experience.

Feb 22, 2018
5/5
Overall
4 / 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: Microsoft SQL Server is really good relational database management system. Easy to use with knowledge of SQL

Cons: Microsoft SQL Server sometimes gets heavy with large database but still manages efficiently. I do not find major drawbacks

Learn about more and more uses everyday!

Feb 22, 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: Easy to use, great for relational database, looks of add-ins to work more efficient, easy use of SSIS abilities

Cons: many useful add-ins do not come with it which makes it difficult to use until purchasing licenses for the additional add-ins

MS SQL server not a replacement for Oracle

Feb 22, 2018
2/5
Overall
5 / 5
Ease of Use
3 / 5
Features & Functionality
2 / 5
Customer Support
1 / 5
Value for Money
Likelihood to Recommend: 5.0/10 Not
Likely
Extremely
Likely

Comments: Its good for learners and beginners but not for professionals

Pros: Very easy to use as compared to oracle Easy to manage and maintain with tools easy to start work with

Cons: Performance is very poor as compared to other sql servers not reliable for enterprise solutions very expensive product

Good experience

Feb 21, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money

Pros: Easy to use. Plenty of functions. Good for relational database. More features now. Python , R integration. Jason functions.

Cons: Some things need improvement. Would like to easily manage and maintain the database. Would like more sql prompt short cuts.

Excellent application for DBMS

Feb 20, 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: I've been working with SQL Server for several years and I'm very pleased with the application. It allows you to quickly process all requests, there is a ready-made set of ready-made SQL queries. It's nice to work when there is a query analyzer, a resource scheduler, and the ability to generate reports.

Cons: Sometimes my databases (especially large ones) hang and I have to overload the server. This takes time in which the client sites are idle.

Capterra-loader

Microsoft SQL Server is a great Database Plaform

Feb 19, 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: Being able to create relational tables and columns easily. Being able to import data from other data sources on a schedule. SQL management studios flexibility and graphic aids are great.

Cons: Does not run on Linux, Cals are too expensive, needs to have built in maintenance to run backups and shrink logs.