Cees Alberts on July 24th, 2011

As a .NET developer I mostly fill my days making ASP.NET websites, and Windows forms application for my big clients. A few months ago I decided to take a look at making WordPress and Joomla websites. I wanted a tool that would help me make websites for small businesses quickly. Mostly I didn’t want them to come to me later and ask me to change the color of the third word in the second paragraph to red…. In other words they should be able to manage the content of their websites themselves, in an easy way.

Let’s be honest, you can make wonderful websites in .NET but you need a good CMS behind it and a good framework at the front end to quickly make websites with it. If you don’t have this, making a site is a lot of work, maintaining it even more!

In WordPress on the other hand I can make a good looking, company website in a few hours. This includes registering the URL, putting the website with a hosting company, making the site, doing the styling and putting the first content in it. The downside of a CMS like WordPress is that making it look and do EXACTLY what you want also involves a lot of work, and with WordPress you’re stuck with a “simple” scripting language like PHP. PHP doesn’t come close to the powerful languages you have in .NET!

So I decided to cover both sides of the market; the quick and “limited” side of WordPress and the not so quick but very powerful side of .NET. I will just let it depend on the wallet of the customer!
At the moment I love doing both things so it’s also making my work a lot more interesting!

Tags: , , ,

Cees Alberts on June 3rd, 2011

I watched the movie “The Net” a few days back again and I noticed that all computers that were used were Mac’s(!) Even the woman from the US consulate in Mexico printed the visa form with a Mac! I guess the makers of the movie made a nice deal with Apple to promote Mac’s! 😉

It was funny to see though that even the viruses that were used in the movie were Mac viruses. A bit unbelievable of course because everybody knows that almost no viruses were made for the Mac! Even more unrealistic was that the same Mac virus that was captured in the beginning of the movie crashed a mainframe at the end of it.

All in all the movie was enjoyable and more realistic when it comes to computers, hacking and programming than most, but I guess software developers like me notice only the inconsistencies.

Tags: , , ,

Cees Alberts on May 20th, 2011

I love my Macbook Pro I really do! I do Microsoft .NET software development and for this it’s great. Of course I couldn’t do the work without VMWare because .NET is still mostly / only working on Windows machines but that’s another story.

After using the Macbook Pro for some months I found out that OSX has a problem; every now and then the Hard disk gets corrupted. I think this might have to do with the fact that OSX originally used to be Unix; a server OS. Unix Servers are made to run continuously,no administrator turns of his servers at the end of the day, but I do turn of my Macbook!

Especially when you hibernate your Mac, now and then you will get the dreaded message saying The volume Macintosh HD was found corrupt and needs to be repaired. Now in most situations repairing will go ok and after that it’s business as usual. But once in a while this will not work and you need to restore the time machine backup you of course made, didn’t you? Because my notebook harddisk is 1TB this can take hours and hours! Did I tell you I hate waiting?!

After already resigning to the fact that every now and then it would be necessary to do a restore of my backup I stumbled upon a great little tool. The look and feel took me back a bit to the old MSDOS days (no graphics, everything character based) but who cares if it works. The tool is called AppleJack ( http://applejack.sourceforge.net ) and is OpenSource (which means free!).

After installing it you need to start up the Macbook holding the CMD-S keys. The Mac will start in single user, character based mode. Type ‘applejack’ at the prompt and a small and simple menu will show. Chose option ‘a’ for ‘autopilot’ and the whole repair cycle will start. I found that 99 out of 100 this will repair everything and withing 10 minutes it’s back to business as usual; I just love this tool!

Tags: , ,

Cees Alberts on April 28th, 2011

One of the clients I worked for didn’t allow it’s developers to use embedded SQL in their sourcecode. Only the usage of stored procedures was allowed. Applications only got the database authorization to call stored procedures, nothing else. To me this is the most optimal use of database security!

The DBA department made one stored procedure per table to select everything and one to select records on bases of their primary key. All other stored procedures that were necessary for an application were made by developers, but before they could be used in a production environment the DBA’s reviewed them. This way the DBA’s could keep an eye on how different tables were used and how this was affecting the database / DBMS. If necessary they optimized the stored procedures or just sent it back to the developers to have them optimize it themselves. In general this made for optimized stored procedures with a uniform way of coding in them. I liked this way of working and try to do this also with other clients, if they allow me to do this of course.

In general for me the advantages of stored procedures are:

  1. Security (only expose stored procedures to the big bad world outside, nothing else)
  2. Speed; because the DBMS optimizer makes a one time plan for execution (this has advantages and disadvantages but that’s another discussion altogther)
  3. Reusable code / procedures.
  4. Reviewable code. Reviewable by DBA’s that have the right knowledge for optimizing stored procedures. No .NET or other knowledge is necessary for these reviews!


So according to me we should use stored procedures more often!


Today I needed to find a workitem in TFS (Team Foundation Server) but didn’t know in which Team Project it was. I also didn’t know the workitem ID so I was getting ready for a big search through all the projects. Then I decided that there must be a better way to do this, and that it couldn’t be that I was the only one with this problem.

After searching a bit on google I found this plugin for Visual studio and Team Explorer and it works great! It adds a toolbar to Visual Studio with a small search field in it where you can put any search word. It then will search through all the workitems in all the projects and gives you a list with items it finds. Exactly what I needed so I added it to my great tools for .NET development toolbox!

You can find this plugin on codeplex:

The description on codeplex for this plugin is:
This plugin for Team System puts a little search box right into Visual Studio to make it easy to find work items. It is an addin for Team Foundation Client (Team Explorer) and is accessible from the Team menu when you’re connected to a Team Foundation Server and is also available from a VS Toolbar. You just type in some search text and it runs a work item query for you showing you results across the work item store, or enter a work item ID to immediately open a specific work item.

Tags: ,

Cees Alberts on April 3rd, 2011

To stay in the spirit of code sharing and showing of the plugin I found for putting source code in my blog post I decided to add another code snippet!

This little snippet of C# shows a method that will make all the first letters of the words in a string uppercase.

Okay, okay not exactly brain surgery but a nice snippet anyway! 😉

public static string InitCap(string tekst)
   if (string.IsNullOrEmpty(tekst) || tekst.Trim() == "")
      return tekst;
   string r ="";
   foreach (char c in tekst)
      r += r.Length == 0 || r[r.Length - 1] == ' '
           ? c.ToString().ToUpper()
           : c.ToString().ToLower();
   return r;

That’s it!

Cees Alberts on April 2nd, 2011

So after registering my URL developerblog.nl and installing wordpress I started thinking about what I would write about. I decided that I will write general ramblings about being a freelance .NET developer having a strange infatuation with the Macbook pro, the iPad and the iPhone.

Next to that I also will write more technical blogs about .NET development, where I will insert C# source code. To keep the source code readable and to make use of a (sort of) color coding I decided to search for a plugin that would help me with that.

Luckily I found SyntaxHighlighter which did the trick for me! It isn’t 100% what I want but it comes close to this. You just have to put two tags around your source code, letting WordPress know what is code and what is not and that’s it! You can even let WordPress know which language it is so the right words will be hightlighted.

I put a small C# code snippet below to show what I mean.
Nicely done right?!

private static string MakeFirstUpper(string name)
   if (name == null) return "";
   if (name.Length <= 1) return name.ToUpper();
   Char[] letters = name.ToCharArray();
   letters[0] = Char.ToUpper(letters[0]);
   return new string(letters);

Tags: , , , ,

Cees Alberts on March 4th, 2011

Finally I started blogging! After wanting to do this for months, even registering my URL ( www.developerblog.nl ) I finally found the time to install WordPress.

By the way, WordPress really rocks! It took my all of 5 minutes to install it. Ok, after that it took me 3 hours to configure it but truth must be told, my newborn daughter was distracting me ! 😉

Now let’s see how I can setup this site a bit better!

Tags: , , , ,