<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>Trust Your Technologist</title>
	<atom:link href="http://www.trustyourtechnologist.com/index.php?feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://www.trustyourtechnologist.com</link>
	<description>Software with coffee and art...</description>
	<lastBuildDate>Mon, 23 Aug 2010 13:24:30 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.0</generator>
		<item>
		<title>15 Facts about Net Neutrality &#8211; An Infographic</title>
		<link>http://www.trustyourtechnologist.com/index.php/2010/08/15-facts-about-net-neutrality-an-infographic/</link>
		<comments>http://www.trustyourtechnologist.com/index.php/2010/08/15-facts-about-net-neutrality-an-infographic/#comments</comments>
		<pubDate>Mon, 23 Aug 2010 13:24:30 +0000</pubDate>
		<dc:creator>Stephanie</dc:creator>
				<category><![CDATA[General Knowledge]]></category>
		<category><![CDATA[net neutrality]]></category>

		<guid isPermaLink="false">http://www.trustyourtechnologist.com/?p=588</guid>
		<description><![CDATA[Recently there has been a lot of discussion about net neutrality on our blog and elsewhere and it seems the debate is not going to end anytime soon. With the most recent chapter in the debate involving Google and Verizon making a deal, it&#8217;s hard to keep track of all the big players and the [...]]]></description>
			<content:encoded><![CDATA[<p>Recently there has been a lot of <a href="http://www.trustyourtechnologist.com/index.php/2010/07/debate-over-net-neutrality/">discussion about net neutrality</a> on our blog and elsewhere and it seems the debate is not going to end anytime soon. With the most recent chapter in the <a href="http://www.trustyourtechnologist.com/index.php/2010/08/google-and-verizon-take-a-positive-step-towards-net-neutrality/">debate involving Google and Verizon</a> making a deal, it&#8217;s hard to keep track of all the big players and the latest advancements. Most people have probably heard about the debate but not everyone necessarily knows or cares what it means to their everyday internet use and some people still may be having a hard time digesting the concept of net neutrality as a whole. With that we bring you 15 Facts about Net Neutrality &#8211; an infographic courtesy of <a href="http://www.onlinemba.com/">Online MBA Programs</a>. As a visual learner (and someone who has been following the debate closely), I found this helpful and hope you will too.</p>
<p><a href="http://www.readwriteweb.com/archives/15_facts_about_net_neutrality_infographic.php"><span id="more-588"></span></a><a href="http://www.readwriteweb.com/archives/15_facts_about_net_neutrality_infographic.php"><img src="http://onlinemba.com.s3.amazonaws.com/net-neutrality.jpg" border="0" alt="Online MBA Rankings" width="500" /></a><br />
[Via: <a href="http://www.onlinemba.com/">Online MBA Programs</a>]</p>
Share and Enjoy:<a rel='nofollow' target='_blank'  href='http://www.printfriendly.com/print?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2F15-facts-about-net-neutrality-an-infographic%2F&amp;partner=sociable'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/printfriendly.png' class='sociable-img sociable-hovers ' title='Print' alt='Print' /></a><a rel='nofollow' target='_blank'  href='mailto:?subject=15%20Facts%20about%20Net%20Neutrality%20-%20An%20Infographic&amp;body=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2F15-facts-about-net-neutrality-an-infographic%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/email_link.png' class='sociable-img sociable-hovers ' title='email' alt='email' /></a><a rel='nofollow' target='_blank'  href='http://www.trustyourtechnologist.com/index.php/feed/'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/rss.png' class='sociable-img sociable-hovers ' title='RSS' alt='RSS' /></a><a rel='nofollow' target='_blank'  href='http://www.facebook.com/share.php?u=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2F15-facts-about-net-neutrality-an-infographic%2F&amp;t=15%20Facts%20about%20Net%20Neutrality%20-%20An%20Infographic'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/facebook.png' class='sociable-img sociable-hovers ' title='Facebook' alt='Facebook' /></a><a rel='nofollow' target='_blank'  href='http://twitter.com/home?status=15%20Facts%20about%20Net%20Neutrality%20-%20An%20Infographic%20-%20http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2F15-facts-about-net-neutrality-an-infographic%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/twitter.png' class='sociable-img sociable-hovers ' title='Twitter' alt='Twitter' /></a><a rel='nofollow' target='_blank'  href='http://www.linkedin.com/shareArticle?mini=true&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2F15-facts-about-net-neutrality-an-infographic%2F&amp;title=15%20Facts%20about%20Net%20Neutrality%20-%20An%20Infographic&amp;source=Trust+Your+Technologist+Software+with+coffee+and+art...&amp;summary=Recently%20there%20has%20been%20a%20lot%20of%20discussion%20about%20net%20neutrality%20on%20our%20blog%20and%20elsewhere%20and%20it%20seems%20the%20debate%20is%20not%20going%20to%20end%20anytime%20soon.%20With%20the%20most%20recent%20chapter%20in%20the%20debate%20involving%20Google%20and%20Verizon%20making%20a%20deal%2C%20it%27s%20hard%20to%20k'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/linkedin.png' class='sociable-img sociable-hovers ' title='LinkedIn' alt='LinkedIn' /></a><a rel='nofollow' target='_blank'  href='http://digg.com/submit?phase=2&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2F15-facts-about-net-neutrality-an-infographic%2F&amp;title=15%20Facts%20about%20Net%20Neutrality%20-%20An%20Infographic&amp;bodytext=Recently%20there%20has%20been%20a%20lot%20of%20discussion%20about%20net%20neutrality%20on%20our%20blog%20and%20elsewhere%20and%20it%20seems%20the%20debate%20is%20not%20going%20to%20end%20anytime%20soon.%20With%20the%20most%20recent%20chapter%20in%20the%20debate%20involving%20Google%20and%20Verizon%20making%20a%20deal%2C%20it%27s%20hard%20to%20k'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/digg.png' class='sociable-img sociable-hovers ' title='Digg' alt='Digg' /></a><a rel='nofollow' target='_blank'  href='http://www.stumbleupon.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2F15-facts-about-net-neutrality-an-infographic%2F&amp;title=15%20Facts%20about%20Net%20Neutrality%20-%20An%20Infographic'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/stumbleupon.png' class='sociable-img sociable-hovers ' title='StumbleUpon' alt='StumbleUpon' /></a><a rel='nofollow' target='_blank'  href='http://delicious.com/post?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2F15-facts-about-net-neutrality-an-infographic%2F&amp;title=15%20Facts%20about%20Net%20Neutrality%20-%20An%20Infographic&amp;notes=Recently%20there%20has%20been%20a%20lot%20of%20discussion%20about%20net%20neutrality%20on%20our%20blog%20and%20elsewhere%20and%20it%20seems%20the%20debate%20is%20not%20going%20to%20end%20anytime%20soon.%20With%20the%20most%20recent%20chapter%20in%20the%20debate%20involving%20Google%20and%20Verizon%20making%20a%20deal%2C%20it%27s%20hard%20to%20k'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/delicious.png' class='sociable-img sociable-hovers ' title='del.icio.us' alt='del.icio.us' /></a><a rel='nofollow' target='_blank'  href='http://reddit.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2F15-facts-about-net-neutrality-an-infographic%2F&amp;title=15%20Facts%20about%20Net%20Neutrality%20-%20An%20Infographic'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/reddit.png' class='sociable-img sociable-hovers ' title='Reddit' alt='Reddit' /></a><a rel='nofollow' target='_blank'  href='http://www.google.com/reader/link?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2F15-facts-about-net-neutrality-an-infographic%2F&amp;title=15%20Facts%20about%20Net%20Neutrality%20-%20An%20Infographic&amp;srcURL=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2F15-facts-about-net-neutrality-an-infographic%2F&amp;srcTitle=Trust+Your+Technologist+Software+with+coffee+and+art...'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/googlebuzz.png' class='sociable-img sociable-hovers ' title='Google Buzz' alt='Google Buzz' /></a><a rel='nofollow' target='_blank'  href='http://technorati.com/faves?add=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2F15-facts-about-net-neutrality-an-infographic%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/technorati.png' class='sociable-img sociable-hovers ' title='Technorati' alt='Technorati' /></a><br/><br/>]]></content:encoded>
			<wfw:commentRss>http://www.trustyourtechnologist.com/index.php/2010/08/15-facts-about-net-neutrality-an-infographic/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Facebook Places: Another Invasion of Privacy</title>
		<link>http://www.trustyourtechnologist.com/index.php/2010/08/facebook-places-another-invasion-of-privacy/</link>
		<comments>http://www.trustyourtechnologist.com/index.php/2010/08/facebook-places-another-invasion-of-privacy/#comments</comments>
		<pubDate>Thu, 19 Aug 2010 20:21:13 +0000</pubDate>
		<dc:creator>Stephanie</dc:creator>
				<category><![CDATA[Social Media]]></category>
		<category><![CDATA[checking-in]]></category>
		<category><![CDATA[Facebook]]></category>
		<category><![CDATA[Facebook Places]]></category>
		<category><![CDATA[geolocation]]></category>
		<category><![CDATA[privacy]]></category>

		<guid isPermaLink="false">http://www.trustyourtechnologist.com/?p=577</guid>
		<description><![CDATA[Facebook unveiled the new Places feature late yesterday and once again there is criticism for their lack of concern for users’ privacy. While the privacy controls for the new geolocating feature, which is only currently available in certain areas of the US, are not as dicey as the spring privacy overhaul, there are some features [...]]]></description>
			<content:encoded><![CDATA[<p><a rel="attachment wp-att-581" href="http://www.trustyourtechnologist.com/index.php/2010/08/facebook-places-another-invasion-of-privacy/fb/"><img class="alignleft size-full wp-image-581" title="FB" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/08/FB.jpg" alt="" width="243" height="243" /></a><a href="http://blog.facebook.com/blog.php?post=418175202130">Facebook unveiled the new Places feature</a> late yesterday and once again there is criticism for their lack of concern for users’ privacy. While the privacy controls for the new geolocating feature, which is only currently available in certain areas of the US, are not as dicey as the <a href="http://www.trustyourtechnologist.com/index.php/2010/05/facebook-makes-an-attempt-to-save-face/">spring privacy overhaul</a>, there are some features that don’t bode well for the social network.</p>
<p>Users can check-in to local establishments using their smart phones (currently the iPhone is the only device compatible with Places) to show others where they are, to see where friends in the area have recently checked-in and to see who was last at their current location. It seems Facebook attempted to learn from their privacy mistakes by setting the check-in default visibility to “Friends Only” so your current location isn’t broadcast over all of Facebook—unless of course you’ve set your master privacy control to “Everyone.”</p>
<p>On the surface it seems Facebook Places operates just like any other check-in application like Foursquare or Gowalla. But what sets it apart, for better or worse, is the ability to tag others. One person checking in to a local restaurant can tag all of the members of his group. The fact that someone else can broadcast where you are without your knowledge or consent <a href="http://www.aclunc.org/issues/technology/blog/facebook_places_check_this_out_before_you_check_in.shtml">doesn’t sit well with the ACLU</a>. Furthermore, they find fault with the privacy controls stating “you are only given a ‘not now’ option (aka ask me again later). ‘No’ isn’t one of the easy options.”</p>
<p><span id="more-577"></span>Another major concern is the fact that all information gathered by Facebook Places is available to developers and third-party applications. And similar to the issues in the spring, you don’t always have control over what your friends choose to share about you. Your friends can choose to share their check-in information with applications and if you are linked to that info via a recent check-in at the same location or by being tagged in a check-in, your information is also shared with that application.</p>
<p>It does seem that Facebook made an effort to learn from the backlash against their last privacy overhaul and put more control in the hands of the users. There are controls that you can set for each level of privacy where check-ins are concerned. You can choose if you want to appear in the “People Here Now” section after you’ve checked in so others checking in can see that you were/are there and you can control if you want to share your own info with third party applications.</p>
<p>Overall, there are some issues but it seems users have control if they choose to exercise it. But if users are relying on the default settings to keep their information secure, they may be sharing more than they bargained for. Then again, if you can’t be bothered to check your privacy settings, maybe you shouldn’t bother broadcasting your whereabouts either.</p>
<p>What do you think? Is Facebook Places bordering on invasion of privacy? Or is it your responsibility to know what you’re broadcasting and how when you choose to get involved with this type of social networking?</p>
Share and Enjoy:<a rel='nofollow' target='_blank'  href='http://www.printfriendly.com/print?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Ffacebook-places-another-invasion-of-privacy%2F&amp;partner=sociable'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/printfriendly.png' class='sociable-img sociable-hovers ' title='Print' alt='Print' /></a><a rel='nofollow' target='_blank'  href='mailto:?subject=Facebook%20Places%3A%20Another%20Invasion%20of%20Privacy&amp;body=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Ffacebook-places-another-invasion-of-privacy%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/email_link.png' class='sociable-img sociable-hovers ' title='email' alt='email' /></a><a rel='nofollow' target='_blank'  href='http://www.trustyourtechnologist.com/index.php/feed/'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/rss.png' class='sociable-img sociable-hovers ' title='RSS' alt='RSS' /></a><a rel='nofollow' target='_blank'  href='http://www.facebook.com/share.php?u=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Ffacebook-places-another-invasion-of-privacy%2F&amp;t=Facebook%20Places%3A%20Another%20Invasion%20of%20Privacy'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/facebook.png' class='sociable-img sociable-hovers ' title='Facebook' alt='Facebook' /></a><a rel='nofollow' target='_blank'  href='http://twitter.com/home?status=Facebook%20Places%3A%20Another%20Invasion%20of%20Privacy%20-%20http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Ffacebook-places-another-invasion-of-privacy%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/twitter.png' class='sociable-img sociable-hovers ' title='Twitter' alt='Twitter' /></a><a rel='nofollow' target='_blank'  href='http://www.linkedin.com/shareArticle?mini=true&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Ffacebook-places-another-invasion-of-privacy%2F&amp;title=Facebook%20Places%3A%20Another%20Invasion%20of%20Privacy&amp;source=Trust+Your+Technologist+Software+with+coffee+and+art...&amp;summary=Facebook%20unveiled%20the%20new%20Places%20feature%20late%20yesterday%20and%20once%20again%20there%20is%20criticism%20for%20their%20lack%20of%20concern%20for%20users%E2%80%99%20privacy.%20While%20the%20privacy%20controls%20for%20the%20new%20geolocating%20feature%2C%20which%20is%20only%20currently%20available%20in%20certain%20areas%20o'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/linkedin.png' class='sociable-img sociable-hovers ' title='LinkedIn' alt='LinkedIn' /></a><a rel='nofollow' target='_blank'  href='http://digg.com/submit?phase=2&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Ffacebook-places-another-invasion-of-privacy%2F&amp;title=Facebook%20Places%3A%20Another%20Invasion%20of%20Privacy&amp;bodytext=Facebook%20unveiled%20the%20new%20Places%20feature%20late%20yesterday%20and%20once%20again%20there%20is%20criticism%20for%20their%20lack%20of%20concern%20for%20users%E2%80%99%20privacy.%20While%20the%20privacy%20controls%20for%20the%20new%20geolocating%20feature%2C%20which%20is%20only%20currently%20available%20in%20certain%20areas%20o'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/digg.png' class='sociable-img sociable-hovers ' title='Digg' alt='Digg' /></a><a rel='nofollow' target='_blank'  href='http://www.stumbleupon.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Ffacebook-places-another-invasion-of-privacy%2F&amp;title=Facebook%20Places%3A%20Another%20Invasion%20of%20Privacy'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/stumbleupon.png' class='sociable-img sociable-hovers ' title='StumbleUpon' alt='StumbleUpon' /></a><a rel='nofollow' target='_blank'  href='http://delicious.com/post?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Ffacebook-places-another-invasion-of-privacy%2F&amp;title=Facebook%20Places%3A%20Another%20Invasion%20of%20Privacy&amp;notes=Facebook%20unveiled%20the%20new%20Places%20feature%20late%20yesterday%20and%20once%20again%20there%20is%20criticism%20for%20their%20lack%20of%20concern%20for%20users%E2%80%99%20privacy.%20While%20the%20privacy%20controls%20for%20the%20new%20geolocating%20feature%2C%20which%20is%20only%20currently%20available%20in%20certain%20areas%20o'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/delicious.png' class='sociable-img sociable-hovers ' title='del.icio.us' alt='del.icio.us' /></a><a rel='nofollow' target='_blank'  href='http://reddit.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Ffacebook-places-another-invasion-of-privacy%2F&amp;title=Facebook%20Places%3A%20Another%20Invasion%20of%20Privacy'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/reddit.png' class='sociable-img sociable-hovers ' title='Reddit' alt='Reddit' /></a><a rel='nofollow' target='_blank'  href='http://www.google.com/reader/link?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Ffacebook-places-another-invasion-of-privacy%2F&amp;title=Facebook%20Places%3A%20Another%20Invasion%20of%20Privacy&amp;srcURL=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Ffacebook-places-another-invasion-of-privacy%2F&amp;srcTitle=Trust+Your+Technologist+Software+with+coffee+and+art...'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/googlebuzz.png' class='sociable-img sociable-hovers ' title='Google Buzz' alt='Google Buzz' /></a><a rel='nofollow' target='_blank'  href='http://technorati.com/faves?add=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Ffacebook-places-another-invasion-of-privacy%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/technorati.png' class='sociable-img sociable-hovers ' title='Technorati' alt='Technorati' /></a><br/><br/>]]></content:encoded>
			<wfw:commentRss>http://www.trustyourtechnologist.com/index.php/2010/08/facebook-places-another-invasion-of-privacy/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
		</item>
		<item>
		<title>Quick Fire Tips for Effective Email Marketing</title>
		<link>http://www.trustyourtechnologist.com/index.php/2010/08/quick-fire-tips-for-effective-email-marketing/</link>
		<comments>http://www.trustyourtechnologist.com/index.php/2010/08/quick-fire-tips-for-effective-email-marketing/#comments</comments>
		<pubDate>Mon, 16 Aug 2010 14:03:23 +0000</pubDate>
		<dc:creator>Damon</dc:creator>
				<category><![CDATA[Business Intelligence]]></category>
		<category><![CDATA[General Knowledge]]></category>
		<category><![CDATA[Services]]></category>
		<category><![CDATA[email]]></category>
		<category><![CDATA[email marketing]]></category>
		<category><![CDATA[html email]]></category>
		<category><![CDATA[newsletter]]></category>

		<guid isPermaLink="false">http://www.trustyourtechnologist.com/?p=537</guid>
		<description><![CDATA[For some, email marketing is a golden opportunity to reach numerous customers, increase brand recognition and cross-sell many different things. However, for others, email marketing is﻿ a bear; they get less than desirable results and have no idea how to improve their reach. My aim is to expose some simple guidelines to improve your email [...]]]></description>
			<content:encoded><![CDATA[<p>For some, email marketing is a golden opportunity to reach numerous customers, increase brand recognition and cross-sell many different things. However, for others, email marketing is﻿ a bear; they get less than desirable results and have no idea how to improve their reach. My aim is to expose some simple guidelines to improve your email marketing campaigns. Even though some may seem obvious, many of these tips are often overlooked, resulting in email newsletters that simply don&#8217;t get the job done.</p>
<p><img class="alignnone size-full wp-image-569" title="email" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/08/email.jpg" alt="" width="400" height="191" /></p>
<p><span id="more-537"></span></p>
<h3>Keep the message short &amp; concise</h3>
<p>There&#8217;s nothing more daunting then getting a long, drawn out email that doesn&#8217;t get to the point and conceals the overall goal of the message at hand. Why muddle your marketing campaign with non–essential fluff, if all it does is detract the user from your goals? By keeping your message short, simple and easy to scan, it is more likely that a user will find the benefits, important message or whatever your promoting.</p>
<div id="attachment_546" class="wp-caption alignnone" style="width: 246px"><a href="http://www.trustyourtechnologist.com/wp-content/uploads/2010/08/37.jpg" target="_blank"><img class="size-full wp-image-546 " title="37-t" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/08/37-t.jpg" alt="" width="236" height="250" /></a><p class="wp-caption-text">37 Signals Newsletters get right down to the point.</p></div>
<h3>If Possible, Personalize</h3>
<p>Instead of a generic &#8220;Dear Subscriber&#8221; or &#8220;Hello Sir/Madam&#8221; to open your message, why not use the first name of the person being addressed? Most email clients today allow you to include some type of code snippet that will search for that person&#8217;s name and apply it. This will create a more personal feel, inviting the user to read your content and hopefully click on your call to action.</p>
<h3>Send on a Schedule and Amount</h3>
<p>Most, if not all email software will allow messages to be sent at a specific date and time (usually down to the second); with that in mind, considering things like users time zones, day of the week and time of day are all important. For example &#8211; if you are on the east coast, but a majority of users are on the west coast, you wouldn&#8217;t want to send your message at 8AM, as west coast users would get it at 5AM. By the time they get to their email in the morning, your message will likely be buried.</p>
<p>Along the same lines, considering your message volume is an important factor. Too many messages in a period of time and it&#8217;s likely that you will be flagged as spam; too little and the message will probably will get discarded before it&#8217;s even read.</p>
<h3>Use a smart Subject Line</h3>
<p>Subject Lines are like the worm in fishing &#8211; they are the first thing seen by a user when your email comes through. If it doesn&#8217;t look enticing, the user won&#8217;t bite and will swim right past it. Keeping that in mind, getting to the point is critical in the subject — it will make the user decide whether they want to open your message or not. Also, steer clear of spam-like keywords, such as &#8220;Free&#8221;, &#8220;Discount&#8221; and &#8220;Promotion&#8221;, as your message will most likely get routed to the Junk folder before it reaches the inbox.</p>
<h3>Provide Something Useful</h3>
<p>In every email that you send, you need to provide something useful to the user. If anything else, it shows the user that you care about them and are willing to satisfy them. If you don&#8217;t give them anything besides another message in their inbox, they might consider it useless to keep getting your marketing. Things like a discount for a product or a free e-book can help garner some attention from your users.</p>
<div id="attachment_548" class="wp-caption alignnone" style="width: 316px"><a href="http://www.trustyourtechnologist.com/wp-content/uploads/2010/08/nb.jpg" target="_blank"><img class="size-full wp-image-548 " title="nb-t" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/08/nb-t.jpg" alt="" width="306" height="250" /></a><p class="wp-caption-text">New Balance provides a button to download a piece of free software right from their newsletter.</p></div>
<h3>Always provide an Unsubscribe Link &amp; Contact Information</h3>
<p>Not only is this information required by the <a href="http://www.ftc.gov/bcp/edu/pubs/business/ecommerce/bus61.shtm">CAN-SPAM Act</a> (see numbers 4 and 5), it&#8217;s just good practice to give your users options and to give them another way of contacting you. Again, doing this shows that you care about the user, which provides a more personal feel.</p>
<h3>Incorporate Social Media Links</h3>
<p>By now, you know the buzz surrounding social media and what it can do for your business if used properly. Putting your email marketing to good use, you can link back to your Facebook, Twitter, Youtube, etc. accounts, generate some talk between users and provide yet another way of communication. All you need is a few icons strategically placed in your message and you should see some feedback.</p>
<div id="attachment_539" class="wp-caption alignnone" style="width: 305px"><a href="http://www.trustyourtechnologist.com/wp-content/uploads/2010/08/bb.jpg"></a><a href="http://www.trustyourtechnologist.com/wp-content/uploads/2010/08/bb.jpg" target="_blank"><img class="size-full wp-image-540  " title="bb-t" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/08/bb-t.jpg" alt="" width="295" height="250" /></a><p class="wp-caption-text">Bride Buzz encorporates a couple social media links in their newsletters.</p></div>
<h2>Design Considerations</h2>
<p>Now that we&#8217;ve covered some technical guidelines, here are a few design related tips that will ensure you reach a maximum number of users.</p>
<h3>Stay skinny!</h3>
<p>It&#8217;s fairly common that users will have some sort of preview pane to view their messages before opening them in a new window. Typically, these preview panes are less than half the size of a normal window, drastically reducing the amount of screen real estate available to view your message. If you keep your email design skinny, with the important information to the left portion of the message, there is a better chance of that content being seen even if the message never gets opened in a full sized window.</p>
<h3>Keep your images to a minimum</h3>
<p>Likewise, images are typically turned off by default in most email clients. Because of this, you should keep important text (dates, times, call to actions) as just that – text. If that important text is not displayed because images are turned off, a user might not get a chance to see your “message” in the email. Also, another important consideration is load time. If you have just a few images, the user won&#8217;t have to wait for them to load and can get on to reading your email faster.</p>
<div id="attachment_543" class="wp-caption alignnone" style="width: 257px"><a href="http://www.trustyourtechnologist.com/wp-content/uploads/2010/08/sunny.jpg" target="_blank"><img class="size-full wp-image-543 " title="sunny-t" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/08/sunny-t.jpg" alt="" width="247" height="250" /></a><p class="wp-caption-text">Sunny Thinking uses just a few images to accompany the main message.</p></div>
<h3>Brand Consistently</h3>
<p>Using the same types of graphics, colors and fonts, whether it be on your website, direct advertisements or email campaigns, will keep brand consistency at a maximum. Keeping an email design in line with the website design will create a seamless, polished and enjoyable experience for the viewer, hopefully increasing their trust in your brand.</p>
<p>While some of these tips may seem like common sense, more times than not, we see even the most basic tips go unnoticed. However, by taking a few minutes to include a few of these tips, you should see increased click throughs, better response and less bounces.<strong> </strong></p>
<p><em><strong>Do you have any more tips to add to the list</strong>?</em></p>
Share and Enjoy:<a rel='nofollow' target='_blank'  href='http://www.printfriendly.com/print?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fquick-fire-tips-for-effective-email-marketing%2F&amp;partner=sociable'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/printfriendly.png' class='sociable-img sociable-hovers ' title='Print' alt='Print' /></a><a rel='nofollow' target='_blank'  href='mailto:?subject=Quick%20Fire%20Tips%20for%20Effective%20Email%20Marketing&amp;body=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fquick-fire-tips-for-effective-email-marketing%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/email_link.png' class='sociable-img sociable-hovers ' title='email' alt='email' /></a><a rel='nofollow' target='_blank'  href='http://www.trustyourtechnologist.com/index.php/feed/'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/rss.png' class='sociable-img sociable-hovers ' title='RSS' alt='RSS' /></a><a rel='nofollow' target='_blank'  href='http://www.facebook.com/share.php?u=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fquick-fire-tips-for-effective-email-marketing%2F&amp;t=Quick%20Fire%20Tips%20for%20Effective%20Email%20Marketing'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/facebook.png' class='sociable-img sociable-hovers ' title='Facebook' alt='Facebook' /></a><a rel='nofollow' target='_blank'  href='http://twitter.com/home?status=Quick%20Fire%20Tips%20for%20Effective%20Email%20Marketing%20-%20http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fquick-fire-tips-for-effective-email-marketing%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/twitter.png' class='sociable-img sociable-hovers ' title='Twitter' alt='Twitter' /></a><a rel='nofollow' target='_blank'  href='http://www.linkedin.com/shareArticle?mini=true&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fquick-fire-tips-for-effective-email-marketing%2F&amp;title=Quick%20Fire%20Tips%20for%20Effective%20Email%20Marketing&amp;source=Trust+Your+Technologist+Software+with+coffee+and+art...&amp;summary=For%20some%2C%20email%20marketing%20is%20a%20golden%20opportunity%20to%20reach%20numerous%20customers%2C%20increase%20brand%20recognition%20and%20cross-sell%20many%20different%20things.%20However%2C%20for%20others%2C%20email%20marketing%20is%EF%BB%BF%20a%20bear%3B%20they%20get%20less%20than%20desirable%20results%20and%20have%20no%20idea%20h'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/linkedin.png' class='sociable-img sociable-hovers ' title='LinkedIn' alt='LinkedIn' /></a><a rel='nofollow' target='_blank'  href='http://digg.com/submit?phase=2&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fquick-fire-tips-for-effective-email-marketing%2F&amp;title=Quick%20Fire%20Tips%20for%20Effective%20Email%20Marketing&amp;bodytext=For%20some%2C%20email%20marketing%20is%20a%20golden%20opportunity%20to%20reach%20numerous%20customers%2C%20increase%20brand%20recognition%20and%20cross-sell%20many%20different%20things.%20However%2C%20for%20others%2C%20email%20marketing%20is%EF%BB%BF%20a%20bear%3B%20they%20get%20less%20than%20desirable%20results%20and%20have%20no%20idea%20h'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/digg.png' class='sociable-img sociable-hovers ' title='Digg' alt='Digg' /></a><a rel='nofollow' target='_blank'  href='http://www.stumbleupon.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fquick-fire-tips-for-effective-email-marketing%2F&amp;title=Quick%20Fire%20Tips%20for%20Effective%20Email%20Marketing'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/stumbleupon.png' class='sociable-img sociable-hovers ' title='StumbleUpon' alt='StumbleUpon' /></a><a rel='nofollow' target='_blank'  href='http://delicious.com/post?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fquick-fire-tips-for-effective-email-marketing%2F&amp;title=Quick%20Fire%20Tips%20for%20Effective%20Email%20Marketing&amp;notes=For%20some%2C%20email%20marketing%20is%20a%20golden%20opportunity%20to%20reach%20numerous%20customers%2C%20increase%20brand%20recognition%20and%20cross-sell%20many%20different%20things.%20However%2C%20for%20others%2C%20email%20marketing%20is%EF%BB%BF%20a%20bear%3B%20they%20get%20less%20than%20desirable%20results%20and%20have%20no%20idea%20h'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/delicious.png' class='sociable-img sociable-hovers ' title='del.icio.us' alt='del.icio.us' /></a><a rel='nofollow' target='_blank'  href='http://reddit.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fquick-fire-tips-for-effective-email-marketing%2F&amp;title=Quick%20Fire%20Tips%20for%20Effective%20Email%20Marketing'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/reddit.png' class='sociable-img sociable-hovers ' title='Reddit' alt='Reddit' /></a><a rel='nofollow' target='_blank'  href='http://www.google.com/reader/link?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fquick-fire-tips-for-effective-email-marketing%2F&amp;title=Quick%20Fire%20Tips%20for%20Effective%20Email%20Marketing&amp;srcURL=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fquick-fire-tips-for-effective-email-marketing%2F&amp;srcTitle=Trust+Your+Technologist+Software+with+coffee+and+art...'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/googlebuzz.png' class='sociable-img sociable-hovers ' title='Google Buzz' alt='Google Buzz' /></a><a rel='nofollow' target='_blank'  href='http://technorati.com/faves?add=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fquick-fire-tips-for-effective-email-marketing%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/technorati.png' class='sociable-img sociable-hovers ' title='Technorati' alt='Technorati' /></a><br/><br/>]]></content:encoded>
			<wfw:commentRss>http://www.trustyourtechnologist.com/index.php/2010/08/quick-fire-tips-for-effective-email-marketing/feed/</wfw:commentRss>
		<slash:comments>3</slash:comments>
		</item>
		<item>
		<title>Encrypt Data Across Multiple Operating Systems Using TrueCrypt</title>
		<link>http://www.trustyourtechnologist.com/index.php/2010/08/encrypt-data-across-multiple-operating-systems-using-truecrypt/</link>
		<comments>http://www.trustyourtechnologist.com/index.php/2010/08/encrypt-data-across-multiple-operating-systems-using-truecrypt/#comments</comments>
		<pubDate>Thu, 12 Aug 2010 13:26:43 +0000</pubDate>
		<dc:creator>Shazad</dc:creator>
				<category><![CDATA[General Knowledge]]></category>
		<category><![CDATA[AES]]></category>
		<category><![CDATA[data]]></category>
		<category><![CDATA[encryption]]></category>
		<category><![CDATA[Linux]]></category>
		<category><![CDATA[mac]]></category>
		<category><![CDATA[on-the-fly]]></category>
		<category><![CDATA[security]]></category>
		<category><![CDATA[TrueCrypt]]></category>
		<category><![CDATA[volumes]]></category>

		<guid isPermaLink="false">http://www.trustyourtechnologist.com/?p=522</guid>
		<description><![CDATA[Data encryption and security is a serious concern for business and personal computer use. TrueCrypt is free data encryption software that can encrypt volumes on either an individual partition or an entire storage device. It is supported on Windows 7, Vista, XP, Mac OS X and Linux. In TrueCrypt, there are three different options for [...]]]></description>
			<content:encoded><![CDATA[<p>Data encryption and security is a serious concern for business and personal computer use. TrueCrypt is free data encryption software that can encrypt volumes on either an individual partition or an entire storage device. It is supported on Windows 7, Vista, XP, Mac OS X and Linux.</p>
<p>In TrueCrypt, there are three different options for Volume Creation.The first option is to create an encrypted file which can be mounted and used as a drive. The file created by using this method can be copied and emailed or moved to a different space and still retain its encryption. The second option is to encrypt a non-system partition or drive like a flash drive or other external storage device. The last option is the same as the second option except it requires the user to enter a password before the OS boots to fully protect the encrypted files. This option can only encrypt Windows XP, 2003, 2008, Vista and Windows 7 operating systems.<br />
<span id="more-522"></span></p>
<p><a rel="attachment wp-att-525" href="http://www.trustyourtechnologist.com/index.php/2010/08/encrypt-data-across-multiple-operating-systems-using-truecrypt/figure-1/"><img class="aligncenter size-full wp-image-525" title="Figure 1" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/08/Figure-1.png" alt="" width="396" height="245" /></a></p>
<p>Once a user chooses which TrueCrypt Volume to use, there are two more options: standard or hidden. Standard is very basic and only requires one password. Hidden TrueCrypt volume requires two passwords, one for the hidden partition and another for the non-hidden partition. The only downside to using a hidden partition is if the user fills all of the space on the non-hidden partition, the space on the hidden partition will be overwritten to make space for the non-hidden partition. However, this can be prevented by using the mount option “Protect hidden volume against damage caused by writing to outer volume.”</p>
<p>TrueCrypt uses three different encryption algorithms with five different combinations available. The three algorithms used are AES, Serpent and Twofish. Each encryption can be benchmarked and tested to see which is the right option for your needs. Any option with AES is a good choice because AES is the standard encryption used by the US Federal government, the NSA and the National Institute of Standards and Technology (NIST) among a number of other corporations. Version 7.0 introduced hardware-accelerated AES which takes advantage of Intel’s Westmere-based processors new set of instructions that provide over three times the encryption and decryption rate of AES.</p>
<p><a rel="attachment wp-att-526" href="http://www.trustyourtechnologist.com/index.php/2010/08/encrypt-data-across-multiple-operating-systems-using-truecrypt/figure-2/"><img class="aligncenter size-full wp-image-526" title="Figure 2" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/08/Figure-2.png" alt="" width="405" height="250" /></a></p>
<p>TrueCrypt currently uses the XTS mode which is more secure than Cipher-block chaining (CBC) mode. XTS is based on Xor-Encrypt-Xor (XEX) with a Tweaked CodeBook (TCB) and CipherText Stealing (CTS). The NIST recommended XTS-AES mode for confidentiality on storage devices in a <a href="http://csrc.nist.gov/publications/nistpubs/800-38E/nist-sp-800-38E.pdf">special report from January of 2010</a>. In that report the organization says</p>
<blockquote><p><em>“The XTS-AES mode provides confidentiality for the protected data.  Authentication is not provided, because the P1619 Task Group designed XTS-AES to provide encryption without data expansion, so alternative cryptographic methods that incorporate an authentication tag are precluded.  In the absence of authentication or access control, XTS-AES provides more protection than the other approved confidentiality-only modes against unauthorized manipulation of the encrypted data.”</em></p></blockquote>
<p>The crypto hash functions used by TrueCrypt are RIPEMD-160, SHA-512 and Whirlpool.  RIPEMD-160 (RACE Integrity Primitives Evaluation Message Digest) is a 160-bit message digest algorithm developed in Leuven, Belgium.  SHA-512 was designed by the National Security Agency (NSA) and published in 2001 by the NIST as part of SHA-2 set of cryptographic hash functions.  Whirlpool was designed by Vincent Rijmen (co-creator of AES) and Paulo S. L. M. Barreto. Out of the three, SHA-512 seems to be the most popular hash function.</p>
<p>TrueCrypt can also protect your files without requiring the use of a password by using keyfiles. A user can chose to use keyfiles in combination with a password or just one or the other. The keyfile could be security tokens, smart cards, a generated file or a random file off the computer such as an mp3 file. You can select more than one file to be used as your keyfile. If you have multiple keyfiles, the order doesn’t matter. Using keyfiles is beneficial in defending against brute-force attacks on a password.</p>
<p><a rel="attachment wp-att-524" href="http://www.trustyourtechnologist.com/index.php/2010/08/encrypt-data-across-multiple-operating-systems-using-truecrypt/figure-3/"><img class="aligncenter size-full wp-image-524" title="Figure 3" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/08/Figure-3.png" alt="" width="420" height="259" /></a></p>
<p>Another great feature of TrueCrypt is the creation of a rescue disk. Once a user encrypts a system partition or drive, TrueCrypt requires that you create a TrueCrypt Rescue Disk. This assists the user in repairing the boot loader if it gets damaged or data is corrupted. It’s a good idea to always make a rescue disk because you never know what can happen once your data is encrypted and this system allows you to retrieve some data so all is not lost if a hard drive goes bad or is infected with malware.</p>
<p style="text-align: left;">The process to un-encrypt your files, partition or drive is a simple one. First you need to locate the encrypted volume. Next select the drive you want it mounted as. Then type your password and/or use your keyfiles and click “Mount.” When you’re finished, the file that is written to the drive will be encrypted on-the-file. If you have an OS encrypted partition or drive you can only un-encrypt at boot up or from a rescue disk.</p>
<p style="text-align: center;"><a rel="attachment wp-att-523" href="http://www.trustyourtechnologist.com/index.php/2010/08/encrypt-data-across-multiple-operating-systems-using-truecrypt/figure-4/"><img class="size-full wp-image-523 aligncenter" title="Figure 4" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/08/Figure-4.png" alt="" width="380" height="326" /></a></p>
<p>TrueCrypt is a great piece of free software that works across multiple OS. The feature that I found to stand out the most was the encrypted file container.  TrueCrypt just might give Bitlocker and other disk encryption software a run for their money.</p>
Share and Enjoy:<a rel='nofollow' target='_blank'  href='http://www.printfriendly.com/print?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fencrypt-data-across-multiple-operating-systems-using-truecrypt%2F&amp;partner=sociable'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/printfriendly.png' class='sociable-img sociable-hovers ' title='Print' alt='Print' /></a><a rel='nofollow' target='_blank'  href='mailto:?subject=Encrypt%20Data%20Across%20Multiple%20Operating%20Systems%20Using%20TrueCrypt&amp;body=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fencrypt-data-across-multiple-operating-systems-using-truecrypt%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/email_link.png' class='sociable-img sociable-hovers ' title='email' alt='email' /></a><a rel='nofollow' target='_blank'  href='http://www.trustyourtechnologist.com/index.php/feed/'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/rss.png' class='sociable-img sociable-hovers ' title='RSS' alt='RSS' /></a><a rel='nofollow' target='_blank'  href='http://www.facebook.com/share.php?u=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fencrypt-data-across-multiple-operating-systems-using-truecrypt%2F&amp;t=Encrypt%20Data%20Across%20Multiple%20Operating%20Systems%20Using%20TrueCrypt'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/facebook.png' class='sociable-img sociable-hovers ' title='Facebook' alt='Facebook' /></a><a rel='nofollow' target='_blank'  href='http://twitter.com/home?status=Encrypt%20Data%20Across%20Multiple%20Operating%20Systems%20Using%20TrueCrypt%20-%20http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fencrypt-data-across-multiple-operating-systems-using-truecrypt%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/twitter.png' class='sociable-img sociable-hovers ' title='Twitter' alt='Twitter' /></a><a rel='nofollow' target='_blank'  href='http://www.linkedin.com/shareArticle?mini=true&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fencrypt-data-across-multiple-operating-systems-using-truecrypt%2F&amp;title=Encrypt%20Data%20Across%20Multiple%20Operating%20Systems%20Using%20TrueCrypt&amp;source=Trust+Your+Technologist+Software+with+coffee+and+art...&amp;summary=Data%20encryption%20and%20security%20is%20a%20serious%20concern%20for%20business%20and%20personal%20computer%20use.%20TrueCrypt%20is%20free%20data%20encryption%20software%20that%20can%20encrypt%20volumes%20on%20either%20an%20individual%20partition%20or%20an%20entire%20storage%20device.%20It%20is%20supported%20on%20Windows%207%2C'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/linkedin.png' class='sociable-img sociable-hovers ' title='LinkedIn' alt='LinkedIn' /></a><a rel='nofollow' target='_blank'  href='http://digg.com/submit?phase=2&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fencrypt-data-across-multiple-operating-systems-using-truecrypt%2F&amp;title=Encrypt%20Data%20Across%20Multiple%20Operating%20Systems%20Using%20TrueCrypt&amp;bodytext=Data%20encryption%20and%20security%20is%20a%20serious%20concern%20for%20business%20and%20personal%20computer%20use.%20TrueCrypt%20is%20free%20data%20encryption%20software%20that%20can%20encrypt%20volumes%20on%20either%20an%20individual%20partition%20or%20an%20entire%20storage%20device.%20It%20is%20supported%20on%20Windows%207%2C'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/digg.png' class='sociable-img sociable-hovers ' title='Digg' alt='Digg' /></a><a rel='nofollow' target='_blank'  href='http://www.stumbleupon.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fencrypt-data-across-multiple-operating-systems-using-truecrypt%2F&amp;title=Encrypt%20Data%20Across%20Multiple%20Operating%20Systems%20Using%20TrueCrypt'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/stumbleupon.png' class='sociable-img sociable-hovers ' title='StumbleUpon' alt='StumbleUpon' /></a><a rel='nofollow' target='_blank'  href='http://delicious.com/post?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fencrypt-data-across-multiple-operating-systems-using-truecrypt%2F&amp;title=Encrypt%20Data%20Across%20Multiple%20Operating%20Systems%20Using%20TrueCrypt&amp;notes=Data%20encryption%20and%20security%20is%20a%20serious%20concern%20for%20business%20and%20personal%20computer%20use.%20TrueCrypt%20is%20free%20data%20encryption%20software%20that%20can%20encrypt%20volumes%20on%20either%20an%20individual%20partition%20or%20an%20entire%20storage%20device.%20It%20is%20supported%20on%20Windows%207%2C'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/delicious.png' class='sociable-img sociable-hovers ' title='del.icio.us' alt='del.icio.us' /></a><a rel='nofollow' target='_blank'  href='http://reddit.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fencrypt-data-across-multiple-operating-systems-using-truecrypt%2F&amp;title=Encrypt%20Data%20Across%20Multiple%20Operating%20Systems%20Using%20TrueCrypt'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/reddit.png' class='sociable-img sociable-hovers ' title='Reddit' alt='Reddit' /></a><a rel='nofollow' target='_blank'  href='http://www.google.com/reader/link?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fencrypt-data-across-multiple-operating-systems-using-truecrypt%2F&amp;title=Encrypt%20Data%20Across%20Multiple%20Operating%20Systems%20Using%20TrueCrypt&amp;srcURL=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fencrypt-data-across-multiple-operating-systems-using-truecrypt%2F&amp;srcTitle=Trust+Your+Technologist+Software+with+coffee+and+art...'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/googlebuzz.png' class='sociable-img sociable-hovers ' title='Google Buzz' alt='Google Buzz' /></a><a rel='nofollow' target='_blank'  href='http://technorati.com/faves?add=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fencrypt-data-across-multiple-operating-systems-using-truecrypt%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/technorati.png' class='sociable-img sociable-hovers ' title='Technorati' alt='Technorati' /></a><br/><br/>]]></content:encoded>
			<wfw:commentRss>http://www.trustyourtechnologist.com/index.php/2010/08/encrypt-data-across-multiple-operating-systems-using-truecrypt/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Google and Verizon Take a Positive Step Toward Net Neutrality</title>
		<link>http://www.trustyourtechnologist.com/index.php/2010/08/google-and-verizon-take-a-positive-step-towards-net-neutrality/</link>
		<comments>http://www.trustyourtechnologist.com/index.php/2010/08/google-and-verizon-take-a-positive-step-towards-net-neutrality/#comments</comments>
		<pubDate>Mon, 09 Aug 2010 19:24:16 +0000</pubDate>
		<dc:creator>Stephanie</dc:creator>
				<category><![CDATA[General Knowledge]]></category>
		<category><![CDATA[FCC]]></category>
		<category><![CDATA[Google]]></category>
		<category><![CDATA[ISPs]]></category>
		<category><![CDATA[net neutrality]]></category>
		<category><![CDATA[Verizon]]></category>

		<guid isPermaLink="false">http://www.trustyourtechnologist.com/?p=508</guid>
		<description><![CDATA[Late last week reports were circulating that Google and Verizon were in secret talks regarding net neutrality. It appears today that those reports were half right. They have been involved in private meetings trying to reach an agreement but their goal according to a joint announcement today is actually for net neutrality. It all started [...]]]></description>
			<content:encoded><![CDATA[<p>Late last week reports were circulating that <a href="http://mashable.com/2010/08/05/google-verizon-net-neutrality/">Google and Verizon were in secret talks regarding net neutrality</a>. It appears today that those reports were half right. They have been involved in private meetings trying to reach an agreement but their goal according to a joint announcement today is actually <em>for </em><a href="http://www.trustyourtechnologist.com/index.php/2010/07/debate-over-net-neutrality/">net neutrality</a>.</p>
<p>It all started when <a href="http://www.nytimes.com/2010/08/05/technology/05secret.html?pagewanted=2&amp;_r=3&amp;ref=technology">the New York Times published an article</a> alleging the two were in cahoots and attempting to work out an agreement after their group meetings with the FCC and other Internet service and content providers like AT&amp;T and Skype were getting them nowhere. It made sense that perhaps it would be in Google’s best interest to garner a deal with one of the leading ISPs in the business considering Google is one of the largest providers of content on the web and the Google owned YouTube is an easy target for ISPs claiming it slows their service to customers. But Google has been pro net neutrality since the argument began.</p>
<p><span id="more-508"></span>After b<a rel="attachment wp-att-509" href="http://www.trustyourtechnologist.com/index.php/2010/08/google-and-verizon-take-a-positive-step-towards-net-neutrality/523496_51052131/"><img class="alignright size-full wp-image-509" title="523496_51052131" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/08/523496_51052131.jpg" alt="" width="352" height="233" /></a>oth companies denied any sort of deal last week but confirmed they were talking, they announced earlier today <a href="http://www.readwriteweb.com/archives/google_verizon_propose_enforceable_net_neutrality.php">a joint effort for net neutrality</a>. The two are proposing an enforceable net neutrality agreement that provides a few basic guidelines but does not lead to “anti-competitive measures that hurt consumers.” Click the following link to view their proposal: <a href="http://www.scribd.com/doc/35599242/Verizon-Google-Legislative-Framework-Proposal">Verizon-Google Legislative Framework Proposal</a>.</p>
<p>There are still some skeptics that feel there are some ulterior motives behind Google’s and Verizon’s joint venture. Others feel there is too much room for interpretation that could lead to loopholes that fly in the face of net neutrality. Regardless of their intentions and the potential for others to engage in shady business practices, this seems to be a positive step toward net neutrality. Whether this specific proposal is actually adopted by internet service and content providers and the government remains to be seen but it is a big statement. Two of the biggest names involved on opposite sides of the debate have come together. They agree that net neutrality is a good thing and the free and open exchange of information is worth more than a few extra bucks per month to speed certain content through the internet.</p>
<p>What do you think? Is this a step in the right direction? What sort of implications will this have on the discussions being led by the FCC?</p>
Share and Enjoy:<a rel='nofollow' target='_blank'  href='http://www.printfriendly.com/print?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fgoogle-and-verizon-take-a-positive-step-towards-net-neutrality%2F&amp;partner=sociable'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/printfriendly.png' class='sociable-img sociable-hovers ' title='Print' alt='Print' /></a><a rel='nofollow' target='_blank'  href='mailto:?subject=Google%20and%20Verizon%20Take%20a%20Positive%20Step%20Toward%20Net%20Neutrality&amp;body=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fgoogle-and-verizon-take-a-positive-step-towards-net-neutrality%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/email_link.png' class='sociable-img sociable-hovers ' title='email' alt='email' /></a><a rel='nofollow' target='_blank'  href='http://www.trustyourtechnologist.com/index.php/feed/'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/rss.png' class='sociable-img sociable-hovers ' title='RSS' alt='RSS' /></a><a rel='nofollow' target='_blank'  href='http://www.facebook.com/share.php?u=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fgoogle-and-verizon-take-a-positive-step-towards-net-neutrality%2F&amp;t=Google%20and%20Verizon%20Take%20a%20Positive%20Step%20Toward%20Net%20Neutrality'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/facebook.png' class='sociable-img sociable-hovers ' title='Facebook' alt='Facebook' /></a><a rel='nofollow' target='_blank'  href='http://twitter.com/home?status=Google%20and%20Verizon%20Take%20a%20Positive%20Step%20Toward%20Net%20Neutrality%20-%20http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fgoogle-and-verizon-take-a-positive-step-towards-net-neutrality%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/twitter.png' class='sociable-img sociable-hovers ' title='Twitter' alt='Twitter' /></a><a rel='nofollow' target='_blank'  href='http://www.linkedin.com/shareArticle?mini=true&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fgoogle-and-verizon-take-a-positive-step-towards-net-neutrality%2F&amp;title=Google%20and%20Verizon%20Take%20a%20Positive%20Step%20Toward%20Net%20Neutrality&amp;source=Trust+Your+Technologist+Software+with+coffee+and+art...&amp;summary=Late%20last%20week%20reports%20were%20circulating%20that%20Google%20and%20Verizon%20were%20in%20secret%20talks%20regarding%20net%20neutrality.%20It%20appears%20today%20that%20those%20reports%20were%20half%20right.%20They%20have%20been%20involved%20in%20private%20meetings%20trying%20to%20reach%20an%20agreement%20but%20their%20goa'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/linkedin.png' class='sociable-img sociable-hovers ' title='LinkedIn' alt='LinkedIn' /></a><a rel='nofollow' target='_blank'  href='http://digg.com/submit?phase=2&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fgoogle-and-verizon-take-a-positive-step-towards-net-neutrality%2F&amp;title=Google%20and%20Verizon%20Take%20a%20Positive%20Step%20Toward%20Net%20Neutrality&amp;bodytext=Late%20last%20week%20reports%20were%20circulating%20that%20Google%20and%20Verizon%20were%20in%20secret%20talks%20regarding%20net%20neutrality.%20It%20appears%20today%20that%20those%20reports%20were%20half%20right.%20They%20have%20been%20involved%20in%20private%20meetings%20trying%20to%20reach%20an%20agreement%20but%20their%20goa'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/digg.png' class='sociable-img sociable-hovers ' title='Digg' alt='Digg' /></a><a rel='nofollow' target='_blank'  href='http://www.stumbleupon.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fgoogle-and-verizon-take-a-positive-step-towards-net-neutrality%2F&amp;title=Google%20and%20Verizon%20Take%20a%20Positive%20Step%20Toward%20Net%20Neutrality'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/stumbleupon.png' class='sociable-img sociable-hovers ' title='StumbleUpon' alt='StumbleUpon' /></a><a rel='nofollow' target='_blank'  href='http://delicious.com/post?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fgoogle-and-verizon-take-a-positive-step-towards-net-neutrality%2F&amp;title=Google%20and%20Verizon%20Take%20a%20Positive%20Step%20Toward%20Net%20Neutrality&amp;notes=Late%20last%20week%20reports%20were%20circulating%20that%20Google%20and%20Verizon%20were%20in%20secret%20talks%20regarding%20net%20neutrality.%20It%20appears%20today%20that%20those%20reports%20were%20half%20right.%20They%20have%20been%20involved%20in%20private%20meetings%20trying%20to%20reach%20an%20agreement%20but%20their%20goa'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/delicious.png' class='sociable-img sociable-hovers ' title='del.icio.us' alt='del.icio.us' /></a><a rel='nofollow' target='_blank'  href='http://reddit.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fgoogle-and-verizon-take-a-positive-step-towards-net-neutrality%2F&amp;title=Google%20and%20Verizon%20Take%20a%20Positive%20Step%20Toward%20Net%20Neutrality'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/reddit.png' class='sociable-img sociable-hovers ' title='Reddit' alt='Reddit' /></a><a rel='nofollow' target='_blank'  href='http://www.google.com/reader/link?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fgoogle-and-verizon-take-a-positive-step-towards-net-neutrality%2F&amp;title=Google%20and%20Verizon%20Take%20a%20Positive%20Step%20Toward%20Net%20Neutrality&amp;srcURL=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fgoogle-and-verizon-take-a-positive-step-towards-net-neutrality%2F&amp;srcTitle=Trust+Your+Technologist+Software+with+coffee+and+art...'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/googlebuzz.png' class='sociable-img sociable-hovers ' title='Google Buzz' alt='Google Buzz' /></a><a rel='nofollow' target='_blank'  href='http://technorati.com/faves?add=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fgoogle-and-verizon-take-a-positive-step-towards-net-neutrality%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/technorati.png' class='sociable-img sociable-hovers ' title='Technorati' alt='Technorati' /></a><br/><br/>]]></content:encoded>
			<wfw:commentRss>http://www.trustyourtechnologist.com/index.php/2010/08/google-and-verizon-take-a-positive-step-towards-net-neutrality/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Dynamic SQL</title>
		<link>http://www.trustyourtechnologist.com/index.php/2010/08/dynamic-sql/</link>
		<comments>http://www.trustyourtechnologist.com/index.php/2010/08/dynamic-sql/#comments</comments>
		<pubDate>Thu, 05 Aug 2010 18:45:44 +0000</pubDate>
		<dc:creator>Tommy</dc:creator>
				<category><![CDATA[Solutions]]></category>
		<category><![CDATA[code]]></category>
		<category><![CDATA[columns]]></category>
		<category><![CDATA[Dynamic SQL]]></category>
		<category><![CDATA[family of data]]></category>
		<category><![CDATA[selectmethod]]></category>
		<category><![CDATA[table]]></category>

		<guid isPermaLink="false">http://www.trustyourtechnologist.com/?p=443</guid>
		<description><![CDATA[While working on a project I was challenged to build a table that showed only the columns of data associated with the current family of data. The challenge was the database I was pulling from had over a hundred columns and hundreds of rows. I only wanted to show the columns associated with the products showing in the table [...]]]></description>
			<content:encoded><![CDATA[<p>While working on a project I was challenged to build a table that showed only the columns of data associated with the current family of data. The challenge was the database I was pulling from had over a hundred columns and hundreds of rows. I only wanted to show the columns associated with the products showing in the table so I needed a way to remove the unneeded columns from the table. This could be done by hiding the unneeded columns after the data was retrieved but it was time intensive to pull all the columns and then hide some of them. What I chose to do was to build the table completely during the SQL call using Dynamic <span class="SpellE">SQL </span>methods.</p>
<div class="WordSection1">
<p><span id="more-443"></span>In order to return the final table, I needed to know the name of the column and what data was stored there. In order to find the name of a column one must use the method COL_NAME; this method had two parameters: Table ID and the column index. In order for this method to work you must know the number of columns in the table. To find the number of columns in a table, call a query from <span class="SpellE">information_schema</span>:</p>
<p style="text-align: center;"><a rel="attachment wp-att-444" href="http://www.trustyourtechnologist.com/index.php/2010/08/dynamic-sql/image001/"><img class="size-full wp-image-444 aligncenter" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/image001.gif" alt="count columns" width="338" height="81" /></a></p>
<p class="MsoNormal">
<p class="MsoNormal">
<p class="MsoNormal">Now that the number of columns is known, a loop can be created to find what columns have data:</p>
<p class="MsoNormal" style="text-align: center;"><a rel="attachment wp-att-445" href="http://www.trustyourtechnologist.com/index.php/2010/08/dynamic-sql/image002/"><img class="size-full wp-image-445 aligncenter" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/image002.gif" alt="Loop get column name" width="454" height="192" /></a></p>
<p class="MsoNormal">
<p class="MsoNormal">
<p class="MsoNormal">To simply make a table that only has columns with data, the following can be run inside of the loop:</p>
<p class="MsoNormal" style="text-align: center;"><a rel="attachment wp-att-446" href="http://www.trustyourtechnologist.com/index.php/2010/08/dynamic-sql/image003/"><img class="size-full wp-image-446 aligncenter" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/image003.gif" alt="Create table 1st type" width="552" height="113" /></a><!--[if mso &amp; !supportInlineShapes &amp; supportFields]&gt;--></p>
<p class="MsoNormal">
<p class="MsoNormal">
<p class="MsoNormal">The issue with the above is when the final table is returned the column names are set and would need to be changed. To avoid having to change the column after the table is returned, I used a reference table that held the corrected names of the columns and created a selecting variable with the right columns and names:</p>
<p class="MsoNormal" style="text-align: center;"><a rel="attachment wp-att-448" href="http://www.trustyourtechnologist.com/index.php/2010/08/dynamic-sql/image004/"><img class="size-full wp-image-448 aligncenter" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/image004.gif" alt="" width="585" height="126" /></a><!--[if mso &amp; !supportInlineShapes &amp; supportFields]&gt;--></p>
<p class="MsoNormal">
<p class="MsoNormal" style="text-align: center;"><a rel="attachment wp-att-449" href="http://www.trustyourtechnologist.com/index.php/2010/08/dynamic-sql/image005/"><img class="size-full wp-image-449 aligncenter" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/image005.gif" alt="Column name change" width="585" height="257" /></a><!--[if mso &amp; !supportInlineShapes &amp; supportFields]&gt;--></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">Once all of these queries are done, the temporary table can be queried and returned:</p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; text-align: center;"><a rel="attachment wp-att-450" href="http://www.trustyourtechnologist.com/index.php/2010/08/dynamic-sql/image006/"><img class="size-full wp-image-450 aligncenter" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/image006.gif" alt="Select method" width="448" height="48" /></a></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">The final table displays only the columns that have data in them.  By using Dynamic SQL, I was able to build a list of items with only the needed information. The following is the procedure code:</p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">ALTER </span><span style="color: blue;">PROCEDURE</span> proc_MerchandiseTbl</p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">(</p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;">@MerchandiseID <span style="color: blue;">uniqueidentifier</span></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">)</p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">AS</span></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">BEGIN</span></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">CREATE </span><span style="color: blue;">TABLE</span> #tmpTbl<span style="color: gray;">(</span><span style="color: blue;"> </span></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; text-indent: .5in; line-height: normal;">.</p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-bottom: .0001pt; margin-left: .5in; line-height: normal;">.</p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-bottom: .0001pt; margin-left: .5in; line-height: normal;">.</p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">)</p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">INSERT </span><span style="color: blue;">INTO</span> #tmpTbl<span style="color: blue;"> </span><span style="color: gray;">(</span></p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-bottom: .0001pt; margin-left: .5in; line-height: normal;">.</p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-bottom: .0001pt; margin-left: .5in; line-height: normal;">.</p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-bottom: .0001pt; margin-left: .5in; line-height: normal;">.</p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">)</p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">SELECT </span><span style="color: gray;">*<br />
</span><span style="color: #0000ff;">FROM </span>[Merchandise]<br />
<span style="color: #0000ff;">WHERE</span>([MerchandiseID] <span style="color: gray;">=</span> @MerchandiseID<span style="color: gray;">)</span></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">CREATE </span><span style="color: blue;">TABLE</span> #currentItem<span style="color: gray;">(</span>[CurrentItem] [nvarchar]<span style="color: gray;">(</span>4000<span style="color: gray;">)</span><span style="color: gray;"> </span><span style="color: gray;">NULL)</span></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">DECLARE </span>@i <span style="color: blue;">int</span></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">DECLARE </span>@count <span style="color: blue;">int</span></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">DECLARE </span>@colName <span style="color: blue;">nvarchar</span><span style="color: gray;">(</span>1000<span style="color: gray;">)</span></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">DECLARE</span> @current <span style="color: blue;">nvarchar</span><span style="color: gray;">(</span>1000<span style="color: gray;">)</span></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">DECLARE </span>@selectMethod <span style="color: blue;">nvarchar</span><span style="color: gray;">(</span>4000<span style="color: gray;">)</span></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">DECLARE </span>@header <span style="color: blue;">nvarchar</span><span style="color: gray;">(</span>1000<span style="color: gray;">)</span></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">SET </span>@selectMethod <span style="color: gray;">=</span> <span style="color: red;">&#8221;</span></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">SELECT </span>@count <span style="color: gray;">=</span> <span style="color: fuchsia;">COUNT</span><span style="color: gray;">(*)<br />
<span style="color: #000000;"><span style="color: #0000ff;">FROM </span><span style="color: green;">information_schema</span><span style="color: gray;">.</span><span style="color: green;">columns<br />
</span></span></span><span style="color: #0000ff;">WHERE </span>table_name <span style="color: gray;">=</span> &#8216;Merchandise&#8217;</p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">SET </span>@i <span style="color: gray;">=</span> 1</p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;"><span style="color: #0000ff;">WHILE </span>(@i <span style="color: gray;">&lt;=</span> @count<span style="color: gray;">)<br />
</span><span style="color: #0000ff;">BEGIN<br />
</span><span style="color: #0000ff;">SELECT </span>@colName <span style="color: gray;">= </span><span style="color: fuchsia;">COL_NAME</span><span style="color: gray;">(</span><span style="color: fuchsia;">OBJECT_ID</span><span style="color: gray;">(</span><span style="color: red;">&#8216;Merchandise&#8217;</span><span style="color: gray;">),</span>@i<span style="color: gray;">)</span></p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;"><span style="color: #0000ff;">EXECUTE</span>(&#8216;<span style="color: #ff0000;">DECLARE<br />
</span><span style="color: #ff0000;">@LocalCurrent nvarchar(1000)SELECT<br />
</span><span style="color: #ff0000;">TOP(1) @LocalCurrent = &#8216; </span><span style="color: #000000;">+</span><span style="color: #000000;"> @colName </span><span style="color: #000000;">+</span><span style="color: #ff0000;"> </span><span style="color: #ff0000;">&#8216; FROM #tmpTbl<br />
</span><span style="color: #ff0000;">INSERT </span><span style="color: #ff0000;">INTO #currentItem VALUES(@LocalCurrent)</span>&#8216;)</p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;">
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;"><span style="color: #0000ff;">SELECT</span> <span style="color: blue;">TOP</span><span style="color: gray;">(</span>1<span style="color: gray;">)</span>@current <span style="color: gray;">=</span> [CurrentItem] <span style="color: blue;">FROM </span>#currentItem</p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;"><span style="color: #0000ff;">DELETE </span><span style="color: #0000ff;">FROM </span>#currentItem</p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;">
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;"><span style="color: #0000ff;">IF</span> @current <span style="color: gray;">IS </span><span style="color: gray;">NOT</span> <span style="color: gray;">NULL</span></p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;"><span style="color: #0000ff;">BEGIN</span></p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 60px;"><span style="color: #0000ff;">SELECT </span>@header <span style="color: gray;">= </span>SpecName<br />
<span style="color: #0000ff;">FROM </span>Specifications<br />
<span style="color: #0000ff;">WHERE </span>SpecField <span style="color: gray;">= </span>@colName</p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;"><span style="color: #0000ff;">END</span></p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;">
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;"><span style="color: #0000ff;">IF </span>@i <span style="color: gray;">&gt; </span>1</p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;"><span style="color: #0000ff;">BEGIN</span></p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 60px;"><span style="color: #0000ff;">SET </span>@selectMethod <span style="color: gray;">=</span> @selectMethod <span style="color: gray;">+</span> <span style="color: red;">&#8216;, &#8216;</span></p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;"><span style="color: #0000ff;">END</span></p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;"><span style="color: #0000ff;">SET </span>@selectMethod <span style="color: gray;">=</span> @selectMethod <span style="color: gray;">+</span> <span style="color: fuchsia;">QUOTENAME</span><span style="color: gray;">(</span>@colName<span style="color: gray;">)</span></p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;"><span style="color: #0000ff;">IF </span>@header <span style="color: gray;">IS </span><span style="color: gray;">NOT</span> <span style="color: gray;">NULL</span></p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;"><span style="color: #0000ff;">BEGIN</span></p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 60px;"><span style="color: #0000ff;">SET </span>@selectMethod <span style="color: gray;">=</span> @selectMethod <span style="color: gray;">+</span> <span style="color: red;">&#8216; &#8220;&#8216; </span><span style="color: gray;">+</span> @header <span style="color: gray;">+</span> <span style="color: red;">&#8216;&#8221;&#8216;</span></p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 60px;"><span style="color: blue;">SET</span> @header <span style="color: gray;">=</span> <span style="color: gray;">NULL</span></p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;"><span style="color: #0000ff;">END </span></p>
<p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal; padding-left: 30px;"><span style="color: #0000ff;">SET </span>@i <span style="color: gray;">=</span> @i <span style="color: gray;">+</span> 1<span style="color: gray;">;</span><span style="color: blue;"> </span></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">END</span></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">EXECUTE</span>(&#8216;<span style="color: #ff0000;">Select&#8217;</span> <span style="color: gray;">+</span> @selectMethod <span style="color: gray;">+</span><span style="color: gray;"> </span><span style="color: red;">&#8216; FROM #tmpTbl&#8217;</span><span style="color: gray;">)</span></p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">DROP </span><span style="color: blue;">TABLE</span> #tmpTbl</p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">DROP </span><span style="color: blue;">TABLE</span> #currentItem</p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;">
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">RETURN </span>0</p>
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="color: #0000ff;">END</span></p>
</div>
Share and Enjoy:<a rel='nofollow' target='_blank'  href='http://www.printfriendly.com/print?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fdynamic-sql%2F&amp;partner=sociable'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/printfriendly.png' class='sociable-img sociable-hovers ' title='Print' alt='Print' /></a><a rel='nofollow' target='_blank'  href='mailto:?subject=Dynamic%20SQL&amp;body=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fdynamic-sql%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/email_link.png' class='sociable-img sociable-hovers ' title='email' alt='email' /></a><a rel='nofollow' target='_blank'  href='http://www.trustyourtechnologist.com/index.php/feed/'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/rss.png' class='sociable-img sociable-hovers ' title='RSS' alt='RSS' /></a><a rel='nofollow' target='_blank'  href='http://www.facebook.com/share.php?u=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fdynamic-sql%2F&amp;t=Dynamic%20SQL'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/facebook.png' class='sociable-img sociable-hovers ' title='Facebook' alt='Facebook' /></a><a rel='nofollow' target='_blank'  href='http://twitter.com/home?status=Dynamic%20SQL%20-%20http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fdynamic-sql%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/twitter.png' class='sociable-img sociable-hovers ' title='Twitter' alt='Twitter' /></a><a rel='nofollow' target='_blank'  href='http://www.linkedin.com/shareArticle?mini=true&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fdynamic-sql%2F&amp;title=Dynamic%20SQL&amp;source=Trust+Your+Technologist+Software+with+coffee+and+art...&amp;summary=While%20working%20on%20a%20project%20I%20was%20challenged%20to%20build%20a%20table%20that%20showed%20only%20the%20columns%20of%20data%20associated%20with%20the%20current%20family%20of%C2%A0data.%20The%20challenge%20was%20the%C2%A0database%20I%20was%20pulling%20from%20had%20over%20a%20hundred%20columns%20and%20hundreds%20of%C2%A0rows.%20I%20only'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/linkedin.png' class='sociable-img sociable-hovers ' title='LinkedIn' alt='LinkedIn' /></a><a rel='nofollow' target='_blank'  href='http://digg.com/submit?phase=2&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fdynamic-sql%2F&amp;title=Dynamic%20SQL&amp;bodytext=While%20working%20on%20a%20project%20I%20was%20challenged%20to%20build%20a%20table%20that%20showed%20only%20the%20columns%20of%20data%20associated%20with%20the%20current%20family%20of%C2%A0data.%20The%20challenge%20was%20the%C2%A0database%20I%20was%20pulling%20from%20had%20over%20a%20hundred%20columns%20and%20hundreds%20of%C2%A0rows.%20I%20only'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/digg.png' class='sociable-img sociable-hovers ' title='Digg' alt='Digg' /></a><a rel='nofollow' target='_blank'  href='http://www.stumbleupon.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fdynamic-sql%2F&amp;title=Dynamic%20SQL'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/stumbleupon.png' class='sociable-img sociable-hovers ' title='StumbleUpon' alt='StumbleUpon' /></a><a rel='nofollow' target='_blank'  href='http://delicious.com/post?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fdynamic-sql%2F&amp;title=Dynamic%20SQL&amp;notes=While%20working%20on%20a%20project%20I%20was%20challenged%20to%20build%20a%20table%20that%20showed%20only%20the%20columns%20of%20data%20associated%20with%20the%20current%20family%20of%C2%A0data.%20The%20challenge%20was%20the%C2%A0database%20I%20was%20pulling%20from%20had%20over%20a%20hundred%20columns%20and%20hundreds%20of%C2%A0rows.%20I%20only'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/delicious.png' class='sociable-img sociable-hovers ' title='del.icio.us' alt='del.icio.us' /></a><a rel='nofollow' target='_blank'  href='http://reddit.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fdynamic-sql%2F&amp;title=Dynamic%20SQL'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/reddit.png' class='sociable-img sociable-hovers ' title='Reddit' alt='Reddit' /></a><a rel='nofollow' target='_blank'  href='http://www.google.com/reader/link?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fdynamic-sql%2F&amp;title=Dynamic%20SQL&amp;srcURL=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fdynamic-sql%2F&amp;srcTitle=Trust+Your+Technologist+Software+with+coffee+and+art...'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/googlebuzz.png' class='sociable-img sociable-hovers ' title='Google Buzz' alt='Google Buzz' /></a><a rel='nofollow' target='_blank'  href='http://technorati.com/faves?add=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F08%2Fdynamic-sql%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/technorati.png' class='sociable-img sociable-hovers ' title='Technorati' alt='Technorati' /></a><br/><br/>]]></content:encoded>
			<wfw:commentRss>http://www.trustyourtechnologist.com/index.php/2010/08/dynamic-sql/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>The 3 Essential Functions of Social Media</title>
		<link>http://www.trustyourtechnologist.com/index.php/2010/07/3-essential-functions-of-social-media/</link>
		<comments>http://www.trustyourtechnologist.com/index.php/2010/07/3-essential-functions-of-social-media/#comments</comments>
		<pubDate>Tue, 27 Jul 2010 16:25:47 +0000</pubDate>
		<dc:creator>Stephanie</dc:creator>
				<category><![CDATA[Business Intelligence]]></category>
		<category><![CDATA[businesses]]></category>
		<category><![CDATA[connect]]></category>
		<category><![CDATA[consumers]]></category>
		<category><![CDATA[interact]]></category>
		<category><![CDATA[monitor]]></category>
		<category><![CDATA[social media]]></category>

		<guid isPermaLink="false">http://www.trustyourtechnologist.com/?p=462</guid>
		<description><![CDATA[A friend asked me the other day why companies get involved in social media. After posing her question, she proceeded to answer it herself. “So they can do more advertising and stuff, right?” Wrong. There may be some companies out there that just use social media to further flood the market with their current ad [...]]]></description>
			<content:encoded><![CDATA[<p>A friend asked me the other day why companies get involved in social media. After posing her question, she proceeded to answer it herself. “So they can do more advertising and stuff, right?” Wrong. There may be some companies out there that just use social media to further flood the market with their current ad campaign, but there is so much more to social media. And the companies that are truly successful at social media understand that it is so much more.</p>
<h2>1. Monitor</h2>
<p>One of the most basic functions of social media is to help businesses monitor their name, brand, and products as they’re discussed in the  online world. This is a crucial point that many businesses overlook. There will always be conversations online and in real life about people, places and things and there is nothing anyone can do to stop it. But a business can monitor and listen to those conversations and in some cases join in on the conversation. This is particularly important when it comes to negative comments about a company’s product or service. Often a scorned customer can be appeased with a simple acknowledgment of the problem and an apology. People want to be heard and they want people to care about what they have to say. If they don’t feel like they’re being taken seriously, a problem that often times could be quickly and easily resolved, gets blown entirely out of proportion. Look at the <a href="http://www.engadget.com/2010/06/24/apple-responds-over-iphone-4-reception-issues-youre-holding-th/">apple iphone fiasco</a>. The antenna issue could be easily resolved with bumpers to fix the reception. Had apple immediately acknowledged the reception issue, apologized and said &#8220;We’re looking into it,&#8221; maybe they wouldn’t be facing a <a href="http://gizmodo.com/5577010/first-iphone-4-class-action-suit-filed-against-apple-and-att">class-action lawsuit</a>. Instead, Steve Jobs chose to deny, deny, deny and they’re in much hotter water because of it.</p>
<p><span id="more-462"></span></p>
<p>Tools like Twitter and Google Alerts can be so valuable in this function. With a few quick searches, any business owner can be aware of exactly what is being said about the company, the product or the service and the owner can be immediately notified if there is a storm brewing so he can step in before it’s a full blown hurricane.</p>
<p><!-- Start of HootSuite Embed --><object id="hootsuite_embed_25926" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="300" height="400" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0"><param name="allowFullScreen" value="true" /><param name="allowscriptaccess" value="always" /><param name="bgcolor" value="#FFFFFF" /><param name="flashvars" value="primaryColor=999999&amp;refreshRate=0&amp;query=social+media+consulting&amp;title=social+media+consulting&amp;profanityFilter=0" /><param name="src" value="http://static.hootsuite.com/hoot-embed.swf" /><param name="allowfullscreen" value="true" /><embed id="hootsuite_embed_25926" type="application/x-shockwave-flash" width="300" height="400" src="http://static.hootsuite.com/hoot-embed.swf" flashvars="primaryColor=999999&amp;refreshRate=0&amp;query=social+media+consulting&amp;title=social+media+consulting&amp;profanityFilter=0" bgcolor="#FFFFFF" allowscriptaccess="always" allowfullscreen="true"></embed></object><br />
<!-- End of HootSuite Embed --></p>
<address>Using tools like HootSuite, you can monitor conversations by searching for exact phrases, names, topics and more. The above is a live twitter feed of all tweets mentioning &#8220;social media consulting.&#8221;<br />
</address>
<h2>2. Connect</h2>
<p>One of the most valuable functions of social media is the ability to connect with people. Social media, in any shape or form, creates a public persona for a business that allows it to connect with consumers. Social media humanizes businesses and allows consumers to see more than just the high dollar ads and business execs on TV. A business can share more like company values, the corporate culture, other projects that the company is involved in like various philanthropies. By showing more than just the finely tuned marketing campaign, consumers are able to connect with businesses on a more personal level. This allows consumers to become more vested in the company and more willing to support the company in the long run.</p>
<p>Facebook is a <a href="http://www.facebook.com/home.php?#!/pages/Pepsi-We-Inspire/162878725361?ref=ts">perfect example</a> of how businesses can connect with consumers. All it takes is one person to become a fan of the company. Then that person is updated regularly on sales and regular goings on in the business, but also on the people behind the business, what they’re doing, what they’re supporting and what they’re thinking. The next time a consumer needs a product or service offered by this company, the consumer is much more likely to do business with a company he can connect with on a more personal level as opposed to one of the other competitors that the consumer knows nothing about.</p>
<h2>3. Interact</h2>
<p>Once you’ve monitored what people are saying and you’ve connected with them on some level, the next step is to interact with them. This is the ultimate goal of social media because its possibilities are limitless for your business. Once you s<a rel="attachment wp-att-473" href="http://www.trustyourtechnologist.com/index.php/2010/07/3-essential-functions-of-social-media/1063655_61642424/"><img class="alignright size-full wp-image-473" title="1063655_61642424" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/1063655_61642424.jpg" alt="" width="338" height="238" /></a><!--more--><!--more--><!--more-->tart interacting regularly with consumers, you can learn more about them, what they think, what they do and how they act. You can then use this information to better your business. And by forming meaningful relationships and interacting with consumers, you will strengthen their customer loyalty. Odds are that those loyal customers will not only support your business for years to come but they will introduce your business to their friends and family.</p>
<p>One way to interact with customers using social media is to provide special offers and coupons to encourage them to give you business. But more than that, you can interact with them directly by responding to their comments and providing them with useful information and feedback. Foursquare is a  fun new way to interact with consumers on a personal level. Customers can check in whenever they frequent your business. They can <a href="http://techcrunch.com/2009/07/16/foursquare-shows-the-business-potential-of-location-based-services/">get special deals</a> using promotion codes and if they check in enough, they even get the glory of being dubbed &#8220;mayor&#8221; of your business.</p>
<p>There are plenty of different ways to monitor, connect and interact with consumers using social media. The important thing is not how you go about it, just that you do it. By getting involved with social media and in turn getting more involved with your consumers, you create a ripple effect. Each time you create a meaningful relationship with a customer, they’ll share that with a friend, who will share that with a friend and so on. The return on social media is only limited by the effort and energy you’re willing to put into it.</p>
<p>So what do you think? How do you use social media? What are some other benefits and basic functions of social media that haven’t been discussed?</p>
Share and Enjoy:<a rel='nofollow' target='_blank'  href='http://www.printfriendly.com/print?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2F3-essential-functions-of-social-media%2F&amp;partner=sociable'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/printfriendly.png' class='sociable-img sociable-hovers ' title='Print' alt='Print' /></a><a rel='nofollow' target='_blank'  href='mailto:?subject=The%203%20Essential%20Functions%20of%20Social%20Media&amp;body=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2F3-essential-functions-of-social-media%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/email_link.png' class='sociable-img sociable-hovers ' title='email' alt='email' /></a><a rel='nofollow' target='_blank'  href='http://www.trustyourtechnologist.com/index.php/feed/'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/rss.png' class='sociable-img sociable-hovers ' title='RSS' alt='RSS' /></a><a rel='nofollow' target='_blank'  href='http://www.facebook.com/share.php?u=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2F3-essential-functions-of-social-media%2F&amp;t=The%203%20Essential%20Functions%20of%20Social%20Media'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/facebook.png' class='sociable-img sociable-hovers ' title='Facebook' alt='Facebook' /></a><a rel='nofollow' target='_blank'  href='http://twitter.com/home?status=The%203%20Essential%20Functions%20of%20Social%20Media%20-%20http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2F3-essential-functions-of-social-media%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/twitter.png' class='sociable-img sociable-hovers ' title='Twitter' alt='Twitter' /></a><a rel='nofollow' target='_blank'  href='http://www.linkedin.com/shareArticle?mini=true&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2F3-essential-functions-of-social-media%2F&amp;title=The%203%20Essential%20Functions%20of%20Social%20Media&amp;source=Trust+Your+Technologist+Software+with+coffee+and+art...&amp;summary=A%20friend%20asked%20me%20the%20other%20day%20why%20companies%20get%20involved%20in%20social%20media.%20After%20posing%20her%20question%2C%20she%20proceeded%20to%20answer%20it%20herself.%20%E2%80%9CSo%20they%20can%20do%20more%20advertising%20and%20stuff%2C%20right%3F%E2%80%9D%20Wrong.%20There%20may%20be%20some%20companies%20out%20there%20that%20just%20'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/linkedin.png' class='sociable-img sociable-hovers ' title='LinkedIn' alt='LinkedIn' /></a><a rel='nofollow' target='_blank'  href='http://digg.com/submit?phase=2&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2F3-essential-functions-of-social-media%2F&amp;title=The%203%20Essential%20Functions%20of%20Social%20Media&amp;bodytext=A%20friend%20asked%20me%20the%20other%20day%20why%20companies%20get%20involved%20in%20social%20media.%20After%20posing%20her%20question%2C%20she%20proceeded%20to%20answer%20it%20herself.%20%E2%80%9CSo%20they%20can%20do%20more%20advertising%20and%20stuff%2C%20right%3F%E2%80%9D%20Wrong.%20There%20may%20be%20some%20companies%20out%20there%20that%20just%20'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/digg.png' class='sociable-img sociable-hovers ' title='Digg' alt='Digg' /></a><a rel='nofollow' target='_blank'  href='http://www.stumbleupon.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2F3-essential-functions-of-social-media%2F&amp;title=The%203%20Essential%20Functions%20of%20Social%20Media'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/stumbleupon.png' class='sociable-img sociable-hovers ' title='StumbleUpon' alt='StumbleUpon' /></a><a rel='nofollow' target='_blank'  href='http://delicious.com/post?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2F3-essential-functions-of-social-media%2F&amp;title=The%203%20Essential%20Functions%20of%20Social%20Media&amp;notes=A%20friend%20asked%20me%20the%20other%20day%20why%20companies%20get%20involved%20in%20social%20media.%20After%20posing%20her%20question%2C%20she%20proceeded%20to%20answer%20it%20herself.%20%E2%80%9CSo%20they%20can%20do%20more%20advertising%20and%20stuff%2C%20right%3F%E2%80%9D%20Wrong.%20There%20may%20be%20some%20companies%20out%20there%20that%20just%20'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/delicious.png' class='sociable-img sociable-hovers ' title='del.icio.us' alt='del.icio.us' /></a><a rel='nofollow' target='_blank'  href='http://reddit.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2F3-essential-functions-of-social-media%2F&amp;title=The%203%20Essential%20Functions%20of%20Social%20Media'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/reddit.png' class='sociable-img sociable-hovers ' title='Reddit' alt='Reddit' /></a><a rel='nofollow' target='_blank'  href='http://www.google.com/reader/link?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2F3-essential-functions-of-social-media%2F&amp;title=The%203%20Essential%20Functions%20of%20Social%20Media&amp;srcURL=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2F3-essential-functions-of-social-media%2F&amp;srcTitle=Trust+Your+Technologist+Software+with+coffee+and+art...'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/googlebuzz.png' class='sociable-img sociable-hovers ' title='Google Buzz' alt='Google Buzz' /></a><a rel='nofollow' target='_blank'  href='http://technorati.com/faves?add=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2F3-essential-functions-of-social-media%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/technorati.png' class='sociable-img sociable-hovers ' title='Technorati' alt='Technorati' /></a><br/><br/>]]></content:encoded>
			<wfw:commentRss>http://www.trustyourtechnologist.com/index.php/2010/07/3-essential-functions-of-social-media/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Improve your Ecommerce Presence</title>
		<link>http://www.trustyourtechnologist.com/index.php/2010/07/improve-your-ecommerce-presence/</link>
		<comments>http://www.trustyourtechnologist.com/index.php/2010/07/improve-your-ecommerce-presence/#comments</comments>
		<pubDate>Fri, 23 Jul 2010 13:12:31 +0000</pubDate>
		<dc:creator>Damon</dc:creator>
				<category><![CDATA[Business Intelligence]]></category>
		<category><![CDATA[Solutions]]></category>
		<category><![CDATA[design]]></category>
		<category><![CDATA[Ecommerce]]></category>
		<category><![CDATA[products]]></category>
		<category><![CDATA[users]]></category>

		<guid isPermaLink="false">http://www.trustyourtechnologist.com/?p=412</guid>
		<description><![CDATA[The world of Ecommerce is at a unique point in its young life.  With the increased focus on web standards and usability, web users are constantly on the lookout for something cutting edge and easy to use.  That being said, creating an online shopping presence is becoming an increasingly important avenue for selling your goods. [...]]]></description>
			<content:encoded><![CDATA[<p>The world of Ecommerce is at a unique point in its young life.  With the increased focus on web standards and usability, web users are constantly on the lookout for something cutting edge and easy to use.  That being said, creating an online shopping presence is becoming an increasingly important avenue for selling your goods. However, without a specific, granular approach to your<img class="alignleft size-full wp-image-440" title="open" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/open.jpg" alt="" width="300" height="206" /> Ecommerce store, it&#8217;s likely that it will produce less than desirable sales, be difficult to maintain and ultimately ineffective for users to perform even basic actions.</p>
<p>There are some fairly fool proof ways to combat common mistakes, however. By following some pretty simple rules within your Ecommerce store, we can improve sales, generate leads and referrals and subsequently increase conversions. Let&#8217;s get started!<br />
<span id="more-412"></span></p>
<p>&nbsp;</p>
<h3>1. Remove clutter and distracting elements</h3>
<p>The single biggest step I can recommend is removing &#8220;clutter&#8221; and unneeded elements from the design of the store. In doing so, you will free up sections of the page, which can help for many different reasons. First, it will reduce the amount of information the user takes in, drawing the focus to what is most important on the page, the product. Second, it frees up more real estate for product photos, descriptions and reviews; all of which will help a user make a more informed decision. Finally, by reducing clutter, you reduce the amount of elements that load when a page is requested by the user, thus decreasing their loading times and providing a more responsive feel to the site. Take a look at Lucky Brand Jeans&#8217; site:</p>
<p><img class="size-full wp-image-416 alignnone" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/lucky.jpg" alt="Lucky Brand Jeans" width="404" height="318" /></p>
<p><em><span style="font-size: 11px;">By incorporating a large product shot, the focus is drawn directly to the product. You will also notice a solid product description followed by different options you can select. Only when you get to the bottom of the page will you see recommended products. By doing this, they reduce clutter on the page in order to put the main focus on the product and the product only.</span></em></p>
<h3>2. Make actions clearly visible</h3>
<p>Along the same lines, making an Ecommerce site have clear and specific actions is essential to a successful store. Without them, a user might get lost on what to do next (ex: after adding a product to the cart, what do I do?). This becomes exponentially important during the checkout process, as users are very quick to cancel their entire transaction if they get even the slightest hint that they might be doing something wrong; especially if they believe it might compromise their sensitive information.</p>
<p>With that in mind, actions to make extremely clear might include: add to cart, remove from cart, update quantities, checkout, select variation/option and any forms they need to fill out. Below are some examples.</p>
<p><img class="alignnone size-full wp-image-419" title="Fugitive Toys" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/fugitive.jpg" alt="" width="404" height="310" /><br />
<em><span style="font-size: 11px;">Fugitive Toys has large buttons that clearly pull you to the next action.</span></em></p>
<p><img class="alignnone size-full wp-image-420" title="REI" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/rei.jpg" alt="" width="404" height="394" /><br />
<em><span style="font-size: 11px;">REI includes a 1. 2. 3. step process to add a product to the cart, which tells the user exactly what to do to add that product (and any variations) to the cart.</span></em></p>
<h3>3. Make product shots visually appealing</h3>
<p>If you have already removed distracting, unneeded elements from your store, chances are you have some free space (it might even look a bit empty). That&#8217;s OK! You can fill up a bit of that space with product images that will highlight the craftsmanship &amp; fine details of your products. A common feature found on Ecommerce sites is a product image gallery. This is quite a useful feature for users because they are able to see multiple images and it will help them to make a more informed decision about the product. Think of it this way: someone can describe something picturesque and beautiful, but if you&#8217;ve never seen it with your own eyes, you won&#8217;t appreciate it fully; it&#8217;s the same with your products online. You can have pages and pages detailing how your products are created, but if a user never sees a decent picture, their opinion will be skewed because ultimately, they want to make the final decision for themselves.</p>
<p><img class="alignnone size-full wp-image-425" title="Spy Optics" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/spy.jpg" alt="" width="404" height="309" /></p>
<p><img class="alignnone size-full wp-image-424" title="Converse" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/converse.jpg" alt="" width="404" height="290" /><br />
<em><span style="font-size: 11px;">Spy Optics &amp; Converse both use very large product shots to show detail; this is like being able to hold a product in a store.</span></em></p>
<h3>4. Include value added or related products</h3>
<p>Have you ever gone on a camping trip, assembled your tent, and realized you didn&#8217;t have any stakes to hold it down? Smaller items like tent stakes can help to increase sales by providing a user something extra to buy at the last minute. If they see a product that they &#8220;might need&#8221; just before checking out, they may feel inclined to add it to their order (think of the checkout aisle at the grocery store). There are a couple of things to keep in mind, though; first, you have to make these additional products stand out from the rest of the content, to draw attention to them (but do it subtly!). Second, make sure that the product you are trying to cross-sell is pertinent to the product they just are about to buy. Last but not least, it must be extremely simple to add that product to the cart so the user can be on their way in a matter of seconds.</p>
<p><img class="alignnone size-full wp-image-427" title="Amazon" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/amazon.jpg" alt="" width="404" height="318" /><br />
<em><span style="font-size: 11px;">On most product pages at Amazon, you will find items that are “Frequently Bought Together”.  Items that correspond to the product being viewed are typically placed here.</span></em></p>
<h3>5. Checkout process needs to be a breeze</h3>
<p>Let&#8217;s go to a real life example again. After picking out a few products, you head to the register and run into a long line. When you finally get to the clerk, they aren&#8217;t helpful in ringing up your items and give you no indication of when to swipe your card, enter your PIN or sign, and don&#8217;t bag your items up for you. Pretty inconvenient, right? Making the entire checkout process simple and easy is an integral part of increasing sales. This section could be an entire article by itself, so I won&#8217;t elaborate too much, but:</p>
<ul>
<li>Step by step completion can help the user see exactly where they are in the checkout process, giving them feedback and encouraging them to continue.</li>
<li>Error messages need to be clearly defined and helpful, so that the user can correct the problem quickly and be on their way.</li>
<li>Security is an increasing concern for everyone, so reassuring the user that their sensitive data is safe is imperative.</li>
<li>Confirmation of a successful transaction should be clearly stated so that the user understands everything that happened.</li>
</ul>
<p><img class="alignnone size-full wp-image-428" title="Crystal" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/crystal.jpg" alt="" width="404" height="404" /><br />
<em><span style="font-size: 11px;">Swarovski Crystal has a great checkout process. They have steps to alert you exactly where you are in the checkout process, as well as forms that guide you in case of errors.</span></em></p>
<h3>6. Go the extra mile to keep users informed</h3>
<p>You&#8217;re wrong if you think your job is done when the user completes their transaction! Keeping them informed about the status of their order will give them peace of mind that all is well. Emails that tell the user you received their order, their order was processed &amp; shipped, and possibly a follow up email are all key to helping the user through the end. Providing things like contact numbers and email addresses are great because it puts the user in contact with you if they have any questions. Also, adding a tracking number to the email is a great feature that a user definitely appreciates, as they like to see exactly what is happening with their order.</p>
<p>Will these 6 tips guarantee success in every Ecommerce store? No. However, they are guidelines that can be formatted to fit your store so that in the end, your focus is on the most important aspect of your business – the consumer. Take a look at these tips again, and then browse through your Ecommerce site. What can be improved? What can be added or removed? Whether you need to customize your current solution or start from scratch, we have the tools and knowledge to help.</p>
<p>﻿</p>
Share and Enjoy:<a rel='nofollow' target='_blank'  href='http://www.printfriendly.com/print?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fimprove-your-ecommerce-presence%2F&amp;partner=sociable'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/printfriendly.png' class='sociable-img sociable-hovers ' title='Print' alt='Print' /></a><a rel='nofollow' target='_blank'  href='mailto:?subject=Improve%20your%20Ecommerce%20Presence&amp;body=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fimprove-your-ecommerce-presence%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/email_link.png' class='sociable-img sociable-hovers ' title='email' alt='email' /></a><a rel='nofollow' target='_blank'  href='http://www.trustyourtechnologist.com/index.php/feed/'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/rss.png' class='sociable-img sociable-hovers ' title='RSS' alt='RSS' /></a><a rel='nofollow' target='_blank'  href='http://www.facebook.com/share.php?u=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fimprove-your-ecommerce-presence%2F&amp;t=Improve%20your%20Ecommerce%20Presence'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/facebook.png' class='sociable-img sociable-hovers ' title='Facebook' alt='Facebook' /></a><a rel='nofollow' target='_blank'  href='http://twitter.com/home?status=Improve%20your%20Ecommerce%20Presence%20-%20http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fimprove-your-ecommerce-presence%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/twitter.png' class='sociable-img sociable-hovers ' title='Twitter' alt='Twitter' /></a><a rel='nofollow' target='_blank'  href='http://www.linkedin.com/shareArticle?mini=true&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fimprove-your-ecommerce-presence%2F&amp;title=Improve%20your%20Ecommerce%20Presence&amp;source=Trust+Your+Technologist+Software+with+coffee+and+art...&amp;summary=The%20world%20of%20Ecommerce%20is%20at%20a%20unique%20point%20in%20its%20young%20life.%C2%A0%20With%20the%20increased%20focus%20on%20web%20standards%20and%20usability%2C%20web%20users%20are%20constantly%20on%20the%20lookout%20for%20something%20cutting%20edge%20and%20easy%20to%20use.%C2%A0%20That%20being%20said%2C%20creating%20an%20online%20shoppi'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/linkedin.png' class='sociable-img sociable-hovers ' title='LinkedIn' alt='LinkedIn' /></a><a rel='nofollow' target='_blank'  href='http://digg.com/submit?phase=2&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fimprove-your-ecommerce-presence%2F&amp;title=Improve%20your%20Ecommerce%20Presence&amp;bodytext=The%20world%20of%20Ecommerce%20is%20at%20a%20unique%20point%20in%20its%20young%20life.%C2%A0%20With%20the%20increased%20focus%20on%20web%20standards%20and%20usability%2C%20web%20users%20are%20constantly%20on%20the%20lookout%20for%20something%20cutting%20edge%20and%20easy%20to%20use.%C2%A0%20That%20being%20said%2C%20creating%20an%20online%20shoppi'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/digg.png' class='sociable-img sociable-hovers ' title='Digg' alt='Digg' /></a><a rel='nofollow' target='_blank'  href='http://www.stumbleupon.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fimprove-your-ecommerce-presence%2F&amp;title=Improve%20your%20Ecommerce%20Presence'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/stumbleupon.png' class='sociable-img sociable-hovers ' title='StumbleUpon' alt='StumbleUpon' /></a><a rel='nofollow' target='_blank'  href='http://delicious.com/post?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fimprove-your-ecommerce-presence%2F&amp;title=Improve%20your%20Ecommerce%20Presence&amp;notes=The%20world%20of%20Ecommerce%20is%20at%20a%20unique%20point%20in%20its%20young%20life.%C2%A0%20With%20the%20increased%20focus%20on%20web%20standards%20and%20usability%2C%20web%20users%20are%20constantly%20on%20the%20lookout%20for%20something%20cutting%20edge%20and%20easy%20to%20use.%C2%A0%20That%20being%20said%2C%20creating%20an%20online%20shoppi'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/delicious.png' class='sociable-img sociable-hovers ' title='del.icio.us' alt='del.icio.us' /></a><a rel='nofollow' target='_blank'  href='http://reddit.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fimprove-your-ecommerce-presence%2F&amp;title=Improve%20your%20Ecommerce%20Presence'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/reddit.png' class='sociable-img sociable-hovers ' title='Reddit' alt='Reddit' /></a><a rel='nofollow' target='_blank'  href='http://www.google.com/reader/link?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fimprove-your-ecommerce-presence%2F&amp;title=Improve%20your%20Ecommerce%20Presence&amp;srcURL=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fimprove-your-ecommerce-presence%2F&amp;srcTitle=Trust+Your+Technologist+Software+with+coffee+and+art...'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/googlebuzz.png' class='sociable-img sociable-hovers ' title='Google Buzz' alt='Google Buzz' /></a><a rel='nofollow' target='_blank'  href='http://technorati.com/faves?add=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fimprove-your-ecommerce-presence%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/technorati.png' class='sociable-img sociable-hovers ' title='Technorati' alt='Technorati' /></a><br/><br/>]]></content:encoded>
			<wfw:commentRss>http://www.trustyourtechnologist.com/index.php/2010/07/improve-your-ecommerce-presence/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>QR Codes Unleashed</title>
		<link>http://www.trustyourtechnologist.com/index.php/2010/07/qr-codes-unleashed/</link>
		<comments>http://www.trustyourtechnologist.com/index.php/2010/07/qr-codes-unleashed/#comments</comments>
		<pubDate>Thu, 22 Jul 2010 14:50:50 +0000</pubDate>
		<dc:creator>Andrew Newby</dc:creator>
				<category><![CDATA[Business Intelligence]]></category>
		<category><![CDATA[General Knowledge]]></category>
		<category><![CDATA[Solutions]]></category>
		<category><![CDATA[mobile]]></category>
		<category><![CDATA[qr code]]></category>

		<guid isPermaLink="false">http://www.trustyourtechnologist.com/?p=366</guid>
		<description><![CDATA[As mobile application acceptance and influence grows, finding better ways to connect information will evolve. That means not only sharing but also accessing information and application interaction on a device level &#8211; bridging the divide between print, mobility and infosharing. One of these methods is the QR Code (Quick Response Code). A QR Code is [...]]]></description>
			<content:encoded><![CDATA[<p>As mobile application acceptance and influence grows, finding better ways to connect information will evolve.  That means not only sharing but also accessing information and application interaction on a device level &#8211; bridging the divide between print, mobility and infosharing.  One of these methods is the QR Code (Quick Response Code).  A QR Code is a 2D bar code configured in a matrix; information is stored horizontally as well as vertically.  This differs from a traditional bar code which only contains information horizontally.  A QR Code uses blocks (called modules) instead of variable width lines.  The benefit of this is the ability to store a lot more information.  Here is an example.</p>
<div id="attachment_370" class="wp-caption aligncenter" style="width: 290px"><a rel="attachment wp-att-370" href="http://www.trustyourtechnologist.com/index.php/2010/07/qr-codes-unleashed/trustyourtechnologist/"><img class="size-full wp-image-370" title="A QR Code of the url www.trustyourtechnologist.com" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/trustyourtechnologist.png" alt="A QR Code of the url www.trustyourtechnologist.com" width="280" height="280" /></a><p class="wp-caption-text">A QR Code of the url www.trustyourtechnologist.com</p></div>
<p>The basic function of the code is to be scanned (laser based 2D bar code scanner &#8211; or more likely, a phone&#8217;s camera).  On a phone the image is analyzed by a QR Code reading application such as <a href="http://www.qr-barcodes.com/" target="_blank">QRdvark</a> and the content, link, and info is then available on the device.</p>
<p><a rel="attachment wp-att-370" href="http://www.trustyourtechnologist.com/index.php/2010/07/qr-codes-unleashed/trustyourtechnologist/"><span id="more-366"></span></a>The QR Code is machine readable only, of course.  But its usefulness is only limited by the application reading it.  For example, a QR Code reader recognizing a URL in the QR Code will open the location in a browser.  A QR Code of contact information can automatically create that contact in your address book.</p>
<div id="attachment_369" class="wp-caption alignright" style="width: 160px"><a rel="attachment wp-att-369" href="http://www.trustyourtechnologist.com/index.php/2010/07/qr-codes-unleashed/sms-i-love-your-blog/"><img class="size-full wp-image-369" title="SMS I love your blog" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/SMS-I-love-your-blog.png" alt="SMS I love your blog" width="150" height="150" /></a><p class="wp-caption-text">SMS I love your blog</p></div>
<p>An enormous benefit is that this format can contain 4,296 text characters, 7,089 digits, 2,953 raw bytes, or 1,817 kanji.  That&#8217;s plenty of information to include full contact information on a business card, details about a movie on a poster, or quick link to a product&#8217;s URL.  If you have not seen it already, expect to see QR Codes appearing in print ads.  A scan of the code could open a URL of the product or a special promotion.</p>
<p><strong>Design QR</strong><br />
These QRs take logos or other imagery and incorporate them into the QR Code.  This is possible because there is redundancy enough for a lot of code deterioration before the code becomes unreadable.</p>
<div id="attachment_393" class="wp-caption aligncenter" style="width: 382px"><a rel="attachment wp-att-393" href="http://www.trustyourtechnologist.com/index.php/2010/07/qr-codes-unleashed/avatarsyndicate-com-2/"><img class="size-full wp-image-393" title="AVATAR's DesignQR" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/avatarsyndicate.com_1.png" alt="AVATAR's DesignQR" width="372" height="372" /></a><p class="wp-caption-text">AVATAR&#39;s DesignQR</p></div>
<p><strong>Structure</strong><br />
A QR Code contains several meta elements in addition to the embedded information being shared.  Extra information about what version of the code is being used but also tracking points to help the reader application adjust for position and skew.  A QR Code is from 21-177 modules in height and 21-177 modules in width.</p>
<p><strong>Future Uses</strong><br />
In advertising you attempt to catch the eye and make an impression.  QR Codes help make that impression digital.  But I think this will also be a major infosharing technique.  Current uses include an art gallery tour enhanced through codes to help identify sections of a digital tour or to open more information about the artist, the piece, the period, etc.  Street artists tagging their work with QR Codes.  Near future uses could include traffic signs auto-read by in-car readers.  And future uses such as 3D QR Codes that can store even more information (in theory, an entire video clip), or enhanced encoding techniques that could store more as well.</p>
Share and Enjoy:<a rel='nofollow' target='_blank'  href='http://www.printfriendly.com/print?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fqr-codes-unleashed%2F&amp;partner=sociable'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/printfriendly.png' class='sociable-img sociable-hovers ' title='Print' alt='Print' /></a><a rel='nofollow' target='_blank'  href='mailto:?subject=QR%20Codes%20Unleashed&amp;body=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fqr-codes-unleashed%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/email_link.png' class='sociable-img sociable-hovers ' title='email' alt='email' /></a><a rel='nofollow' target='_blank'  href='http://www.trustyourtechnologist.com/index.php/feed/'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/rss.png' class='sociable-img sociable-hovers ' title='RSS' alt='RSS' /></a><a rel='nofollow' target='_blank'  href='http://www.facebook.com/share.php?u=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fqr-codes-unleashed%2F&amp;t=QR%20Codes%20Unleashed'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/facebook.png' class='sociable-img sociable-hovers ' title='Facebook' alt='Facebook' /></a><a rel='nofollow' target='_blank'  href='http://twitter.com/home?status=QR%20Codes%20Unleashed%20-%20http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fqr-codes-unleashed%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/twitter.png' class='sociable-img sociable-hovers ' title='Twitter' alt='Twitter' /></a><a rel='nofollow' target='_blank'  href='http://www.linkedin.com/shareArticle?mini=true&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fqr-codes-unleashed%2F&amp;title=QR%20Codes%20Unleashed&amp;source=Trust+Your+Technologist+Software+with+coffee+and+art...&amp;summary=As%20mobile%20application%20acceptance%20and%20influence%20grows%2C%20finding%20better%20ways%20to%20connect%20information%20will%20evolve.%20%20That%20means%20not%20only%20sharing%20but%20also%20accessing%20information%20and%20application%20interaction%20on%20a%20device%20level%20-%20bridging%20the%20divide%20between%20prin'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/linkedin.png' class='sociable-img sociable-hovers ' title='LinkedIn' alt='LinkedIn' /></a><a rel='nofollow' target='_blank'  href='http://digg.com/submit?phase=2&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fqr-codes-unleashed%2F&amp;title=QR%20Codes%20Unleashed&amp;bodytext=As%20mobile%20application%20acceptance%20and%20influence%20grows%2C%20finding%20better%20ways%20to%20connect%20information%20will%20evolve.%20%20That%20means%20not%20only%20sharing%20but%20also%20accessing%20information%20and%20application%20interaction%20on%20a%20device%20level%20-%20bridging%20the%20divide%20between%20prin'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/digg.png' class='sociable-img sociable-hovers ' title='Digg' alt='Digg' /></a><a rel='nofollow' target='_blank'  href='http://www.stumbleupon.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fqr-codes-unleashed%2F&amp;title=QR%20Codes%20Unleashed'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/stumbleupon.png' class='sociable-img sociable-hovers ' title='StumbleUpon' alt='StumbleUpon' /></a><a rel='nofollow' target='_blank'  href='http://delicious.com/post?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fqr-codes-unleashed%2F&amp;title=QR%20Codes%20Unleashed&amp;notes=As%20mobile%20application%20acceptance%20and%20influence%20grows%2C%20finding%20better%20ways%20to%20connect%20information%20will%20evolve.%20%20That%20means%20not%20only%20sharing%20but%20also%20accessing%20information%20and%20application%20interaction%20on%20a%20device%20level%20-%20bridging%20the%20divide%20between%20prin'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/delicious.png' class='sociable-img sociable-hovers ' title='del.icio.us' alt='del.icio.us' /></a><a rel='nofollow' target='_blank'  href='http://reddit.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fqr-codes-unleashed%2F&amp;title=QR%20Codes%20Unleashed'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/reddit.png' class='sociable-img sociable-hovers ' title='Reddit' alt='Reddit' /></a><a rel='nofollow' target='_blank'  href='http://www.google.com/reader/link?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fqr-codes-unleashed%2F&amp;title=QR%20Codes%20Unleashed&amp;srcURL=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fqr-codes-unleashed%2F&amp;srcTitle=Trust+Your+Technologist+Software+with+coffee+and+art...'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/googlebuzz.png' class='sociable-img sociable-hovers ' title='Google Buzz' alt='Google Buzz' /></a><a rel='nofollow' target='_blank'  href='http://technorati.com/faves?add=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fqr-codes-unleashed%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/technorati.png' class='sociable-img sociable-hovers ' title='Technorati' alt='Technorati' /></a><br/><br/>]]></content:encoded>
			<wfw:commentRss>http://www.trustyourtechnologist.com/index.php/2010/07/qr-codes-unleashed/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>An Outside Glimpse into AVATAR</title>
		<link>http://www.trustyourtechnologist.com/index.php/2010/07/an-outside-glimpse-into-avatar/</link>
		<comments>http://www.trustyourtechnologist.com/index.php/2010/07/an-outside-glimpse-into-avatar/#comments</comments>
		<pubDate>Wed, 21 Jul 2010 14:03:58 +0000</pubDate>
		<dc:creator>Stephanie</dc:creator>
				<category><![CDATA[General Knowledge]]></category>
		<category><![CDATA[AVATAR]]></category>
		<category><![CDATA[small business]]></category>

		<guid isPermaLink="false">http://www.trustyourtechnologist.com/?p=341</guid>
		<description><![CDATA[This is a guest post by Jake Newby. Jake is the nephew of the owners of AVATAR and will be majoring in Computer Science at Ball State this Fall. He came to observe the office for the week and see what we do everyday. It&#8217;s my third day in Toledo and I&#8217;ve experienced an atmosphere [...]]]></description>
			<content:encoded><![CDATA[<address><a rel="attachment wp-att-357" href="http://www.trustyourtechnologist.com/index.php/2010/07/an-outside-glimpse-into-avatar/24734_384160742979_539652979_3686533_4164878_n-2/"><img class="size-full wp-image-357 alignleft" title="Jake" src="http://www.trustyourtechnologist.com/wp-content/uploads/2010/07/24734_384160742979_539652979_3686533_4164878_n.jpg" alt="" width="139" height="142" /></a>This is a guest post by Jake Newby. Jake is the nephew of the owners of AVATAR and will be majoring in Computer Science at Ball State this Fall. He came to observe the office for the week and see what we do everyday.<br />
</address>
<p>It&#8217;s my third day in Toledo and I&#8217;ve experienced an atmosphere at AVATAR that can only be described as the genuine small business experience.  On one end, you have an engaged business, but given the opportunity for playtime, the gang will not hesitate to poke fun at each other and engage in office shenanigans all in the name of fun. For example, today I decided to eavesdrop on a conversation between Robert and Damon with Damon accusing Robert of eating his last dinosaur Silly Bandz bracelet. Watching this exchange I was reminded of similar situations on the hit TV series &#8220;The Office.&#8221; This exchange was certainly something that you wouldn&#8217;t want to miss! But what&#8217;s great is how work still gets done in this atmosphere. One end of the office could be in the middle of a rubber band war while I am sitting across from Kristin and Stephanie who are meeting to discuss AVATAR&#8217;s next big step in the social media arena. Moments of raucous fun are quickly followed by the sounds of feverish typing and clicking with everyone hard at work. In short, AVATAR is a small business atmosphere upheld by close-knit friends seldom seen at your typical nine to five job.</p>
<p>Reflecting on my visit so far, I&#8217;d say that two very valuable things have come of it to this point.  First, I&#8217;ve learned quite a bit about web development.  Second, don&#8217;t try something  just because someone tells you that it tastes good &#8212; you may regret it the following morning.</p>
Share and Enjoy:<a rel='nofollow' target='_blank'  href='http://www.printfriendly.com/print?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fan-outside-glimpse-into-avatar%2F&amp;partner=sociable'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/printfriendly.png' class='sociable-img sociable-hovers ' title='Print' alt='Print' /></a><a rel='nofollow' target='_blank'  href='mailto:?subject=An%20Outside%20Glimpse%20into%20AVATAR&amp;body=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fan-outside-glimpse-into-avatar%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/email_link.png' class='sociable-img sociable-hovers ' title='email' alt='email' /></a><a rel='nofollow' target='_blank'  href='http://www.trustyourtechnologist.com/index.php/feed/'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/rss.png' class='sociable-img sociable-hovers ' title='RSS' alt='RSS' /></a><a rel='nofollow' target='_blank'  href='http://www.facebook.com/share.php?u=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fan-outside-glimpse-into-avatar%2F&amp;t=An%20Outside%20Glimpse%20into%20AVATAR'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/facebook.png' class='sociable-img sociable-hovers ' title='Facebook' alt='Facebook' /></a><a rel='nofollow' target='_blank'  href='http://twitter.com/home?status=An%20Outside%20Glimpse%20into%20AVATAR%20-%20http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fan-outside-glimpse-into-avatar%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/twitter.png' class='sociable-img sociable-hovers ' title='Twitter' alt='Twitter' /></a><a rel='nofollow' target='_blank'  href='http://www.linkedin.com/shareArticle?mini=true&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fan-outside-glimpse-into-avatar%2F&amp;title=An%20Outside%20Glimpse%20into%20AVATAR&amp;source=Trust+Your+Technologist+Software+with+coffee+and+art...&amp;summary=This%20is%20a%20guest%20post%20by%20Jake%20Newby.%20Jake%20is%20the%20nephew%20of%20the%20owners%20of%20AVATAR%20and%20will%20be%20majoring%20in%20Computer%20Science%20at%20Ball%20State%20this%20Fall.%20He%20came%20to%20observe%20the%20office%20for%20the%20week%20and%20see%20what%20we%20do%20everyday.%0D%0AIt%27s%20my%20third%20day%20in%20Toledo%20and%20'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/linkedin.png' class='sociable-img sociable-hovers ' title='LinkedIn' alt='LinkedIn' /></a><a rel='nofollow' target='_blank'  href='http://digg.com/submit?phase=2&amp;url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fan-outside-glimpse-into-avatar%2F&amp;title=An%20Outside%20Glimpse%20into%20AVATAR&amp;bodytext=This%20is%20a%20guest%20post%20by%20Jake%20Newby.%20Jake%20is%20the%20nephew%20of%20the%20owners%20of%20AVATAR%20and%20will%20be%20majoring%20in%20Computer%20Science%20at%20Ball%20State%20this%20Fall.%20He%20came%20to%20observe%20the%20office%20for%20the%20week%20and%20see%20what%20we%20do%20everyday.%0D%0AIt%27s%20my%20third%20day%20in%20Toledo%20and%20'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/digg.png' class='sociable-img sociable-hovers ' title='Digg' alt='Digg' /></a><a rel='nofollow' target='_blank'  href='http://www.stumbleupon.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fan-outside-glimpse-into-avatar%2F&amp;title=An%20Outside%20Glimpse%20into%20AVATAR'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/stumbleupon.png' class='sociable-img sociable-hovers ' title='StumbleUpon' alt='StumbleUpon' /></a><a rel='nofollow' target='_blank'  href='http://delicious.com/post?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fan-outside-glimpse-into-avatar%2F&amp;title=An%20Outside%20Glimpse%20into%20AVATAR&amp;notes=This%20is%20a%20guest%20post%20by%20Jake%20Newby.%20Jake%20is%20the%20nephew%20of%20the%20owners%20of%20AVATAR%20and%20will%20be%20majoring%20in%20Computer%20Science%20at%20Ball%20State%20this%20Fall.%20He%20came%20to%20observe%20the%20office%20for%20the%20week%20and%20see%20what%20we%20do%20everyday.%0D%0AIt%27s%20my%20third%20day%20in%20Toledo%20and%20'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/delicious.png' class='sociable-img sociable-hovers ' title='del.icio.us' alt='del.icio.us' /></a><a rel='nofollow' target='_blank'  href='http://reddit.com/submit?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fan-outside-glimpse-into-avatar%2F&amp;title=An%20Outside%20Glimpse%20into%20AVATAR'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/reddit.png' class='sociable-img sociable-hovers ' title='Reddit' alt='Reddit' /></a><a rel='nofollow' target='_blank'  href='http://www.google.com/reader/link?url=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fan-outside-glimpse-into-avatar%2F&amp;title=An%20Outside%20Glimpse%20into%20AVATAR&amp;srcURL=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fan-outside-glimpse-into-avatar%2F&amp;srcTitle=Trust+Your+Technologist+Software+with+coffee+and+art...'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/googlebuzz.png' class='sociable-img sociable-hovers ' title='Google Buzz' alt='Google Buzz' /></a><a rel='nofollow' target='_blank'  href='http://technorati.com/faves?add=http%3A%2F%2Fwww.trustyourtechnologist.com%2Findex.php%2F2010%2F07%2Fan-outside-glimpse-into-avatar%2F'><img src='http://www.trustyourtechnologist.com/wp-content/plugins/sociable-30/images/default/16/technorati.png' class='sociable-img sociable-hovers ' title='Technorati' alt='Technorati' /></a><br/><br/>]]></content:encoded>
			<wfw:commentRss>http://www.trustyourtechnologist.com/index.php/2010/07/an-outside-glimpse-into-avatar/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
