Windows Server 2008/2012 Blue Screen after Login – No Desktop
One of my teammates was working on a Windows server and needed to access IIS to complete a Sitecore upgrade on the machine. After logging in, he was reporting that he only saw a blue screen with no user interface. I logged in under the administrator account and ran into the same thing. Here's how I was able to reset:
Steam is having trouble connecting to the Steam servers.
If you use Steam and  suddenly find yourself unable to connect receiving the error "Steam is having trouble connecting to the Steam servers.", check and see if you have Peerblock installed and running. I wasted a lot of time trying to figure out why the connections wouldn't go through and finally went through apps running in the background one by one, until I closed Peerblock and discovered Steam suddenly started working. If you would like to continue to use Steam while Peerblock is open, follow these instructions for a workaround: 1. Start PeerBlock 2. Click List Manager 3. Click Add 4. Put something in the description like steam-allow 5. click add url and paste this: "http://list.iblocklist.com/?list=steam" (no quotes) 6. Choose type: allow 7. Click Ok then close the List Manager. This will download a list that adds exceptions for Steam and should let you connect with no issues.
ASP.NET MVC Model Generator
In making the switch to ASP.NET MVC, I've moved away from using my old Data Access Layer that I've used for years and have opted to use Dapper as my ORM of choice in the quest for optimal performance. My DAL was actually pretty optimized for WinForms and WebForms (using straight SQL Queries and SQL parameters) but mapping it to models wasn't something I had in mind when I created it. I'm finding Dapper takes some getting used too but it is still pretty fast. The downside is that writing the code for Models to wire it up is proving to be a little tedious. To that effect, I wrote a little application that has helped me generate the models from a database dynamically. It's in it's infancy stages and something I cobbled together in less than 8 hours but it works. I'll add more features too as time goes on if there's enough interest or to satisfy my own needs. In the meantime, I'm open sourcing the project as it may help others and I'd love to see it become something grander if others are willing to contribute to it. There's also some useful bits of code that others may find useful to reference like dynamically reading fields from a database, pluralization/singularization of words, amongst others. You can find the repository on Github: https://github.com/gregvarghese/MVCModelGenerator
Uninstalling Trend Micro Client/Server Security without a Password
Lost or forgot your Trend Micro Client/Server Password? How about inheriting a computer that had the software installed by an IT team or consultant that won't give up the password? I had to work on a network with the latter and it's rather annoying. The product is utter crap as the machine is spyware infested even though the antivirus is running and present. I went to uninstall it but can't because the previous person/company password protected it and nobody has it. Here's how to bypass the protection:
Drobo Dashboard Can’t Connect to Drobo when ESET Firewall is Active
Have a Drobo storage unit? If you have ESET Smart Security Firewall enabled, you'll probably find Drobo Dashboard can't connect while the firewall is on even after adding all the required ports and services to ESET's rules from the Drobo online help site (http://goo.gl/iVKVU). After enabling the detailed logging in ESET, I found that ESET's firewall was flagging Drobo Dashboard as an intrusion attempt and blocked it. From the Drobo help page (http://goo.gl/iVKVU):
Round Up to Whole Numbers in Excel (10s, 100s, 1000s, etc)
After years of using Excel, I realized today I have never had to round up to the nearest whole number before - until today that is. I was organizing my finances and realized that I wanted to round some of the amounts up to the nearest 10. So to round to the nearest decimal place in Excel, the formula is: =ROUNDUP([Range],[Position]) Count the number of places after the 0 to round to and set [Position] to that value So if you had 1234.25 in Cell A1 and wanted to round up to the nearest cent, =ROUNDUP(A1, 1) would produce 1234.30.