Microsoft SQL Server

4,6 (1 829)
Système de gestion de base de données relationnelle pour l'analytique de données

Note globale

4,6 /5
(1 829)
Rapport qualité-prix
4,3/5
Fonctionnalités
4,6/5
Simplicité d'utilisation
4,3/5
Support client
4,3/5

97%
des utilisateurs recommandent cette application
Classer par

1829 avis

Mohamed
Note globale
  • Secteur d'activité : Logiciels
  • Taille de l'entreprise : 11–50 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

Meilleur outil de gestion de base de données - DB

Publié le 24/08/2021

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.

Alternatives envisagées 

Talend Data Fabric

Pourquoi choisir Microsoft SQL Server 

Pour faire des analyses.

Logiciel antérieur 

Google Analytics 360

Pourquoi passer à Microsoft SQL Server

C'est trés pratique et facile a utiliser.
Utilisateur vérifié
Note globale
  • Secteur d'activité : Vente au détail
  • Taille de l'entreprise : Auto-entrepreneur
  • Logiciel utilisé tous les jours pendant 6 à 12 mois
  • Provenance de l'avis

Note globale

  • Rapport qualité-prix
  • Simplicité d'utilisation
  • Support client
  • Probabilité de recommander le produit 7.0 /10

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

Publié le 12/02/2023

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

Filipe
Note globale
  • Secteur d'activité : Services et technologies de l'information
  • Taille de l'entreprise : Auto-entrepreneur
  • 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

SQL Server review

Publié le 10/03/2020

SQL server is great, because i can use the same language same application, and for small customers it uses free option, and only for best performnace or bigger data need to pay for it
Can use it locally on on cloud

Avantages

SQL Server is a great system to develop databases with great functionalities like jobs, procedures, functions ans so one

Inconvénients

For me the only think not so good is performance for bigger batabases, but for me between 10GiB and 15GiB works fine

Alternatives envisagées 

Oracle Database

Pourquoi choisir Microsoft SQL Server 

SQL server is lot less expensive and have a free option for small aplications or for small customers

Logiciel antérieur 

Oracle Database

Pourquoi passer à Microsoft SQL Server

SQL server is lot less expensive and have a free option for small aplications or for small customers
Kawther
Note globale
  • Secteur d'activité : Rédaction et correction
  • Taille de l'entreprise : 2–10 employés
  • Logiciel utilisé toutes les semaines pendant plus de deux ans
  • Provenance de l'avis

Note globale

  • Rapport qualité-prix
  • Simplicité d'utilisation
  • Support client
  • Probabilité de recommander le produit 7.0 /10

A Reliable RDBMS Alternative for OLTP Systems

Publié le 10/02/2023

Avantages

The approach is flexible and long-lasting, however primary and secondary database synchronization still needs to be enhanced. If the primary and secondary databases are out of sync for an extended period of time, the primary database for whatever reason stops responding or behaves erratically. A forced restart or the reconstruction of secondary nodes from backups may be the main solutions to the issue. MS SQL can be an expensive option given that there are many open-source alternatives available on the market that can provide equivalent functionality but certainly lack the benefits I outlined above.

Inconvénients

Although the solution is adaptable and durable, synchronization between primary and secondary databases still needs to be improved. For whatever reason, the primary database stops responding or behaves abnormally if the primary and secondary databases become out of sync for a considerable amount of time. The problem may mostly require a forceful reboot or the reconstruction of secondary nodes from backups. Given that there are numerous open-source options on the market that can offer comparable functionality but unquestionably lack the advantages I listed above, MS SQL can be a costly offering.

Sergio R
Note globale
  • Secteur d'activité : Internet
  • Taille de l'entreprise : Auto-entrepreneur
  • 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 7.0 /10

Good RDBMS

Publié le 25/06/2022

Avantages

Very easy to implement and integrate with other systems.

Inconvénients

MS SQL Server consumes almost all compute resourses

Alternatives envisagées 

PostgreSQL

Pourquoi choisir Microsoft SQL Server 

Cost

Logiciel antérieur 

Oracle Database
Utilisateur vérifié
Note globale
  • 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 10.0 /10

MS SQL Server Review

Publié le 15/01/2023

I love it, it is my first personal preference. And I love teaching others using Microsoft SQL server because it's easily understood.

Avantages

It is easy to use for data transfer and data retrieval.It enables you to create stored procedures and views.There is security for data storage, backup, and restoring your databases.

Inconvénients

When there's a large amount of data in the database it tends to slow down the speed of fetching data

Edris
Note globale
  • Secteur d'activité : Comptabilité
  • Taille de l'entreprise : Auto-entrepreneur
  • Logiciel utilisé tous les jours pendant Essai gratuit
  • Provenance de l'avis

Note globale

  • Rapport qualité-prix
  • Simplicité d'utilisation
  • Support client
  • Probabilité de recommander le produit 8.0 /10

Microsoft SQL Server the best software for database.

Publié le 10/02/2023

At the moment, I use SQL Server to maintain the databases at Sonic Drive-Ins all over the United States, as well as to fix late ticket times, modify orders, cancel orders, and do anything else related to the database failing systems over and ensuring that they have the data they require when they need to go back. Additionally, tables must be modified while setting payroll. And when users become trapped in the system, we enter, maintain the users, and use the SQL Server to free them. What I appreciate about SQL Server is that it saves all the data and information in alphabetical order, making it clean and tidy and simple to locate.

Avantages

platform for data management and consultation that is effective and useful.This is a fantastic method to use your data to improve metrics and outcomes. These days, data is the fuel that powers the world, so utilizing that is a terrific idea.Very good; working with SQL Server has thus far been a pleasure. We're quite pleased with its performance and environment, featuring interesting data visualization, along with T-SQL capabilities and Azure connection.

Inconvénients

For instance, if you leave off a comma while listing the fields you're requesting, you can get an odd message rather than a syntax error.The thing I dislike the most about it is that occasionally the error messages aren't very clear, leaving you wondering what went wrong.

Utilisateur vérifié
Note globale
  • Secteur d'activité : Services et technologies de l'information
  • Taille de l'entreprise : 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 9.0 /10

Powerful and Scalable Database Solution from Microsoft

Publié le 11/02/2023

Avantages

1. It is a robust DBMS and a go to solution for many applications2. Its Management studio and Command line interface is so powerful and easy to use3. All access are managed with built in roles and user defined roles effectively4. Secure, easy to configure and does not require deep experience in using the product5. Business Intelligence tools like SSMS and SSRS work seamlessly6. Its so mature and has great community support

Inconvénients

Price Price Price!! It is so expensive and Support could have been better.

Ketan
Note globale
  • Secteur d'activité : Machines
  • Taille de l'entreprise : 201–500 employés
  • Logiciel utilisé toutes les semaines 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

Benefits Using Microsoft SQL Server

Publié le 11/02/2023

SQL server is overall very good product considering performance and price

Avantages

SQL Server is very easy to deploy. Very fast performance, Backup and restoration is also a simplified Maintain it is not a big task and SQL server is able to Store and retrieve multiple records very fast.

Inconvénients

yet not found any such thing as it's a good product.

Alternatives envisagées 

Oracle PeopleSoft

Pourquoi passer à Microsoft SQL Server

Product with performance and price
Utilisateur vérifié
Note globale
  • Secteur d'activité : Logiciels
  • Taille de l'entreprise : 11–50 employés
  • Logiciel utilisé toutes les semaines pendant plus d'un an
  • Provenance de l'avis

Note globale

  • Rapport qualité-prix
  • Simplicité d'utilisation
  • Support client
  • Probabilité de recommander le produit 7.0 /10

An easy SQL Server with some issues.

Publié le 10/02/2023

Overall satisfactory , meets almost all the necessities , needs to improve some areas.

Avantages

Easily understandable queries , data browser's UI is very simple.

Inconvénients

Complex data migration process , complexity in installation

Utilisateur vérifié
Note globale
  • Secteur d'activité : Construction
  • 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 10.0 /10

application for companies High

Publié le 12/02/2023

Avantages

this software is very useful to use it with big company

Inconvénients

every person or company can be use this with daily work to make share in the form of cloud

Manish
Note globale
  • Secteur d'activité : Services et technologies de l'information
  • Taille de l'entreprise : 1 001–5 000 employés
  • Logiciel utilisé toutes les semaines 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

Awesome Product!

Publié le 11/02/2023

Avantages

It supports a wide variety of transaction processing

Inconvénients

There are no cons that I can think of currently

Masoud
Note globale
  • Secteur d'activité : Vente au détail
  • 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

A database system that you can trust your data with!

Publié le 10/03/2022

I believe we rely on Microsoft SQL Server and its great features and performance a lot. It's our first choice in terms of an RDBMS database and I believe it remains as such for a long time.

Avantages

I've been using Microsoft SQL Server since version 2000 and I must say that every year the team behind it adds tons of improvements and great new features that keep this software a fantastic competitor in the market.
The database engine is very clever in optimising your queries, giving insights on improvements and dealing with your complex queries.
Microsoft's TSQL is very easy to understand and very easy to grasp even though in recent years the team have introduced more complex query templates but still it stands out impressively amongst the others.
I also love that they have released the full version as a Developer version where you can try all the software's great features without any cost at all!

Inconvénients

The huge cost difference between the Standard and the Enterprise version is a put off as certain features like table partitioning should be part of the Standard version.

Alternatives envisagées 

MySQL

Pourquoi passer à Microsoft SQL Server

The greater community behind it and the performance difference made us go to Microsoft SQL Server as our first choice.
Hasan
Note globale
  • 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 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.

Jonathan Alexander
Note globale
  • Secteur d'activité : Hôpitaux et soins de santé
  • Taille de l'entreprise : 1 001–5 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 9.0 /10

A robust database engine with high information security standards.

Publié le 25/05/2022

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

Alternatives envisagées 

Oracle Database

Pourquoi choisir Microsoft SQL Server 

We needed a more robust database engine due to the growth of the company and the processes that are currently being handled, plus the integrations with different platforms.

Logiciel antérieur 

PostgreSQL et MySQL

Pourquoi passer à Microsoft SQL Server

We needed a more robust database engine due to the growth of the company and the processes that are currently being handled, plus the integrations with different platforms.
Paolo
Note globale
  • Secteur d'activité : Fabrication électrique/électronique
  • Taille de l'entreprise : 51–200 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 10.0 /10

The quintessential database server

Publié le 25/05/2022

From the administrative point of view, database management is certainly more efficient than in the past, I must say that in some cases we have been able to solve particular data extractions that without the use of the T-SQL language we would not have been able.

Avantages

Microsoft has always tried over the years to improve its flagship product, achieving good stability and robustness. For administrators, the management interface is particularly useful and easy to use.
SQL Server has allowed us to manage several databases at the same time from our applications without problems giving the possibility to colleagues to have, for example, always updated sales data.

Inconvénients

Unfortunately I must also report the defects and in this case in my opinion the interface for administrators has become too slow in terms of starting in the latest versions.
Sometimes product updates do not install correctly, even if this rarely happens it can create a general disservice almost always in time of need.

Alternatives envisagées 

PostgreSQL

Pourquoi passer à Microsoft SQL Server

Because when it comes to Microsoft products, it's inevitable not to rate them
Gonzalo
Note globale
  • Secteur d'activité : Automatisation industrielle
  • 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 8.0 /10

Good for medium and big companies

Publié le 21/08/2019

I am using SQL Server for 4 years in a Low, Medium and Big environment, but in low environment i have a bad experience using SQL SERVER, Mysql is better in a small busines for cost, and simplicity, but in Big environment SQL SERVER can compete with ORACLE DB.

Avantages

Is powerfull
Easy
Complete
Customer Support
Features
interoperatibity

Inconvénients

Have some errors
You need to reset de SQL 1 time at week
Consumes a lot of ram
it needs a Windows Server

Alternatives envisagées 

PostgreSQL et MySQL

Pourquoi choisir Microsoft SQL Server 

Pricing and Simplicity

Logiciel antérieur 

Oracle Database

Pourquoi passer à Microsoft SQL Server

is a more powerfull alternative to Mysql and is more simple than Oracle Database
Utilisateur vérifié
Note globale
  • Secteur d'activité : Automobile
  • Taille de l'entreprise : 1 001–5 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 9.0 /10

Relational Database Management System

Publié le 17/10/2019

Overall had a great experience as the name suggests that "Microsoft SQL Server" the first word of the product defines it all and have a huge impact on its sale and purchase.

Avantages

As a Microsoft SQL Server administrator , i like the community and the support that Microsoft community provides as it has a very powerful knowledge base if i stuck in some problem i just google it and the problem has been resolved in minutes.

Inconvénients

Microsoft should increase the performance of few of its products as it is very slow as compared to Oracle and DB2 . And should consider on Monitoring of the databases as database administrator primary objective is to monitor the instances continuously.

Alternatives envisagées 

Oracle Database

Pourquoi passer à Microsoft SQL Server

As we have a committed microsoft partner and we are in an Enterprise agreement with Microsoft so it is easier for us to explore the all new world of Microsoft.
Surender
Note globale
  • 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 10.0 /10

Best DBMS tool for scalable enterprises

Publié le 16/05/2019

My overall experience is 100% satisfactory because of its robust feature.

I recommend this to all either its a large or small scale compan y because SQL server can handle large quantities of data and process it smoothly. Just loving it.

Avantages

Microsoft SQL server is one of the best database management system that provide top rated performance optimisation with SQL queries, below is the list of top highlights:

1. Richness of user interface that provides ease of use with cool features like dock able windows.

2. Intelligence window is prominent feature that saves a lot of development time up to large extent.

3. Code debugging and performance tuning with query flow maps is the best features that assures about code optimisation.

4. Microsoft SQL Server Agent is provided with this software and that runs the automatic jobs in very secure way and later we can track the statements executed.

5. We can filter out the records in SQL Server Agent interface based on our interest.

6. Code snippet manager makes it easy to write high standard code that is perfact for code convention.

7. Most prominent feature is that it can handle large quantities of data, runs automatic jobs with concurrent transactions.

8. At last it's a Microsoft product that provides a belief to users.

Inconvénients

I have been using SQL server from version 2012 to 2014 and never troubled with SQL server's performance in any way.

However I feel that error details must long descriptive when statement have some syntax error. Sometime its pathetic when we wants to know the exact error line but is hints the whole block of code instead of exact line number.

Otherwise Its a great product and happy with it.

Griffin
Note globale
  • Secteur d'activité : Hôtellerie
  • Taille de l'entreprise : 1 001–5 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
  • Probabilité de recommander le produit 10.0 /10

SQL Server is the backbone of my life!

Publié le 04/02/2019

Overall, my experience with SQL Server is amazing! I am able to store all of our Las Vegas luxury casino data (gaming, hotel, food & beverage, entertainment, etc.) and query that for information that we then turn into automated or ad-hoc reports. These then go to the operators of the business as well as the executives who analyze the reports and make better decisions daily, weekly, and monthly. The goal is simple: just become better over time...better than you were last year, last month, last week. And SQL Server is the vehicle to empower your organization to find those valuable insights hiding in plain sight to do just that!

Avantages

I absolutely LOVE SQL Server. It is my favorite software to use because the possibilities for query-writing are endless. I would say this is the most reliable and flexible of all the database software I have ever used. SQL Server allows you to write in T-SQL (T = transact, SQL = structured query language), which means that you can create variables, use temp tables, and write code in a procedural format that runs akin to a module in other programming languages. We use SQL Server 2008 at work, though I am really loving the new features in the latest version (as of today) SQL Server 2016.

Overall, SQL Server is a platform for creating table schema, storing information, and then writing scripts (queries) to manipulate that data--to find insights that are useful to making better business decisions. The interface is easy to understand, the error-checking is strong (and actually tells you what is wrong). It doesn't hold your hand like other simplified coding languages, but it becomes very reliable and easy to use once you obtain a solid foundation in relational database theory and SQL language.

Inconvénients

Hmm...if I had to speak ill of SQL Server...I would probably say that it is a bit tricky to get up to speed quickly with. There's a lot to it, so to speak, so it's taken me the better part of five years working in the data analytics industry to finally say that I feel I am completely proficient in utilizing the software to its full potential. Topics such as query optimization remain my areas of biggest weakness. I can write a query to pull any kind of desired information; however, the art lies in being able to pull it quickly and with reasonable efficiency. If your query takes more than 15 minutes (or even hours!) to run, it's probably not written correctly and likely poses a major threat to the server you are connecting to (and tying up!) in the process. I would like more information in the software (GUIs, warnings, etc.) regarding poorly-written queries from an execution standpoint.

Germo
Note globale
  • Secteur d'activité : Logiciels
  • Taille de l'entreprise : Auto-entrepreneur
  • 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

my every day tool which I use, since it exists

Publié le 21/02/2022

I use SQL Server since it was obtained by Microsoft. I am specialized on it and I work only in projects where it is used as core technologie. I am a very experienced architect and developer, based on SQL Server And Microsoft BI.

Avantages

It is easy to install. There is also a free Express Edition / Localdb, which has most features of the paid Version. The developer Edition has all Features of the Enterprise Edition. It is very easy to install even several instances on any system. I can solve nearly all tasks, I feel very confident. The documentation is great and it is easy to find answers to questions. It is just my every day tool.

Inconvénients

If there are some heavy queries then the whole instance gets down, often even other instances on the same system. I don't understand why it is not possible to limit the effect.
Many features which I would like to use are only available in the enterprise edition. But this edition cost much more than standard and I am forced to use only features of the standard edition.
Often I am forced to use quite old version, for example 2016, but the current version is 2019. Again the reason is the price. Customers would need to spent more money for the latest version, therfore they force me to develop based on old versions.

Utilisateur vérifié
Note globale
  • Secteur d'activité : Hôpitaux et soins de santé
  • Taille de l'entreprise : 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 8.0 /10

SQL Server 2016 - Features Review

Publié le 20/12/2018

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.

Gábor
Note globale
  • Secteur d'activité : Automobile
  • 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

My past with MS SQL

Publié le 25/10/2022

I met firstly with MS SQL in the uni. The in one of my workplaces I became an admin of it, so as a "user".Its two sides-role widely different. Writing queries, retrieving data, manipulating the results (not the stored data) is a cool option. Easier, faster, more known then Oracle's PL/SQL I would say. The option it gives you are enormous, and how many things uses a DB nowadays are surprising. Knowing and being able to manage a DB, will be an asset in the future. Speed depends on your codes and on your machine. The memory is the enemy of the DBs, so as for MS SQL. Maybe other, non-relational DBs have better results, but on specific tasks. MS SQL is being better, has a lot of devs. behind its back and MS itself, you definitely worth considering it having as a primary database. 3rd party extensions can be used, that can take your productivity to the next level, like APEX.Having a free version up to 10 gigs per database, you would not believe how many company based its business on this "advantage".

Avantages

Can be integrated with a lot of MS and 3rd party tools.The query window is well formed.The speed of the DB is excellent, but bases heavily on your custom codes.Reports, ad-hoc table, integrations with other reporting tools, intranet websites are great.

Inconvénients

Less training options available comparing it to other MS tools.Intergration, access management can be difficult.Sometimes not easy to track changes in your codes, mostly in big databases.Installation could be easier.It not recommended, but for IT personnel with solid knowledge.

Gabriel
Note globale
  • Secteur d'activité : Compagnies aériennes/Aéronautique
  • 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 8.0 /10

A database for every level of user expertise

Publié le 16/01/2021

Regarding to the cost; licenses are cheaper than others. But when analyzing a database you should consider many others variables like administration cost, available resources, expertise of the team, company size, available servers, budget, etc...

Avantages

SQL Server allows users to setup up a database with different features, from basic database to a complex environment that can include partitions, replication, business intelligence, reporting, etc. Is really simple to deploy on different scenarios like on-premise or cloud. Regarding SQL Language - Transact SQL - it is simpler and easier than other languages. For beginners this could be something positive because of the velocity of the learning curve. The integration with the business process is really easy when working with other Microsoft technologies. Additionally there is an interesting feature called FileTables which allows see the storage as a table. SQL Azure database is something great, an scalable database service that can me managed with Management Studio tool and created in less than a minute.

Inconvénients

Something that could be an improvement to MS SQL is related to the performance monitor. In general all databases require to have a relative high level of expertise to create a good database design. With a simpler performance tool, junior users could create better queries, indexes, model, etc...

Anuj
Note globale
  • Secteur d'activité : Internet
  • Taille de l'entreprise : 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
  • Probabilité de recommander le produit 10.0 /10

Two words - "Best RDBMS"!

Publié le 05/09/2018

Highly recommended - The Best RDBMS Package I have worked so far.
Best IDE - let the wizard do basic things with you few clicks so you can focus on actual DB tasks and writing query.
Developers in your team are going to love this Database!

Avantages

• Microsoft SQL Server is the best RDBMS package I have ever worked on! (Other DBs I have used are - Oracle, Teradata, MySQL, and Redshift)
• Just like other Microsoft products; SQL Server is by far the most User-friendly Database Server - best IDE
• Lots of wizard features from import, export, backup, query builder etc that anyone can easily learn and do just with few clicks!
• Intellisense (like visual studio) to complete code while typing and showing common mistakes before you even execute
• Built-in execution plan viewer which is nice enough to start with.
• Free Plugins and third-party tools available to make your life even easier like: Poorman SQL Formatter, SentryOne Plan Explorer etc
• Integrates very well with other MS products. Full MS BI stack includes SSIS ETL, SSRS BI Tool, SSAS etc.

Inconvénients

• No considerable cons. Maybe Microsoft should consider offering built-in features/tools for which developers use third-party tools and plugins. Like builtin execution plan viewer is not as great as SentryOne Plan Explorer.
• With so many built-in features one little must have to include is One click code indentation. Until Microsoft can add this feature, we can live with Poorman SQL formatter.