Fixing slow queries running on SQL server using JPA (Hibernate) and jTDS

Submitted by Jochus on Thu, 01/05/2014 - 07:40 | Posted in: Java
Posted in



Some JPA queries, especially the ones with a LIKE operator, can run very slow on a SQL server using jTDS.

The issue is in the way the jTDS drivers send the parameter strings to the SQL server. Apparently Java will attempt to send the parameters Unicode by default, and SQL server will translate it to ASCII. It can take some seconds because it changes each column value to Unicode before comparing against your parameter. This means it can't take full advantage of any index on the field leading to much slower performance.

If you add the following parameter sendStringParametersAsUnicode=false to your connection string in the datasource, this conversion step can be skipped and it can speed up the performance of your queries:


jdbc:sqlserver://localhost\SQLEXPRESS;DatabaseName=TESTDB;sendStringParametersAsUnicode=false

How to disable phone number linking in Safari on an iOS device?

Submitted by Jochus on Thu, 01/05/2014 - 07:33 | Posted in: Mac
Posted in



I recently got a question from somebody who has a personal site on the web and he wanted to disable the phone number linking on his own site (which is rendered automatically in the Safari application of an iPad). I first assumed that such request could not be answered, but I came across following solution:

If you include the following meta tag at the top of your page:

<meta name="format-detection" content="telephone=no">

... phone linking will be disabled. More information can be found on the developer pages of Apple: https://developer.apple.com/library/ios/featuredarticles/iPhoneURLScheme_Reference/PhoneLinks/PhoneLinks.html

How to completely remove Office for Mac 2011 from you Mac OS X installation

Submitted by Jochus on Thu, 01/05/2014 - 07:26 | Posted in: Mac
Posted in



I recently had a problem with an update of Office on my Macbook Pro. The only solution was to remove everything (but really EVERYTHING) from Office for Mac. Afterwards, the installation + update went fluently.

A very good tutorial on removing Office for Mac can be found here: http://support.microsoft.com/kb/2398768

Disable FileZilla server interface from popping up on server logon

Submitted by Jochus on Thu, 01/05/2014 - 07:22 | Posted in: Windows
Posted in



When I logon to a server which is running a FileZilla server (as a service), I always get a popup which connects to the FileZilla server. It's a bit annoying as you can only disable this popup while installing the server. There's no GUI configuration to disable it after post install.

Luckily, there's a small fix in the windows registry which disables the popup, but still keeps the FileZilla server service running in the background:

  • Navigate to the following key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run\
  • Remove FileZilla Server Interface entry