SQL Server

Commentaires: I am able to store thousands of users information in a arranged way.
I am able to analyse the data from different sources.
I am able to print report such as pdf file.
I am able to get backup of my data.
I can show the records in any form using SQL queries.
I can fetch details of any number of customer in just a second without going through the bunch.
I can update the data about my customer.
I can delete any unnecessary data.
I can send automatic mails using the sql job.
I can make my data easily accessible by using different index provided by SQL.
I can sort the data in ascending, descending or in alphabetical order.
So bottom line is I am making money by investing some money into SQL server.

Avantages: 1. The capability of extraction and manipulation of data. Using sql server you can fetch or gather data from different file system like excel file csv file etc and then manipulate them according to your need like sort them with name, make the first later of name in capital etc. And then you can print the manipulated data as well.
2. It provides backup for all your stored data into it, by this there is no worry of loosing your data.
3. After making backup obviously they provide the facility to restore those backups.
4. As I mentioned in first point report generation is also its one of the powerful feature.
5. It serves as back end for many programming language. When someone is maintaining his site.
6. Support of different tools like SQL profiler these tools will work as magic when you will be performing complex task.
7. Another tool is tuning adviser that can suggest you different ideas with which you can optimize your sql queries.
8.Gives you ability to run different instance of sql server in one system by this i mean one can have SQL server 2012 and then after that you can also have SQL server 2014 and 2016 parallaly.
9. Debugging tools like debugger.

Inconvénients: There are very few things left about it as it has released its different versions.
1. It is paid
2. It is heavy sometimes it stucks.
3. Takes lot of resources like memory and space.

Commentaires: I have worked several times with this software for different reasons I have been able to simplify developments thanks to the Transact-SQL so it has saved me programming time, the services that I have under my responsibility at work are stable, this gives confidence and tranquility for me and for my bosses, I made restorations in record time.

Avantages: This software has as its first advantage that it is a Microsoft product and has the full support of the company and the stability of a well-tested product. At the basic level, I find it very efficient, the sql responses are fast and there are almost no service interruptions, which is a point in its favor when I use it, I find the Transact-SQL language that is used very powerful, I was able to assign commercial processes of the application in the database that allows multiple applications to use them and it is not necessary to program these functions in each application, the SQL server administration tools are very well thought to be all in a Microsoft environment, the integration is perfect, they are very intuitive to find new functions, they do not require prior knowledge, what is important to train new staff, another thing that I like about this software is the scalability that can start with a small database and grow, in A past project had transactional tables that inserted millions of records daily. I like security, it is possible to assign specific permissions to different users who perform different activities within the same database, this makes me trust the product.

Inconvénients: The least I like is undoubtedly the cost SQL-Server does not have a good cost-benefit ratio, other brands offer better benefits in this regard, another point is the high consumption of RAM, it is necessary to allocate a large amount of resources for this And to guarantee the quality of the service, until now I have not found a hosting provider that offers me a PHP server with Sql-server. This stopped once a new development for a client was disappointing to me. It is difficult to learn in a particular way, the free versions of this software are very limited and the certifications are expensive, which reduces the interest when it is investigated.