I can’t say I’ve ever seen the Windows registry explained well. It helps to think of the registry as a database. Microsoft loves databases, and they’ve been trying for decades to stuff as much database technology into Windows as they can. The registry was one of the earliest and most successful of those efforts.
Although it was controversial in the 1990s, the registry solved a very real problem. Windows 3.1 and earlier stored all of its settings in huge plaintext files called ini files. They were a tangled mess, and the more you used your computer, the slower it became. The registry made it a lot faster for the computer to find each setting it needed.
If you regularly visit forums online, particularly forums powered by the forum software Vbulletin, you ought to change your forum passwords right now. The longer and more random you make them, the better.
Whether you’re a sysadmin, an analyst, or use a computer for something else professionally–even if you’re not a database administrator or developer–SQL is a useful skill to know. I’ve gotten by for 20 years without knowing much more SQL other than simple SELECT statements, but those days are rapidly winding down–if I want to be good at my current job, I’m going to have to take some time to learn SQL. If you’re in the same boat, here are some resources for learning SQL.
SQL is the underlying language behind Oracle, Microsoft SQL, MySQL, PostgresSQL, and probably a few other databases I’m forgetting. If you’re doing something beyond Microsoft Access, it’s probably using some kind of SQL. Each implementation has its own quirks but the basics remain the same between all of them.
The GCHQ is the British equivalent of the NSA. They recently published a new document containing the GCHQ’s new password advice in light of the things we’ve learned in the last few years. It’s worthwhile reading, whether you’re a sysadmin or a web developer or just an end user who wants to stay secure online.
So, I’ve been seeing one particular ad incessantly lately. It’s a fairly generic-looking ad, with the words “Jesus Christ is Lord” in bold letters across the top. Scroll down a little further, and there’s a very heavily tanned woman, under a thick layer of makeup wearing a skimpy halter top. She’s probably in her early 20s. It’s an ad for a certain Christian-themed dating web site I won’t mention by name.
It seems to be targeted advertising. Fine, my religion is no great secret. Most public databases that I’ve queried about myself identify me as a Protestant, and some even peg me as Lutheran too. But there’s this one other little detail that’s even easier to find out than what religion I practice.
Flash memory’s days may be numbered. The end of the line for traditional flash memory has been predicted for a long time, and gloated about by Luddites who are dead-set against buying SSDs for whatever reason. But I’m not worried about it. All I want is solid-state storage; I don’t care about the underlying technology. The technology behind the RAM my computer uses has changed several times since the early 1980s, and I’m not broken up about it–the SSD in the last computer I built is faster than the RAM in my Commodore 64 was. Speed is good. More speed is better.
A couple of years ago, I stood up a WordPress server. I made no effort to tune it, let alone turbocharge it, which is a decision I later came to regret. If your site gets more than a few hundred hits per day, you need to tune it. If you want to get more than a few hundred hits per day, you need to tune it because Apache and MySQL’s default settings are by no means one-size-fits-all. And you can never have too much speed. There are two reasons for that: Google favors fast sites over slow sites, and Amazon found that a one-second delay in page load drops traffic by 7 percent.
There’s a lot of advice out there on tuning WordPress, some of which seems to be good, and some of it not so good.
Here are four things that I know work. I run Apache and MySQL under Linux; these tools may run under Windows or OS X too. Read more
I’ve suspected for a long time that street addresses aren’t good to use–the formula is too simple–but now it seems that even mashing together a sentence into a long password doesn’t work. (That isn’t something I do often, but I’ve done it at least once or twice.) Read more
Andy Black is a former colleague and an Oracle DBA. Several times in the last few years, I ran into problems where I wished he wasn’t a former colleague, because my team got into some jams that I was pretty sure he could have fixed. (And let’s not even mention the time I got blackmailed into building an Oracle server.)