Tutorial

Fix for RTX Graphics Cards rebooting Dell XPS 8700

Symptons: NVidia RTX 2060, 2070 and 2080 cards cause random reboots in Dell XPS 8700 computers on low demmaning softwares like browsers or 3D viewers.

Solution: Disable PCI Express Link State Power Management

  1. Click on the Start Menu and then type "Power Options" to open the app with the green battery icon.
  2. Select "Change plan settings" for your current power scheme
  3. Select "Change advanced power settings"
  4. Disable the PCI Express link state power management.

Notes:

Excel - Pivot tables with text values or numbers without calculations

Objectives

Create a Pivot table that displays text data or number values that are not summarized (count, sum, etc...). This solution does not require macros or long search/replace functions, just the Microsoft Power Query tool that comes with Excel 2016 or can be installed for free as an add-on in previous versions.

Drupal - Duplicate view results in multi language sites

This article explains how to eliminate the duplicate pages that appear in multi-language Drupal site views. The solution was tested on Drupal 8 but works well in previous versions.

Duplicate pages normally appear in:

  • Banners
  • Most Popular Lists
  • Related Content lists
  • Slideshows
  • Taxonomy terms
  • What's new pages
  • Lists or Tables
  • Views in general

Types of duplicate pages

There are two types of duplicate results in multi-language website views:

Installation of the rear speakers on the Suzuki Jimny

If you have a Suzuki Jimny up to 2011 (or later) you probably noticed the very bad sound quality of the original sound system. The bad quality is not from the receiver/player but from the low-end Sanyo speakers included on the car and the absence of rear speakers. This tutorial will teach you how to install the rear speakers.


To preserve the original factory warranty this installation will not alter the electric cables, the car body or the holes for fixation.

Installing an USB/SD/MP3/Aux-in adapter on the Suzuki Jimny OEM Radio

The OEM Clarion Radio that comes with the Suzuki Jimny doesn't allow modern media inputs as most of the car radios. It comes only with a CD player and a AM/FM receiver. Replacing this unit with a convencional 1 or 2-din stereo is not that simple since the dash has an unusual round edges hole. Fortunately the manufacturer of the radio, Clarion, included a CD changer port called Cenet (anyone uses a CD changer nowadays?)