Friday, 6 December 2019

Release Notes 2019-12-07

*** Arnold Gym Management Release Notes ***

Another busy week at Stingrae, with the following minor changes to our popular martial arts school management system:

* Redesign of Member Home Screen so that you can see almost everything at once
* Improved Popup screen for Contacts (previously had display issues on Edge)
* Sections for Notes, Gradings & Classes now stay open when you click on them
* New section to view Competitions for Members
* Fixed Layout issues on Account Sale
* Fixed bug with business logo on Member Portal

Saturday, 16 November 2019

Competitions & Incidents

Been a busy time at Stingrae over the past week or so ...

We've just put out a new version of Arnold Martial Arts and Gym Management. Along with a few minor bug fixes, there are now two new menu options:

1. Competitions - Record how your students go in martial arts or dance comps.
2. Incidents - Ensure that any accidents or problems are properly recorded.

One final note on the Competitions - your gym members can enter them them-self via the member portal area!

Wednesday, 2 October 2019

*** New Report ***

Happy to announce a new report - a simple Outstanding Debtors report. Quickly see who owes you money in one click.

Check it out now at 

Saturday, 14 September 2019

Video Overview of Arnold Martial Arts Gym Management Software!

I just spent 2 hours recording this 5 minute video overview ... I kept either saying the wrong thing, or clicking the wrong link or seeing that I hadn't masked some data ... not to mention the noisy kids playing nearby that kept interrupting ..!

Anyway, here it is!

Thursday, 5 September 2019


Yes ... Arnold has had a Face-lift ..!!!

What do you think?

If you run a martial arts dojo, dance studio or small gym ... then visit and sign up for a FREE Trial!

Sunday, 21 July 2019

New Version of Arnold!

Over 20 years ago I started writing a CRM product for a friend's martial arts club. I think I wrote it with VB5 and a csv file back-end.

From there, as I progressed in my professional IT career (as well as building my own martial arts school), I've continued to develop the CRM, now named Arnold (nothing to do with the Terminator btw).

I'm so proud of where it is now. As of now, it is the newest commercial martial arts software package available for commercial use.

I've spent the past 6 months of weekends & nights converting it from a .Net Windows Application to a .Net Web Application, with the back-end hosted on a Microsoft Azure SQL Server Database.

And to compliment the main web application, users and businesses can also download the App from the Play Store or App Store (Android / iOS). The App provides businesses with a professional check-in display at reception, and communication from the system to members' phones via push notifications.

This is my passion project and one which I work on to continually develop new skills.

If you, or any martial arts, dance or yoga business you can think of could benefit ... please direct them to the sales website which can be found here:

Cheers ... and Oss!!!  😄

Monday, 15 April 2019

SQL Server Database Chackup

Just like you take your car to the mechanic. 

And you should visit the doctor for a regular checkup ...

If your #SQL #Server #database hasn't had a checkup in a while, then it's probably a good idea to do one! 

I am just finishing a large contract in the Sydney CBD and will soon be available to businesses in the #Sutherland #Shire again to look at their systems and offer suggestions of how they can run quicker! 

Contact me now via this website:

Thursday, 7 February 2019

New Feature for my Reception & Check-In App

A new feature to the app I developed for Martial Arts Gyms.

It can be used to remind members to collect something they've left behind, or that they need to update their credit card number etc ...

It's different to the existing Push Notifications feature because this alert only notifies them when they're actually IN the gym and can take action immediately.

For a FREE meeting and quote, go to .

We can come to you, or you can come visit Lisa or I in Caringbah.


ps. a hidden gem in this video is why Fred is the perfect name for a test user ... hehehe

Monday, 28 January 2019

Is Data the World's Most Precious Resource?

The James Bond film Quantum of Solace discussed that water is the world's most precious resource …!

Interesting to see that Data is now number two then!

#data #databases #sql

Tuesday, 22 January 2019

To Page 1 of Google in 48 hours!

For those who read this blog and don’t know … I also own a Martial Arts business ( if you’re interested).

About 8 years ago it was growing rapidly, with new students turning up every week … mostly due to a google search.

I then moved into a larger premises … with more overheads … and then something strange happened. The leads stopped … there were some new schools in the area and they were getting the new leads. And i must admit I was slow to figure out why (becoming a father for the first time being one of the reasons I dropped the ball).

Finally, I decided to do a search on Google for what I assumed was the most common search phrase for my business, I was shocked to find that I was on page 2 of the results … how could this be? There were only 3 or 4 gyms in the same area with what I offered!

I had to figure it out … so I went back to study and learned how to rank in Google. I watched videos, and read books. And in one those I found the most useful information. It was a tiny book too .. only about 100 pages and cost less than $20.

But what it contained was gold … I completely re-did the website, and followed the other instructions. Within 3 months I was back, and not just on Page 1, but either ranking 1 or 2 depending on the actual words entered into Google.

Fast forward to today, and my gym runs itself which allows me to focus on my IT business. With my new focus now on SQL Server, I have to make sure that “sql server expert sydney” ranks high.

No word of a lie … it has taken me 48 hours to go from Page 3, to Page 1 for this search phrase. And without spending any money!

If you want me to help with your business’ #SEO then contact me at … but here’s a FREE tip .. Google is a #database. Yes, it’s bloody huge, but a database is a database. And not many people in Sydney know more about databases than I do …  😉
Here is the "before" image, where the phrase is on Page 3
And now here is the "after" on Page 1, about half-way down. Soon it'll be #1, you watch!

Tuesday, 15 January 2019

How to be Big Brother in Microsoft SQL Server!!!

A few years ago I was working as a SQL Developer at a large company in Sydney’s CBD. Although an established business, the environment was relaxed and based on many of the “start-up” type businesses which you see around today. For example the office was filled with comfortable lounge chairs and TVs everywhere, plus an on-site barista and cafe.

Of the roughly 120 staff in the Sydney office, over 100 would have been in IT, with probably 20 teams spread across everything from mobile web and app development, to myself in the database team and 3 or 4 full-time SQL DBAs.

As one of only a handful of people who had access to the production SQL environment, and the ability to view and change the production data, I would often get tickets in regards to importing or exporting data.

One day a request came in for me to import some data from Excel, and then use it to update some records.

To assist with this, I used the SQL Server Import And Export Wizard to import this data from Excel into a new table.

Within minutes of me doing this, my phone rang. It was the senior DBA. Ie, the man who all the database programmers and DBAs reported to.

His question was simple … “why did you just create a new table on a production database?”.

Even though I had all the boxes ticked from the testing team, and another senior manager (for which this task required) ... for whatever reason he didn’t see the authorisation and wanted to know what I was doing. When I explained it to him, he approved it and had no issue with what I was doing. But … it got me thinking … how did he know?

Not long after, I’m at a smaller company and am THE DBA when I notice that a .net programmer had snuck in some DDL changes into a release script. Once released into production, it caused some issues that did not appear in UAT. It was a lesson for me in that I needed to performance test the changes that came through via the developers.

As it was a smaller company (especially in terms of IT resources), I now wanted to keep more of an eye on what the .Net programmers were doing. And it reminded me of what happened to me earlier at my previous role - how did my boss know I made DDL changes almost immediately?

I soon discovered that you can setup what is known as Server Triggers.

There are many examples on sites such as stack overflow on how to set these up, so I won’t bother with typing the exact steps. But in short all you do is enable SQL Mail, and then create Server Triggers which are fired from the system tables. From the event which is fired, call a stored procedure which then writes the changes to an audit log (along with who did it, assuming you're using Windows Authentication) and also sends you an email.

Simply do this on whichever SQL Instance you wish to monitor and you too can play Big Brother and keep an eye on any cowboy developers! Personally, from now on I always do this on all UAT and Production instances. Often the Dev instances have too many changes made and I feel that if I get too many emails coming through saying “DDL change” then they become lost in my inbox of other alerts. But when I get one saying change(s) in UAT or production, then I can investigate … and if necessary get out the proverbial big stick!

Thursday, 10 January 2019

Database Example - How Qantas is going to know your every move ... with your permission!

Want to collect your customers' data?

Qantas is paying in Frequent Flyer Points to find out more about you.

With this #App, you earn points by telling Qantas what you do, and where you go!

(Not saying it's ethical, but the lawyers have made it permissible)

Wednesday, 9 January 2019

Friday, 4 January 2019

Brad Sugars explains this so well ...!

This 3 minute video is the perfect example of how the combination of a #database, and mobile #app, are required for all #businesses in 2019.

At I type this, I'll be at our HQ in #Caringbah until 4pm, so if you want to come in for a chat, please do!