October 2026 – Page 3 – WebCheatSheet

SQL

Fix Node.js SQL Server Named Instance Timeouts

Connect Node.js to SQL Server through a known TCP port, then separate connection timeouts from stored-procedure execution timeouts.

Use the Bitbucket username in the HTTPS remote, enter a scoped API token as the password, and keep the token out of the remote URL.

Keep menu state in a CSS class, update aria-expanded from the resulting state, and avoid one-time inline-style comparisons.

PHP

Use a bounded queue worker from cron when shared hosting does not provide Supervisor, and log the command before debugging Laravel.

Restore the standard gtag wrapper, verify command order and the measurement ID, then confirm a collection request and DebugView event.

Handle the contextmenu event, position an HTML menu inside the viewport, and provide an equivalent keyboard-accessible control.

PHP

Trace Apache authorization decisions across virtual hosts, .htaccess files, proxy addresses, and multiple backend nodes.

SQL

Add WITH GRANT OPTION only at the intended privilege scope, then verify the stored result with SHOW GRANTS.

SQL

Measure database role transitions with Always On events and separately measure the client-visible outage through the listener.

Set a real data attribute on the element and match its exact serialized value with a CSS attribute selector.