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 …