Saturday, October 31, 2020

Favorite Windows Screenshot Tool

When on Windows, for taking and making screenshots for technical documentation, I love Greenshot.

Here's an image from their website, showing the UI of the application.

Friday, October 30, 2020

Removing orphans from MSX

From time to time, I try to script a job in MSX. Very often, it fails. 

When it does, I use this query to take a look at the orphans, and then I use the "delete" section to remove the orphan rows from MSX, which allows me to script the job.

This is based on code I found online, but I have lost the source.

select j.[name], *--count(*) 

--delete from js 

FROM msdb.dbo.sysjobservers js

INNER JOIN msdb.dbo.sysjobs j ON j.job_id = js.job_id

LEFT JOIN msdb.dbo.systargetservers ts ON ts.server_id = js.server_id

WHERE ts.server_id IS NULL

Thursday, October 29, 2020

IT is the new Halloween

We have USERS who create things that get KILLED using COMMANDS that are EXECUTED. Within the office, we speak of MASTERS and SLAVES, and of the dark magic that is BINDINGS. In our transportation, we are rich with DRIVERS and CONTAINERS.