Sunday, December 27, 2009

HP ProLiant boot failure

After firmware update on HP ProLiant you may encounter following trouble: the machine failes to boot form HDD or USB stick.
The system check routine displays valid boot sector on HDD, but the boot still fails.

The possible reason: check if your box has an external USB HDD attached. Try to detach the USB cable, restart the machine - and enjoy!

UPD: alternatively
1. Boot the box and enter the boot setup
2. Insert floppy boot option between HDD and USB (you shouldn't have any floppy drives, but the boot option is still here)
3. Reboot the box

Saturday, December 05, 2009

Windows Live Writer @Win7

This entry was written with Windows Live Writer @ Windows 7.

I like it!

Wednesday, December 02, 2009

While using "Result to Text" the output is trimmed to 256 chars

The output of query results in SQL Management Studio (Microsoft SQL Server 2005, 2008) is redirected default to Grid(s).

Optionally you may want to redirect them to text (for example, to re-use output as composed statements etc.). You will be wondered, why the same results are displayed complete while "Results To Grid" set and trimmed to 256 chars once you switch to "Results To Text".

The reason is the default setting in Query Options:



Adjust the setting "Maximum number of characters displayed in each column" and enjoy!