SQL Server 2012 RC0 on Windows 8

Today I got some leisure time and thought of Installing SQL 2012 on my Win8 machine and sharing my experiences at a very high level. Well,  I’ve Installed SQL Server 2012 RC0 on my Windows 8(Consumer Preview – Evaluation Copy, Build 8250) Machine.

To be honest, I was expecting few bugs and annoying errors. But let me tell you this, My Installation went Flawless. FYI, I’ve Installed only basic components(DB Engine – with Replication, SSIS,Complete Client Tools, SDK Connectivity).

Just a screenshot of how it looks like on Win8. Well, Technically there is no difference in how SSMS looks and how it behaves, but as most of you are already aware of…there is no START Button on my Menu bar on my Desktop! See below on the bottom Left corner.

So, where did I open SSMS from?? If you said “Metro Screen” yes, you are correct. See the below Screenshot for how Windows8 organized programs on my Metro Screen.

Hmm…this is something which really disappointed me. Basically, It created bunch of Apps for each exe! Imagine how ugly your Metro Screen gets if you Install all the components of SQL Server!! I Wish it was smart enough to create at least folders/Groups and place related exe’s accordingly.

Btw, if you want to Run SSMS as Admin, just right click on the App and you will see the available options in the bottom of your Screen as shown below. ( This applies to all the Executables)

Advertisements

Installing Windows8 with Dual Boot Option

Hey……!All excited to let you guys know that at laaaaast I was able to Install Windows 8 in my Laptop 🙂 Huhuuuuuuuu. Thought of sharing my experiences with getting this done!

How to Install Windows8 with Dual Boot Option?

Before jumping into actual content, let me tell you guys difficulties I had when i was trying to Install on Virtual Machine(s).

My Laptop Hardware Specs(in brief):

Windows 7 X64, Intel CPU with No VT(Virtualization Technology), Harddrive which already had 4 partitions which is the maximum limit for mine 😦

Initially, I thought of Installing Windows 8 on a Virtual Machine. I started with VMware WorkStation(Version 7.x) which i was continuously getting BSOD(Blue Screen of Death) no matter what options I tweak while installing Windows8.

I gave up and tried downloading Oracle Virtual Box. Annoyingly I was not getting BSOD but, all kinds of other CPU related Errors :(. I Guess this is because my CPU doesn’t support Virtualization Technology. PS, even if your CPU supports VT, it will be disabled by Default in most of the laptops and you’ve to manually enable that feature from BIOS Settings.

If you are using Intel CPU, to identify whether your CPU is VT compatible or not, you can make use of “Intel Processor Identification Utility“.  Or you can use one of my favorite tool called CPUZ. CPUZ is vendor independent.  See the below Screenshot of Intel’s Util.

Basically I lost hopes on Installing Windows 8 on a virtual machine and i had to Install on my Laptop. Here we’ve two Options

1. Overwriting Windows 7( which I don’t recommend)

2. Installing Windows8 on a separate partition with Dual boot Option(in other words, you will be having both Windows 7 and Windows8; you’ll be given an option to choose either OS while you boot your machine. 

Let’s see what I did to make this happen!

Step1:

Created a separate partition from Disk Management(named it as Win8). How to create a new partition in Windows?Right Click on My Computer – >Manage->Disk Management. Right Click on Shrink Volume and choose the required Size in the next screen and click on “SHRINK” button. It will create un-allocated space. Now Right Click on “Un allocated Space” and select “create a Simple Volume” and Choose NTFS as File System,Choose Quick Format, Choose a Drive letter, Name the Volume and You can leave the rest to defaults.  You can see below Screenshot in my laptop.

As you can see I took the above Screenshot from Windows8:)

Step2:

You’ve to download Windows 8 ISO file(Windows is providing X86 and X64 versions). Choose accordingly.

Step3:

Download Windows7 USB DVD Download Tool, for creating a bootable USB or DVD from the above ISO. How to create a Bootable USB Device? You can simply follow the below Screen shots once you are done with Installing the tool.

I’ve inserted a USB drive instead of a DVD. PS your USB device will be formatted.

Step4:

We are all set with pre-requisites! Now, Plug in your USB Stick and Restart your Computer and change your Boot Priority to USB(or DVD) device first, or You can choose Select Boot Device Option(If you’ve it) when you restart your Computer.

Step5:

Once you boot your machine via USB or DVD which you prepared in the above steps, You’ll be welcomed with the brand new Windows 8 Installation Center.  Here you’ve to choose your Language, TimeZone and Keyboard Settings as shown below.

In the Next Screen, You’ll be seeing two Options a) Upgrade b) Custom(Advanced). Since we are doing Dual boot, you’ve to select option b(Custom). Now you’ve to select the Partition(not the C Drive) which we’ve created earlier and decided to dedicate to Windows8 and hit next.

That’s it…..You are all set:) Your Installation will be done with couple of Next Next Buttons! It’ll ask for few personalization settings at the end of setup. If you see any errors, in the last step, probably your ISO file is corrupted, you’ve to download a fresh copy from scratch.

From next time On….you’ll be welcomed with two Options(Windows Vista/7 and Windows8) to choose each time you reboot your machine!

I’m having lot of Fun playing with Windows 8. Try it yourself and feel the difference 🙂