Microsoft SQL Server reviews

Data Management made so easy with MS SQL Server

Pluspunten:

For any developer, before first they can this own what their apps are going to be developed in their should think of what server should host their database. I do believe that MS SQL Server is the best on the marketing when comes to data management and administration. The best feature that i really love the most on MS SQL Server is the ability to disable remote execution of your queries and really helps protect data integrity in case your server authentication has been compromised. You can also be rest assured that your data is consistent and accurate at all times. Yes hackers some times can try sql injection but i believe MS SQL Server its the most secure servers around.

Minpunten:

The license key for MS SQL might cost you an arm and a leg but at the end of the day its really worth it when you think of a platform where you are able to develop enterprise apps that secure and helps with Business Intelligence.

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

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

Pluspunten:

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

Minpunten:

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

SQL Server as a primary tool for developers

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

Pluspunten:

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.

Minpunten:

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.

Microsoft SQL Server - Reliable Database Management Tool

Opmerkingen: After using Microsoft SQL Server for several years, I have found it to be a reliable and secure database management system. Its robust features and intuitive coding language make it suitable for a variety of tasks and its user-friendly interface is easy to navigate.

Pluspunten:

Microsoft SQL Server is a reliable database management tool that provides a secure and structured environment for data storage and retrieval. It offers robust features for data manipulation, including advanced query optimization, transaction processing and performance monitoring. The user interface is easy to use and the coding language is intuitive, making it suitable for both experienced and novice developers.

Minpunten:

Microsoft SQL Server can be tricky to configure and maintain, as it requires an in-depth knowledge of database design and administration. Additionally, certain features are only available with the enterprise edition, which can be costly for smaller businesses.

the best SQL tool you will ever use!

Opmerkingen: We currently have more than 10 databases in our company, all under SQL Server, with good maintenance and applying good resources, we have guaranteed stability and scalability. excellent product.

Pluspunten:

For me it is the best tool for managing databases, the functionalities it has meet my needs, being able to add Microsoft Integration Services is the best I have been able to use.

Minpunten:

it may take a bit of resources to get its full potential

Enterprise DBMS

Pluspunten:

We had to migrate our free databases to SQL server because we reached many gigabytes in a few tables and needed a fast and reliable software to handle it and integrate with some BI products. Microsoft SQL Server had no issues and works really fine.

Minpunten:

License costs are major issues , but any other paid database costs about the same. It is still a bit overkill for us but we are looking at using it in the cloud as a PaaS.

Microsoft SQL Server: A Comprehensive Database Management Solution

Opmerkingen: In conclusion, Microsoft SQL Server is a comprehensive and reliable database management system that is ideal for organizations of all sizes. Although it has some limitations, its strengths in scalability, security, and customer support make it a strong choice for businesses that need a robust and dependable database solution.

Pluspunten:

Scalability: Microsoft SQL Server is capable of handling high volumes of data and provides fast, efficient performance, even under heavy load. This makes it ideal for organizations that need to grow and scale their databases over time.Security: The software provides a secure platform for storing sensitive data, with built-in encryption and authentication capabilities to keep your data safe from unauthorized access.Customer Support: Microsoft provides a range of resources, including documentation, tutorials, and forums, to help users get the most out of the software. And if you do encounter any problems, Microsoft's support team is always on hand to assist you.Intuitive User Interface: Microsoft SQL Server has a user-friendly interface that makes it easy for even those with limited technical expertise to manage and maintain their databases.

Minpunten:

Complexity: Although Microsoft SQL Server is designed to be user-friendly, it can still be complex for those who are new to database management. Some users may find it challenging to get started with the software and may require additional training and support.Cost: Microsoft SQL Server can be expensive compared to other database management systems, particularly for larger organizations that need to purchase multiple licenses.

Most widely used database

Opmerkingen: Microsoft MySQL is great. I definitely suggest it to anyone seeking a robust and user-friendly database programme.

Pluspunten:

I recently tried Microsoft MySQL and was very impressed with its performance. Installing and configuring the software was simple. The documentation made it easy to start using the product. Microsoft MySQL was powerful and feature-rich. It offered everything I needed to set up a database quickly, and the assistance was great. Complex searches on massive datasets ran smoothly.

Minpunten:

Microsoft MySQL is good, but some has disappointed me. The interface was slow and poorly documented. The information was dispersed and hard to find, so I had trouble answering my simple queries. Microsoft MySQL cost more than a generic database. Technical support was also poor. My questions were answered slowly and generically. It required time to explore and solve problems on my own.

Exploring the Power of Microsoft SQL Server

Opmerkingen: It is complex to set up and manage, and may require significant hardware resources, these limitations are outweighed by the benefits it provides for managing large amounts of data and ensuring high availability and security. Additionally, Microsoft provides extensive documentation and support resources, making it easier for users to get the most out of the software. Overall, Microsoft SQL Server is a highly effective solution for managing large and complex databases.

Pluspunten:

The SQL Server provides the ability to handle large amounts of data and to scale up to meet the demands of growing businesses. SQL Server provides several features for ensuring high availability, such as database mirroring, failover clustering, and Always On Availability Groups, which help ensure that the database is always available, even in the event of a failure.

Minpunten:

SQL Server can be complex to set up and manage, especially for those who are not familiar with database management systems

Manage Databases with ease

Opmerkingen: Overall we will continue to use Microsoft SQL Server as we have no intention of using an alternative.

Pluspunten:

SQL Server allows us to create and manage our Databases with its integrated and powerful engine. Running queries is easy which allows us to select, update or sort data with its easy to use interface.

Minpunten:

The License of the Microsoft SQL server can be expensive compared to alternatives

Microsoft RDBMS Solution

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

Pluspunten:

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

Minpunten:

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

Microsoft SQL Server for Business

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

Pluspunten:

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.

Minpunten:

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.

Powerful and Scalable Database Software

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

Pluspunten:

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

Minpunten:

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.

All time market leader

Opmerkingen: When comes to business critical it can consume the raw data, process it and provide to the user understandable format. More than decades, this software providing tremendous help to business to evolve and reach their goals by fetching data from any formate and load it into structured form and with help of powerful Tsql query languge we able to fetch the right data from database. We can also connect with any visualization tool to provide the better UI(Power BI) to users to take right decision.

Pluspunten:

1. Optimized storage and querying business critical data. 2. Powerful Tsql Query language. 3. Query execution plan to predict and optimize the data. 4. Query profiler to find out anomaly and query latency.

Minpunten:

1. We need to take care of all patching works. 2. We need to take care of all infrastructure scalability(RAM,HDD and IO etc) 3. Server maintenance and outrage time is high.

The best database management system

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

Pluspunten:

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.

Minpunten:

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

every day using MS SQL Server

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

Pluspunten:

- 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

Minpunten:

it expensive compared by other competitors

My Database Engine

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

Pluspunten:

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.

Minpunten:

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

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

Pluspunten:

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.

Minpunten:

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.

A great database system for any purpose

Opmerkingen: We use SQL Server for a data warehouse project in a large bank. It stores thousands of tables and terabytes of data, so it's mandatory for DBMS to run smoothly. SQL server does its job extremely well.

Pluspunten:

SQL server is packed with features. It was a very fun job to implement it and using it is even better. Runs well, built-in tools are useful and plenty.

Minpunten:

It takes up quite a bit of resources. Sometimes, tech support isn't very helpful. Otherwise, it's good.

SQL Server | The Gold Standard

Opmerkingen: Overall, I have had an excellent experience with SQL Server. It is cost-effective, provides a great deal of functionality, and is a great piece of software for database management.

Pluspunten:

In my current role as an Application Manager, it is vital to have a means of benchmarking and assessing application performance. The tools within SQL Server, particularly Activity Monitor, make it very easy to determine when performance bottlenecks arise.

Minpunten:

I believe the default alerting functionality could be improved. For example, I believe it would make more sense to alert the user to any failed SQL Agent jobs when launching SSMS. Currently, either alerts need to be set up individually or the user would need to view the job history.

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

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

Pluspunten:

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.

Minpunten:

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.

Ridiculously powerful and full of features we do not make use of. We love it, and cannot do without.

Opmerkingen: This software practically runs our facility. Without it, we couldn't keep track of our animals or our people (staff, members, donors). To us, this software is well worth the costs involved.

Pluspunten:

SQL Server is just so incredibly powerful, most users probably do not know how much it can do, or how much it can handle. In our type of organization, we deal with people and animals. We rely on donors and members for funding, we track everything about our animals from health issues, to medications, to physical exercise. Every one of our systems relies on, as the backbone, SQL Server. This software is powerful, versatile, and reliable. With pretty much every department of ours needing some type of database, standardizing to SQL Server was just the best move. It can handle it all. It can track it all. And it can report on it all for us. To date, we use it for: our Accounting software, our donor tracking, our membership tracking, our animal tracking (includes tracking from what zoo or aquarium animals came, their medical history, their exercise history, their diet, their location in our facility, their trainers, their behavioral issues/environmental factors), our vet's digital imaging systems, our guest services scheduling, our security systems (surveillance, door locks), our water quality and hvac sysytems logging and controls, our point of sale system (for admissions and food court and ecommerce), and our facility management software (maintenance and IT requests). This system does indeed handle everything we need it to.

Minpunten:

You need a lot of training to make the most of it. Or it could cost you a lot if you have to pay a developer to help you get the most out of your systems. Luckily a couple of us are really into databases, and we both have a lot of experience with SQL, we can do most things in-house. But still the amount of training we go through to keep current, or to keep learning is probably the biggest "problem" with this software. Most software packages, you can buy, setup, receive a few hours or a few days of training, and you'll be good to go. With SQL, if you intend to use it, to get the most of out it, you will need more extensive training, or to hire people to put in the work. It's not cheap. But it can help you accomplish so much if you put in the time.

SQL Server a Building Block of Tech Stack

Opmerkingen: Good overall experience. We're addressing the need to store, transform, and retrieve data. Information has become the backbone of many technological and business operations, and almost everything I work on goes through a SQL database to accomplish the job. It's one tier of applications that is used almost everywhere. SQL Server allows us to query data for reporting to end users, and also provides options to move and transform the data to different environments.

Pluspunten:

At our firm, we have a completely Microsoft tech stack; from servers, databases, middleware, peripheral applications, etc. When using all Microsoft products, it is extremely easy to connect and integrate between applications, servers, and databases. I am less sure about integrating with other providers (such as oracle), but I know its possible with a little more effort. Maintenance, backups, restores, disaster recovery plans all seem routine now. The product is very familiar and there is ample documentation and general SQL training. Get a good DBA and your servers will stay healthy as well; certain system settings are important, and monitoring those and adjusting for your business is prudent. SSMS is an easy IDE to use and perform any function. You can use SQL to automate many tasks, and I really like the SQL jobs. SSIS lets me automate so much, even to and from external vendors, using SFTP or some other mechanism. It extends SQL Server to use any script or basic Windows command.

Minpunten:

When you run into an issue, it can be hard to resolve. An example would be when Microsoft data connectors aren't working. Understanding and getting the right supporting software installed is important; like OLE DB and ODBC connectors. Another difficulty can be performance. As data sets get larger, this is more important. While there are enough tools to investigate and troubleshoot, sometimes it's just a big effort to try to query tune, index, or adjust server settings to get the results in performance that you want. Queries seem to only get more complex, and data sets larger. I am pretty sure other databases will perform better with Big Data.

Easy to configure, difficult to master

Opmerkingen: Easily the most intuitive RDBMS software out of the box.

Pluspunten:

The most noteworthy features of Microsoft SQL Server are the many tools and wizards that allow even novice users to get started by creating tables and views without extensive knowledge of relational databases. The query wizard can even assist with creating queries with its intuitive IDE. These features lower the intimidating barrier to entry that accompanies other relational database software such as Oracle or MySQL. There is even a free version call Express that allows anyone to dabble in the software before committing to the product. Aside from the user assisted features, the other appealing aspect of SQL Server is the integration with other Microsoft products that are probably already running in an organization. SQL Server interfaces with Active Directory allowing for easy user management so appropriate levels of database access can be allotted via group membership. This is useful because even something simple like user access management in another RDBMS may present a learning curve for anyone that is not a DBA. With SQL Server a general IT resource could manage user access with an existing knowledge of Active Directory providing more time to focus on core database design.

Minpunten:

SQL Server carries a high cost subscription based licensing cost. The user assistance features provide a great introduction to relational databases, but there is still a significant and continuous learning curve. Databases continue to evolve with industry need. Anyone that interacts significantly with SQL Server during day to day database or application design may need to consider yearly training to keep up with all the changes.

Perfect for all types of workloads!

Opmerkingen: Have used SQL Server as a a Relational Database (RDBMS) for the past 15 years, primarily to support SAP based enterprise workloads. Microsoft's development of SQL Server has been fuelled by its largest customer - SAP, in order to provide better functionality to rival its competition (Oracle, DB2, Informix (who remembers this one?). I started with MSSQL 2000 and boy has it come a long way. MSSQL versions are denoted via the year and is still a practice till today, similar to how Microsoft denotes its Windows versions. To date, the latest version of MSSQL 2017 is also supported on SAP, and I am sure once MSSQL 2019 is released later this year it would also be certified by SAP.

Pluspunten:

The review is based on my experience of using SQL Server as a database with SAP. What I like about MSSQL : - ACID compliant like any enterprise based RDBMS (Oracle, IBM DB2, SAP HANA) - Runs well and scales well with commodity x86 hardware - Various editions to suit customer needs and requirements. For example Express Edition for small workloads and is free, or all the way to Enterprise Edition for state-of-the-art functionality (High-Availability, Disaster Recovery etc. to prevent Single-Points-of-Failure). Its current functionality definitely rivals the existing enterprise RDBMS's - Straightforward learning curve as it is Windows based. Unlike other RDBMS's (e.g. Oracle or DB2), administering a MSSQL DB is very easy GUI (SQL Server Management Studio) is very easy to use especially if coming from Oracle/DB2, or if you're learning from scratch - Supports Linux (finally!) - MSSQL is no longer limited to the Windows platform, and Microsoft has released version on Linux to compete with the likes of Oracle, DB2, etc.

Minpunten:

Over my years of using MSSQL have encountered numerous bugs (performance issues, corrupted data, etc.) but these are normal with other RDBMS's (Oracle, DB2, SAP HANA, etc.) given the enterprise nature of the workloads. Can't really think of any other disadvantages.