-
MySQL replication notes 1: replicating all databases
A couple of weeks ago, a friend asked about replication on MySQL 4.1.7. I’ve worked with replication in the past, just a quick and dirty job on MySQL 5, and soon forgot about it. This time, I wanted to do it on MySQL 4, and make sure I take good notes for my own benefit.…
-
Drop all indexes in Sql Server 2005
Here is a script I wrote to generate a script to drop all indexes that are not primary keys. This works for Sql Server 2005. The main thing it uses is sp_MSForEachTable, an undocumented stored procedure. Run the generated script, and you will be good to go. This is especially useful before a bulk load…
-
Oracle 10g Express Install Part 2
After my last failed Oracle 10g Express install due to insufficient memory, I purchased some memory from eBay, and started it over. This time, the first thing the installer noticed was that the swap file is not big enough. I fixed that by doing a total re-install of Fedora Core 2. Yeah, I know that…
-
Katmai installation notes
I downloaded and installed Katmai, code name for Sql Server 2008, a few weeks ago. My friend Scott Whigham has a great post on it. Here are some of my own observations: 1. The installation process is very similar to that of Sql Server 2005. Here is one screen shot of feature selections: 2. If…
-
打扑克/Let’s play poker!
Below is something I wrote a couple of months ago for my son, to help him prepare for his Japanese speech. The teacher presented a list of interview questions to me, which I replied in writing. I was organizing my files and came across it. I made slight editing to the original. Why do I…