Microsoft SQL Server
Description de Microsoft SQL Server
Qui utilise Microsoft SQL Server ?
Toutes les entreprises de toutes tailles, à la recherche d'un logiciel de gestion de base de données
Microsoft SQL Server ne vous convainc pas tout à fait ?
Comparer avec une alternative populaire
Microsoft SQL Server
Alternatives à Microsoft SQL Server
Avis sur Microsoft SQL Server
Mohamed
Alternatives envisagées :
Meilleur outil de gestion de base de données - DB
Commentaires : tout simplement ma experience est parfaite avec SQl-server . Je l'utilise depuis près de 2 ans et il a beaucoup aidé dans mon projet de business intelligence. C'est magnifique a utiliser.
Avantages :
SQL-Server est simple à installer et l'utiliser les configurations sont également faciles. Comme il s'agit d'un système de GBD relationnelle, c'est un outil parfait pour les analystes de données. Il permet aux utilisateurs de extraire , tronsformer et télecharger les données requises en quelques secondes. Le produit est livré avec de nombreuses fonctionnalités telles que l'analyseur de requêtes, les services d'intégration, le planificateur de tâches et les services de rapports. De plus, on peut facilement planifier des tâches dans la section des outils de travail, ce qui est également une fonction très utile de cet outil. Vraiment c'est un outil trés efficace pour un processus complet de business Intelligence.
Inconvénients :
En effet, elle occupe plus de stockage de données pour installer le moteur de la BD par rapport aux autres BD SQL. Aussi l'interface et l'espace de travail. Lorsqu'on déplace une partie de l'interface, Il n'est pas très intuitif de la replacer à l'endroit par défaut.
Shaunak
Best, well-known and wide-spread product for SQL.
Commentaires : There are lots of benefits to using MS SQL Server.1) Secure data storage.2) SSMS for data exploration on desktop.3) Awesome public documentation by MS.
Avantages :
Little can I write about this vast product, but to brief each which I find insightful are below:1) Fine-grained role and attribute-based access control. 2) Highly secure and robust ways for authorization and authentication.3) Sync with Active Directory authentication.4) Awesome connectors with data warehousing tools.5) Best data at rest and in transit encryption.6) Dedicated support and advisory.
Inconvénients :
Almost nothing to be pitched here, it is continually being developed and refined for adding better features.My advice would be to learn T-SQL for best usage.
juan jose
Alternatives envisagées :
Microsoft SQL Server for Business
Commentaires : I have 5 years working with Microsoft SQL Server, I have adapted well, I like the functionality it has, the practical way in which you can perform queries, scheduled tasks for my daily and weekly backups are excellent, accompanied by the crystal report, works great, I tried to try other database managers like ORACLE, but I think it is better Microsoft SQL server, to this day, I prefer to work with it.
Avantages :
Personally, I like that the application is easy to use, obviously if you already have time using it and you are familiar with the concepts and terms used, the tools to create backups or schedule tasks to run on specific dates and times is quite good, the price is affordable not too expensive unlike oracle.
Inconvénients :
to install it is a bit time consuming, since you have to configure it on the fly, it does not bring any preconfigured default settings, this takes a little time to the user, to migrate to other operating systems other than windows, you have to make other extra configurations.
Wilmer Josué
SQL Server as a primary tool for developers
Commentaires : I have been using SQL server since the first periods of college in my programming classes, as a storage of information I have been taught its practical use both personally and for program development in companies. I find it a very useful and versatile tool, it is used with ease as long as the developer has studied enough information about sql server because a novice and a pro can delete by mistake a whole database, you have to be careful because there are no request messages to deny the deletion. To use the tool I recommend to practice a lot and to comment the coding.
Avantages :
What I liked about the tool is the practical use it has, it can be used by novices in an easy way, as long as someone teaches them the basics, it is very useful on a daily basis due to the management of databases and their respective migration to other platforms. The management of the information becomes useful, it is versatile to changes before, during and after the development of the project.
Inconvénients :
What I liked least is the interface and the work area because when moving a part of that interface it is not very intuitive to place it to the default place, I have had problems with that and also that for processes of adding data I find the work space very small.
Guillermo
A good choice as a database manager, but it can be improved.
Commentaires : It is good software, as I mentioned before. It syncs well with other Microsoft tools. In almost 2 years of use, I feel comfortable when working with this software. I hope that the improvements I mention in the negative points will be included. Otherwise excellent.
Avantages :
I like that it allows me to use my Windows login credentials as user authentication to connect to the server. Plus it integrates easily with other Microsoft programs such as Visual Studio 2022, Business Intelligence tools, etc. I am a Software Engineering student, and I have been testing many database managers. Of all the ones I have used Microsoft SQL Server is the easiest to install and very intuitive regarding the use of its tools. In addition to being a student, I give small tutorials on how to use the software, such as tips for new users, and database backup.
Inconvénients :
I don't have much to criticize in this space. For me, the Software is very complete. But if I would like you to implement a dark theme throughout the interface, it would be very helpful to rest your eyes and avoid fatigue after hours of work.
