Microsoft SQL Server - BI Edition


Microsoft SQL Server - BI Edition Logo

 

1314 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

1314 Bewertungen über Microsoft SQL Server - BI Edition

 

Surender B. Branche: Informationstechnologie & -dienste Anzahl der Mitarbeiter:  13-50 Mitarbeiter Mitarbeiteranzahl:  13-50 Mitarbeiter

16.5.2019

16.5.2019

Quelle der Bewertung: Capterra

Best DBMS tool for scalable enterprises

Übersetzen nach: Deutsch
Bedienkomfort

 

Funktionalität

 

Produktqualität

 

Preis-Leistungs-Verhältnis

 

Kundenbetreuung

 

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

My overall experience is 100% satisfactory because of its robust feature.

I recommend this to all either its a large or small scale compan y because SQL server can handle large quantities of data and process it smoothly. Just loving it.

Vorteile

Microsoft SQL server is one of the best database management system that provide top rated performance optimisation with SQL queries, below is the list of top highlights:

1. Richness of user interface that provides ease of use with cool features like dock able windows.

2. Intelligence window is prominent feature that saves a lot of development time up to large extent.

3. Code debugging and performance tuning with query flow maps is the best features that assures about code optimisation.

4. Microsoft SQL Server Agent is provided with this software and that runs the automatic jobs in very secure way and later we can track the statements executed.

5. We can filter out the records in SQL Server Agent interface based on our interest.

6. Code snippet manager makes it easy to write high standard code that is perfact for code convention.

7. Most prominent feature is that it can handle large quantities of data, runs automatic jobs with concurrent transactions.

8. At last it's a Microsoft product that provides a belief to users.

Nachteile

I have been using SQL server from version 2012 to 2014 and never troubled with SQL server's performance in any way.

However I feel that error details must long descriptive when statement have some syntax error. Sometime its pathetic when we wants to know the exact error line but is hints the whole block of code instead of exact line number.

Otherwise Its a great product and happy with it.

Aníbal M.

7.7.2018

7.7.2018

Quelle der Bewertung: Capterra

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

Übersetzen nach: Deutsch
Bedienkomfort

 

Funktionalität

 

Produktqualität

 

Preis-Leistungs-Verhältnis

 

Kundenbetreuung

 

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

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

Vorteile

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

Nachteile

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

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

20.3.2020

20.3.2020

Quelle der Bewertung: Capterra

Data Management made so easy with MS SQL Server

Übersetzen nach: 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.

Filipe F. Branche: Informationstechnologie & -dienste Anzahl der Mitarbeiter:  Selbstständig Mitarbeiteranzahl:  Selbstständig

10.3.2020

10.3.2020

Quelle der Bewertung: Capterra

SQL Server review

Übersetzen nach: Deutsch
Bedienkomfort

 

Funktionalität

 

Produktqualität

 

Preis-Leistungs-Verhältnis

 

Kundenbetreuung

 

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

SQL server is great, because i can use the same language same application, and for small customers it uses free option, and only for best performnace or bigger data need to pay for it
Can use it locally on on cloud

Vorteile

SQL Server is a great system to develop databases with great functionalities like jobs, procedures, functions ans so one

Nachteile

For me the only think not so good is performance for bigger batabases, but for me between 10GiB and 15GiB works fine

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

19.9.2019

19.9.2019

Quelle der Bewertung: Capterra

Easy and Fast for Development

Übersetzen nach: 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