Author: Protiguous

C# Software Developer, SQL Server DBA, Father, and seeker of Truth.

Scale of Intelligence Levels

God-like – Able to change inputs and outputs Intuitive – Able to predict a sequence of outputs with missing inputs. Intelligent – Able to recognize the pattern of inputs even with missing inputs. Sentient – Able to recognize a sequence of inputs. Algorithmic – Able to activate the correct outputs in the correct sequence for a given input in the correct sequence. Logical – Able to… Continue reading Scale of Intelligence Levels

Fix for the message “Windows is still setting up the class configuration for this device”.

So, the Hyper-V Manager stopped allowing me to open the settings on any virtual machine. It would just stay on “loading…”; the cancel button worked but the properties just would not show up. So, I uninstalled and reinstalled all Hyper-V settings under the Control Panel “Turn Windows features on or off”. No change. The Hyper-V… Continue reading Fix for the message “Windows is still setting up the class configuration for this device”.

How to save some Emergency Drive Space for SQL Server (or other Servers)

Photo by Pixabay on Pexels.com

Running out of disk space on a SQL Server server is something that you should never allow to happen, but it can happen. If you need to be the emergency Fireman putting out the fire, here is a way to “reserve” some drive space ahead of time. It is literally a dummy file that you… Continue reading How to save some Emergency Drive Space for SQL Server (or other Servers)

Faith in God and Science

I’ve tried to say this before, so please be patient with me: Faith in God and Science are not mutually exclusive concepts. Science, as of yet, cannot prove or disprove the existence of any godlike creature. Personally, I don’t believe there is an all-knowing white guy sitting on a throne demanding to be worshiped. What… Continue reading Faith in God and Science

How to update and query an SQL Queue table with multiple consumers

First, create the test table and populate it with some data. The data itself isn’t too important; we just want a table that will be updated while also concurrently be queried and then deleted. Now open a second tab and paste this next query. This one will make random changes to the queue table every… Continue reading How to update and query an SQL Queue table with multiple consumers

My Main Rules For Life

Don’t Lie. Be Kind. Not Yours? Don’t Touch. Always Learn. Leave things better than you found them. These pretty much cover every action I take (or don’t take). I know they’re not “Earth Shattering” or “Complex“. But I believe in their simplicity and earnestness, and I hope that by sharing them I can bring some… Continue reading My Main Rules For Life