December 2022

T-SQL-Commands

T-SQL: Shrink incremental

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…

Read More
SteamGridDB Decky Loader plugin

Steam Deck: SteamGridDB 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…

Read More
Steam Deck BIOS

Steam Deck: enter the 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.…

Read More
T-SQL-Commands

T-SQL: Clear msdb backup history

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