I have been having a problem with SQL server on the Small Business Server 2003 R2 running away with over 1 GB of RAM. This has lead to high memory alert messages from the server. I did some goggling and found this article at DogRiley - Your Network WatchDog.

sqlservr.exe high memory usage for SBSMonitoring process

Syntax of commands
osql -E -S servername\sbsmonitoring

sp_configure ’show advanced options’,1
reconfigure with override
go
sp_configure ‘max server memory’, nnnn
reconfigure with override
go

I followed his example with my server named gentoo

C:\Documents and Settings\Administrator>osql -E -S gentoo\sbsmonitoring
1> sp_configure ’show advanced options’,1
2> reconfigure with override
3> go
DBCC execution completed. If DBCC printed error messages, contact your system
administrator.
Configuration option ’show advanced options’ changed from 0 to 1. Run the
RECONFIGURE statement to install.
1> sp_configure ‘max server memory’,100
2> reconfigure with override
3> go
DBCC execution completed. If DBCC printed error messages, contact your system
administrator.
Configuration option ‘max server memory (MB)’ changed from 2147483647 to 100.
Run the RECONFIGURE statement to install.
1> quit

What a way to spend 2 days of my easter weekend. I added some RAM and added a drive to the RAID array of the main server.

I needed to dived the extra space over 3 partitions currently on the server, so I needed a partitioning tool, and I did not want to pay for it. I have used Knoppix in the past and loaded up QTParted, and it has worked well. I went to use this tool again, but found I could not move partitions. So I did some searching and found GParted, and they had a Live CD.

So I made sure I had a complete backup and booted up the CD.

Very basic interface, but it was all that was needed, nothing more. The program scanned my drivers and found everything. I then proceeded to resize, and move partitions. The tool did everything I needed! I then Hit apply, and a warning came up saying it might take a long time, and I assumed maybe a few hours.

11 hours later the first partition was done, now came the other 2. just under 20 hours from starting, the process was finished. The only complaint that I have is that there was no message box on the screen reporting that the operations were complete.

Go to Start | All Programs | Accessories, then right-click on “Command Prompt”, and select “Run as administrator”.
This will open a command prompt window with admin rights.
Navigate to the directory where you saved the apache*.msi install file, and type “msiexec /i apache*.msi”
(where apache*.msi is the actual name of the file - hint: type apache and then hit tab, it should fill in the file name automatically). Hit enter, and the rest should work just fine, it did for me. Hope this helps.

While a few commands, such as ‘cd’ are built directly into bash; many of the most important commands come from coreutils, a GNU package containing over a hundred commands.

Some are the well known commands such as ‘ls’, ‘mv’ and ‘cat’. While there are some more obscure ones that are not always discovered because there are also more modern programs that can do similar jobs.

http://commandline.org.uk/2007/ten-cool-coreutils-commands/

I was playing with the new BIT data type in MySQL 5.0.24 and found that it does not work as expected. It does not accept data in a single quoted field as in
INSERT INTO TABLE VALUE(’1′);
I get a Data Too Long error.

I found this article that explains how it works, and that you should avoid it.
Why you should not use BIT columns in MySQL - Xaprb
Why you should not use BIT columns in MySQL

MySQL implements the BIT data type differently in different versions, and the behavior is not what one might expect. In this article I’ll explain how MySQL’s behavior has changed over time, what strange things can happen as a result, and how to understand and work around display issues. I’ll tell you about a serious bug I’ve found, and discuss differences in the BIT data type between MySQL and Microsoft SQL Server.