<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>Dave's Blog</title>
	<link>http://blog.thewebsiteguy.com.au</link>
	<description>Dave Muller - The Website Guy - Personal and Technical blog</description>
	<lastBuildDate>Sun, 29 Aug 2010 01:27:51 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.0.1" -->

	<item>
		<title>MySQL Performance benefits of limit</title>
		<description><![CDATA[Besides the small security increase by using limit (destructive queries can only affect x rows), there are some performance benefits as well. Consider the following queries: select field1, field2 from Product where ProductID = 1; update User set Firstname = 'jim' where UserID = 3; MySQL will update the row that matches the ID, but [...]]]></description>
		<link>http://blog.thewebsiteguy.com.au/?p=346</link>
			</item>
	<item>
		<title>Google must hate Stephen Conroy</title>
		<description><![CDATA[I took these screen shots of suggestions in Google while typing, &#8220;Stephen Conroy&#8221;.  Enjoy!]]></description>
		<link>http://blog.thewebsiteguy.com.au/?p=337</link>
			</item>
	<item>
		<title>Guitar practice no more</title>
		<description><![CDATA[I had a gap in guitar practice because I was starting to get RSI back.  It&#8217;s been a fair few weeks now and no change.  I can still play, but not the scales and exercises to a metronome.  I have improved enough that all the solos I have written are now quite playable but it [...]]]></description>
		<link>http://blog.thewebsiteguy.com.au/?p=334</link>
			</item>
	<item>
		<title>Guitar Practice &#8211; Week 5</title>
		<description><![CDATA[I was sick this week so I didn&#8217;t practice much. Ross from MCD Guitars has finished the refurb on my JEM and it was a pleasure to play it again. The neck was taken off, sanded down and polished, new pots put in and a new trem installed. I can play a few BPM faster [...]]]></description>
		<link>http://blog.thewebsiteguy.com.au/?p=326</link>
			</item>
	<item>
		<title>Guitar Practice &#8211; Week 4</title>
		<description><![CDATA[Again I have been slack. Belinda is back in hospital so I have been busy with that, and I have also had a creative spurt so I have written a bit of music instead. 100bpm is still proving to be a barrier, but I think I will be up to 105 next week. 115 is [...]]]></description>
		<link>http://blog.thewebsiteguy.com.au/?p=322</link>
			</item>
	<item>
		<title>Guitar Practice &#8211; Week 3</title>
		<description><![CDATA[I practiced more this week and have improved mostly in consistency. 100bpm is proving to be a tough barrier. I could play the chromatic exercises at 110bpm reasonably well, but still would think of 100 as the clean speed. I changed the sweep picking exercises to arpegios. Here’s my improvement over this last week, first [...]]]></description>
		<link>http://blog.thewebsiteguy.com.au/?p=320</link>
			</item>
	<item>
		<title>Guitar Practice &#8211; Week 2</title>
		<description><![CDATA[I only practised three times this week. Mostly to do with slackness, and a little because I learnt &#8220;sleep walk&#8221;. I&#8217;ve been asked to demo an MCD guitar at the guitar expo this year, so I will be learning some classic songs to play. I went backwards this week, but at least I can play [...]]]></description>
		<link>http://blog.thewebsiteguy.com.au/?p=318</link>
			</item>
	<item>
		<title>Creating MySQL stored procedures from PHP</title>
		<description><![CDATA[I&#8217;ve been writing an n-tier PHP web application, and I&#8217;ve been working on the installer. As part of it, I needed to create stored procedures from PHP.  I hit a snag, which was the following: $sql = "delimiter $$ drop procedure if exists spsTableDelete $$ create procedure spsTableDelete(mySession nvarchar(255),myTableID bigint unsigned) begin update sTable set [...]]]></description>
		<link>http://blog.thewebsiteguy.com.au/?p=306</link>
			</item>
	<item>
		<title>Guitar practice week 1</title>
		<description><![CDATA[It&#8217;s been about two years since I practiced my scales and exercises on guitar to a metronome. I&#8217;ve been writing a fair bit of progressive and neo-baroque rock recently and I wrote a solo at 260bpm quavers, which I can&#8217;t play cleanly, so I need to get up to speed. Last time I checked (two [...]]]></description>
		<link>http://blog.thewebsiteguy.com.au/?p=302</link>
			</item>
	<item>
		<title>Password Generator</title>
		<description><![CDATA[I wrote a password generator today to help me whenever  I need to create passwords for myself or a user.  It&#8217;s pretty easy to use &#8211; just enter the password length and character set to use. Enjoy! http://tools.thewebsiteguy.com.au/password.php]]></description>
		<link>http://blog.thewebsiteguy.com.au/?p=298</link>
			</item>
</channel>
</rss>
