Category Archives: Databases

Once again, UPHPU has had a minor stir about which database is faster / better / stronger, PostgreSQL or MySQL. All fanboyism aside, who really cares? You want to know the way to *really* speed up your database? Normalization is … Continue reading →

It’s been a good while that I’ve ranted and raved against MS SQL Server. I’ve actually found a few bugs since then, I just haven’t documented them. My beef this time around is that SQL Server 2000 doesn’t have a … Continue reading →

There are some things in life that, once you get used to them … there’s just no going back. Things like underwear, Malt-O-Meal, Neverwinter Nights, and views. At work we use databases much, much more than I ever have anywhere … Continue reading →

I’ve spent almost all day trying to get these free versions of large databases working. Well, that, and watching a good amount of Justice League. So far, I’ve yet to feel like I’ve made any good progress. Although that one … Continue reading →

I’m sure I’m going to get into trouble by announcing something I *plan* on releasing, because then I might never get around to it … but oh well, I felt like mentioning it. I started working tonight on a SQL … Continue reading →

This one isn’t a rant, just another head-scratching-that’s-an-odd-thing-to-do kind of post. One of the main scripts was running slow tonight that gets hit on a regular basis, and we couldn’t figure out why. So, we do what we do when … Continue reading →

Just for a background .. anyone who has talked to me for more than 30 seconds about databases knows that I hate Microsoft SQL Server with a passion. The real bonus is that it’s not just an unfounded passion! I … Continue reading →