Special Polish characters in KDE applications

If special Polish characters are not displayed correctly in KDE applications, configure them to use Verdana instead of Helvetica.

You can also change the fonts used by the system using Kcontrol, if you are using KDE.

I am not sure, if system language settings affect this. I am almost 100% sure that there is a better way to solve this problem, but this one's quick & simple.

I've found it here.

Visual Studio add-ins and .NET tools

Just a few links today:

• Ten Essential Tools Visual Studio Add-Ins Every Developer Should Download Now
My favourite add-in described in this article is Smart Paster - it is really useful if one is creating a lot of SQL queries in Query Analyzer and then pasting them into Visual Studio, like I do.
• Ten Must-Have Tools Every Developer Should Download Now
This article was published more than a year ago, but it's still worth reading. I used almost every tool described here.
• XML Visualizer
  
And this is a how-did-I-live-without-it tool. It allows to view data in various XML-backed data sources (for example, DataSet and DataTable variables) while debugging.

Installing VMware Workstation on Ubuntu

When installing VMware on Ubuntu (and other Linux distros too, I think) from a compressed tar archive (for example, VMware-workstation-5.5.0-18463.tar.gz), make sure to change the directory to the root of an unpacked tarball, so you can start the installation by typing ./vmware-install.pl. Otherwise, the setup process will fail.

I had a problem installing VMware 5.5.0 and I found the solution here.

Transaction isolation levels in Oracle Database

There's an interesting article about transaction isolation levels in the last issue (November/December 2005) of Oracle Magazine - On Transaction Isolation Levels by Tom Kyte.

Being a SQL Server guy who has to use NOLOCK all the time, I was surprised to learn that there is no READ UNCOMITTED isolation level in Oracle Database. And here's the explanation how it is solved:

When the query I'm executing gets to the block containing the locked row (row 342,023) at the bottom of the table, it will notice that the data in it has changed since execution began. To provide a consistent, or correct, answer, Oracle Database will create a copy of the block containing this row as it existed when the query began. That is, it will read a value of $100, which is the value that existed when the query began. Effectively, Oracle Database takes a detour around the modified data—it reads around it, reconstructing it from the undo (also known as a rollback) segment. A consistent and correct answer comes back without waiting for the transaction to commit.

Nice.

Upgrading Ubuntu 5.04 to 5.10 (in, increasingly inaccurately named, 3 easy steps)

All you have to do to upgrade Ubuntu 5.04 (Hoary Hedgehog) to 5.10 (Breezy Badger) is:

1. Start Synaptic Package Manager.
2. Go to Settings / Repositories.
3. Change Distribution from hoary to breezy for every Ubuntu repository (example).
4. Close the Repositories window; the package information will be automatically reloaded.
5. Press Mark All Upgrades button and choose Smart Update.

That's all - Synaptic Package Manager will download all the needed packages and install them.

VS 2005 Beta 2 - cannot create a new project or open an existing one

I have been using Visual Studio 2005 Beta 2005 for a few weeks and one day, completely out of the blue it failed to open my project. I tried to open another one - the same result. I also couldn't create a new project.

Unfortunately, I didn't jot down the error message, but I remember it mentioned Microsoft.Common.targets file.

I checked this file on my machine and it turned out that it was empty. I did some googling to make sure that it is not normal and then reinstalled .NET Framework 2.0 (use repair option) - it helped!

Ubuntu - smooth fonts (continued)

I wrote this yesterday.

And today I've removed Arial font from my system (you can type fonts:/// in Nautilus and delete appropriate files) and, in my opinion, Google and Gmail look now even better than yesterday, because Firefox uses sans-serif instead of Arial.

Ubuntu - smooth fonts

My OS is Ubuntu and the browser of my choice is Firefox. Some WWW developers seem to be unaware of the fact that not everyone in the world runs Windows and specify only fonts like Verdana, Tahoma, Helvetica or Arial in the CSS files. On my machine such webpages (example) were rendered with a font that looks like Times New Roman and looked really awful.

To solve this problem I installed msttcorefonts package. This solved one problem... And created another one. Google and Gmail started to look worse than they did before.

After some searching I found this thread and enabled autohinting in /etc/fonts/local.conf file. Both Google and Gmail started to look good again. And what's more all fonts on the system seem smoother and clearer.

Autohinting disabled
Autohinting enabled

I made amaroK show ID3v2 tags! Finally

I have been using amaroK during the last few months and I think it is an excellent MP3 player (on the other hand, I like foobar2000, too). However, throughout all this time I have struggled with one problem - amaroK kept trimming long song titles, band names, etc (for example, instead of Anyone Can Play Radiohead: A Tribute To Radiohead it showed only Anyone Can Play Radiohead: A T).

Today I have found this and the problem is gone. I've pasted an appropriate piece of amaroK's FAQ below:

amaroK is not using the tags I know are in my files!

If Konqueror or other apps are displaying different Title, Artist, Album or Genre information than amaroK is picking up when it creates your collection, it may be reading the older ID3v1 format tags rather than the newer ID3v2 tags. This can be due to your Encodings setting:

• Go to Settings, Configure amaroK, and then find the Encodings section of the Settings panel. Unclick all checkboxes to "Do not decode the following as latin1".
• Rescan your collection to pick up the ID3v2 tags.

Reflections on installing MSDE

So you've been working with SQL Server for almost two years now?
And you've installed SQL Server a few dozens of times?
And you've passed 70-728 with more than 900 points?

Believe or not, but you still may encounter some problems while installing MSDE. Firstly, there is no wizard; you need to execute setup.exe with appropriate parameters from command-line. And secondly, if you install MSDE using only SAPWD and INSTANCENAME parameters, it will later run in Windows Authentication mode, despite the fact that you have to provide an sa password.

If I had found this article yesterday, it would have saved me a lot of headaches. I didn't, so I had to work it out all by myself. I learned a lot.