Installing Sql Server (SQL)

Installing SqlServer

When we want to install the sql server software on a machine.First we need to analyze the information related with the version .we want to install and the edition.we want to install.

Note : Generally while choosing the version .we prefer the most latest version available int the market as of know the current version of sql server is sql server is 2016

Comming to the editions of the sql server it is available in Multiple editions with different features targeting different users.Those Editions are

1) Database

   Sql server 2008 R2 is the full future edition of sql server and is designed for datacenter that need high levels of applications support.This edition has been retired in sql server 2012 and all its features are available in sql sql server 2012 Enterprise edition.

2) EnterPrise

   This edtion includes both the core data base engine and add-on services with a range of tools for managing sql server database.It can manage databases as large as 524 petabytes and address 2 terabytes of memory and supportes 160 physical processors from sql server 2012 edition.

3) Standard

This Edition includes the core databse engine,along with stand alone services.It differs from enterprise edition in that some high availablility functions sush as Hot add memory(allowing memory to be added while the server is still runing),and parallel indexes
  web : This edition is an option available for web hostiing


4) Business Intelligence

   Introduced in sql server 2012,Focusing on self service and coperate business intelligence.it includes all the standard edition capabilities and business intelligence tools.

   i)Workgroup

        This edition includes the core database functionality but doesnot include any editional services .This edition has also been retired in sql server 2012.

   ii)Express
     

  1.       This edition is a scaled down.free edition of sql server,which includes the core databse engine only while there are no limitations on the number of databases or users supported.It is limited to using one processor and 1 GB memory and 10 gb datafiles from sql serer express 2008 R2.
  2.       Two additional editions provide a supper set of features not in the original express edition.The First is sql server express with tools.which includes sql server management studio basic and second is sql server express with advanced services that adds full text search capbility and reporting services.


About Author: author 4 + years of Information Technology experience in understanding and analyzing the software and hardware engineering requirements, onsite and offshore management of product development. Expert work on design and development for windows,web,mobile Expert knowledge of C#,ADO.NET, ASP.Net MVC, ENTITY FRAMEWORK, LINQ,COLLECTIONS, JAVASCRIPT,AngularJs 1.0,Angular2, Jquery,Jquery-Ajax, SQL SERVER, XAML,Windows phone 8.1 Good knowledge of WCF-Restful services,WCF, WEB API-Services ,Web- Services,MIcrosoft-Azure,JUICE UI,HTML,CSS,AJAX Read More...

Join him on Google+ | Facebook | Linkedin

No comments