Duplicates Recipe

In Uncategorised by jayden.macrae

Here is a quick recipe for those of our customers that use Analytique. If you want to check that for duplicate data in your Analytique data stores, you can use …

DBeaver Clutter Reduction

In Uncategorised by jayden.macrae

I love DBeaver. It is a versatile and universal SQL client. There are so many great things about it that I love but of course, first of all it is …

Find Office Space the Spatial Way

In Uncategorised by jayden.macrae

Here at DataCraft we have recently needed to look at finding new office space. There is a reasonable amount of space that we can look at around the city here …

The Windows Virtual Store

In Technical by jayden.macrae

In my view, perhaps better named the virtually crazy store. Read about what the Windows VirtualStore is┬ábut in a nutshell, it is a feature added since Windows 7 that “helps …

Security Fail : The Password Opression

In Commentary by jayden.macrae

It beggers belief that we are still faced with websites today that protects relatively sensitive informaiton that impose maximum password limits! I like using strong passwords. Some times, my passwords …

UX Fail : The Label Illude

In Commentary by jayden.macrae

I love being able to fill in government forms online, rather than have to post them in! Thanks IRD. While undertaking a process for registering an employee today on the …

SQL Structure – Where And Or

In Technical by jayden.macrae

In the last blog post, we looked at the basics of formatting complex SQL statements. We will often use a Where clause to limit the records we return in a …

SQL Structure

In Uncategorised by jayden.macrae

When it comes to structuring SQL code, I’m pretty specific about what I like and why. I tend to follow most normal conventions with a few specific exceptions. The first …