Tuesday, 11 June 2013

SQL Server Editions

SQL Server Editions and Service Pack information

History

This is basic information of MS SQL Server 2012, 2008 R2, 2008, 2005, 2000, 7.0, 6.5 that have been released.
SQL Server is the product of Microsoft. We will have a look in brief description
More new features introduced in SQL Server 2005 version and vast improvement.
T-SQL (Transaction SQL) enhancements
CLR (Common Language Runtime)
Service Broker
Data encryption
HTTP endpoints
Multiple Active Result Sets (MARS)
SQL Server Integration Services (SSIS)
Database mirroring
Snapshot isolation                    ….going back to Product versions


below following table as a reference for SQL versions.
Version pattern
SQL Product
11.0.x.x
SQL Server 2012
10.5.x.x
SQL Server 2008 R2
10.00.x.x
SQL Server 2008
9.00.x.x
SQL Server 2005
8.00.x.x
SQL Server 2000
7.00.x.x
SQL Server 7.0
6.5.x.x
SQL Server 6.5

History of Editions

Installation requirements based on your application needs. The different editions of SQL Server accommodate the performance, runtime, and price requirements of corporate organizations and small company. The SQL Server components that you install also depend on your specific requirements.
The following sections help you understand how to make the best choice among the editions and components available in SQL Server....
SQL Server 2000 Enterprise Edition
SQL Server 2000 Developer Edition
SQL Server 2000 Standard Edition
SQL Server 2000 Personal Edition
SQL Server 2000 Windows CE Edition
SQL Server 2000 Enterprise Evaluation Edition(Trail Version)


Enterprise Edition

Used as a production database server. Supports all features available and scales to the performance levels required to support the largest Web sites and enterprise online transaction processing (OLTP) and data warehousing systems. It’s Expensive comparing to all SQL Server versions.
Developer Edition
Used by programmers developing applications that uses SQL Server212 as their data store. Although the Developer Edition supports all the features of the Enterprise Edition that allow developers to write and test applications that can use the features, The Developer Edition is licensed for use only as a development and test system, not a production server.

Standard Edition
Standard Edition for Small Business includes all of the technical components and capabilities and is licensed to operate in a small scale environment
Personal Edition
Used by mobile users who spend some of their time disconnected from the network but run applications that require SQL Server data storage. Also used when running a stand-alone application that requires local SQL Server data storage on a client computer.
Windows CE Edition
SQL Server CE is used as the data store on Windows CE devices. Capable of replicating data with any edition of SQL Server 2000 to keep Windows CE data synchronized with the primary database.
Enterprise Evaluation Edition
Full-featured version available by a free download from the Web. Intended only for use in evaluating the features of SQL Server; this version will expires after 120 days after downloading.


SQL Server 2005 Editions

SQL Server 2005 Enterprise Edition
SQL Server 2005 Developer Edition
SQL Server 2005 Standard Edition
SQL Server 2005 Work Group Edition
SQL Server 2005 Express Edition
SQL Server 2005 Express Edition with advanced Services


About all versions we discussed on above the document. we will have a look with work group and Express edition.


Express Edition

SQL Server Express or SQL Server Express with Advanced Services are having very limited features. SQL agent won’t available. Moreover it’s a Free Edition.


Work Group Edition

SQL Server Workgroup is ideal for running branch location databases providing a reliable data management. Useful for any small type of organization.

SQL Server 2008 Editions

SQL Server 2008 Enterprise Edition
SQL Server 2008 Developer Edition
SQL Server 2008 Standard Edition
SQL Server 2008 Work Group Edition
SQL Server 2008 Web Edition
SQL Server 2008 Express Edition
SQL Server 2008 Express Edition with advanced Services
SQL Server 2008 Compact Edition

Enterprise is available in SQL Server 2008 Enterprise Evaluation for a 180-day trial

About all versions we discussed on above the document.

SQL Server 2008 Web Edition

Web Edition is a low total-cost-of-ownership option for Web hosts and Web sites that provide scalability and manageability capabilities for small to large scale Web properties.
SQL Server 2008 Compact Edition
Compact Edition is a free version, embedded database ideal for building stand-alone and occasionally connected applications for mobile devices, desktops, and Web clients on all Windows environments.

SQL Server 2012 Editions

SQL Server 2012 Enterprise Edition
SQL Server 2012 Business Intelligence Edition New
SQL Server 2012 Standard Edition
SQL Server 2012 Web Edition
SQL Server 2012 Developer Edition
SQL Server 2012 Express Edition

Service Pack Summary and Code names


SQL Server 
codename
RTM (No SP)
SP1
SP2
SP3
SP4
SQL Server 2012
   
Denali
11.00.XX.XX
11.00.XX..



SQL Server 2008 R2
Kilimanjaro
10.50.XX.XX


SQL Server 2008
Katmai
10.00.XX..

SQL Server 2005
Yukon
9.00.XX..
SQL Server 2000
    
Shiloh 32-Bit
Liberty 64-Bit
8.00.XX.
SQL Server 7.0
Sphinx
7.00.XX..
 SQL Server 6.5
Hydra
6.5.XX..
6.50.XX
6.50.XX

Determine the version of SQL Server

Method 1:-

SQL Server Management Studio (SSMS)

To determine the version of the client tools that are installed on your system, start Management Studio, and then click About on the Help menu.


Method 2:-
Look at the first few lines of the Errorlog file for that instance. By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.


Method 3:- Connect to the instance of SQL Server, and then run the following query:
Select @@version



Method 4:- run the following query on SSMS query builder:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')


These are the versions and editions about sql server .                Happy Reading

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts