So far in my career, I've made other people money with my work. I want to change that, and I think software is fertile ground for an entrepreneur. We can create machines that do stuff all by themselves, generating value and thus money while we sleep. I will learn and simultaneously teach others how to build a sustainable software business. My main focus is how to make money with MySQL, but I will include other technologies. This endeavor will go beyond technical knowledge, incorporating marketing, sales, and customer service to figure out what your customers (or your boss) wants, and how to get them to pay you well for your efforts. I've created some basic resources to help you. Read what I've written on MySQL or take a look at my upcoming book, MySQL Simplified.
Within MySQL, there’s a piece called a storage engine that reads and writes to disk on your behalf when you execute a query. It controls the way that your data is stored on disk. With MySQL, you can change what storage engine you use, which is helpful since every engine has different advantages and downsides, and you can select which engine to use based on your workload. There are two main engines: MyISAM and InnoDB. MyISAM was the default engine before MySQL 5.5 and it’s been there since the beginning. It’s also not crash-proof, it doesn’t have foreign keys, and it’s not transactional. InnoDB, on the other hand, has all these features. Read more
Character sets are like the force: they surround us and penetrate us, binding all our digital world together. A character set is how we convert the 1’s and 0’s that the computer understands into human-readable characters like ABC. In one of the first character sets, ASCII, the number 97 is translated to “a” and 63 is the question mark (?). Read more
One day, after taking a job using MySQL, I was writing a query quietly at my desk. It was around quittin’ time, and I was whipping up a new report on the monthly sales figures that the CEO needed for his board meeting in the morning. I, in my ignorance, wrote a nice query with a simple little sum() function. What I did not realize is this caused all my rows to sum up to one row when it really should’ve show several rows. Read more
I am a budding software entrepreur located in beautiful Boise, Idaho. I like creating software, because our work frees people from meaningless, repetitious tasks, often giving them a lever to move the world. I've worked on everything from a small ERP system, to trucking software, and now I'm on a team with a great group of people writing software for the marketing space. My favorite technologies include MySQL, C#, SQL Server, and Linux (if only Microsoft released a *nix SQL Server).
My non-work hours are filled with family and travelling, hopefully both! (<-- That's my beautiful wife and me in Switzerland). I won't say no to either a Homeric epic or a snifter of cognac.