Sometimes business wants a column in several rows concatenated to one string list. I found this gem: Still working on it, but here’s my cleaner code for better readabity: ;with basetable as ( SELECT id, CAST(name as varchar(max)) name, ROW_NUMBER() OVER(Partition By id order by countRecords) rowNumber, COUNT(*) OVER (Partition By id) countRecords FROM […]

Use them a lot lately, so here they are in one place: # vim echo ‘” paste-mode from external programm set pastetoggle=<F2> ” displayed tab width set tabstop=4 ” indent tab width set shiftwidth=4 ” color scheme desert for nice 256 colors colorscheme desert’ >> /etc/vim/vimrc.local # screen echo “altscreen on caption always ‘%{= dg} […]

If you want to just disable that one shortcut, then simply execute these 2 lines: mkdir -p ~/.config/xfce4/terminal echo ‘(gtk_accel_path “<Actions>/terminal-window/contents” “”)’ >> ~/.config/xfce4/terminal/accels.scm Close all instances of xfce4-terminal to apply the change. Full story: xfce4-terminal opens its help when pressing F1. The process to change that is *censored* – see here: What […]

The tool “ARandR” lets you position your screens nicely. But you cannot assign a primary monitor – the one where the panels and menus should be on. This can be resolved by adding setting the “output-name” property of the panels. Either do it in the “Settings Editor” or from CLI with: xfconf-query -c xfce4-panel -p […]

This is what I always append to /etc/screenrc: altscreen on caption always ‘%{= dg} %H %{G}| %{B}%l %{G}|%=%?%{d}%-w%?%{r}(%{d}%n %t%? {%u} %?%{r})%{d}%?%+w%?%=%{G}| %{B}%M %d %c:%s ‘

How the hell did this happen … Shall I or not … oh well … My new laptop has an Atheros AR8161 ethernet device, which needs an alx kernel module. That’s how it started some months ago. Found out that the alx module is part of compat-wireless, which was only available from the Pentoo overlay. […]

When coding around with the pentoo-installer in virtual machines, grub simply refused to detect the virtual device mounted on /dev/vda. The solution was in this article: # grub > device (hd0) /dev/vda > root (hd0,0) > setup (hd0) > quit Also put this in /boot/grub/ (hd0) /dev/vda