Wednesday, April 27, 2011

Introduction to SQL Server 2008

 

Hi again,

I’m Mohamed Adel Microsoft Middle East and Africa Data Platform Developer and I'll write a series of blog posts about SQL Server 2008 R2, hope you enjoy this series.

  • Introduction to SQL Server 2008 R2

 

SQL Server Storage:

-524272 TB per DB

-32767 concurrent user connections

-32757 Databases on a server

-up to 2147483647 tables per database

-1024 columns per table

 

SQL Server Versions and history:

-Microsoft and IBM are the first to start The data base development concept @1989

-1998 MS OLAP TOOLS

-2000 SQL Server 2000 (8.0)

-9.0 SQL Server 2005

-10.0 SQL Server 2008

-Virtual Box (SUN Virtual Machine)

 

SQL Server Editions:

 

1-Core Editions (Standard & Enterprise)

 

a- Standard

-Small to large business

-Up to 4 CPU

-Max OS Ram

b-Enterprise

-Enterprise Workloads and BI

-CPU and raM limited by OS

 


2-Specialized Editions

 

a-Workgroup:

-Remote offices
-2 CPU Max
-4 GB Ram MAX

b-Web

-Web application hosting

-4 CPU's MAX

-OS MAX RAM

c-Developer

-licensed for development and testing only
-OS MAX CPUs
-OS MAX RAMs

 


3-Free Editions

 

a-Express Edition:

-Entry level for learning

-1 CPU MAX

-1 GB MAX RAM

-4 GB MAX Database SIZE

b-Compact 3.5

-embedded database for developing desktop and mobile apps
-OS MAX CPUs
-OS Max RAMs

 
 
  For More Info Please Visit: SQL Server 2008 R2 Introduction  

Search This Blog