Relational Database Management System: MS SQL Server

Microsoft SQL server is a relational database management system developed by Microsoft to enterprise environment. It runs on Transact SQL. This is a Sybase and Microsoft set of programming extensions that incorporate several entities to the standard SQL, such as exception and error handing, transaction control, declared variables and row processing.

Yukon is the code in development, SQL server 2005 was came into market in late 2005. These version facilities enhanced scalability, security, flexibility and reliability to the database applications, making creation and deployment very easy. This feature minimizes database management tedium and complexity I addition to many support for administration (Bernstein, 66).

The initial SQL server code was designed and developed by Sybase, in 1980s, Sybase, Microsoft and Ashton-Tate collaborated to come up with the first version of SQL server relational database named SQL Server 4.2 for OS/2. Subsequently, Microsoft and Sybase distribute the products of SQL server. And Sybase eventually changed the name of their product to Adaptive Server Enterprises.

The following table gives the details of hardware and software requirements for different SQL server editions:

EDITIONS HARDWARE REQUIRED

SQL Server 2016 Memory-Minimum: Express Editions: 512 MB, All other editions: 1 GB; Recommended: Express Editions: 1 GB

Other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.

Processor Speed: Minimum: x64 Processor: 1.4 GHz, Recommended: 2.0 GHz or faster

Processor Type: x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support

SQL Server 2014 Memory: Minimum: Express Editions: 512 MB, All other editions: 1 GB

Recommended: Express Editions: 1 GB

All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.

Processor speed: Minimum: x86 Processor: 1.0 GHz,

x64 Processor: 1.4 GHz

Recommended: 2.0 GHz or faster

Processor type: x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support

x86 Processor: Pentium III-compatible processor or faster

SQL Server 2012 Memory: Minimum: Express Editions: 512 MB, All other editions: 1 GB

Recommended: Express Editions: 1 GB All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance

Processor speed: Minimum:

x86 Processor: 1.0 GHz

x64 Processor: 1.4 GHz

Recommended: 2.0 GHz or faster

Processor type: x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support

x86 Processor: Pentium III-compatible processor or faster

SQL Server 2008 R2 Microsoft demands that a minimum of 1 GB amount of memory required. 256 MB to 512 MB for SQL Server Express and ranges.

4 GB of memory

SQL Server 2008 A CD or DVD drive that is capable of reading the SQL Server installation media

A video card and monitor with a resolution of 1024 x 768 or above

A mouse or other pointing device

Microsoft demands that a minimum of 1 GB amount of memory required. 256 MB to 512 MB for SQL Server Express and ranges.

4 GB of memory

SQL Server 2005 Processor type1: IA64 minimum: Itanium processor or higher

x64 minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support

Processor speed2: IA64 minimum: 1 GHz,IA64 recommended: 1 GHz or more, x64 minimum: 1 GHz x64

recommended: 1 GHz or more

Memory (RAM)3: IA64 minimum: 512 MB, IA64 recommended: 1 GB or more, IA64 maximum: 32 TB, Operating system maximum

Minimum:512 MB, x64 recommended: 1 GB or morex64 maximum: Operating system maximum

SQL Server 7.0 Computer: DEC Alpha AXP and compatible systems, or Intel or compatible (Pentium 166 MHz or higher, Pentium PRO, or Pentium II)

Memory: 32 MB of RAM

Disk Drive: A CD-ROM drive.

At least 80 MB of free disk space for a minimal installation.

Microsoft SQL server provides appropriate edition that meets the clients business needs, such as enterprise suitable for mission critical applications, business intelligence that is good for corporate and self-service business intelligence, data warehousing and data warehousing and standard, which is used for basic database, analytic and reporting capabilities.

The standard edition facilitates principle data management and business intelligence. It can be deployed to server non-critical workload by institution with minimal information technology resources. In addition, it provides security, scalability, performance and availability.

The enterprise edition provides premium services that deliver detailed high-end datacenter features for business intelligence and demanding database requirements. It enables the company that has deployed to achieve faster failover, greater uptime, better hardware utilization and greater uptime via guaranteed availability. When it is on, it facilitates maximum of four active readable secondaries, high online operation capability and a detailed dashboard that enables the user t achiever high availability (Agrawal, 77-79).

The business intelligence edition provides a detailed platform that empowers organizations to create and deploy scalable, secure and manageable business intelligence solution. It facilitates rapid data visualization and exploration enabling the user to realize new insight of the power view speed of thought, browser based data exploration, visualization and ever presence experience. The power pivot assists the users to get and mash-up data from virtually all sources. It also users familiar tools to obtain big data.

The express edition utilizes the benefits of similar powerful database engine in a model tailored for embedding and redistribution. It has 10GB of memory per database, simple backup and restore to the functionalities of Microsoft azure, and it has compatibility features of all the SQL server editions and Microsoft azure SQL database so that the user can create and deploy the database with confidence (Hamilton, 345).

When deploying the SQL server in the internet, one does not need additional products to be installed or other tools to configure SQL server for web deployment. Assuming that the web server and the database server is running in different computers, you simply need to follow the following steps:

Allow the SQL server to communicate through TCP/IP

Disable all the firewalls

Name the web server computer account for SQL server login

Create a mapping between the required database and the machine account login

Provide the account that will run the deployment as SQL server login database creator allowance.

Map the deployment account login to the db-owner database role to facilitate repeated deployment support.

Work cited

Agrawal, Sanjay, et al. "Database tuning advisor for microsoft SQL server 2005: demo." Proceedings of the 2005 ACM SIGMOD international conference on Management of data. ACM, 2005.

Bernstein, Philip A., et al. "Adapting microsoft SQL server for cloud computing." Data Engineering (ICDE), 2011 IEEE 27th International Conference on. IEEE, 2011.

MacLennan, Jamie, ZhaoHui Tang, and Bogdan Crivat. Data mining with Microsoft SQL server 2008. John Wiley & Sons, 2011.

Hamilton, James R., and Tapas K. Nayak. "Microsoft SQL server full-text search." IEEE Data Eng. Bull. 24.4 (2001): 7-10.