SQL Server Valuable Features
RK
Ranjeet Kumar
Senior General Manager at Worly Plumbing Supply, Inc.
Agent service is a good feature of SQL Server, where you can schedule certain tasks. The solution's encryption feature allows the data to be encrypted while transferring from one place to another. The solution's performance and speed are also good. Indexing and Magic Tables are very good features of SQL Server. We have a different transition style with the solution.
View full review »HS
HarkamalSingh
Works 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 »PJ
PeterJones
Professional Services Manager at Business Intelligence DA
SQL Server is very popular in this region because of the price.
From version 2014 to version 2016, the performance really improved. We also moved to new hardware, resulting in a four-times speed-up of the processing. Now we can supply a 16-core, 15TB, data warehouse loading hundreds of thousands of transactions per day for $100,000 purchase or cheaper via hosting partners. The price of SE for the features it provides is why we use it so often.
View full review »Buyer's Guide
SQL Server
March 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,995 professionals have used our research since 2012.
SQL Server is essentially the backbone of every microservice. From a developer's perspective, it is the backbone of all microservices. The tool enables data retrieval, set data, and essential operations, ensuring the smooth functioning of applications. In essence, it is the integral part that keeps applications operational.
The solution's security features are good.
PE
Phil Ernst
Chief Technology Officer at Wolff Logics
The fact that SQL Server fully integrates within the entire Microsoft ecosystem is a plus.
View full review »MJ
seniorda483732
Senior Database Administrator at a comms service provider with 10,001+ 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 »We use SQL Server Reporting Services, and it is very good. We use scheduled jobs to transfer reports from one server to another server.
View full review »HB
reviewer1264416
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 »SQL Server is very easy to use. A person with limited skill also can handle the software easily. The retrieving time of the data is very fast. You don't require any higher configuration machine for that. If you have very limited resources, you can easily manage.
View full review »Whenever we had to restore the data, it was not as difficult as restoring the database to any other RDBMS. The restoration of data is very easy compared to any other database. The solution is very intuitive and easy to use. It is one of the best relational database systems in the market. The restore and backup strategy was not complicated. The ease of use was excellent compared to any other databases.
View full review »I find query optimization to be highly valuable for data management. Additionally, drag-and-drop query creation greatly facilitates data management tasks.
View full review »I can't comment on the valuable features of the product right now since I recently downloaded some whitepaper and manuals. I downloaded the documentation related to the tool, but I haven't used much of the system. I know that SQL Server is a good system, based on a report I read on the Gartner website.
The solution is valuable because it seamlessly extracts reports and enables the collection of information from different tables.
View full review »MH
Mohammed Habeeb
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 »AM
Aju Mathai
Database Architect at Huron Consulting
- Performance-wise, it is an excellent tool.
- It is a Microsoft product, so there's a lot of support.
- It's not a new tool; it has been around for a while.
- It is one of the top five relational databases in the market.
- It is very user-friendly.
- There are a lot of resources available for it.
SE
Simon Evans
IT Analysis at Kirkby (Tyres) Ltd
Having everything in one centralized set of databases is the most valuable feature.
View full review »MM
Mpho Morake
Group CEO at Mmusi Group
It works fine in terms of performance and stability.
View full review »AK
Anandan Kanagarajan
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 »YM
YahyaMahdy
Senior Data Engeer at Qbros
The valuable features are Excel integration, writing a query in SQL Server, exporting the data, and copying the data.
View full review »RN
reviewer1695144
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 »PL
reviewer1056471
Manager Global Identity & Access Management at a healthcare company with 10,001+ employees
What I find most useful in SQL Server is that it's easier to manage and to query. Its databases are well-designed. It's easy to do any changes, and it's easy to query the database through reports and whatever information you need.
View full review »BL
reviewer1389651
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 »DV
Dany Van Den Steen
Database Administrator at Court of Audit Belgium
The most valuable features for database management in SQL Server are SQL Server Management Studio and Visual Studio Code with its administration capabilities.
View full review »JM
JasminaMarkovic
BI Developer at a tech services company with 51-200 employees
The most valuable aspect is the ability to use jobs and various functions to accomplish specific tasks, which cannot be achieved with standard procedures alone. This allows for a combination of features and functionalities to be employed.
View full review »FR
Francisco Racionero
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 »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 »MP
Marcelo Pissinati
IT Cybersecurity and Compliance Coordinator at Plaenge
The most valuable feature of SQL Server is that it is easy to set up.
View full review »This is a user-friendly solution. It's great that I can extract the data from the SQL server and store it in my local data source for BI purposes.
View full review »MB
MichaelBarnett
Sr. Training Manager with 201-500 employees
I've been using SQL Server for 20 years, and there is nothing that it can't do. It is awesome.
View full review »Overall, we've been satisfied with the capabilities of the product.
The solution is stable. It works without issue - to the point you rarely need any technical support at all.
The scalability is very good.
It's got an easy initial setup.
View full review »SS
Shivanshu Srivastav
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.
MA
Maurice Aelion
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.
RN
reviewer1572765
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 »We mostly use linking servers and several applications; one pulls data from another. Thus, we created a Linked Server and implemented a replication algorithm to facilitate data transfer between different sources.
The product enables us to grant access to users. The product is easy to use.
View full review »AR
Abdelkader Raway
Works at a financial services firm with 51-200 employees
For my business requirements, the performance is good. If we use it on a larger scale, it will not fit our business needs.
It is easy to use.
It has simple syntax, but you must check your packet on a daily basis.
View full review »SS
Satyam Saxena
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 »TP
Tim Platson
Solutions Architect at One Click
Scalability, cluster ability, ease of use, ease of implementation — these are all great.
View full review »MP
reviewer1570953
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 »The product’s most valuable features are flexibility and scalability.
View full review »TL
Tim Lenz
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 »TN
ThembaNhlapo
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 »The performance of the SQL Server is very good.
View full review »BC
BruceCollins
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 »RU
reviewer1524594
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 »SM
Sanjeeb Mohanty
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.
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 »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 »RM
RogerMorera
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 »One of the big advantages of this product is its performance, where it works well when the data is not complex.
View full review »What I like best about this product is the environment.
The documentation and manuals are very good.
View full review »SA
Scott Albritton
Applications Business Intelligence Analyst at a aerospace/defense firm with 10,001+ employees
There are many, but I would have to say the two most important for me have been SQL Server Profiler -- to run traces and the ability to kill sessions in the enterprise manager tool. This command-based functionality lets you search and sort through processes actively running on the system to find your i/o hog – that is the user that is overloading the database either through a hung query or bad SQL code.
Once the hog user is found, the terminate or “kill” command can be used to shut down the hanging transaction. Similar to how clearing a vehicle crash on the interstate frees up waiting traffic, this kill command gives other users the ability to continue work as normal once the terminated transaction has been killed. This should be used sparingly though since it can cause waiting applications to corrupt data depending on how the application was written, but it is an often used research feature when a system starts to overload or show major signs of slowing.
View full review »SQL Server is easy to use, but there is a great deal of complexity that you can dive into to use it to its best. Also, it integrates well with other platforms.
BL
Bjarne Lindquist
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 »FZ
reviewer1641576
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 »DG
reviewer1001628
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 »The solution is great for creating backups.
You can create databases using this product.
I like the way you can shrink the volume using SQL.
It's a very stable solution.
I've found the product to be able to scale well.
View full review »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.
View full review »US
Uchechi Sylvanus
Team Lead, Process Improvement at Fidelity Bank Plc
I like the way it can manage the users from the security section where you can change their roles.
SQL is simple to manage, as long as you know the script, and know the tables that you make reference to. If there are errors, you can easily debug them.
You can easily debug and resolve your issues.
The ease of backup, how you can back up and call up your backups too is great. Backups hardly get corrupt, except if maybe you have some bad hard drive clusters or bad hard drive sectors.
It is stable.
It's an easy-to-use product.
I find the solution to be scalable.
View full review »PT
Paulo Toscano
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 »SL
reviewer1385976
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 »SQL Server is easy to manage.
View full review »AS
Amir Saudi
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 »GK
reviewer1671969
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 »SK
Santosh Kurakula
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 »OK
OmidKoushki
Solution Architect at KIAN company
The solution is very easy to use.
View full review »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 »LA
Lional Angelo
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 »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 »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 »MM
reviewer2112948
Consultant at a transportation company with 10,001+ employees
It makes managing the database easy. Backups are very quick.
View full review »IG
Irwin Gibson
Chief ICT Officer at Barbados Public Workers Cooperative Credit Union Ltd
We don't encounter any issues with the solution.
View full review »AS
Azeezulla Sheriff
General Manager IT at a manufacturing company with 10,001+ employees
The backup capabilities are extremely good.
View full review »Its security is good. The GUI of SQL Server is also very good.
View full review »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 »RV
reviewer1624716
2de Solution Engineer - storage & compute at a financial services firm with 10,001+ employees
MS
reviewer1428423
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 »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 »DI
Dimitris Iracleous
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.
MB
reviewer1494501
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 »ST
reviewer1022898
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 »AS
Aditya Sawant
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 »SB
Shanti Sahu
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 »PS
Prakash Somasundaran
Project Advisor at A private sector Company
I would rate MS SQL Server 4/5 for its ease of administration,rich features, Nice GUI support for all its complex features.
Valuable features include:
1.Management Studio (Nice GUI support for all its complex features.)
2.Hot add CPU
3.Configure Dynamic memory also configure MIN and MAX memory.( Very flexible)
4.Replication ( Very Simple).
5.Clustering (The best high availability feature available among all
its compitators due to its robustness and scalability).
6.SSIS ( Very rich).
7.In memory OLTP in SQL Server 2012
8.Always On (High Availability) in SQL Server 2012
9.SQL Server Profiler
10.DMVs
View full review »NY
reviewer2265342
Consultant at a tech company with self employed
I value the ability it gives me to test on small machines and easily scale up to larger devices for live applications.
View full review »KG
reviewer1488372
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 »JJ
JohannesJoubert
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 »NS
Navee Srichaiyanont
IT manager at IRPC PCL
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 »Probably the most useful feature of SQL Server is the ability to write and execute SQL on the fly.
Even though there are some very useful features on Oracle, MySQL, and other platforms, the SQL Server by far has the most robust capabilities of any database platform.
In my experience with numerous coding languages and platforms, the SQL Server has the only programming language that allows the user to create, compile, and execute code in its own language.
To clarify, Java, .NET, PL/SQL and all other programming languages can dynamically create code, but not their own. In other words, Java can dynamically create SQL and execute it, but it cannot create Java and compile/execute.
Other great features are:
- Passing tables as parameters
- Table valued functions
- Horizontal table partitioning
- Very granular disk partitioning
SQL Server provides access to audio information and audio tables. You can customize and create views. The ability to customize and upload these services is uncertain when migrating, but SQL in a local environment or Azure seems suitable for now. The ability to see tables, reviews, and custom script options is good.
SQL Server is a very mature solution.
View full review »This solution is user-friendly and easy to understand.
View full review »One of the most valuable features of SQL Server is that it's easy to use.
View full review »AL
reviewer1652016
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 »MF
Mohamed_Farouk
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 »BM
Biswajit Mohanty
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 »SB
Surendra Bajracharya
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 »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.
PV
reviewer2384076
BI Specialist at a educational organization with 1,001-5,000 employees
SQL Server is a highly stable solution.
View full review »MN
Michael Ndwiga
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.
MO
reviewer1613988
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 »YT
reviewer1478394
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.
FA
Florent ADODO
IT Assistant at Hotel 2 Fevrier
the database management tool is very easy to use and largely meets expectations
View full review »HP
hugodpereira
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 »HV
Helder Valente
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 »VP
reviewer1501629
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 »MM
reviewer1187943
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.
SP
SashisekharPanda
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 »НЕ
Недашковский Евгений
Senior SQL DBA at a financial services firm with 51-200 employees
Always On is my favorite feature. I do like availability groups and cannot imagine how I lived with them before.
Microsoft tries to release new features with every version, but I cannot say that they are killer features. Usually these are just "nice to have" stuff. However, SQL Server works and it works just fine. It is really reliable if you don't shoot your own leg. All the basic functionality is 100% bulletproof.
View full review »BG
Gh0ce
Systems Analyst/DBA at Vecima Networks
Everything is valuable. It is a relational database system which is critical for storing reporting data or any data that is highly relate-able. Plus your data is one of the most important assets in your company. Might as well have a good system to protect it.
View full review »SA
Albeez
IT Director at DAR AL ARKAN
Apart from the standard SQL database-related features, the 2012 version enables the AlwaysOn functionality which enables two or more SQL Servers that can be clustered, with heartbeat across geographic locations along with high availability failover and 99.9999% uptime.
View full review »I like the stability of the solution, the fact that you have two, three, four nodes replicating at any given time at different locations, and they're all synchronized; if one is lost it automatically moves to another. The other advantage here is that when it comes to application maintenance, you switch onto another node while you maintain another server and there's no downtime.
View full review »The most valuable feature of SQL Server is the performance.
View full review »VB
reviewer1803756
Data Analyst at a financial services firm with 501-1,000 employees
The most valuable aspect of the solution is its ease of use.
It's a pretty stable solution.
We found it to be quite scalable.
View full review »BR
reviewer1037115
senior system integrator at a retailer with 10,001+ 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.
VG
reviewer1322280
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 »AG
Alberto Geminiani
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.
AM
reviewer1359642
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 »NM
NipunaMaliga
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 »Without any doubt the Integration Services and Analysis Services are the most widely used. These are the basis for data quality, data gathering, ETL process, as well as collation for the data warehouse, Cube-generation, and ad-hoc processes. The ease in which you may mold a process flow or even modularly add in new structures is something which is much needed in my job.
View full review »The most valuable features of SQL Server are the speed, great support, and it is from a known vendor.
View full review »IH
reviewer1159494
Advisory Software Engineer at a tech services company with 1,001-5,000 employees
The solution has a user-friendly environment and supporting functionalities. It also has great memory and processing databases.
View full review »RC
Ryan Cerney
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 »KJ
reviewer1233759
Deputy Manager at a computer software company with 10,001+ employees
SQL Server has scaled as per our requirements.
View full review »RZ
Roman Zubrytsky
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 »CL
reviewer1621938
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 »PR
reviewer1569966
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 »SJ
reviewer1407519
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 »AW
reviewer1566654
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 »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 »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 »MM
reviewer1522923
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 »MS
Mike Sax
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 »MA
MartinAnderson
Owner at BNS
The most valuable features are programmability and reliability.
View full review »RL
Rmegio Lawag
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 »SSAS is the most interesting feature to organize the data and let the users play with it.
SSIS is also very powerful, but not always user-friendly. It requires you to build a solution around SSIS.
View full review »The most valuable feature for me is that the database engine is always on.
View full review »VA
reviewer1162596
Data Analyst at a healthcare company with 10,001+ employees
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.
What I find most valuable in SQL Server is that it's user-friendly.
View full review »FN
Florent NOPOUDEM
Senior Database Administrator at ITGStore
Most valuable features include: high availability, clustering, save backup and recovery.
SR
reviewer1653840
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 »MP
Mohammed-Pasha
CEO at SkyNet
What I like most is the management, as it is very easy compared with other products.
View full review »ST
MD.SIHAB TALUKDAR
System Engineer at asa
The most valuable feature is the system architecture.
View full review »Performance improvements, optimizer enhancements. Most of our clients have high demands for performance, and this version of SQL Server delivers what we need.
View full review »PN
Paul Nockolds
Data Analyst at a media company with 1,001-5,000 employees
The ability to organize and structure our data in order to extract and provide it to various products and systems within our organization. It is widely used and has great online support from many third-party sites.
View full review »- Business intelligence platform
- Analysis services (multidimensional and tabular)
- Relational database features
- Data extraction and transformation (integration services)
EO
Edgar Orare
Senior Systems Engineer at Dimension Data
Its usability is very good. Its performance is satisfactory.
View full review »TU
TonderayiUsada
Managing Director at D3
One of the best features of SQL Server is the efficient retrieval of information.
View full review »IC
reviewer1646865
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 »OB
Ossama Benaziz
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 »DB
reviewer1473555
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 »- SQL Server Integration Services tools
- Data Quality Services tools
- Master Data Services tools
- SQL Server Reporting Services tools
- Data Partitioning (Horizontal Partitioning) tools
- ColumnStore Indices
- In-Memory OLTP tables
The SSIS, SSRS, and DB are the most valuable features because they help in everything.
View full review »SQL Server integration services tools
Data quality services tools
Master data services tools
SQL Server reporting services tools
Data partitioning (horizontal partitioning) tools
ColumnStore indexes
In-memory OLTP tables
View full review »VC
reviewer938061
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 »MK
Mazen Kassem
Senior Digital Services Engineer at a pharma/biotech company with 1,001-5,000 employees
SW
Stephan Warreyn
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 »KV
Karel Van Der Walt
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 »JP
reviewer1470330
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.
KG
reviewer1413750
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 »JM
Johan Malan
System administrator at a mining and metals company with 10,001+ employees
The availability is the most valuable feature. It has high availability. It also has good performance.
View full review »PS
reviewer1030020
Programmer Analyst at a tech services company with 10,001+ employees
- Creating and executing SQL queries, transactions, ACID properties
- Creating and implementing stored procedures.
磊刘
Lei Liu
DBA,data architectuire at LG CNS Co.
table partition options, that is very useful to separate unnecessary cost.
For legacy data, we can do partition swith out and store into flat files or old tables.
When it necessary, we can switch in back.
View full review »- Ease of installation.
- Ease of creating your databases.
- Ease of changing what your databases look like when you need to.
- Creating tables is simple.
- They have lots of different options that you can use for the fields within the tables.
It is a simple query language. It is consistent across all versions. If you start with an older version, move to the newer version. The same code will still work.
It can go easily on a virtual machine and be accommodated by a virtual machine easily. That is a plus, as not all databases can handle that. It also will do clustering, so you can have two database servers looking at the same data simultaneously.
You can always access the data. You could have an offsite and an onsite, and if the onsite goes down, the offsite picks it up. I like that flexibility to provide continuing operations.
View full review »
Activity Monitor and Dynamic Management Views
View full review »
HG
reviewer1595568
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 »MO
Manjunatha OK
Marketo Consultant at Webtech software servies
The most valuable features of this solution are easy queries and straightforward programming for beginners.
View full review »MR
Menoj-Roekalea
Cloud DBA at UNIT4
- SSMS
- SSIS
- Reporting services
- FCI clustering
- AlwaysOn
- Basic availability groups.
AK
reviewer977976
System Architect, SCRUM Product Owner at a tech company with 10,001+ employees
I have found SQL Server easy to use.
View full review »SF
Stefano Festa
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.
- Ease of use of this product is much better than equivalent products
- New AlwaysOn availability group enhancements bundles more DR and HA features in one easy to use interface
- In-Memory OLTP, or project Hekaton, allows for utilizing memory to boost application performance with only minor application changes
- Power, scalability, flexibility, and bundled tooling means it will meet all of your organizational DBMS needs for all size workloads
- Support from MS and free knowledge and support from the MS community is terrific
- Virtualization friendly!
- Core features of the product include many features that require additional licenses with other platforms
- SImple to setup and keep running
View full review »
DK
reviewer1314546
Senior Systems Engineer at a energy/utilities company with 201-500 employees
It is easy to deploy and easy to maintain.
View full review »SY
cto267069
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 »PS
reviewer1643577
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 »YA
reviewer1519596
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 »RS
reviewer1309482
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 »Traditional DB toolkit closely integrated into Microsoft Office. This makes it truly easy to deploy in a light non-business critical environment.
View full review »Analysis Services, because we are an independent software vendor in the business-intelligence area.
View full review »Most of SQL Server High Availability and Disaster Recovery solutions. They are easy to configure and maintain.
View full review »The ability to browse table structures and re-design it easily.
View full review »
A great database management system for all size companies. SQL server is more user friendly than competitors. Provides easy installation. If you need support or research for the product, it is easy to find help online. There are 3 editions available which will meet any companies needs. Latest version is cloud ready. Offers power and flexibility.
View full review »
AJ
Abaso Jadhav
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 »EK
reviewer1601793
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 »DS
reviewer1430925
Technical Director at a security firm with 51-200 employees
It is stable, and it works okay.
View full review »EN
reviewer1564890
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 »GV
reviewer1476273
Manager with 501-1,000 employees
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 »YW
Yasin Bin Wasim
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 »VS
Victor Sokolov
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 »RS
Rahul Kumar Singh
Software Developer at OATI
- SQL Server Profiler: Know exactly which procedures and functions are being called and how much read and write they are taking.
- Tuning Advisor: It suggests where to add indexes and from where to remove them. It works like an adviser.
- Storage capability
- Debugger: The debugger tool can execute code step-by-step.
DM
DenisMunger
Chief of Engineering at a comms service provider with 11-50 employees
Ease of use.
The AlwaysOn high-availability feature is the most valuable feature of SQL Server to us. This is because of the relative ease of the configuration, rather than configuring for OLTP-OLAP distinction.
View full review »JI
reviewer1707912
System Analyst and Team Lead at a tech services company with 11-50 employees
Many developers like SQL Server.
View full review »RP
reviewer1362969
IT Specialist at a government with 1,001-5,000 employees
I like that it's relatively stable.
View full review »OY
reviewer1503438
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 »PF
Paul Fijma
Engineer / MS SQL DBA at Solvinity
The additional tools, like SSIS and reporting services, make this solution useful.
The most valuable feature is the easy installation. The user just needs to know how to read.
View full review »It allows for performance tuning to maximize performance. With the enhancements to the tuning wizard indexes are added to the needs of the system structure and use. I find this helps prevent locking of the system.
View full review »FK
Faruk Kutlu
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 »The solution is easy to use.
View full review »CM
reviewer1489908
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 »IF
reviewer1593270
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 »The Microsoft SQL Server is a great and powerful data storage capable to provide many functionalities starts on free version until the power with BI resource and mirroring.
View full review »AA
reviewer1556808
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 »RP
reviewer1288086
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 »- Net integration is best for me
- Better optimizer
- Ease of use (admin tools)
SQL Server Migration Assistant for Access (AccessToSQL).
View full review »SK
reviewer1491816
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 »WL
reviewer1484775
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 »GA
GhamdanAl-Anesi
Member of the Board & Co-Founder, Executive Manager at Networld Systems
The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations.
View full review »The database engine within SQL Server 2014 is one of the most valuable components of the platform to me.
The engine provides a solid and efficient database backend for any relational database requirement, performance is strong and there are options such as table, index partitioning and columnstore indexes that enhance the scalability of the platform.
In addition to the database engine, I would also highlight the built-in integration services platform (SSIS) for ETL purposes as well as the Reporting and Analysis Services functionality (SSRS and SSAS respectively).
One of the key features that I would use regularly to support the delivery of a Data Warehouse solution would be the Master Data Services (MDS). This is an extendable Master Data Management platform that works very well out-of-the- box.
View full review »It's a solution that's always on.
View full review »- Reliability
- Ease of use
- Extensive Knowledge Base to improve and maintain the product
SP
reviewer1614828
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 »MG
reviewer1546989
CEO at a tech services company with 11-50 employees
It is integrated with Microsoft tools.
SS
reviewer1085256
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 »Ability to convert to bigger DBs. It makes it easier to move or upgrade between branches.
View full review »The way the product shows the execution plan and the facility to the developer and tests the SQL code.
View full review »There are lots of features including the analysis, database, and reporting, services. We use it mainly for reporting and analysis purposes.
The components I use are -
- SSAS 8.5/10
- SSIS 8/10
- SSRS 7/10
Indexes, CTE, aggregate functions, partitions, memory optimized tables, service broker, CLR (C# assemblies),...
View full review »
- Reliability
- Transaction management
- Its higher limits for storage and table management
• SQL server has dynamic resource allocation feature that allows disk and memory usage scale to meet changing database demands. This facility provides better performance and simplifies software management.• SQL Server’s Graphical Query Analyzer not only helps building stored procedures and interactive queries but also graphically displays the steps performed by query processor to execute the query.
• SQL Server’s Online Analytical Processing (OLAP) provides services like data warehousing, data marts and decision support to many medium sized companies.• Data Transformation Services is a powerful and flexible tool provided by SQL server, it simplifies importing and exporting data between and OLE-DB compatible databases.
View full review »
CL
reviewer1410678
Data Analyst at a tech company with 51-200 employees
It's a flexible solution.
View full review »
• SQL Server provide end users and database programmers with a broad spectrum of services such as Analysis and Reporting services, Data Engine, Integration Services thus making database development and management easier and reliable.
• SQL Server offers a platform on which data in all levels- structured, semi-structured, and unstructured data can be managed, integrated and analyzed thus enabling an organization to realize its mission-critical information.
• Latest versions of SQL Server provide a handy development studio that not only make the creation of database objects easy but also offer useful tools such Object Explorer to allow quick processes.
View full review »
It is widely used and we never have problems with it. It can handle a PC, and it can also handle huge data. It is fast and efficient. It is something unique that tracks reporting of records, personnel, finances and more. It also integrates well with everything, not just Microsoft tools.
View full review »KH
reviewer1517148
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’s easy to develop and learn for newbies, and community MVP’s are so powerful and qualified, so info is easily accessible.
Also, SQL Server is not only a DBMS solution anymore, it is also a BI platform, and improvements are being made continuously.
View full review »Buyer's Guide
SQL Server
March 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,995 professionals have used our research since 2012.