Restoring Windows 7 after an oopsie

I have a RAID10 and 2 other hard drives installed on my PC. I was trying to format one of non-RAID HDD but it wouldn’t let me in Windows. So I booted off of the Windows 7 DVD and formatted it that way. I didn’t continue the installation after I formatted the HDD. I made sure I selected the right HDD. I restarted and kept getting the missing bootmgr message like the one below.

bootmgr

The joys of Windows. I guess it’s what I get for messing around with it too much. But I accepted the challenge. Here’s what I did. I recently purchased a Kingston SSD drive which came with an Arconis software to clone HDDs and partitions. I know the data is still in my RAID array, the bootmgr is just messed up and won’t boot that drive. I tried to restore by booting off the Windows 7 disc. Unfortunately, because it’s a RAID, it doesn’t recognize it. I can load the drivers but I only have 1 optical drive on this PC and it already has the Windows 7 in there.

So I ended up cloning the contents in the RAID onto one of the HDD. I booted of the Windows 7 disc again and I was able to restore the bootmgr. This was possible because the HDD wasn’t in a RAID array and is just a regular drive. So with a working Windows 7 installed on the non-RAID, I cloned it again but back to the RAID10 array. I unplugged the other drive and rebooted. Everything is back to normal. I didn’t have any back ups yet because I was trying to prepare those drives when this happened.

Conclusion: Make sure you have a software that can clone or back up. It’s very helpful. The Arconis True Image software is great. Saved me today from re-doing my Windows machine.

New PC built

I’m beginning to feel limited while using Apple products. Don’t get me wrong, it’s a great platform. But as I start introducing non-Apple devices, I have to go out of my way to get it to work. I started looking into building a PC after 8 years of exclusively using Macs. At first I had my eyes set on an i7 Sandy Bridge but after doing more research and talking with experts, I decided to go with the last generation i7 (LGA1366, Bloomfield). Why?

  • More motherboards available
  • Supports faster memory – DDR31600
  • If I ever want to switch out CPU to the hexacore, I don’t have to switch out motherboards
  • X58 is a great platform and more stable

It’s been almost a week and I’ve been impressed by some of the tests I’m running. I will go part by part and tell you what I liked and disliked (if applicable).

Corsair Graphite 600T: I decided to spend the extra money getting this tower for several reasons.

  • I can run the cables in the back side of the tower. There’s plenty of room there.
  • It is truly tool-less.
  • Can hold 7 hard drives. It can be reconfigured and move around depending on how you want your airflow to work.
  • Removable dust filters.
  • Great quality and durable.
  • Bottom mounted PSU for liquid cooling solution.

So far, the only thing I don’t like is it doesn’t have a 3.5” slot. I don’t use a floppy drive but most internal memory card readers use this slot. Now I have not only buy the memory card reader but an adapter to make it fit in the 5.25” slot.

Gigabyte GA-X58A-UD3: I was going to get the ASUS Sabertooth but the Gigabyte has dual bios where if one were to fail to load, I can use the other and fix the issue.

  • 3 different raid controllers. 6 Intel (SATAII 3Gbps), 2 Gigabyte (SATAII 3Gbps), and 2 Marvell (SATAIII 6Gbps)
  • Supports triple channel ram up to 24GB
  • Software to OC is easy to use

One thing I don’t like is it doesn’t have an internal USB port. The front of my tower has a USB3.0 and uses the standard cable. In order for me to use it, I’d have to run the cable to the back of the tower and plug it in.

Intel i7 960 3.2GHz: Currently the fastest processor before going into the extreme hexacore CPU. I have seen people OC this over 4.0GHz so it has great potential. This is a quad core CPU and with Hyper Threading, it becomes 8 cores. I was considering the AMD Phenom II 1100T Black Edition but the benchmarks I’ve seen online were not impressive. Based on those benchmarks, it runs against the Intel i5 Sandy Bridge – not the i7.

Corsair Vengeance 12GB DDR31600: I was going to get a 6GB set but decided to go with the 12GB so that I can max it out in the future. It has XMP and all I needed to do in the BIOS is to set it to Profile 1. Comes with a heat spreader as well. It has a CAS Latency of 9 but seen it run at 8 when OC.

Seagate ST3500641AS: Seagate makes great drives and since I’ve started to use them, I haven’t had one go bad yet (knock on wood). Drives that have died on me are usually Maxtors and Western Digitals. These drives have a 16MB cache and runs at 7200RPM. I bought 4 of these 500GB hard drives and set them up as a RAID10. They run great and  my Windows gives it a score of 6.1.

Corsair CMPSU-850TX: I figured 850W should give me enough for current any future mods. Supports SLI and Crossfire. It’s rated at 80Bronze. The only thing I don’t like is it doesn’t support the new ATX v2.3. Corsair just came out with the second version of the PSU. I could’ve waited but I didn’t want to. I figured the changes were not important for my set up and use.

Corsair CWCH70: I could’ve use the stock heatsink that came with my i7 but would need an aftermarket one if I decide to OC it. Rather than figure this out later, I bought it so it’s ready for OC. The install was not as easy as the videos I’ve seen on Youtube. Once installed, I get around 40-52 C on idle or normal use. When doing transcoding (high CPU usage) I don’t go over 65 C. Spending the extra $80 (after rebate) is worth it. It’s compact unlike the first versions of liquid cooling solutions.

EVGA nVidia GTX470SC: It’s not the high end video card in the series but works great. It has CUDA and works great with Adobe software. I have already used Adobe Premiere Elements 9 and exported an HD video to 1080i, 25fps. At the same time, I played Starcraft 2 on ultra settings. The computer remained stable and responsive. I was very impressed. All 8 cores were at 100% and ran around 52-65 C and the video card ran at around 84 C. Starcraft 2 was running at about 52-58FPS. I was able to ALT+Tab between applications, play HD videos off Youtube and watch an HD video off my hard drive.

Microsoft Windows 7 Professional 64-bit OEM: One of the best, if not the best OS Windows has “created”. I find the 64-bit to be more stable than 32-bit and with 12GB of ram, it’s necessary. I still miss things on OS X but there are things on Windows that don’t exist in my Apple. I love Live Writer. I can blog from my desktop. I wish Apple would create something that works similarly. The built-in Backup/Restore is still unreliable. I’ve had failed backups and failed restores. I decided to keep my iMac and run it side by side. My iMac will contain all of my important documents and use Time Machine to back up. Hopefully one day there will be a back up software/workflow as easy as Time Machine for Windows.

Whoever says using Windows is cheaper than a Mac is wrong. I have spent about the same price building this PC rather than purchasing a new Mac. I have already spent close to $300 on just software, where similar software is unnecessary or already included with a Mac. The hardware cost is about $1500. Unlike my Apple products though, I can switch out parts. To make this possible with Apple hardware, you’d have to purchase a Mac Pro which starts at $2400 and you are still limited to hardware that’s compatible. Regardless, I would have to use both in order to do everything I need to do. I just wish software licenses are easily transferable for both platforms.

Shout out to Jeff of JB Tech Enterprises and his brother Eric for helping me build this machine.

 

Edit: Here’s a video I posted on Youtube.

Here are some pics I took.

IMG_2990IMG_2993IMG_3073IMG_3074IMG_3077IMG_3075IMG_3076IMG_2996IMG_3078IMG_3079IMG_3080IMG_3082IMG_3084IMG_3083IMG_3085IMG_3086

RAID boo boo

I got my RAID1+0 set up Sunday night and I bought some molex to SATA power cable adapters (I ran out because of the positioning of the devices). After Windows 7’s backup/restore failed to restore my OS onto my new drives from a backup and image file on my NAS, I decided to plug in my old/space 1TB hard drive internally – hoping to fix that issue. The 4 drives on my RAID were plugged in with 3 red and 1 blue. Nitpicking around, I wanted to have them all red so I swapped the drive3 of the array (blue) cable with red. Then I plugged in the new drive. After booting up, I noticed my RAID manager saying that my array needed to be rebuilt. I’m guessing even swapping out cables is not allowed or it will break the chain – noob IT guy :\

So for the last few hours, my 3rd drive is being rebuilt. I’m just glad I didn’t have to reinstall Windows and all those drivers. Nevertheless, if you can set up any RAID configuration on your computer, I highly recommend it. Not only will it increase performance, but it can increase hardware reliability – based on the RAID configurations of course. If you got any questions, email Jeff from JB Tech Enterprisessupport@jbtechent.com. He’ll be able to help you out. He’s a genius when it comes to these things and he helped me build my new PC, or leave a comment below.

rebuild_raid

Moving back to Windows?

It’s been over 6 years since I exclusively used Windows and have been using Apple. But recently I’ve had the urge to build a PC – mainly for games and video transcoding. So I started doing so research on hardware. As I am doing research, I’m starting to realize how much Apple has limited me from doing certain things and lacked support for some I/O devices.

I find myself running Windows virtually for doing simple tasks that I can’t seem to do with Apple either free or efficiently. For instance, if I need to edit metadata on a video file without having it render again is only possible with iTunes. But if I use iTunes, it has to be added to the library and not all file formats are supported. In Windows, I can accomplish this by using a free app called MP3Tag. I’ve looked and have not found an app for OS X – free anyway.

My second example. USB 3.0 and eSata has been available for years now (well eSata has been around for years) – no support at all by any Apple hardware. Yes, there is FW400 and FW800 but it isn’t as practical or affordable. I have many external devices that have both USB 2.0 and eSata. The eSata is begging to be used but I can’t. Even my HD camcorder uses USB and iMovie can recognize it – no FW support on the camcorder.

My third example. I have a bluray burner and have a lot of movies. Not all have portable media versions that come with it and even if they did, I would download through iTunes and have it be stuck (DRM) to 5 accounts. I’d like to throw this file onto my DLNA server and have it stream throughout the house. I don’t want to leave my iMac on all day just so that iTunes can share things – that’s why I have a Terastation with DLNA. Now I can rip blueray videos. I use MakeMKV to rip it then use Handbrake to create an MP4 file which would take around 9 hours to do. I’m hoping to cut this down by a lot on a Windows machine because Windows supports blueray format.

My fourth example. Time Machine is great. But without the expensive Time Capsule, I can’t do back ups over the network. I have found hacks but they are not 100%. Again, I have a Terastation and want to use it to its full potential.

My fifth example. My iMac that I bought in 2008 has been maxed out of its upgrade. The ram is at 4GB and the hard drive is 1TB 7200RPM (I think this model should recognize up to 1.5TB). I’m unable to upgrade the video card because iMacs are built like laptops. So whenever a new game comes along (Starcraft 2), I’m stuck with hardware from 2008. I’m able to get as high as medium setting and still experience some lag. World of Warcraft, I’m able to get 22-40 FPS in high populated areas. For my uses, I can’t upgrade the hardware anymore and would like to. If I had bought a Mac Pro, I probably could but for the price… no thanks!

So the plan is to build a PC that will let me have a better experience in games as well as transcode/edit videos more efficiently than my current iMac. I will be using an Intel i7-2600K processor and an H-series motherboard. The P-series is a little more expensive and I don’t plan on overclocking anytime soon – even though the 2600K allows me to. Now why spend the extra bucks on K? I just want to have the capability of overclocking once I do decide. And when I do, I just get a new motherboard. By then the Z-series motherboards will be available will have the Quick Sync capability and overclocking capability. I will be running 8GB DDR3 1333 ram for starters but the motherboard will be ready for 16GB when I am. For now, I’ll be running 500GB Sata 3Gbps, but in the future I’ll have it set up with 4 250GB on Sata 6Gbps with RAID10. That should give me a powerful and enjoyful experience compared to what I have now with my iMac.

I enjoy using Apple and OS X and will continue to use it. But as a desktop and for my current needs, I feel I’m better off on a PC running Windows 7 64bit. My MBP 13″ will be my second desktop/laptop because I still don’t feel comfortable nor do I trust doing certain things on a Windows machine.

Once I get more comfortable and have a nice workflow set up on my new PC, I will be selling my iMac. But that won’t be for weeks. Hopefully, what I have read and expect is true. If not, my new PC will just be a gaming computer and I will continue to do everything else on my Mac.

MSSQL Driver for PHP5.3

Before using PHP5.3, I never had to worry about MSSQL support. PHP included a dll file to use with MSSQL Server 2000 and up. This is no longer true if you decide to upgrade to PHP5.3.x. For months I looked for ways to connect to our MSSQL Server using PHP5.3.x. I finally found the driver and it works. It’s called SQLSRV and you can download it from http://sqlsrvphp.codeplex.com. It’s easy to install, just read the CHM file.

  • Run the exe to unpack it
  • Rename the folder to Microsoft SQL Server Driver for PHP (optional)
  • Move this to your %Program Files% directory (optional)
  • Inside that directory you will find several dll files. It supports both NTS (Non Thread Safe) and TS (Thread Safe). You also need to choose between VC6 or VC9 compiler. This will determine which file will be used.
  • Copy that file to %Installation Directory%\PHP\ext\ (assuming you are using the ext directory for your extensions.
  • Edit your php.ini. In the extensions section add the following extension=php_sqlsrv_53_ts_vc6.dll – or whatever file you copied to your ext directory.
  • Restart your web server and that should be it.

Here’s a quick sample code to get you started.

<?php

$servername = "SQLSERVER_NAME_OR_IP";
$uid = "db_username";
$pwd = "db_passwd";
$connectionInfo = array (
"UID"=>$uid,
"PWD"=>$pwd,
"Database"=>"database_name"
);
$conn = sqlsrv_connect($serverName, $connectionInfo);

if ($conn === false) {
echo "ERROR: DB Connection";
die(print_r(sqlsrv_errors(), true));

}
$stmt = sqlsrv_query($conn, "SELECT * FROM table");

if ($stmt) {
while ($row = sqlsrv_fetch_array($stmt)) {
echo $row[0].’<br />’;
}
}

?>

That should do it. I have only tested this on Windows 7 Professional (32bit), MSSQL 2005 (32bit) Standard on a remote Windows 2008 Server Standard R2, PHP5.3.3, Apache2.2.15, and driver version 1.1 (version 2 is now available) . Make sure your MSSQL server can accept remote connections if it is on a different server than your web server. The above instructions shouldn’t be  too different on other versions.

If you have a phpinfo() page, you will see the image below.

sqlsrv_phpini

Hope this helps you get started. Happy coding.