:::: MENU ::::

Posts Categorized / SQL Server versions and editions

  • Feb 10 / 2015
  • 0
DBA Interview questions, dbDigger, SQL Server Training, SQL Server versions and editions

SQL Server versions, editions, service packs, OS and deployment

Like other Microsoft technologies SQL Server follows the categorization of versions and editions. Updates are applied mainly through service packs and patches that are released by Microsoft for each version. Understanding of these concepts is important for DBAs as they have to make use of this information for deployment, upgrades and proposals. It is better for beginner level DBAs to explore this information prior to work on these during their jobs.

Click here to download presentation on this topic.

  • Dec 14 / 2011
  • 0
DBA Interview questions, dbDigger, Deployment, SQL Server Training, SQL Server versions and editions, Windows Server

SQL Server editions and Windows platform

Each of SQL Server release like SQL Server 2000, SQL Server 2005 and SQL Server 2008 is further categorized in editions based on their features and capabilities. For example, edition of a specific release may be any of following

  • Data center edition
  • Enterprise edition
  • Standard edition
  • Developer edition
  • Express edition
  • Apart from these there may be some other editions like run time edition or web edition. Some editions like Data center edition or enterprise edition can only be installed on Server OS while others may be installed on both server or client OS.
    For windows platform the term Server OS refers to different editions of

  • Windows server 2000
  • Windows server 2003
  • Windows server 2008
  • Windows server 2008 R2
  • While for windows platform, client OS would be any edition of following

  • Windows 2000
  • Windows XP
  • Windows vista
  • Windows 7
  • So while installing any SQL Server version, do consult the requirements related to OS.

    Consult us to explore the Databases. Contact us