Avis clients sur Microsoft SQL Server

4,6 (1 788) Écrivez votre avis !

En savoir plus sur Microsoft 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.

En savoir plus sur Microsoft SQL Server

Avantages :

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.

Inconvénients :

Licensing is confusing, whenever you have license by call or by CPU core, it's a bit hard to understand how they apply the prices.

Microsoft SQL Server - Notes

Note moyenne

Facilité d'utilisation
4,3
Service client
4,3
Fonctionnalités
4,6
Rapport qualité-prix
4,3

Probabilité de recommander le produit

8,7/10

Microsoft SQL Server a reçu une note globale de 4,6 étoiles sur 5 d'après 1 788 avis d'utilisateurs publiés sur Capterra.

Avez-vous déjà utilisé Microsoft SQL Server ?

Partagez vos expériences avec d'autres acheteurs de logiciels.

Filtrer les avis (1 788)

Mohamed
Data analyst (Tunisie)
Logiciels, 11-50 employés
Temps d'utilisation du logiciel : plus d'un an
Source de l'avis

Alternatives envisagées :

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

5,0 l’année dernière

Commentaires : 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.

Ishan
Ishan
SDE-1 (Inde)
Utilisateur LinkedIn vérifié
Internet, 11-50 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

RDBMS tool for Microsoft based stack

5,0 il y a 2 semaines Nouveau

Commentaires : Overall a perfect combo of database management with help of its tools.

Avantages :

1. Supports SQL with only subtle change in syntax2. It has its UI application MSS Management studio, which is helpful editor and platform for implementation.

Inconvénients :

1. It consumes lot of RAM.2. Latest version are some times not stable.

Vinicius
Software Engineer (Brésil)
Services et technologies de l'information, 2-10 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Alternatives envisagées :

Review for Microsoft SQL Server

5,0 il y a 2 semaines Nouveau

Commentaires : SQL Server is my main RDBMS for Windows environments because it has a wide range of features and is completely compatible with the operating system since it runs on its native platform.

Avantages :

Easy to install, configure, update and use. Through tools such as SQL Server Management Studio (SSMS) the system has a very friendly graphical user interface. SQL Server has extensive documentation on the Internet.

Inconvénients :

Full installation takes up a lot of disk space. Depending on the version, the software license can be very expensive.

Josh
Senior Support Engineer (R.-U.)
Services et technologies de l'information, 2-10 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

SQL management is overly complex, but perhaps rightly so…

3,0 il y a 2 semaines Nouveau

Commentaires : Our customers are able to push their Sage 200 data to various third-parties and have greatly expanded on their opportunities to increase income. SQL essentially offers endless possibilities as it’s widely supported by many other tools and devices.

Avantages :

Our customers who use SQL in conjunction with Sage 200 and Sage BI have achieved great results with regards to both end-user experience and data analytics. The way in which SQL handles their data, means they’re able to tie the databases in with various external web services and expand on their business usage case.

Inconvénients :

The user interface is extremely complicated to use if you’re not a SQL Server expert, but perhaps that is unavoidable due to the shear volume of features and settings available. It would be nice if certain areas of the GUI were simplified, especially when dealing with Active Directory access control lists and permissions.

juan jose
ANALYST PROGRAMMER "A" (Mexique)
Aviation et industrie aéronautique, 501-1 000 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Alternatives envisagées :

Microsoft SQL Server for Business

4,0 il y a 3 mois

Commentaires : 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.

Avantages :

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.

Inconvénients :

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.

Utilisateur vérifié
software developer (Afrique du Sud)
Utilisateur LinkedIn vérifié
Services et technologies de l'information, 11-50 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

MS SQL Server Review

5,0 il y a 2 semaines Nouveau

Commentaires : 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

Edward
Lead Infrastructure Engineer (É.-U.)
Banque, 10 000+ employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Alternatives envisagées :

SQL Server Review

5,0 il y a 3 semaines Nouveau

Commentaires : I have used every version since 6.5 and all releases have been solid and each subsequent release showed improvements.

Avantages :

It has been the same core components since 6.5, but the new features are very good.

Inconvénients :

Some of the alerts provided by Microsoft are not always intuitive or clear

Ryan
Ryan
Marketing Analytics Engineer (É.-U.)
Utilisateur LinkedIn vérifié
Marketing et publicité, 1 001-5 000 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

A good tool when you need it, but not my favorite place to access data

4,0 il y a 2 semaines Nouveau

Avantages :

I like that it is a good tool to access a SQL database, especially one that is housed within Microsoft.

Inconvénients :

As with most Microsoft tools (e.g., visual studio), it has too many bells and whistles. There is so much available within this tool that I get lost and have a hard time getting a workspace set up. I also had quite a few authentication problems because I was logging in with different credentials than my laptop password and it kept looking in my credentials manager so that was frustrating.

Sameh
IT specialist (Égypte)
Services et technologies de l'information, 51-200 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Microsoft SQL Server is a great data management, analyzing and reporting, It has many features.

5,0 il y a 2 mois Nouveau

Commentaires : It's very interesting knowledge to handle many many customers at the same time and it's easy, and very impressive to display any data any time.

Avantages :

It's powerful to display any data right now day to day, It help us to handle many clients with writing a query

Inconvénients :

I think and it's my opinion It's very, powerful, useful and helpful software

Manjula
Manjula
Head of Learning and Developement (Inde)
Utilisateur LinkedIn vérifié
Services et technologies de l'information, 201-500 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Best Back End Support for Storage of Data

5,0 il y a 2 semaines Nouveau

Avantages :

It is best database software to support as back end for all the RPA product like Automation Anywhere and UiPath.It is best database for configuration and support as back end.

Inconvénients :

To implement easily better IDE is required so non technical people can learn this tool easily.

Utilisateur vérifié
VP, Technical Support (Inde)
Utilisateur LinkedIn vérifié
Logiciels, 1 001-5 000 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Powerful and reliable

5,0 il y a 4 semaines Nouveau

Commentaires : Overall, Microsoft SQL Server is a reliable database management system for businesses of all sizes. It is secure and offers a range of powerful features to help manage and analyze data.

Avantages :

I like SQL Server's range of development and management tools, including the SQL Server Management Studio and SQL Server Data Tools, which make designing, developing, and maintaining databases easier. SQL Server is able to handle large data efficiently and contains reliable disaster recovery features.

Inconvénients :

While you'd expect anyone using SQL Server to have reasonable DBMS knowledge, SQL Server can be difficult to learn depending on an individual's skillset.

Imi
Imi
MIS Developer (É.-U.)
Utilisateur LinkedIn vérifié
Organisme politique, 201-500 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Alternatives envisagées :

SQL is getting better as it grows older

4,0 il y a 3 ans

Commentaires : 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.

Hasan
Hasan
T24 Technical Analyst (Pakistan)
Utilisateur LinkedIn vérifié
Banque, 501-1 000 employés
Temps d'utilisation du logiciel : plus d'un an
Source de l'avis

SQL Server

5,0 il y a 2 ans

Commentaires : 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.

Quentin
Products Director (É.-U.)
Logiciels, 2-10 employés
Temps d'utilisation du logiciel : plus d'un an
Source de l'avis

Alternatives envisagées :

This sequel is better

5,0 il y a 3 ans

Commentaires : Once SQL Server in Azure was selected, it proved to be a great experience. Security, performance and usability was ironed out for us already. We could focus on building our application rather than learning something new about cloud security or how to use a new type of database or database language variation. We have been pleased with the ability to research performance and include other features such as SSIS to accomplish our business requirements easily. Knowing that manual tasks are being completed automatically is a sigh of relief. We also will know immediately if there are any issues. We have had a great experience with SQL Server.

Avantages :

It is an industry standard that continues to improve to make the lives of developers easier. We are able to produce software solutions more efficiently because Microsoft continues to improve SQL Server. We rely heavily on this as critical to our business. Developers tell me how flexible SQL Server is also. SQL is more compatible with software packages than other competing databases.

Inconvénients :

Parts can be not intuitive unless you've been using it for awhile. It is a technical piece of software that requires time and training. If you need the Enterprise edition for specific features, it is expensive.

tavimbanashe
IT Administrator (Zimbabwe)
Services et technologies de l'information, 11-50 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

The best database management system

5,0 il y a 2 ans

Commentaires : Microsoft SQL Server is a great data management, analyzing and reporting tool which helps in day to day running of a business. The very powerful features it posses makes data analysis easy. The community support makes it easy to do many tasks and above all, the security this tool provides makes it safer than other database management tools

Avantages :

The ability to store, manage , retrieve and backup large amounts of data without so much hassle. The availability of support on the internet is just amazing. It works well for small sized to big sized companies and the security of these databases is top notch. Since it has recently been integrated with Azure, it will be easier for cloud deployment and cloud support. Can also be used be as a reporting and analyzing tool.

Inconvénients :

The cost is a bit high and it requires skill to be able to work with sql. The larger the information on the database usually makes it to slow down in terms of querying it

Utilisateur vérifié
Senior Software Engineer (Égypte)
Utilisateur LinkedIn vérifié
Logiciels, 201-500 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Alternatives envisagées :

every day using MS SQL Server

5,0 l’année dernière

Commentaires : have +10 years experience in SQl server , i have create a lot of apps depend on it as database storage engine

Avantages :

- every day i use it through management studio or from C# Code by using Entity framework and you can depend on it in any scale application ( small - medium - and large ) - easy integrate with applications - good security -have a good Replication feature

Inconvénients :

it expensive compared by other competitors

Lasha
Lasha
System Administrator (Géorgie)
Utilisateur LinkedIn vérifié
Hôpitaux et soins de santé, 501-1 000 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Alternatives envisagées :

One of the best DB management systems.

5,0 il y a 3 ans

Commentaires : I've been using SQL Server for a few years and I haven't had any problems with it except for partitioning. It's very optimized and stable and due to it being free - it's an amazing choice for small and medium enterprises.

Avantages :

MSSQL comes jam-packed with features. It's standard library is enough to cover the needs of a small enterprise. It is also very stable and can handle large amounts of database exceedingly well. However, my favorite tool is the built-in scripting language - T-SQL. It is very powerful and flexible and lets you do anything you might need.

Inconvénients :

SQL Server takes up a lot of computing resource. We have a small data warehouse and yet it takes up over 1 TB. Views are not as useful as in Oracle. For example, partitioning a fact table by multiple columns is impossible without a workaround.

Utilisateur vérifié
SOFTWARE DEV (Honduras)
Utilisateur LinkedIn vérifié
Logiciels, 2-10 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Very complete Database manager

5,0 il y a 3 ans

Avantages :

Even when some people argue that is not the most fastest database for me is the most useful and with more tools than most, almost all databases has store procedure, functions, etc. but one thing that SQL Server has that most don't is the ability to create your own type of data, I mostly prefer to use Table type so I can insert a lot data in one single transition without using a loop condition to validate The source manager allos to see the type the query and from what machine is been executed

Inconvénients :

you need to use the installer every time you need to create a new instance, if the server is down and you restar the services, you need to open the sql magnament to restart the jobs as well

alfredo
alfredo
ventas (Mexique)
Utilisateur LinkedIn vérifié
, 51-200 employés
Temps d'utilisation du logiciel : Non fourni
Source de l'avis

If you are working from scratch,it is relatively easy to set up a new database server and connectivi

5,0 il y a 5 ans

Avantages :

If you are working from scratch, it is relatively easy to set up a new database server and connectivity between clients. Everything is quite simple, given that you have knowledge of the database. The DBMS allows you to easily create several things completely in design (tables, views, etc.), which is a great advantage when you do not know all the syntax. The integration of other monitoring software such as fog light is very easy without the consumption of time. Great ability to handle all complex query requirements. Suite of advanced functions of sql. Provide all the excellent functionalities, such as Reporting Services, Integration Services, Job Scheduler, Resource Manager, Query Analyzer and Profiler, etc. Each of these modules is perfectly constructed and manages the tasks effectively. Configurable in each level. The user permission is on all objects and other higher levels. Changes can be made for specific privileges at the user level. Window service based on Control to the server to start and stop the service. I think one of the best things about Microsoft SQL (currently using 2012) is the Developer Network and the useful resources that are available. Thanks to the network of developers, I have been able to learn much more about queries and create more useful and advanced queries over time. Things like Transact-SQL (T-SQL) are useful many times due to the large number of new queries that can be generated after learning T-SQL.Compatibility with most SQL Server administ

Inconvénients :

Sometimes, performance when executing some long queries is not what you would expect. Although the power of the CPU is important for this part, but in the company we have state-of-the-art servers in the NAP of the Americas, so it seems a software problem instead of a hardware problem. Some of the configurations of previous versions (2008 - 2012) are quite clumsy and not very well done - I have had several instances of my corrupt installer and have to re-download. The administrator of the database, sometimes, takes time to load. Scalability is excellent, but not the best, like other new databases in the market. The memory consumption of the CPU is always more than normal in the production specifically by the sql server. Scope of the improvement in the profile generator for the most used options. Sometimes, if it is not handled properly with a predefined scheme, the relations and the maintenance of the data become a problem. This happens mainly only when it comes to new users or with people who do not work as part of a larger workforce that manages the system. Certain add-ons also provide useful features, but if SQL added them, it would save users the problem of finding and installing them. The database is the target of many attacks from your SA account, this should be disabled by default and just after installation, about 30 seconds, the attacks begin, with many requests per second, need to improve the firewall to prevent these attacks, or place the SQL Server inside a VPN

Surender
Technical Lead (Inde)
Utilisateur LinkedIn vérifié
Services et technologies de l'information, 11-50 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Best DBMS tool for scalable enterprises

5,0 il y a 4 ans

Commentaires : 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.

Aníbal
Aníbal
Programador (Venezuela)
Utilisateur LinkedIn vérifié
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

My experience with sql Server has been satisfactory, I have done punctual work.

4,0 il y a 5 ans

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.

Germo
Germo
BI Architect and Developer (Allemagne)
Utilisateur LinkedIn vérifié
Logiciels, Auto-entrepreneur
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

my every day tool which I use, since it exists

4,0 il y a 11 mois

Commentaires : 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.

Gabriel
Software Engineer (Argentine)
Compagnies aériennes/Aéronautique, 2-10 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

A database for every level of user expertise

4,0 il y a 2 ans

Commentaires : 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...

Scott S.
Scott S.
Sr. Data Analyst (É.-U.)
Utilisateur LinkedIn vérifié
Gestion de l'enseignement, 501-1 000 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Solid relational database ecosystem with useful accessories

5,0 il y a 5 ans

Commentaires : The ability to solve data problems and syndicate actionable information to the right audiences in a timely manner.

Avantages :

I have been using Microsoft SQL Server for about 20 years and have watched the product evolve into a very mature and vibrant offering. SQL Server gives me the flexibility and performance needed for many different relational database solutions ranging from application OLTP databases to enterprise level business intelligence implementations. With my main focus being business intelligence, I have been very impressed with the SQL Server 2016 releases and improvements. It seems the Microsoft is very dedicated to this BI ecosystem and they seem committed to continuity in the products. Some of my favorite things to note are the new SSRS portal interface in 2016, the ColumnStore indexing in Enterprise versions, SSAS tabular models, and the ease of use with Power BI. Overall, I feel extremely confident in this product in terms of its use to solve almost any problem related to data. I find most things very easy to use and due to the wide use of this product, figuring out the more complex issues is not difficult thanks to Google.

Inconvénients :

I sometimes don't appreciate the complexities related to transnational logging and the time it takes to roll back large transactions. Purely a performance and optimization issue, but the ambiguities in terms of when a task like this will complete can be frustrating.

Duane
Duane
CTO (É.-U.)
Utilisateur LinkedIn vérifié
Appareils médicaux, 11-50 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Microsoft SQL Server is the all-around best out there.

5,0 l’année dernière

Commentaires : The best thing about is is that I can write all the business logic in Store Procedures and only have to write code to display and manipulate data sets.

Avantages :

I started using Microsoft SQL Server in 1999 loaded on a dual 1GH Pentium processor workstation motherboard with the Microsoft NT 4 OS Server. I soon upgraded to Windows 2000 Advanced Server. I wanted see to just what it would do on basically a low end server. I used the same box for the database and the web server running 10 data driven websites. The server was located in my bedroom and connected to the internet via broadband cable. Not the best type of connection for a server. I would test my websites offsite at work and at friends houses. The pages would load instantly. Imagine the performance on a monster server? The real kicker is with the Microsoft SQL Server Management Studio. Other databases like MySQL and Oracle are also great until you get to the UI part. At the time both of the latter UI's where rather primitive as with MySql or clunky and difficult to use like with Oracle. Over time, all the databases I mentioned improved but Microsoft SQL Server is still a step ahead. When it comes to moving a database from one machine to another Microsoft made it easy

Inconvénients :

I am totally happy with everything about it.