SQL Server Archived Reviews (More than two years old)
- Highest Rating
- Lowest Rating
- Review Length
Dec 05 2017
What is most valuable?Everything is valuable. It is a relational database system which is critical for storing reporting data or any data that is highly relate-able. Plus your data is one of… more»
How has it helped my organization?In a manufacturing system, storing test data in an Excel file has limitations in how much data can be stored at one time and how many people can manipulate the data at one… more»
What needs improvement?Setting up some of the more complex systems could be simpler. Things like service broker can be tricky to set up for the inexperienced.
What's my experience with pricing, setup cost, and licensing?Pricing and licensing is based on a per core and/or per-processor license. Try to keep these low, but keep it above four. (Four is the minimum number of cores.) If you are… more»
Which solution did I use previously and why did I switch?I did not use a previous solution. I have heard of other companies using Microsoft Access or Excel for similar problems. However, after hearing the headaches they have, I… more»
What other advice do I have?If you don't have a DBA on site, hiring a consultant is recommended to help get things setup and configured. This will reduce headaches down the line.
Which other solutions did I evaluate?We did not evaluate other options. The other options lacked support, lacked performance, or were too expensive.
Aug 15 2017
What is most valuable?* SQL Server Integration Services tools * Data Quality Services tools * Master Data Services tools * SQL Server Reporting Services tools * Data Partitioning (Horizontal… more»
How has it helped my organization?We design and implement DW solutions with SS 2016 Dev Ed tools. This solution has given us high levels of productivity, which has allowed us to use an Agile approach to… more»
What needs improvement?We do not have much to complain about SS 2016 Dev Ed in itself, we do have some complaints regarding licensing for SQL Server 2016 Enterprise Ed. In an emerging market… more»
What's my experience with pricing, setup cost, and licensing?No issues with pricing and licensing for SS 2016 Dev Ed, as it is free of charge, as mentioned above, the thorny issue with pricing and licensing is with customers. We do… more»
Which solution did I use previously and why did I switch?I have always used DW tools from Microsoft since SQL Server 2000.
What other advice do I have?Consider the ROI (most training investment). If training is not in-house, only hire training from an official Microsoft Training Center in your region. Look for the best… more»
Which other solutions did I evaluate?The cost-benefit ratio offered by Microsoft's DW solutions is, by a long shot, much more convenient for our customers (small and medium companies) than solutions from… more»
Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: May 2020.
417,925 professionals have used our research since 2012.
Jun 09 2017
What do you think of SQL Server?
What is most valuable?The Microsoft SQL Server is a great and powerful data storage capable to provide many functionalities starts on free version until the power with BI resource and mirroring.
How has it helped my organization?MS SQL is a recognized data tool, it provides many ways to help us organize data and process information.
What needs improvement?MS SQL need to improve the big data functions and also own market share.
For how long have I used the solution?since 1999
What was my experience with deployment of the solution?few problems
What do I think about the stability of the solution?no
What do I think about the scalability of the solution?i didn't use it like admin, i don't know.
How are customer service and technical support?great product …
Jun 01 2017
What do you think of SQL Server?Where to start? Great range of admin tools (far outnumbers MYSQL) - I like the database tuning tools Nice BI tools and integration ability. Evolves quickly due to the monster support from MS Integrates with the rest of MS products (this is a plus and a minus, of course) Scalable - a few MBs up to petabytes. High availability/failover clustering makes DR straightforward. Own reporting services - if you can't report on it, it's hard to manage. Problems include - is it an MS product? Then licensing can be a pain if they do an audit. Also, with AWS's offerings becoming so easy to set up, scale, and work at great speed, MS SQL probably needs to up its game massively if they are ever going to keep up, let alone fully compete with Amazon's database suite.
Mar 15 2017
What is most valuable?SQL Server integration services tools Data quality services tools Master data services tools SQL Server reporting services tools Data partitioning (horizontal… more»
How has it helped my organization?We design and implement data warehouse solutions with SQL Server 2016 Developer Edition tools. This solution has: Given us high levels of productivity Allowed us to use an… more»
What needs improvement?We do not have much to complain about SQL Server 2016 Developer Edition in itself. We do have some complaints regarding licensing. In an emerging market like Argentina, it… more»
What's my experience with pricing, setup cost, and licensing?We have no issues with pricing and licensing for SQL Server 2016 Developer Edition, as it is free of charge. The thorny issue is with pricing and licensing with customers… more»
Which solution did I use previously and why did I switch?I have used data warehouse tools from Microsoft since SQL Server 2000.
What other advice do I have?My advice is focused on companies that develop and offer data warehouse solutions for customers that use SQL Server. Consider the ROI, which is mostly training investment… more»
Which other solutions did I evaluate?The cost-benefit ratio offered by Microsoft's data warehouse solutions is, by a long shot, much more convenient for our customers, small and medium sized companies, than… more»
Jan 02 2017
The MSBI features SSAS, SSIS as well as SSRS together, has enabled us to build a data warehouse for our Enterprise.
What is most valuable?I would rate MS SQL Server 4/5 for its ease of administration,rich features, Nice GUI support for all its complex features. Valuable features include: 1.Management Studio (Nice GUI support for all its complex features.) 2.Hot add CPU… more»
How has it helped my organization?The MSBI features SSAS, SSIS as well as SSRS together has enabled us to build a data warehouse for our Enterprise with Business Intelligence reports around the data. We have fully exploited its all complex features like Slowly Changing… more»
What needs improvement?I am not sure if these areas have been taken care in SQL 2012 but areas for improvement include: 1.In SQL 2008 ,Data encryption is not a fully mature feature.Encryption works fine for individual rows.For handling a batch a for loop has to… more»
Which solution did I use previously and why did I switch?We were a Microsoft shop (.NET, Share point etc) primarily, hence using MS SQL Server 2008.
What other advice do I have?1. Find out the right licensing mode you require (Comes with different options CAL/Server and # of CPUs and Virtualisation). 2. Use the Enterprise lincencing or Standard edition or Web according to your need. 3.Make use of SQL Server… more»
Nov 21 2016
We're able to create an end-to-end automated BI platform, but we'd prefer hosting multidimensional OLAP instances with Tabular rather than the either/or installation.
What is most valuable?* Business intelligence platform * Analysis services (multidimensional and tabular) * Relational database features * Data extraction and transformation (integration… more»
How has it helped my organization?It provides the ability to create an end-to-end automated BI platform through data management and provisioning, transformation and publication. Data platform development… more»
What needs improvement?Hosting multidimensional OLAP instances in conjunction with Tabular, rather than the either/or installation. OLAP multidimensional ongoing maintenance - automated… more»
What's my experience with pricing, setup cost, and licensing?I don’t concentrate on this issue, but rather the necessary features and the version required.
Which solution did I use previously and why did I switch?Open Source database and OLAP solution was found to lack stability, and required the installation of many moving parts in order to have a complete stack. These services… more»
What other advice do I have?Make sure that you have an experienced database administrator to implement the infrastructure of the solution.
Which other solutions did I evaluate?No other oprions were evaluated.
Jul 31 2014
What is most valuable?Activity Monitor and Dynamic Management Views
How has it helped my organization?After reviewing a client's Microsft SQL environment, I have been able to setup specifics alerts and jobs in SQL Server Management Studio (SSMS) to definitely show them where they are experiencing network latency, disk latency, memory pressure, etc., etc. I have done this type of performance review for over 20 clients in the last 5 years
What needs improvement?When reviewing SQL processes it would be great if all of the local processes on the SQL server were marshaled to a remote SSMS client.
May 01 2014
What is most valuable?- Ease of use of this product is much better than equivalent products - New AlwaysOn availability group enhancements bundles more DR and HA features in one easy to use interface - In-Memory OLTP, or project Hekaton, allows for utilizing memory to boost application performance with only minor application changes - Power, scalability, flexibility, and bundled tooling means it will meet all of your… more»
What needs improvement?- Ease of installation means that anyone can install it, but many do not perform the steps required to properly maintain the data - The increasing cost of the platform is slowing adoption by the SMB space
What other advice do I have?I am so fond of this product that I have dedicated this portion of my career to focusing on mastering this platform as a consultant. I feel that this product is the best fit on the market for your database needs. The product is stellar, the amount of free knowledge on the Internet for this product is without parallel, and the community around SQL Server is so strong that I consider it a family.
May 01 2014
What do you think of SQL Server?Microsoft’s flagship database engine, SQL Server, keeps getting better with every release. The SQL Server 2014 platform is the best-ever SQL Server release, and is packed full of features for organizations of all sizes. Every organization has different requirements for data. Vendors might specify a particular product or platform for their software. In-house development staff might be geared towards one platform over others. Management might have their preferences. SQL Server might not be right for all shops out there, but I can state that it provides the same scalability, flexibility, and raw power of other DBMS platforms on the market, and does it with the easiest to manage suite of features that I encounter. I enjoy this product and the technical community that has grown up around this…
What is SQL Server?
SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development.
Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities.
Also known asMicrosoft SQL Server, MSSQL, MS SQL
SQL Server customers
Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.