February 2005 Blog Posts

  • It's getting louder.

    The marketing has cranked up a gear, which would seem to indicate they are getting a good response from the betas. Looking here (features) and here (pricing), we see 4 commercial breeds of SQL Server 2005. I have to say that the Express addition is my show stealer here.  1GB RAM, 4GB database size, GUI interface, no query governor.  That much grunt for “free” is outstanding.  A well built app and a good db design, I honestly think this little animal could handle a large portion of the average small business data demands for both web...

  • Too good at SQL for a job..

    The job market in Australia is pretty good at the moment for any decent programmer/DBA.  After the blood letting of post 2000, many charlatans where uncovered and removed.  The days of the “Database Fix“ began.. Contract after contract was the same.. “Fix this piece of s#it!“... “Fix it!  Sorry, I don't do resurrections.“ So a mate of mine is looking for a new job.  We worked together a while back.. He shared his knowledge of good programming and I shared the database stuff.   To cut to the chase...I'd hire/recommend him at the drop of a hat for any IT job. Anyway he goes...

  • Towards a Point Array constraint

    In my last blog, I asked the question for breaking 1NF for a particular situation involving Points. Graz hit the nail on the head with the question about the relevance of the internal data components to the outside world.  Type vs Entity is always a case by case evaluation ... So here is this one The “base“ object stores 2 Points.  All of the initial sub classes of this base object follows this representation.  Initially I decomposed a Point to columns X and Y, giving columns X,Y,Xi,Yi for the objects spatial position.  So from the get go I am contaminated by implementation issues screwing...

  • Should I break 1NF?

    I am storing graphical objects in SQL Server. A Line, Rectangle, Ellipse, Image and Text object can all be represented spatially on the drawing surface by 2 elements StartPoint and EndPoint    (Point= X INT > 0,Y INT > 0). Without type support , it decomposes to the columns X,Y,Xi,Yi. I had a lot of fun with the the front end  (C# windows forms) class structures (nice little factory pattern) and decided to add a free hand drawing object.  The front end coding was fairly trivial.  Every 20ms, get the mouse coordinate (Point: X,Y). After this object is “finished”, I am left with an array...