Hosting a Microsoft SQL Server for small and enterprise businesses
October 22, 2020

Hosting a Microsoft SQL Server for small and enterprise businesses

Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft SQL Server

Our company uses MS SQL Server to run jobs, store data and generates reports. Our team is supporting two separate companies and both use MS SQL Server. One is for storing data and running SSIS jobs for app and reporting purposes. These are company-owned servers and we are hosting other companies to provide service, application and hardware support for them.
Our company maintains these servers and they are being used by different departments, also internal company-wide. Business problems that we commonly encountered are mostly connection issues. These are basically a between network, database and applications connecting to MS SQL Server. The MS SQL Server support is easy to get in touch with when we are having issues with the application itself.

Pros

  • Maintenance, SQL server is easy to maintain.
  • User Friendly, Easy to use and understand.
  • Access, user access, and administration are very straightforward.
  • Application, it is easy to setup and provide service.
  • Can be used in small and enterprise sized clients.

Cons

  • Support cost, need to pay for support.
  • Compatibility with other new technologies.
  • Reporting capabilities.
  • Licensing, it is a lot of work to get licenses renewal
  • Support income, we are getting paid by selling our services.
  • Hosting income, we own the servers and we can provide support for multiple companies.
  • Internal support, as we own the servers, we can have internal support.
Oracle DB and SQL Server are very much alike. They provide the same quality of service and applications. The difference is only the price and support from them. Development codes and almost similar and can be used either way, which is very favorable for users. They can adopt to other Database with the knowledge of the other. Database Queries wise, they are almost identical. Very useful if your company has both services.
In case we have to tap their support services, we are getting different responses. But, most of the times, they provide urgent and superb services. During an issue with a SQL defect or compatibility issue, the support constantly provides updates and follow-ups to the development so we can stay updated.
SQL Server is very user-friendly and easy to use. The wizard and setup are straight forward. Development codes are free and can be outsourced. The IT community are very helpful when it comes with codes. In this SQL server stands out because a lot of people and company are using it.

Do you think Microsoft SQL Server delivers good value for the price?

Yes

Are you happy with Microsoft SQL Server's feature set?

Yes

Did Microsoft SQL Server live up to sales and marketing promises?

Yes

Did implementation of Microsoft SQL Server go as expected?

Yes

Would you buy Microsoft SQL Server again?

Yes

Oracle Database, Red Hat Enterprise Linux (RHEL), Ubuntu Linux
I think it is best used in small businesses if you will be just paying for the hosting platform. Building your own server, maintenance, support, and application will be very expensive. Getting support solutions from other companies will be the best option since you will not have any problems setting up and will have the database and reports ready for you. In the enterprise setting, creating and building will only have a licensing issue if they can provide and maintain their own servers.

Comments

More Reviews of Microsoft SQL Server