I.T. minded
Yes, Hogwarts Legacy runs great on your little buddy, the Steam Deck! But of course, it’s never perfect. Are you for looking for some performance improvements, you can try to add the options below. Open desktop mode (or use ssh/scp), open dolphin/file explorer and edit the following file: Or with…
To identify the queries that are responsible for high-CPU activity currently, run the following statement: If queries aren’t driving the CPU at this moment, you can run the following statement to look for historical CPU-bound queries:
If you still have a Windows system somewhere, and you want to transfer files to the deck, you can easily transfer those files using SSH default, the deck has a ssh server installed, but this isn’t started.You can easily enable that using a terminal on the deck, and execute: Once…
With the powershell script below, you can check TLS settings on Windows Server .
Well, SQL statements can use a log of log space, and you most probably want to find out which SQL statement is using all of your log space. The T-SQL code below will show you the SQL statements using the log space, including the size that it’s using.
First off you don’t ever shrink a database file unless you known it won’t need the space back again. (There’s some caveats to that statement but it mostly holds true) If that’s the space the file has consumed generally that’s the space the file needs. Shrinking just means the file…
Personally I didn’t like installing special plugins on the Steam Deck, just because..I don’t know :). Then I noticed that they is a plugin for ‘SteamGridDB’. What is SteamGridDB? Well, that’s a website which has a LOT of artwork for a lot of games for the steam client. If you…
In order to enter the BIOS of your Steam Deck, you can follow the procedure below. 1. Hold the Power button on your Steam Deck. 2. Turn off your Steam Deck by selecting Shut Down from the options that appear on the screen. 3. Press and hold the Power and Volume Up buttons until you hear a beep. 4. Select Setup…
After a while,the msdb database can be overloaded with backup history, and clearing that history can be a pain. You can use the t-sql code below to clear the msdb backup history, in incremental steps of 1 week.
Using WP-CLI you can create MO files from PO files using the following command:
1. Begin by pvcreate’ing the new disk. This is the disk from the new storage array to which we want to migrate to. # pvcreate /dev/mapper/mpathY 2. Now, add this disk into the data_vg Volume Group : # vgextend data_vg /dev/mapper/mpathY Make sure there are free extents on the new…
With systemd you can configure the service so that it automaticaly restarts the service in case the service crashes.It’s enough to add the “restart” option to the [service] stanza within the service systemd configuraiton file.See example below. Of course, you need to reload the systemd file in order to active…
Once in a while the clamd process can get killed because of memory usage. It turns out it would always get killed when reloading the database after an update. This is due to the fact that during a database reload clamd will load the new DB first and then drop the old…
Mapping Oracle ASM disks to physical disks can be done using the command: This will result something like this:
You can group datetime fields by year/month by using a simple ‘format’. Of course, there are other possibilities for doing this. See example below:
When SQL Server needs a database master key to decrypt or encrypt a key, SQL Server tries to decrypt the database master key with the service master key of the instance. If the decryption fails, SQL Server searches the credential store for master key credentials that have the same family…
With curl you can test if your website supports http2. Just execute the following curl command: