Tutorial

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:

Step by step installation

This tutorial was written for Windows 10 64-bits but should work for Windows 10 32-bits, Windows 8.1 and Windows 7.

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 8 has a known issue that allows database cache tables grow to the infinite (hundreds of MB or even GB) this can slow or stop automated backups and in the worst scenario, take all available storage and put the site offline.

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:

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.

The Suzuki Jinmny is a very robust and well built car for off-road purposes. If you have plans to go a little deeper than the standard factory wading depth limits you should consider this inexpensive modification to prevent water from getting inside the gear wheels.

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?)