Microsoft SQL Server BI Software


 

Microsoft SQL Server Business Intelligence (BI) Edition is a database management and BI software solution designed for companies of all sizes. The system offers relational database management, which allows users to access enterprise data using structured query language. The solution allows users to perform complex analysis on the database. The product also features a BI Semantic model that allows users to extract and analyze data from heterogeneous sources.

Microsoft SQL Server features “in-memory analytics,” which allows users to perform queries and analytics while the data is in the RAM, thereby improving the speed of access. The software has scalable and corporate reporting features that help management to make decisions that are more informed. Organizations can improve the data quality by using the organizational knowledge and third-party reference data providers to profile, clean, and match the data.

The IT department can manage data through a BI Semantic Model, which provides a consistent view across multiple data sources.

 

Microsoft SQL Server - BI Edition - Sales summary
 
  • Microsoft SQL Server - BI Edition - Sales summary
    Sales summary
  • Microsoft SQL Server - BI Edition - Buffer pool extensions
    Buffer pool extensions
  • Microsoft SQL Server - BI Edition - Query
    Query
  • Microsoft SQL Server - BI Edition - OLTP
    OLTP
Supported Operating System(s):
Windows 7, Windows Vista, Windows XP, Mac OS, Linux, HP-UX, AIX, Solaris, Unix, IBM OS/400, Web browser (OS agnostic), Windows 2000, Windows 8, Windows 10

119 Reviews of Microsoft SQL Server - BI Edition

 

Start your review of Microsoft SQL Server - BI Edition

Click to start
https://www.softwareadvice.com/bi/microsoft-sql-review/
Software Advice Reviews (20)
More Reviews (99)

Showing 1-20 of 20

Santhosh Kumar from Scientific Games Corporation
Specialty: Software / Technology
Number of employees: 5,001-10,000 employees Employees number: 5,001-10,000 employees

December 2017

December 2017

SQL 2014 Feature and Upgrades

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Database clustering with always On is one of the nice feature we use. An application was working with SQL 2008 R2 and after upgrading the SQL 2014, we have some issues popping up.

Pros

Database clustering with always On is one of the nice feature we use. Very user friendly when we do failover from Node1 to Node2.

Cons

An application was working with SQL 2008 R2 and after upgrading the SQL 2014, we have some issues popping up.

Review Source
 
 

Varun from Adaptrum
Specialty: Engineering
Number of employees: 11-50 employees Employees number: 11-50 employees

December 2017

December 2017

Powerful Database

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

Reliable; relatively easy to administer; huge amount of paid and free books, videos, blogs, forums, third-party products available; actively being improved by Microsoft.
Free Express edition for desktop and small server databases up to 10GB.

Cons

It can be pricey
SQL Server often challenged to due to limitations of integration to 3rd party software like MySQL etc.

Review Source
 
 

Victor from waytoweb.com.br
Specialty: Software / Technology
Number of employees: 2-10 employees Employees number: 2-10 employees

December 2017

December 2017

An incredible database

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

It is a powerful database, with extra features of bank design, it is possible to program with it, making it one of the most competent alternatives

Cons

The fact that this bank do everything makes it superficial in some specific areas, as in OLAP cube management the best alternative is postgresql

Review Source
 
 

yogalakshmi from Lodgenet
Specialty: Software / Technology
Number of employees: 201-500 employees Employees number: 201-500 employees

November 2017

November 2017

MS sqlserver Database

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

User friendly with high-end datacenter.high service levels for mission-critical workloads and end user access to data insights. cost effective compare the Oracle licensing.

Cons

Not having much features for the data warehousing and data integration between multiple system. SSIS can be improved with respect to the warehousing and analytical reporting.

Review Source
 
 

Osama Mahmoud from Information Technology and Services
Specialty: Software / Technology
Number of employees: 2-10 employees Employees number: 2-10 employees

November 2017

November 2017

Easy to create and maintain and backup database

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Pros

1.All field types available
2.Easy to manage indexes and relationships
3.Easy maintenace plans
4.Db backup made simple

Cons

1.Take database offline is time consuming from the context menue. It has to be done using script.
2.Big size log

Review Source
 
 

harmandeep singh from New York University
Specialty: Education
Number of employees: 5,001-10,000 employees Employees number: 5,001-10,000 employees

November 2017

November 2017

Any person can work with MS SQL

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

Error logging and indicators
Colors keywords
Allows for easy formatting
Allows for multiple tabs
Allows for multiple subqueries

Cons

Would prefer more built in queries for DB optimization rather than having to find scripts on the internet.
Data encryption
Security
Fuzzy SQL logic

Review Source
 
 

Alexis from Fine Tune
Specialty: Education
Number of employees: 10,000+ employees Employees number: 10,000+ employees

November 2017

November 2017

Love it!!! So easy to learn

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

Super easy to learn-the syntax is pretty straight forward
Really helps with data analytics and integrates with all the BI tools for data visualization

Review Source
 
 

Brian from Mercy Health
Specialty: Healthcare / Social Services
Number of employees: 10,000+ employees Employees number: 10,000+ employees

November 2017

November 2017

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

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

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.

Review Source
 
 

jain from Lawrence foods
Specialty: Food / Beverage
Number of employees: 51-200 employees Employees number: 51-200 employees

November 2017

November 2017

I love using it !!

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

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

Cons

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

Review Source
 
 

Ramia from CAII
Specialty: Government
Number of employees: 201-500 employees Employees number: 201-500 employees

October 2017

October 2017

this software has changed the world of reporting for me

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

DTS feature is a powerful and flexible tool. Although Microsoft created it to facilitate data warehousing, the product's usefulness doesn't stop there. DTS simplifies importing and exporting data between any two Object Linking and Embedding Database (OLE DB)-compatible databases. DTS also generates Visual Basic Script (VBScript) files that you can run from the Windows Scripting Host (WSH) or other component object model (COM) environments.

Cons

The lack of Cascading DRI is probably SQL Server's biggest shortcoming in comparison with competing databases in the NT market. Even Access provides support for Cascading DRI. You can use triggers to compensate for this shortcoming, but you don't need to go this route with other databases, so you shouldn't need to do it with SQL Server 7.0. Considering SQL Server 7.0's other features, the fact that this one didn't make the cut is a shame.

Review Source
 
 

Jasmine from DaVita
Specialty: Healthcare / Social Services
Number of employees: 10,000+ employees Employees number: 10,000+ employees

September 2017

September 2017

Time saving

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Pros

I really like how quickly I am able to pull useful data that is already formatted in a way that I can just paste it into Excel for further data manipulation

Cons

I have to actually be in the office in order to use it. I can't connect to the database even when on the VPN

Review Source
 
 

James from UHealth - University of Miami Health Care System
Specialty: Healthcare / Social Services
Number of employees: 10,000+ employees Employees number: 10,000+ employees

August 2017

August 2017

Consitent and Performance

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

I like the consistancies of the the software over time. They are able to bridge generations of coders to be able to continue.

Cons

I hope they could bridge the gap so that everyone could feel powerful programming in different languages.

Review Source
 
 

Gavindra from UHealth
Specialty: Healthcare / Social Services
Number of employees: 10,000+ employees Employees number: 10,000+ employees

August 2017

August 2017

A very powerful tool in data analytics, data warehousing, and big data in general.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

An extremely powerful and versatile Database Engine that integrates well with multiple platforms. In addition it has tools that provide lots of flexibility for automation.

Cons

Depending on the usage, the Database can eat up resources very quickly and does not tend to release them without some manual intervention.

Review Source
 
 

James from United Metropolitan Nigeria Life Insurance Ltd
Specialty: Banking & Financial Services
Number of employees: 51-200 employees Employees number: 51-200 employees

July 2017

July 2017

Effective database management software

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

A good software, one of the best around.

Pros

Continuous improvement and addition of more functions for easy of use. The application is a complete bundle for data management, development and BI.

Cons

Limited GUI tool for newbies in database development. Express edition is also very limited, needs to be improved on.

 
 

Dinesh Kumar from Lennox International Inc
Specialty: Banking & Financial Services
Number of employees: 2-10 employees Employees number: 2-10 employees

July 2017

July 2017

Microsoft SQL Server

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

Performance of SQL Server's database engine is a huge plus.
Performance gets better and better with new versions of SQL Server. Keep upgrading to newer versions

Cons

Compatibility with other versions of SQL Server is tough.
Not all companies use the same version. Administrative tasks changes with every version of SQL Server

 
 

anudeep from MicroinfoIT
Specialty: Software / Technology
Number of employees: 51-200 employees Employees number: 51-200 employees

June 2017

June 2017

Its amazing software to do lot of things.

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Pros

Easy when compared to other platforms like DB2 and Oracle.
Can organize the data in a proper manner.

Cons

One needs to have knowledge of databases.
Need to know the concepts of traditional databases.
PL/SQL knowledgs.

 
 

Caitlin from MMSG
Specialty: Banking & Financial Services
Number of employees: 501-1,000 employees Employees number: 501-1,000 employees

June 2017

June 2017

One of the easiest places to exhibit your SQL brilliance

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

The colour formatting is smart, and being able to shrink/expand coding chunks for smarter faster skim reading.

Cons

Auto-fill can sometimes be hard to reverse as it persists with the wrong value, I've found myself reverse typing the field names so it didn't do this.

 
 

Kevin from Camson Construction, Inc.
Specialty: Construction / Contracting
Number of employees: 11-50 employees Employees number: 11-50 employees

May 2017

May 2017

One of the better Database Platforms

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

A great product overall.

Pros

I love that it's a Microsoft Product. The programming tools and interface is easy to use and the online help is very good also.

Cons

Not much to say as far as cons for SQL Server. It may be a little pricey for a small business and you may need some help/expertise in house or consultants.

 
 

Chris from Edfinancial Services
Specialty: Banking & Financial Services
Number of employees: 201-500 employees Employees number: 201-500 employees

April 2017

April 2017

Senior BI Developer

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

I use Microsoft SQL Server daily and generally enjoy the product.

Pros

Microsoft's SQL server is extremely affordable and is relatively easy to use. You can quickly manage data, permissions as well as provide consumers access to the data through SSAS and SSRS.

Cons

Other BI solutions provide more intuitive features and better ETL/ELT solutions. SSIS & SSRS can be clunky, but they get the job done with extremely low overhead relative to Microsoft's competitors. If permissions are mismanaged, they can get messy very quickly.

 
 

Carl from Day & Zimmermann
Specialty: Construction / Contracting

September 2016

September 2016

Comfortable and still kicking

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Likes Best

Microsoft SQL Server has served me well, handling all kinds of tasks from Data warehousing, automated data pushes, reporting, notifications and ad-hoc analysis. Since we started using SQL Server several years ago, it has allowed us to better serve our customers with consistent data analysis and file pushes. There are also plenty of third party add ins which add immense value to the program.

Likes Least

This program has been around for a long time and most of the complaints I have ever had have been ironed out in recent versions. There is not much to dislike about the program. I will say that there are other vendors with better support than Microsoft but it is not lacking in any way, just not quite the personal touch you get from other vendors. Lastly, it would be nice if Microsoft would incorporate some of the extra features that third party vendors have created. They have slowly incorporated some of them in the past and I am sure it will continue though.

Recommendations

Just make sure you have the proper hardware for your instance and you are good to go. There is not a lot of complication surrounding this install and evaluation is a cinch.

 
 
 
Showing 1-20 of 99

Valentine from eGov Ja. Ltd.

January 2018

January 2018

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

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

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

Cons

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

Review Source: Capterra
 

Larry from INCOSTAS
Number of employees: 51-200 employees Employees number: 51-200 employees

January 2018

January 2018

Safe and robust application, easy to use for data control

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

1. It available on Linux as well as Windows-based platforms.
2. It is very fast and stable.
3. It works very well with other Microsoft products.

Cons

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

Review Source: Capterra
 


January 2018

January 2018

Using Microsoft SQL Server was a great experience! It is one of the best RDBMS in the market.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

I think what I liked the most was the availability of various tools and plugins like SQL Server Management Studio - It enabled me to connect to any database remotely/via the internet.
The Intellisense feature was very useful to help me write queries.

Cons

I think the Settings tab can be configured to be more user-friendly. It is not very intuitive and does require experience to adjust it properly.

Review Source: Capterra
 


January 2018

January 2018

If you know how to use the SQL language, this is an extremely good platform. If not it still works!

Ease-of-use

Functionality

Product Quality

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Pros

Offers a wealth of features to help you easily see optimizations, timing, performance, and basic information about all your databases, whether remote or local.
Connects easily to most modern coding frameworks, as well!
Even if you don't know SQL, you can still easily use the GUI to run basic queries.

Cons

Costs money, but that's to be expected.
Not a problem for most, since it is often covered by work expenses.

Review Source: Capterra
 

Gerson from TECRA TECHNOLOGIES

January 2018

January 2018

Powerful and Reliable like nothing else.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

Peace of mind knowing that I am using the best product on the market.

Pros

Nobody can doubt how reliable and powerful SQL server has become. Today represents the base for every serious deployment over Microsoft software. Features I really enjoy are, high availability, clustering, mirroring... There is a solution for every need, Small or huge. SQL can handle it all.

Review Source: Capterra
 

Khang from Kimberley Hotel Georgetown

January 2018

January 2018

No complain no compliment

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

- Using SQL standard
- Great security
- Easy to configure and setup

Cons

- Only able to install on a Windows Operating System machine
- Making relationships is a painful action

Review Source: Capterra
 

Danielle from County

January 2018

January 2018

Easy to use

Ease-of-use

Functionality

Product Quality

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Pros

The software is easy to use and universal. It is easy to begin and easily transfer data from one SQL server to the next.

Cons

It is a bit expensive, which would be the only real con. I can¿t think of anything else that could be considered a con.

Review Source: Capterra
 

WILLIAM from WorldView LTD

January 2018

January 2018

Frequent SQL user over last several years, best relational db software in the market.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

Like with any relational DB software, you have to understand that specific iteration of the software syntax for queries. This means that users need to be versed in the specific syntax for MSSQL Server (less of a con, and more of just part of the territory with this type of software).

Pros

Microsoft SQL Server has a very user friendly interface, allowing for a quick ramp-up time for new users and ease of user for those more familiar with the software.

Review Source: Capterra
 


January 2018

January 2018

Use with Entity Framework

Ease-of-use

Functionality

Product Quality

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality

I have not found a problem or had any difficulties with documentation which is where I usually see problems.

Pros

Been very easy to switch to I came from using Oracle Server and the transition has been pretty seamless.

Review Source: Capterra
 

Gilberto from Incostas
Number of employees: 51-200 employees Employees number: 51-200 employees

December 2017

December 2017

Es una herramienta de trabajo que me permite almacenar de manera facil y rapida gran volumen de info

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

Easy handling and storage of large volume of data, administration, etc.

Pros

It allows me an easy integration with the software that I develop for the processing of the stored data, easy to manage and administer

Cons

It requires a good computer with a lot of memory and a lot of disk space. Additional you need a good internet connection to keep it updated

Review Source: Capterra
 

Jenish from NexJ Systems Inc

December 2017

December 2017

Using SQL Server for day today software development works

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

The simple steps for taking and maintaining a backup of the database and to apply the old version immediately to verify any issues in software development.
This feature saved me hours of recreating the database during local development process.

Cons

Enabling file channels or setting up different channels with the SQL Server is complicated process sometimes. But n our company we do not do this on a daily process, so we haven't encountered a major backdrop because of this.

Review Source: Capterra
 


December 2017

December 2017

Easy to work with, interface like visual studio

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

I really do enjoy working with the SQL Server client. Something about its familiarity like visual studio makes it pretty easy to use. It's definitely the nicer looking client out there for those user other database clients. The nice thing is that the client is rock solid and I've never had it crash on me. You have the ability to query multiple servers at a time, and the answer sets are preserved per query window - very useful. Its definitely more powerful than Access since it is a fully fledged database.

Cons

I find sometimes its hard to bring things into or out of the tool. Exporting data can be a pain sometimes, it would be nice as a Microsoft product to export to excel, and vice versa to be able to import with excel files too.

Review Source: Capterra
 


December 2017

December 2017

Leading Database Management System at current time

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

SQL Server is most flexible and manageable solution for enterprise data management, and it`s integrations with Azure making it the only really cloud oriented DBMS for now

Cons

Performance tuning tasks are bit complex and involves analizing a lot of data from different sources

Review Source: Capterra
 


November 2017

November 2017

Great database software!

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

I'm a big fan of Microsoft SQL Server. It's easy to install, use, configure, administer and run structured query language statements against.

Cons

It has some limitations once you get into situations where you need to run large, high-performance databases but, other than that, I've had great success using it.

Review Source: Capterra
 

Isis from INCOSTAS
Number of employees: 51-200 employees Employees number: 51-200 employees

November 2017

November 2017

It is an easy-to-use software, strong, robust and safe.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

Fast access to data, security,

Pros

*It is easy to use.
*The security restrictions for the different users that manage the database is good.

Cons

*The commit is not configurable.
*The Express edition has many limitations.
*Uses a lot of RAM in the installation.

Review Source: Capterra
 

Eliz from Incostas
Number of employees: 51-200 employees Employees number: 51-200 employees

November 2017

November 2017

I use the application, to review the data tests of the applications that are developed or data adju

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

It is easy to use, it is very easy to adjust data or review test data that allows faster corrections at the time of development tests

Pros

It is a simple database manager, very inductive, you can search and change data quickly and easily. It is easy to install.

Cons

Comparing with other software really what I do not like is that it is auto commit, this should be configurable.

Review Source: Capterra
 

Justin from GoldenbergLaw, PLLC
Number of employees: 11-50 employees Employees number: 11-50 employees

November 2017

November 2017

Great Database Server

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

Hosts our case management software

Pros

We use the MS SQL server to host our case management software. It makes searching through thousands of files and millions of pieces of information remarkably simple. There is no question it has increased our efficiency.

Cons

It's definitely not the easiest type of server to set up and it's easy to run into errors is everything is not set up exactly the way it has to be.

Review Source: Capterra
 

Tyler from Food & Beverages

November 2017

November 2017

SQL Service is a business standard for a reason

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

I've found that using SQL Server has been smooth sailing ever since we've set it up. As long as you know how to use SQL properly, everything should be a walk in the park

Cons

No real negative about Microsoft SQL Server, but rather SQL itself. Learning the syntax may be the only downside, but its a needed requirement

Review Source: Capterra
 


November 2017

November 2017

Advanced rdbms but performance and backwards implementation let it down.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

Easy to install and setup. Some nice features like ability to detach databases.

Easy "wizards" to create availability groups, log shipping etc - in some ways can be more forgiving than other dbmses

Cons

Backwards implementation of transaction logs, and having to schedule backups rather than do continuous archiving.

Log shipping and "replication" functionality implemented in very dodgy way - all hanging off scheduled jobs.

Review Source: Capterra
 

Greg from Golden Frog, GmbH
Number of employees: 51-200 employees Employees number: 51-200 employees

November 2017

November 2017

Industry Standard for Databases

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

As an Analyst it was good to use an industry standard and reliable tool that was relatively easy to use. Code completion in the Server Management Studio works really well, unlike some of the tools for open source equivalent tools. Full functionality vs other DBs like MySQL, so I was able to complete complex tasks at the database rather than reporting layer which sped analysis time up considerably.

Pros

Industry standard, full featured SQL Database.
Reliable code completion in the SQL Server Manager.
Large Community online able to answer questions.
Ability to Pivot data on the fly.

Cons

Generally considered to be a little expensive.
Proprietary standard.
Open Source could provide alternative solution.

Review Source: Capterra
 
 
Write a Review