Skip to content
Solved Assignments

ITS410 SQL Server 2012 Corporate Proposal - Colorado State University Global Campus

Proposal for corporate implementation of SQL Server 2012.

Preview 3 of 8 pages

See the first 3 pages exactly as they appear in the document.

  1. Page 1
    Read page 1 as text

    Running head: SQL SERVER 2012 CORPORATE PROPOSAL 1 SQL Server 2012 Corporate Proposal Name: ITS 41 0 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.

  2. Page 2
  3. Page 3
    Read page 3 as text

    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.

5 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.

Unlock the full document

More Information Technology study materials

See all

Study this document with CramX

Once it is in your library, every tool can work from it.