20Mar
Excel Template T Accounts with Manual and Automatic Balance for debit and credit
Excel template for T-accounts with and without automatic balance creation on two sheets. The template
Author: megaadmin
20Mar
Creating SQL Statements with Excel (Quick and Dirty)
Sometimes, you have to import predefined data supplied as a list, such as personnel numbers, into a database and at the same time provide it with additional (default) values. Creating each statement manually would be very time-consuming, especially for large amounts of data. The function "concatenate" in Excel helps a lot.
20Mar
Import contents of a CSV file into an existing table via SQL (Bulk Operation)
Script to import data from a CSV file into an existing MS-SQL table via bulk operation. Creation of a temporary table, import, transfer to productive table. The assignment of the data to the correct keys takes place via an inner join.
20Mar
Remote support via TeamViewer without active Windows login ends in “this screen cannot be captured at the moment This is due to to fast user switching or a disconnected/minimized remote desktop session”
If you want to access your server with installed TeamViewer Host via TeamViewer with full access rights, you might know the following problem: The user only expects a black screen and the message "this screen cannot be captured at the moment. This is due to to fast user switching or a disconnected/minimized remote desktop session". You might think the solution to this problem is in the TeamViewer settings. Most of the time far from it. The solution is to distinguish between the server ID and the user ID of the running TeamViewer.
20Mar
The Best Home Remedy Against Bursitis
"Now he is completely gone crazy" you will think, because now he starts to write about diseases. Don't worry this will be the only blog post on health topics. But maybe one or the other will stumble over this post while googling and save his vacation. That's why I don't want to keep my tip to myself.
20Mar
Colour codes of the German flag – RGB, CMYK, HSV, RAL, Pantone
For my work as a graphic designer I often need exact colour specifications for printing or online publication.
Yesterday a task led me to find out the exact colour codes for the German flag. I found surprisingly little about it on the Internet.
