SQL Server

by Microsoft

4.5 / 5 825 reviews
SQL Server

Popular Products


Who Uses This Software?

Any company of all sizes, looking for database management software

Average Ratings

825 reviews
  • Overall 4.5 / 5
  • Ease of Use 4 / 5
  • Customer Service 4 / 5
  • Features 4.5 / 5
  • Value for Money 4 / 5

Product Details

  • Starting Price $931/one-time
  • Free Version Yes
  • Free Trial No
  • Deployment Installed - Windows
  • Training In Person
    Webinars
    Documentation
  • Support 24/7 (Live Rep)
    Online

Vendor Details

  • Microsoft
  • http://www.microsoft.com
  • Founded 1975

About SQL Server

A relational database management system developed by Microsoft as a database server, designed to store and retrieve different requests. Choose your preferred language and platform and build modern applications creatively. Take advantage of breakthrough performance and availability while turning raw data into meaningful reports that can be delivered to any device or platform.

Spotlight_media_placeholder

SQL Server Features

  • Backup and Recovery
  • Data Migration
  • Data Replication
  • Data Security
  • Database Conversion
  • Mobile Access
  • NOSQL
  • Performance Analysis
  • Queries
  • Relational
  • Virtualization
  • Backup
  • Data Migration
  • Database Conversion
  • Monitoring
  • OLAP
  • Performance Analysis
  • Queries
  • Storage Optimization

SQL Server Most Helpful Reviews

SQL Server is the backbone of my life!

Translate with Google Reviewed on 2/4/2019
Griffin B.
Senior Strategic Planning Analyst
Hospitality, 1,001-5,000 Employees
Used the Software for: 2+ years
Reviewer Source 
5/5
Overall
3 / 5
Ease of Use
5 / 5
Features & Functionality
Customer Support
5 / 5
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

Comments: Overall, my experience with SQL Server is amazing! I am able to store all of our Las Vegas luxury casino data (gaming, hotel, food & beverage, entertainment, etc.) and query that for information that we then turn into automated or ad-hoc reports. These then go to the operators of the business as well as the executives who analyze the reports and make better decisions daily, weekly, and monthly. The goal is simple: just become better over time...better than you were last year, last month, last week. And SQL Server is the vehicle to empower your organization to find those valuable insights hiding in plain sight to do just that!

Pros: I absolutely LOVE SQL Server. It is my favorite software to use because the possibilities for query-writing are endless. I would say this is the most reliable and flexible of all the database software I have ever used. SQL Server allows you to write in T-SQL (T = transact, SQL = structured query language), which means that you can create variables, use temp tables, and write code in a procedural format that runs akin to a module in other programming languages. We use SQL Server 2008 at work, though I am really loving the new features in the latest version (as of today) SQL Server 2016. Overall, SQL Server is a platform for creating table schema, storing information, and then writing scripts (queries) to manipulate that data--to find insights that are useful to making better business decisions. The interface is easy to understand, the error-checking is strong (and actually tells you what is wrong). It doesn't hold your hand like other simplified coding languages, but it becomes very reliable and easy to use once you obtain a solid foundation in relational database theory and SQL language.

Cons: Hmm...if I had to speak ill of SQL Server...I would probably say that it is a bit tricky to get up to speed quickly with. There's a lot to it, so to speak, so it's taken me the better part of five years working in the data analytics industry to finally say that I feel I am completely proficient in utilizing the software to its full potential. Topics such as query optimization remain my areas of biggest weakness. I can write a query to pull any kind of desired information; however, the art lies in being able to pull it quickly and with reasonable efficiency. If your query takes more than 15 minutes (or even hours!) to run, it's probably not written correctly and likely poses a major threat to the server you are connecting to (and tying up!) in the process. I would like more information in the software (GUIs, warnings, etc.) regarding poorly-written queries from an execution standpoint.

SQL Server 2016 - Features Review

Translate with Google Reviewed on 12/20/2018
Senior Consultant
Hospital & Health Care, 10,001+ Employees
Used the Software for: 2+ years
Reviewer Source 
4/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

Comments: Overall experience with SQL server 2016 is very nice and excited in my perceptions due to Better support for memory optimzed tables, Built in JSON support, Stretch DB concepts, Query Store and dynamic temp db according to size and presence of CPU in the databases.

Pros: In our project we have been migrated from Microsoft SQL Server 2008 to SQL server 2016 directly for all our databases & SSIS packages. There are many features that was available to use for the projects and some of those are: 1. Data was always encrypted, so less vulnerable to SQL injections and useful to take a backup when database is in motion. Prior version (Before SQL server 2016) support only when databases is in Rest.
2. Data/Software Migration is very useful from prior version without any issues or taking any time. It took only set of testing activities and 2 hours of trun around time to get it upgraded.
3. Very simillar like XML TSQL clause created in SQL 2005, in SQL 2016 JSON clause T-SQL has been created for JSON output from querying database objects.
4. In prior versions we have to wait for long running query to capture, however in SQL server 2016 ability to view the execution plan as the query is active on the system.
5. Strecth Database is a new concept that has been created and stored in Azure. However in the background it is shown as single databases for user views.

Cons: Only I know very least number of disadvantages this MS SQL server 2016 is having: 1. Enterprise pricing may be costly as some of the organisation cant afford for the count of data they are having.
2 With the performance tuning, Microsoft SQL Server will be having some gobble resources.

Read More Reviews