Do you need to look at a report once a month? Is it a hassle for you to go through the motions to get the right configurations and metrics every …
Report Documentation Feature
We have rolled out a new feature for reports.
When you open a report look in the…
Duplicates Recipe
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
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
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 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 …
Manawatu Gorge Closure : The Health Service Effect
The recent high profile closure of the Manawatu Gorge, yet again, has raised serious concerns in the Manawatu region; mainly around economics but increasingly about access to health services. The …
Investigating GP Presentations of Respiratory Illness in Children
Its very exciting that a research team in which we work have another academic paper published using our Natural Language Processing approach to unlock the power of clinical narrative. Our …
SQL Structure – Where And Or
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
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 …