Enable/disable CPU turbo boost from command line

Intel’s turbo boost can be enabled and disabled in Windows using the command line.

First we need to check the active profile.

By default Windows does not display the turbo boost setting via the powercfg utility. To enable it use the command:

Using the current profile’s GUID 8c5e7fda-e8bf-4a96-9a85-a6e23a8c635c we can check if turbo boost is enabled or not.

The output of the command shows that turbo boost is disabled using AC and using DC:

To enable turbo boost in AC:

To enable turbo boost in DC:

The last argument is the index of the turbo boost mode to enable (003 is “Efficient enabled”).

To apply the changes use the command

How to read huge Excel file using C#

Reading a Excel file is easy using the SpreadsheetDocument and SheetData classes but this method uses a lot of memory if the Excel file is big.
This is due to the fact that to get the sheet data the framework loads the entire file into memory.

To read huge files it is better to use the OpenXmlReader.

Here’s an example usage of the OpenXmlReader (it also consider the SharedString)

To loop the Excel’s rows

The OpenXmlReader uses less memory, but it is slow.
For faster reading you can use the ExcelDataReader, it is available also as a NuGet package.

How to use the BASS audio library in UWP development

The BASS audio library is a solid library to decode and play many audio formats, supports gapless playback (using the mixer, not used in this example) and equalizer (not used in this example).

The library is available also for Windows Store development.

To reference the BASS audio library in your UWP project remember to add conditional references based on platform in the csproj file

Let’s see how we can use the library in a background audio player.

First we need the background task. Here we initialize the BASS audio library, and free it when the task ends. Since we are going to use BASS only to decode the audio we can use the “no sound” device.

Now we need to play the file when the foreground app asks for it. Communication between the foreground app and the background task is made through messages.

When the background task receives a “file” request message it opens the file using BASS (we’ll see later how) and sets the media source of the bacgkround media player.

The BassMediaSource class implements IMediaSource and is the one responsible of opening and playing the file.

The code is quite simple: we need to create the decode stream for the BASS audio library and listen to the MediaSource events (Closed, Starting, SampleRequested).

The SampleRequested event occurs when then audio player needs a decoded sample to play. Here we just need to decode the requested data and return it to the player.

The application lets you select a file from your music library (files outside of your music library won’t work because the application does not have access to external folders).

Here’s the full source code of the test program (remember to set your BASS registration info)

Download source code

Have fun! 😉

GPD Win: Fix game crash in full screen through HDMI

Life is strange crashed during startup on my GPD Win when using HDMI output (I think I read about people having the same problem with other games).

After messing with the display settings I found a working configuration that I think might fix the same issue with other games.

Open the Intel display settings window and

  • Set the mode to Extended desktop and select your external monitor as the primary display
    My GPD Win screen went to portrait mode (rotation 0) but you can restore it by setting rotation to 270.
  • Set the display resolution to 1280×720 (it was 1920×1080 by default)
  • Done, you can play Life is strange 😉