Happy Chanukah and Merry Christmas to you! Just in time for the holidays, Solid has released the Generally Available version of solidDB for MySQL. Features of the GA release include:

• Both pessimistic and optimistic tables can now be specified in create table
• Performance enhancements
• New configuration parameters
• Documentation extended
• Online backup supported and documented
• New admin command checkpoint now supported and documented
• Support for insert into … on duplicate key … added
• Support for insert or update ignore added
• Support for drop table cascade added
• Support for geometry type added

Bits are available at http://dev.soliddb.com/download/ or you can go to a local mirror at our solidDB project at the …

How to Disable Windows Login Screensaver Have you ever been annoyed by the computer going into a screensaver before you've even logged in to it? This is a step-by-step guide to disabling this feature. Steps Login to your computer as an amdinistrator account. Go to Start->Run Type regedit into the text box Navigate in the explorer like window to the section: HKEY_USERS -> .DEFAULT -> CONTROL

How to Use Windows XP Built in Remote Desktop Utility This explains how to connect to another computer on your local network through Windows XP's built-in remote desktop utility. Steps Remote Desktop must be enabled on all the computers to which you wish to connect. To ensure that it is enabled, follow these steps: Right click the My Computer icon on your desktop or start menu and click

How to Convert Measurements Easily in Microsoft Excel

We've all been in a situation where we need to convert one measurement to another. An objects mass was measured in ounces and not kilos, or the lumber you ordered was measured in metres instead of feet, or someone is planning a trip to the USA and wants to know the speed limits in mp/h when they're used to km/h. There are a multitude of jobs where this is a daily task, some of them where measurements must be exact. Well, there is an easier way. There is a function in Microsoft Excel called CONVERT that will convert from one measurement system to another and all you have to do is specify the number and the measurement systems!

Steps

1. Start Microsoft Excel
2. The CONVERT function is not installed by default. It is part of the Analysis Add-in tool pack. To …

Hello All

Search the full text of books and discover new ones ---------> with Google Books


Enjoy

MICROSOFT IN EGYPT (CAIRO)

Soon Microsoft will be in Egypt, interviewing interested and qualified candidates for software development positions here in the USA at our corporate headquarters working on our major products.

If you know of anyone who might be interested, or a bulletin board where it would be appropriate to post this, please forward this email. There are multiple positions open and candidates will be in competition with themselves, not each other. Please send your resume/cv to egyptres@microsoft.com

What is a qualified candidate?

* Someone who has (or will be completing this year) a bachelor's (four year or more) degree in Computer Science or a related field

* Someone that has very strong abilities to write code …

I’ll be presenting a webinar about the solidDB for MySQL product on Tuesday, Dec 5. The webinar includes my talk, followed by some time at the end for Q&A. If you’re interested, you can find more info about the webinar and register for the event. ¶

As some of you may already know, Solid is well on our way to launching our Generally Available release of solidDB for MySQL. As part of the launch process, we are running a Pilot Program that gives customers early access to our storage engine technology. Customers in the Pilot Program will get help from Solid in integrating solidDB for MySQL into their business. They will also have access to Solid?s technical support and product management staff. Finally, there are some attractive incentives for future purchases and many other benefits. ¶

There are still a few slots left in the program, so if you are interested in participating, please send mail to pilot-request@solidtech.com and we will send you further details. …

We have released an update to Beta 5, which contains several bug fixes. This release is solidmysql-5.0.27-beta5-0040 (note 0040 instead of 0036 from the original Beta 5). You can get it from the usual place (http://dev.soliddb.com/download/). We also have new mirrors set up through sourceforge, which should improve the download speeds for people, especially for those who are in Europe or Asia. You can access the mirrors from the same download page. ¶

When using a uniqie index on a text field in mysql, the column collation setting is very important. The collation settings of a column does not only affect sorting and comparsion, but also unique indexes. So you can not insert "a" and "A" into a table that has a unique index on a column that has a case-insensitive collation. The mysql manual about collations: "A character set is a set of symbols and encodings. A collation is a set of rules for comparing characters in a character set."

Here is an example:
The column text in table text1 has a case-sensitive collation (_cs suffix), the column in text2 has a case-insensitive collation (_ci suffix).

PLAIN TEXT CODE:

1.  
2. CREATE TABLE text1 (
3.   `text` varchar(50) character set latin1 collate latin1_general_cs NOT NULL …