18. May 2017

How to use PowerShell in IntelliJ Idea terminal instead of cmd

IntelliJ Idea has support for embedded terminal. That’s handy because you do not need to open extra window just for a terminal.

The default configuration of IntelliJ on Windows is installed with old-school cmd.exe. It’s quite easy to replace it by PowerShell.

Go to Settings (Ctrl+Alt+S). Search for word “terminal“. Select Tools – Terminal.

Change Shell path option from cmd.exe to

C:\WINDOWS\System32\WindowsPowerShell\v1.0\powershell.exe

Press OK and start new Terminal window.

I recommend to use Dracula theme which is a little bit more readable than the white theme.

2. March 2017

How to increase font size in pgAdmin 4 on Windows

New version of pgAdmin 4 is based on QT5. When you install pgAdmin 4 on Windows computer with a high-density display you may see that letters are too small.

Solution is to send one parameter to QT engine. It will handle DPI in different way.

Open PowerShell and go to directory with pgAdmin. Then launch application with parameter:

cd "c:\Program Files\PostgreSQL\9.6\pgAdmin 4\bin"
.\pgAdmin4.exe -platform windows:dpiawareness=0

You can persist the configuration by creating qt.conf. Start PowerShell as Administrator. Go to directory with pgAdmin and create the file:

cd "c:\Program Files\PostgreSQL\9.6\pgAdmin 4\bin"
notepad qt.conf

Write there following content:

[Platforms]
WindowsArguments = dpiawareness=0

Save the file and start pgAdmin 4 and enjoy new font size.

25. February 2017

How to limit amount of data downloaded by Windows 10 Updates?

Windows 10 often downloads a large volume of updates. This is not a problem when you have good connectivity. When you’re on some slower network like ADSL it might lead into problems with connectivity.

One option how to limit the amount of downloaded data by Windows 10 update is to set a connection as Metered connection.

Search for Change Wi-Fi settings in start menu:

In Wi-Fi section scroll down below list of available networks and click Advanced options.

Flip the toggle Set as metered connection to On.

Windows will limit the amount of downloaded data and it will download only necessary stuff.

21. January 2017

How to freeze 1st row and 1st column in Excel

Tables in Microsoft Excel could be really big and it’s easy to loose track about information from the first column or the top row. There is simple way how to lock these two parts on screen.

Select cell B2 (it will serve as reference point), click View, click Freeze Panes.

Select Freeze Panes from drop-down menu.

Done 🙂

17. January 2017

How to disable autocorrect in Skype on Windows 10

The default autocorrection in Skype on Windows 10 might be annoying sometimes. The question is how to disable it? It’s little bit hidden.

Click menu Tools and select Options… or press CTRL+,

Select IM settings in left pane, click Show advanced options

Uncheck Auto correct and highlight misspelled words, click Save