Skip to main content
TrustRadius
Microsoft SQL Server

Microsoft SQL Server

Overview

What is Microsoft SQL Server?

Microsoft SQL Server is a relational database.

Read more

Learn from top reviewers

Awards

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

Return to navigation

Pricing

View all pricing

Subscription

$1,418.00

Cloud
Per License

Enterprise

$13,748.00

Cloud
Per License

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
Return to navigation

Product Demos

An Introduction to Microsoft SQL Server's Statistics

YouTube

Introduction to Transact SQL (T-SQL) using Microsoft SQL Server

YouTube
Return to navigation

Product Details

What is Microsoft SQL Server?

Microsoft SQL Server Video

Microsoft SQL Server Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Microsoft SQL Server is a relational database.

Reviewers rate Implementation Rating highest, with a score of 9.

The most common users of Microsoft SQL Server are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

(1-5 of 36)

The way to go for your database implementations

Rating: 10 out of 10
September 12, 2019
GD
Vetted Review
Verified User
Microsoft SQL Server
24 years of experience
I use Microsoft SQL Server primarily as the back end database server to ASP.Net C# websites. For authentication and authorization, the database uses tables and stored procedures to implement membership or identity for user login and defining roles. Of course, the database is used to hold data entities for the needs of the website. Use of stored procedures, views, and sequences full-text indexing are just some of the useful features I take advantage of.
  • Speed of selects with appropriate indexes.
  • Use through C# of Linq queries to the data.
  • Ability to use CLR assemblies to program in C#.
  • Replication to keep the database mirrored to another server.
Cons
  • I sure wish the T-SQL language was more like C# - it's really primitive.
  • I would like an easy way to pass an array to stored procedures and a way to iterate through the array in the code.
  • Integrated source control for the database would be appreciated.
Microsoft SQL Server is well suited for various scenarios and solutions since it is a general-purpose relational database capable of easily and efficiently meeting the needs of your website or application. It is fast, reliable, scalable and easy to use. Due to its popularity, there are many sources of user help, tutorials, examples, and solutions available.

Good database engine

Rating: 8 out of 10
January 08, 2016
AG
Vetted Review
Verified User
Microsoft SQL Server
3 years of experience
Microsoft SQL Server is being used on different projects for different customers. I had a chance to use this software several times and it left a very good impression. Microsoft SQL Server has a good set of tools for developers, its T-SQL language is convenient. Microsoft SQL Server can be used both by medium and large size enterprise applications and is pretty easy to scale out using techniques like replication, clustering etc.
  • Good query optimizer. For complex a query it provides helpful tools like Query Tuning Advisor.
  • Reliable database engine.
  • Many options for replications.
  • Good additional out-of-box features like Integration services, Analysis services and Reporting services.
Cons
  • No integration with source control like Microsoft TFS.
  • Intellisense can be improved further.
Definitely recommend for enterprise application. Do not recommend for small companies - better to use MySQL.

Easy to implement this complete set of tools

Rating: 9 out of 10
September 10, 2019
Vetted Review
Verified User
Microsoft SQL Server
15 years of experience
It is used as a data warehousing and business intelligence platform across the whole organization.
  • Troubleshooting is easy because of several forums available on the internet. We can Google error messages and find solutions easily.
  • It has a complete set of tools for data warehousing and business intelligence, so integration and automation are easy.
  • Easy access to training and skilled workforce availability.
Cons
  • There are some in-memory tools in the market that I have used to replace analysis services. Those in-memory tools have reduced the aggregation time to a few minutes as compared to a couple of hours on analysis services.
  • Mobile apps for SSMS and SQL agent would be a good addition to the toolbelt.
  • A built-in SQL source code control tool that can be used to track code changes and schema changes from SSMS would be very useful. It should easily show who made the changes, what changes were made and when, and provide an option to roll back to any of the previous versions if needed.
SQL Server is easy to implement and has all the components for data management and business intelligence. It needs some performance improvement and built-in SQL source code change tracking.

Microsoft SQL Server Hands Down Over Oracle

Rating: 10 out of 10
February 23, 2016
TM
Vetted Review
Verified User
Microsoft SQL Server
16 years of experience
The organization has implemented an ERP system that has a Microsoft SQL Server backend. We also use Microsoft SQL Server for business reporting, analytics and intelligence.
  • The relational database management system is easy to use in designing database objects, including primary and foreign keys, constraints, default values, triggers, etc.
  • Microsoft SQL Server is great at processing sets of data.
  • Microsoft SQL Server's transactional structured query language (T-SQL) is very easy to use for ad-hoc queries as well as for designed database programs for database and application maintenance, operations and reporting.
Cons
  • The cost of Microsoft SQL Server is often not feasible for smaller businesses.
  • I'd like to see source control integrated into SQL Server, so that all changes to the database objects are automatically versioned and stored for reference or retrieval.
In my opinion and experience Microsoft SQL Server is ALWAYS well suited, if the database is designed and configured appropriately.

Database Administration With Microsoft SQL Server

Rating: 10 out of 10
May 13, 2021
JR
Vetted Review
Verified User
Microsoft SQL Server
10 years of experience
This is the database engine we use for our own systems and for our clients. So we use it internaly and externaly, to store all the information we need to have control of.
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
Cons
  • External data sources
  • Support and chatting
Our companny is a Service Desk, and IT Support supplier. We have different needs regarding information, ticketing systems, clients systems and also our company internal information such as HR related.
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.
Return to navigation