Anyone unpacking the Unifi Cloud Key Gen 2 Plus for the first time will notice that the device does not come with a power cable or power adapter and cannot be used with all USB chargers. I'll show you which power supplies and cables really work.
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.
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.
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.
If you want to start HRFORMS in payroll accounting after a patch or release upgrade, you may experience the following error as soon as you call up the print output of the remuneration statement.
Runtime error OBJECTS_OBJREF_NOT_ASSIGNED
Anyone who uses surveillance cameras in outdoor areas knows the problem: Especially in spring and autumn, the lenses of the cameras are occupied by spiders and spider webs are limiting visibility.
You can now either clean the cameras every week or use a spraying agent that effectively keeps spiders away from the cameras. A product from the water sports sector, actually intended for the high masts of sailing yachts, is perfect and much cheaper than the same products especially for cameras.