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 …

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 …

Psake Builds

In Technical by jayden.macrae

For a while now I’ve been tearing my hair out (and I can little afford that these days) about a whole lot of inconsistencies in the build pipeline using msbuild. …