SQL2k Allowing Nulls, Temp Tables (tempdb) and no results

This describes an odd issue where code that previously worked on an older system, no longer worked correctly. We used good old ad-hoc sql to get some search results and suddenly we have 0 rows where the EXACT same code running under QA DOES return rows.
Continue reading

Posted in SQL | Leave a comment

PHP5 SegFault mssql.datetimeconvert and Free TDS …Insanity and a wasted day

Contained herein is a gruesome tail of PHP5, Apache2, FreeTDS, invalid DateTime values and of SegFaults. Please don’t read if you have a heart condition or if you are pregnant or plan on becoming pregnant. If you have an erection that last longer than 3 weeks, high five yourself.
Continue reading

Posted in PHP | Leave a comment

MSSQL 2000 Tying DB Users to System Logins

At critical times when working with database backups, sometimes the server pixies have their way and screw up the tie between DB User and System Login. Here’s a little blurb on how to get them to tied back in. Realize in SQL2005 this is done through a system procedure.
Continue reading

Posted in SQL | Leave a comment

Recursive XML Object Serialization and Persistence with PHP5

This post discusses how to give your derived PHP5 objects the ability to serialize themselves to XML recursively. It also discusses common problems and issues faced with recursion and object member visibility.
Continue reading

Posted in PHP | Leave a comment

Emotionally Driven User Interface Design

Far too many applications are being developed by logical, structured, and rigid methodologies. We live and breathe by the heartbeat of Business Process Diagrams, Control Flow Diagrams and Database Schemas. While this will produce a very predictable result, it inherently stifles creativity. It all makes a lot of sense really. If you’ve a developer then you know how documenting the knowns of a project keep you sane and cover your ass. It’s like somehow we keep striving to make a more intelligent automation mechanism for us to do less, be more productive and wow the big wigs. This just reeks of stereotypical corporate bullshit. Break out your shell, risk a little and grow as a person.

I’m constantly challenging myself to bring a creative dimension into my development. I long for the day I can sit back at my desk, chill out with some nice ambient beats and imagine what development should be like. A development pipeline that’s efficient and logical and a final product that is aesthetically pleasing and is architected to leave the end user with a positive emotion. It could be satisfaction in the final product, confidence in their ability to utilize the software and be productive or excitement at finally having the software that perfectly fits their need.

I can’t tell you how horribly sick and tired I am of all the user control garbage the industry has pushed down our throats. I’m going to suffocate from stagnation.

Yay let’s see how many different ways we can show a list control. Hey let’s start embedding controls into OTHER controls, wow that counts as a brand new control right? That means we have 5,234,090,234 different controls! That’s good right?

I keep thinking of how we can merge efficient user interfaces with emotionally fulfilling ones. There are obvious interfaces which totally suck ass. The one I currently hate the most has to be Microsoft SQL 2000 Enterprise Manager.

This has to of been created by Drooling Monkey Retards. Let’s give you a list of all your databases, but gosh you only really need to see the first 7 letters of a database name right?? I’m getting pissed just thinking of it right now.

I keep pushing myself to think outside of my comfort level. Why can’t we have visually pleasing 3d controls that group or collapse information in a logical, predicable fashion and use colors to denote something that’s emotionally connected? We can see so much more information at once and be able to know at a blink which garbage to filter out visually. Or balance that against something that’s got much less going on visually, but is intuitive enough to show you exactly what you need to see and nothing more.

The Revolution – Less is more

I’ve noticed in the past few years that there have been many applications that wildly popular because they are so friggen easy to use. Google has an input box and a button for F’s sake. My corporation just switched to Google calendar because a) Its horribly simple to use and b) it actually WORKS as you would expect it to. The interesting aspect to these interfaces is they are very flat and minimalistic in nature. Things are colored differently when separation is needed, but one will notice fewer borders, little gradients etc. Yet at the same time I FEEL good when I’m using the applications. It does what I want it to and I don’t get drowned by feature bloat.

This revolution signifies to me that we are entering into an age when we really have a significant number of contributors that are willing to advance the face of software and user interface development. For far too long the titans of the industry have pandered their dumbed down bloated wares onto us and we’re finally answering the challenge with solutions that are simpler and provide a much more satisfying experience. I’m emotionally connected to these solutions because of their simplicity. Google has taken the time to know me and to know what I really want even when I really say I want it all.

I really think far too many people don’t even think about emotional impact of their user interfaces. How can a color or sound or the curve of a report change how an end user feels about your product? How can you use the Less is more approach to wow a user by simply knowing them and making them feel like you really took the time to understand them? In the end its all about connections.

Posted in My Rant | Leave a comment

Reading the Joystick Port

The joystick is not only a pain in the butt to use, but it is also as old as input devices can get!! Unfortunately, because of it simplicity and that fact that any moron can move a stick, joysticks are STILL around! What would I like to see instead? I think I would like the Joystick if it had a better design. Speaking of which, let’s get into covering what makes it tick! Continue reading

Posted in C++ | Leave a comment

C++ Structures

Structures form a very large building block with which to collect like data into one collective unit. They are a versatile data structure in which to clump data together in convenient little packages! They are essentially classes with all members defined as public access with no private or protected access modes available. Continue reading

Posted in C++ | Leave a comment

C++ Linked Lists

Although linked lists sounds kind of scary, don’t worry they are really easy to use once you’ve got a little practice under your belt! When I first learned this odd way of storing data, I really thought that I wouldn’t be using them again. I certainly learned differently! Continue reading

Posted in C++ | Leave a comment

Programming the Timer Interrupt

The timer interrupt is used when a certain event MUST happen at a given frequency. In the Programming the Sound Blaster 16 Example #4 we used it to play back a sample in Direct Mode so that the sample frequency matched the timer interrupt’s frequency. Continue reading

Posted in C++ | Leave a comment

Reprogramming the Keyboard Interrupt

First off, trying to quickly poll the keyboard in standard C++ is a joke. There is not way to get multiple keystrokes *easily* and quickly. When you finally support multiple keystrokes, you are limited to probably only 2, three tops. The point isn’t that you need more than 3 at a time, but it says something about the speed the program is polling the keyboard. It just isn’t fast enough. Continue reading

Posted in C++ | Leave a comment