ITS410 SQL Server 2012 Corporate Proposal - Colorado State University Global Campus
Proposal for corporate implementation of SQL Server 2012.
Benjamin Fisher
Contributor
5.0
55
about 1 month ago
Preview (3 of 8)
Sign in to access the full document!
Running head: SQL SERVER 2012 CORPORATE PROPOSAL 1
SQL Server 2012 Corporate Proposal
Name:
ITS410
Colorado State University Global Campus
SQL Server 2012 Corporate Proposal
Based on your proposal for the implementation of SQL Server 2012 at ESL Inc.,
critically evaluate the recommended SQL Server edition, security measures, and
performance optimization strategies. Discuss how these recommendations align with the
company’s goals of scalability, data security, and performance. Additionally, explain the
importance of integrating legacy data and the role of tools like SQL Server Integration
Services (SSIS) in this process.
Your answer should include references to system requirements, backup strategies, and
potential risks. Ensure your response is 1,000–1,200 words.
SQL Server 2012 Corporate Proposal
Name:
ITS410
Colorado State University Global Campus
SQL Server 2012 Corporate Proposal
Based on your proposal for the implementation of SQL Server 2012 at ESL Inc.,
critically evaluate the recommended SQL Server edition, security measures, and
performance optimization strategies. Discuss how these recommendations align with the
company’s goals of scalability, data security, and performance. Additionally, explain the
importance of integrating legacy data and the role of tools like SQL Server Integration
Services (SSIS) in this process.
Your answer should include references to system requirements, backup strategies, and
potential risks. Ensure your response is 1,000–1,200 words.
SQL SERVER 2012 CORPORATE PROPOSAL 2
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, highlyscalable, 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.
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, highlyscalable, 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.
Preview Mode
Sign in to access the full document!
100%
Study Now!
XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat
Document Details
University
Colorado State University
Subject
Information Technology