
Microsoft SQL Server
Overall rating
Filter by
Company size
Time used
1884 Reviews

- Industry: Information Technology & Services
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 9.0 /10
Data Management made so easy with MS SQL Server
Reviewed on 20/03/2020
Pros
For any developer, before first they can this own what their apps are going to be developed in their should think of what server should host their database. I do believe that MS SQL Server is the best on the marketing when comes to data management and administration. The best feature that i really love the most on MS SQL Server is the ability to disable remote execution of your queries and really helps protect data integrity in case your server authentication has been compromised. You can also be rest assured that your data is consistent and accurate at all times. Yes hackers some times can try sql injection but i believe MS SQL Server its the most secure servers around.
Cons
The license key for MS SQL might cost you an arm and a leg but at the end of the day its really worth it when you think of a platform where you are able to develop enterprise apps that secure and helps with Business Intelligence.
Alternatives Considered
Oracle DatabaseReasons for Switching to Microsoft SQL Server
In the case of Oracle DB vs MS SQL Server, MS SQL Server is easy to manage, easy to configure and has a huge community in case when you are stuck with any problem you are guaranteed to get a solution online.
- Industry: Marketing & Advertising
- Company size: 2–10 Employees
- Used Weekly for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 7.0 /10
A good choice as a database manager, but it can be improved.
Reviewed on 09/11/2022
It is good software, as I mentioned before. It syncs well with other Microsoft tools. In almost 2...
It is good software, as I mentioned before. It syncs well with other Microsoft tools. In almost 2 years of use, I feel comfortable when working with this software. I hope that the improvements I mention in the negative points will be included. Otherwise excellent.
Pros
I like that it allows me to use my Windows login credentials as user authentication to connect to the server. Plus it integrates easily with other Microsoft programs such as Visual Studio 2022, Business Intelligence tools, etc. I am a Software Engineering student, and I have been testing many database managers. Of all the ones I have used Microsoft SQL Server is the easiest to install and very intuitive regarding the use of its tools. In addition to being a student, I give small tutorials on how to use the software, such as tips for new users, and database backup.
Cons
I don't have much to criticize in this space. For me, the Software is very complete. But if I would like you to implement a dark theme throughout the interface, it would be very helpful to rest your eyes and avoid fatigue after hours of work.

- Industry: Internet
- Company size: Self Employed
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 7.0 /10
Good RDBMS
Reviewed on 25/06/2022
Pros
Very easy to implement and integrate with other systems.
Cons
MS SQL Server consumes almost all compute resourses
Alternatives Considered
PostgreSQLReasons for Choosing Microsoft SQL Server
CostSwitched From
Oracle Database- Industry: Design
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 10.0 /10
Streamlining My Data Management Tasks with Microsoft SQL Server
Reviewed on 30/06/2023
My overall experience with Microsoft SQL Server has been very positive. As a student, the platform...
My overall experience with Microsoft SQL Server has been very positive. As a student, the platform has helped me to manage and analyze data more efficiently and effectively, which has been invaluable in my studies. While there are some potential downsides to consider, such as cost and a potential learning curve, I believe that the benefits of the platform far outweigh any potential drawbacks. I would highly recommend Microsoft SQL Server to any student or organization looking for a powerful and versatile tool for managing data.
Pros
As a student, I have found Microsoft SQL Server to be an incredibly powerful and versatile tool for managing data. One of the things I appreciate most about the platform is its ease of use. The interface is user-friendly and intuitive, which has made it easy for me to quickly learn and navigate the various features.I also appreciate the platform's robust set of tools for managing data, including its ability to handle large amounts of data and its support for a wide range of data types. The platform's integration with other Microsoft products, such as Excel and Power BI, has also been a game-changer, making it easy for me to analyze and visualize data.
Cons
One of the potential downsides of Microsoft SQL Server is its cost. While the platform offers a lot of value for businesses and organizations that need to manage large amounts of data, the cost can be prohibitive for individuals or smaller businesses with limited budgets.Another potential drawback is the learning curve involved in getting started with the platform. While the interface is generally intuitive, there are a lot of features to learn, and it can take some time to become proficient in using the platform to its full potential.
- Industry: Information Technology & Services
- Company size: 2–10 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 8.0 /10
Review for Microsoft SQL Server
Reviewed on 17/01/2023
SQL Server is my main RDBMS for Windows environments because it has a wide range of features and is...
SQL Server is my main RDBMS for Windows environments because it has a wide range of features and is completely compatible with the operating system since it runs on its native platform.
Pros
Easy to install, configure, update and use. Through tools such as SQL Server Management Studio (SSMS) the system has a very friendly graphical user interface. SQL Server has extensive documentation on the Internet.
Cons
Full installation takes up a lot of disk space. Depending on the version, the software license can be very expensive.
Reasons for Switching to Microsoft SQL Server
Compatibility with the operating system and its features.- Industry: Commercial Real Estate Software
- Company size: 201–500 Employees
- Used Daily for 6-12 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 7.0 /10
Relation Database Management
Reviewed on 01/05/2023
The availability of server editions and the Microsoft premium support where you will get access to...
The availability of server editions and the Microsoft premium support where you will get access to premium support with Microsoft skilled specialist.The SQL server also supports for use on Linux
Pros
The Microsoft SQL server editions available like enterprise, standard, web, developer for basic data management and business intelligence features and SQL server components availability was the most advantage of using SQL server
Cons
The enterprise edition was more expensive for per core licence it is around $14,200.
Reasons for Switching to Microsoft SQL Server
The Microsoft SQL server developer edition was free and which has all the features required for us. We can download install and manage database on our own.- Industry: Industrial Automation
- Company size: 501–1,000 Employees
- Used Weekly for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 8.0 /10
Enterprise DBMS
Reviewed on 09/02/2023
Pros
We had to migrate our free databases to SQL server because we reached many gigabytes in a few tables and needed a fast and reliable software to handle it and integrate with some BI products. Microsoft SQL Server had no issues and works really fine.
Cons
License costs are major issues , but any other paid database costs about the same. It is still a bit overkill for us but we are looking at using it in the cloud as a PaaS.
Alternatives Considered
Oracle DatabaseReasons for Choosing Microsoft SQL Server
Very big tables and need to consolidate databases to integrate with BI- Industry: Information Technology & Services
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 9.0 /10
The default database for Windows development
Reviewed on 09/11/2022
This is the base storage for many of our applications, allowing to handle millions of rows without...
This is the base storage for many of our applications, allowing to handle millions of rows without a single failure.
Pros
This is the database that I grew up with, and it's never disappointed me over all these years.It keeps compatibility between versions and has a nice documentation about migrating.
Cons
There has been situations where we hit a roadblock and the documentation for it was a bit lacking.
Reasons for Switching to Microsoft SQL Server
This is the one our client are used to, and it's tightly integrated with Active Directory- Industry: Banking
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 10.0 /10
SQL Server Review
Reviewed on 14/01/2023
I have used every version since 6.5 and all releases have been solid and each subsequent release...
I have used every version since 6.5 and all releases have been solid and each subsequent release showed improvements.
Pros
It has been the same core components since 6.5, but the new features are very good.
Cons
Some of the alerts provided by Microsoft are not always intuitive or clear
Alternatives Considered
Oracle DatabaseReasons for Switching to Microsoft SQL Server
Integration with existing Microsoft infrastructure- Industry: Automotive
- Company size: 1,001–5,000 Employees
- Used Daily for 1-5 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Likelihood to recommend 8.0 /10
SQL Server Review
Reviewed on 07/09/2023
Pros
the performance of the SQL server is outstanding, aswell the security that it offers due to the features, including data encryption, access control, etc.
Cons
SQL server is expensive edpecially for enterprise editions. It is complex to learn so the learning curve will be steep for begginers.

- Industry: Telecommunications
- Company size: 10,000+ Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 9.0 /10
Microsoft products are usually stable and reliable.
Reviewed on 03/09/2022
SQL Server allows a large number of accesses without affecting performance. Once switched, there...
SQL Server allows a large number of accesses without affecting performance. Once switched, there are no performance issues. Many users and developers have stated that the process is faster and more convenient thanks to the application. Access is used for the database and this has led to slow performance when the number of data increases. Large amounts of data sometimes require slow operations.
Pros
SQL Server is the enterprise system database, and its toolset is provided as standard. Many departments in the company use it as a database when creating a small system. Its graphical user interface is easy to use even for beginners, and its data can be queried seamlessly from other Microsoft products such as Access.
Cons
The application has very few bugs and offers stable operation.
The core elements of the product's usability remain the same despite repeated changes.
Both the cost and feature set of Oracle is superior to NetSuite.
Alternatives Considered
Amazon S3Reasons for Choosing Microsoft SQL Server
An Excel database can be shared with other BI tools and used to store personal information. As the database increases in size, searches will take longer because the search speed depends on device specifications. In reality, however, more records mean longer search time.Switched From
Microsoft ExcelReasons for Switching to Microsoft SQL Server
We decided to test it first and check the features and advantages it offers when integrating with Microsoft products by purchasing the free Express edition, which allows us to use up to 10 GB of database capacity. The GUI is easy to use and provides stable performance, which has not led to any complaints. Before buying the paid version, try the free EXPRESS version.- Industry: Airlines/Aviation
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Likelihood to recommend 10.0 /10
Powerful and Scalable Database Software
Reviewed on 28/10/2020
Storing large quantities of production data to solve quality and efficiency problems has been a big...
Storing large quantities of production data to solve quality and efficiency problems has been a big use for SQL. All of the reporting and power to analyze data has solved countless puzzles for me in my job capacity. I also have done a lot of database administration for our ERP software and the tiles to tune and optimize have always been very helpful.
Pros
One of my favorite things about Microsoft SQL Server is the scalability. Whether you are using the free version for a small program running on a local machine or running an entire factory it is the same basic concept of programming and administration. I really appreciated being able to work to have a database software that could grow and expand when I need it too. Additionally the reporting and automation packages that come with it are super powerful. I would absolutely recommend using Microsoft SQL Server as anyone’s data as software
Cons
The biggest con in my opinion is that some of the more advanced features for big data analysis and high availability are in the top tier pricing which can be hard for smaller companies to afford. Other than that I have never not been able to solve a problem with Microsoft SQL.
Alternatives Considered
MySQLReasons for Switching to Microsoft SQL Server
Microsoft SQL had superior options and capabilities.- Industry: Retail
- Company size: 2–10 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 10.0 /10
A database system that you can trust your data with!
Reviewed on 10/03/2022
I believe we rely on Microsoft SQL Server and its great features and performance a lot. It's our...
I believe we rely on Microsoft SQL Server and its great features and performance a lot. It's our first choice in terms of an RDBMS database and I believe it remains as such for a long time.
Pros
I've been using Microsoft SQL Server since version 2000 and I must say that every year the team behind it adds tons of improvements and great new features that keep this software a fantastic competitor in the market.
The database engine is very clever in optimising your queries, giving insights on improvements and dealing with your complex queries.
Microsoft's TSQL is very easy to understand and very easy to grasp even though in recent years the team have introduced more complex query templates but still it stands out impressively amongst the others.
I also love that they have released the full version as a Developer version where you can try all the software's great features without any cost at all!
Cons
The huge cost difference between the Standard and the Enterprise version is a put off as certain features like table partitioning should be part of the Standard version.
Alternatives Considered
MySQLReasons for Switching to Microsoft SQL Server
The greater community behind it and the performance difference made us go to Microsoft SQL Server as our first choice.
- Industry: Hospital & Health Care
- Company size: 1,001–5,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 9.0 /10
A robust database engine with high information security standards.
Reviewed on 25/05/2022
At the moment we have no negative features to add to the product
At the moment we have no negative features to add to the product
Pros
How safe this database engine can be, its integration with other technological tools, say, programming languages, infrastructure, datawarehouse and more
Cons
A bit the price, since the enterprise license is a bit expensive
Reasons for Choosing Microsoft SQL Server
We needed a more robust database engine due to the growth of the company and the processes that are currently being handled, plus the integrations with different platforms.Reasons for Switching to Microsoft SQL Server
We needed a more robust database engine due to the growth of the company and the processes that are currently being handled, plus the integrations with different platforms.
- Industry: Information Technology & Services
- Company size: 2–10 Employees
- Used for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 9.0 /10
Best database management tool for relational databases
Reviewed on 11/08/2021
I would recommend it to all low-scale and small organizations that are already using MS Office...
I would recommend it to all low-scale and small organizations that are already using MS Office products or subscriptions. Its interface is similar to learn and use like other Microsoft software. Enterprise and large corporates can look into Oracle services if they require specific Oracle-made enterprise functions and features to handle very complex data.
Pros
First and foremost, it has all the features and functionality from the basics to advanced users for relational database management. Can be integrated well with other Microsft software especially Visual Studio code for a smooth development experience. Along with data storage management, professional performance analysis can be performed through GUI server management studio tools like Database Tuning Advisor. Data Analysts will find data extraction and filtration as well as visual & interactive report generation quite beneficial in their routine tasks. Backup and restore from one SQL server to another is fairly simple. Pricing is very reasonable according to the DBMS system and tools that are provided.
Cons
One of the main issues is that licensing price packages are difficult to choose due to confing choices for common users. One other limitation is that a backup made in a newer version of MS SQL server is not compatible with an older version of SQL Server. For large volumes of data records and for complex data it becomes slower to process queries. Taking backup of a very large number of records also takes time. Sometimes difficult to debug syntax errors.
Alternatives Considered
Oracle Data Management PlatformReasons for Switching to Microsoft SQL Server
We decided to use an MS SQL server as it suits our needs in pricing, features, and performance. Also, it is easier to use for development teams that are already using Microsoft products like MS Office. Students should also use it to learn the basics of SQL through a GUI environment. Oracle database service is more expensive due to the fact it handles complex & large-scale enterprise data. We did not require those enterprise features.- Industry: Computer Software
- Company size: 2–10 Employees
- Used Weekly for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 9.0 /10
This sequel is better
Reviewed on 07/10/2019
Once SQL Server in Azure was selected, it proved to be a great experience. Security, performance...
Once SQL Server in Azure was selected, it proved to be a great experience. Security, performance and usability was ironed out for us already. We could focus on building our application rather than learning something new about cloud security or how to use a new type of database or database language variation. We have been pleased with the ability to research performance and include other features such as SSIS to accomplish our business requirements easily. Knowing that manual tasks are being completed automatically is a sigh of relief. We also will know immediately if there are any issues. We have had a great experience with SQL Server.
Pros
It is an industry standard that continues to improve to make the lives of developers easier. We are able to produce software solutions more efficiently because Microsoft continues to improve SQL Server. We rely heavily on this as critical to our business. Developers tell me how flexible SQL Server is also. SQL is more compatible with software packages than other competing databases.
Cons
Parts can be not intuitive unless you've been using it for awhile. It is a technical piece of software that requires time and training. If you need the Enterprise edition for specific features, it is expensive.
Reasons for Switching to Microsoft SQL Server
We needed a back-end database for our new product. We had an AngularJS front end and needed a fast, efficient relational database. We wanted an industry standard that would be supported for many years going forward. We also needed reliability of a database that would meet our needs while continuing to improve in the future. SQL also has great support, user forums, groups, and 3rd party consultants. Many resources are available to us as we build our new solution and have questions. SQL Server in the cloud was a perfect fit for our organization which already used MS Azure.- Industry: Electrical/Electronic Manufacturing
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 10.0 /10
The quintessential database server
Reviewed on 25/05/2022
From the administrative point of view, database management is certainly more efficient than in the...
From the administrative point of view, database management is certainly more efficient than in the past, I must say that in some cases we have been able to solve particular data extractions that without the use of the T-SQL language we would not have been able.
Pros
Microsoft has always tried over the years to improve its flagship product, achieving good stability and robustness. For administrators, the management interface is particularly useful and easy to use.
SQL Server has allowed us to manage several databases at the same time from our applications without problems giving the possibility to colleagues to have, for example, always updated sales data.
Cons
Unfortunately I must also report the defects and in this case in my opinion the interface for administrators has become too slow in terms of starting in the latest versions.
Sometimes product updates do not install correctly, even if this rarely happens it can create a general disservice almost always in time of need.
Alternatives Considered
PostgreSQLReasons for Switching to Microsoft SQL Server
Because when it comes to Microsoft products, it's inevitable not to rate them- Industry: Industrial Automation
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 8.0 /10
Good for medium and big companies
Reviewed on 21/08/2019
I am using SQL Server for 4 years in a Low, Medium and Big environment, but in low environment i...
I am using SQL Server for 4 years in a Low, Medium and Big environment, but in low environment i have a bad experience using SQL SERVER, Mysql is better in a small busines for cost, and simplicity, but in Big environment SQL SERVER can compete with ORACLE DB.
Pros
Is powerfull
Easy
Complete
Customer Support
Features
interoperatibity
Cons
Have some errors
You need to reset de SQL 1 time at week
Consumes a lot of ram
it needs a Windows Server
Reasons for Choosing Microsoft SQL Server
Pricing and SimplicitySwitched From
Oracle DatabaseReasons for Switching to Microsoft SQL Server
is a more powerfull alternative to Mysql and is more simple than Oracle Database- Industry: Computer Software
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 10.0 /10
My Database Engine
Reviewed on 18/06/2019
It has been awsome as i am now a good Database developer because of this awsome tool.
It has been awsome as i am now a good Database developer because of this awsome tool.
Pros
I am not DBA but i am using it from more than 3 years from university days and still using SQL in my professional life.
I like everything about from query writing, to testing using SQL profiler.
Most about it is that you can do most thing by using queries and GUI as well.
Its easy to connect and configure with any kind of application with single line of code.
Most thing about it is its prediction while typing and highlighting errors with underline squiggly.
Cons
As a developer i cant find anything that i dont like in it. Its always more than my expectations.
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 10.0 /10
Ridiculously powerful and full of features we do not make use of. We love it, and cannot do...
Reviewed on 02/07/2018
This software practically runs our facility. Without it, we couldn't keep track of our animals or...
This software practically runs our facility. Without it, we couldn't keep track of our animals or our people (staff, members, donors). To us, this software is well worth the costs involved.
Pros
SQL Server is just so incredibly powerful, most users probably do not know how much it can do, or how much it can handle. In our type of organization, we deal with people and animals. We rely on donors and members for funding, we track everything about our animals from health issues, to medications, to physical exercise. Every one of our systems relies on, as the backbone, SQL Server. This software is powerful, versatile, and reliable. With pretty much every department of ours needing some type of database, standardizing to SQL Server was just the best move. It can handle it all. It can track it all. And it can report on it all for us. To date, we use it for: our Accounting software, our donor tracking, our membership tracking, our animal tracking (includes tracking from what zoo or aquarium animals came, their medical history, their exercise history, their diet, their location in our facility, their trainers, their behavioral issues/environmental factors), our vet's digital imaging systems, our guest services scheduling, our security systems (surveillance, door locks), our water quality and hvac sysytems logging and controls, our point of sale system (for admissions and food court and ecommerce), and our facility management software (maintenance and IT requests). This system does indeed handle everything we need it to.
Cons
You need a lot of training to make the most of it. Or it could cost you a lot if you have to pay a developer to help you get the most out of your systems. Luckily a couple of us are really into databases, and we both have a lot of experience with SQL, we can do most things in-house. But still the amount of training we go through to keep current, or to keep learning is probably the biggest "problem" with this software. Most software packages, you can buy, setup, receive a few hours or a few days of training, and you'll be good to go. With SQL, if you intend to use it, to get the most of out it, you will need more extensive training, or to hire people to put in the work. It's not cheap. But it can help you accomplish so much if you put in the time.
- Industry: Information Technology & Services
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 9.0 /10
Powerhouse of Data Management
Reviewed on 23/06/2023
My overall experience with Microsoft SQL Server has been highly positive. The platform's robustness...
My overall experience with Microsoft SQL Server has been highly positive. The platform's robustness and scalability have empowered us to efficiently manage and analyze our data. The advanced query optimization and indexing capabilities have ensured optimal performance for our applications. The seamless integration with other Microsoft tools and technologies has enhanced our productivity and workflow. While there were some areas for improvement, such as the learning curve and occasional performance issues, Microsoft SQL Server remains a reliable and powerful solution for data management. It has been instrumental in helping us unlock valuable insights and make data-driven decisions.
Pros
Microsoft SQL Server impressed me with its standout features that revolutionized our data management experience. The robustness and scalability of the platform allowed us to handle large volumes of data with ease. The advanced query optimization and indexing capabilities ensured optimal performance and fast retrieval of information. The comprehensive security measures instilled confidence in the protection of our data assets. The seamless integration with other Microsoft tools and technologies enhanced our overall productivity. Microsoft SQL Server has become an indispensable tool, empowering us to effectively store, manage, and analyze our data.
Cons
While Microsoft SQL Server offers powerful data management capabilities, there were a few aspects that left room for improvement. One drawback was the complexity of the platform, which required a steep learning curve and technical expertise. The licensing costs, especially for enterprise editions, might be a limiting factor for smaller organizations. Occasionally, the platform's performance could be affected when handling extremely large datasets. The documentation, while extensive, could benefit from more detailed examples and tutorials for complex scenarios. Despite these limitations, Microsoft SQL Server remains a robust and reliable choice for data management, but addressing these areas for improvement would further enhance its usability.
- Industry: Automotive
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 10.0 /10
My past with MS SQL
Reviewed on 25/10/2022
I met firstly with MS SQL in the uni. The in one of my workplaces I became an admin of it, so as a...
I met firstly with MS SQL in the uni. The in one of my workplaces I became an admin of it, so as a "user".Its two sides-role widely different. Writing queries, retrieving data, manipulating the results (not the stored data) is a cool option. Easier, faster, more known then Oracle's PL/SQL I would say. The option it gives you are enormous, and how many things uses a DB nowadays are surprising. Knowing and being able to manage a DB, will be an asset in the future. Speed depends on your codes and on your machine. The memory is the enemy of the DBs, so as for MS SQL. Maybe other, non-relational DBs have better results, but on specific tasks. MS SQL is being better, has a lot of devs. behind its back and MS itself, you definitely worth considering it having as a primary database. 3rd party extensions can be used, that can take your productivity to the next level, like APEX.Having a free version up to 10 gigs per database, you would not believe how many company based its business on this "advantage".
Pros
Can be integrated with a lot of MS and 3rd party tools.The query window is well formed.The speed of the DB is excellent, but bases heavily on your custom codes.Reports, ad-hoc table, integrations with other reporting tools, intranet websites are great.
Cons
Less training options available comparing it to other MS tools.Intergration, access management can be difficult.Sometimes not easy to track changes in your codes, mostly in big databases.Installation could be easier.It not recommended, but for IT personnel with solid knowledge.
- Industry: Airlines/Aviation
- Company size: 2–10 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 8.0 /10
A database for every level of user expertise
Reviewed on 16/01/2021
Regarding to the cost; licenses are cheaper than others. But when analyzing a database you should...
Regarding to the cost; licenses are cheaper than others. But when analyzing a database you should consider many others variables like administration cost, available resources, expertise of the team, company size, available servers, budget, etc...
Pros
SQL Server allows users to setup up a database with different features, from basic database to a complex environment that can include partitions, replication, business intelligence, reporting, etc. Is really simple to deploy on different scenarios like on-premise or cloud. Regarding SQL Language - Transact SQL - it is simpler and easier than other languages. For beginners this could be something positive because of the velocity of the learning curve. The integration with the business process is really easy when working with other Microsoft technologies. Additionally there is an interesting feature called FileTables which allows see the storage as a table. SQL Azure database is something great, an scalable database service that can me managed with Management Studio tool and created in less than a minute.
Cons
Something that could be an improvement to MS SQL is related to the performance monitor. In general all databases require to have a relative high level of expertise to create a good database design. With a simpler performance tool, junior users could create better queries, indexes, model, etc...
- Industry: Financial Services Software
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
- Likelihood to recommend 8.0 /10
Great database for small To medium business
Reviewed on 26/09/2019
I used sql server in the past until cloud based database system like Hadoop and Google cloud are...
I used sql server in the past until cloud based database system like Hadoop and Google cloud are available. this tools is complex and extensive. There are a lot of features and functionalities to create stable and high rated database system like cursor, functions, stored procedures, etc. However, when the data requirements grows exponentially, the system unable to handle the load which takes significant amount of time to query. This is where company looks for better solution to handle big data load using cloud based database. SQL server going to be recognized as the pioneer of database system that set the standard of SQL language for similar products. Perhaps overtime they also evolve with better solutions to handle big data load; something that I have no knowledge about.
Pros
Relationship database is structured database management that create with data integrity and reliability in mind.
Cons
Slow performance with big data load requirements.
Also physically need to build primary keys for each tables instance.

- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support Software
I have been working with this software from last 8 years. I like this software and used its...
Reviewed on 25/05/2018
Pros
This software offers a lot of features that are very handy to work with. And frankly it took very less time to understand this software and get used to it. I have used this software for creating stored procedures, functions, views, database schema.
Easy to connect with external database as well. I have heavily used the SQL profiler which again is a very useful feature. SQL profiler let you see the request that SQL receive from a source and it help you debug your code. Generating backup, restoring backup, importing and exporting data tiers all features are so easy to understand. Even I never googled to know how to do it, I just saw the option and start following the instructions and it's done. Its easy to use and all its features are very useful. Even when you didn't saved your file and accidentally your laptop got off,it help recover your files. Easy interface to create database tables even if you do not remember the script syntax.
Cons
There is nothing that I don't like kind of this with this useful software.
Its just if the edit rows option could have been made easy by auto showing the SQL pane to write query while editing the rows. I found it one step extra. It should be like when we select rows. Also running the query on edit rows if could be done via f5 only, then it would be easier for the user.