18 years helping New Zealand businesses
choose better software

Microsoft SQL Server
What Is Microsoft SQL Server?
Database and analysis offering for rapidly delivering the next generation of scalable e-commerce & line-of-business solutions.
Who Uses Microsoft SQL Server?
Companies of all sizes, looking for database management software
Not sure about Microsoft SQL Server?
Compare with a popular alternative

Microsoft SQL Server
Reviews of Microsoft SQL Server

Microsoft SQL Server
Comments: My experience with Microsoft server is very delightful, I am an independent contractor and I own my own business, so I'm always on my computer, Microsoft server has everything including my data secured and safe, I never have to worry about my data
Pros:
The pros of Microsoft server, it helps support enterprise management and it also helps store your data securely, without worrying about your data security.
Cons:
The cons of Microsoft server, is whenever your Internet are interrupted, you will definitely lose access to your software data.
Alternatives Considered:
The best Database to use with Windows-Native applications
Comments: I've used SQL server since version 7, which is more than 20 years ago, and still use it every day (Although, not version 7!)
Pros:
If you are using C# / .NET on a Windows server, then Microsoft SQL server is the natural choice. The free edition is fine to get started, and once you out grow it, you can afford the license fee (hopefully!)
Cons:
It's very expensive, given that there are free alternatives like MySQL. CSV importing is a pain, when it doesn't need to be.
Microsoft SQL Server: An RDBMS that is Lagging in the Database Industry
Comments: I do believe that Microsoft has improved dramatically the performance and features of MS-SQL Server in the last decade but still many performance tuning on the algorithmic level (especially in concurrency support) has to be targetted.
Pros:
I mostly like the integration features that Microsoft worked on hardly to make its Visual Studio IDE seamlessly integrating MS-SQL Server which makes the development process really streamlined and rapid whether using C#.NET, VB.NET, or the Web ASP.NET. The common language platform features in .NET leverages the RDBMS capabilities of MS SQL Server in development and production environments.
Cons:
The performance of MS-SQL Server lags with concurrent user access. Concurrency support has to be worked on to better compete with industry leading RDBMSes such as Oracle and DB2. Even MySQL can surpass the performance of MS-SQL Server in many concurrency management configurations.
Jr. developer
Pros:
Easy to use, not complicated, easy to use for coding. Easy to download
Cons:
Hard to find the debug, not friendly for the new user.
Alternatives Considered:
Successful data management and administration
Comments: A great tool for database administration and management, the ability to perform easy tasks in terms of backups, restores and replications makes it one of the great options for productive environments where you work.
Pros:
Its ease and versatility in administration tasks, its great integration with bi and bigdata environments, as well as its stability in production environments.
Cons:
The biggest disadvantage I see is that it is not as mature in its implementation in unix environments.
Alternatives Considered:
SQL Server in teaching
Comments: I'm using it at school to teach SQL language and web developing
Pros:
Possibility of using it quite everywhere
Cons:
installation that sometimes crash and has to be dome again
Alternatives Considered:
Microsoft
Comments: I am using it only but many people are doing it and its result is very good.
Pros:
it is very good software it gives very good server i am using it for almost two years
Cons:
I have run it for two years its complete result is very good
Microsoft SQL Server depending on what you need
Comments: What I liked the most is that Microsoft SQL server offers a "free specialized edition" which I used to test what they actually offered and how good it was.
Pros:
Great features, cross-platform, well equiped, a good search/filter system, data secured, and the permissions system seemed pretty secure.
Cons:
The pricing is somewhat high, and it would run slow sometimes for no reasons, something that reports and analytics wouldn't show.
Microsoft hight the world technology
Pros:
Microsoft SQL provides integrated environment for data analysis
Cons:
Mainly cost, and other is complex interface
The complete database solution!
Comments: It's a whole platform that can be installed on any Windows computer, is free for developers, and is well worth a try
Pros:
Excellent relational database management system for massive data analytics; yet, for smaller databases or projects, it might even be too much
Cons:
Since it is difficult to integrate with non-Microsoft products, support for other suppliers and products is not really possible
SQL server Aka the OG
Comments: My first machine language and I have fallen in love with it
Pros:
* best source to extract required data * easy to learn and will get more fun by time you progress in your career
Cons:
* Slow for huge data set loading * intellisense doesn’t work
Microsoft SQL Server will meet all your Database Server needs
Comments: Overall, Microsoft SQL server is a powerful database server option in the market.
Pros:
- Microsoft SQL server is indeed a robust Database Server option. In this review, I will talk about Microsoft SQL in terms of SAP and compare it to its alternative option in SAP - the HANA Server. - When it comes to SAP ERP, our clients have two options for their database server needs - Microsoft SQL Server or HANA server. Microsoft SQL server is great option that will get the job done. Most of us consultants, have the SQL server installed in our local machines since it is impossible to install the HANA server in our local machines because of the heavy resources needed. SAP HANA requires a minimum of 32 GB ram for example.- Microsoft SQL server is easy to install especially the if you are installing the Express Version which is very light and install quickly. - I did not require much training to be able to use the basic features of Microsoft SQL server and I get a free license for my local machine if you install the evaluation version on your machine.
Cons:
- Compared to SAP HANA Server, Microsoft SQL Server has less analytical capabilities but generally, Microsoft SQL is a powerful database server option in the market.- There is a bit of a learning curve involved. If you want to be able to do some complex tasks in Microsoft SQL server, you might need to employ the use of some learning material.

Empowering Enterprise Data Management with MS SQL Server
Comments: MS SQL Server is the cornerstone of our operations, most of our products are based off it. It just works, that's all.
Pros:
Integration with the MS ecosystem, scalability and reliability of the product.
Cons:
Licensing costs too high for non express configurations.
Microsoft SQL Review
Comments: Generally good, little complaints but it isn't a market leader either.
Pros:
It was a simple and effective tool to ETL data from ERP sources and analyse data outside the system.
Cons:
Slightly aged looked, appears to be a bit old and could do with a refresh.
businesses go to solution for databases
Pros:
ease of use and integrationalong with support option makes it a premier product
Cons:
licensing costs, be sure to purchase the correct version and edition
Alternatives Considered:
Versatile DMBS for all businesses
Comments: I have developed software for SQL Server for over 20 years and am happy with how it fits the needs to small businesses.
Pros:
Integration with Access, Excel. C#, and many other tools. Easy to migrate data in and out.
Cons:
Would prefer a data and schema comparison tool that's built in to SSMS rather than having installing Visual Studio and an extension.
Create a structure and store for analysis
Pros:
Best tool to handle Enormous data for your data modules and analysis
Cons:
Hard for scrolling in tables when we have huge lists and if the scroll option can be replaced with some search setting it would be easy.
Microsoft SQL Server
Pros:
The software is easy to use, and the view makes it easy to see all the tables.
Cons:
I do not like that it does not have a commit and rollback feature.
Great RDMS for middle-sized companies.
Comments: Overall Microsoft SQL Server is a very useful software. My daily working process is linked with this program. And it does its job well.
Pros:
In my opinion Microsoft SQL Server is the leader on the market. Performance is great. Installation is so easy.
Cons:
Microsoft SQL Server requires special knowledge to use. I need to know syntax, standard language to manipulate data. Also it is suitable for only little and middle sized companies that store not so much data.
Microsoft SQL Server review
Pros:
What I appreciate most about it is how dependable and simple it is to operate. Under heavy demand, it operates efficiently and guarantees fast execution with little downtime. This is essential for our company
Cons:
Software could be updated to interface with a variety of cloud services that are open source. Sometimes the software breaks because it is too many inquiries

My opinion of Microsoft SQL Server
Comments: Quite simply, my experience with SQl-server is perfect. I've been using it for nearly 2 years and it has helped me a lot in my business intelligence project. It's wonderful to use.
Pros:
As a relational GBD system, it's the perfect tool for data analysts. It enables users to extract, transform and download the data they need in a matter of seconds.
Cons:
it requires more data storage to install the DB engine than other SQL DBs.
The first thing that comes to mind when talking about database is
Pros:
A program that can handle heavy workloads with the appropriate hardware. The express version is also used in many software.
Cons:
It consumes a lot of hardware resources. If your hardware is not good, it responds very late.

Developer Friendly
Comments: All companies I worked for had MS SQL Server. I also used it as a database. I have gained a lot of experience especially in creating tables, procedures and jobs.
Pros:
We usually use it to keep our own inventory. We chose it because it has a corporate architecture. My favorite features are automatic code completion, creating parts such as tables and indexes without writing code, high level of authorization, multiple users working on the same data, and having a software-friendly interface.
Cons:
When I first started coding, I used MS SQL Server as a database. I've been using it for about 15 years. So far, it has never upset me and there is nothing that I dislike.

A performance database but can carry high licensing costs
Comments: We use SQL Server to handle all our ERP softwares backend database and deliver business critical data in a fast and responsive way.
Pros:
SQL Server is a fast performing database that allows us to scale and replicate our systems to multiple sites and the cloud.
Cons:
Licensing costs can be restrictive for smaller organisations and also complicated to understand.
I like using Microsoft SQL
Comments: Been using this for over a year now and its been a great help whenever I need to give reports to our department heads regarding our customers
Pros:
I'm not a data analyst that mostly use SQL. But I used it from time to time to create reports for our department heads.
Cons:
not really sure if there's one. I'm sure any sql experts can say a thing or two but not me