-
Following High Performance MySQL’s hash index discussion
Mixing up some MySQL and SQL Server hacking activities can be fun. I’ve also noticed that when you work with different database platforms, it can bring additional clarity to certain concepts and techniques. One reason for that, I think, is that different terminologies and ways of explanations are used for people practicing on different platforms,…
-
Using Linux Mint as my main operating system
Man, a functional, reliable, day-to-day use Linux desktop distro, I’ve been chasing that unicorn for a while. I think I might have caught one yesterday. Time will tell, but so far it looks promising. Here is a list of distros I’ve tried: Ubuntu 9.04 64-bit and 32-bit. I am sure I’ve tried versions prior to…
-
Find and replace text in a file with Python
Continuing my Lego block building, here is the code for myself and whoever will find it useful. Two blocks of code, the first one searches and replaces, then write the results to a new file, leaving the original intact. The second replaces things in place. Highlights: 1. os.path.join is cool, but you’ve got to be…
-
Building up Python Lego pieces – some directory stuff
I lost all my Python code that I have written and collected over time, don’t ask why. So I am in the process of building that back up. Here is some code to create directories for a SQL Server gig I am working on. Highlights: 1. Use os.path.join to take care of the forward and…
-
Unattended install of SQL Server 2008 R2
I’ve written unattended / silent install before for SQL Server 2005. Unattended install is cool because you can automate things: it saves time and improves consistency. Here is something to get you started. I used the command below to: 1. Install SQL Server 2008 R2 default instance, including Replication and FullText search; 2. Install client…