Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Microsoft SQL Server, and make your voice heard!
Entry-level set up fee?
- No setup fee
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
- Easy to configure and use with Visual Studio and Dot Net
- Easy integration with MSBI to perform data analysis
- Data Security
- Easy to understand and use
- Very easy to export database and tables in the form of SQL query or a script
- Database backup and recovery functionality need improvement. Sometimes I have observed that when you try to restore a backup to a previous date/state, it does not work as expected, and restore fails.
- Cost gets higher on integrating with Azure SQL
- high volume transactions
- data staging and bulk data loads
- integration to active directory
- ease of setup
- it's still a memory hog, but that's gotten better since 2016
- it can be expensive to license
In general, SQL performs well for a multitude of tasks beyond web app backends. We use SQL for high volume transactions for our core ESB which has very high data volume and data churn.
- Easy to use with Visual Studio and ASP projects
- Multiple options for Data Security
- Industry standard and easy to use
- Easy to install and configure
- Licensing can get complicated
- Very very expensive
- combability issues and dependencies with servers etc
- Microsoft support....you know
- Data Storage and Manipulation
- Highly Scalable
- Easy Integration with a lot of framework including .NET
- Lower prices
- Better UI
- Requires a lot of maintainence
- No visualization of data
1. Microsoft SQL Server is well suited when company needs to have high control over their data from creating, managing to maintaining.
2. Data needs to be highly structed and related to each other.
3. It can be integrated with a lot of frameworks.
Less appropriate scenarios include:
1. Pricing is very high and becomes difficult for smaller or mid-tier companies.
2. We are moving towards big data which is mostly unrelated and is very difficult for SQL to handle it.
- It's the most used Database so it's mandatory to have knowledge for most of the roles today
- You can find anything your need related to SQL Server on forums
- Easy Implementation
- I don't see too much to improve but maybe a more intuitive or graphical way to monitor the performance
- Is reasonably responsive even when thousands of queries are executing at the same time
- Provides an end user experience that allows for intuitive use of structured query language coding
- The database explorer is intuitive and easy to use for SQL neophytes
- This is probably a sys admin setting, but it forces me to reset my password every month
- I've heard the enterprise edition is quite costly
- If we want to do anything substantial with it beyond simple storing and reporting, we often need to hire consultants
- Extremely reliable
- Great interface via SSMS
- Fast operations
- A better debugging experience
- More built in support for logging
- Better diagram generation
- Relational Database Server
- Easy to stand up DB to support OEM Applications
- Backend for Custom Written Application
- COTS DB
- Cost for Enterprise Edition
- Heavy Mgmt Tools
- It has quite a lot of pre-built function that helps speed up development time.
- One of the fastest SQL database engines.
- Built for enterprise use with enterprise-level of support available.
- It could be very expensive to utilize MS SQL server to its full potential due to the licensing tier limit.
- It does not have a built-in JSON type column, unlike PostgreSQL, although it has built-in functions to help to work with JSON.
- Require more space to install the database engine compared to other SQL databases.
- It supplies a quick and easy way to analyze raw data when troubleshooting.
- It gives the ability to easily create non standard ad hoc reports for clients.
- It provides a standard platform for trouble shooting when we need to bring in engineers with advanced skills to solve problems.
- It provides great tools for testing and development off line.
- Configuration of the environment to create compatibility and restrict resource uses.
- Configuration of connections in configuration manager.
- Connection of data to other Microsoft products like Excel.
- Holds data tables
- Filters information quickly
- Integrates with many programs
- Installation is pretty complicated
- Needs professional maintenance
- Costs a pretty penny
If you have a big base of Data, for instance, your customers' contact information, each customer's own detailed contract and layout, their tickets and service hours. You want to store them all in a organized manner and be able to retrieve any information quickly. That's when you use a Database of any kind and Microsoft SQL Server is one such Database programs which does a good job.
- Integration. We use PowerBI and Crystal Reports for our reporting and it integrates seamlessly with either.
- Ease of use. Easy to learn and use. (Not the language - but the application)
- Protection. Easy maintenance and backup options.
- Licensing. Can be sometimes confusing layers and expensive.
- Efficiency. Can be memory intensive on larger tables.
- Server maintenance can be intensive as well.
- ETL using SSIS to automate processes
- Reporting Services to offer SSRS reports as a standard reporting interface
- Data Analysis using stored procedure, views and transformations
- Connectivity/Integration with other applications through ODBC, Linked Server, etc.
- Simplify licensing
If you use other Microsoft applications, it integrates well such as Excel and Access.
If you have limited resources to support and maintain environment this may not be ideal compared to a managed service or SAAS solution such as Snowflake.
- Easy to use to set up databases
- Reliable clustered instances
- Maintenance plan wizards
- Good UI with Management Studio
- Good BI tools out of the box with SSIS, SSAS, and SSRS
- It could use more/better templates in SQL Server Profiler
- Lacks error avoidance tools when working in different environments (DEV/TEST/PROD). That is, preventing some code execution against PROD, for example.
- Mircosoft SQL Server allows mutliple database to be set up for business purposes.
- Microsoft SQL Server allows jobs to be scheduled after hours, when no one is in the office.
- Microsoft SQL Server allows queries to be run to gather specific information needed.
- Microsoft SQL Server allows security settings that will only allow specified users access. Easy disable employees no longer with the company.
- Microsoft SQL Server has an activity monitor that will show any errors.
- I have been using Microsoft SQL Server for 12 years and I have no complaints.
Also this is the source for different process and reports, outside the database sich as Power BI.
It helps a lot with the database storing, since it is very easy to use and manage.
- Safe to store and query information
- Query optimization
- Scheduled jobs and tasks
- Easy to code.
- Maintenance procedures
- External data sources
- Support and chatting
We are capable to keep the information always available around the globe, also this is kept in a safe way.
We have our systems working on several countries, and the response time, is always excelent.
- Microsoft SQL Server is simple to install and configure.
- Many advanced options like Compression and Partitioning are available with no extra cost, thus reducing the overall TCO.
- Partitioning does not provide as many options as Oracle (like Foreign Key partitioning, list partitions, hash partitioning and sub partitions)
- The default READ COMMITED isolation level block readers, so it is important to use the READ_COMMITTED_SNAPSHOT option, that should be default right now...
- Stored procedures, efficient and so much easier to update business logic when under pressure!
- High availability always on groups (since 2012), is pretty easy to set up and just works - has been an absolute savior on 2 server failures.
- Fairly straightforward to administer out the box as it were (but this can be enhanced see below).
- So widely used that someone somewhere has probably faced the same challenges that you have so [to] find a guide, solution, suggested path is relatively easy (not strictly a SQL server thing but makes a massive difference knowing that you have access to huge resource with a well supported well adopted piece of software).
- Very well supported in terms of third party software to enhance administration (backups, performance, etc.).
- Enterprise is unbelievably expensive.
- Not tolerant of bad practices and poor query writing, really shows up when you do it badly!
- Deep insight into what is happening with query performance is not especially great (but as mentioned in the "Pros", software support from third parties does cover this).
I will say I have had limited joy with text search (full-text indexing) to achieve better text searching results, but that's probably done to me. It's the one area I have never really managed to find a great guide on though.
- Easy to use is of course the foremost reason [for] its extensive use in almost every industry
- Less expensive than Oracle tools
- Multiple user support in [a] single set up
- Excellent user support and documentation
- Visualization is not available for that you have to use [the] different tool this is one of the feature[s] I think they should include
- In MS Access you can design the query but here you have to write it in SQL
- Enterprises edition is really expensive
- Ease of use
- De-duplicate data
- A requirement for most MS based applications
- Widely used in the industry, allowing to easily support it
- Flexible in terms of configurations
- Very expensive!
- Scalable, but not with ease
- Resource hog
- Easy to create queries to return specific, filtered data
- Provides easy mechanisms to backup and restore data
- SQL Reports are easily created and customized
- Better exporting of SQL Reports to multiple formats
- More Tool Tips for some of the less familiar options
- More backwards compatibility for older software
- When properly maintained results are returned quickly
- Backups and restores can be done quickly for testing
- Support for common data access methods makes coding less painful
- SSMS (SQL Server Management Studio) really helps IT in database activities
- Debugging stored procedures can be done better
- SSMS could be integrated more efficiently
- Tasks that require many steps could be either streamlined or at the very least remember the data entered for each step
- UI is user-friendly, making integration easy for all members of the team.
- It is easy to set up and teach to new members.
- Good support with third-party software.
- Cost can be expensive.
- Some learning curves for users transitioning from other services.
- Scales well
- Widespread usage means resources are more readily available.
- Reliable when configured and maintained properly.
- *Very* complex
- Performance can be poor when configuration isn't tweaked just right.
- System resource intensive, and some resources are capped by licensing.
- Upgrading to newer versions is difficult and time-consuming.