My Shiny New Alienware m17x R3

Somehow, as if by magic, I have managed to persuade work to buy me a nice new Alienware m17x gaming laptop. I decided to show you all what it is like, not to brag, but to educate…

What an awsome machine it is!!! Check out the spec below.

Intel Core i7 2630QM Quad Core @ 2Ghz
16GB DDR 3 @ 1333Mhz
2 x 320GB 7200RPM Disks in RAID 0
AMD Radeon HD 6870M 1GB GDDR5
17.3″ 1920×1080 Full HD WLED LCD display
Blur-Ray Reader / CD-RW DVD-RW Slot loading Drive
HDMI Output
HDMI Input
USB 3.0

It’s really is an amazing machine considering it’s portability. It’s a shame it gets used more for work and running virtual servers in a development environment then to play games…  I have obviously tested it with a few games though, which it handles admirably.

The sound quality from the Klipsch speakers is quite impressive for a laptop, although I would have preferred a bit more bass. It does however have 2 headphone ports for gaming headsets, and allows the gamer to fade between game sounds and player chat through Ventrilo or teamspeak. A digital audio out is also handy for connecting my 7.1 surround sound system with just one cable.

The graphics output options are pretty impressive for a laptop, having HDMI Out, VGA 15 pin D-sub out and a Mini Display port out offer plenty of flexibility when outputting those PowerPoint presentations, or of course for playing your games on a larger display. The laptop also has a built-in WiHD transmitter, which I am told will wirelessly transmit HD video to a WiHD ready TV or receiver. although I havn’t tried this feature yet I’m sure it is a handy for Gamers.

HDMI In support allows you to plug your PlayStation 3 or XBOX 360 in and use the built-in HD display of the laptop to play your console games.

Two USB 3.0 ports are a very welcome feature, allowing me to use an external hard disk to run VM’s from without contending my internal hard disks.

All in all I am very pleased with the Alienware m17x R3, although it is on the heavy side when it comes to commuting with the laptop in my bag.

 

Recovering a “Suspect” Database in SQL Server 2008

Today I broke my SharePoint development environment by shutting down the SQL Server forcibly and corrupting my transaction logs, making the databases show in Management Studio show as “Suspect”. Thankfully this was a development environment and not our live environment! After a lot of googling and perseverance, I managed to cobble together a solution to get my databases back online and continue to work.

The best way to recover from this issue is to restore from a Backup. Stupidly I didn’t have a good backup available for the databases in my Dev environment.

I DO NOT recommend this method on a live system!!!

To recover the database, which involves rebuilding the transaction log I executed the following query in Management Studio. Obviously change the database name to reflect your own database name.

USE master
GO
ALTER DATABASE [DB_Name] SET EMERGENCY
GO
ALTER DATABASE [DB_Name] SET SINGLE_USER;
GO
DBCC CHECKDB ([DB_Name], REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
GO
ALTER DATABASE [DB_Name] SET ONLINE;
GO
ALTER DATABASE [DB_Name] SET MULTI_USER;
GO

Again I stress, DO NOT sue this method on a live environment.