Sql Server Proposal

SQL Server Proposal Margaret E. McWhorter ITS410 - Database Management Colorado State University – Global Campus Dr. Mazen Alkhatib January 4, 2017 SQL Server 2012 Corporate Proposal Overview Thank you for the opportunity to present this proposal on behalf of McWhorter Consulting. Our recommendation is that Shiv Corp transitions their systems from MySql to SQL Server 2012. This proposal provides details for the transition, system requirements, data security, performance monitoring, and a back-up plan in case of system outage or failure. Which Edition Should you Choose? There are a number of editions and versions of SQL server 2012 for a company to choose from and utilize. The editions range in functionality and size and include, Express, Web, Standard, Enterprise, and Business intelligence. It is our recommendation that Shiv Corporation utilizes the Enterprise edition. This version of SQL Server 2012 is the most in depth, it contains all of the tools necessary to run a in depth SQL program without having to purchase additional software. The other editions are all reasonable options, but will not be all inclusive of the items that the company may need in order to operate and ensure there is no impact to their daily productivity. Though these options from a start up cost may be cheaper, we believe that the overall start up investment will save money in the future when compared to the other editions of SQL Server 2012. SQL Server 2012 Enterprise Edition is the better option over the standard version as it will provide more functionality for Shiv Corporation. SQL Server 2012 Enterprise allows for more than 64GB of memory per instance which will help stabilize and ensure enough memory is available to keep up with task being assigned to the server. Enterprise Edition also offers Partition Switching, AlwaysOn Availability groups, Resource Government, Columnstore Indexes, Online Reindexing, Advanced Adapters, Advanced Transforms for SSIS, Change Data Capture, and SSRS Data Driven Subscription just to name a few (McCown, J, 2014.). All of these functions help to make the system administrators job a little easier and the can manage the database more efficiently. SQL Server 2012 Enterprise Edition can handle up fifty multiple instances at one time, which increases scalability and performance in growing corporations. The features mentioned above are what allow for its ability to perform at a higher level than the other editions available. Enterprise Edition includes such scalability features as table and index partitioning, data compression and partition table parallelism. Enterprise Edition comes with PowerPivot for SharePoint and Master Data services. This features allow for easier access to data thus increasing the ability to quickly efficiently analyze data in the SharePoint environment, and helps to ensure data consistency and manageability across your company (Sheldon, R., n.d.). System and Security Requirements There are a few requirements in order to have a successful install of SQL Server 2012. Hardware must meet certain minimums in order to run SQL server. There are also a few recommendations that Microsoft provides in order to best optimize SQL server 2012. SQL server is designed to run on multiple types of devices, from desktops and laptops. The minimum processing speed for the 32-bit implementation is 1.0GHz and for the 64-bit implementation is 1.4GHz, it is our recommendation that Shiv Corporation utilizes the 64-bit implementation as this will allow for use of all features. The 64-bit addition allows for hot swapping of memory