Avis clients sur Microsoft SQL Server

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

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.

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

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

Unlocking the Potential of Data Management with Microsoft SQL Server: A Comprehensive Review

Avantages :

Powerful database management system: Microsoft SQL Server is a robust database management system that can handle large amounts of data and complex queries with ease.Integration with other Microsoft tools: SQL Server integrates well with other Microsoft tools, making it easier to manage and analyze data.Scalability: SQL Server can scale up or down to meet your organization's changing needs.High availability: SQL Server offers high availability features that ensure your data is always accessible, even in the event of a system failure.Business intelligence: SQL Server has robust business intelligence capabilities, which can help you gain insights from your data and make informed decisions.

Inconvénients :

Cost: SQL Server can be expensive, especially for enterprise-level deployments.Complexity: SQL Server can be complex to set up and manage, and it may require a team of dedicated IT professionals to run effectively.Limited cross-platform support: While SQL Server can run on some non-Microsoft platforms, its full capabilities are only available on Windows.Resource-intensive: SQL Server can be resource-intensive, requiring powerful hardware and significant amounts of storage space to operate effectively.Licensing restrictions: Microsoft's licensing policies for SQL Server can be complicated, and you may need to purchase additional licenses to use certain features or functionalities.

Navigating the World of Database Management: A Critical Review of Microsoft SQL Server

Commentaires : In my experience, Microsoft SQL Server has been an excellent choice for enterprise-level data management. The system's comprehensive feature set, scalability, and robust reporting and analytics tools make it an ideal solution for businesses that are looking to manage their data effectively. While the system's pricing may be on the higher side compared to some other mid-tier database management systems, I believe that the benefits of using Microsoft SQL Server far outweigh the cost. Overall, I highly recommend Microsoft SQL Server to organizations looking for a reliable, scalable, and comprehensive database management system.

Avantages :

One of the standout features of Microsoft SQL Server is its comprehensive feature set that allows for seamless data integration, security, and performance optimization. The system's user interface is intuitive and easy to navigate, making it easy to manage and monitor data. Additionally, the system's reporting and analytics tools are robust and provide valuable insights into data trends and patterns.Another major advantage of Microsoft SQL Server is its scalability. The system can easily accommodate the needs of large-scale enterprises, making it an ideal solution for businesses that are looking to expand their operations. The system's backup and recovery tools are also noteworthy, providing peace of mind to organizations that rely heavily on their data.

Inconvénients :

While Microsoft SQL Server offers a lot of features and functionalities, some users may find it overwhelming to navigate the system. Additionally, the pricing of the system can be considered on the expensive side compared to other mid-tier database management systems in the market. Finally, some users may find the installation and setup process to be somewhat complicated.

Microsoft SQL Server is a reliable and powerful tool for managing data bases.

Commentaires : I got the chance to work with Microsoft SQL Server multiple times during my time as an IT intern at the university. This program was used by us to create reports and maintain the database for research projects. Overall, I thought the program was simple to use and gave a lot of helpful features for our job.

Avantages :

Microsoft SQL Server is a reliable and powerful tool for managing databases that offers a wide range of functionalities for managing massive data volumes. One of its advantages is its ability to work with many data types and its integration with other Microsoft tools, such as Excel and Power BI. Additionally, it provides advanced security and data recovery options in case of errors.

Inconvénients :

Despite being a very comprehensive tool, Microsoft SQL Server's initial configuration can be difficult and need significant technical knowledge. It may also prove to be pricey for smaller or mid-sized organizations due to its license needs and hardware requirements.

SQL Server: A Game-Changer for Data Management and Analytics

Commentaires : One of the key strengths of SQL Server is its data management capabilities, including data import/export, backup and recovery, data cleansing, data connectors, and data storage management. The software's reporting and analytics features, including customizable dashboards and interactive reports, provide organizations with valuable insights into their data. Additionally, the software's security and data quality control features help ensure that organizations can maintain accurate and consistent data.However, like any software, SQL Server also has some limitations. The software can be complex and challenging for inexperienced users to navigate, and the customization options available may be limited compared to other database management systems. Additionally, the cost of the software can be a barrier for some organizations, especially small businesses or startups. Some users have also reported performance issues, particularly when working with large amounts of data, and limited integration with other tools and technologies.Overall, Microsoft SQL Server is a comprehensive relational database management system that provides robust features for managing, analyzing, and reporting on data. While it may have some limitations, it is a well-regarded and widely-used tool that is well-suited for organizations with large amounts of data.

Avantages :

One of the key benefits of Microsoft SQL Server is its robust data management capabilities. The software provides an array of tools for importing and exporting data, managing data storage, and ensuring data quality, which makes it easier for organizations to manage and maintain their data. Additionally, the software provides robust reporting and analytics features, including interactive dashboards and customizable reports, which make it easier for organizations to gain insights into their data and make informed decisions.Another advantage of SQL Server is its scalability. It can handle large amounts of data and supports high-performance data processing, making it suitable for organizations of all sizes, from small businesses to large enterprises. The software also provides multiple options for connecting to other data sources, including other databases and cloud services, which enables organizations to integrate data from a variety of sources and create a single source of truth for their data analysis.Finally, SQL Server provides reliable and secure backup and recovery options, which give organizations peace of mind in knowing that their data is protected. The software also includes features for data cleansing, which help organizations to maintain accurate and consistent data, improving the quality of their analysis and reporting.Overall, the combination of robust data management tools, scalability, and reliable backup and recovery options makes Microsoft SQL Server an

Inconvénients :

it also has some limitations and drawbacks. Here are a few cons that you may find with the software:- 1) Complexity and Steep Learning Curve: One of the main criticisms of SQL Server is its complexity. While the software is designed for enterprise-level data management, its interface and features can be difficult for inexperienced users to navigate and understand. The software's advanced features, such as data warehousing, data mining, and OLAP, can also be difficult to set up and use for non-technical users. Additionally, the software's query language, T-SQL, can be challenging for those who are new to database programming.2)Integration with Other Tools: users have reported that SQL Server may have difficulty integrating with other tools and technologies, such as big data platforms, cloud services, and data visualization tools. While the software provides multiple options for connecting to other data sources, some users have found that the integration process can be complex and time-consuming.3)Limited Mobile Support: SQL Server provides limited support for mobile devices, which can be a drawback for organizations that require mobile access to their data. Some users have reported that the software's mobile app is limited in functionality and may not provide the same level of access to data as the desktop version.4)Poor User Experience: Some users have reported that the user interface of SQL Server can be confusing and not as user-friendly as other database management

Relation Database Management

Commentaires : The availability of server editions and the Microsoft premium support where you will get access to premium support with Microsoft skilled specialist.The SQL server also supports for use on Linux

Avantages :

The Microsoft SQL server editions available like enterprise, standard, web, developer for basic data management and business intelligence features and SQL server components availability was the most advantage of using SQL server

Inconvénients :

The enterprise edition was more expensive for per core licence it is around $14,200.

Review for Microsoft SQL Server

Commentaires : Overall, Microsoft SQL Server is a powerful and versatile database management system that provides a range of features and tools for data management, security, and business intelligence. However, its cost and complexity may be a barrier for some users, particularly those who are new to database management.

Avantages :

Scalability: Microsoft SQL Server is designed to scale with your business needs, whether you have a small database or a large enterprise-scale database.Security: SQL Server provides a range of security features, including encryption, authentication, and access control, to help keep your data secure.Performance: SQL Server is optimized for performance, with features like in-memory processing and columnstore indexes that can help speed up queries and data processing.Integration: SQL Server is designed to integrate seamlessly with other Microsoft products, including Azure and Power BI.Business intelligence: SQL Server provides a range of tools for business intelligence, including reporting, data visualization, and data mining, which can help you gain insights into your data.

Inconvénients :

Cost: SQL Server can be expensive, particularly for larger enterprises with complex data requirements.Learning curve: SQL Server can be complex to learn, particularly for users who are new to database management systems.Platform limitations: SQL Server is a Windows-based platform, which may limit its use in environments where other operating systems are preferred.Support: While Microsoft provides extensive support for SQL Server, some users may find that support options are limited compared to other database management systems.

Microsoft SQL Server is one of the easiest and convenient SQL server to use for a beginner

Commentaires : Database management in an IT organization that deals with customer data is not an issue to be resolved, it is a necessity.

Avantages :

Microsoft SQL server is very efficient to use, as a developer with limited database management knowledge, I found it very helpful to get the prompts for the completion of commands, correction of syntax, and search/filter other tables for similar commands. I absolutely love using Microsoft SQL Server for database management.

Inconvénients :

Everything I noticed is great about Microsoft SQL Server, since I havent worked much upon other database applications, I found it very quick to learn and implement. No dislikes for me.

Microsoft SQL Server Review

Commentaires : SQL server is perfect since I can utilize a similar language same application, and for little clients, it utilizes free choice, and just for best execution or greater information need to pay for it Can utilize it locally on the cloud

Avantages :

"One of the most famous information base stages gives you the ideal permeability of the tables. Simple client association permits you to deal with your information base from any place...""Microsoft SQL Server is an extraordinary information the executives, dissecting, and revealing device which helps in the everyday running of a business. The extremely strong highlights it ...""I have had a decent involvement in SQL Server as it has shown how itself can be dependable, secure, and proficient."

Inconvénients :

"Permitting is confounding, at whatever point you have a permit by call or by central processor center, it's a digit hard to comprehend how they apply the costs.""The last thing I found about the product is blunder explanations, a few times an additional room can cause an enormous issue, and tossing the mistake which isn't like...""The absence of detailing administrations is a horrendous deficiency. It could have an option in Apache, or even permit combination with Windows servers for this demand...."

Modern Relational Database Management System

Commentaires : My experience with it has been very good. We were looking for a database management system for our time and attendance system, and Microsoft SQL Server was the best choice because it supported the system very well.

Avantages :

It served as a Database management system for our attendance management system, and It served the purpose very well.

Inconvénients :

The initial setup is a bit complicated, but it is worth it.

Microsoft SQL server since 2015

Avantages :

This is a feature rich, flexible, highly available and scalable database management system. It is the first database management system that I used when I was an undergraduate. This supports for in-memory processing and big data such as hadoop. There are many developer tools supported by this like visual studio integration.

Inconvénients :

This is expensive and might not be affordable for startups.

SQL Server

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.

Powerful and Scalable Database Software

Commentaires : Storing large quantities of production data to solve quality and efficiency problems has been a big use for SQL. All of the reporting and power to analyze data has solved countless puzzles for me in my job capacity. I also have done a lot of database administration for our ERP software and the tiles to tune and optimize have always been very helpful.

Avantages :

One of my favorite things about Microsoft SQL Server is the scalability. Whether you are using the free version for a small program running on a local machine or running an entire factory it is the same basic concept of programming and administration. I really appreciated being able to work to have a database software that could grow and expand when I need it too. Additionally the reporting and automation packages that come with it are super powerful. I would absolutely recommend using Microsoft SQL Server as anyone’s data as software

Inconvénients :

The biggest con in my opinion is that some of the more advanced features for big data analysis and high availability are in the top tier pricing which can be hard for smaller companies to afford. Other than that I have never not been able to solve a problem with Microsoft SQL.

This sequel is better

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.

A database system that you can trust your data with!

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

Microsoft RDBMS Solution

Commentaires : Whenever I need to rely on a robust DBMS for any of my platforms, provided that my clients have the financial muscle to support it, I always recommend going with SQL Server. So, in that sense, I can say that my overall experience is remarkable all over the years I have been deploying solutions backed up by this Database System.

Avantages :

Among the most interesting features of Microsoft SQL Server we can disclose the following: Robust & Secure System Easy to Deploy Performance+ Integration with Public Cloud such as Microsoft Azure

Inconvénients :

As many of Microsoft Premium products, SQL Server license is really expensive.

best of server

Commentaires : I have using this more than 5 years , by comparing with other server platforms sql server te best of easy use for developers as well as Administrators

Avantages :

It was easy of access to manage SQL server agent can manage most required part with automate rather than doing manual And also design with more user friendly compare with others

Inconvénients :

While queries of data some times have to convert it to tostring, but I hope its possible to identify and convert automatically, then developers will reduse their codings

every day using MS SQL Server

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

My Database Engine

Commentaires : It has been awsome as i am now a good Database developer because of this awsome tool.

Avantages :

I am not DBA but i am using it from more than 3 years from university days and still using SQL in my professional life. I like everything about from query writing, to testing using SQL profiler. Most about it is that you can do most thing by using queries and GUI as well. Its easy to connect and configure with any kind of application with single line of code. Most thing about it is its prediction while typing and highlighting errors with underline squiggly.

Inconvénients :

As a developer i cant find anything that i dont like in it. Its always more than my expectations.

SQL Server Great for SQL Database Creation

Commentaires : Overall, my experience with SQL Server has been pleasant. If I had employees, I would strongly recommend them to use is as their main source to create SQL databases. It makes sense to use a platform that is specialized and can be a one stop shop. That is what SQL Server is.

Avantages :

I love the ability to create SQL databases separate from Visual Studio. Although you can create databases in VS, I like how SQL Server Management Studio is designed specifically for database creation. Plus, it has advanced features for database admins which Visual Studio does not. After creating a database, the admin can migrate the SQL Server database in Visual Studio.

Inconvénients :

It is difficult to learn if someone at a beginning level is using it. They will need to utilize the many tutorials provided within EDX.org, youtube or Udemy (to name a few) to learn it. It makes sense if you know how to create SQL databases and the SQL language prior to using it. If not, I suggest to learn SQL first prior to jumping into SQL Server to do database management.

SQL Server 2016 - Features Review

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.

Review of Microsoft SQL Server

Commentaires : I can provide you with objective information about Microsoft SQL Server.SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is widely used for managing and storing data in various applications, ranging from small to large-scale enterprises. It provides various features such as reliability, scalability, security, and compatibility with other Microsoft products. The recent versions of SQL Server also offer advanced analytics and machine learning capabilities.SQL Server is highly configurable and offers several editions to meet the needs of different organizations. Additionally, it supports multiple programming languages, including T-SQL, .NET, and Python.Overall, Microsoft SQL Server is a robust and versatile RDBMS that has proven to be a reliable solution for many organizations.

Avantages :

I can say that Microsoft SQL Server is a popular and widely used relational database management system known for its reliability, performance, and security features. It also offers a comprehensive set of enterprise-level tools and services, making it a suitable option for large-scale data management and business intelligence applications. Additionally, it has a large and active user community, providing extensive resources and support.

Inconvénients :

some common criticisms of Microsoft SQL Server:Cost: The cost of acquiring and maintaining SQL Server can be high, especially for enterprise-level users.Complexity: SQL Server can be complex to set up and manage, especially for smaller organizations with limited IT resources.Limited platform support: SQL Server runs primarily on Windows operating systems, limiting its compatibility with other platforms.Lack of open-source options: Unlike other database management systems, SQL Server does not have a widely available open-source alternative, which could limit its accessibility for some users.These are just some of the common criticisms of Microsoft SQL Server and may not apply to all users or use cases.

Best DBMS tool for scalable enterprises

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.

Microsoft SQL server review

Commentaires : One of the problems that Microsoft SQL Server solves is the challenge of managing large and complex datasets. The system provides a wide range of data management and analysis tools, making it possible to perform complex data operations with ease. For example, it provides data warehousing features, such as data mining and OLAP (Online Analytical Processing), which allow organizations to perform advanced data analysis and decision making. This helps organizations to make informed decisions based on their data, leading to better outcomes and increased efficiency.Another problem that Microsoft SQL Server solves is the challenge of ensuring data security and availability. The system provides a robust security model that allows administrators to control access to data and manage permissions at various levels. It also supports encryption, making it possible to secure sensitive data in the database. Additionally, Microsoft SQL Server provides disaster recovery options, such as database backups, log shipping, and replication, which help to ensure that data is always available and can be recovered in case of a failure. This provides peace of mind for organizations and helps to protect their critical data.

Avantages :

The feature i likes the most about Microsoft SQL server is its high performance and scalability. It supports high concurrent user access, allowing multiple users to work on the same database simultaneously without slowing down the system. Additionally, it provides the ability to scale up and down as needed, making it ideal for organisations of all sizes.Another advantage of Microsoft SQL Server is its security features. The system provides a robust security model that allows administrators to control access to data and manage permissions at various levels. It also supports encryption, making it possible to secure sensitive data in the database. Microsoft SQL Server also provides disaster recovery options, such as database backups, log shipping, and replication, which help to ensure that data is always available and can be recovered in case of a failure.Microsoft SQL Server also provides a range of data management and analysis tools, making it possible to perform complex data operations with ease. For example, it provides data warehousing features, such as data mining and OLAP (Online Analytical Processing), which allow organisations to perform advanced data analysis and decision making. It also provides Business Intelligence tools, such as reporting and dashboard tools, which allow organisations to visualise and analyse data in a meaningful way.

Inconvénients :

One thing which i didn't like about Microsoft SQL Server is its cost. Although it provides many advanced features and tools, it can be expensive for small businesses like us with limited budgets. The cost of licensing, hardware, and maintenance can quickly add up, especially if you need to scale your database solution as your organisation grows. Additionally, certain advanced features, such as data warehousing and business intelligence tools, can also be expensive and may require additional licenses.