Big Sur – Unity Bug

Quick fix for big sur.

sed -i 's/Mac OS X (10/Mac OS X (1\./g' UnityLoader.js

1	sed -i 's/Mac OS X (10/Mac OS X (1\./g' UnityLoader.js

Employee Retention Strategy for IT Firms

A steady increase in the global employee turnover rate is becoming an issue of utmost concern to employers, human resource managers and associated experts. More threatening is the fact that employee retention poses to be highly difficult in the IT industry which has grown to become the focus or core of every innovation across all[…]

TSQL – Equivalent of On Update CURRENT_TIMESTAMP(MYSQL)

Requires a trigger in MS-SQL to achieve the same behaviour. Update a timestamp only when a field changes (colTest).

CREATE TRIGGER <triggerName> ON <table>
FOR UPDATE
AS
BEGIN

SET NOCOUNT ON;
IF UPDATE (colTest)
BEGIN
UPDATE <table>
SET <field> = GETDATE(),colPersistent =I.colTest

FROM <table> S
INNER JOIN Inserted I ON S.id = I.id
WHERE I.colTest<> S.colPersistent
end
END
GO

CREATE TRIGGER <triggerName> ON <table>

FOR UPDATE

BEGIN

SET NOCOUNT ON;

IF UPDATE (colTest)

BEGIN

UPDATE <table>

SET <field> = GETDATE(),colPersistent =I.colTest

FROM <table> S

INNER JOIN Inserted I ON S.id = I.id

WHERE I.colTest<> S.colPersistent

end

END

A persistent field is required as S.colTest is NULL as this trigger is executed.

Intellectual Property (IP) Protection

Intellectual property (IP) refers to invented works, designs, models, symbols, names, images, and any asset of commercial or social value which are mostly creations of the mind and unique in nature. IP are mostly of inestimable commercial value especially at the point of conception and that is why inventors or innovators need proper protection for[…]

Slow one drive on windows

Open a Run dialog by pressing Windows key and R. Copy this and paste it into the dialog window then press OK %localappdata%\Microsoft\OneDrive\onedrive.exe /reset If you see a “Windows cannot find…” message, copy and paste this instead, then press OK. C:\Program Files (x86)\Microsoft OneDrive\onedrive.exe /reset Manually restart OneDrive by going to Start , type OneDrive in the search box, and then click on the OneDrive desktop[…]

Room Temperature – Quantum Machines

Could this be the thing that reduces errors in Quantum to make them ubiquitous? If its true, then this could lead to some great things!

Jupyter Notebook – Denied Launch in Opera

Redirects from html files fail in the Opera web browser. You can disable them by adding a redirect parameter in a Jupyter user configuration file.

c.NotebookApp.use_redirect_file = False

1	c.NotebookApp.use_redirect_file = False

If you dont have a config file it can be generated like below. Search and then uncomment the var.

jupyter notebook --generate-config
vi ~/.jupyter/jupyter_notebook_config.py

1 2	jupyter notebook --generate-config vi ~/.jupyter/jupyter_notebook_config.py

Debian Linux – Install VMware Tools

apt update
apt install linux-source
apt install open-vm-tools-desktop

apt update

apt install linux-source

apt install open-vm-tools-desktop

Slow Onedrive – Mac

Prior to this, I was seeing 1 file per 5 seconds! If you’re suffering from a super slow onedrive sync on a mac, then these steps might help. Note this worked in June 2020.. Quit OneDrive. (Select the cloud icon in the top tray, then select Settings > Quit OneDrive.) Find OneDrive in your Applications folder. Right-click OneDrive and select Show Package Contents. Browse to[…]

Offline Linux Package Install

for debian systems. Ubuntu 18.04 1. Download The packages On an internet connected system, download the packages you need.

apt-get install --download-only <package-name>

1	apt-get install --download-only <package-name>

If you already have the package installed locally, you will need to add the –reinstall flag

apt-get install --download-only <package-name> --reinstall

1	apt-get install --download-only <package-name> --reinstall

2. Copy to the target system The download-only options, puts the package and dependencies into

>/var/cache/apt/archives

1	>/var/cache/apt/archives

Download the[…]