USB to 5VDC wiring diagram
I can never remember what the pinout is to get 5VDC from a male USB-A connector, and being color-blind having a true wiring diagram helps a lot. Sure I could Google and Wikipedia search it, and combine the results, but hey, why not use my blog as a repository of stuff I’ve learned, right? Here is a link to a PDF document including pictures and data polarity/voltages. Basically, you want pins 1 and 4. Looking at the male connector head-on,…
Upgrading a Cliq XT…when Motorola won’t
Like many Cliq XT owners (TMO), I got tired of everyone in the world getting a newer OS except me…even the Cliq owners got 2.1 this past month, but Cliq XT didn’t. Yeah, well, enough of that crap. Here’s how I rooted and upgraded my Cliq XT: 1. Root the phone – instructions here2. Install Recovery image – instructions here3. Download ROM zip file (leave as ZIP file!) and copy to root of SD card – instructions here4. Boot the…
Case expressions may only be nested to level 10
I was working on a rather lengthy query that used a typical CASE WHEN THEN ELSE END sequence, but it kept telling me “Case expressions may only be nested to level 10”, even though I wasn’t nesting or doing something unique with them, just like this: case when field1 = ‘data’ then ‘data1’ when field1 = ‘datax’ then ‘data2’ when field1 = ‘datay’ then ‘data3’ when field1 = ‘dataz’ then ‘data4’ when field1 = ‘dataa’ then ‘data5’ when field1 =…
Reveal most useful settings in Windows 7
Most useful here is subjective, but here is a quick way to create your own quick listing of common Windows 7 settings, including shortcuts, links to Control Panel items, etc. It’s definitely not an all-inclusive list, but it works, and it’s pretty cool. Create a folder somewhere (desktop preferably until you see what it does). Right-click and rename the folder .{ED7BA470-8E54-465E-825C-99712043E01C} Note the period between and the unique identifier – very important! “Name of your choice” can be anything you…
Event ID 6050 error in SharePoint 2010 with AD User Profile Import
Here I was, banging my head into the proverbial wall over why in MOSS 2007 I was able to use a service account with read permissions to Active Directory, but when setting up SharePoint 2010’s User Profile Import to AD it kept breaking. Then I stumbled across this article. So I contacted out Network guys, who created a service account with permissions as indicated in this KB article: http://support.microsoft.com/kb/303972 And lo and behold, all problems are solved! SharePoint 2010 now…