New Windows installation done. Coffee ready. And suddenly my WD EX2 NAS decided to pretend it did not know me at all.
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.
SQL SERVER – Always On Listener Creation Failure – Enabling Object ProdListener Failed With Error 5
I have written a few blogs where I explained a few issues about the failure of listener creation failure in a cluster. Let us learn about it.
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.
SQL SERVER – Always On Listener Failure – Provisioning Computer Object Failed With Error 5
I have written a few blogs on issues about the failure of listener creation in the cluster. In this blog, we will explore listener creation failure.
Task Manager Update Speed: Why the CPU Graph Looks Stuck
Task Manager update speed controls how often the CPU graph moves. When it is set to Paused, the graph freezes and a normal server can look like it has a CPU problem. This post shows the fix and a five second test in T-SQL that tells you whether the graph is alive.