Sql Server 2012 Introduction

Sql Server 2012

Introduction:

 These instructions are used by everyone. If you need any help so contact me “https://www.facebook.com/bilal.fareed1”. In this blog we discuss sql server editions with its requirements.

SQL Server offer different edition to support various need and options.
Choosing the correct version is critical to ensuring the installed database engine and supporting tools will meet your needs. We discussed in blow about different versions if SQL Server 2012

               1.      SQL Server Express Edition
         2.      SQL Server Developer Edition
         3.      SQL Server Standard Edition
         4.      SQL Server Business Intelligence (BI) Edition
         5.      SQL Server Enterprise Edition

Hardware Requirements:

Microsoft gave the minimum requirements for installation of SQL Server.

  Screen Resolution (800 X 600 or higher)

Processor (x86 version require at least 1.0 GHz, x64 version require at least 1.4 GHz, 2.0 Ghz or faster recommended)

Hard disk Space (6 GB ) is depends on the components installation.

RAM (Recommended: 1 GB for Express Edition and at least 4 GB for other Edition and this is increase if your DB sizes increase)

      1)      SQL Server Express Edition

SQL Server Express Edition in a entry level version for learning about SQL Server.

SOFTWARE Requirements:

            Windows 7 SP1 (Pro, Ultimate)

Windows Vista SP, 64-bit (Business, Enterprise, Ultimate)

Windows Server 2008 SP2 + 64-bit(Datacenter, Fundation)

.Net Framework 3.5 SP1 or later

      2)      SQL Server Developer Edition

SQL Server Developer Edition in a entry level version for learning about SQL Server. Only Licensed for development and testing Purposes. Not licensed for Production  use.

SOFTWARE Requirements:

            Windows 7 SP1 (Pro, Ultimate)

Windows Vista SP, 64-bit (Business, Enterprise, Ultimate)

Windows Server 2008 SP2 + 64-bit(Datacenter, Fundation)

.Net Framework 3.5 SP1 or later

      3)      SQL Server Standard Edition

Intended for smaller-scale deployments

Data management and BI functionality

The right choice for a small business.

SOFTWARE Requirements:

            Windows 7 SP1 (Pro, Ultimate)

Windows Vista SP, 64-bit (Business, Enterprise, Ultimate)

Windows Server 2008 SP2 + 64-bit(Datacenter, Fundation)

.Net Framework 3.5 SP1 or later

      4)      SQL Server Business Intelligence (BI) Edition

This is new Edition in SQL Server

Provide Business Intelligence functionality to organizations

Provides data discovery with power View, reporting, analytics, Data Quality Services, Master Data Services and All the features of standard Edition.

SOFTWARE Requirements:

            Windows Server 2008 SP2

            Server 2008 R2 SP2, 64-bit

.Net Framework 3.5 SP1 or later

      5)      SQL Server Enterprise Edition

Mission critical, data warehousing installation

Provides high-availability, high performance and large scale data warehousing

SOFTWARE Requirements:

            Windows Server 2008 SP2

            Server 2008 R2 SP2, 64-bit

.Net Framework 3.5 SP1 or later