Avis clients sur Microsoft SQL Server

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.

L'un des meilleurs systèmes de gestion de base de données disponibles

Commentaires : J'utilise SQL Server depuis plusieurs années maintenant. Je l'ai vu employé sur des projets de taille et de domaines très différents, sur des architectures on premise et cloud. Il est très polyvalent.

Avantages :

Microsoft SQL Server est très complet. Il s'intègre avec tous les outils Microsoft relativement facilement. Il possède toutes les fonctionnalités qu'on attends d'un système de gestion de base de données de cette envergure. Il est disponible en version on premise et dans le cloud (notamment sur Azure). De nombreux outils permettent de le manipuler (Management Studio, Visual Studio, Visual Studio Code, les outils RedGate...). Il est plus facile à appréhender, installer et gérer que son concurrent Oracle Database.

Inconvénients :

Microsoft SQL Server est plus complexe à mettre en place et le gérer efficacement est un véritable métier. Pour un projet assez léger, il faudra se tourner vers d'autres outils mais quand il s'agit d'un projet important qui va monter en puissance, il s'en sort très bien.

Parfait outil de gestion de base de données

Commentaires : Je l'ai utilisé pour un projet de fin d'étude et il m'a beaucoup aidé pour la conception de la base de données.

Avantages :

Microsoft SQL Server est un logiciel fiable et stable. Il propose des fonctionnalités de sécurité avancées pour la protection des données. Un puissant logiciel d'analyse de données.

Inconvénients :

Ne supporte pas NOSQL. Un système de gestion de données complexe. Consomme beaucoup en ressources.

Avis - Microsoft SQL Server

Avantages :

Le système de gestion de base de données de Microsoft est vraiment facile à manager ! C'est un logiciel qui est stable et fiable, et qui propose de nombreuses fonctionnalités notamment sur la sécurité des données. Donc pour moi, il s'agit un superbe logiciel !

Inconvénients :

La consommation de mémoire est juste folle comparée aux anciennes version du logiciels.

Bon SGBD simple à implémenter

Avantages :

Le SGBD est facile à implémenter et surtout compatible avec tous les logiciels/progiciels Microsoft Interface utilisateur pour requêtes SQL ok

Inconvénients :

Je ne trouve pas que ce soit le logiciel le plus performant comparé à certains de ces concurrents Fonctionne très bien avec des outils Microsoft mais plus compliqué avec des outils d’autres éditeurs

SQL Server est très puissant

Commentaires : très satisfait.

Avantages :

La robustesse. Très facile à manager avec SQL server management studio. facile d'utilisation avec microsoft visual studio

Inconvénients :

disponible seulement sur Windows. A part ça tout est propre.

c'est l'un des meilleur système de gestion de base de données pour moi

Commentaires : pour moi c'est à la portée

Avantages :

- la bonne gestion de l’accès aux données grâce au système de vue- Le traitement intelligent des requêtes qui est disponible par défaut sur les dernières versions.- Coût moins cher par rapport aux autres SGBD

Inconvénients :

- le prix élévé pour les versions enterprise et pour les petite enterprises c'est trop cher pour démarrer

Microsoft

Avantages :

Le logiciel me permet de surveiller mon entreprise, d'avoir une base de donnée solide

Inconvénients :

Ce logiciel est à la portée de tous et pour l'instant je n'ai pas encore rencontrer de difficulté.

Un logiciel extraordinaire !

Commentaires : Ce logiciel ma permit de créer des bases de données et des requêtes SQL au seins de mon entreprise

Avantages :

Ce logiciel est parfait pour créer une base de données ou des requîtes SQL

Inconvénients :

Aucun inconvénient rencontré durant l'utilisation de ce logiciel

Data Management made so easy with MS SQL Server

Avantages :

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.

Inconvénients :

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.

Microsoft RDBMS Solution

Commentaires : Whenever I need to rely on a robust DBMS for any of my platforms, provided that my clients have the financial muscle to support it, I always recommend going with SQL Server. So, in that sense, I can say that my overall experience is remarkable all over the years I have been deploying solutions backed up by this Database System.

Avantages :

Among the most interesting features of Microsoft SQL Server we can disclose the following: Robust & Secure System Easy to Deploy Performance+ Integration with Public Cloud such as Microsoft Azure

Inconvénients :

As many of Microsoft Premium products, SQL Server license is really expensive.

A Great Start To Database Management

Commentaires : Microsoft SQL Server software has many facets, more positive than negative. But it is undoubtedly one of the favorites of web developers and internet marketers. Since it is ideal for database management and has warranty. On the other hand you can have many tools to optimize its operation, which you can equate to multiple useful guides provided by the same company.

Avantages :

Is quite secure, it guarantees the security of the databases, it is very easy to configure unlike other database management programs, the installation and configuration is easier. And it also has data recovery support.

Inconvénients :

Cost, there is a free version that can be used, however for more advanced data-driven applications and functions, you will need to make a considerable investment in higher versions of the software. Also, additional investments in Microsoft software may be necessary if your company uses some or no Microsoft infrastructure.

Microsoft SQL review

Commentaires : Very good - best relational DB application for running on Windows

Avantages :

It works well with all Microsoft platforms

Inconvénients :

Backing up to shared drive using Legato was time consuming

A robust database engine with high information security standards.

Commentaires : At the moment we have no negative features to add to the product

Avantages :

How safe this database engine can be, its integration with other technological tools, say, programming languages, infrastructure, datawarehouse and more

Inconvénients :

A bit the price, since the enterprise license is a bit expensive

Best database management tool for relational databases

Commentaires : I would recommend it to all low-scale and small organizations that are already using MS Office products or subscriptions. Its interface is similar to learn and use like other Microsoft software. Enterprise and large corporates can look into Oracle services if they require specific Oracle-made enterprise functions and features to handle very complex data.

Avantages :

First and foremost, it has all the features and functionality from the basics to advanced users for relational database management. Can be integrated well with other Microsft software especially Visual Studio code for a smooth development experience. Along with data storage management, professional performance analysis can be performed through GUI server management studio tools like Database Tuning Advisor. Data Analysts will find data extraction and filtration as well as visual & interactive report generation quite beneficial in their routine tasks. Backup and restore from one SQL server to another is fairly simple. Pricing is very reasonable according to the DBMS system and tools that are provided.

Inconvénients :

One of the main issues is that licensing price packages are difficult to choose due to confing choices for common users. One other limitation is that a backup made in a newer version of MS SQL server is not compatible with an older version of SQL Server. For large volumes of data records and for complex data it becomes slower to process queries. Taking backup of a very large number of records also takes time. Sometimes difficult to debug syntax errors.

SQL is getting better as it grows older

Commentaires : 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!

Avantages :

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.

Inconvénients :

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.

The Only Enterprise Level DBMS I Use

Commentaires : We build enterprise level SAAS, Desktop, Web and Mobile applications and API's. I've been SQL Server for over a decade mainly as a DB Developer but at times as an administrator as well.

Avantages :

A mature DBMS with no limits. Anything we or our customers wanted has always been possible with SQL Server. First class security, speed, and connection capabilities have enabled us to create world class applications for desktop, mobile, and web. The SQL Server community is huge which is critical for those new or rarely used features. I've been working in SQL Server for over a decade and still haven't touched many of the features available. Having a robust community makes learning any new feature quick and easy!

Inconvénients :

It's not a SQL Server thing per se... but Microsoft's support in general is weak at best. I've never really had a good experience using Microsoft support as it is slow and cumbersome and many times the reps don't communicate well. The huge community is what really what makes all Microsoft products manageable as most anything you want to learn or figure out is a quick browser search away.

A great database system for any purpose

Commentaires : We use SQL Server for a data warehouse project in a large bank. It stores thousands of tables and terabytes of data, so it's mandatory for DBMS to run smoothly. SQL server does its job extremely well.

Avantages :

SQL server is packed with features. It was a very fun job to implement it and using it is even better. Runs well, built-in tools are useful and plenty.

Inconvénients :

It takes up quite a bit of resources. Sometimes, tech support isn't very helpful. Otherwise, it's good.

SQL Server : Best database I have ever seen .

Avantages :

User friendly interface, extensive documentation , large community support , automatic backups, overall robust performance

Inconvénients :

Nothing as such. Till this time SQL is great to use and deploy.

This sequel is better

Commentaires : Once SQL Server in Azure was selected, it proved to be a great experience. Security, performance and usability was ironed out for us already. We could focus on building our application rather than learning something new about cloud security or how to use a new type of database or database language variation. We have been pleased with the ability to research performance and include other features such as SSIS to accomplish our business requirements easily. Knowing that manual tasks are being completed automatically is a sigh of relief. We also will know immediately if there are any issues. We have had a great experience with SQL Server.

Avantages :

It is an industry standard that continues to improve to make the lives of developers easier. We are able to produce software solutions more efficiently because Microsoft continues to improve SQL Server. We rely heavily on this as critical to our business. Developers tell me how flexible SQL Server is also. SQL is more compatible with software packages than other competing databases.

Inconvénients :

Parts can be not intuitive unless you've been using it for awhile. It is a technical piece of software that requires time and training. If you need the Enterprise edition for specific features, it is expensive.

Rock solid, reliable and efficient database

Commentaires : We have enjoyed using SQL Server for various OLTP and data warehousing workloads. It is a workhorse. Its performance is fantastic. Tooling surrounding it is great. We have not encountered a single issue with it. We also have a great local meetup where we discuss the constant improvements SQL Server brings each year.

Avantages :

We love SQL Server's versatility. Every single application we purchase for insurance has support for SQL Server. We have not come across any situation where SQL Server didn't meet our needs.

Inconvénients :

License models are a bit confusing. Some years Microsoft make it easy to understand. Other years Microsoft makes it even more confusing. Can we run SQL Server in our data centers? Can we run it on the cloud? Do we need to change licensing to run in the cloud? Those questions sound easy to answer but the answers we get from Microsoft or resellers confuse us more. It just seems like the confusion is intentional.

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.

A leading and innovative data solution

Commentaires : My personal experience has been very positive once I was able to dive into the product dashboard, look into online training and guides that helped provide a lot of great insight into how to we get the most out of the platform and learn about the latest releases and features to help us keep up to speed on the latest capabilities available to use and try out.

Avantages :

The ability to visualize data, connect data from different sources and track activity and data usage/storage has allowed our organization to be successful in how we meet our objectives from a technical, data delivery and performance optimization standpoint.

Inconvénients :

There were times early on in the deployment and on-boarding process where it was difficult to get quality technical support, which created a few small hiccups early on, but eventually was cleared up once we connected with our solutions engineer who connected us with the right resources and training materials.

SQL Server | The Gold Standard

Commentaires : Overall, I have had an excellent experience with SQL Server. It is cost-effective, provides a great deal of functionality, and is a great piece of software for database management.

Avantages :

In my current role as an Application Manager, it is vital to have a means of benchmarking and assessing application performance. The tools within SQL Server, particularly Activity Monitor, make it very easy to determine when performance bottlenecks arise.

Inconvénients :

I believe the default alerting functionality could be improved. For example, I believe it would make more sense to alert the user to any failed SQL Agent jobs when launching SSMS. Currently, either alerts need to be set up individually or the user would need to view the job history.

The absolute core of our business

Commentaires : Our overall experience with SQL Server has been formidable. This is the reason that it has been at the center of our business since we outgrew an Access central database over 20 years ago.

Avantages :

Installation and upgrading of the software is excellent. The additions of Query Store and other Analytics have drastically changed our ability to monitor the performance of all metrics of our Databases.

Inconvénients :

Turn around time from issuing the Purchase Order until the license is released into our Microsoft account was rather slow, when we needed the software, we had to find an alternative solution until our license was released to us.