ITS410 SQL Server 2012 Corporate Proposal - Colorado State University Global Campus
Proposal for corporate implementation of SQL Server 2012.
Benjamin Fisher
Contributor
4.1
56
5 months ago
Preview (3 of 8 Pages)
100%
Purchase to unlock
Loading document content...
Preview Mode
Sign in to access the full document!
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. 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.
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