SQL Server

par Microsoft

4.5 / 5 777 avis
SQL Server

Logiciels les + demandés


Pour qui ?

Toutes les entreprises de toutes tailles, à la recherche d'un logiciel de gestion de base de données

Notes moyennes

777 avis
  • Note globale 4.5 / 5
  • Facilité d'utilisation 4 / 5
  • Service client 4 / 5
  • Fonctionnalités 4.5 / 5
  • Rapport qualité-prix 4 / 5

Informations sur le produit

  • À partir de $931/unique
  • Version gratuite Oui
  • Version d'essai gratuite Non
  • Déploiement Installation (Windows)
  • Formation Formation présentielle
    Webinaires
    Documentation
  • Ressources d'aide Service de support permanent (réponse directe)
    En ligne

Informations sur l'éditeur

  • Microsoft
  • http://www.microsoft.com
  • Fondé en 1975

En savoir plus sur SQL Server

Offre de base de données et d'analyse pour fournir rapidement la nouvelle génération de commerce électronique évolutif et de solutions sectorielles.

Spotlight_media_placeholder

SQL Server - Fonctionnalités

  • Analyse des performances
  • Conversion de bases de données
  • Migration de données
  • Monitoring
  • Optimisation du stockage
  • Requêtes
  • Sauvegarde
  • Traitement analytique en ligne
  • Accès mobile
  • Analyse des performances
  • Conversion de bases de données
  • Migration de données
  • NOSQL
  • Relationnel
  • Requêtes
  • Réplication de données
  • Sauvegarde et récupération
  • Sécurité des données
  • Virtualisation

Avis les plus utiles sur SQL Server

SQL Server 2016 - Features Review

Traduire avec Google Translate Publié le 20/12/2018
Senior Consultant
Hôpitaux et soins de santé, 10 001+ employés
Temps d'utilisation du produit: plus de deux ans
Provenance de l'utilisateur 
Source : asdf
4/5
Note globale
5 / 5
Facilité d'utilisation
5 / 5
Fonctionnalités
4 / 5
Support client
3 / 5
Rapport qualité-prix
Probabilité de recommander le produit :
Très faible Très élevée

Commentaires: Overall experience with SQL server 2016 is very nice and excited in my perceptions due to Better support for memory optimzed tables, Built in JSON support, Stretch DB concepts, Query Store and dynamic temp db according to size and presence of CPU in the databases.

Avantages: In our project we have been migrated from Microsoft SQL Server 2008 to SQL server 2016 directly for all our databases & SSIS packages. There are many features that was available to use for the projects and some of those are: 1. Data was always encrypted, so less vulnerable to SQL injections and useful to take a backup when database is in motion. Prior version (Before SQL server 2016) support only when databases is in Rest.
2. Data/Software Migration is very useful from prior version without any issues or taking any time. It took only set of testing activities and 2 hours of trun around time to get it upgraded.
3. Very simillar like XML TSQL clause created in SQL 2005, in SQL 2016 JSON clause T-SQL has been created for JSON output from querying database objects.
4. In prior versions we have to wait for long running query to capture, however in SQL server 2016 ability to view the execution plan as the query is active on the system.
5. Strecth Database is a new concept that has been created and stored in Azure. However in the background it is shown as single databases for user views.

Inconvénients: Only I know very least number of disadvantages this MS SQL server 2016 is having: 1. Enterprise pricing may be costly as some of the organisation cant afford for the count of data they are having.
2 With the performance tuning, Microsoft SQL Server will be having some gobble resources.

Easy to configure, difficult to master

Traduire avec Google Translate Publié le 17/10/2018
Systems Engineer
Services et technologies de l'information, 10 001+ employés
Temps d'utilisation du produit: plus de deux ans
Provenance de l'utilisateur 
Source : asdf
5/5
Note globale
3 / 5
Facilité d'utilisation
4 / 5
Fonctionnalités
5 / 5
Support client
4 / 5
Rapport qualité-prix
Probabilité de recommander le produit :
Très faible Très élevée

Commentaires: Easily the most intuitive RDBMS software out of the box.

Avantages: The most noteworthy features of Microsoft SQL Server are the many tools and wizards that allow even novice users to get started by creating tables and views without extensive knowledge of relational databases. The query wizard can even assist with creating queries with its intuitive IDE. These features lower the intimidating barrier to entry that accompanies other relational database software such as Oracle or MySQL. There is even a free version call Express that allows anyone to dabble in the software before committing to the product. Aside from the user assisted features, the other appealing aspect of SQL Server is the integration with other Microsoft products that are probably already running in an organization. SQL Server interfaces with Active Directory allowing for easy user management so appropriate levels of database access can be allotted via group membership. This is useful because even something simple like user access management in another RDBMS may present a learning curve for anyone that is not a DBA. With SQL Server a general IT resource could manage user access with an existing knowledge of Active Directory providing more time to focus on core database design.

Inconvénients: SQL Server carries a high cost subscription based licensing cost. The user assistance features provide a great introduction to relational databases, but there is still a significant and continuous learning curve. Databases continue to evolve with industry need. Anyone that interacts significantly with SQL Server during day to day database or application design may need to consider yearly training to keep up with all the changes.

Lire d'autres avis