The most valuable features for database management in SQL Server are SQL Server Management Studio and Visual Studio Code with its administration capabilities.
Director of Product Management at SID GLOBAL SOLUTIONS LLC
Real User
Top 5
2024-03-22T13:01:31Z
Mar 22, 2024
I find query optimization to be highly valuable for data management. Additionally, drag-and-drop query creation greatly facilitates data management tasks.
SQL Server, a widely adopted database management system, is utilized across numerous sectors. Initially competing with Oracle and Db2, SQL Server has gained popularity. It serves as the backend database for a variety of applications.
SQL Server is an inexpensive solution. I recommend it if the project isn't sensitive. SQL is similar to Oracle and integrates well with tools in the cloud environment. The difference is that Oracle is for data solutions where there is replication and moderation.
It is secure, and it is fast. For our present database size, we are using the Always-On feature on SQL Server so that our transactions are replicated among three servers. If one server goes down, we can find the data from other servers. We have benefited from this feature.
Executive Director at a manufacturing company with 5,001-10,000 employees
Real User
2022-01-30T06:27:25Z
Jan 30, 2022
SQL Server is similar to other Microsoft products, such as BI, they are easy to use. You do not need to have an expensive BD to maintain them. All the useful intuitive features you find in Microsoft solutions you will find in SQL Server.
Principal JDE Business Analyst at a manufacturing company with 201-500 employees
Real User
2022-01-04T21:51:36Z
Jan 4, 2022
I like the availability group functionality. We are setting up more clusters using availability groups. The enterprise licensing or Software Assurance makes it a little bit cheaper as well. It is nice to have that read-only copy for reporting and everything else.
I love SQL Server's Common Table Expression. In addition to that, I like its lead and lag functions. That helped us reduce a lot of code when comparing rows in SQL Server.
They have improved the UI and ease of accessing the database and server which is good.
You can load it up and start using it from the very minute it is implemented.
System engineer at a financial services firm with 51-200 employees
Real User
2021-10-29T15:40:18Z
Oct 29, 2021
The most valuable feature would most likely be querying. We query a lot, we use a lot of stored procedures. As for other features, such as replication and all other more fancy features we don't use them the most. I do not know, but perhaps the DBAs would be the best people who know of the features that they use, but as far as how I use it, it's just for querying and running stored procedures. We use the bare minimum features.
The replication feature, user interface, reporting services, and notification services are really good. They are providing SQL profiler and SQLCMD as their integrated software, so we don't find it difficult to integrate any of our third-party applications with MS SQL because all of them support MS SQL very clearly.
Founder and Managing Director at Analytic Brains Technologies Private Limited
Real User
2021-09-23T10:01:00Z
Sep 23, 2021
SQL Server's Management Studio is very user friendly. I like their database and the additional features it offers. It's also easy to integrate SQL Server with things like CLR, PowerShell, and command shell
Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa
Real User
2021-09-20T10:53:41Z
Sep 20, 2021
The SQL Server is low maintenance, it does not require advanced technical skills to maintain or use it as you might in other similar database solutions. You need some knowledge on how to access the solution and how to query it but it is fairly straightforward.
Data Architect at a computer software company with 1,001-5,000 employees
Real User
2021-09-16T18:10:00Z
Sep 16, 2021
It's easy to use and fairly intuitive. I do development and data analysis, so we do a lot of work with SSIS and SQL Job Scheduler. Deploying new databases is very simple with things like BACPAC.
SQL Server is very good, it can be used as a transactional database and used to support the data warehouse. Additionally, the ANSI-compliant satisfies our database properties.
Sr. Supervisor - Enterprises Application DBA at a manufacturing company with 10,001+ employees
Real User
2021-08-11T20:53:08Z
Aug 11, 2021
I like that it's very easy to use, and Veeam is excellent. There are tons of experts and writers in the area now, and we don't find the same for other databases.
Principal Database And Cloud Architect at a financial services firm with 10,001+ employees
Real User
2021-07-31T01:45:43Z
Jul 31, 2021
I love the developer version. Microsoft tells you about all the cool things they provided for everybody. You can develop and do anything with it. It's really good to learn. Oracle will not give you that much freedom, and Microsoft really kills it.
You don't do anything with it but develop, learn, break, and push it to its limits. If there are problems, you show Microsoft or ask them, "what's going on here?" There is good community support for the developer edition, and that's what I really appreciate. You can teach people about it without limitations. You can have small databases created. You can keep it for a year and then work on it. It's a good thing for learners and developers.
Senior Solutions Architect at a manufacturing company with 51-200 employees
Real User
2021-07-09T12:40:31Z
Jul 9, 2021
The most valuable feature of the solution, compared to other RDBMS solutions, such as Oracle MySQL or IBM DB2, it is more user-friendly and has backward compatibility. For example, if you have an application that requires an old version of SQL Server and you have the latest version of the license, you are able to install and use it in backward compatibility mode. They keep supporting the existing legacy application.
Head of Technical Support at a real estate/law firm with 51-200 employees
Real User
2021-07-09T10:16:58Z
Jul 9, 2021
SQL Server provides good performance. Most of the SQL solutions can be integrated and this solution is no different, you are able to link other databases. For example, we have Oracle running a Postgres Server and it is linked. It follows the ISO standard when it comes to commands, it works well.
Computer engineering student at a educational organization with 501-1,000 employees
Real User
2021-05-19T14:14:21Z
May 19, 2021
The most valuable aspect of the solution is that it's integrated with the Visual Studio and also with Microsoft SQL Server Management Studio. It's a tool they have and it's quite easy to use and understand. It's the interface for programming for SQL Services.
Database Administrator at a computer software company with 10,001+ employees
Real User
2021-05-07T23:13:07Z
May 7, 2021
Microsoft SQL Server is one of the better database administration software packages out there. It runs primarily on Windows Server platforms, but it can also run on Linux platforms.
It is a typical database solution, and it is working well so far. It is easy to use, and it is also very common and popular, which makes it easy to find a support partner.
Information Systems Manager at a aerospace/defense firm with 51-200 employees
Real User
2021-03-30T19:25:39Z
Mar 30, 2021
The management studio is probably the thing we use the most for running quick queries and creating quick reports. Quite often, somebody comes and says, "Hey, can you find XYZ?" It is so much easier just to jump in there and run a quick query.
It is a very user-friendly solution. It is easy to manage the databases and troubleshoot any issue. It is a perfect solution for the volume or transactions that we need to manage.
Chief of Information Technology at a manufacturing company with 201-500 employees
Real User
2021-03-04T04:45:30Z
Mar 4, 2021
We have found there are many useful features such as the solution is continually being upgraded, ETL capabilities for extracting and transformation, and it is very easy to use.
Project manager at a tech services company with 11-50 employees
Real User
2021-02-09T19:41:58Z
Feb 9, 2021
Its speed and the ease of server management are valuable. If I compare Microsoft SQL Server to MySQL, what I like in Microsoft SQL Server is the speed. We are using Microsoft Management Studio for managing our Microsoft SQL Server, and the user interface that I get to work with is also better.
Works at a manufacturing company with 10,001+ employees
Real User
2021-01-23T13:47:39Z
Jan 23, 2021
It is a pretty good solution. The on-premise version 2019 has many features, and they had introduced a really good and stable environment in version 2019. It has very good integration with big data clusters and other things. It covers pretty much everything that you can do with a SQL server. You can use any language to connect to it, which is not there in other solutions. They have also introduced Python, and it also has ArcScale.
PaaS is a modern, scalable database. You can use Power Automate and a lot of features in this. It is very easy, and you don't have to worry about versions and upgrades.
Microsoft keeps on adding new features to this solution. Microsoft is improving its connectivity on an ongoing basis. It connects well with Office 365. If you see something not working, in a couple of weeks, it is going to work because there is a team working on it. You can vote for the things that are missing, and Microsoft can work on them depending on the product that they're launching.
Deputy Manager IT at Carl Bechem Lubricants India Pvt. Ltd.
Real User
Top 5
2020-08-06T12:29:00Z
Aug 6, 2020
The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python involves aggregation, batch mode - which processes rows of data several at a time, can be very helpful.
I have experience with this product for many years. I never have problems with it. It can handle a PC, and it can also handle huge data. It is fast and efficient.
SQL Server is a relational database management system (RDBMS) by Microsoft. The product's main purposes are to store data and retrieve it as requested by other software applications - on the same computer or on another computer across a shared network. The solution is built on top of Structured Query Language (SQL), which is a standardized programming language used for relational database management.
The product is tied to Transact-SQL (T-SQL), which is an implementation of SQL from Microsoft...
We use it for our on-premises solutions, virtual servers and SSAS, SSRS packages. Also, our applications are .NET based, so it made to use it.
SQL Server is a highly stable solution.
The most valuable features for database management in SQL Server are SQL Server Management Studio and Visual Studio Code with its administration capabilities.
I find query optimization to be highly valuable for data management. Additionally, drag-and-drop query creation greatly facilitates data management tasks.
It is an extremely stable solution.
The product's initial setup phase was simple.
SQL Server, a widely adopted database management system, is utilized across numerous sectors. Initially competing with Oracle and Db2, SQL Server has gained popularity. It serves as the backend database for a variety of applications.
SQL Server is easy to manage.
Having everything in one centralized set of databases is the most valuable feature.
The product is easy to use.
The solution is valuable because it seamlessly extracts reports and enables the collection of information from different tables.
I would say that it is a stable product.
We're satisfied with the stability.
Microsoft is less demanding because everything is GUI, unlike Oracle, where you need to use command lines.
It's great that the nodes are synchronized so if you lose one it automatically moves to another.
I've been using SQL Server for 20 years, and there is nothing that it can't do. It is awesome.
The most valuable feature of SQL Server is the performance.
The most valuable features of SQL Server are the speed, great support, and it is from a known vendor.
Its usability is very good. Its performance is satisfactory.
SQL Server is very scalable because we use it across a couple of different types of applications, such as micro-infrastructure setup and server farm.
The license fee is very low.
The support from Microsoft has been good.
SQL Server is a very mature solution.
We found it to be quite scalable.
It works fine in terms of performance and stability.
The scalability is very good.
Very stable relational database management system that offers ease of management, querying, and scaling. It has well-designed databases.
SQL Server is an inexpensive solution. I recommend it if the project isn't sensitive. SQL is similar to Oracle and integrates well with tools in the cloud environment. The difference is that Oracle is for data solutions where there is replication and moderation.
Backups hardly get corrupt.
For my business requirements, the performance is good.
This solution is user-friendly and easy to understand.
The backup capabilities are extremely good.
SQL Server's most valuable features are that it is a large number of community resources to help you out. that's one, and then it is quite powerful.
It's great that the database engine is always on.
The technical support that Microsoft provides is great.
It is secure, and it is fast. For our present database size, we are using the Always-On feature on SQL Server so that our transactions are replicated among three servers. If one server goes down, we can find the data from other servers. We have benefited from this feature.
SQL is stable.
Easy to implement and user-friendly relational database management system. This product is stable and scalable.
It's a very stable solution.
Its security is good. The GUI of SQL Server is also very good.
SQL Server is similar to other Microsoft products, such as BI, they are easy to use. You do not need to have an expensive BD to maintain them. All the useful intuitive features you find in Microsoft solutions you will find in SQL Server.
If we want to expand to other servers and create an extra node, it's expandable.
It is easy to deploy and easy to maintain.
The solution has a user-friendly environment and supporting functionalities. It also has great memory and processing databases.
I like the availability group functionality. We are setting up more clusters using availability groups. The enterprise licensing or Software Assurance makes it a little bit cheaper as well. It is nice to have that read-only copy for reporting and everything else.
I love SQL Server's Common Table Expression. In addition to that, I like its lead and lag functions. That helped us reduce a lot of code when comparing rows in SQL Server.
We have found the solution to be scalable.
The solution is stable. It's reliable.
Stability and usability, which is quite simple, are two of the solution's most valuable features.
One of the most valuable features of SQL Server is that it's easy to use.
We are using the net for our environment. We're using the ADF Azure data factory for our analysis services, and it is pretty good.
I have contacted technical support, and overall my experience with technical support was okay.
I have found SQL Server easy to use.
SQL Server has good performance. It is one of the best features.
One of the things I most like about SQL Server is the log shipping piece. This is a great feature.
There is a lot of information about the solution readily available online.
The interface for building the queries or writing the store procedures is good.
The solution has a reliable database.
They have improved the UI and ease of accessing the database and server which is good.
You can load it up and start using it from the very minute it is implemented.
Many developers like SQL Server.
SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer.
The most valuable feature would most likely be querying. We query a lot, we use a lot of stored procedures. As for other features, such as replication and all other more fancy features we don't use them the most. I do not know, but perhaps the DBAs would be the best people who know of the features that they use, but as far as how I use it, it's just for querying and running stored procedures. We use the bare minimum features.
The Always On tool improves the SQL server availability.
SQL Server is quite user-friendly. I have experience with Oracle and PostgreSQL, so out of three, I like SQL Server a lot.
SQL Server scales well.
The replication feature, user interface, reporting services, and notification services are really good. They are providing SQL profiler and SQLCMD as their integrated software, so we don't find it difficult to integrate any of our third-party applications with MS SQL because all of them support MS SQL very clearly.
The performance of the SQL Server is very good.
One of the best features of SQL Server is the efficient retrieval of information.
A valuable feature of the solution is that it is comparatively simpler to manage than Oracle.
SQL Server's performance is fine.
The initial setup was straightforward.
The installation was straightforward. We did not have a large installation and it took a couple of weeks to complete.
SQL Server's Management Studio is very user friendly. I like their database and the additional features it offers. It's also easy to integrate SQL Server with things like CLR, PowerShell, and command shell
The ease of administration, in general, is the solution's most valuable aspect.
The SQL Server is low maintenance, it does not require advanced technical skills to maintain or use it as you might in other similar database solutions. You need some knowledge on how to access the solution and how to query it but it is fairly straightforward.
It is fairly easy to work with. I like the high-availability options, like mirroring for example, and the high-availability groups.
It's easy to use and fairly intuitive. I do development and data analysis, so we do a lot of work with SSIS and SQL Job Scheduler. Deploying new databases is very simple with things like BACPAC.
The solution is very common. It's easy to use.
The solution is configurable.
There is no lack of features.
SQL Server is easy to manage because all our DevOps team are familiar with it and simple to access because it is cloud-based.
The solution is stable.
SQL Server is very good, it can be used as a transactional database and used to support the data warehouse. Additionally, the ANSI-compliant satisfies our database properties.
In Poland, SQL Server is the most popular database engine, and overall, our customers like it.
Similar to Microsoft SQL, it is easy to scale.
For me, the initial setup is very easy as I have years of experience with the product.
I like that it's very easy to use, and Veeam is excellent. There are tons of experts and writers in the area now, and we don't find the same for other databases.
The product can scale if a company needs it to.
Most valuable features include: high availability, clustering, save backup and recovery.
The solution is easy to use.
I love the developer version. Microsoft tells you about all the cool things they provided for everybody. You can develop and do anything with it. It's really good to learn. Oracle will not give you that much freedom, and Microsoft really kills it.
You don't do anything with it but develop, learn, break, and push it to its limits. If there are problems, you show Microsoft or ask them, "what's going on here?" There is good community support for the developer edition, and that's what I really appreciate. You can teach people about it without limitations. You can have small databases created. You can keep it for a year and then work on it. It's a good thing for learners and developers.
The initial setup is easy, flawless.
The backups are excellent.
The installation is pretty straightforward.
The solution is easy to use and provides similar features to other competitors.
The solution is easy to set up.
The scalability of the product is great.
The main feature of this solution is ease of use.
The most valuable features of this solution are easy queries and straightforward programming for beginners.
The most valuable feature of the solution, compared to other RDBMS solutions, such as Oracle MySQL or IBM DB2, it is more user-friendly and has backward compatibility. For example, if you have an application that requires an old version of SQL Server and you have the latest version of the license, you are able to install and use it in backward compatibility mode. They keep supporting the existing legacy application.
SQL Server provides good performance. Most of the SQL solutions can be integrated and this solution is no different, you are able to link other databases. For example, we have Oracle running a Postgres Server and it is linked. It follows the ISO standard when it comes to commands, it works well.
I haven't really experienced any issues that required the assistance of technical support.
I have found the whole solution with all its features wonderful.
We have found the solution valuable because we are able to easily create a query, shrink, backup, and make new tables.
The solution is very easy to use.
I like that it's a cloud solution, is simple to set up, and is simple to use.
From a security perspective, we have no complaints.
I like that it's relatively stable.
The solution is user-friendly, is a robust tool and is always reliable to users.
The solution has proven to be very stable.
I have found that SQL Server works very well in the Microsoft Dynamics environment.
Scalability, cluster ability, ease of use, ease of implementation — these are all great.
The solution can be used for a host of applications.
It is a stable product, and it runs seamlessly. It is not complex.
It is integrated with Microsoft tools.
The performance of SQL Server is perfect.
Since we can automate most of our tasks, it means that the management is very easy.
We have found the feature that allows us to publish web applications to be valuable.
The most valuable aspect of the solution is that it's integrated with the Visual Studio and also with Microsoft SQL Server Management Studio. It's a tool they have and it's quite easy to use and understand. It's the interface for programming for SQL Services.
The initial setup is time-efficient and can be done independently.
It is stable, and it works okay.
It's a good option for those that have a lot of Microsoft solutions in use.
Very easy to use, and it's very democratic in the enterprise.
The solution is very easy to use. It's intuitive and easy to navigate. Overall, it's a straightforward product.
Microsoft SQL Server is one of the better database administration software packages out there. It runs primarily on Windows Server platforms, but it can also run on Linux platforms.
It's a flexible solution.
I believe Always On is the most valuable feature. It's also easy to use and not very tricky.
It is easy to use and very stable.
The product has been on the market for over 25 or 30 years. It's an extremely mature solution.
I have found the most valuable features to be the flexibility and the vast amount of features available.
The performance is reliable.
SQL Server is definitely easy to use, and with the volume that we have, it's also stable.
It is a typical database solution, and it is working well so far. It is easy to use, and it is also very common and popular, which makes it easy to find a support partner.
The solution is easy to use, has rich feature sets, and is business-oriented.
The most valuable feature is that it is easy to use and you don't have to do a lot of configuration.
It is easy to manage for the administrator. It is also easy to use for applications that are Windows-based.
It is a very stable product, and it has got backup and recovery tools.
What I like most is the management, as it is very easy compared with other products.
SQL Server and their offers are very good. You can switch over, export, and do other things.
The installation is really easy.
The performance is good.
We like business integration, database, and analysis.
The management studio is probably the thing we use the most for running quick queries and creating quick reports. Quite often, somebody comes and says, "Hey, can you find XYZ?" It is so much easier just to jump in there and run a quick query.
We've found it to basically be pretty problem-free.
The performance is great.
It's much more friendly in comparison with Oracle.
It is a very user-friendly solution. It is easy to manage the databases and troubleshoot any issue. It is a perfect solution for the volume or transactions that we need to manage.
A big advantage is the ability to store any type of data in SQL Server.
The solution has the capability to scale.
It is easy to use and easy to perform a backup.
The initial setup isn't overly complex.
We have found there are many useful features such as the solution is continually being upgraded, ETL capabilities for extracting and transformation, and it is very easy to use.
Stability is one of the most valuable features.
I use the menu on the management view credit section to get information from the database.
I like that the new version has a memory-optimized table to improve the performance.
The most valuable feature is easy installation. It was very easy to install.
The solution offers very high performance.
The security and vulnerability management are well-managed through the vendor.
It is the latest technology and pretty powerful in terms of the high availability of the virtual server.
The interface is user friendly.
Its speed and the ease of server management are valuable. If I compare Microsoft SQL Server to MySQL, what I like in Microsoft SQL Server is the speed. We are using Microsoft Management Studio for managing our Microsoft SQL Server, and the user interface that I get to work with is also better.
It's more user-friendly than most databases.
The pricing of the solution is okay. It's less expensive than Oracle, for example.
If you need to, you can scale the solution very easily.
The product has very good online documentation that can be used for troubleshooting.
It is a pretty good solution. The on-premise version 2019 has many features, and they had introduced a really good and stable environment in version 2019. It has very good integration with big data clusters and other things. It covers pretty much everything that you can do with a SQL server. You can use any language to connect to it, which is not there in other solutions. They have also introduced Python, and it also has ArcScale.
PaaS is a modern, scalable database. You can use Power Automate and a lot of features in this. It is very easy, and you don't have to worry about versions and upgrades.
Microsoft keeps on adding new features to this solution. Microsoft is improving its connectivity on an ongoing basis. It connects well with Office 365. If you see something not working, in a couple of weeks, it is going to work because there is a team working on it. You can vote for the things that are missing, and Microsoft can work on them depending on the product that they're launching.
SQL Server is quite stable. And now we are using the Lattice 2017 version.
I have seen that this is a very stable product.
As a data warehouse and storage solution, it's quite good.
The solution seems to be pretty flexible.
It's a good learning environment, it's easy enough to learn and understand. Anybody that picks up the language early on will be able to develop in it.
Technical support is very good.
The columnstore index feature is useful for us, and we also use the integration services. It is also very stable.
The pricing of the product is very good.
The most valuable features are programmability and reliability.
The documentation and manuals are very good.
We have many users, between 50 and 100 using the SQL Server product.
The technical support is good.
The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products.
The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python involves aggregation, batch mode - which processes rows of data several at a time, can be very helpful.
The features that we have found the most valuable are reliability, availability perspective, and current scalability.
It helps with moving the design of the database into reality.
Very good security features.
SQL Server is a stable product.
The feature that I have found most valuable is that it is easy to code.
SQL is very easy to manage.
The availability is the most valuable feature. It has high availability. It also has good performance.
The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations.
It is one of the most stable relational databases out there.
I have experience with this product for many years. I never have problems with it. It can handle a PC, and it can also handle huge data. It is fast and efficient.
Tuning Advisor suggests where to add indexes and from where to remove them. It works like an adviser.
This solution has proven stability and operational power.