We changed our name from IT Central Station: Here's why

SQL Server Valuable Features

RN
President at a consultancy with 1-10 employees

One of the things I most like about SQL Server is the log shipping piece.

I have another client who uses GP, and they use Power BI to take the data out of the back end. I'm doing an IT assessment there, so I'm not really involved in that specifically, other than the fact this person has too many rights.

I have an auditing background, and I spent 25 years doing IT auditing as well. I understand I'm not a programmer, but I've been involved with enough of them. The log shipping really is one of the greatest features. It is not the only database you can do it in, but that was one of the better features of it because I am a backup nut. We use Veeam Backup and Replication to a local mass storage, but then we fully replicate everything in Veeam to another site with the exact same server set up at our other location. But I wasn't satisfied with that from a disaster recovery point of view. My IT company was, but I was not. I said, "I want to do SQL log shipping. I want to do an SQL backup and SQL log shipping and move it to Azure in the cloud," which is what we do every day. We have an hour by hour backup, in addition to our multiple nightly backups and our replication to our other site, and we've had to use it and it worked. This is a great feature.

View full review »
User at a manufacturing company with 10,001+ employees

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. 

View full review »
MV
Information Technology Software Developer at a financial services firm with 501-1,000 employees

The solution is very easy to use for me. SQL is the most user-friendly system for databasing aside from Postgres. 

Due to the financial costs of Postgres, the SQL system is a good alternative as the product can be utilized free of charge. 

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.

View full review »
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: January 2022.
565,689 professionals have used our research since 2012.
Senior Software Developer at a manufacturing company with 5,001-10,000 employees

Out of all the tools in the complete SQL Server package, I'm mainly using Toolbox and SQL Profiler because I'm using SSIS packets, so we're using job scheduling a lot. And sometimes we are creating the SSIS packages, so I'm using SQL Server for MSD for maintenance purposes. SQL Server is quite user-friendly. I have experience with Oracle and PostgreSQL, so out of three, I like SQL Server a lot.

View full review »
BL
Certified Adjunct Faculty, School of Engineering and Computing at a university with 1,001-5,000 employees

The most valuable aspect of the solution is that the metadata is just generalized. Metadata is the way that data is described both for technical aspects of building a database and for the user interfaces. Our metadata is the objects attached to the database, not in the software. 

It helps with moving the design of the database into reality.

View full review »
IT Manager : HOD at Condot Systems

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. As a part of optimization, it is good for processing huge amounts of data.

View full review »
RS
Business Analytics Manager at a transportation company with 201-500 employees

Their integration, SSRS and SSIS tools are really good. The flow is great.

The pricing of the solution is okay. It's less expensive than Oracle, for example.

View full review »
AL
Senior Service Architect at a tech services company with 501-1,000 employees

While I don't like SQL Server so much, the selection was for clients so we needed to utilize it. Of course, one thing is that as great with this and other Microsoft products is that it's quite well documented and there are also light versions available. If you need to do something, you can also try it somehow on your own computer and so on. 

If I'm helping a client to define what they need to have or what they need to do in a public sector procurement process quite often we cannot fix the database as it would be limiting the competition. That's why we never rule out the SQL Server; it should be included as an option at this level.

The solution is stable. 

I haven't had issues with sizing or scaling.

View full review »
System engineer at a financial services firm with 51-200 employees

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.

We do not know all the features of SQL Server.

View full review »
Manager Digital Technologies at a real estate/law firm with 51-200 employees

When you use the solution with Azure, for example, you get very good scalability. You can scale fast, whether it is horizontal or vertical.

If we use the product as a PaaS, Platform as a Service, it comes with all the security features you need - including against DDoS attacks.

The product offers good bloc storage, which you can buy at an additional cost. This allows you to have large object storage if you need it.

Over a period of time, their split engine has evolved and in the latest version, they've done a lot. Even from the management tool perspective, a lot of things have been done. A lot of functions have been added.

The initial setup is pretty straightforward.

Technical support has been good.

The solution has the capability to scale.

The pricing isn't as high as other options.

SQL is very easy to use. That's a very good thing about it in general.

View full review »
Cloud Data Architect (Data service Team) at NTT Data India Enterprise Application Services Pri

The feature that I have found most valuable is that it is easy to code. You can very easily get a resource to work on that. For example, if we have a big project it's hard to get a good resource in the IT industry. However, since SQL Server is the most popular solution, you can easily get resources to use it so the risk factors are very, very low. Even if someone leaves the company, you can easily replace them.

Additionally, it is very stable. 

You don't need to struggle for anything. Most of the codes are there.

View full review »
DG
Information Systems Manager at a aerospace/defense firm with 51-200 employees

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.

View full review »
WL
Senior Programmer at a tech services company with 51-200 employees

I personally work with Microsoft products and therefore I like the continuity it provides. I like sticking with the brand.

The solution is very stable.

The product has very good online documentation that can be used for troubleshooting.

The solution can scale as necessary.

We've found the setup to be quick and relatively easy.

View full review »
JJ
Business Solutions Architect at a real estate/law firm with 501-1,000 employees

Support and adoption are important because skills are available to lower the total cost of ownership. 

High availability, read-only copy synchronization, and data integrity mean that it is relatively easy to ensure data security, availability, and integrity. Lower tier SKUs offer high-end features.

Data integration is available, as SSIS offers a flexible data integration platform with rich features including .NET integration for web-service integration, or bus architectures.

SSAS analytical DBs are powerful yet easy to develop and own.

SSRS offers enterprise reporting that is reasonably user-friendly.

It is easy to deploy cloud/on-premises hybrid implementations with a familiar and consistent toolset.

View full review »
Business Intelligence Manager at a consumer goods company with 10,001+ employees

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.

View full review »
MA
Senior DBA & IT Consultant at MA Consulting

A valuable feature of the solution is that it is comparatively simpler to manage than Oracle. Now that the Linux version is an option, this can be taken into consideration, since Windows limited one's use to things which could only be done in Windows. 

View full review »
Technical Director at Progetti e Soluzioni

The product is very stable.

It offers very good documentation. When there are some little issues, it's always very easy to go into the documentation for troubleshooting purposes. There's just so much documentation on hand and a really great community around the product that is very helpful.

It's a very complete product.

We've found it to basically be pretty problem-free.

The integration with other products has always been quite good.

The security of the product has never given us any issues.

View full review »
Information Technology Manager at OrchidaSoft

It is easy to maintain, and it's easy to set up.

It is also easy to develop. Overall, it's easy.

It can work with many different sizes of data, anywhere from 10 to 50 gigs of data.

The performance of SQL Server is perfect. It does not need to be enhanced.

View full review »
DB
Sr Tech Business Analyst, Group Data Projects & Ventures at a financial services firm with 10,001+ employees

SQL SSIS is the most useful aspect of the solution.

We find the product to be relatively stable.

The solution seems to be pretty flexible.

View full review »
BL
Owner at 2 Bit

The solution is very fast. 

The data is reliable and I can normalize the database and normalize the data so that I can collect whatever information I need. If I collect the data correctly, then I can share whatever report I want.

Normally, when the data is in the database, it will always be a long-term information holder, instead of putting it in Excel or something like a spreadsheet or something like that. 

For me, the initial setup is very easy as I have years of experience with the product.

View full review »
Senior Developer at a government with 51-200 employees

There's a lot of great features. I like T-SQL, which is wonderful. The backups are excellent. There's a lot of things that are much easier to manage. All of the features and functions within the SQL language itself, the store procedures, I really, really enjoy. The security has been excellent.

The initial setup is very straightforward. 

The stability is very good.

We find it easy to scale if we need to.

View full review »
FZ
Principal Database And Cloud Architect at a financial services firm with 10,001+ employees

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.

View full review »
MJ
Senior Database Administrator at a government with 11-50 employees

The ease of administration, in general, is the solution's most valuable aspect.

You can make the solution work pretty fast. Performance isn't an issue.

The initial setup is quick and easy.

The solution is stable.

The scalability is good. 

View full review »
Vice President, Product Engineering at Logitix

The solution offers very high performance.

It is a very reliable solution. We find it to be quite stable.

We've found the product to be very scalable, specifically from MSSQL

The product offers various deployment models.

View full review »
Assistant Manager at ECU

Security is obviously the most valuable feature because I can provide certain logins for a particular level of security and I can provide specific permissions for certain logins. That's a very good feature. I like the user interface as well, it's easy to use. The SSMS Management Studio, which we use to do some work in database file query is a recent feature from 2018 and the SSMS is quite good. It has many features and it also shows the query statistics which I was not getting previously. The other feature I like is the query store which helped me a lot to analyze the data getting hit on the database. 

View full review »
RB
Software Engineer at a comms service provider with 51-200 employees

The solution is quite stable.

The solution has the capability of scaling.

The performance is good. 

It's very easy to use.

View full review »
AM
Sr. DBA/Developer at a financial services firm with 5,001-10,000 employees

The performance is a very valuable aspect of the solution.

SQL is very easy to manage.

View full review »
Computer engineering student at a educational organization with 501-1,000 employees

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 solution is very stable.

The solution scales well.

The initial setup is straightforward. 

View full review »
CEO Owner at ALESON ITC

I like the Always On tool which improves the SQL server availability. We cross-link servers with Oracle, MySQL and other platforms using PolyBase as a service to join with big data systems like Spark.

View full review »
SM
Global Head ICT (CITP & MIE) at The Aga Khan Academies

It is a stable product, and it runs seamlessly. It is not complex.

It has been there for a long time, and they are doing whatever bug fixes they have to do. 

View full review »
SQL Database Administrator at Aurora Mental Health Center

The solution comes at a more effective price than Oracle. 

It's a little bit more advanced than using MySQL or NoSQL.

It's more prevalent in the industry than SQL Postgre.

The initial setup is mostly straightforward.

The product is scalable. 

The stability has been mostly pretty good.

There is a lot of information about the solution readily available online.

View full review »
Lead Technical Instructor at codehub

I feel that this is the simplest of solutions. It is user-friendly, is a robust tool and is always reliable to users. The solution is within the Windows environment. This means that all users, who are already accustomed to Windows, will naturally prefer to use this environment over that of Linux or another operating system. 

View full review »
MM
Director of Data Analytics at a insurance company with 1,001-5,000 employees

That question is not that easy to answer, to say that there is a feature in a database that you like more than others. When you are running a database, you expect it to do many different things, and if fails in one area, it basically takes it out of the picture completely.

View full review »
GF at Innopact GmbH

If you compare the SQL Server with the block storage it's stable and it's working. 

The product has been on the market for over 25 or 30 years. It's an extremely mature solution.

The solution is pretty scalable.

The initial setup is pretty straightforward, depending on your requirements.

View full review »
MO
Senior Manager at a financial services firm with 201-500 employees

We find the Microsoft SQL Server affordable compared to its real competitors. 

We find it easy to manage. 

It offers a very robust infrastructure for us.

The solution is easy to set up.

We have found the stability to be good.

We've had a good experience with technical support. They are helpful.

View full review »
Sr. Consultant (Enterprise Architect) at Devoteam

SQL Server, as a database, is great.

When it comes to the governmental sector, it is easily dealt with and can handle a big load of data. Specifically, after they added the capability of building a big data cluster from the SQL Server itself it's been great. 

If it was a database developer who was working with it or database admin, it provides a lot of tools and potential utilization that helps in doing the work in the right way.

Stability-wise, it's stable. 

If we want to expand to other servers and create an extra node, it's expandable. If you want to connect it with another, let's say, cloud node, it's also expandable with the cloud node. 

Security-wise, it provides most of the required security aspects in the market suchg as hashing, or encrypting, or hiding some data in tables (according to privileges and tools of the users). That can be done throughout it easily. 

It's an out-of-the-box solution. Lately, after they created the SQL Azure, if you use the Azure SQL Explorer, or SQL Server Management Studio, both of them can connect to the same database easily. It's natively built on the same core.

View full review »
MB
BI Developer at a manufacturing company with 1,001-5,000 employees

The performance can be great. Tuning and understanding SSAS is not straightforward.

View full review »
YT
Information Security Manager at a financial services firm with 501-1,000 employees

We have found the feature that allows us to publish web applications to be valuable. 

We have 20 servers and we use disparate ones for different applications, such as Kaspersky Anti-Virus Server and Windows SharePoint in respects of the surveillance system. 

View full review »
Senior Digital Services Engineer at a pharma/biotech company with 1,001-5,000 employees

The solution is stable.

The product is scalable.

The solution is configurable. 

View full review »
Systems Specialist at Zillione Technology

Its availability for a secured server is one of its most valuable features. Also its replication features are valuable- we can manage eight replicas. Their clustering and availability groups are also valuable.

View full review »
Senior Manager - RPA & Transition at a financial services firm with 10,001+ employees

The solution is extremely stable. The performance is reliable.

The scalability of the solution is very good.

Technical support is pretty good. they are prompt in their responses.

View full review »
MP
Database Administrator at a computer software company with 10,001+ employees

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.

View full review »
KG
Lead Data Architect at a financial services firm with 1,001-5,000 employees

The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products.

View full review »
Data Architect at ACPAS Loan Management Software

The product is very good at centralizing information.

The solution has very good features related to timezones.

The product is quite stable.

If you need to, you can scale the solution very easily.

View full review »
Sr. Supervisor - Enterprises Application DBA at a manufacturing company with 10,001+ employees

- There are hundreds of "Dynamic Management Views" (DMVs) & Dynamic Management Functions (DMFs) that are system views & system functions that return metadata of the system state and they provide valuable insight into the current SQL instance state. 

- Resumable online index rebuild 

- Table Partitioning and the Swap out to covert a Table Partition into a separate table.

- Python & R2 Integration, Graph Databases

- Automatic Database Tuning

- Very reliable Backup technology and many more

View full review »
Deputy Manager IT at Carl Bechem Lubricants India Pvt Ltd

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. Two other new batch mode features, memory grant feedback, and adaptive joins will enhance SQL Server's performance and efficiency as well. It is good to move from Microsoft to deal with big data analytics

View full review »
GK
Data Architect at a computer software company with 1,001-5,000 employees

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. You don't have to do all the scripting for the database, then all the tables, keys, etc. It takes all that out of your hands.

View full review »
RS
Senior Developer at a non-profit with 10,001+ employees

One of the big advantages of this product is its performance, where it works well when the data is not complex.

View full review »
Operations Director at ALTERSIS Performance

The solution has proven to be very flexible.

The product is quite stable.

Overall, we've found it to be extremely easy to use. 

The initial setup is pretty straightforward. It's not difficult to implement and the deployment doesn't take too long.

Technical support has been pretty good so far. They are helpful.

It's a good option for those that have a lot of Microsoft solutions in use.

View full review »
PR
Technical Specialist at a media company with 10,001+ employees

The solution is very easy to use. It's intuitive and easy to navigate. Overall, it's a straightforward product.

You don't really need a learning code to study MySQL. If you know the basics, it's quite easy to use the product. There isn't a high learning curve and you don't have to be overly technical.

The initial setup was straightforward.

View full review »
KR
Information Technology Administrator at a tech services company with 51-200 employees

The most valuable feature is that it is easy to use and you don't have to do a lot of configuration. For example, there is no installation.

When you want to insert data, it is easy to do. For example, if I want to test something then I log into my GitHub account, download what I want, and then upload it to the SQL server.

The integration with other products like SQL Developer is really good. Connecting it to Visual Studio is also quite good.

View full review »
Solutions Architect at One Click

Scalability, cluster ability, ease of use, ease of implementation — these are all great. 

View full review »
RU
Senior Solutions Architect at a manufacturing company with 51-200 employees

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. Additionally, the solution is simple and if it is configured properly it performs very well. 

View full review »
SB
Software Manager at a computer software company with 1-10 employees

The only problem with this product is that it doesn't have an open source version.

View full review »
Solution Architect at a tech services company with 1,001-5,000 employees

The basic features of the solution are excellent overall.

The initial setup isn't overly complex.

The pricing is reasonable.

The solution scales well.

The solutions very fast. It reads and writes six to eight times faster than any other tool.

View full review »
NMS Service Automation & RPA Technical Lead at Vodafone

The solution is very stable.

The product scales well.

From a security perspective, we have no complaints. 

The initial setup is very straightforward. 

View full review »
CM
Systems Engineer at a tech services company with 11-50 employees

Right now, we are using DB2 and the SQL Server. It's really helpful for the replication of data. It's real-time and very easy to use.

The product is very stable. We find it to be reliable.

The scalability is okay. 

The installation is pretty straightforward.

View full review »
MM
Head of IT, CTO at a insurance company with 51-200 employees

It's much more friendly in comparison with Oracle.

We are using the standard features. I don't see any areas that can be simplified with the standard functionalities. We don't use any special extended features.

From my point of view, using SQL Server 2017 and 2019 is very good. I haven't experienced any issues or been in a situation where I was struggling with problems for which I didn't have access to proper documentation or proper functions.

View full review »
HG
Technical Content Writer at a computer software company with 51-200 employees

Since MongoDB, we have come up and there are lots of tools that do enhance the database management system or keep an eye on our data. People can easily access it. 

The solution is stable. It's reliable. 

The initial setup is simple. 

View full review »
JP
Analytics Manager - Data and Capability at a financial services firm with 1,001-5,000 employees

The analytics are pretty good.

As a data warehouse and storage solution, it's quite good.

It's easy to put the data back onto the SQL Server or Oracle. 

The solution is pretty fast. We find it to be responsive.

There are a lot of services, such as the SSISS, SIS, and SSI's that work quite well.

View full review »
PT
Database Administration Team Leader at a transportation company with 10,001+ employees

I believe Always On is the most valuable feature. It's also easy to use and not very tricky.

View full review »
OY
Specialist Systems Engineer at a tech services company with 51-200 employees

I use the menu on the management view credit section to get information from the database.

View full review »
RV
2de Solution Engineer - storage & compute at a financial services firm with 10,001+ employees

The solution is very stable. 

The scalability of the product is great.

View full review »
AY
IT Service Manager at a financial services firm with 5,001-10,000 employees

Overall, it's a very good device.

The solution has proven to be very stable.

The scalability potential is very high.

The initial setup is very straightforward and the deployment happens very quickly.

View full review »
IC
ICT Consultant at a tech services company with 11-50 employees

The solution is easy to use.

The deployments are very easy.

Technical support is very helpful.

The product can scale if a company needs it to.

The stability is quite reliable. 

View full review »
NS
Network Engineer at a pharma/biotech company with 1,001-5,000 employees

The pricing of the product is very good.

We've found the stability to be very reliable.

The initial setup isn't too complicated. It's pretty straightforward.

View full review »
RN
Manager at a pharma/biotech company with 10,001+ employees

It's a standard product that is used with standard applications, which is why we use it.

There is no lack of features.

View full review »
IT Officer at a manufacturing company with 201-500 employees

Stability and usability, which is quite simple, are two of the solution's most valuable features. 

View full review »
SY
CTO at a tech services company with 11-50 employees

The solution is very common. It's easy to use.

The product offers a lot of support. Technical support has been great.

It's a reliable solution currently in this space.

The solution doesn't take a long time to set up. It's pretty straightforward. 

View full review »
VP
Chief Information Officer at a financial services firm with 501-1,000 employees

Working with SQL Server, it is quite convenient to use the SSMS tools to write a profile. I also like the profiling tools.

I like that the new version has a memory-optimized table to improve the performance.

View full review »
Solution Architect at KIAN company

The solution is very easy to use.

View full review »
Principal JDE Business Analyst at a manufacturing company with 201-500 employees

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.

They've been adding a lot of great functionality such as columnstore indexes to improve the way indexes are rebuilt and to be able to do online index rebuilds. All those are great features.

View full review »
RP
Project manager at a tech services company with 11-50 employees

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.

View full review »
SS
Founder and Managing Director at a tech services company with 11-50 employees

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

View full review »
KH
Data Solution Architect at a comms service provider with 1,001-5,000 employees

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.

View full review »
HB
Domain architect at a financial services firm with 10,001+ employees

The solution is easy to use, has rich feature sets, and is business-oriented. 

View full review »
IT Manager at a consumer goods company with 1,001-5,000 employees

What I like best about this product is the environment.

The documentation and manuals are very good.

View full review »
System Engineer at a non-profit with 10,001+ employees

The most valuable feature is the system architecture.

View full review »
MS
Head of Technical Support at a real estate/law firm with 51-200 employees

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.

View full review »
SJ
Chief Technology Officer & Vice President, Delivery at a recruiting/HR firm with 1-10 employees

It is easy to use and very stable.

View full review »
EN
Head of Data Analytics at a tech services company with 11-50 employees

This solution is very easy to use, and it's very democratic in the enterprise. A lot of customers use this type of database, and that's why the deployments are very often in the medium enterprise.

View full review »
SL
Enterprise Architect at a educational organization with 10,001+ employees

SQL Server is easier to use than Oracle, programming-wise.

It is the latest technology and pretty powerful in terms of the high availability of the virtual server.

View full review »
MP
CEO at SkyNet

What I like most is the management, as it is very easy compared with other products.

View full review »
System Administrator at ARTIc

We have found the solution valuable because we are able to easily create a query, shrink, backup, and make new tables.

View full review »
ST
Director at a tech services company with 10,001+ employees

We like the whole product and we use most of the features.

View full review »
Digital Transformation Architect at Comdata

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.

View full review »
Product Owner at a tech services company with 201-500 employees

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.

View full review »
Software Engineer at a tech services company with 11-50 employees

SQL Server and their offers are very good. You can switch over, export, and do other things. I got access from users and it is very flexible to use.

View full review »
Senior Database Administrator at ITGStore

Most valuable features include: high availability, clustering, save backup and recovery.

View full review »
KG
Associate Manager at a consultancy with 501-1,000 employees

The best feature in SQL Server is the CDC mechanism for adding data incrementally. Another good feature is the ability to store any type of data in SQL Server, it's a big advantage.

View full review »
IT Assistant at Hotel 2 Fevrier

the database management tool is very easy to use and largely meets expectations

View full review »
VC
Sr. Solution Architect at a computer software company with 5,001-10,000 employees

The solution is very easy to use, because even the technical engineers that we get are able to use it more efficiently. I like the programming interface they have where they help us get the table names that we are dealing with, and the field names in that particular table. 

The interface for building the queries or writing the store procedures is good.

View full review »
JI
System Analyst and Team Lead at a tech services company with 11-50 employees

Many developers like SQL Server.

View full review »
Technical Department Manager at Direcbusiness Technologies, Inc.

We have been using SQL Server from the start, so it's a stable product.

View full review »
General Manager/MVP at Yotta Infrastructure Solutions LLP

The features that we have found the most valuable are reliability, availability perspective, and current scalability. 

View full review »
Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa

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.

View full review »
Marketo Consultant at Webtech software servies

The most valuable features of this solution are easy queries and straightforward programming for beginners.

View full review »
Principal, Sr. IT Consultant at a consultancy with 51-200 employees

It is fairly easy to work with. I like the high-availability options, like mirroring for example, and the high-availability groups. It's quite an interesting feature that enables high availability for the SQL Server. I think it's important. So that's the feature that I'm particularly interested in and it works pretty well.

View full review »
CEO at netison

Microsoft has a very broad landscape of products that they provide—almost everything that you need. SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer. And even if you don't like Microsoft, you should know how to use it because just about every customer uses Microsoft, so you have to use it. So it doesn't matter if I like it. It's everywhere, so you have to know how to use it.

View full review »
Owner at BNS

The most valuable features are programmability and reliability.

View full review »
SR
Director -Data Architecture and Engineering

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.

View full review »
AA
ASM at a healthcare company with 51-200 employees

SQL Server is definitely easy to use, and with the volume that we have, it's also stable.  Maintenance is much easier compared to other products. I may not be comfortable with Oracle because I don't have much experience with it. But in this case, SQL Server is much better for me. 

View full review »
AJ
Data Analyst

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.

View full review »
Managing Partner at Veribir Ltd

SQL Server is easy to manage because all our DevOps team are familiar with it and simple to access because it is cloud-based.

View full review »
KJ
Deputy Manager at a computer software company with 10,001+ employees

SQL Server has scaled as per our requirements.

View full review »
CL
Senior BI Consultant at a tech services company with 11-50 employees

I have found the whole solution with all its features wonderful.

View full review »
SS
Software Engineer at a tech services company with 10,001+ employees

This product works well, serving as our operational database.

The interface is user friendly.

View full review »
Infrastructure and Networks at a financial services firm with 10,001+ employees

We like everything. We use all of the features that SQL offers. 

We like business integration, database, and analysis.

View full review »
VG
Regional Head Customer Experience at a financial services firm with 10,001+ employees

The solution is easy to use and provides similar features to other competitors.

View full review »
BR
senior system integrator at a retailer with 10,001+ employees

It's useful as a backend server.

We have found the solution to be scalable. 

View full review »
MG
CEO at a tech services company with 11-50 employees

It is integrated with Microsoft tools.

View full review »
DK
Senior Systems Engineer at a energy/utilities company with 201-500 employees

It is easy to deploy and easy to maintain.

View full review »
CL
Data Analyst at a tech company with 51-200 employees

It's a flexible solution.

View full review »
System administrator at ZEST WEG Group

The availability is the most valuable feature. It has high availability. It also has good performance. 

View full review »
KH
Program Solution Architect at a tech services company with 11-50 employees

It is easy to use and easy to perform a backup.

It is easy to find resources that can manage SQL Server.

View full review »
IT manager at a wholesaler/distributor with 10,001+ employees

The performance of the SQL Server is very good.

View full review »
IF
CEO at a tech services company with 51-200 employees

I have found that SQL Server works very well in the Microsoft Dynamics environment.

View full review »
PS
Project Manager at a comms service provider with 51-200 employees

In Poland, SQL Server is the most popular database engine, and overall, our customers like it.

View full review »
SK
Senior Architect at a computer software company with 10,001+ employees

It's more user-friendly than most databases. If we don't have to use the command mode, it's very easy.

View full review »
Information Security Engineer at a security firm with 11-50 employees

The most valuable feature is easy installation. It was very easy to install.

The interface is very user-friendly.

View full review »
Sr. Network Administrator at ACMC

One of the most valuable features of SQL Server is that it's easy to use. 

View full review »
DWH Architect at B2BSoft

The columnstore index feature is useful for us, and we also use the integration services. It is also very stable.

View full review »
EK
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees

I like that it's a cloud solution, is simple to set up, and is simple to use.

We are also totally satisfied with the stability and scalability of SQL Server.

View full review »
TU
Managing Director at D3

One of the best features of SQL Server is the efficient retrieval of information.

View full review »
GV
Manager

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.

View full review »
RP
IT Specialist at a government with 1,001-5,000 employees

I like that it's relatively stable.

View full review »
DS
Technical Director at a security firm with 51-200 employees

It is stable, and it works okay.

View full review »
AA
Modern Data Center and Cloud Engineer II at a tech services company with 51-200 employees

The solution is easy to use.

View full review »
SP
Chief Information Officer at a tech consulting company with 51-200 employees

The main feature of this solution is ease of use.

View full review »
AK
System Architect, SCRUM Product Owner at a tech company with 10,001+ employees

I have found SQL Server easy to use.

View full review »
AW
Database Operation Assistant Manager at a consumer goods company with 10,001+ employees

I have found the most valuable features to be the flexibility and the vast amount of features available.

View full review »
YA
Chief of Information Technology at a manufacturing company with 201-500 employees

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.

View full review »
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: January 2022.
565,689 professionals have used our research since 2012.