Keyboard Face

when you find QWERTY imprinted on your cheek - it's time to go to bed.

Tags

asp CSS css menus dreamweaver flash gallery2 hosting iis7 Javascript jquery jquery ui left mac mssql os9 php printer rdp SEO sql sql server windows wordpress

Truncating SQL Server 2000 Log Files

by 1 Comment

I run several SQL Server 2000 databases that have lots of updates to them every day. Inevitably our log files grow very large. I discovered a long time ago that you could shrink them by backing them up.

All that was left was to make it back up every day so that it never grew too big to backup. Unfortunately, I let it grow to big and I was no longer able to back it up because it was now 11 gb!

Finally, after much searching, I found this tool that shrinks your log file for you using the SQL-DMO object.

Here you go: http://www.codeproject.com/database/ShrinkingSQLServerTransLo.asp

WordPress Permalink with IIS on Windows

by 2 Comments

It appears I was a little quick to talk about how easy it was to install this on a Windows server. 3 hours later!

WordPress was really written to take advantage of all the benefits of Apache. It uses a feature of Apache called mod_rewrite to make urls like this “site.com/index.php?year=2004&monthnum=07&day=07” look like this “site.com/archives/2004/07/07/”. This is incredibly helpful with the search engines as they often don’t read URLs that have ?’s in them.

While you can use WordPress without this feature enabled, I feel it is extremely important. I was on the verge of uninstalling it when I finally found this article that solved my problems.

The problem was that Windows web server, IIS, doesn’t have an equivalent feature to mod_rewrite. In short, the solution suggested installing an add on to IIS called ISAPI_Rewrite . You can download the lite (freeware) version of it from here.

Rather than quote everything that I did, this article explains it very well.