Check Index Fragmentation with SQL Server 2000/2005

This post looks at how to check if an index is fragmented in a Microsoft SQL Server table and how to rebuild the index. The advice offered in this post works for both SQL Server 2000 and SQL Server 2005 although the methods are deprecated for SQL Server 2005 and are likely to be dropped in the next release. I will look at the alternate way of doing this for SQL Server 2005 in a later post.

Change Adobe Photoshop Filename Compatibility Options

Adobe Photoshop’s "Save for Web" function will truncate filenames to 31 characters by default to (apparantly) allow for compatibility with Mac OS 9 browsers. The dialog box which gives the warning about the filename truncation tells you to edit the output settings but it isn’t that clear where to go to actually change the filename compatibility options. This post looks at how to do this.

Using the FCKEditor HTML Editor with PHP

FCKeditor is an in-browser WYSIWYG HTML editor and I use it on a number of websites including in the blog admin for this website. This post looks at how to put FCKeditor into a web page using PHP. In future posts I will look at some of the other functions and features of FCKeditor.

logwatch “postdrop Illegal seek” and “sendmail queue file write error”

logwatch is a daily process for reporting and analyzing log files and I recently started getting errors on one of the CentOS Linux machines I manage and no daily report. The particular machine gets thousands of bounced emails per day and the mail log files get very large. logwatch had been reporting to me every single bounced email message so the report emails had got very large before stopping altogether. This post looks at the error messages I got and what I did to fix the problem.

FCKEditor: Using a custom configuration file

A little while back I posted about how I upgrade FCKEditor when a new release comes out, and how I need to merge changes from my old fckconfig.js to the new one for the new release. I have since learned how to use a custom configuration file with FCKEditor which means no longer needing to merge changes into the new version of the file.

Changing the Postfix maximum email size

I’ve recently had some of my customers emailing me large image attachments and my Postfix mail server has been rejecting them. A quick look at the postfix configuration showed the message size limit was the default so I needed to increase it. This post looks at how to see what the current email message size limit is with Postfix and how to change it.