Hanging out at moms, eating grandma's home cooking... waiting for 2010
to arrive. Happy New Year Everyone!!!!!
Man it is nippy outside, vehicle is covered in frost! I am trying to warm up the SUV before the little ones get in. #cold
I have no idea how I manage to remove pillow cases while I am sleeping. Finding them the next day is difficult!
Kitchen Organization Phase I - Complete
I opted to go with the Rev-A-Shelf (Two-Tier Pull Out Basket) Large
since I could not find a large version of the Two-Tier Cookware
Organizer. Either way I am pretty happy with the outcome. The initial
install of the first one took a little over 35 mins and the second was
assembled and installed in about 15 mins. Since my cabinets are a
little larger then the average cabinet size the racks did not fit
exactly perfect, but I decided to leave most of room on the outer
sides of the racks. So in the left cabinet I pulled the rack more the
right leaving about a good 45 inches of space on the left and vice
versa for the right cabinet. With that 4 inches of space I will use
it for cutting boards, cookie sheets, etc...
Man playing Wii Punch-Out is bringing back memories of Mike Tyson's
Punch Out that we all used to play at my boys crib at�Granada Villa
I'm parked! Person loading her car in the spot next to me let one loose as she bent over with her rear end facing me. Loud!
sqlshots: Add Leading Zeros
Typically in most cases you find yourself removing leading zeros but in this case I needed to add leading zeros to a column.
Remove Leading Zeros
SELECT CAST(CAST(ColumnName AS INT) AS VARCHAR(10)) FROM TableName
Let's Pad the field
Since I needed 6 chars this will add 3 spaces to the front of the numbers
SELECT STR(ColumnName, 6) FROM TableName
Add Leading Zeros
Let's say we need to add zeros to an employee id, well this would be an easy way to accomplish it.
SELECT REPLACE(STR(ColumnName, 6), SPACE(1), '0') FROM TableName
SELECT SalesPersonID ,REPLACE(STR(SalesPersonID, 6), SPACE(1), '0') AS PaddedSalesPID FROM Sales.SalesPerson
Note: the SPACE(1) is equivalent to ' ' (That is a Tick Space Tick) So two Ticks with a space in between)
Update Table
UPDATE Sales.SalesPerson SET newSalesPID = REPLACE(STR(SalesPersonID, 6), SPACE(1), '0')
Custom URL + Google Apps + Posterous = Easy Custom Blog
Step 1: Get yourself a domain
Preferably a registrar that gives you control of the DNS (e.g Buydomains.com, GoDaddy.com, etc...)
Step 2: Edit the DNS settings of your new domain
You may have to delete all the previous entires which is what I did. At this point you can do everything listed in the illustration with the exception of the area highlighted in blue (Google Apps Identifier) since we haven't gotten their yet. Save your changes!
Step 3: Signup for Google Apps
The standard account allows you to create up to 50 email addresses. So you can get you@yoursite.com. Which is way cool!
Go here: http://bit.ly/6Z3d2h to sign up for a Standard (FREE) account
Setup your custom URL for:
- Google Docs
- Google Calendar
- Google Sites
- Google Email
- Save your changes!
Just make sure the names you choose match the CNAME entries which you made in step 2!
Step 4: Update the DNS settings
Now go back and add a CNAME entry to your DNS settings using your new Google App Identifier. Remember it is the blue highlighted area back on step 2. Save your changes!
Step 5: Signup for a Posterous account
Go here: http://bit.ly/8NMxrV to signup
Setup Posterous to use your custom URL
- Click on Manage
- Click on the Settings tab
- In the top section you will see (Custom domain name)
- Save your changes
Optional Items
Google Analytics
It's an easy way to analyze the traffic that visits your site.
Go here: http://bit.ly/8SHZuc to singup
FeedBurner
In case you're in the mood for syndication. Here is some info: http://bit.ly/6np9yl
Go here: http://bit.ly/5TgOvr to signup
To configure these optional items they are located on the bottom of the settings page which we visited back on step 5.
Posting to your site
If you can send an email you can make a post on your site. Here are the addresses you can use.
- post@yourAccount.posterous.com (If you have autopost enabled this will update all the linked social sites)
- posterous@yourAccount.posterous.com (Will only post to your site and will not autopost)
- private@yourAccount.posterous.com (Will only post to your site and will only be visible to you)
Posting Tips
Gallery vs No Gallery
See the difference here: http://bit.ly/6dbTsP
If you add multiple images to your email it will collectively be placed into a very cool (thumb driven) gallery, but if you don't want that simply add ((nogallery)) to your subject line. Yes that is a double parentheses.
Tags
Tags are commonly used pretty much everywhere nowadays so to tag your posts simply add ((tags: food, family, bbq)) to your subject line. Again that is a double parentheses.
Happy posting!
Subscribe to:
Posts (Atom)
