Resolving Connection Error with MySQL Migration Toolkit

June 2nd, 2010 Pierre Buckley 5 comments

If you are here because you are getting the dreaded “Network error IOException: Connection Refused: connect in MS SQL Server 2000” error message with the MySQL migration toolkit and need a solution, then you have come to the right place. Read more…

Handling Null Values in SQL Server

May 28th, 2010 Pierre Buckley 5 comments

From time to time, we may want to replace NULL values with some desired value when doing an sql select statement. Turns out that SQL Server makes this a simple task – and no IF statements are necessary! To do this, we use SQL Server's ISNULL function. This function takes two parameters. The first parameter is the name of the field that we expect may have a NULL value that we wish to replace. The second parameter represents the replacement value for the NULL value. Read more…

Categories: SQL Server Tags: , ,

5 Great Web Developer Tools

February 8th, 2010 Pierre Buckley No comments

A web developer’s life is never an easy one. I know and understand this, and so I thought I would share my top five, must have, tools that I use from day to day. They are in no particular order and are great tools. They have saved me countless hours of additional work and have made my work so much more tolerable. Read more…

Alternative to MySQL’s LIMIT Command

December 20th, 2009 Pierre Buckley 11 comments

I recently ran into the situation where I needed to create a query in MySQL that counted up to n rows from a result set. I scoffed at the challenge and proceeded to go for the one tool I thought could do the job – MySQL's LIMIT command. Unfortunately, the result I got was not what I had expected. Read more…

Categories: MySQL Tags: , , , ,

ASP.NET from Scratch Tutorial Series

December 14th, 2009 Pierre Buckley 5 comments

Very good screencast that introduces ASP.Net. Authored by Jeremy McPeak and hosted at Nettuts. So far there are only two lessons available. I will continue to update this post as more becomes available. Read more…

Categories: ASP.Net Tags: , ,

I Am Back!

September 30th, 2009 Pierre Buckley No comments

After being absent for way too long, I decided to dust off this blog and try running with it again. I must say that I am much more experienced than when I first started this blog and I have so much more to share.

I will be sharing this information with everyone in the coming weeks. I thought I would start thing off by writing a tutorial to make your own blog, albeit will only have the bare minimum features. So you can look out for that. Read more…

Categories: Uncategorized Tags:

Windows Live Writer

August 6th, 2008 Pierre Buckley 3 comments

Ok, so I came across Windows Live Writer today. I am publishing this post by using it. I must say that I am impressed by it and now believe, at least, I will be able to update my blog more often. I tire of logging in to Blogger and creating a new post. It's too tedious. Read more…

Starting ASP.NET Programming

March 8th, 2007 Pierre Buckley 11 comments

Okay, I haven't updated this blog in a while. The reason is i am bogged down with tons of school work. At the moment, I have being doing a lot of ASP.Net and thought that I would just write this quick guide to help the noobs out there to get started in programming with ASP.Net. As always, you need to have some prerequisite knowledge and tools to get started. Read on… Read more…

An Introduction

January 10th, 2007 Pierre Buckley No comments

I thought I would kick of this blog with an introduction of myself. My name is Pierre Buckley and I am a programmer. I consider myself as a novice even though I have experiences in more than four computer programming languages…go figure. Anyways, I believe to better myself as a programmer, I would have to venture on a journey of research to uncover the mysteries of programming. I have created this blog to share my findings and knowledge with other programmers like myself. Read more…

Categories: Uncategorized Tags:
  • Twitter
  • Buzz
  • Facebook