How to concatenate strings with GROUP BY while joining multiple tables in MS SQL SERVER?

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.

TreeSize Free

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.

Jetpack Markdown Replacement

In my blog I’ve been using Jetpack Markdown for years. But lately I had to move the blog to another system and then Jetpack Markdown was no longer available. WordPress says that’s the case because it violates some WordPress guidelines. Strange enough that it didn’t violate any guidelines for years. I assume the brightest of the WordPress developers introduced some new guidelines which made Jetpack Markdown unusable. WELL DONE WORDPRESS DEVELOPERS.

Now I’m trying the Markup Markdown plugin and until now it seems to work. Though I’m not too content. Main disadvantages, which are quite annoying:

  1. It seems not to be possible to preview changes of already published posts.
  2. The editor likes to mark some words or abbreviations in a rosy color.
    image with rosy text

Markdown cheat sheet

What Description Syntax
Headers h1, h2, h3 #, ##, ###
Emphasizing italic, bold *inline*, **bold**
Code inline, block ` <- that's a backtick, ~~~
Links link, image [title](https://www.example.com), ![alt text](abcd.jpg)

VisualStudio 2017 Crashes When Docking a Window

This is terribly annoying. But there are workarounds mentioned on https://developercommunity2.visualstudio.com/t/Unexpected-VS-crash-when-docking-or-spli/1323017:

I tried this one and it helps:

Edit %InstallRoot%\Common7\IDE\devenv.exe.config and %LocalAppData%\Microsoft\VisualStudio\16.0_xxx\devenv.exe.config and append the following text to the element’s value attribute:

;Switch.System.Windows.Interop.MouseInput.OptOutOfMoveToChromedWindowFix=true;
Switch.System.Windows.Interop.MouseInput.DoNotOptOutOfMoveToChromedWindowFix=true

All of this text must be put into one line without spaces in between. The line break in this post is only for readability.

How to move a WordPress Blog

My blog provider has terminated my old hosting platform, he said he cannot support it anymore. So I’ve been forced to move my dear blog to another one. I tried lots and lots of stuff and nothing worked.

 

Until I stumbled over the menu entries Export and Import in the WordPress-Tools menu. I exported my old blog to a xml file and imported it in my new WordPress installation. And voilá, all my posts have been transformed from the old to the new blog.  So easy.

What’s not been transferred by this action where all the settings, plugins, plugins-settings, themes, theme-adaptions and the like.   But that is the least part and I’ll do it manually.