Facebook Turned My Mom Into An Asian With Myspace Angles

Months ago when Facebook posted the update for their iPhone app to version 3.1, I immediately grabbed it. For those of us that enjoy using Facebook, I argue that it is one of the best iPhone apps available.

Push notification has been a long time coming, and I’ve enjoyed it as an alternative to email for notifications. The other big feature of the update was contact picture syncing. This wasn’t exactly something I was Jones’n’ for, but a welcome addition. I’ve had the same stagnant pictures of my contacts for years. Many of them came from my old Cingular 8125 via Exchange syncing.

What I didn’t expect, however, was for Facebook to turn my mom into an Asian with some pretty serious Myspace angles:

The thing that’s strange is I have no idea who this girl is. She’s not any of my friends on Facebook. I’ve never seen her. She’s never been in any of their profile pictures that I’ve seen or even in their photo albums.

What gives, Facebook? Have a little mix-up over there?

SSMS Tools Pack Makes My Life Easier

I don’t currently do a lot of whiz-bang magic in my current job role. The majority of my day consists of writing reports, which can be boiled down to any of the follow:

• Writing a stored procedure to generate the report data
• Creating the report layout in a WYSIWYG-style editor.
• Writing SQL script to deploy those changes to our customers.

The most exciting part is generally when I need to roll up my sleeves and figure out something fancy for the stored procedure. Much more often though, I’m hammering out INSERT scripts or UPDATE scripts with some XML stored as VARCHAR(MAX).

Because of the robotic nature of some of this, I decided to start using some code snippets. I couldn’t find any snippet feature in SQL Sever Management Studio, so I discovered SSMS Tools Pack.

This add-on has already saved me an enormous amount of time. I’ve only used a few of the features so far. SQL code snippets have obviously saved me a lot of time, but I found some other uses that I didn’t expect. I often need to test a report across multiple databases. With the tool pack, I can right click on a script, click “Run on multiple targets” and be prompted with a list of text boxes for each database I want to run it against. There’s nothing particularly magical about this process – it just creates a new tab and separates copies of the script with ‘USE [DatabaseName]’ lines, but it saves me a reasonable amount of time.

If you spend much time in SSMS, I recommend giving it a whirl. The full list of features:

• Run one script on multiple databases
• Copy execution plan bitmaps to clipboard or file
• Search results in Grid Mode or Execution Plans
• Generate Insert statements from resultsets, tables, or database
• Regions and Debug sections
• Running custom scripts from Object Explorer
• CRUD stored procedure generation
• New query template

SSMS Tools Pack

Not All Security Questions Are Secure

I’m a thief. I stole an email address, and I don’t feel too bad about it. Maybe a year or so ago, I decided to register my full name with Gmail. Because my primary address had my gaming handle in it, I wanted something a little more professional to use when necessary. When I attempted to register, I was told that name was already taken. For you Kevin Johnsons out there, this might not be uncommon. For a Seth Gholson, this is quite uncommon. My initial thought was “Oh! I must’ve registered it long ago and forgotten.” Naturally, I clicked “forgot my password.” I was present with the following security question:

What is your favorite color?

This seemed quite odd. I’d never use that as security question. For one thing, I’m on the fence between green and blue. I tend to spend a few years in each camp, alternating every so often. I just assumed I might’ve made this account so long ago that I chose this question before I understood what security meant. I made a gamble and I picked green. Wrong. Next up: blue. Bingo. I was present with a “new password” form. I set my password and logged in.

There were 5 emails – all Myspace related, 4-6 months old, and unread. None had even been archived. The last email was an account cancellation message from Myspace. That seemed awfully odd. A bit of Googling and and use of the Way Back Machine and I found him: another Seth Gholson. If his Myspace profile was an accurate indication, then he was around 14 or 15, had already developed an impressive ego, and fully expects to become a professional athlete.

Lessons to be learned by Mr. Other Seth Gholson:

1. Don’t pick easy security questions.
2. Don’t use the most obvious answer.
3. Bind your next gmail account to a secondary email address, like I did right after I snatched it.
4. Stay away from Myspace. It’s full of pervies.

I don’t feel too bad for this. It looks like he barely ever used it. On top of that, I’m older. I call firsties. If there’s a Seth Gholson out there born before ‘83, I welcome you to snatch the address from me.

Off with my Gmail account’s head! Long live my Gmail account!

In an effort to simplify life and centralize my scattered points of communication, I’m consolidating my email addresses. I currently have:

• My original gmail account, which includes my gaming handle for some strange reason and I’ve hated using it for years.
• My email account for this blog, which uses Google Apps For Your Domain Business.
• My full name at gmail – my acquisition of this account warrants its own post. I don’t use it too often because my last name isn’t immediately intuitive and it makes the address a bit long.
• My primary email account from my old domain, which I primarily used for a side job I used to do, but I have a couple of random website accounts tied to it like Drop Box.

When I started considering this, I immediately thought of Google Reader, gmail chat, and of course Buzz. I want to check everything from the same account, so these are a factor as well.

Transferring my contacts was a cakewalk, but not as easy as it should be. When you create a new account, Google has 3 emails waiting in your inbox – an introduction to mobile phone access, a summary of customization options like colors and themes, and a third email sympathizing with the pains of transferring contacts and a handy “Import contacts and mail” link. Strangely enough,  they wouldn’t allow me to import contacts from another gmail account. WTF, Google? I had to export/import a Google CSV file, but no obvious data was lost. It also allowed me an opportunity to address the contacts that I don’t really communicate with often enough to label a “contact” and omit them. Nonetheless, it should’ve been a one-click operation.

Google Reader was a similar painless affair – I just exported the OPML file from my old account and imported into my new account.

Buzz and Google Chat were a different story, though. Because Buzz just launched, I’m only following 9 people – the 9 it automatically recognized. For this and for chat, I had to manually add each contact by typing in their name or email address. Luckily, Buzz tied into Google Reader, so I was automatically following my old Google Reader chaps.

Next up – forwarding. In each of my old accounts, I configured it to forward all email to my new account. In my new main account, I created a filter and I have each account dropping into its own folder label. This will help me make sense of it all at first, but I plan to eliminate this distinction later.

I expect there to be some cases in which I don’t want my reply-to address to be my new main email address, but keep it as the old address. Because of this, I added all accounts under “Send mail as” in my Google settings. This will allow me to still send mail from my @sethgholson.com address if I specifically wanted to:

Google sends a verification email to that address with a code/link to confirm you own the address. Because I had already configured forwarding, it all came to my new inbox and I didn’t have to hunt down the number in each account.

I’m sure I neglected something, but that should be the core of the transition.

Back on track

Over a year ago, I lost my debit card. Naturally, I canceled it. Because I’m lazy, I had a number of bills auto debiting via that card. This made the process of moving to a new debit card a nightmare.

I forgot something, and it was my hosting provider. They didn’t call me or email me (from what I could tell) for months. My old website worked for quite a long time. One day it quit working, and they wanted their money. Well, a collection agency wanted their money. The first time I recognized the problem was when a collection agency called me. Of course I paid it immediately, but all of my data was gone. My account hasn’t been restored. I’m fine with that – the hosting provider (1and1) was terrible, hard to communicate with, and had a dreadful management panel. I also hated my old domain name.

When all of this went down, I was pretty busy with work and school and family, so I didn’t feel like I had enough time to spare worrying about some silly blog posts.

I woke up early today, over a year after that happened, and decided to address it. I made my way over to the Way Back Machine and grabbed most of my old blog posts. Worked like a charm, other than missing pictures from some of the most recent posts.

I plan on implementing some automated backup solution for my data this time around.

Oh, and maybe post! That would be a great idea.