Microsoft SQL Server

Um dos melhores Banco de dados do Mercado

Vantagens:

Robustez, segurança e facilidade na implantação e manutenção

Desvantagens:

O custo de implantação da versão SQL Server full é um pouco elevado

Best, well-known and wide-spread product for SQL.

Comentários: There are lots of benefits to using MS SQL Server.1) Secure data storage.2) SSMS for data exploration on desktop.3) Awesome public documentation by MS.

Vantagens:

Little can I write about this vast product, but to brief each which I find insightful are below:1) Fine-grained role and attribute-based access control. 2) Highly secure and robust ways for authorization and authentication.3) Sync with Active Directory authentication.4) Awesome connectors with data warehousing tools.5) Best data at rest and in transit encryption.6) Dedicated support and advisory.

Desvantagens:

Almost nothing to be pitched here, it is continually being developed and refined for adding better features.My advice would be to learn T-SQL for best usage.

Microsoft SQL Server for Business

Comentários: I have 5 years working with Microsoft SQL Server, I have adapted well, I like the functionality it has, the practical way in which you can perform queries, scheduled tasks for my daily and weekly backups are excellent, accompanied by the crystal report, works great, I tried to try other database managers like ORACLE, but I think it is better Microsoft SQL server, to this day, I prefer to work with it.

Vantagens:

Personally, I like that the application is easy to use, obviously if you already have time using it and you are familiar with the concepts and terms used, the tools to create backups or schedule tasks to run on specific dates and times is quite good, the price is affordable not too expensive unlike oracle.

Desvantagens:

to install it is a bit time consuming, since you have to configure it on the fly, it does not bring any preconfigured default settings, this takes a little time to the user, to migrate to other operating systems other than windows, you have to make other extra configurations.

SQL Server as a primary tool for developers

Comentários: 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.

Vantagens:

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.

Desvantagens:

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.

A good choice as a database manager, but it can be improved.

Comentários: It is good software, as I mentioned before. It syncs well with other Microsoft tools. In almost 2 years of use, I feel comfortable when working with this software. I hope that the improvements I mention in the negative points will be included. Otherwise excellent.

Vantagens:

I like that it allows me to use my Windows login credentials as user authentication to connect to the server. Plus it integrates easily with other Microsoft programs such as Visual Studio 2022, Business Intelligence tools, etc. I am a Software Engineering student, and I have been testing many database managers. Of all the ones I have used Microsoft SQL Server is the easiest to install and very intuitive regarding the use of its tools. In addition to being a student, I give small tutorials on how to use the software, such as tips for new users, and database backup.

Desvantagens:

I don't have much to criticize in this space. For me, the Software is very complete. But if I would like you to implement a dark theme throughout the interface, it would be very helpful to rest your eyes and avoid fatigue after hours of work.