SQL Server Reviews

• SQL Server provide end users and database programmers with a broad spectrum of services such as Analysis and Reporting services, Data Engine, Integration Services thus making database development and management easier and reliable. • SQL Server offers a platform on which data in all levels- structured, semi-structured, and unstructured data can be managed, integrated and analyzed thus enabling an organization to realize its mission-critical information. • Latest versions of SQL Server provide a handy development studio that not only make the creation of database objects easy but also offer useful tools such Object Explorer to allow quick processes.

• SQL Server work best with Windows Operating System and it is not compatible with some other systems hence limiting its platform friendliness. • Advance versions with higher functionality such as Work Group Edition have high installation requirement such as multi-processor computers, larger primary memory and are not open source.

• Database developers who want to have a clear logical and physical understanding of database systems will no doubt benefit much from using SQL Server. I personally marvel at the extensible support provided by the management studio especially on disk and file management as I enjoy using SQL Server 2008. SQL Server is friendly to both beginners and experts and its installation process can be customized to suite different features.

It is widely used and we never have problems with it. It can handle a PC, and it can also handle huge data. It is fast and efficient. It is something unique that tracks reporting of records, personnel, finances and more. It also integrates well with everything, not just Microsoft tools. 

It would be nice to search for specific value across multiple tables. This would save a lot of time. 

More than five years.

I have never had a problem with the stability of the solution. 

We have never really had a problem with the scalability of the solution. 

I have never used technical support. It is the joke at the office that you cannot get help on the Microsoft website at all. Also, downloading anything from Microsoft is usually a nightmare. Honestly, I end up googling the problem and solving it myself. This is definitely something Microsoft needs to improve.

It is definitely important for someone looking at a new vendor to consider the support of the solution. In addition, the customer should really do their research and understand what their needs are, and make sure the new solution will solve those needs. 

My background is primarily in software development, and I use SQL Server among other tools in that capacity. SQL Server was one of the main databases in my previous company, and it is used for storing data from different applications.

It is easy to use and easy to perform a backup.

It is easy to find resources that can manage SQL Server.

In my experience, I've found that scalability can be improved.

I have used SQL Server while working for different companies.

This is a stable product.

We have between 40 and 50 applications running on it, which are used by many people.

The support from Microsoft is good.

The installation is simple.

We have an in-house team for deployment and maintenance.

One administrator is suitable for managing it.

In summary, this is a good product and I recommend it.

I would rate this solution a nine out of ten.

On-premises

It’s easy to develop and learn for newbies, and community MVP’s are so powerful and qualified, so info is easily accessible.

Also, SQL Server is not only a DBMS solution anymore, it is also a BI platform, and improvements are being made continuously.

SQL Server is our main RDBMS for SIS (Student Information System) and also our DWH, which are hosted on our SQL Server.

Version management, editor capabilities, CDC (change date capture), and some advanced analytic functions should be added; continuous integration solutions.

I’ve been developing with MS SQL Server for nearly 20 years, since Version 6.5.

Not in this version.

Yes, we did, with the 2008 version.

We have a yearly technical support agreement with a major partner. Consultant meetings are a requirement.

No. We’ve been using SQL Server for 17 years.

We’ve been using AlwaysOn availability groups for three years. It took a while to model the structure, but now it is stabilized, and safe with disaster recovery and failover configurations.

It was years ago, so it’s not relevant info anymore.

Database modeling and indexing best practices are so important. Do not defer to implement these practices. Before installation, planning different file groups for temp, data, and index files will help to gain performance and maintenance advantages.