Microsoft SQL Server BI Software

Pros

We use SQL on our servers to run the databases from our ERP software and everything runs very smoothly and securely.

Cons

Learning how to report write and utilize the full potential of this software requires a lot of learning.

Pros

This database management tool is a full package because it has a lot of features that is very helpful for our team and it makes us easy to handle our database and design its structures.

Cons

Maybe there is a bit curiousity at first on how this DBM tool works compare to other but somehow when you explore it you can see all of its important use and its new features.

Pros

This database managenent tool security and it's efficiency to manage tables structure and data are great! You can also manage multiple database connection using this tool.

Cons

I don't have anything to say about this DBM tool because this is great! It is helpful and very efficient for us to manage our data to get the desired output.

Pros

The analytics and modeling tools have a very user friendly user interface that allows much less advanced users to create useful reports in an SQL product. SQL BI also includes the powerful query and transformation capabilities common in all sql server editions and necessary for robust BI and analytics including Integration Service for ETL and Report Service for querying and sharing models. These user friendly analytics tools and powerful data prep and data expression tools are integrated relatively seamlessly, and combine to from a product that combines SQLs DB/Query power and systematic product integration with user friendly (but still powerful) data and analytics tools.

Cons

Even this version of sql with some relatively user friendly tools has a pretty steep learning curve and intense resource requirements. In fact, in some ways the nice GUI for tabular modeling is misleading because it seems similar to Excel at first look, but can be deeply discouraging to users when they find out they are nothing alike. Also, no matter how user friendly and integrated the analysis service tools are, you can't avoid writing sql and searching for obscure table names as always.

Pros

This tool provides a secured database connections and it can also handle multiple connections for your database. You can easily manage your data's and dabatase structures.

Cons

If you are first time to use this tool, you really need to explore this and this is actually become useful for your database.

Pros

This database management tool is very useful and efficient because i can easily established database network connection and also to import/export my data if needed.

Cons

it is not easy to change database management tool to another because it takes time to explore new features but this tool doesn't need much time to waste because you can easily learn on how to use this tool.

Pros

This is a powerful dbm tool where you can easily import data's from csv to become structured data and with this tool it also easily to handle or manage the data from your database tables

Cons

I have nothing to say about this tool because i am actually using this database management tool and it is very useful and easy to use for me

Pros

What can't SQL do? Powerful database engine, analytics tools, and ETL capabilities seamlessly integrated with software that is familiar to end users.

Cons

It is not easy to learn. SQL is complicated, and it doesn't necessarily get less complicated as you develop experience. Just try to build an SSIS package for the first time after 10 years of experience with SSAS or database features.

Pros

The Microsoft SQL server works perfectly well with the Sage Enterprise Resource Management (X3) software.

Cons

Sometimes the SQL server will get a random glitch that will cause an unwanted error. This sometimes messes with the X3 program too.

Pros

Is an excellent tool, easy to maintain and simple to create jobs, stored procedures, views, analysis of data.

Cons

The cost of the licensing is too much, this is the only downside I have found with Microsoft products but for everything else are great.

I would recommend this software. It is a little expensive, but if you have the capital to so do, invest in this. It is easy to use and does an exceptional job of analyzing data.

Pros

Nice Interface
Easy to Use
Great for data analytics
Great for Reporting
Great software for someone who isnt an expert

Cons

There are a lot of features, but theres so many its hard to find them all. Some features are hidden under drop down menus

Pros

Microsoft SQL is a versatile tool that can support organizational analytics and business intelligence

Cons

this product is rather complex and requires SQL experience in order to use. Some robust usability testing may reveal opportunities to enhance the queries to be more user-friendly.

I would recommend this product even for small businesses.

Pros

Easy to manage database even if our databases are stored in different areas in the system, easy to navigate and to run queries.

Cons

A little expensive. It would help to improve user interface and make it easier for non technical users like me.

Pros

This is a great program, and deep down, it has all the functions and features you'd ever want from a program like this

Cons

A lot of features and functionality is hidden below loads and loads of dropdown menus and subfolders, which makes it hard to find sometimes

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.

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.

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.

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.

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

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