Tag sql 2008

So this conversation came up the other day, basically, “Hey, isn’t there a way to convert Std to Ent in one command?” Some might say, “No, you must re-install of your hosts and as part of that rebuild process I will charge you 1 million dollars in Consulting! MUAHHAHAHA!” But, no. The answer is. YES YOU CAN!   And so I don’t have to go hunting to find this at some point in the future… here is all the citing evidence to refer back to ;)

Thanks to our dear friend,  Jim Millard @millardjk – It’s as easy as seen in this tweet!

     Dism /online /set-edition:ServerEnterprise /product key:<KMS key>

But to cite some additional information, in case we need to troubleshoot something or we don’t fully understand WTF that means!  These additional articles can help out as well!

• Change Windows Server from Standard to Enterprise Edition
• SQL Server 2008: Upgrading to Standard/Enterprise Edition from Evaluation Edition
• Upgrade Windows Server 2008 R2 standard to Enterprise

While this may not be the most authoritative source on the subject… if it solves for your problem, then BAM! And if not… well, we can track down those other scenarios! Unfortunately… I don’t have any Std versions to actually need to upgrade to Ent at the moment to screenshot through! But hopefully you find this useful.. eventually when I’m in that situation needing to use the cmd, I’ll look back upon this and give this a whirl! :) Enjoy!

Another verbatim theft from Beta Blog!

You are invited to take beta exam 71-433: TS: Microsoft SQL Server 2008, Database Development. If you pass the beta exam, the exam credit will be added to your transcript and you will not need to take the exam in its released form. The results will not appear on your transcript until several weeks after the final form of the exam is released. The 71-xxx identifier is used for registering for beta versions of MCP exams, when the exam is released in its final form the 70-xxx identifier is used for registration.

71-433: TS: Microsoft SQL Server 2008, Database Development counts as credit towards the following certification(s).

· Microsoft Certified Technology Specialist: SQL Server 2008, Database Development (earned when passing 70-433)

· Microsoft Certified IT Professional: Database Developer 2008. In order to earn this certification you must also pass exam 70-451: PRO: Microsoft SQL Server 2008, Designing and Optimizing Database Solutions.

Find exam preparation information: http://www.microsoft.com/learning/exams/70-433.mspx

Availability

Registration begins: September 19, 2008

Beta exam period runs: September 22, 2008– October 10, 2008

Receiving this invitation does not guarantee you a seat in the beta; we recommend that you register immediately. Beta exams have limited availability and are operated under a first-come-first-served basis. Once all beta slots are filled, no additional seats will be offered.

Testing is held at Prometric testing centers worldwide, although this exam may not be available in all countries (see Regional Restrictions). All testing centers will have the capability to offer this exam in its live version.

Regional Restrictions: India, Pakistan, China

Registration Information

Please use the following promotional code when registering for the exam: F589G
You must register at least 24 hours prior to taking the exam.

To register in North America, please call:

· Prometric: (800) 755-EXAM (800-755-3926)

Outside the U.S./Canada, please contact:

· Prometric: http://www.register.prometric.com/ClientInformation.asp

Test Information and Support

You are invited to take this beta exam at no charge.
You will be given four hours to complete the beta exam. Please plan accordingly.

The word is out!

It’s official! SQL Server 2008 has gone RTM!

And I expect in short-order a full support for SQL 2008 with SMSQL – as things are certainly inline with this paper published in February of this year:

MICROSOFT SQL SERVER 2008:

DECISION SUPPORT WORKLOADS -1TB DATA WAREHOUSE ON IA64

So, coming soon to a test lab near me (at home) I’ll be upgrading to SQL 2008 with RTM, instead of the RC0 release I’ve been running!

Good luck upgrading, planning and sizing your environments!

Fairly straight to the point – SQL 2008 Beta exams until July 31st!
These beta exams are for 71-432 (70-432) and 71-448 (70-448)

TS: Microsoft SQL Server 2008, Implementation and Maintenance
http://www.microsoft.com/learning/en/us/exams/70-432.mspx

TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
http://www.microsoft.com/learning/en/us/exams/70-448.mspx

71-432 – Promotion code: 943F6
71-448 – Promotion Code: B6543

Beta available until July 31st

Thanks GerryO!