General

Happy new year from SQL Down Under and from me

Happy new year from SQL Down Under and from me

Hi Folks,

Just a short note today to wish everyone a happy new year. I know that new year is a time when many people make resolutions, with the intention of changing something about themselves during the upcoming year. It makes it a time full of hope for fresh starts.

I don’t tend to make too many resolutions as I think that needs to happen on an ongoing basis rather than once per year, but I understand why people do.

2019-01-01

Happy Christmas period to all my readers

Happy Christmas period to all my readers

Hi folks,

It’s been a big year again and the number of readers just keeps increasing quite fast. So pleased to have you all here. You make it all worthwhile. Thanks to so many who reached out during the year.

Just wanted to wish you all the best for the holiday and Christmas season, from here down under.

Greg

2018-12-25

Never lose hope - it's all around you

Never lose hope - it's all around you

It’s that time of year again when people look philosophically back at the current year, and start to think about how they’ll improve their situation in the new year. But for many, this is a very hard time of the year.

I’ve had a few friends this year who seem to have almost lost hope when they’ve ended up in poor situations.

I just wanted to make a short post to encourage you all to never lose hope. Alexander Pope said:

2018-12-18

Opinion: Get used to reading traces and logs before you need them

Opinion: Get used to reading traces and logs before you need them

I used to do a lot of work at the operating system and network level. I was always fascinated watching people use network trace tools when they were trying to debug a problem. The challenge was that they had no idea what was normal activity on the network, and what wasn’t.

The end result of this is that they’d then spend huge amounts of time chasing down what were really just red herrings.

2018-12-11

Using the classic editor in WordPress 5.0

Using the classic editor in WordPress 5.0

Well today WordPress on my blog site went up to version 5.0. I knew a new editor (Gutenberg) had been coming to replace the classic editor but I hadn’t had time to try it. So when it did the upgrade, I happily let it go and install the new editor.

Then I tried to write a post.

Oh my goodness, that was just a horrid, horrid experience. I can see what they’ve tried to do but it literally took me about five times longer than normal to write a single post.

2018-12-07

Opinion: Case sensitivity is a pox on computing

Opinion: Case sensitivity is a pox on computing

I’ve been in the IT industry a long, long time. One thing that I’ve never liked is case sensitivity in application development tools or in database languages.  And it’s creeping into more and more places.

I know that will offend some people but hear me out.

I think we’re stuck with case sensitivity in languages like C, C#, C++, Java, etc. because that was the easiest way to implement those languages in the first place. As soon as you decide that a language is case insensitive, you also have to decide the internal collation rules. For example, is the letter A the same as the letter a ? But then what about the letter á ?

2018-12-04

Opinion: Over-dependence on geolocation is a pest

Opinion: Over-dependence on geolocation is a pest

One of the real beauties of the Internet is its global nature. But ever since we’ve had it, people keep trying to ring-fence certain locations, and make applications location-aware. While geolocation can be useful, over-dependence upon it is a real pain in the neck.

The first situation where this is painful is in media restrictions. Companies are still trying to enforce country and region boundaries for media licensing.

We need to get past this.

2018-11-27

Opinion: Banks and Councils cause potential identity theft problems

Opinion: Banks and Councils cause potential identity theft problems

Banks, Councils, and Government Departments are often lecturing customers about protecting against identity theft, yet they often a indirect potential cause of that threat.

Sending to Old Addresses

This one really frustrates me. When we change the postal address for one of our accounts, they almost always send a letter to our old street address. I can imagine why they think that’s a sensible idea, but if we’ve already left that address, what they are doing is sending our private details to whoever now occupies the house.

2018-11-20

Opinion: Corporate Compliance Isn't Training

Opinion: Corporate Compliance Isn't Training

I spend a lot of time mentoring on client sites, and many of the clients are large organizations. Often these organizations require me to attend “training” on a regular basis, to satisfy their corporate compliance goals.

I don’t mind doing this at all, even though the course on conflicts of interest, or handling private or sensitive data, at company A is invariably almost word for word the equivalent course that I do at company B, and company C.

2018-11-13

Basic Photo Viewer in Windows 10 - Where have you been?

Basic Photo Viewer in Windows 10 - Where have you been?

I teach SQL Server, BI, Azure, and AI classes on a fairly regular basis, and one thing I love to do is to show attendees images (or photos) of where the application of the technology has gone very right or very wrong. Ever since I’d installed Windows 10 though, that became much harder.

The Photos app that’s installed with Windows 10 must have someone who loves it, but that’s not me. There seems to be no way to just have it automatically maximize the images, so I’m always showing them, then having to resize them.

2018-11-09