<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:blogChannel="http://backend.userland.com/blogChannelModule" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:pingback="http://madskills.com/public/xml/rss/module/pingback/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#" version="2.0">
  <channel>
    <title>Internet Blu</title>
    <description>Internet Marketing, Book Reviews, and Web Randomness</description>
    <link>http://www.internetblu.com/</link>
    <docs>http://www.rssboard.org/rss-specification</docs>
    <generator>BlogEngine.Net Syndication Generator 1.0.0.0 (http://dotnetblogengine.net/)</generator>
    <language>en-US</language>
    <blogChannel:blogRoll>http://www.internetblu.com/opml.axd</blogChannel:blogRoll>
    <dc:creator>John Callaway</dc:creator>
    <dc:title>Internet Blu</dc:title>
    <atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" href="http://feeds.feedburner.com/InternetBlu" type="application/rss+xml" /><feedburner:emailServiceId xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0">InternetBlu</feedburner:emailServiceId><feedburner:feedburnerHostname xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0">http://feedburner.google.com</feedburner:feedburnerHostname><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com" /><item>
      <title>Fighting Developer Burnout</title>
      <description>&lt;p&gt;Recently, a colleague and I were having a philosophical debate regarding developer burnout.&amp;nbsp; He pointed me towards an article (&lt;a href="http://stackoverflow.com/questions/48958/what-causes-developer-burnout"&gt;What causes developer burnout&lt;/a&gt;) that he had found that same morning.&amp;nbsp; This got me to thinking about my own experiences and times of professional frustration.&lt;/p&gt;&lt;p&gt;What follows are a few tips that may help fight developer burnout.&lt;/p&gt;&lt;p&gt;&lt;strong&gt;Avoid blame&lt;/strong&gt;.&amp;nbsp; Don&amp;#39;t get stuck finger pointing and searching for a source of your frustration.&amp;nbsp; The reality is that it doesn&amp;#39;t matter.&amp;nbsp; Instead, focus on finding solutions.&lt;/p&gt;&lt;p&gt;&lt;strong&gt;Work &lt;em&gt;with&lt;/em&gt; those whom you feel frustration towards&lt;/strong&gt;.&amp;nbsp; It&amp;#39;s been my experience that the team is more productive when everyone works together instead of against one another.&amp;nbsp; Befriend those that frustrate you and ask how you might help them.&amp;nbsp; This act will go a long way.&amp;nbsp; In return they may even remove some of the unnecesary obstacles in your way.&lt;/p&gt;&lt;p&gt;What tips do you have to share?&amp;nbsp;&lt;/p&gt;</description>
      <link>http://www.internetblu.com/post/2009/07/Fighting-Developer-Burnout.aspx</link>
      <author>John Callaway</author>
      <comments>http://www.internetblu.com/post/2009/07/Fighting-Developer-Burnout.aspx#comment</comments>
      <guid>http://www.internetblu.com/post.aspx?id=4fac0fd3-6a5f-4259-ace8-7391d00b38f4</guid>
      <pubDate>Sun, 26 Jul 2009 18:34:00 -0500</pubDate>
      <category>Tips and Tricks</category>
      <dc:publisher>John Callaway</dc:publisher>
      <pingback:server>http://www.internetblu.com/pingback.axd</pingback:server>
      <pingback:target>http://www.internetblu.com/post.aspx?id=4fac0fd3-6a5f-4259-ace8-7391d00b38f4</pingback:target>
      <slash:comments>2</slash:comments>
      <trackback:ping>http://www.internetblu.com/trackback.axd?id=4fac0fd3-6a5f-4259-ace8-7391d00b38f4</trackback:ping>
      <wfw:comment>http://www.internetblu.com/post/2009/07/Fighting-Developer-Burnout.aspx#comment</wfw:comment>
      <wfw:commentRss>http://www.internetblu.com/syndication.axd?post=4fac0fd3-6a5f-4259-ace8-7391d00b38f4</wfw:commentRss>
    </item>
    <item>
      <title>Why  Testing Your Pay Per Click (PPC) Ad Text is Like Dating</title>
      <description>
&lt;p&gt;
&lt;em&gt;The following is a guest post from good friend and SEO and PPC expert, Amberly Stitzel.&lt;/em&gt;
&lt;/p&gt;
&lt;p&gt;
by Amberly Stitzel
&lt;/p&gt;
&lt;p&gt;
When it comes to dating it seems like everyone is trying to find &amp;quot;The One.&amp;quot; It appears we are trying to meet the same goal with &lt;strong&gt;Pay Per Click&lt;/strong&gt; (PPC) ad copy. We all want to find the one ad text that can generate the highest &lt;strong&gt;Click Through Rate&lt;/strong&gt; (CTR) thus getting more qualified users in the door for a lower &lt;strong&gt;Cost Per Click&lt;/strong&gt; (CPC).
&lt;/p&gt;

&lt;p&gt;
Just like dating you start with a pool of, hopefully, qualified applicants. In PPC you also start with a pool of qualified ad texts; I recommend at least three and probably no more than five just to keep results from getting diluted.
&lt;/p&gt;
&lt;p&gt;
You don&amp;#39;t want to send your ad texts out into the search space without properly preparing them for competition, just as you wouldn&amp;#39;t go out on a date in your pajamas after your just rolled out of bed in the morning. We all try to put our best foot forward on a date by wearing something nice, fixing our hair and smelling good so why wouldn&amp;#39;t you do the same for your ad texts? Using great calls to action and accurately explaining what you expect the user to do when they arrive at your site after clicking on the ad is similar to getting &amp;quot;gussied up&amp;quot; before a date. It is a bit more difficult, however, because pay per click ads have only so many characters to put their best foot forward whereas dates can go all out, wearing whatever, wherever.  Nonetheless, make sure you put as many selling points as you can in your ads and don&amp;#39;t try to write ads just for the clicks because the ultimate goal is the conversion once they get there.
&lt;/p&gt;
&lt;p&gt;
With PPC ad texts the system then optimizes to show the best performer most often. And with dating, lets be honest, you wouldn&amp;rsquo;t keep seeing someone if you weren&amp;#39;t that interested in them. So in both scenarios we are optimizing for the best performers.  So what happens after you deem a winning ad text or date? With ad texts you would then take your lowest performers out of the mix and replace with new ad texts to test against your control (the winning ad).  With dating I presume you would continue seeing the winning date until they do something to turn you off or until someone better comes along (a new control).  In either scenario you have the best performer 100% of the time until that no longer works for your goals in mind. The main thing to keep in mind is to not be complacent with your ad copy or it could be costing you clicks and ultimately, sales.
&lt;/p&gt;
&lt;p&gt;
###
&lt;/p&gt;
&lt;p&gt;
Amberly Stitzel is the Interactive Marketing Manager for LeapFrog Interactive. She has been in the search engine marketing industry for over three years and is certified inGoogle AdWords, MSN AdCenter and the Yahoo Ambassador Program.&lt;br /&gt;
&lt;a href="mailto:astitzel@leapfroginteractive.com"&gt;astitzel@leapfroginteractive.com &lt;/a&gt;
&lt;/p&gt;
</description>
      <link>http://www.internetblu.com/post/2009/05/Why--Testing-Your-Pay-Per-Click-(PPC)-Ad-Text-is-Like-Dating.aspx</link>
      <author>John Callaway</author>
      <comments>http://www.internetblu.com/post/2009/05/Why--Testing-Your-Pay-Per-Click-(PPC)-Ad-Text-is-Like-Dating.aspx#comment</comments>
      <guid>http://www.internetblu.com/post.aspx?id=1cf21564-70cc-4aef-b0e6-5453020e1079</guid>
      <pubDate>Mon, 04 May 2009 08:33:00 -0500</pubDate>
      <category>Internet Marketing</category>
      <dc:publisher>John Callaway</dc:publisher>
      <pingback:server>http://www.internetblu.com/pingback.axd</pingback:server>
      <pingback:target>http://www.internetblu.com/post.aspx?id=1cf21564-70cc-4aef-b0e6-5453020e1079</pingback:target>
      <slash:comments>6</slash:comments>
      <trackback:ping>http://www.internetblu.com/trackback.axd?id=1cf21564-70cc-4aef-b0e6-5453020e1079</trackback:ping>
      <wfw:comment>http://www.internetblu.com/post/2009/05/Why--Testing-Your-Pay-Per-Click-(PPC)-Ad-Text-is-Like-Dating.aspx#comment</wfw:comment>
      <wfw:commentRss>http://www.internetblu.com/syndication.axd?post=1cf21564-70cc-4aef-b0e6-5453020e1079</wfw:commentRss>
    </item>
    <item>
      <title>What Good is a CMS if You Can't Add Pages?</title>
      <description>&lt;p&gt;
Recently I&amp;#39;ve been working with a local &lt;em&gt;not for profit&lt;/em&gt; organization.&amp;nbsp; Early on in my meetings with them it was discussed that they needed a new website.&amp;nbsp; I offered my services and suggestions through numerous emails and lunch meetings.&amp;nbsp; At then end of that initial run I had suggested a new website using one of a number of Content Management Systems (CMS) available on the market.&amp;nbsp; The organization members at that last meeting thanked me and stated that they had someone volunteer to design, code, and host a solution for them.&amp;nbsp; &amp;quot;Great,&amp;quot; I thought, &amp;quot;less work for me to do.&amp;quot;
&lt;/p&gt;
&lt;p&gt;
It was in my next coorespondance with this group that made me a little nervous about their choice.&amp;nbsp; It turned out that the &lt;em&gt;volunteer&lt;/em&gt; was actually selling his services as a design group and host provider.&amp;nbsp; We discussed his proposed solution and I pointed out some of the limitations that I thought would hurt this particular venture.&amp;nbsp; The designer assured me that he had a custom designed, home grown application that would be perfect for them, and promptly pushed me aside.
&lt;/p&gt;

&lt;p&gt;
At this point I was shaken, but not down for the count.&amp;nbsp; I tried one last time to urge the organization to reconsider their choice and reevaluate their options on the proposed solution.&amp;nbsp; Again, I was ignored and the project began under my objections.&amp;nbsp;&amp;nbsp;
&lt;/p&gt;
&lt;p&gt;
I continued to weigh in from time to time, as I had more interest in the organization as a whole, not just their web presence.&amp;nbsp; The provider took 6 months to deliver his turn key product, and as I feared it is lacking basic functionality.&amp;nbsp; What makes things worse is that the organization has asked if I would volunteer to maintain their site for them, since they believe all it is lacking is basic content.&amp;nbsp; As a web professional I know&amp;nbsp; that much more is needed.
&lt;/p&gt;
&lt;p&gt;
My initial questions to the provider upon taking over site administration has led me to discover that you can&amp;#39;t actually add pages to the site.&amp;nbsp; Let me say that again, in this custom Content Management System you can&amp;#39;t add pages!&amp;nbsp; Wouldn&amp;#39;t that be a basic feature for any Content Management System, light weight or otherwise?&amp;nbsp; I would think that would be a requirement.&amp;nbsp; What are users to do when new information is to be published?&amp;nbsp; Do existing pages just grow exponentially?&amp;nbsp; That seems a bit ridiculous to me.
&lt;/p&gt;
&lt;p&gt;
My next gripe is the lack of Search Engine Optimization (SEO) capabilities.&amp;nbsp; Pages, as they exist today do not contain any meta tags... at all.&amp;nbsp; No keywords.&amp;nbsp; No descriptions.&amp;nbsp; There are no heading tags (h1, h2, etc.) of any kind.&amp;nbsp; There isn&amp;#39;t a single page that contains valid markup, even though each page is listed as XHTML 1.0 Transitional.&amp;nbsp; When I asked the provider to grant me FTP and database access he questioned the need, the purpose.&amp;nbsp; The need, quite simply, is to fix your lame CMS for you.
&lt;/p&gt;
&lt;p&gt;
The &amp;quot;blog&amp;quot; is simply a link to BlogSpot, for goodness sakes! 
&lt;/p&gt;
&lt;p&gt;
Am I wrong?&amp;nbsp; Would you be happy with a CMS with so few and lacking features?&amp;nbsp; What should I do?&amp;nbsp; Should I continue to fight the ignorant provider, or should I break down and port the site to a more feature rich (basic, even) CMS? Let me hear your thoughts, readers and fellow bloggers.&amp;nbsp;  
&lt;/p&gt;
</description>
      <link>http://www.internetblu.com/post/2009/04/What-Good-is-a-CMS-if-You-Cant-Add-Pages.aspx</link>
      <author>John Callaway</author>
      <comments>http://www.internetblu.com/post/2009/04/What-Good-is-a-CMS-if-You-Cant-Add-Pages.aspx#comment</comments>
      <guid>http://www.internetblu.com/post.aspx?id=91e21e20-1333-402f-af40-624f6e6a50d7</guid>
      <pubDate>Fri, 10 Apr 2009 16:00:00 -0500</pubDate>
      <category>Search Engine Optimization</category>
      <dc:publisher>John Callaway</dc:publisher>
      <pingback:server>http://www.internetblu.com/pingback.axd</pingback:server>
      <pingback:target>http://www.internetblu.com/post.aspx?id=91e21e20-1333-402f-af40-624f6e6a50d7</pingback:target>
      <slash:comments>6</slash:comments>
      <trackback:ping>http://www.internetblu.com/trackback.axd?id=91e21e20-1333-402f-af40-624f6e6a50d7</trackback:ping>
      <wfw:comment>http://www.internetblu.com/post/2009/04/What-Good-is-a-CMS-if-You-Cant-Add-Pages.aspx#comment</wfw:comment>
      <wfw:commentRss>http://www.internetblu.com/syndication.axd?post=91e21e20-1333-402f-af40-624f6e6a50d7</wfw:commentRss>
    </item>
    <item>
      <title>New Position, New Technologies</title>
      <description>&lt;p&gt;I&amp;#39;ve taken a new position with a relatively new custom web development firm. &amp;nbsp;I&amp;#39;ve completed 2 full weeks with the new company. &amp;nbsp;So far it&amp;#39;s been really exciting.&lt;/p&gt;&lt;p&gt;With the new position I&amp;#39;ve had the opportunity to work on some newer technologies. &amp;nbsp;For my first project I&amp;#39;ve had to chance to use Visual Studio 2008, C# with ASP.NET 3.5, SQL Server 2008, ADO.NET Entity Framework, LINQ to Entities, and more. &amp;nbsp;New development with new technologies is a welcome change. &amp;nbsp;It seems a lot of my career has been enhancement and maintenance programming on existing systems.&lt;/p&gt;&lt;p&gt;My question to my readers is, of the technologies listed above, what would you like the next few posts to focus on? &amp;nbsp;Please contribute to the discussion by adding your comments below.&amp;nbsp;&lt;/p&gt;</description>
      <link>http://www.internetblu.com/post/2009/03/New-Position-New-Technologies.aspx</link>
      <author>John Callaway</author>
      <comments>http://www.internetblu.com/post/2009/03/New-Position-New-Technologies.aspx#comment</comments>
      <guid>http://www.internetblu.com/post.aspx?id=5f399ae1-cdd3-4094-a9a8-66632266f579</guid>
      <pubDate>Sun, 29 Mar 2009 16:08:00 -0500</pubDate>
      <category>ASP.NET</category>
      <dc:publisher>John Callaway</dc:publisher>
      <pingback:server>http://www.internetblu.com/pingback.axd</pingback:server>
      <pingback:target>http://www.internetblu.com/post.aspx?id=5f399ae1-cdd3-4094-a9a8-66632266f579</pingback:target>
      <slash:comments>3</slash:comments>
      <trackback:ping>http://www.internetblu.com/trackback.axd?id=5f399ae1-cdd3-4094-a9a8-66632266f579</trackback:ping>
      <wfw:comment>http://www.internetblu.com/post/2009/03/New-Position-New-Technologies.aspx#comment</wfw:comment>
      <wfw:commentRss>http://www.internetblu.com/syndication.axd?post=5f399ae1-cdd3-4094-a9a8-66632266f579</wfw:commentRss>
    </item>
    <item>
      <title>Retrieving aspnet Profile Property Data using SQL</title>
      <description>&lt;p&gt;
Recently, I was working on a project that used ASP.NET Membership and Profiles.&amp;nbsp; The 
application worked great, but there was a problem with the user profile data and 
reporting.&amp;nbsp; &lt;br /&gt;
&lt;br /&gt;
Using aspnet Membership and Profiles is great.&amp;nbsp; It&amp;#39;s quite easy to retrieve, 
update, and insert profile data using .NET.&amp;nbsp; However, our reporting team was 
having difficulty retrieving the user profile data for their reporting cubes and 
data warehouse.&amp;nbsp; This wouldn&amp;#39;t be a problem using CLR in SQL Server 2005 or 
2008, but for this particular project we were still on SQL Server 2000.&lt;br /&gt;
&lt;br /&gt;
After an exhaustive web search I was unable to find any quick and easy way to 
retrieve the data using anything other than .NET code.&amp;nbsp; This simply would not 
do.&amp;nbsp; Surely there is a way to do this, right?&amp;nbsp; Perhaps a &lt;strong&gt;User Defined 
Function&lt;/strong&gt;?
&lt;/p&gt;
&lt;p&gt;
So, I set about writing my own &lt;strong&gt;User Defined Function&lt;/strong&gt; for 
this project. 
&lt;/p&gt;
 
&lt;p&gt;
&lt;div class="codeSnippet"&gt;
	&lt;div class="codeHeader"&gt;
		&lt;img src="http://blog.furred.net/pics/page_white_code.png" /&gt;
		&lt;a href="" onclick="document.getElementById('snippet_8').style.display = document.getElementById('snippet_8').style.display == 'none' ? 'block' : 'none'; return false;"
		title="Click for expanding.."&gt;SQL-Code: User Defined Function&lt;/a&gt;
	&lt;/div&gt;
	&lt;pre id="snippet_8" class="codeContainer"&gt;&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=CREATE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;CREATE&lt;/a&gt; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=FUNCTION&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;FUNCTION&lt;/a&gt; [dbo].[aspnet_Profile_GetProfile]
(
&amp;nbsp;&amp;nbsp;&amp;nbsp; @UserID &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=UNIQUEIDENTIFIER&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;UNIQUEIDENTIFIER&lt;/a&gt;,
&amp;nbsp;&amp;nbsp;&amp;nbsp; @PropertyName &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=varchar&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;varchar&lt;/a&gt;(100),
&amp;nbsp;&amp;nbsp;&amp;nbsp; @ApplicationName &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=NVARCHAR&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;NVARCHAR&lt;/a&gt;(256) = &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=NULL&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;NULL&lt;/a&gt;
)
&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=RETURNS&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;RETURNS&lt;/a&gt; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=VARCHAR&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;VARCHAR&lt;/a&gt;(100)
&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=AS&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;AS&lt;/a&gt;
&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=BEGIN&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;BEGIN&lt;/a&gt;

&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=DECLARE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;DECLARE&lt;/a&gt; @ApplicationID &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=UNIQUEIDENTIFIER&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;UNIQUEIDENTIFIER&lt;/a&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=DECLARE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;DECLARE&lt;/a&gt; @StartPosition &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=INT&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;INT&lt;/a&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=DECLARE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;DECLARE&lt;/a&gt; @PropertyLength &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=INT&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;INT&lt;/a&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=DECLARE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;DECLARE&lt;/a&gt; @&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Return&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Return&lt;/a&gt; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=VARCHAR&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;VARCHAR&lt;/a&gt;(100)

&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=IF&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;IF&lt;/a&gt; @ApplicationName &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=IS&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;IS&lt;/a&gt; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=NULL&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;NULL&lt;/a&gt; 
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=SELECT&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;SELECT&lt;/a&gt; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=TOP&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;TOP&lt;/a&gt; 1 @ApplicationName = LoweredApplicationName, @ApplicationID = ApplicationID &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=FROM&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;FROM&lt;/a&gt; aspnet_Applications &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=ORDER&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;ORDER&lt;/a&gt; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=BY&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;BY&lt;/a&gt; ApplicationId
&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=ELSE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;ELSE&lt;/a&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=SELECT&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;SELECT&lt;/a&gt; @ApplicationID = ApplicationID &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=FROM&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;FROM&lt;/a&gt; aspnet_Applications &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=WHERE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;WHERE&lt;/a&gt; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=LOWER&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;LOWER&lt;/a&gt;(@ApplicationName) = LoweredApplicationName

&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=IF&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;IF&lt;/a&gt; (@ApplicationId &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=IS&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;IS&lt;/a&gt; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=NULL&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;NULL&lt;/a&gt;)
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=RETURN&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;RETURN&lt;/a&gt; 0

&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=DECLARE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;DECLARE&lt;/a&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; @RowData &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=nvarchar&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;nvarchar&lt;/a&gt;(2000)
&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=DECLARE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;DECLARE&lt;/a&gt; @SplitOn &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=nvarchar&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;nvarchar&lt;/a&gt;(5)

&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=DECLARE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;DECLARE&lt;/a&gt; @PropertyTable &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=table&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;table&lt;/a&gt; 
&amp;nbsp;&amp;nbsp;&amp;nbsp; (
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; Id &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=int&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;int&lt;/a&gt; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=identity&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;identity&lt;/a&gt;(1,1),
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; Property &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=nvarchar&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;nvarchar&lt;/a&gt;(100),
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; DataType &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=CHAR&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;CHAR&lt;/a&gt;(1),
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; Start &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=INT&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;INT&lt;/a&gt;,
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; Length &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=INT&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;INT&lt;/a&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; ) 

&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=SELECT&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;SELECT&lt;/a&gt; @RowData = PropertyNames
&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=FROM&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;FROM&lt;/a&gt; aspnet_Profile
&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=WHERE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;WHERE&lt;/a&gt; UserID = @UserID
&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=AND&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;AND&lt;/a&gt; PropertyNames &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=LIKE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;LIKE&lt;/a&gt; '&lt;span style="color:#8B0000"&gt;%&lt;/span&gt;'+@PropertyName+'&lt;span style="color:#8B0000"&gt;%&lt;/span&gt;'

&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=SET&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;SET&lt;/a&gt; @SplitOn = '&lt;span style="color:#8B0000"&gt;:&lt;/span&gt;'

&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=While&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;While&lt;/a&gt; (Charindex(@SplitOn,@RowData)&amp;gt;0)
&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Begin&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Begin&lt;/a&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Insert&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Insert&lt;/a&gt; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Into&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Into&lt;/a&gt; @PropertyTable (Property)
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Select&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Select&lt;/a&gt; ltrim(rtrim(&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Substring&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Substring&lt;/a&gt;(@RowData,1,Charindex(@SplitOn,@RowData)-1)))
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; 
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Set&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Set&lt;/a&gt; @RowData = &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Substring&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Substring&lt;/a&gt;(@RowData,Charindex(@SplitOn,@RowData)+1,len(@RowData))
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; 
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=UPDATE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;UPDATE&lt;/a&gt; @PropertyTable &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=SET&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;SET&lt;/a&gt; DataType = (
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Select&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Select&lt;/a&gt; ltrim(rtrim(&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Substring&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Substring&lt;/a&gt;(@RowData,1,Charindex(@SplitOn,@RowData)-1))))
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=WHERE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;WHERE&lt;/a&gt; Id = @@&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=IDENTITY&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;IDENTITY&lt;/a&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; 
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Set&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Set&lt;/a&gt; @RowData = &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Substring&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Substring&lt;/a&gt;(@RowData,Charindex(@SplitOn,@RowData)+1,len(@RowData))
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; 
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=UPDATE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;UPDATE&lt;/a&gt; @PropertyTable &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=SET&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;SET&lt;/a&gt; Start = (
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Select&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Select&lt;/a&gt; ltrim(rtrim(&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Substring&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Substring&lt;/a&gt;(@RowData,1,Charindex(@SplitOn,@RowData)-1))))
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=WHERE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;WHERE&lt;/a&gt; Id = @@&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=IDENTITY&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;IDENTITY&lt;/a&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; 
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Set&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Set&lt;/a&gt; @RowData = &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Substring&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Substring&lt;/a&gt;(@RowData,Charindex(@SplitOn,@RowData)+1,len(@RowData))
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; 
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=UPDATE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;UPDATE&lt;/a&gt; @PropertyTable &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=SET&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;SET&lt;/a&gt; Length = (
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Select&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Select&lt;/a&gt; ltrim(rtrim(&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Substring&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Substring&lt;/a&gt;(@RowData,1,Charindex(@SplitOn,@RowData)-1))))
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=WHERE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;WHERE&lt;/a&gt; Id = @@&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=IDENTITY&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;IDENTITY&lt;/a&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; 
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Set&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Set&lt;/a&gt; @RowData = &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Substring&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Substring&lt;/a&gt;(@RowData,Charindex(@SplitOn,@RowData)+1,len(@RowData))
&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=END&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;END&lt;/a&gt;

&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=SELECT&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;SELECT&lt;/a&gt; @StartPosition = Start, @PropertyLength = Length &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=FROM&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;FROM&lt;/a&gt; @PropertyTable &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=WHERE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;WHERE&lt;/a&gt; Property = @PropertyName

&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=SELECT&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;SELECT&lt;/a&gt; @&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Return&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Return&lt;/a&gt; = &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=SUBSTRING&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;SUBSTRING&lt;/a&gt;(PropertyValuesString, @StartPosition + 1, @PropertyLength)
&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=FROM&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;FROM&lt;/a&gt; aspnet_Profile
&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=WHERE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;WHERE&lt;/a&gt; UserID = @UserID
&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=AND&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;AND&lt;/a&gt; PropertyNames &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=LIKE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;LIKE&lt;/a&gt; '&lt;span style="color:#8B0000"&gt;%&lt;/span&gt;'+@PropertyName+'&lt;span style="color:#8B0000"&gt;%&lt;/span&gt;'

&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=RETURN&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;RETURN&lt;/a&gt; @&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=Return&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;Return&lt;/a&gt;
&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=END&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;END&lt;/a&gt;
&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=GO&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;GO&lt;/a&gt;&lt;/pre&gt;
&lt;/div&gt;
&lt;script type="text/javascript"&gt;
	document.getElementById('snippet_8').style.display='none';
&lt;/script&gt; 
&lt;br /&gt;
&lt;/p&gt;
&lt;p&gt;
This was simple enough and seems to work rather well.&amp;nbsp; All you have to do is 
pass in the UserID, PropertyName, and ApplicationName and you get back the 
ProperyValue of the user profile.&amp;nbsp; Here&amp;#39;s the usage information: 
&lt;/p&gt;
&lt;p&gt;
&lt;div class="codeSnippet"&gt;
	&lt;div class="codeHeader"&gt;
		&lt;img src="http://blog.furred.net/pics/page_white_code.png" /&gt;
		&lt;a href="" onclick="document.getElementById('snippet_9').style.display = document.getElementById('snippet_9').style.display == 'none' ? 'block' : 'none'; return false;"
		title="Click for expanding.."&gt;SQL-Code: Usage&lt;/a&gt;
	&lt;/div&gt;
	&lt;pre id="snippet_9" class="codeContainer"&gt;
&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=SELECT&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;SELECT&lt;/a&gt; dbo.aspnet_Profile_GetProfile(UserID, PropertyName, ApplicationName)
&lt;/pre&gt;
&lt;/div&gt;
&lt;script type="text/javascript"&gt;
	document.getElementById('snippet_9').style.display='none';
&lt;/script&gt; 
&lt;br /&gt;
&lt;/p&gt;
&lt;p&gt;
I also included a default NULL value for ApplicationName, for the cases where 
there is only one application and/or the ApplicationName is unknown to the 
user.&amp;nbsp; In this instance it will grab the first application from the 
aspnet_Applications table.&amp;nbsp; Here&amp;#39;s an example retrieving FirstName and LastName 
for all aspnet_users: 
&lt;/p&gt;
&lt;p&gt;
&lt;div class="codeSnippet"&gt;
	&lt;div class="codeHeader"&gt;
		&lt;img src="http://blog.furred.net/pics/page_white_code.png" /&gt;
		&lt;a href="" onclick="document.getElementById('snippet_10').style.display = document.getElementById('snippet_10').style.display == 'none' ? 'block' : 'none'; return false;"
		title="Click for expanding.."&gt;SQL-Code: Example 1&lt;/a&gt;
	&lt;/div&gt;
	&lt;pre id="snippet_10" class="codeContainer"&gt;
&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=SELECT&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;SELECT&lt;/a&gt; userid, username,
&amp;nbsp;&amp;nbsp;&amp;nbsp; dbo.aspnet_Profile_GetProfile(userid, '&lt;span style="color:#8B0000"&gt;FirstName&lt;/span&gt;', &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=DEFAULT&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;DEFAULT&lt;/a&gt;) &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=AS&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;AS&lt;/a&gt; FirstName,
&amp;nbsp;&amp;nbsp;&amp;nbsp; dbo.aspnet_Profile_GetProfile(userid, '&lt;span style="color:#8B0000"&gt;LastName&lt;/span&gt;', &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=DEFAULT&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;DEFAULT&lt;/a&gt;) &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=AS&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;AS&lt;/a&gt; LastName
&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=FROM&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;FROM&lt;/a&gt; aspnet_users
&lt;/pre&gt;
&lt;/div&gt;
&lt;script type="text/javascript"&gt;
	document.getElementById('snippet_10').style.display='none';
&lt;/script&gt; 
&lt;br /&gt;
&lt;/p&gt;
&lt;p&gt;
Here&amp;#39;s another example passing in the ApplicationName, joining to the 
aspnet_Applications table.&amp;nbsp; Please note that the syntax is the same as any 
standard SQL query.&amp;nbsp; Return as little or as much information as you like.&amp;nbsp; 
&lt;/p&gt;
&lt;p&gt;
&lt;div class="codeSnippet"&gt;
	&lt;div class="codeHeader"&gt;
		&lt;img src="http://blog.furred.net/pics/page_white_code.png" /&gt;
		&lt;a href="" onclick="document.getElementById('snippet_11').style.display = document.getElementById('snippet_11').style.display == 'none' ? 'block' : 'none'; return false;"
		title="Click for expanding.."&gt;SQL-Code: Example 2&lt;/a&gt;
	&lt;/div&gt;
	&lt;pre id="snippet_11" class="codeContainer"&gt;
&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=SELECT&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;SELECT&lt;/a&gt; LU.UserID, LU.UserName,
&amp;nbsp;&amp;nbsp;&amp;nbsp; dbo.aspnet_Profile_GetProfile(LU.UserID, '&lt;span style="color:#8B0000"&gt;FirstName&lt;/span&gt;', AP.ApplicationName) &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=AS&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;AS&lt;/a&gt; FirstName, 
&amp;nbsp;&amp;nbsp;&amp;nbsp; dbo.aspnet_Profile_GetProfile(LU.UserID, '&lt;span style="color:#8B0000"&gt;LastName&lt;/span&gt;', AP.ApplicationName) &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=AS&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;AS&lt;/a&gt; LastName&amp;nbsp;&amp;nbsp;&amp;nbsp; 
&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=FROM&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;FROM&lt;/a&gt; dbo.aspnet_Users LU
&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=INNER&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;INNER&lt;/a&gt; &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=JOIN&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;JOIN&lt;/a&gt; dbo.aspnet_Applications AP &lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=ON&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;ON&lt;/a&gt; LU.ApplicationID = AP.ApplicationID
&lt;a href="http://search.microsoft.com/default.asp?so=RECCNT&amp;siteid=us%2Fdev&amp;p=1&amp;nq=NEW&amp;qu=WHERE&amp;IntlSearch=&amp;boolean=PHRASE&amp;ig=01&amp;i=09&amp;i=99" style="color:#0000FF"&gt;WHERE&lt;/a&gt; AP.ApplicationName = '&lt;span style="color:#8B0000"&gt;[ApplicationName]&lt;/span&gt;'
&lt;/pre&gt;
&lt;/div&gt;
&lt;script type="text/javascript"&gt;
	document.getElementById('snippet_11').style.display='none';
&lt;/script&gt; 
&lt;br /&gt;
&lt;/p&gt;
&lt;p&gt;
Hopefully this will help&amp;nbsp;those that may be&amp;nbsp;struggling with how to retrieve 
profile data from the aspnet_Profiles table.&amp;nbsp; This is done quite easily through 
.NET, but somewhat combersome with SQL.&amp;nbsp; The User Defined Function has the added 
benefit of a single point for code change, should Microsoft change the way the 
data is stored in future releases. 
&lt;/p&gt;
&lt;p&gt;
More resources: 
&lt;/p&gt;
&lt;ul&gt;
	&lt;li&gt;&lt;a href="http://msdn.microsoft.com/en-us/library/yh26yfzy.aspx"&gt;Introduction to 
	Membership&lt;/a&gt;&lt;/li&gt;
	&lt;li&gt;&lt;a href="http://msdn.microsoft.com/en-us/library/2y3fs9xs.aspx"&gt;ASP.NET Profile 
	Properties Overview&lt;/a&gt;&lt;/li&gt;
	&lt;li&gt;&lt;a href="http://weblogs.asp.net/scottgu/archive/2006/02/24/438953.aspx"&gt;ASP.NET 2.0 Membership, Roles, Forms Authentication, and Security Resources&lt;/a&gt;&lt;br /&gt;
	&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;
If you have any questions, comments, or concerns please use the &lt;a href="http://www.internetblu.com/contact.aspx"&gt;Contact 
Form&lt;/a&gt;. 
&lt;/p&gt;
&lt;h3&gt;
Download&amp;nbsp;
&lt;/h3&gt;
&lt;p&gt;
&lt;a rel="enclosure" href="http://www.internetblu.com/file.axd?file=UDF_aspnet_Profile_GetProfile_v1.zip"&gt;UDF_aspnet_Profile_GetProfile_v1.zip (1.19 kb)&lt;/a&gt;
&lt;/p&gt;
</description>
      <link>http://www.internetblu.com/post/2009/02/Retrieving-aspnet-Profile-Property-Data-using-SQL.aspx</link>
      <author>John Callaway</author>
      <comments>http://www.internetblu.com/post/2009/02/Retrieving-aspnet-Profile-Property-Data-using-SQL.aspx#comment</comments>
      <guid>http://www.internetblu.com/post.aspx?id=f07712f9-30c4-4b5e-87bb-cd4c40bdc2d8</guid>
      <pubDate>Fri, 06 Feb 2009 15:08:00 -0500</pubDate>
      <category>ASP.NET</category>
      <dc:publisher>John Callaway</dc:publisher>
      <pingback:server>http://www.internetblu.com/pingback.axd</pingback:server>
      <pingback:target>http://www.internetblu.com/post.aspx?id=f07712f9-30c4-4b5e-87bb-cd4c40bdc2d8</pingback:target>
      <slash:comments>6</slash:comments>
      <trackback:ping>http://www.internetblu.com/trackback.axd?id=f07712f9-30c4-4b5e-87bb-cd4c40bdc2d8</trackback:ping>
      <wfw:comment>http://www.internetblu.com/post/2009/02/Retrieving-aspnet-Profile-Property-Data-using-SQL.aspx#comment</wfw:comment>
      <wfw:commentRss>http://www.internetblu.com/syndication.axd?post=f07712f9-30c4-4b5e-87bb-cd4c40bdc2d8</wfw:commentRss>
    </item>
    <item>
      <title>ShareThis Extension for BlogEngine.NET</title>
      <description>&lt;h3&gt;
Add ShareThis to any page or post!
&lt;/h3&gt;
&lt;p&gt;
After the great success of the my first two BlogEngine.NET extensions (&lt;a href="http://www.internetblu.com/post/2008/12/Digg-Button-Extension-for-BlogEngineNET.aspx" title="BlogEngine.NET"&gt;Digg Button Extensions for BlogEngine.NET&lt;/a&gt; and &lt;a href="http://www.internetblu.com/post/2008/12/jQuery-Extension-for-BlogEngineNET.aspx"&gt;jQuery Extension for BlogEngine.NET&lt;/a&gt;)
I decided to try one more.&amp;nbsp; Several of my coworkers and I have been using BlogEngine in our off hours.&amp;nbsp; Some of the latest discussions have been around the use of extensions and user controls to eliminate the need to make any other code modifications.&amp;nbsp; This lead me to create the following ShareThis extension.&amp;nbsp; Below you will
find download and installation instructions.&amp;nbsp; If you have any questions
please feel free to use the &lt;a href="http://www.internetblu.com/contact.aspx"&gt;Contact Form&lt;/a&gt;.
&lt;/p&gt;
&lt;h3 id="installation"&gt;Installation&lt;/h3&gt;
&lt;p&gt;
Download the compressed file ShareThis_Extension_v1.0.zip, then: 
&lt;/p&gt;
&lt;ol&gt;
	&lt;li&gt;Extract the file. &lt;/li&gt;
	&lt;li&gt;Copy &lt;strong&gt;ShareThis.cs&lt;/strong&gt; into &lt;em&gt;/App_Code/Extensions/&lt;/em&gt; folder &lt;/li&gt;
&lt;/ol&gt;

&lt;br /&gt;
&lt;h3 id="configuration"&gt;Configuration&lt;/h3&gt;
&lt;p&gt;
The component is completely configurable valuing the following mandatory attributes : 
&lt;/p&gt;
&lt;ul&gt;
	&lt;li&gt;&lt;strong&gt;Publisher ID&lt;/strong&gt;: Your ShareThis Publisher ID. &lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;ShareThis File Location&lt;/strong&gt;: The location of the ShareThis JavaScript extension.&lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;ShareThis Style&lt;/strong&gt;: At this time ShareThis Style options are &lt;em&gt;Default &lt;/em&gt;and &lt;em&gt;Rotate&lt;/em&gt;.&lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;Character Set&lt;/strong&gt;: ShareThis character set. &lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;Tabs&lt;/strong&gt;: Tabs to show.&lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;Services&lt;/strong&gt;: Which services to display by default.&lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;HeaderBG&lt;/strong&gt;: Background color of the ShareThis header.&lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;InactiveBG&lt;/strong&gt;: Background color of the inactive link(s).&lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;InactiveFG&lt;/strong&gt;: Foreground color of the inactive link(s).&lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;LinkFG&lt;/strong&gt;: Foreground color of active link(s).&lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;OffsetLeft&lt;/strong&gt;: Left offset of the tabs.&lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;OffsetTop&lt;/strong&gt;: Top offset of the tabs.&lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;Popup&lt;/strong&gt;: Popup true or false.&lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;Embed&lt;/strong&gt;: Embed true or false.&lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;Position&lt;/strong&gt;: Position to display ShareThis.&lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;Insert in [P]ost, P[A]ges, [B]oth&lt;/strong&gt;: Show ShareThis in Post, Pages, or Both.&lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;CSS Style Code&lt;/strong&gt;: Add CSS Style Code to change the display.&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;
The extension will be loaded with default options.&amp;nbsp; &lt;strong&gt;Don&amp;#39;t forget to change the Publisher ID&lt;/strong&gt;!
&lt;/p&gt;
&lt;h3&gt;Additional Resources &lt;/h3&gt;
&lt;ul&gt;
	&lt;li&gt;The official ShareThis site - &lt;a href="http://sharethis.com/"&gt;http://sharethis.com&lt;/a&gt;&lt;/li&gt;
	&lt;li&gt;Preview ShareThis settings - &lt;a href="http://sharethis.com/publishers/getbutton/"&gt;http://sharethis.com/publishers/getbutton/&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;h3&gt;Download &lt;/h3&gt;
&lt;p&gt;
&lt;a rel="enclosure" href="http://www.internetblu.com/file.axd?file=ShareThis_Extension_v1.0.zip"&gt;ShareThis_Extension_v1.0.zip (2.15 kb)&lt;/a&gt;&amp;nbsp;
&lt;/p&gt;
&lt;p&gt;
Please use the &lt;a href="http://www.internetblu.com/contact.aspx"&gt;Contact Form&lt;/a&gt; to submit any bugs or feature requests. 
&lt;/p&gt;
</description>
      <link>http://www.internetblu.com/post/2009/01/ShareThis-Extension-for-BlogEngineNET.aspx</link>
      <author>John Callaway</author>
      <comments>http://www.internetblu.com/post/2009/01/ShareThis-Extension-for-BlogEngineNET.aspx#comment</comments>
      <guid>http://www.internetblu.com/post.aspx?id=fc43ff2f-110c-4476-a70d-d5f5948e1606</guid>
      <pubDate>Sun, 25 Jan 2009 09:31:00 -0500</pubDate>
      <category>BlogEngine Extension</category>
      <dc:publisher>John Callaway</dc:publisher>
      <pingback:server>http://www.internetblu.com/pingback.axd</pingback:server>
      <pingback:target>http://www.internetblu.com/post.aspx?id=fc43ff2f-110c-4476-a70d-d5f5948e1606</pingback:target>
      <slash:comments>9</slash:comments>
      <trackback:ping>http://www.internetblu.com/trackback.axd?id=fc43ff2f-110c-4476-a70d-d5f5948e1606</trackback:ping>
      <wfw:comment>http://www.internetblu.com/post/2009/01/ShareThis-Extension-for-BlogEngineNET.aspx#comment</wfw:comment>
      <wfw:commentRss>http://www.internetblu.com/syndication.axd?post=fc43ff2f-110c-4476-a70d-d5f5948e1606</wfw:commentRss>
    </item>
    <item>
      <title>Why Managing Your Pay Per Click Budget is Like Going to the Delicatessen</title>
      <description>
&lt;p&gt;
&lt;em&gt;The following is a guest post from good friend and SEO and PPC expert, Amberly Stitzel.&lt;/em&gt;
&lt;/p&gt;
&lt;p&gt;
by Amberly Stitzel
&lt;/p&gt;
&lt;p&gt;
Managing pay per click budget can be somewhat tricky for those who have not had much experience in handling them. Some would say it is like a delicate art form but there are a couple of takeaways that I have learned that I would like to share so expectations are set ahead of time in order to help you have a successful pay per click campaign.
&lt;/p&gt;
&lt;p&gt;
One of the quickest lessons I learned in managing pay per click campaigns is that your daily spending limit, or budget, is one of the most volatile pieces of the pay per click equation. When you go to the delicatessen and ask for a pound of turkey they don&amp;rsquo;t add or take away turkey until it is exactly one pound. You expect that it will be just under or just over (most often over) the amount you ask for because the precision it would take to get it exact is often not worth the time and effort. The same is true for your pay per click budget. If you are trying to get your budget right at $300 it would be pointless to sit there and refresh every 10 seconds until you hit that amount so you could turn the campaign off.
&lt;/p&gt;

&lt;p&gt;
Instead of monitoring your budget constantly for precision, let the search engine assist you. Start by determining what your weekly budget is; for me this is often set by the client. Once you have the weekly budget you can set your daily budget based on how many days per week you are running your campaigns. I recommend testing all seven days of the week before deciding to eliminate days of the week from your schedule.&amp;nbsp; Once you have your daily budget you can then set that amount in the engine and let it cap that amount for you. So what happens if one day has a larger search volume than your budget can handle? This is where the overage at the delicatessen comes into play. The engines will allow a slight overage on days when traffic is high to allow your campaigns to take advantage of the traffic when it is available.&amp;nbsp; Search engine traffic for your keywords will not be exactly the same each day, week and month of the year. One days&amp;rsquo; traffic could be lower than you budget and if the budget capped at $300 the first day and only reached $250 the following day you still have leftover budget you have not spent for the two days combined. The engines will not go over your weekly budget but will allow a variance by day to take advantage of differing levels of traffic. 
&lt;/p&gt;
&lt;p&gt;
The only other caveat in managing your budget is to pay special attention when you do have day parting turned on (campaigns only run at certain times of the day). One thing the engines do to help your budget last for more hours of the day is show them intermittently throughout the day if you do not have enough to fully fund all impressions and clicks in the hours you have the campaign running. One thing I have learned in this scenario is to set your budget higher than you actually want it so that you have the opportunity to hit the budget you want. Otherwise your ads will be shown at a slower rate throughout the day and will never have a chance to hit the intended budget if it is a substantial amount.&amp;nbsp; This technique is most applicable when you have multiple campaigns running in one account and are not sure ahead of time what your spend per day for each campaign will be. Be sure to monitor your budget more closely if you are using this technique because there is a better chance that you will go over your intended daily budget if you set it higher than what you actually have available to spend.
&lt;/p&gt;
&lt;p&gt;
In addition, it is important to coach your clients on the fact that pay per click is not an exact science so an agreed upon overage to a pay per click budget is recommended.&amp;nbsp; I recommend a 5% overage on all pay per click budgets so that opportunities can be taken advantage of on high traffic days and to set a realistic expectation for your clients so that both parties are satisfied. 
&lt;/p&gt;
&lt;p&gt;
###
&lt;/p&gt;
&lt;p&gt;
&lt;strong&gt;
Amberly Stitzel&lt;/strong&gt; is the Interactive Marketing Manager for LeapFrog Interactive. She has been in the search engine marketing industry for over three years and is certified inGoogle AdWords, MSN AdCenter and the Yahoo Ambassador Program.&lt;br /&gt;
&lt;a href="mailto:astitzel@leapfroginteractive.com"&gt;astitzel@leapfroginteractive.com&lt;/a&gt;
&lt;/p&gt;
</description>
      <link>http://www.internetblu.com/post/2009/01/Managing-your-Pay-Per-Click-Budget-Delicatessen.aspx</link>
      <author>John Callaway</author>
      <comments>http://www.internetblu.com/post/2009/01/Managing-your-Pay-Per-Click-Budget-Delicatessen.aspx#comment</comments>
      <guid>http://www.internetblu.com/post.aspx?id=f020adeb-79bb-4f62-9e72-69c906db335a</guid>
      <pubDate>Mon, 12 Jan 2009 08:27:00 -0500</pubDate>
      <category>Internet Marketing</category>
      <dc:publisher>John Callaway</dc:publisher>
      <pingback:server>http://www.internetblu.com/pingback.axd</pingback:server>
      <pingback:target>http://www.internetblu.com/post.aspx?id=f020adeb-79bb-4f62-9e72-69c906db335a</pingback:target>
      <slash:comments>5</slash:comments>
      <trackback:ping>http://www.internetblu.com/trackback.axd?id=f020adeb-79bb-4f62-9e72-69c906db335a</trackback:ping>
      <wfw:comment>http://www.internetblu.com/post/2009/01/Managing-your-Pay-Per-Click-Budget-Delicatessen.aspx#comment</wfw:comment>
      <wfw:commentRss>http://www.internetblu.com/syndication.axd?post=f020adeb-79bb-4f62-9e72-69c906db335a</wfw:commentRss>
    </item>
    <item>
      <title>A New Year, a New Look</title>
      <description>&lt;h3&gt;A new look for Internet Blu! &lt;br /&gt;
&lt;/h3&gt;
&lt;p&gt;
Well, the new year has finally arrived.&amp;nbsp; With it, I have updated the look of Internet Blu with a new theme.
&lt;/p&gt;
&lt;p&gt;
Since Internet Blu went live in June 2008 I haven&amp;#39;t done a very good job of monetizing or promoting this blog.&amp;nbsp; I&amp;#39;m hoping I can rectifiy that situation in the first part of the new year.&amp;nbsp; If you would like to support this site please visit one of our sponsor links.&amp;nbsp; Or, if you would like to become a site sponsor please visit our &lt;a href="http://www.internetblu.com/page/Advertise.aspx"&gt;advertising&lt;/a&gt; page for more information.
&lt;/p&gt;

&lt;p&gt;
During the next few months I hope to continue to provide more useful internet tools.&amp;nbsp; So far I&amp;#39;ve been able to provide a couple of BlogEngine.NET extensions.&amp;nbsp; If you missed these, be sure to visit the links below. 
&lt;/p&gt;
&lt;ul&gt;
	&lt;li&gt;&lt;a href="http://www.internetblu.com/post/2008/12/jQuery-Extension-for-BlogEngineNET.aspx"&gt;jQuery Extension for BlogEngine.NET&lt;/a&gt;&amp;nbsp;&lt;/li&gt;
	&lt;li&gt;&lt;a href="http://www.internetblu.com/post/2008/12/Digg-Button-Extension-for-BlogEngineNET.aspx"&gt;Digg Button Extension for BlogEngine.NET&lt;/a&gt;&lt;/li&gt;
	&lt;li&gt;More to come...&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;
If you have any ideas or requests for the coming months please add your comments below.
&lt;/p&gt;
&lt;p&gt;
Looking forward to a great 2009! 
&lt;/p&gt;
&lt;p&gt;
&amp;nbsp;
&lt;/p&gt;
</description>
      <link>http://www.internetblu.com/post/2009/01/A-New-Year-a-New-Look.aspx</link>
      <author>John Callaway</author>
      <comments>http://www.internetblu.com/post/2009/01/A-New-Year-a-New-Look.aspx#comment</comments>
      <guid>http://www.internetblu.com/post.aspx?id=041f7a8a-574c-4c25-8a30-610ba1264069</guid>
      <pubDate>Thu, 01 Jan 2009 16:33:00 -0500</pubDate>
      <category>Internet Blu Site News</category>
      <dc:publisher>John Callaway</dc:publisher>
      <pingback:server>http://www.internetblu.com/pingback.axd</pingback:server>
      <pingback:target>http://www.internetblu.com/post.aspx?id=041f7a8a-574c-4c25-8a30-610ba1264069</pingback:target>
      <slash:comments>0</slash:comments>
      <trackback:ping>http://www.internetblu.com/trackback.axd?id=041f7a8a-574c-4c25-8a30-610ba1264069</trackback:ping>
      <wfw:comment>http://www.internetblu.com/post/2009/01/A-New-Year-a-New-Look.aspx#comment</wfw:comment>
      <wfw:commentRss>http://www.internetblu.com/syndication.axd?post=041f7a8a-574c-4c25-8a30-610ba1264069</wfw:commentRss>
    </item>
    <item>
      <title>jQuery Extension for BlogEngine.NET</title>
      <description>&lt;h3&gt;
Add the jQuery Library to your blog!
&lt;/h3&gt;
&lt;p&gt;
After the great success of the my &lt;a href="http://www.internetblu.com/post/2008/12/Digg-Button-Extension-for-BlogEngineNET.aspx" title="BlogEngine.NET"&gt;Digg Button Extensions for BlogEngine.NET&lt;/a&gt;, I decided to try another.&amp;nbsp; With the growing popularity of jQuery I chose to write a jQuery Extension for BlogEngine.NET.&amp;nbsp; Below you will find download and installation instructions.&amp;nbsp; If you have any questions please feel free to use the &lt;a href="http://www.internetblu.com/contact.aspx"&gt;Contact Form&lt;/a&gt;.
&lt;/p&gt;
&lt;h3 id="installation"&gt;Installation&lt;/h3&gt;
&lt;p&gt;
Download the compressed file jQuery_Extension_v1.0.zip, then: 
&lt;/p&gt;
&lt;ol&gt;
	&lt;li&gt;Extract the files. &lt;/li&gt;
	&lt;li&gt;Copy &lt;strong&gt;jQuery.cs&lt;/strong&gt; into &lt;em&gt;/App_Code/Extensions/&lt;/em&gt; folder &lt;/li&gt;
	&lt;li&gt;Copy the &lt;strong&gt;jQuery &lt;/strong&gt;folder into the root of the web folder&lt;/li&gt;
&lt;/ol&gt;

&lt;h3 id="configuration"&gt;Configuration&lt;/h3&gt;
&lt;p&gt;
The component is completely configurable valuing the following mandatory attributes : 
&lt;/p&gt;
&lt;ul&gt;
	&lt;li&gt;&lt;strong&gt;jQuery File&lt;/strong&gt;: File name of jQuery plugin file. &lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;Description&lt;/strong&gt;: Description of jQuery plugin file.&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;
By default the jQuery Extension loads with jQuery 1.2.6 min file.&amp;nbsp; Any additional plugin files should be copied to the jQuery folder and entered into the Extension configuration page.&amp;nbsp; You can find many more jQuery plugins &lt;a href="http://plugins.jquery.com/"&gt;here&lt;/a&gt;.
&lt;/p&gt;
&lt;h3&gt;Additional Resources &lt;/h3&gt;
&lt;ul&gt;
	&lt;li&gt;The official jQuery site - &lt;a href="http://jquery.com/"&gt;http://jquery.com&lt;/a&gt;&lt;/li&gt;
	&lt;li&gt;Chris Blankenship - &lt;a href="http://www.dscoduc.com/post/2008/09/24/jQuery-Goodness-for-BlogEngineNET.aspx"&gt;jQuery Goodness for BlogEngine.NET&lt;/a&gt;&lt;/li&gt;
	&lt;li&gt;Dityo Nurasto - &lt;a href="http://www.nurasto.com/post/jQuery-in-BlogEngineNet.aspx"&gt;jQuery in BlogEngine.NET&lt;/a&gt;&lt;/li&gt;
	&lt;li&gt;Kyle Johnson - &lt;a href="http://www.designsbyjohnson.com/post/JQuery-with-Blogenginenet.aspx"&gt;jQuery with BlogEngine.NET&lt;/a&gt;&amp;nbsp;
	&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;
If you have any trouble loading additional jQuery plugins be sure to check the above resources.&amp;nbsp; In some instances there may be a confilct with the often used &amp;quot;$&amp;quot; as a shorthand method.
&lt;/p&gt;
&lt;h3&gt;Download &lt;/h3&gt;
&lt;p&gt;
&lt;a rel="enclosure" href="http://www.internetblu.com/file.axd?file=jQuery_Extension_v1.0.zip"&gt;jQuery_Extension_v1.0.zip (63.51 kb)&lt;/a&gt;&amp;nbsp;
&lt;/p&gt;
&lt;p&gt;
Please use the &lt;a href="http://www.internetblu.com/contact.aspx"&gt;Contact Form&lt;/a&gt; to submit and bugs or feature requests. 
&lt;/p&gt;
</description>
      <link>http://www.internetblu.com/post/2008/12/jQuery-Extension-for-BlogEngineNET.aspx</link>
      <author>John Callaway</author>
      <comments>http://www.internetblu.com/post/2008/12/jQuery-Extension-for-BlogEngineNET.aspx#comment</comments>
      <guid>http://www.internetblu.com/post.aspx?id=3dedfb45-3fc1-454e-93b0-478e8c8085a4</guid>
      <pubDate>Fri, 26 Dec 2008 11:08:00 -0500</pubDate>
      <category>BlogEngine Extension</category>
      <dc:publisher>John Callaway</dc:publisher>
      <pingback:server>http://www.internetblu.com/pingback.axd</pingback:server>
      <pingback:target>http://www.internetblu.com/post.aspx?id=3dedfb45-3fc1-454e-93b0-478e8c8085a4</pingback:target>
      <slash:comments>13</slash:comments>
      <trackback:ping>http://www.internetblu.com/trackback.axd?id=3dedfb45-3fc1-454e-93b0-478e8c8085a4</trackback:ping>
      <wfw:comment>http://www.internetblu.com/post/2008/12/jQuery-Extension-for-BlogEngineNET.aspx#comment</wfw:comment>
      <wfw:commentRss>http://www.internetblu.com/syndication.axd?post=3dedfb45-3fc1-454e-93b0-478e8c8085a4</wfw:commentRss>
    </item>
    <item>
      <title>Digg Button Extension for BlogEngine.NET</title>
      <description>&lt;h3&gt;
Add a Digg submission button to your post!
&lt;/h3&gt;
&lt;p&gt;
This is my first attempt at an extension for &lt;a href="http://www.dotnetblogengine.net/" target="_blank" title="BlogEngine.NET"&gt;BlogEngine.NET&lt;/a&gt;. I used &lt;span&gt;&lt;/span&gt;Cristiano Fino&amp;#39;s code for &lt;a href="http://www.cristianofino.net/post/Adsense-Injector-extension-per-BlogEngineNET.aspx"&gt;Adsense Injector extension&lt;/a&gt; as a starting point for the Digg Extension.&lt;br /&gt;
&lt;/p&gt;
&lt;h3 id="installation"&gt;Installation&lt;/h3&gt;
&lt;p&gt;
Download the compressed file Digg_Extension_v1.0.zip (1.27 kb)
, then: 
&lt;/p&gt;
&lt;ol&gt;
	&lt;li&gt;Extract the single file &lt;strong&gt;Digg.cs&lt;/strong&gt;. &lt;/li&gt;
	&lt;li&gt;Copy &lt;strong&gt;Digg.cs&lt;/strong&gt; into &lt;em&gt;/App_Code/Extensions/&lt;/em&gt; folder &lt;/li&gt;
&lt;/ol&gt;

&lt;h3 id="configuration"&gt;Configuration&lt;/h3&gt;
&lt;p&gt;
The component is completely configurable valuing the following mandatory attributes : 
&lt;/p&gt;
&lt;ul&gt;
	&lt;li&gt;&lt;strong&gt;Style (code)&lt;/strong&gt;: CSS code for its proper positioning. &lt;/li&gt;
	&lt;li&gt;&lt;strong&gt;Insert&lt;/strong&gt;: &lt;strong&gt;B&lt;/strong&gt; = display in &lt;em&gt;posts&lt;/em&gt; and &lt;em&gt;pages&lt;/em&gt;, &lt;strong&gt;P&lt;/strong&gt; = display in &lt;em&gt;posts&lt;/em&gt;, &lt;strong&gt;A&lt;/strong&gt; = display in &lt;em&gt;pages&lt;/em&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;h3 id="configuration"&gt;Usage&lt;/h3&gt;
&lt;p&gt;
Use [ digg ] the same as you would [ more ].&amp;nbsp; Insert the &lt;em&gt;digg&lt;/em&gt; text where you want your submission button.&amp;nbsp; You can modify the style attributes in the Control Panel to align left and right.
&lt;/p&gt;
&lt;h3&gt;Download &lt;/h3&gt;
&lt;p&gt;
&lt;a rel="enclosure" href="http://www.internetblu.com/file.axd?file=Digg_Extension_v1.0.zip"&gt;Digg_Extension_v1.0.zip (1.27 kb)&lt;/a&gt;&amp;nbsp;
&lt;/p&gt;
&lt;p&gt;
Please use the &lt;a href="http://www.internetblu.com/contact.aspx"&gt;Contact Form&lt;/a&gt; to submit and bugs or feature requests. 
&lt;/p&gt;
</description>
      <link>http://www.internetblu.com/post/2008/12/Digg-Button-Extension-for-BlogEngineNET.aspx</link>
      <author>John Callaway</author>
      <comments>http://www.internetblu.com/post/2008/12/Digg-Button-Extension-for-BlogEngineNET.aspx#comment</comments>
      <guid>http://www.internetblu.com/post.aspx?id=d54c238e-a2ad-4b9a-8972-dfdd0a91b0d5</guid>
      <pubDate>Fri, 19 Dec 2008 09:28:00 -0500</pubDate>
      <category>BlogEngine Extension</category>
      <dc:publisher>John Callaway</dc:publisher>
      <pingback:server>http://www.internetblu.com/pingback.axd</pingback:server>
      <pingback:target>http://www.internetblu.com/post.aspx?id=d54c238e-a2ad-4b9a-8972-dfdd0a91b0d5</pingback:target>
      <slash:comments>3</slash:comments>
      <trackback:ping>http://www.internetblu.com/trackback.axd?id=d54c238e-a2ad-4b9a-8972-dfdd0a91b0d5</trackback:ping>
      <wfw:comment>http://www.internetblu.com/post/2008/12/Digg-Button-Extension-for-BlogEngineNET.aspx#comment</wfw:comment>
      <wfw:commentRss>http://www.internetblu.com/syndication.axd?post=d54c238e-a2ad-4b9a-8972-dfdd0a91b0d5</wfw:commentRss>
    </item>
    <item>
      <title>Alive and kicking, barely</title>
      <description>&lt;p&gt;
Things have been incedibly busy for me for the last several months.&amp;nbsp; No worries, there will be updates coming soon.
&lt;/p&gt;
&lt;p&gt;
There&amp;#39;s been a lot happening to improve Internet experiences across the Web.&amp;nbsp; One such advancement comes fom jQuery.&amp;nbsp; I&amp;#39;ll be reviewing jQuery next week, so stay tuned! 
&lt;/p&gt;
</description>
      <link>http://www.internetblu.com/post/2008/11/Alive-and-kicking2c-barely.aspx</link>
      <author>John Callaway</author>
      <comments>http://www.internetblu.com/post/2008/11/Alive-and-kicking2c-barely.aspx#comment</comments>
      <guid>http://www.internetblu.com/post.aspx?id=aab9a38b-b1ff-4f2f-8d56-c894d66a715f</guid>
      <pubDate>Thu, 20 Nov 2008 15:15:00 -0500</pubDate>
      <category>Internet Blu Site News</category>
      <dc:publisher>John Callaway</dc:publisher>
      <pingback:server>http://www.internetblu.com/pingback.axd</pingback:server>
      <pingback:target>http://www.internetblu.com/post.aspx?id=aab9a38b-b1ff-4f2f-8d56-c894d66a715f</pingback:target>
      <slash:comments>0</slash:comments>
      <trackback:ping>http://www.internetblu.com/trackback.axd?id=aab9a38b-b1ff-4f2f-8d56-c894d66a715f</trackback:ping>
      <wfw:comment>http://www.internetblu.com/post/2008/11/Alive-and-kicking2c-barely.aspx#comment</wfw:comment>
      <wfw:commentRss>http://www.internetblu.com/syndication.axd?post=aab9a38b-b1ff-4f2f-8d56-c894d66a715f</wfw:commentRss>
    </item>
    <item>
      <title>Why SEO is Like Underwear</title>
      <description>&lt;p&gt;
&lt;em&gt;The following is a guest post from good friend and SEO expert, Amberly Stitzel.  She was kind enough to share some interesting thoughts on Search Engine Optimization.&lt;/em&gt;
&lt;/p&gt;
&lt;p&gt;
When performing optimization on your website for search engine rankings it is important to keep in mind the blend between optimizing for the &amp;quot;bots&amp;quot; and for users. If you gravitate more towards one than the other then your efforts may only win over one of the aforementioned and could have a lesser affect than both combined.
&lt;/p&gt;

&lt;p&gt;
This is where the underwear part comes in.  Have you ever seen someone wearing pants so tight you can see their underwear lines? Or better yet, have you ever not seen someone&amp;rsquo;s underwear lines and wondered if they were even wearing any? Okay, so maybe if you are a pervert you have wondered these two things but I&amp;rsquo;ll explain my point.  Search engine optimization to improve organic rankings is a delicate balance between the visible and invisible. If you can see too much optimization on the page, for example, too many keywords that look spammy, then you may be penalized by the engines. If you can&amp;rsquo;t see any optimization at all and have curtailed your website toward the user experience, for example, designing all pages in Flash, then while you may not be penalized per say by the search engines,your rankings will certainly reflect these choices.  
&lt;/p&gt;
&lt;p&gt;
This is where the blended approach comes in. You want to make sure your website has your targeted keywords in the meta and content but you want to make sure the content makes sense for users. Simply repeating a keyword a hundred times on a page is just like walking around with your underwear lines exposed. It just looks questionable.  That being said, having a website that has no optimization is like walking around with no underwear lines showing. It just looks tacky.  Keeping these things in mind when you are developing your website will increase your chances of ranking organically in the search engines.
&lt;/p&gt;
&lt;p&gt;
###
&lt;/p&gt;
&lt;p&gt;
&lt;strong&gt;
Amberly Stitzel&lt;/strong&gt; is the Marketing Coordinator for LeapFrog Interactive. She has been in the search engine marketing industry for over three years and is certified in Google AdWords, MSN AdCenter and the Yahoo Ambassador Program.&lt;br /&gt;
&lt;a href="mailto:astitzel@leapfroginteractive.com"&gt;astitzel@leapfroginteractive.com&lt;/a&gt;
&lt;/p&gt;
</description>
      <link>http://www.internetblu.com/post/2008/07/Why-SEO-is-Like-Underwear.aspx</link>
      <author>John Callaway</author>
      <comments>http://www.internetblu.com/post/2008/07/Why-SEO-is-Like-Underwear.aspx#comment</comments>
      <guid>http://www.internetblu.com/post.aspx?id=f36f49eb-5d9a-403d-a330-8d8b328e0bb0</guid>
      <pubDate>Wed, 02 Jul 2008 08:13:00 -0500</pubDate>
      <category>Search Engine Optimization</category>
      <dc:publisher>John Callaway</dc:publisher>
      <pingback:server>http://www.internetblu.com/pingback.axd</pingback:server>
      <pingback:target>http://www.internetblu.com/post.aspx?id=f36f49eb-5d9a-403d-a330-8d8b328e0bb0</pingback:target>
      <slash:comments>0</slash:comments>
      <trackback:ping>http://www.internetblu.com/trackback.axd?id=f36f49eb-5d9a-403d-a330-8d8b328e0bb0</trackback:ping>
      <wfw:comment>http://www.internetblu.com/post/2008/07/Why-SEO-is-Like-Underwear.aspx#comment</wfw:comment>
      <wfw:commentRss>http://www.internetblu.com/syndication.axd?post=f36f49eb-5d9a-403d-a330-8d8b328e0bb0</wfw:commentRss>
    </item>
    <item>
      <title>Louisville Geek Dinner</title>
      <description>&lt;p&gt;
The next &lt;a href="http://www.louisvillegeekdinner.com"&gt;Louisville Geek Dinner&lt;/a&gt; is this evening, Monday June 30th. &amp;nbsp;Unfortunately I won&amp;#39;t be able to attend, as there is just too much work left for me to do today.
&lt;/p&gt;
&lt;p&gt;
I got a chance to meet Ben Thomas (founder of Louisville Geek Dinner) at the &lt;a href="http://www.smclouisville.org"&gt;Louisville Social Media Club&lt;/a&gt; meeting earlier this month. &amp;nbsp;He was very amicable and enthusiastic while talking about all of the projects he&amp;#39;s currently involved in. &amp;nbsp;It sounds like tonight&amp;#39;s Louisville Geek Dinner meeting should be well attended.
&lt;/p&gt;
&lt;p&gt;
Here&amp;#39;s a description straight from their site:
&lt;/p&gt;
&lt;blockquote&gt;
		The purpose of Louisville Geek Dinner is to organize a social networking event for geeks. The original concept came from listening to London Geek Dinner podcasts. The first four Louisville Geek Dinners were quite successful, however there is still potential for significant growth. Let&amp;#39;s build an environment like Silicon Valley!
&lt;/blockquote&gt;
&lt;p&gt;
For more information about Louisville Geek Dinner please follow the link below:
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.louisvillegeekdinner.com"&gt;http://www.louisvillegeekdinner.com&lt;/a&gt;
&lt;/p&gt;
</description>
      <link>http://www.internetblu.com/post/2008/06/Louisville-Geek-Dinner.aspx</link>
      <author>John Callaway</author>
      <comments>http://www.internetblu.com/post/2008/06/Louisville-Geek-Dinner.aspx#comment</comments>
      <guid>http://www.internetblu.com/post.aspx?id=6ca31ada-da1e-411e-8000-a4270c9c4e30</guid>
      <pubDate>Mon, 30 Jun 2008 08:43:00 -0500</pubDate>
      <category>Social Media</category>
      <dc:publisher>John Callaway</dc:publisher>
      <pingback:server>http://www.internetblu.com/pingback.axd</pingback:server>
      <pingback:target>http://www.internetblu.com/post.aspx?id=6ca31ada-da1e-411e-8000-a4270c9c4e30</pingback:target>
      <slash:comments>0</slash:comments>
      <trackback:ping>http://www.internetblu.com/trackback.axd?id=6ca31ada-da1e-411e-8000-a4270c9c4e30</trackback:ping>
      <wfw:comment>http://www.internetblu.com/post/2008/06/Louisville-Geek-Dinner.aspx#comment</wfw:comment>
      <wfw:commentRss>http://www.internetblu.com/syndication.axd?post=6ca31ada-da1e-411e-8000-a4270c9c4e30</wfw:commentRss>
    </item>
    <item>
      <title>Join the Weekly Buzz!</title>
      <description>&lt;p&gt;
&lt;a href="http://www.buzzmyblog.com" title="Buzz My Blog"&gt;&lt;img style="width: 373px; height: 80px" class="no-border" src="/blog/image.axd?picture=buzzlogo.gif" border="0" alt="Buzz My Blog" width="373" height="80" align="center" /&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
Join the Weekly Buzz at &lt;a href="http://www.buzzmyblog.com"&gt;http://www.buzzmyblog.com&lt;/a&gt;! 
&lt;/p&gt;
&lt;p&gt;
Jeff at Buzz My Blog is highlighting a new blog every week with the Weekly Buzz. &amp;nbsp;Blogs are featured in a post at the start of the week and linked to for the next four weeks. &amp;nbsp;What a great way to have your blog highlighted and generate more traffic.
&lt;/p&gt;
&lt;p&gt;
This is a free service that they are offering by bloggers, for bloggers, to bloggers.&amp;nbsp; I think this is a great service, so I thought I would pass this along. 
&lt;/p&gt;
&lt;p&gt;
You can enter for your chance to win a free spotlight on your blog by following the link below:&amp;nbsp; 
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.buzzmyblog.com/post/2008/02/weeklybuzz.aspx?refid=223"&gt;http://www.buzzmyblog.com/post/2008/02/weeklybuzz.aspx?refid=223&lt;/a&gt; 
&lt;/p&gt;
</description>
      <link>http://www.internetblu.com/post/2008/06/Join-the-Weekly-Buzz.aspx</link>
      <author>John Callaway</author>
      <comments>http://www.internetblu.com/post/2008/06/Join-the-Weekly-Buzz.aspx#comment</comments>
      <guid>http://www.internetblu.com/post.aspx?id=349104be-dc35-499d-a898-8aa3e6afa574</guid>
      <pubDate>Sun, 29 Jun 2008 10:10:00 -0500</pubDate>
      <category>Internet Marketing</category>
      <dc:publisher>John Callaway</dc:publisher>
      <pingback:server>http://www.internetblu.com/pingback.axd</pingback:server>
      <pingback:target>http://www.internetblu.com/post.aspx?id=349104be-dc35-499d-a898-8aa3e6afa574</pingback:target>
      <slash:comments>4</slash:comments>
      <trackback:ping>http://www.internetblu.com/trackback.axd?id=349104be-dc35-499d-a898-8aa3e6afa574</trackback:ping>
      <wfw:comment>http://www.internetblu.com/post/2008/06/Join-the-Weekly-Buzz.aspx#comment</wfw:comment>
      <wfw:commentRss>http://www.internetblu.com/syndication.axd?post=349104be-dc35-499d-a898-8aa3e6afa574</wfw:commentRss>
    </item>
    <item>
      <title>Google, Friend to the Blogger</title>
      <description>&lt;h2&gt;Why Google is on top, and how you can benefit from their success.&lt;/h2&gt;
&lt;p&gt;
One of the many secrets to the success of internet giant Google is that they provide useful tools to the internet user.&amp;nbsp; They didn&amp;#39;t rest on the early success of the search engine.&amp;nbsp; They continued to produce extremely useful tools and products for webmasters, site owners, and bloggers. 
&lt;/p&gt;
&lt;h3&gt;Google Trends&lt;/h3&gt;
&lt;p&gt;
&lt;img src="http://www.internetblu.com/image.axd?picture=googletrends.jpg" alt="" width="500" height="322" /&gt; 
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.google.com/trends"&gt;Google Trends&lt;/a&gt; is a great tool that helps determine the amount of search volume a particular term or phrase. This can help you determine the popularity of a particular term. Information regarding search terms can be a big help when determining which phrases to target in a particular campaign. 
&lt;/p&gt;

&lt;h3&gt;Google Webmaster Tools&lt;/h3&gt;
&lt;p&gt;
&lt;img src="http://www.internetblu.com/image.axd?picture=googlewebmastertools.jpg" alt="" width="500" height="316" /&gt; 
&lt;/p&gt;
&lt;p&gt;
Another useful set of tools from Google is the &lt;a href="http://www.google.com/webmasters/"&gt;Google Webmaster Central&lt;/a&gt; site. Here you can check to see that your site is included in the Google index. 
&lt;/p&gt;
&lt;h3&gt;Google Analytics&lt;/h3&gt;
&lt;p&gt;
&lt;img src="http://www.internetblu.com/image.axd?picture=googleanalytics.jpg" alt="" width="500" height="322" /&gt; 
&lt;/p&gt;
&lt;p&gt;
If you don&amp;#39;t want to fork over major amounts of cash on an internet reporting package, I suggest looking into the &lt;a href="http://www.google.com/analytics/"&gt;Google Analytics&lt;/a&gt; tools. The analytics site offers a number of great reporting options that help you analyze traffic. There are also a few options to track conversion rates and dollar values by integrating your Google Adwords information, another great tool from Google. 
&lt;/p&gt;
&lt;h3&gt;Google Alerts&lt;/h3&gt;
&lt;p&gt;
&lt;img src="http://www.internetblu.com/image.axd?picture=googlealerts.jpg" alt="" width="500" height="306" /&gt; 
&lt;/p&gt;
&lt;p&gt;
Once you&amp;#39;ve got your site up and indexed you will want to stay on top of what those on the World Wide Web have to say about you and your site. &lt;a href="http://www.google.com/alerts/"&gt;Google Alerts&lt;/a&gt; provides you a great way to keep tabs on a phrase by receiving an email whenever your selected term is used on the Internet. 
&lt;/p&gt;
&lt;p&gt;
### 
&lt;/p&gt;
&lt;p&gt;
What are your favorite Google tools, and how have they helped you succeed online? 
&lt;/p&gt;
</description>
      <link>http://www.internetblu.com/post/2008/06/Google-Friend-to-the-Blogger.aspx</link>
      <author>John Callaway</author>
      <comments>http://www.internetblu.com/post/2008/06/Google-Friend-to-the-Blogger.aspx#comment</comments>
      <guid>http://www.internetblu.com/post.aspx?id=9aa3ca6d-42be-44f3-b412-5c68196f67ac</guid>
      <pubDate>Mon, 23 Jun 2008 20:23:00 -0500</pubDate>
      <category>Tips and Tricks</category>
      <dc:publisher>John Callaway</dc:publisher>
      <pingback:server>http://www.internetblu.com/pingback.axd</pingback:server>
      <pingback:target>http://www.internetblu.com/post.aspx?id=9aa3ca6d-42be-44f3-b412-5c68196f67ac</pingback:target>
      <slash:comments>1</slash:comments>
      <trackback:ping>http://www.internetblu.com/trackback.axd?id=9aa3ca6d-42be-44f3-b412-5c68196f67ac</trackback:ping>
      <wfw:comment>http://www.internetblu.com/post/2008/06/Google-Friend-to-the-Blogger.aspx#comment</wfw:comment>
      <wfw:commentRss>http://www.internetblu.com/syndication.axd?post=9aa3ca6d-42be-44f3-b412-5c68196f67ac</wfw:commentRss>
    </item>
  </channel>
</rss>
