Duplicate entry in a form

I have seen several forms recently that requested user to enter some information twice. It makes sense to retype the password that user has chosen. It reduces a risk that user does typo and newly created account will be unaccessible. But these forms asked the user to retype his email address or existing password. The email address is displayed unlike password, so the risk of typo is quite small. But I can imagine that developer thinks that this email is so important to force the user to enter the same information twice. To retype existing password is totally useless. If the user enters his password incorrectly, just redisplay the form. Please when you design some form with duplicated entry of some field, ask yourself – is it really neccessary to bother the user?

Malý testík pro programátory

Dámy a pánové, programátoři všeho věku, leč se zaměřením na Javu, mám pro vás jednoduchý úkol na pozdní večer. Už vás nudí číst si cvrlikání na twitteru nebo tlachání na facebooku? Politiky na rádoby důvěryhodné idnes máte plné zuby? Zkuste si zahrát na programátory bankomatu. Zjednodušenou formu najdete na adrese http://37.205.9.68/hiring/ a jestli uspějete, možná si to vyzkoušíte doopravdy :-).

Tips on installing MS SQL 2012 Express edition

Well, I was once again forced to use another Microsoft product – their database this time. And it took me several hours to make it work, so I want to share some details in hope, that it will be helpfull to you.

The installation was smooth but later I realized that I cannot contact this database from java. Why? TCP IP was disabled by default. This is very secure option, yet I can imagine more secure one – switch the computer off. Stop kidding. Open SQL Server Configuration Manager, open Network configuration from left tree and select Protocols node. There you need to enable TCP/IP protocol, open its properties dialog and change the property Enabled to true.

TCP/IP protocol properties

Dis is one half. Oh no, it is back! (Who does understand this joke?)

If you try to connect this new database, you will fail again. MS SQL will play a game Guess my port with you. Ok, they have some naming service and some good reasons for this behaviour, but let keep things simple and switch off dynamic ports feature. Choose IP addresses tab. Either modify one concrete network interface or find the last section IP All. Delete value in the option TCP Dynamic Ports and set 1433 to the option TCP Port. Finally you have to restart MS SQL service.

Default value with dynamic portupdated value to MS SQL default portRestarting MS SQL service

Stop, we are not finished yet. You do not want to use your windows credentials and probably store them somewhere in configuration files, do you? So it is time to switch off Windows Authentication mode. Open MS SQL Management Studio, edit server properties, Security page particularly. There you need to select mixed mode – both SQL Server and Windows Authentication modes in Server authentication section.

Selecting authentication mode

And finally create some user with appropriate roles. It is neccessary to be DDL admin and DB owner for development purposes. Restart MS SQL

Adding new user

Some useful links I used: