Category: Technology

  • Sample Baseball Database for Learning, Testing, and Demo

    I came across this from a blog I follow. Dbt even provided a nifty script to figure out the most recent world series win, loss and appearance for every team in the league. I first heard about this database probably a year ago. Anyway, I thought this really is a great database for my baseball-loving […]

  • Pointers on WordPress customization please

    I’ve had my blog for a couple of weeks by now. It was hosted by MidPhase. I used it because it had good reviews and a colleague recommended it. Based on my experience so far, I am not too happy with it. I will leave that for another post. Anyway, I am actually pretty happy […]

  • Fix Page 404 Error in WordPress

    If 1. You use WordPress; 2. You have permalink turned on; 3. You just wrote a page using WordPress but when you view the page, you get 404 page not found error; Then 1. Go to Options->Permalinks; 2. Click Update Permalink Structure. If your .htaccess cannot be updated through the web interface (very likely), copy […]

  • Server consolidation and virtualization with Sql Server 2005

    We had a PASS volunteer SIG (Special Interest Group) teleconference today. One item discussed was server consolidation. Microsoft is interested in this area and is seeking input. During the earlier discussion we had, Bill Wunder and Lynda Rab brought up good points like login transfer, collations, tempdb issues, job management and maintenance, resource allocation, and […]

  • Change SQLCMD default editor

    In SQLCMD, if you type ed, it will invoke a text editor and put the last command you run in the editor buffer. The default editor is Edit, a command line editor of DOS. This behavior is very similar to Oracle Sql Plus, by the way. The difference is that in Sql Plus, you can […]