Microsoft SQL Server
En savoir plus sur Microsoft SQL Server
SQL Server is a relational database management system (RDMS) designed to help businesses of all sizes analyze structured or unstructured data across various data environments including Azure SQL Database, Azure Cosmos DB, MySQL, and more. It enables administrators to track the performance of databases, monitor data lakes, and handle data warehousing operations on a unified platform.
Features of SQL Server include multi-language support, compliance management, data classification, automated alerts, full-text search, and more. It allows software developers to manage big data environments and deploy data clusters of containerized instances of Apache Spark and Hadoop Data File System (HDFS). DevOps teams can also utilize in-memory database capabilities to track the performance of business workloads.
SQL Server provides extract, transform, and load (ETL) capabilities, which enable users to extract business data from various sources, create custom workflows, execute aggregation, deduplication, or merging of data, and export the transformed data into destination databases or files. It allows employees to store digital objects including dynamic management views (DMVs), procedures, indexes, constraints, and transaction logs in a centralized repository.
Appareils
Pour quelle entreprise ?
Disponible dans les pays suivants
Langues
Images
Fonctionnalités
Nombre total de fonctionnalités pour Microsoft SQL Server : 32
- API
- Analyse ad hoc
- Analyse des performances
- Analyse prédictive
- Analyse visuelle
- Base de données de contacts
- Benchmarking
- Connecteurs de données
- Extraction de données
- Gestion de la conformité
- Gestion des documents
- Gestion du stockage de données
- Importation et exportation de données
- Mappage de données
- Mesure des performances
- Migration de données
- Outils de collaboration
- Profilage de données
- Rapports ad hoc
- Rapports et analyses
- Rapports et statistiques
- Recherche en texte intégral
- Recherche/Filtre
- Requête ad hoc
- Requêtes
- Sauvegarde et récupération
- Suivi des serveurs
- Synchronisation de données
- Tableau de bord
- Transformation des données
- Visualisation de données
- Vérification de données
Alternatives
Improvado
Synerise
Caspio
Qrvey
Avis
Vous avez déjà Microsoft SQL Server ?
Les acheteurs de logiciels ont besoin de vous ! Les avis utilisateurs nous aident tous à prendre de meilleures décisions.
Donnez votre avis !
- Secteur d'activité: Logiciels
- Taille de l'entreprise: 51-200 employés
- Logiciel utilisé tous les jours pendant plus de deux ans
-
Provenance de l'avis
Note globale
- Rapport qualité-prix
- Simplicité d'utilisation
- Support client
- Probabilité de recommander le produit 10.0 /10
MSSQL is good and well supported
Publié le 22/01/2021
Overall experience with Microsoft SQL Server is good throughout with no major issues.
Overall experience with Microsoft SQL Server is good throughout with no major issues.
Avantages
I found it quite easy to install, setup and operate. It is supported by almost all programing languages. The interface is simple and user friendly. I found it safe to be accessed remotely. The visualization of data and retrieving data from different sources is found good. The functionalities like Jobs, Stored Procedures, Functions and Views enhance the database development / management experience.
Inconvénients
Performance issues faced with large databases. With every version, the license model changes which make it complex.
- Secteur d'activité: Banque
- Taille de l'entreprise: 501-1 000 employés
- Logiciel utilisé tous les jours pendant plus d'un an
-
Provenance de l'avis
Note globale
- Rapport qualité-prix
- Simplicité d'utilisation
- Support client
- Probabilité de recommander le produit 9.0 /10
SQL Server
Publié le 25/06/2021
Overall experience is just amazing. I have been using it for almost 2 years and it helped my...
Overall experience is just amazing. I have been using it for almost 2 years and it helped my organization a lot during release upgrade and it made database migrations so smooth.
Avantages
Microsoft SQL is quite simple to install and configurations are also easy. As it is a relational database management system, it is a perfect tool for data analysts. As it enable users to filter and extract required data in a few seconds. The product comes with a lot of features like Query analyzer, Integration services, Job scheduler and Reporting services as well. Restoration and backup of multiple databases is a great advantage and I found this feature very useful because it helps a lot in restoring databases in case of any disaster. Also, one can easily schedule tasks in job tools section which is also a very helpful feature of this tool.
Inconvénients
Well, it occupies more data storage in order to install database engine as compared to other SQL databases. Also, support is pretty much expensive and requires a lot of maintenance. It consumes too much resources to load and start.
- Secteur d'activité: Bibliothèques
- Taille de l'entreprise: 2-10 employés
- Logiciel utilisé tous les jours pendant plus de deux ans
-
Provenance de l'avis
Note globale
- Simplicité d'utilisation
- Probabilité de recommander le produit 7.0 /10
SQL Server as a primary tool for developers
Publié le 18/06/2021
I have been using SQL server since the first periods of college in my programming classes, as a...
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.
- Secteur d'activité: Assurance
- Taille de l'entreprise: 51-200 employés
- Logiciel utilisé tous les jours pendant plus de deux ans
-
Provenance de l'avis
Note globale
- Rapport qualité-prix
- Simplicité d'utilisation
- Support client
- Probabilité de recommander le produit 10.0 /10
Rock solid, reliable and efficient database
Publié le 07/04/2021
We have enjoyed using SQL Server for various OLTP and data warehousing workloads. It is a...
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.
- Secteur d'activité: Logiciels
- Taille de l'entreprise: 2-10 employés
- Logiciel utilisé tous les jours pendant plus de deux ans
-
Provenance de l'avis
Note globale
- Rapport qualité-prix
- Simplicité d'utilisation
- Support client
- Probabilité de recommander le produit 10.0 /10
The Only Enterprise Level DBMS I Use
Publié le 21/07/2021
We build enterprise level SAAS, Desktop, Web and Mobile applications and API's. I've been SQL...
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.
Microsoft SQL Server - FAQ
Voici quelques-unes des questions fréquentes sur Microsoft SQL Server.Q. Quels sont les types de licence disponibles pour Microsoft SQL Server ?
Types de licences disponibles pour Microsoft SQL Server :
- À partir de: 931,00 $US/unique
- Type de licence: Version gratuite
- Essai gratuit: Disponible
Q. Qui utilise Microsoft SQL Server ?
Utilisateurs habituels du logiciel Microsoft SQL Server :
Auto-entrepreneur, 2-10, 11-50, 51-200, 201-500, 501-1 000, 1 001+
Q. Dans quelles langues Microsoft SQL Server est-il disponible ?
Langues dans lesquelles Microsoft SQL Server est disponible :
anglais
Q. Microsoft SQL Server prend-il en charge les appareils mobiles ?
Appareils pris en charge par Microsoft SQL Server :
Q. Avec quelles applications Microsoft SQL Server peut-il s'intégrer ?
Applications s'intégrant à Microsoft SQL Server :
Microsoft Azure, MySQL
Q. Quelles sont les ressources d'aide disponibles pour Microsoft SQL Server ?
Ressources d'aide disponibles pour Microsoft SQL Server :
Service client/e-mail, FAQ/forums, Base de connaissances, Support téléphonique, Service de support 24/7 (réponse directe), Chat
Catégories connexes
Consultez toutes les catégories de logiciels trouvées pour Microsoft SQL Server.
