Dream of Peace

I had a dream… A dream last night.
I saw the world in a different light.
A place to live without despair.
Where men can breathe a clearer air.

A joy like this, I’ve never known.
It filled my heart and filled my soul.

And the dream of peace lives on..
And the dream of peace lives on!

Protiguous, 2021
Note: This song may be from my childhood, but I have been unable to find it again.

Scale of Intelligence Levels

  1. God-like – Able to change inputs and outputs
  2. Intuitive – Able to predict a sequence of outputs with missing inputs.
  3. Intelligent – Able to recognize the pattern of inputs even with missing inputs.
  4. Sentient – Able to recognize a sequence of inputs.
  5. Algorithmic – Able to activate the correct outputs in the correct sequence for a given input in the correct sequence.
  6. Logical – Able to activate the correct outputs for a given input.
  7. Moron – Unable to activate the correct outputs in the correct sequence for a given input.
  8. Idiot – Unable to activate the correct outputs for a given input.
  9. Alive – Able to respond to inputs.
  10. Lifeforms – Able to modify the inputs and create outputs.
  11. Exists – Has inputs and outputs.
  12. Nonexistent – Has zero inputs and outputs.

Examples:

  1. God-like – God, Q, etc..
  2. Intuitive – Any smart woman, mothers, grandmas..
  3. Intelligent – Any above average human.
  4. Sentient – Common household pets: dogs, cats, etc..
  5. Algorithmic – Computers, smartphones, etc..
  6. Logical – calculators? complex machines?
  7. Moron – G.W.B.
  8. Idiot – D.J.T.
  9. Alive – animals, insects
  10. Lifeforms – bacteria, viruses
  11. Exists – I dunno.. sand, rocks maybe? Heheh.
  12. Nonexistent – Nothing unreal exists, according to Spock.

Just some things I was thinking about one day.
Decided to post it to get any constructive feedback.
FYI, this scale is not fully fleshed out or set in stone.
Also, some things can belong to multiple descriptions. 🙂

From my old blog, http://ai-brain.blogspot.com/2012/12/scale-of-intelligence-levels.html

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 settings still would not load.

So, I checked the device manager. There was a yellow flag alert under one of the WiFi adapters with the message, “Windows is still setting up the class configuration for this device.”.

Okay? Sounds like the network subsystem for Windows got borked. <insert high-tech-sounding cause here>

Tried a disable/enable. No change.

So, I did a network reset. “Settings”, “Networks”, “Status”, scroll down to “Network Reset”.

Rebooted. Everything in Hyper-V works now.. You’d think there would be a more robust system for a feature many people use, right?

How to save some Emergency Drive Space for SQL Server

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 an 8GB “dummy” file that you can delete at any time without worry – nothing is using the file. Just SHIFT+DELETE it so it doesn’t fill up the Recycle Bin.

fsutil.exe file createnew "Emergency Disk Space (safe to delete).$$$" 8589934592

This will create an 8GB temporary file in the current folder. Adjust the size to suit your future needs.

When you need to reclaim the disk space, simply select the file and shift+delete (no need to send it to the Recycle Bin).

Here’s the gist if you don’t feel like copy & pasting.

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 I do feel is, is there are Beings of immense knowledge, wisdom, and compassion that have evolved from their lower lifeforms into what they’ve become.

Who knows, maybe we are our own “gods”? Maybe, if we can survive long enough and learn how the Universe operates, then we can become our own godlike immortal beings with souls.

I firmly believe in the existence of our souls. I believe they exist in an extremely higher dimension than our limited 3D+time dimensions.

I believe our souls interact with and are affected by the quantum realm through the mind. A two-way communication as it were..

What do you think? What are your thoughts on this idea?

How to create unsigned data types in SQL Server

Script to create unsigned data types in SQL Server.

USE [Numbers]
GO

DROP TYPE if exists [dbo].[UInt16];
DROP TYPE if exists [dbo].[UInt32];
DROP TYPE if exists [dbo].[UInt64];
DROP TYPE if exists [dbo].[UFloat];
DROP TYPE if exists [dbo].[UReal];
DROP TYPE if exists [dbo].[ZeroToOne];
GO

DROP RULE if exists [dbo].[UInt16];
DROP RULE if exists [dbo].[UInt32];
DROP RULE if exists [dbo].[UInt64];
DROP RULE if exists [dbo].[UFloat];
DROP RULE if exists [dbo].[UReal];
DROP RULE if exists [dbo].[ZeroToOne];
GO

CREATE TYPE dbo.[UInt16] FROM smallint NULL;
CREATE TYPE dbo.[UInt32] FROM int NULL;
CREATE TYPE dbo.[UInt64] FROM bigint NULL;
CREATE TYPE dbo.[UFloat] FROM float NULL;
CREATE TYPE dbo.[UReal] FROM real NULL;
CREATE TYPE dbo.[ZeroToOne] FROM float NOT NULL;
GO

CREATE RULE dbo.UInt16 AS @value >= 0;
GO
CREATE RULE dbo.UInt32 AS @value >= 0;
GO
CREATE RULE dbo.UInt64 AS @value >= 0;
GO
CREATE RULE dbo.UFloat AS @value >= 0;
GO
CREATE RULE dbo.UReal AS @value >= 0;
GO
CREATE RULE dbo.ZeroToOne AS @value between 0.0 and 1.0;
GO

List Cached Data Per Object in Memory

select
	(count(*) * 8) / 1024 as [MB Used],
	object_schema_name( obj.[object_id] ) [Schema Name],
    obj.[name] [tablename],
	obj.[index_id]
from sys.dm_os_buffer_descriptors bd
join (
	select
		object_name( p.[object_id] ) [name],
		p.[index_id],
		au.[allocation_unit_id],
		p.[object_id]
	from sys.allocation_units au
	join sys.partitions p on ( au.[container_id] = p.[hobt_id] and ( au.[type] = 1 or au.[type] = 3 ) )
		or ( au.[container_id] = p.[partition_id] and au.[type] = 2 )
    ) obj on bd.[allocation_unit_id] = obj.[allocation_unit_id]
where bd.[database_id] = db_id()
group by object_schema_name( obj.[object_id] ), [name], [index_id]
order by [MB Used] desc