SQL Server Proposal for GRW Inc

When CCCL Inc is a small business it is realistic to use a spreadsheet to store records and customer data, accessing the database and manual records, but as the company grew, it exceeded this approach . The GRW management team is currently looking for a centralized database solution that enables multi-sector database collaboration and the ability to minify data as needed across the company. The recommended solution is to install Microsoft SQL Server 2012 for company requirements.

SQL Server version 0 was released in 1989, born from Sybase SQL Server. Microsoft later terminated the mutual license agreement with Sybase and continued to develop its own version of SQL Server. The latest version is SQL Server 2008 released on August 6, 2008. This includes many improvements in speed and functionality. This will be explained in more detail below. A transaction (a single logical unit of work) is an action or sequence of actions performed by a user or application that can access and change the contents of the database. Transactions allow a database to transition from one consistent state to another and succeed or fail. Aborting a failed transaction restores the database to its previous consistent state. The database management system is responsible for ensuring that all transactions related updates have been performed, or that the transaction is stable if the transaction fails.

The server-based database we use uses Structured Query Language (SQL) servers to perform security and transactions. SQL Server provides efficient access to database files for client computers. SQL is a relational database management system for building business applications with more advanced data protection. SQL server is like an engine that improves data access and data transfer performance from server to workstation (www.microsoft.com). SQL Server has many security vulnerabilities that require ongoing patch application. If the system administrator does not patch the server, potential worms, viruses, or hackers may access the data. Server If you are not using a third-party security systems such as firewalls and anti-virus software, there is a possibility that the department information is finally infringement.