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.
Options de tarification dès :
931,00 $US/unique
- Essai gratuit
- Licence unique
- Version gratuite
- Open source
Comparer avec les alternatives populaires
Appareils
Pour quelle entreprise ?
Options de tarification dès :
931,00 $US/unique
- Essai gratuit
- Licence unique
- Version gratuite
- Open source
Comparer avec les alternatives populaires
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
Tableau
Improvado
Caspio
ClicData
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é: Services et technologies de l'information
- Taille de l'entreprise: 11-50 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 9.0 /10
Data Management made so easy with MS SQL Server
Publié le 20/03/2020
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.
- Secteur d'activité: Organisme politique
- Taille de l'entreprise: 201-500 employés
- Logiciel utilisé tous les jours pendant plus de deux ans
-
Provenance de l'avis
Note globale
- Simplicité d'utilisation
- Support client
- Probabilité de recommander le produit 9.0 /10
SQL is getting better as it grows older
Publié le 21/11/2019
SQL Server centralized my data and allows my staff to "believe" that they are working in Excel, It...
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.
- 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: 5 001-10 000 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 4.0 /10
Easy solution for data management
Publié le 28/03/2021
I have been using sql server for almost 10 years.
It has become indispensable tool in my software...
I have been using sql server for almost 10 years.
It has become indispensable tool in my software development career.
Avantages
I found SQL server user interface undoubtedly most easy and functionality wise very rich. From database creation to analysis it provides one click operations that has made my life easy. Although, I am web developer but thanks to sql server I can easily handle and work on databases.
Inconvénients
I have trust issues with Data restore functionality. Most of sql server backup fails most of time because of multiple issues.
- Secteur d'activité: Fabrication électrique/électronique
- Taille de l'entreprise: 2-10 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 10.0 /10
There's a reason why most people choose SQL Server over other database softwares
Publié le 27/12/2020
I have never had any problems with SQL Server. It was always efficient and capable of doing...
I have never had any problems with SQL Server. It was always efficient and capable of doing whatever needed to be done.
Avantages
Security is one of the most important aspects of database software since sensitive information can be stored in databases. SQL Servers are some one of the most secure servers out there so data is safe from hackers.
The scaling aspect of this software is great so whether your business is very small or very large that uses huge amounts of data to be stored, SQL servers can scale and use appropriate resources to handle databases therefore no lagging issues and problems querying databases etc. which makes it extremely fast and efficient.
With the large community that uses SQL Server, you have answers to almost all questions that you may have if you encounter any difficulties setting up or using the software, so troubleshooting is made really easy.
Inconvénients
Cost could be an issue as this software could be a bit expensive however with that being said, you definitely will get quality.
Also there might be certain compatibility issues with other non Microsoft software that your company may use so in some cases you might have to switch over to Microsoft softwares in your company depending on what they are.
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: Licence unique, Gratuit, Open source
- Essai gratuit: Disponible
SQL Server offers a 180-day free trial for new users, after which the software is available across various pricing tiers, details of which are outlined below - • Enterprise - $13748 • Standard (per core) - $3586 • Standard (server) - $899 • Standard (CAL) - $209 • Developer – Available to users for free • Express – Available to users for free Additional cost for subscriptions and add-ons include - • SQL Server Enterprise - $5434/year • SQL Server Standard - $1418/year • Big data node cores - $400/year
Q. Quelles sont les principales fonctionnalités du logiciel Microsoft SQL Server ?
Nous n'avons pas d'informations sur les fonctionnalités de Microsoft SQL Server.
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 ?
Nous n'avons pas d'informations sur les langues prises en charge par Microsoft SQL Server.
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.
