Introduction to PowerPivot for Excel and SQL Server

If you’ve heard about PowerPivot for Excel, you may have heard about the self-service business intelligence capabilities of the tool. I guess it’s about time to explore PowerPivot for Excel. Check out this article to get started. I think this is one of the best things that came out of the collaboration between the Excel […]

Disaster Recovery Is More Than Just Technology Part 3: The Lion, The Switch and The Wardrobe

You were in your favourite bar one Saturday night when, suddenly, you hear your mobile phone ring. You pick up the phone and heard the sound of a screaming voice on the other end (no, it’s not your wife telling you to go home and take out the trash). The background noise is preventing you […]

Connecting HyperV guests to the local network even before installing Integration Services

So, I have finally had my hands on Microsoft Hyper-V. I’ve installed Windows Server 2008 with Hyper-V role on my laptop for creating virtual machines. I’ve decided to virtualize my Windows XP work-machine so that I won’t have to worry about backups in case it got corrupted. What I had in mind was to simply […]