Where Can I Get A Copy Of SQL Server Developer R2 Edition ?
I was given a copy of the SQL Server 2008 Developer Edition b y a friend who no longer needs it . I have not installed it as yet by the way , so I am assuming that the product key is pre-installed . The online video training I have access to is for the R2 Version, so my question are : 1) How can I get a copy of the R2 Version ? 2)Additionally is there a way to upgrade to the R2 Version in the Developer Edition? I have seen some blogs with info on upgrading but they are usually the Standard or Enterprise versions. 3)As I am a Newbie, obviously, can I just go ahead and begin the training using the version I have now after I have installed it or will there be some deficiencies in my learning from the very beginning , which by the way does also include how to do an install ?
In terms of your training (and you said you are a Newbie, so I'm guessing it is basic TSQL and general database design), you'll probably find that most of what is covered in the training material is relevant to both 2008 and 2008R2. In the 'official' world of Microsoft learning, there's no distinction between the two, and the only certification you could get prior to the SQL2012 ones where SQL2008, not R2. The majority of changes from 2008 to 2008R2 came in the BI side of the product, plus a few features moved down from Enterprise to Standard - but with Developer Edition you get the full Enterprise-level feature set anyway. Keep looking out for a Dev edition of R2 - eBay, Amazon and others allow sellers to sell their old items. So I say, start the training, don't worry about it, but keep your eye open for a cheap (less than $40) copy of R2 Dev.
I don't think you can buy an upgrade but you can buy the 2008R2 Developer Edition for around £40 from software resellers. (Strangely not from the Microsoft online store.) Whether you need the R2 upgrade depends on what material your training course covers.
For training purposes you will find very little difference in 2008 and 2008R2. there are some new DMVs, functions, etc in R2 but as a newbie, the basics you will be learning probably won't cross over into any new R2 features. Depending on the level of the training you could very well get away with 2008R2 Express Edition as well. However to get 2008R2, Amazon, CDW, Newegg, etc all have them available for under $50 or so. Best of luck and welcome to the world of Microsoft SQL Server. Might I also suggest you take a look at [SQL PASS](