When CCCL Inc was a small company, keeping records and customer data by the use of spreadsheets, access databases, and manual records were realistic practices, but as the company has grown, it has outgrown such practices. Management at GRW is now searching for a centralized database solution that will allow multi-department database collaboration as well as the ability to mine data as needed, companywide. The proposed solution to the needs of the company is the installation of Microsoft SQL Server 2012. The following report addresses the type of SQL Server to implement, security for the new database, high availability, plans for backup & recovery, integration services, and other related details to ensure a smooth transition into the company’s new database.
SQL Edition Selection and Installation
SQL Server 2012 is available in three major editions which include Standard, Business Intelligence (BI), and Enterprise. Each consecutive edition includes all the features of its predecessor, yet with additional features. The Standard Edition of SQL Server 2012 is the base edition which includes features such as programmability, manageability, basic high availability, basic corporate BI, and basic data integration. The BI edition adds the features of self-service business intelligence, advance corporate business intelligence, and enterprise data management. 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 major editions of SQL Server 2012, are more highly specialized editions, which are designed with specific needs in mind, such as the Developer, Web, and Express editions.
Installation of SQL Server...
... middle of paper ...
...oft moved away from the DES encryption standard, and implemented the much stronger AES encryption. AES is currently the industry standard for data encryption.
Microsoft. (n.d.). Choose an Authentication Mode. Retrieved October 19, 2013 from http://technet.microsoft.com/en-us/library/ms144284.aspx
Microsoft. (n.d.). Grant a Permission to a Principal. Retrieved November 21, 2013 from http://technet.microsoft.com/en-us/library/ff878066.aspx
Microsoft. (n.d.). Hardware and Software Requirements for Installing SQL Server 2012. Retrieved November 18, 2013 from http://msdn.microsoft.com/en-us/library/ms143506.aspx
Microsoft. (n.d.). SQL Server 2012 Editions. Retrieved November 18, 2013 from http://www.microsoft.com/en-us/sqlserver/editions.aspx
Mistry, R. & Misner, S. (2012). Introducing Microsoft SQL Server 2012. Redmond Washington. Microsoft Press.