Python: view line numbers in standard editor


By default IDLE (the standard Python IDE) does not show line numbers 😦

You can install the extension IdleX to do this.  This is only one of IdleX’s features. See for an overview of all features.

You can download IdleX here.  After decompressing the ZIP file you only need to run to use this extension (and show/hide line numbers).

Python: creating executables


Out of the box Python is an interpreted programming language.

One way to create an exe file from the standard Python py files is using PyInstaller.  (note: I am working with Python 3.5.  PyInstaller supports Python 3.  Py2exe – which also allows to make exe files – currently only supports Python 2.7)


  1. Download PyInstaller ( – documentation can also be found here)
  2. Install PyInstaller with the pip command:
    • Start Cmd
      Go to the folder containing (using CD FOLDERNAME)
    • Execute the pip command:
    • > pip install pyinstaller

Now package your py file with the command PyInstaller; for example:

> PyInstaller

The exe file will now be created under the dist folder.  You need all files in the dist folder containing the exe file.

Other examples:

> PyInstaller -F

Now Testapp.exe will also be created in the subfolder caller “dist” in a one-file bundled exe file.

> PyInstaller -F -w

This also creates a one-file bundled exe file, but does not show a console window; this is probably what you need when you create a GUI application.

Changing colors in SciTE


When attaching an external monitor I was not able to see a code selection on this screen in the AutoIt editor SciTE.

I found out that changing the colors involved modifying the “c:\Program Files (x86)\AutoIt3\SciTE\” file.

More specifically changing the selection.fore, alpha and back solved the issue.


As the alpha.selection settings apparently can behave differenty on a laptop display and an external monitor, it makes sense to disable this setting …

AutoIt Colors 2


  1. When you modify the colors in SciTE, you can immediately see the result after saving the file.
  2. Put # in front of the original line to keep a backup of the original setting.
  3. See for example this page on for an overview of hex values colors
  4. Modify indicators.alpha, for example to “indicators.alpha=150” to improve visibility when highlighting a word (see below)


SQL queries on WSUS database


Sometimes you need to query the WSUS database using T-SQL statements.

The WSUS database can be installed using the Windows Internal Database (shipping with WSUS 3.0) or a standard SQL database.

When a Windows Internal Database is used, you can use SQL Management Studio Express to connect to.  Use the following string to connect to this database: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
For more info, see
Continue reading SQL queries on WSUS database

IT to the point