When CCCL Inc was a small company, maintaining customer records and data through the use of spreadsheets, access databases, and manual records was a realistic practice, but gradually As the company has grown, it has outgrown such practices. GRW management is now looking for a centralized database solution that enables database collaboration across multiple departments and the ability to extract data as needed, enterprise-wide. The proposed solution to the company's needs is the installation of Microsoft SQL Server 2012. The following report addresses the type of SQL Server to be implemented, security for the new database, high availability, backup and recovery plans, integration services and other related details to ensure a smooth transition to the company's new database. Selecting and Installing SQL EditionSQL Server 2012 is available in three main editions that include Standard, Business Intelligence (BI), and Enterprise. Each consecutive edition includes all the features of the previous one, but with additional features. The Standard Edition of SQL Server 2012 is the base edition that includes features such as programmability, manageability, basic high availability, basic enterprise BI, and basic data integration. The BI edition adds self-service business intelligence, advanced enterprise business intelligence, and enterprise data management capabilities. SQL Server 2012 Enterprise Edition further adds advanced data integration, advanced security, data warehousing, and advanced high availability (Microsoft, n.d.). In addition to the three main editions of SQL Server 2012, there are more highly specialized editions designed with specific needs in mind, such as the Developer, Web, and Express editions.Installing SQL Server...... half of paper..... .often moved away from the DES encryption standard and implemented much stronger AES encryption. AES is currently the industry standard for data encryption. Microsoft References. (n.d.). Choose an authentication mode. Retrieved October 19, 2013, from http://technet.microsoft.com/en-us/library/ms144284.aspxMicrosoft. (n.d.). Grant a permission to a principal. Retrieved November 21, 2013, from http://technet.microsoft.com/en-us/library/ff878066.aspxMicrosoft. (n.d.). Hardware and software requirements for installing SQL Server 2012. Retrieved November 18, 2013, from http://msdn.microsoft.com/en-us/library/ms143506.aspxMicrosoft. (n.d.). SQL Server 2012 editions. Retrieved November 18, 2013, from http://www.microsoft.com/en-us/sqlserver/editions.aspxMistry, R. & Misner, S. (2012). Introducing Microsoft SQL Server 2012. Redmond Washington. Microsoft Press.
tags