Microsoft SQL Server - BI Edition


Microsoft SQL Server - BI Edition Logo

 

1395 Bewertungen (4,5/5)
 

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
Unterstützte Betriebssysteme:
Windows 7, Windows Vista, Windows XP, Mac OS, Linux, HP-UX, AIX, Solaris, Unix, IBM OS/400, Webbrowser (OS-agnostisch), Windows 2000, Window 8, Windows 10

1395 Bewertungen über Microsoft SQL Server - BI Edition

 

Kudakwashe N. Branche: Informationstechnologie & -dienste Anzahl der Mitarbeiter:  11-50 Mitarbeiter Mitarbeiteranzahl:  11-50 Mitarbeiter

20.3.2020

20.3.2020

Quelle der Bewertung: Capterra

Data Management made so easy with MS SQL Server

Übersetzen auf: Deutsch
Bedienkomfort

 

Funktionalität

 

Produktqualität

 

Preis-Leistungs-Verhältnis

 

Kundenbetreuung

 

Bedienkomfort
Bedienkomfort
Funktionalität
Funktionalität
Preis-Leistungs-Verhältnis
Wert
Kundenbetreuung

Vorteile

For any developer, before first they can this own what their apps are going to be developed in their should think of what server should host their database. I do believe that MS SQL Server is the best on the marketing when comes to data management and administration. The best feature that i really love the most on MS SQL Server is the ability to disable remote execution of your queries and really helps protect data integrity in case your server authentication has been compromised. You can also be rest assured that your data is consistent and accurate at all times. Yes hackers some times can try sql injection but i believe MS SQL Server its the most secure servers around.

Nachteile

The license key for MS SQL might cost you an arm and a leg but at the end of the day its really worth it when you think of a platform where you are able to develop enterprise apps that secure and helps with Business Intelligence.

Imi C. Branche: Politische Organisation Anzahl der Mitarbeiter:  201-500 Mitarbeiter Mitarbeiteranzahl:  201-500 Mitarbeiter

21.11.2019

21.11.2019

Quelle der Bewertung: Capterra

SQL is getting better as it grows older

Übersetzen auf: Deutsch
Bedienkomfort

 

Funktionalität

 

Produktqualität

 

Kundenbetreuung

 

Bedienkomfort
Bedienkomfort
Funktionalität
Funktionalität
Kundenbetreuung

SQL Server centralized my data and allows my staff to "believe" that they are working in Excel, It is super fast for loading data from the server, and allow large data set that will normally take hours, or even crash the Excel spreadsheet to load without any issue.
When I am ready for a web app.. SQL server is easy as piece to develop a simple CRUD application and push live.
It seem to connect to every thing - from MS Word Mail merge, MS Excel, MS Access and of course for development environment such as Visual Studios.
One Database ( Centralized) and many presentation modes for the end users. I love it!

Vorteile

MS SQL Server is certainly a competently relational database engine, with reporting service and now R.
Easy to install for small onpremise application.
Easy to administer, easy to backup, easy because it is a Microsoft application.
It is so easy that most of the application today I work on seem to be pulling data from SQL into Excel and or Power BI.
You can start from free version and expand as time goes by.
The management studio take the pain our of scripting, and the online support community most likely have your questions answered with T-SQL scripts for copy and pasting.
If you deciding on an option for an Relational Database system - you should look at this as your most productive option. It allows you to focus on the problem by making the technology easy.

Nachteile

The new the version, the more memory intensive this management studio will become.
Microsoft need to create some more easy to use tool for change control and change tracking.
Backward compatibility - if you used a higher version during development, then it become a pain to use a lower version during production environment.

Prabhu S. Branche: Informationstechnologie & -dienste Anzahl der Mitarbeiter:  10.000+ Mitarbeiter Mitarbeiteranzahl:  10.000+ Mitarbeiter

29.8.2020

29.8.2020

Quelle der Bewertung: Capterra

All time market leader

Übersetzen auf: Deutsch
Bedienkomfort

 

Funktionalität

 

Produktqualität

 

Bedienkomfort
Bedienkomfort
Funktionalität
Funktionalität

When comes to business critical it can consume the raw data, process it and provide to the user understandable format. More than decades, this software providing tremendous help to business to evolve and reach their goals by fetching data from any formate and load it into structured form and with help of powerful Tsql query languge we able to fetch the right data from database. We can also connect with any visualization tool to provide the better UI(Power BI) to users to take right decision.

Vorteile

1. Optimized storage and querying business critical data.
2. Powerful Tsql Query language.
3. Query execution plan to predict and optimize the data.
4. Query profiler to find out anomaly and query latency.

Nachteile

1. We need to take care of all patching works.
2. We need to take care of all infrastructure scalability(RAM,HDD and IO etc)
3. Server maintenance and outrage time is high.

Vikash kumar S. Branche: Industrieautomation Anzahl der Mitarbeiter:  10.000+ Mitarbeiter Mitarbeiteranzahl:  10.000+ Mitarbeiter

19.9.2019

19.9.2019

Quelle der Bewertung: Capterra

Easy and Fast for Development

Übersetzen auf: Deutsch
Bedienkomfort

 

Funktionalität

 

Produktqualität

 

Preis-Leistungs-Verhältnis

 

Kundenbetreuung

 

Bedienkomfort
Bedienkomfort
Funktionalität
Funktionalität
Preis-Leistungs-Verhältnis
Wert
Kundenbetreuung

Vorteile

MS SQL makes your life easy by bringing SQL Management tool
easy to create new database on the fly.
Free express Database for development purpose
Easy to troubleshoot performance issue,.
Same SQL can be published to azure or get the same feeling on Azure.
Most used database

Nachteile

When DB size grow large then it leads to performance issue.
these days in world on No SQL database, ppl tend more use other kind of DBS

Atir Z. Branche: Computer-Software Anzahl der Mitarbeiter:  51-200 Mitarbeiter Mitarbeiteranzahl:  51-200 Mitarbeiter

13.7.2020

13.7.2020

Quelle der Bewertung: Capterra

Top level Database Management

Übersetzen auf: Deutsch
Bedienkomfort

 

Funktionalität

 

Produktqualität

 

Preis-Leistungs-Verhältnis

 

Kundenbetreuung

 

Bedienkomfort
Bedienkomfort
Funktionalität
Funktionalität
Preis-Leistungs-Verhältnis
Wert
Kundenbetreuung

With 10+ years of experience in development and management, I have overcome all the problems and resolved many issues with the help of this product and customer support.

Vorteile

With Rational Databases, SQL Server is at best and top-notch. I am a developer and using this product for more than 10 years. with continuous updates, enhancements, and new features it is getting better and better. Mostly likely SQL Server Management Studio is the best and easy way to manage multiple SQL Servers. Microsoft Customer Service is always great and helpful when needed. Definitely the most Secure system available.

Nachteile

Sometimes migration from the lower version or other databases is challenging. Cost-wise is also very expensive.