



Sales summary




Supported Operating System(s):
Windows 7, Windows Vista, Windows XP, Mac OS, Linux, HP-UX, AIX, Solaris, Unix, IBM OS/400, Web browser (OS agnostic), Windows 2000, Windows 8, Windows 10About Microsoft SQL Server - BI Edition
Microsoft SQL Server Business Intelligence (BI) Edition is a database management and BI software solution designed for companies of all sizes. The system offers relational database management, which allows users to access enterprise data using structured query language. The solution allows users to perform complex analysis on the database. The product also features a BI Semantic model that allows users to extract and analyze data from heterogeneous sources.
Microsoft SQL Server features “in-memory analytics,” which allows users to perform queries and analytics while the data is in the RAM, thereby improving the speed of access. The software has scalable and corporate reporting features that help management to make decisions that are more informed....
Sales summary
Supported Operating System(s):
Windows 7, Windows Vista, Windows XP, Mac OS, Linux, HP-UX, AIX, Solaris, Unix, IBM OS/400, Web browser (OS agnostic), Windows 2000, Windows 8, Windows 10Average User Ratings
Overall
Ease-of-use
4.5
Value for money
4.0
Customer support
4.5
Functionality
4.5
Likelihood to Recommend
Not likely
Very likely
March 2020
Kudakwashe from Madrush Technologies
Company Size: 11-50 employees
Industry: Information Technology and Services
Time Used: More than 2 years
Review Source: Capterra
Ease-of-use
5.0
Value for money
5.0
Customer support
4.0
Functionality
5.0
March 2020
Data Management made so easy with MS SQL Server
Pros
For any developer, before first they can this own what their apps are going to be developed in their should think of what server should host their database. I do believe that MS SQL Server is the best on the marketing when comes to data management and administration. The best feature that i really love the most on MS SQL Server is the ability to disable remote execution of your queries and really helps protect data integrity in case your server authentication has been compromised. You can also be rest assured that your data is consistent and accurate at all times. Yes hackers some times can try sql injection but i believe MS SQL Server its the most secure servers around.
Cons
The license key for MS SQL might cost you an arm and a leg but at the end of the day its really worth it when you think of a platform where you are able to develop enterprise apps that secure and helps with Business Intelligence.
Reasons for Choosing Microsoft SQL Server - BI Edition
In the case of Oracle DB vs MS SQL Server, MS SQL Server is easy to manage, easy to configure and has a huge community in case when you are stuck with any problem you are guaranteed to get a solution online.
November 2019
Imi from IT
Company Size: 201-500 employees
Industry: Political Organization
Time Used: More than 2 years
Review Source: Capterra
Ease-of-use
5.0
Customer support
1.0
Functionality
5.0
November 2019
SQL is getting better as it grows older
SQL Server centralized my data and allows my staff to "believe" that they are working in Excel, It is super fast for loading data from the server, and allow large data set that will normally take hours, or even crash the Excel spreadsheet to load without any issue. When I am ready for a web app.. SQL server is easy as piece to develop a simple CRUD application and push live. It seem to connect to every thing - from MS Word Mail merge, MS Excel, MS Access and of course for development environment such as Visual Studios. One Database ( Centralized) and many presentation modes for the end users. I love it!
Pros
MS SQL Server is certainly a competently relational database engine, with reporting service and now R. Easy to install for small onpremise application. Easy to administer, easy to backup, easy because it is a Microsoft application. It is so easy that most of the application today I work on seem to be pulling data from SQL into Excel and or Power BI. You can start from free version and expand as time goes by. The management studio take the pain our of scripting, and the online support community most likely have your questions answered with T-SQL scripts for copy and pasting. If you deciding on an option for an Relational Database system - you should look at this as your most productive option. It allows you to focus on the problem by making the technology easy.
Cons
The new the version, the more memory intensive this management studio will become. Microsoft need to create some more easy to use tool for change control and change tracking. Backward compatibility - if you used a higher version during development, then it become a pain to use a lower version during production environment.
Reasons for Choosing Microsoft SQL Server - BI Edition
Cost and community of supporters, access to information on the open internet . Available of training.
Reasons for Switching to Microsoft SQL Server - BI Edition
Ease of use, Easy to learn, easy to teach easy to integrate with well know tools.
January 2021
Anthony from Intertek-PSI
Company Size: 10,000+ employees
Industry: Civil Engineering
Time Used: More than 2 years
Review Source: Capterra
Ease-of-use
5.0
Value for money
5.0
Customer support
5.0
Functionality
5.0
January 2021
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.
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
Reasons for Choosing Microsoft SQL Server - BI Edition
We chose SQL Server over the main competitor due to both cost and in-house expertise. SQL Server was much less expensive than its Oracle counterpart and does an excellent job. As a Microsoft shop, we also have a greater deal of experience and familiarity with Microsoft products.
September 2019
Vikash Kumar from HPE
Company Size: 10,000+ employees
Industry: Industrial Automation
Time Used: More than 2 years
Review Source: Capterra
Ease-of-use
5.0
Value for money
4.0
Customer support
3.0
Functionality
4.0
September 2019
Easy and Fast for Development
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
December 2020
Yuvraaj from Sunrise Enterprises
Company Size: 2-10 employees
Industry: Electrical/Electronic Manufacturing
Time Used: Less than 2 years
Review Source: Capterra
Ease-of-use
5.0
Value for money
4.0
Customer support
4.0
Functionality
5.0
December 2020
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.
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.
Reasons for Choosing Microsoft SQL Server - BI Edition
Our company uses a Microsoft Infrastructure so it would have been really easy to integrate it into operation.