T-SQL: Shrink incremental

T-SQL-Commands

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…

Read More

Steam Deck: SteamGridDB plugin

SteamGridDB Decky Loader plugin

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…

Read More

Steam Deck: enter the bios

Steam Deck BIOS

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…

Read More

T-SQL: Clear msdb backup history

T-SQL-Commands

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.

Read More

Linux: migrate storage with pvmove

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…

Read More

Systemd: automatically restart after failure

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…

Read More

Clamav: limit memory usage

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…

Read More

T-SQL: Add/drop pass to open a database master key

T-SQL-Commands

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…

Read More

T-SQL: Jobs in suspended state

T-SQL-Commands

It is possible that sql jobs are “hanging” in a suspended state. The SQL statements below will give you an indication on what the job is waiting.The first SQL statement will create a small stored procedure in the master database, which can be called by “exec sp_check_state”.The second sql satement…

Read More

Linux: quotaon: Quota format not supported in kernel

I was building a new system for hosting, and that system is a virtualised system with  Ubuntu. The OS was built by the provider. After installing everything, I wanted to activate the quota on the filesystem. The quota check failed with the following message: After a small check, I noticed that…

Read More

SQL server: Slow SSMS

T-SQL-Commands

If you are using SSMS 17 or 18, you have maybe noticed that the SSMS startup can be very very very very slow, which is annoying for everyone. There are 2 workaround, which could resolve this issue: Open  Internet Explorer: Options Then scroll to the bottom of the list and uncheck…

Read More

Linux: GRUB slow on 4k screens

In case you have a screen with high resolutions, a 4k screen for example, it is possible that GRUB is incredibly slow. If that is the case, the workaround is to edit the /etc/default/grub file, and add/replace the following line Then run “update-grub” to update the GRUB.This will run GRUB…

Read More