If you ever have to batch rotate some videos with a command line tool – or do anything else to some videos with a command line tool, look for ffmpeg.
It seems, they are currently destroying Thunderbird and it might be not long in the future when it is no longer usable well. I’ve been looking for an easy to use and stable mail client where the developers not constantly are changeing stuff just for fun and to annoy end users.
Here some more info about claws in german
It is quite complicated in MS SQL SERVER.
-- Use a Common Table Expression (CTE) to create a temporary table -- which is only valid for this query to join tables. WITH cte AS ( select a.Artikel, a.Name, lb.Menge, lb.Platz from Artikel a JOIN LAGERBELEGUNG lb on a.ARTIKEL = lb.Artikel where a.SACHGRUPPENKLASSE like 'Ven%' and a.Name like '%2016%') -- Use a query with STUFF and FOR XML PATH on the CTE for concatenation select t.Artikel, max(t.Name) Name , stuff( ( select ', ' + Platz from cte where Artikel = t.Artikel for xml path('') ), 1, 1, '') AS Platz from cte t group by t.Artikel
More about FOR XML PATH and STUFF on Stackoverflow, see 1st and 2nd post there.
And more on Sqlshack.
WinDirStat is a tool to find space thieves on drives and I liked it much. But the newest WinDirStat I could find is v 1.1.2 from the year 2005.
And it has got severe problems. It does not work on our Strato-Server which runs Windows Server 2016 Standard. There it hangs, presumably in the servicing/packages directory.
The alternative Spacemonger 1.4.0 of the year 2000 has got the same problem.
WizTree 4.10 x64 does work very well, it is astonishingly fast, even over the servicing/packages directory. But it is not full freeware, it must be paid if you want to use it commercially.
And it has got a very annoying Donate button. I am not against Donate buttons in general. But this one shivers every some time – i hate this.
Now I’m using TreeSize Free.
TreeSize Free is full freeware even for commercial use. It’s quite fast, even over the problematic servicing/packages directory. And it’s got the nice feature that you can filter what it shall scan. So you can e.g. easily search for too big log files.
There are two paid versions of TreeSize with some additional features available also.