SQL Server Implementation Proposal

Recently, Shiv Corp, a solar panel manufacturing business, put out a bid for database system due to their rapid growth. Congratulations! Your company was chosen from many to develop and implement a proposal for implementation of SQL Server.

Shiv Corp uses MySQL for their order placement system. There are various problems with the current implementation of MySQL including, but not limited to, availability, redundancy, security, and performance monitoring. Plus, the chief information officer (CIO) of Shiv Corp is concerned that there is no professional support because it based on open standards. The CIO is asking that you develop a proposal to move to a SQL Server from MySQL, keeping the cost minimal.

Your proposal should include the following criteria and the reasoning behind your choices:

• The version of SQL Server
• The architecture of the file system of the SQL Server
• Database and data security plan
• Database optimization plan
• Backup and recovery plan
• Proactive monitoring plan