Showing posts with label R2. Show all posts
Showing posts with label R2. Show all posts

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  

Managing Hallucinations & Trust in Generative AI

  When AI Speaks Too Confidently Generative AI dazzles with its fluency, but sometimes it invents facts with absolute conviction. These “hal...