Stuff To Do

Which extended stored procedure can be used to find members of a Windows group?
Answer: xp_logininfo
If we run below command, We'll get the members of a windows group:

xp_logininfo 'windows group name','members'


## Show ID and last character of the ID
select id, substr(id, -1, 1)
from products


I find the file explorer file preview pane <ALT-P> really useful, but it doesn’t preview all text file types I’d like it to, for example .config, .log, .dat, .ksh etc

Easy hack in the registry to enable their display in the preview pane…
Under HKEY_CLASSES_ROOT, find your file extension, add a new String Value of PerceivedType with Value text.

That’s it. Just works

This was very handy! - yum whatprovides