Summary of performance We have assessed the failure rate of each check-digit scheme for both single character substitutions and two-character transpositions. The below table summarises the performance of fives schemes. …
Check-Digit Collisions in the New NHI Implementation
The new NHI format has been implemented to further extend the NHI range as we were previously running out of NHIs. The new format is: AAA00AA Where A is an …
New National Covid-19 Dashboard
DataCraft Analytics has created a new dashboard to display the case rates of Covid-19 across New Zealand. With this dashboard you can monitor the latest cases, see where they are …
Comparing Character Fields in SQL T-SQL
There are times when you may be inserting data from one table to another and you get the message: String or binary data would be truncated This is often because …
Improve Thalamus Security
The recent headlines related to Waikato DHB IT woes has prompted us to remind all our customers about enabling multi-factor authentication for Thalamus as well as other sources where access should be protected. …
New Thalamus Filter Feature
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 …
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 …
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 …
- Page 1 of 2
- 1
- 2