Running head: SQL SERVER 2012 CORPORATE PROPOSAL 1
SQL Server 2012 Corporate
Proposal Paul Schroeder
ITS410
Colorado State University Global Campus
Dr. Boateng
1/4/14
, SQL SERVER 2012 CORPORATE 2
PROPOSAL
SQL Server 2012 Corporate Proposal
Overview
ESL Inc. is a large company that has been using a series of spreadsheets, access
databases, and manual records to keep track of the majority of the organization’s internal
and customer data. The company has grown significantly over the years and is now
looking to implement a comprehensive solution for all their data storage needs. The
objective of this proposal is to recommend an enterprise level, highly scalable, and secure
Microsoft SQL Server-based infrastructure with company-wide service availability.
The following proposal includes recommendations of the SQL Server edition, its
capabilities, and its system requirements. Data security, including user access methods, is
also addressed. Performance monitoring tools and techniques are outlined, as well as
backup types and plans. ESL Inc. will also require a tool to integrate its existing data to
the new database, which is also proposed below. Finally, potential risks and mitigation
practices for these risks are defined.
Proposal
SQL Server 2012 comes in a variety of editions depending on a company’s
specific needs. These editions are Enterprise, Business Intelligence, Standard, Web, and
Express. Each installation version offers different features, with Enterprise being the
most robust and Express being the most limited. For ESL Inc., the Enterprise edition
would give the most options while allowing for future expansion.
SQL Server 2012 Corporate
Proposal Paul Schroeder
ITS410
Colorado State University Global Campus
Dr. Boateng
1/4/14
, SQL SERVER 2012 CORPORATE 2
PROPOSAL
SQL Server 2012 Corporate Proposal
Overview
ESL Inc. is a large company that has been using a series of spreadsheets, access
databases, and manual records to keep track of the majority of the organization’s internal
and customer data. The company has grown significantly over the years and is now
looking to implement a comprehensive solution for all their data storage needs. The
objective of this proposal is to recommend an enterprise level, highly scalable, and secure
Microsoft SQL Server-based infrastructure with company-wide service availability.
The following proposal includes recommendations of the SQL Server edition, its
capabilities, and its system requirements. Data security, including user access methods, is
also addressed. Performance monitoring tools and techniques are outlined, as well as
backup types and plans. ESL Inc. will also require a tool to integrate its existing data to
the new database, which is also proposed below. Finally, potential risks and mitigation
practices for these risks are defined.
Proposal
SQL Server 2012 comes in a variety of editions depending on a company’s
specific needs. These editions are Enterprise, Business Intelligence, Standard, Web, and
Express. Each installation version offers different features, with Enterprise being the
most robust and Express being the most limited. For ESL Inc., the Enterprise edition
would give the most options while allowing for future expansion.
