Option #1: SQL Server Implementation Proposal

User Generated

aulvirr26

Computer Science

Description

Option #1: 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

Deliverable

Your APA-formatted proposal should be at least 10 pages in length, not including the title and reference page(s). Follow the appropriate CSU-Global Guide to Writing and APA for this assignment.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Please find the answer in the attached word file. I really did my best. One of my best works ever. Thanks.

Running Head: SQL SERVER IMPLEMENTATION PROPOSAL

SQL Server Implementation Proposal
Name
Course Name
University Name
Professor Name
Date

1

SQL SERVER IMPLEMENTATION PROPOSAL

2

Introduction
Shiv Corp utilizes MySQL in their current order placement system. Multiple
challenges are however encountered with this kind of implementation like redundancy,
availability, security, and performance monitoring, as well as concerns from Shiv Corp’s
chief information officer of reduced levels of professional kind of support as MYSQL, is
majorly centered on open standards. As a result, the chief information officer wants
migration to a SQL Server to keep the costs minimized. A database that is centralized shall
allow Shiv conduct as much data mining as the organization needs, and the database shall
as well permit for cross-department kind of collaboration in the database. The proposed
solution is the installation of a Microsoft SQL Server 2012 database. This proposal will
outline the proposed solution including all aspects of the database (security, optimization,
backup and recovery plan as well as monitoring).

The version of SQL Server
Microsoft SQL Server 2012 is the ideal database to be installed due to the low cost
involved and its high capabilities. According to Henschen (2012), Microsoft SQL Server
2012 is a less expensive option compared to Oracle Database or IBM DB2. The use of the
Oracle Database could result in 40% additional costs in deployment as compared to
Microsoft SQL Server.
The tools that come included with Microsoft SQL Server 2012 allow for the ease
of use to manage the database. Particularly, the AlwaysOn feature present in SQL Server
2012 aids the user in having up to 4 read-only copies of the databases that are primary.

SQL SERVER IMPLEMENTATION PROPOSAL

3

AlwaysOn allows for multiple databases to be combined in a single failover group, which
helps ensure the stability of the database.
SQL Server 2012 Enterprise version is the best option compared to the regular
format because it will bring extra functionality for Shiv Corp. It allows for more than 64
GB of main memory for any event that will help reduce and maintain adequate memory
and can be used to keep the job, which is reserved for the server.

The architecture of the file system of the SQL Server
Microsoft SQL Server 2012 Enterprise edition’s 64-bit installation shall need a
minimum capacity of 1GB of RAM, but a minimum capacity of 4GB is recommended. The
RAM size is supposed to grow in the same way that the database size also grows. If this is
not done appropriately poor performance will be realized. The processing speed’s
minimum requirement should be about 1.4GHz although 2GHz is the recommended
processing speed for this organization. Other specifications also include things like the
processor’s manufacturer as well as its model. The minimum requirement needed for the
hard drive should be 6GB for installation, but that memory size could be decreased
significantly depending on the system configuration as well as the installed features.
Additional requirements that must be met is the presence of a physical or virtual DVD
drive. Others include 64-bit Windows OS, internet access, and a web browser like Internet
Explorer v7 or higher. (Akkawi, & Schofield, 2014, p. 18)
Two server authentication methods will be utilized which include authentication
mode and Windows authentication. Windows Authentication uses window logging to
permit users to have access to the server. This kind of authentication thwarts the users from

SQL SERVER IMPLEMENTATION PROPOSAL

4

accessing them every t...


Anonymous
Excellent! Definitely coming back for more study materials.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags