New Windows installation done. Coffee ready. And suddenly my WD EX2 NAS decided to pretend it did not know me at all.
PS1 Cannot Be Loaded Because Running Scripts Is Disabled
PS1 cannot be loaded because PowerShell’s execution policy blocks scripts by default. You can set RemoteSigned, bypass the policy for one session, or choose Unrestricted as a last resort. Here is each option, and the scope to check.
Install MongoDB on Windows: SQL in Sixty Seconds #091
To install MongoDB on Windows you need two downloads, the server and the shell. This post walks through the MongoDB 9 setup, then proves the install with real mongosh output: the version, a ping, one inserted document and a clean drop. It ends with the common first-run problems and the safe defaults to keep.
Windows Path Variable: Run oStress From Any Folder
The Windows Path variable is a list of folders that Windows searches when you type a program name. This post shows how to test a change in one window, add a folder for good and check that it works. It uses oStress and sqlcmd as the examples and ends with rules for a clean Path.
Always On Listener Creation Failure: Enabling Object Failed With Error 5
A listener creation failure with error 5 means access was denied, and the cluster log shows who was denied. Here the cluster computer object could not enable the listener object. A domain admin gave it Full Control, and the listener came online.
How to Measure Transactions Per Seconds in SQL Server? – Interview Question of the Week #262
Question: How to Measure Transactions Per Seconds in SQL Server?
I have updated the script for this for Comprehensive Database Performance Health Check.
Provisioning Computer Object Failed With Error 5: Always On Listener Failure
Provisioning computer object failed with error 5 is a cause of Always On listener creation failure. The cluster log showed the cluster computer object being denied access while changing the listener’s password. Giving the CNO Full Control over the listener object fixes it.