Database on a diet (Part 1)

Hi Folks,

My next article for SQL Server Magazine is out now. I’ve decided that New Year is the time that most people discuss diets and databases don’t have to be an exception.

I’m discussing one large client who had a database that really needed to be trimmed down. That involved a whole range of mechanisms and the outcome was great: major size reduction and significant performance improvement.

I’ve decided to discuss this across a series of articles, each covering part of the story about how the reductions were produced and the rationale for each.

You’ll find part one here now:

Enjoy !

New-Object : Constructor not found. Cannot find an appropriate constructor for type

This one is here so that I don’t forget it in future.

I’ve been writing Powershell again all day today and I spent ages trying to find this error when instantiating a particular object.

Bottom line is that there was a valid constructor that took a single string argument. However, I was passing an empty string to the constructor. Let’s just leave it at “The error message returned is interesting”.

Hope it helps someone else.

Icons and the real world

Just realised that book icons are another one that will probably lose meaning over time. That'll apply to book icons for dictionaries and thesauruses too.



Phone icons are already pretty odd as many kids would never have seen a phone that looks like those icons.



And the Save icons that are a picture of a 3 1/2 inch floppy disk are basically meaningless now.


I had to laugh when I heard a kid who saw a 3 1/2 inch floppy for the first time comment that someone had made "a actual save icon". I suppose that's how it seemed to him.

The open icons are often manilla folders. They still have some life left in them but not much.


There are still some clipboards around but not many.


Video icons that show sprocket holes each side of a film are basically meaningless now.


All the mail, email, mail merge, etc. icons that show letters are fast becoming meaningless. (Ask Australia Post about that) And adhesive labels?

image  image

Even the latest versions of Office (2016) have old style lightbulbs for ideas. That'll quickly be meaningless.


The slideshow icon in PowerPoint is an old style roll-up projector screen. And it's timing icons are all analog clocks (limited lifespan). It's screenshot icons are cameras that very few kids would recognize.

image   image

And so on and so on. I wonder how long it will be before many of the icons that were designed to represent common physical things will lose all their physical equivalence. Does that then make it harder for newcomers to computing to recognize anything?