From the course: SQL Server 2008 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

SQL Server editions

SQL Server editions - SQL Server Tutorial

From the course: SQL Server 2008 Essential Training

Start my 1-month free trial

SQL Server editions

In this course, we're going to work with Microsoft SQL Server 2008 R2. This is the latest version of SQL Server, released in April 2010. R2 added several features on top of the first release of SQL Server 2008, although the purposes of an Essential Training course like this, the R2 part really doesn't matter. In fact, most of the core things we're going to talk about are very similar to even earlier versions like SQL Server 2005. But SQL Server 2008 R2 is the latest version. It's what we're going to use. Now although, SQL Server 2008 R2 is the version that we're using, the capabilities of it will differ depending on the edition of SQL Server 2008 R2 that you have, because this product has been around for 20 years. The same way that Microsoft Office is now available in different editions, SQL Server has fragmented into about ten editions with different feature sets for different audiences. So there is a Compact edition for mobile devices. There is a Web edition specific for making web…

Contents