Category: Technology

  • SQL Server 2008 R2 unattended installation via configuration file

    I wrote about unattened install of SQL Server 2008 R2 here, where all parameters were entered on the command line directly. Another way, perhaps a better way, of automation is to put all parameters in a configuration file. Here is a sample: [sourcecode language=”text”] [SQLSERVER2008] ; Specifies a Setup work flow, like INSTALL, UNINSTALL, or…

  • 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…