Windows Server 2012 crashes after enabling Hyper-V

A little off my usual topic but this was a super annoying problem I had to deal with... I enabled the Hyper-V role in Server 2012 and my machine no longer goes past the Windows logo. Sadly there is no Windows Restore feature in Server 2012 not to mention I wasn't able to uninstall Hyper-V in safe mode so I was essentially stuck.

Solution? Disable USB 3.0 controller in BIOS. BAM! Things work again. Apparently Hyper-V and USB 3.0 don't like each other. Thanks Microsoft for wasting an hour of my time.

Datetime Parameter Mapping issue with SSIS

This might be common knowledge but I spent a good 30 minutes trying to figure out why my Execute SQL task wasn't inserting a datetime variable value in to my database. Generally when working with SQL I know that the datetime data type can convert to DBTimestamp with no issue but for some reason it keeps failing whenever I set the data type in the parameter mapping settings of the SQL task to DBTimestamp... Setting it to varchar or long would make the task succeed however it would have inserted a wrong date and time.

The fix? Simple.... set the data type to Date instead of DBTimestamp! DOH!

/cry