Latest Posts
📅 2022-01-18
✍️ Bart Schelstraete
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…
Read more →
📅 2022-01-06
✍️ Bart Schelstraete
Mapping Oracle ASM disks to physical disks can be done using the /etc/init.d/oracleasm command: # /etc/init.d/oracleasm querydisk -p ASMDISK1 This will result in something like this: Disk "ASMDISK1"…
Read more →
📅 2022-01-06
✍️ Bart Schelstraete
You can group datetime fields by year/month by using a simple 'format'. Of course, there are other possibilities for doing this. See the example below: declare @format varchar(100) = 'yyyy/MM' SELECT…
Read more →
📅 2022-01-06
✍️ Bart Schelstraete
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…
Read more →
📅 2022-01-02
✍️ Bart Schelstraete
With curl you can test if your website supports HTTP/2. Just execute the following curl command: curl --http2 https://www.schelstraete.org
Read more →
📅 2022-01-02
✍️ Bart Schelstraete
It is possible that SQL jobs are "hanging" in a suspended state. The SQL statements below will give you an indication of what the job is waiting on. The first SQL statement will create a small stored…
Read more →
📅 2022-01-01
✍️ Bart Schelstraete
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…
Read more →
📅 2021-12-28
✍️ Bart Schelstraete
If you are using SSMS 17 or 18, you may have noticed that the SSMS startup can be very slow, which is annoying for everyone. There are 2 workarounds which could resolve this issue: Open Internet…
Read more →
📅 2021-10-28
✍️ Bart Schelstraete
The T-SQL code below lists the currently running SQL Agent jobs. SELECT ja.job_id, j.name AS job_name, ja.start_execution_date, ISNULL(last_executed_step_id,0)+1 AS current_executed_step_id,…
Read more →
📅 2021-10-10
✍️ Bart Schelstraete
In case you have a screen with a high resolution, 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…
Read more →
