Two useful links from google photos you might not know
Unsaved creations
https://photos.google.com/unsaved
Possibly all creations?
Posts in category “Tips”
MySQL IF(EXPRESSION, A, B) equivalent in PL/SQL (Oracle)
In MySQL, we can
SELECT IF(A IS NULL, "something", A) FROM some_table;
If you want to do a similar thing in PL/SQL, you need to
SELECT (CASE WHEN A IS NULL THEN "something" ELSE A END) FROM some_table;
If you want to get the first non-null value from several fields, you have a better choice than using the CASE keyword.
SELECT COALESCE(A, B) FROM some_table
see more information about the Oracle COALESCE function
Quickest fix: Windows - Taskbar Has Disappeared from the Desktop
- Press Alt + Ctrl + Del => choose Task Manager
- find the Windows explorer process,
- Restart it.
PS: If you use a remote desktop, Press Alt + Ctrl + End instead. It's actually not a fix; it's only a workaround. Anyway, we cannot expect there to be a perfect fix for that. Microsft just sucks.
Set bash terminal integration with Visual Studio 2019
Solution for Slow logon via Remote Desktop to Server 2012: Disable the Large Send Offload
Recently, I found it became very slow when I am logging onto my development VM, a windows server 2012R2 instance through Remote Desktop. There are many kinds of solutions in Google's search results. I tried many of them and found only this one suits me.
On the Windows Server 2012 machine, disable the Large Send Offload via the following steps:
Open Network Connections.
Click Change adapter settings
Right-click the icon of the Network card and select Properties.
In Networking tab, click Configure… button.
In the next window, switch to Advanced tab.
Click the Large Send Offload Version 2 (IPv4) and change the value to Disabled.
Click the Large Send Offload Version 2 (IPv6) and change the value to Disabled.
Your RDP connection will disconnect right away after you apply the change. Don't worry, connect it back and you will find the annoying delay disappears!