May 17, 2016

Copy/paste without using Ctrl+c, Ctrl+v

Here's an alternative to using the well known keyboard combinations Ctrl+c (to copy) and Ctrl+v (to paste).

Copy: Press Ctrl + Insert
Paste: Press Shift + Insert

In some terminal windows you copy text by simply selecting it using the mouse, and you paste by either right-clicking (PuTTy) or using the middle mouse button (Ubuntu).

May 11, 2016

Fixed: SQL Developer with JDK (64 bit) Unable to launch the Java Virtual Machine

The problem

After downloading Oracle SQL Developer version 4.1.3 with JDK (64 bit) and unzipping it to C:\Program Files\ it won't start. The following error message is presented when running sqldeveloper.exe

Unable to launch the Java Virtual Machine
Located at path:
C:/Program Files/sqldeveloper/jdk/jre/bin/server/jvm.dll

My setup:

  • Windows 10
  • No Oracle client installed
  • No Java installed


There are suggestions out there saying that you should mess with SetJavaHome in the sqldeveloper.conf file. Others talk about properly setting java environment variables. But the reality is that SQL Developer does not require any other Oracle components to be installed in order to run. The changes might fix some problems for some people, but it's not relevant to my situation.

The solution

Copy the file msvcr100.dll from C:\Program Files\sqldeveloper\jdk\jre\bin\ to C:\Program Files\sqldeveloper\sqldeveloper\bin\

Fix limited or no connectivity Wi-Fi issues in Windows 10

"This connection has limited or no connectivity" after upgrading to Windows 10


After upgrading my laptop from Windows 7 to Windows 10 it started having intermittent problems with Wi-Fi connectivity. It would connect to my Wi-Fi networks, but occassionally it would give the message below
"This connection has limited or no connectivity"
Troubleshooting would always show that there was nothing wrong with the network. There was nothing wrong with the laptop, since it could connect to other networks. Windows would simply decide that a particular Wi-Fi network can't be used to access the Internet.

Rebooting, disabling the network adapter and many other things I tried to reset it did not help.

I found two ways to solve the "limited or no connectivity" Wi-Fi issue thanks to a blog post linked at the bottom of this post. Here are the short versions of the tips that worked for me.

How to re-enable PuTTY output after pressing CTRL+S

Pressing CTRL+S in PuTTY disables the output to screen. It will appear as if your connection is dead, since you won't see anything happening when you type commands. The fix is to press CTRL+Q to enable output again.

No need to open a new session to the server. Whatever you've typed while output was off (after CTRL+S) will be visible and you can keep working.

CTRL+S sends XOFF
CTRL+Q sends XON

Easily create QR Codes for free using GoQR.me

A great website for creating QR codes for free
goqr.me is a great website for quickly creating QR codes for free

I was recently in need of a way to quickly create a QR code. The site I ended up using is super easy to use and can be used for free. It's not bloated with ads, pop-ups or other annoyances. No need to register or give up your e-mail address.

Just choose the type of QR code in step 1, and enter the text/URL or other contents in the box. That's all! You can now choose the size of the image and download your QR code.

In short: if you need a quick and easy way to generate a QR code, for free, give goqr.me a try.

February 24, 2016

How to Disable the Windows 10 Lock Screen

The Windows 10 lock screen might be a good idea on a Windows phone, but on a computer all it does is add an extra step every time you want to log in or unlock the computer.

By disabling the lock screen the computer presents the password prompt right away.

Here's how to quickly and easily disable the Windows 10 lock screen in the Registry editor.

  1. Open the Start menu and type regedit to to open the Registry editor
  2. Navigate to:

    HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\Personalization


    If you don't have the Personalization key, simply right click the Windows key in the structure and choose New to create it.

  3. Right-click in the right window and create a DWORD value named NoLockScreen
  4. Double click the new NoLockScreen value and enter the number "1" and then click OK.
  5. Close the Registry editor, you are done!
The lock screen has now been disabled. Hope that helps!

November 12, 2012

QPKG updated to support CrashPlan 3.4.1 on QNAP NAS

CrashPlan backups stopped working on QNAP NAS

It seems that the excellent backup software CrashPlan was recently updated to version 3.4.1.

For users running CrashPlan on a QNAP NAS, by using the QPKG package available from the QNAP forums, this means that CrashPlan has simply stopped working (and is no longer backing up files).

This has to do with the CrashPlan auto-update feature, which unfortunately can't be disabled. The CrashPlan installer and the QPKG have completely different directory structures, and it appears to be something that can't be made to work on a QNAP NAS.

Unable to connect to the backup engine on QNAP NAS after CrashPlan released an upgrade.


Upgrade to the latest CrashPlan QPKG for your QNAP NAS

Good news is that dynek, who maintains the CrashPlan QPKG, released an updated version on November 11. It is now available in the QNAP forums and can be used for fresh installations or upgrades.

NOTE: Make sure to read the section "Update instructions" if you have already installed a previous version and are upgrading! You should not uninstall the old version!


November 6, 2012

SQL query shows the benefits of Block Change Tracking

SQL query that shows the benefits of BCT

To see how much you benefit from having Block Change Tracking enabled, use this query to calculate the percentage of blocks read and the number of blocks backed up during incremental backups.

For results to show up, you need to have Block Change Tracking enabled and have performed an incremental level 0 backup followed by one or more incremental level 1 backups.

The query returns one row for each datafile backed up using RMAN.

select file#, avg(datafile_blocks) blocks,
avg(blocks_read) blocks_read,
avg(blocks_read/datafile_blocks)*100 pct_read,
avg(blocks) blocks_backed_up
from v$backup_datafile
where used_change_tracking='YES'
and incremental_level=1
group by file#
order by file#
;