SQL Server

Relational database management system for data analytics

4,6 /5 (1428 reviews) Write a Review!

SQL Server Overview

What is SQL Server?

SQL Server is a relational database management system (RDMS) designed to help businesses of all sizes analyze structured or unstructured data across various data environments including Azure SQL Database, Azure Cosmos DB, MySQL, and more. It enables administrators to track the performance of databases, monitor data lakes, and handle data warehousing operations on a unified platform.

Features of SQL Server include multi-language support, compliance management, data classification, automated alerts, full-text search, and more. It allows software developers to manage big data environments and deploy data clusters of containerized instances of Apache Spark and Hadoop Data File System (HDFS). DevOps teams can also utilize in-memory database capabilities to track the performance of business workloads.

SQL Server provides extract, transform, and load (ETL) capabilities, which enable users to extract business data from various sources, create custom workflows, execute aggregation, deduplication, or merging of data, and export the transformed data into destination databases or files. It allows employees to store digital objects including dynamic management views (DMVs), procedures, indexes, constraints, and transaction logs in a centralized repository.

SQL Server Overview

Pricing

Starting from
US$931,00

Pricing options

Free Trial
One Time License
Free
Subscription
Open Source
Value for money

SQL Server offers a 180-day free trial for new users, after which the software is available across various pricing tiers, details of which are outlined below -
• Enterprise - $13748
• Standard (per core) - $3586
• Standard (server) - $899
• Standard (CAL) - $209
• Developer – Available to users for free
• Express – Available to users for free
Additional cost for subscriptions and add-ons include -
• SQL Server Enterprise - $5434/year
• SQL Server Standard - $1418/year
• Big data node cores - $400/year


SQL Server Features

Devices
Business size
S M L
Markets
United States, Canada, United Kingdom, Australia, China and 5 others, India, Japan, Germany, Brazil, Mexico
Supported Languages
Arabic, Chinese (Simplified), Chinese (Traditional), Dutch, English and 5 others, French, Italian, Korean, Portuguese, Spanish

Media

SQL Server add or remove content
SQL Server search content
SQL Server manage content
SQL Server screenshot: SQL Server add or remove content SQL Server screenshot: SQL Server search content SQL Server screenshot: SQL Server manage content

SQL Server Reviews

SQL Server Reviews

Overall rating
4,6
/
5
Excellent
893

Very good
496

Average
35

Poor
3

Terrible
1

Value for Money
4,2
Features
4,6
Ease of Use
4,3
Customer Support
4,3
97% recommended this app
Filipe F.

SQL Server review

SQL server is great, because i can use the same language same application, and for small customers it uses free option, and only for best performnace or bigger data need to pay for it
Can use it locally on on cloud


Yuvraaj D.

There's a reason why most people choose SQL Server over other database softwares

I have never had any problems with SQL Server. It was always efficient and capable of doing whatever needed to be done.


Vikash kumar S.

Easy and Fast for Development


Brenten L.

Powerful and Scalable Database Software

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.


Anthony B.

SQL Server | Inexpensive and Impressive

Our organization uses SQL Server Enterprise as the backend for our Laboratory Information Management System. While we had the option to use Oracle, we went the Microsoft route due to licensing costs and in-house expertise. We have had nothing but positive experiences with SQL Server. From day-to-day operations to high-availability to SQL Agent jobs, we use a large portion of the functionality included with SQL Server.

In addition to our laboratory system, we link SQL Server to our financial system (running on an Oracle database), which allowed us to create a data mart that we use to mine and report financial data through SQL Server Reporting Services.


Filipe F.
Industry: Information Technology & Services
Company size: Self Employed

SQL Server review

Used Daily for 2+ years
Reviewed on 2020/03/10
Review Source: Capterra

SQL server is great, because i can use the same language same application, and for small customers it uses free option, and only for best performnace or bigger data need to pay for it
Can use it locally on on cloud

Pros

SQL Server is a great system to develop databases with great functionalities like jobs, procedures, functions ans so one

Cons

For me the only think not so good is performance for bigger batabases, but for me between 10GiB and 15GiB works fine

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 9.0/10

Yuvraaj D.
Industry: Electrical/Electronic Manufacturing
Company size: 2-10 Employees

There's a reason why most people choose SQL Server over other database softwares

Used Daily for 1+ year
Reviewed on 2020/12/27
Review Source: Capterra

I have never had any problems with SQL Server. It was always efficient and capable of doing whatever needed to be done.

Pros

Security is one of the most important aspects of database software since sensitive information can be stored in databases. SQL Servers are some one of the most secure servers out there so data is safe from hackers.

The scaling aspect of this software is great so whether your business is very small or very large that uses huge amounts of data to be stored, SQL servers can scale and use appropriate resources to handle databases therefore no lagging issues and problems querying databases etc. which makes it extremely fast and efficient.

With the large community that uses SQL Server, you have answers to almost all questions that you may have if you encounter any difficulties setting up or using the software, so troubleshooting is made really easy.

Cons

Cost could be an issue as this software could be a bit expensive however with that being said, you definitely will get quality.

Also there might be certain compatibility issues with other non Microsoft software that your company may use so in some cases you might have to switch over to Microsoft softwares in your company depending on what they are.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 10.0/10

Vikash kumar S.
Industry: Industrial Automation
Company size: 10 000+ Employees

Easy and Fast for Development

Used Daily for 2+ years
Reviewed on 2019/09/19
Review Source: Capterra

Pros

MS SQL makes your life easy by bringing SQL Management tool
easy to create new database on the fly.
Free express Database for development purpose
Easy to troubleshoot performance issue,.
Same SQL can be published to azure or get the same feeling on Azure.
Most used database

Cons

When DB size grow large then it leads to performance issue.
these days in world on No SQL database, ppl tend more use other kind of DBS

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 7.0/10

Brenten L.
Industry: Airlines/Aviation
Company size: 10 000+ Employees

Powerful and Scalable Database Software

Used Daily for 2+ years
Reviewed on 2020/10/28
Review Source: Capterra

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.

Rating breakdown

Value for Money
Ease of Use

Likelihood to recommend: 10.0/10

Anthony B.
Industry: Civil Engineering
Company size: 10 000+ Employees

SQL Server | Inexpensive and Impressive

Used Daily for 2+ years
Reviewed on 2021/01/05
Review Source: Capterra

Our organization uses SQL Server Enterprise as the backend for our Laboratory Information Management System. While we had the option to use Oracle, we went the Microsoft route due to licensing costs and in-house expertise. We have had nothing but positive experiences with SQL Server. From day-to-day operations to high-availability to SQL Agent jobs, we use a large portion of the functionality included with SQL Server.

In addition to our laboratory system, we link SQL Server to our financial system (running on an Oracle database), which allowed us to create a data mart that we use to mine and report financial data through SQL Server Reporting Services.

Pros

* SQL Server Management Studio is intuitive and fairly straightforward to use

* Implementing more advanced features such as SSRS does not require much effort

* Simple process to link other database servers (i.e. Oracle)

* Robust high-availability solutions available

Cons

* Licensing structure for Enterprise version is per core(s)

* Always On Availability Group high-availability solution, while it works well, could have been simpler to set up

* Performance/query tuning recommendations are not easy to locate

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 10.0/10

User recommendation
8,7/10
Based on 1 428 user ratings
Compare user recommendation rating with alternatives
Compare with alternatives

SQL Server Pricing

SQL Server Pricing

Starting from
US$931,00
Free Trial
One Time License
Free
Subscription
Open Source
Value for money

SQL Server offers a 180-day free trial for new users, after which the software is available across various pricing tiers, details of which are outlined below -
• Enterprise - $13748
• Standard (per core) - $3586
• Standard (server) - $899
• Standard (CAL) - $209
• Developer – Available to users for free
• Express – Available to users for free
Additional cost for subscriptions and add-ons include -
• SQL Server Enterprise - $5434/year
• SQL Server Standard - $1418/year
• Big data node cores - $400/year

SQL Server offers a 180-day free trial for new users, after which the software is available across various pricing tiers, details of which are outlined below -
• Enterprise - $13748
• Standard (per core) - $3586
• Standard (server) - $899
• Standard (CAL) - $209
• Developer – Available to users for free
• Express – Available to users for free
Additional cost for subscriptions and add-ons include -
• SQL Server Enterprise - $5434/year
• SQL Server Standard - $1418/year
• Big data node cores - $400/year

Value for Money
4,2/5
Based on 1 428 user ratings
Compare value for money rating with alternatives
Compare with alternatives

SQL Server Features

SQL Server Features

API
Access Control
Activity Dashboard
Activity Tracking
Alerts / Escalation
Auditing
Automatic Notifications
Collaboration Tools
Compliance Management
Data Import/Export
Data Visualization
Drag & Drop Interface
Monitoring
Real Time Data
Real Time Monitoring
Reporting & Statistics
Role-Based Permissions
Search Functionality
Third Party Integration
Workflow Management
Features
4,6/5
Based on 1 428 user ratings
Compare features rating with alternatives
Compare with alternatives

Categories

Additional information for SQL Server

Additional information for SQL Server

Key features of SQL Server

  • Ad hoc Analysis
  • Ad hoc Query
  • Benchmarking
  • Compliance Management
  • Data Analysis
  • Data Storage Management
  • Performance Metrics

SQL Server FAQs

SQL Server FAQs

Below are some frequently asked questions for SQL Server.

Q. What type of pricing plans does SQL Server offer?

SQL Server offers the following pricing plans:

Starting from: US$931,00

Pricing model: One Time License, Free, Subscription, Open Source

Free Trial: Available

SQL Server offers a 180-day free trial for new users, after which the software is available across various pricing tiers, details of which are outlined below - • Enterprise - $13748 • Standard (per core) - $3586 • Standard (server) - $899 • Standard (CAL) - $209 • Developer – Available to users for free • Express – Available to users for free Additional cost for subscriptions and add-ons include - • SQL Server Enterprise - $5434/year • SQL Server Standard - $1418/year • Big data node cores - $400/year

Q. What are the main features of SQL Server?

SQL Server offers the following features:

  • Ad hoc Analysis
  • Ad hoc Query
  • Benchmarking
  • Compliance Management
  • Data Analysis
  • Data Storage Management
  • Performance Metrics

Q. Who are the typical users of SQL Server?

SQL Server has the following typical customers:

Small Business, Large Enterprises, Mid Size Business

Q. What languages does SQL Server support?

SQL Server supports the following languages:

Arabic, Chinese (Simplified), Chinese (Traditional), Dutch, English, French, Italian, Korean, Portuguese, Spanish

Q. Does SQL Server support mobile devices?

We do not have any information about what devices SQL Server supports

Q. What other apps does SQL Server integrate with?

SQL Server integrates with the following applications:

Aginity Pro, Coras, Elipse Software, Mapex, Microsoft Azure, MySQL, frevvo

Q. What level of support does SQL Server offer?

SQL Server offers the following support options:

Phone Support, Online Support, FAQs, Forum, Knowledge Base, Video Tutorials