Hi, I’m Craig Bailey and this is my personal blog where I write about technology, business systems, HubSpot and general life experiences. You can read my posts here.

(If you are looking for the Content is King post by Bill Gates it is here)

I’m involved with three agencies in Sydney:

  • The first is XEN Systems. We help government departments and mid-large B2B technology companies with their sales and marketing strategy, including implementation and training in HubSpot 
  • The second is XEN Create. We provide premium graphic design services to companies, with a focus on using the latest AI tools, including Midjourney
  • The third is XEN Solar, where we help high quality solar companies (dealers, installers) with their sales and marketing processes.

I also co-host HubShots, the podcast and YouTube show focussed on getting the most out of HubSpot. We are the creators of the HubShots Framework.

Craig Bailey presenting

Latest stories

STREXTRACT()

S

I’m almost too embarassed to mention this… I found a VFP function STREXTRACT() for extracting text from a string. Yep, I have the following code all over the place: nStart = AT(‘Starting text’, cString) nEnd = AT(‘End text’, cString) cSubString = SUBSTR(cString, nStart, nEnd – nStart) which can now be replaced with: cSubString = STREXTRACT(cString...

Moving back end rules to the middle tier

M

Traditionally I have been putting a lot of the admin business logic (eg auditing, recent changes logs) in the back end, but I’m wondering if I should be moving it to the middle tier.   Let me give you a simple example. In SQL I log the last change to a record in a field using an update trigger that checks SUSER_SNAME(). Previously (read client-server projects) this was fine. But...

Too much doing not enough finishing

T

The usual problem – why can’t people finish projects?   At work we do so much great stuff: clever design, efficient development, reasonable testing, but then we drop the ball when it comes to managing the client. A client rang me to say they were disappointed with one of the projects we did recently – it was all going fantastically until the final release. It wasn’t...

Steve Vai concert

S

Steve Vai played Sydney last night. Awesome show. This is the third time I’ve seen him in Sydney. Billy was on bass, Tony MacAlpine on guitars/keyboards, Dave on guitars and Jeremy on drums. Tight band. Nice show. Come back anytime Steve.

The Power of Balance

T

During my holidays I had a chance to read a few books. Some were on time management (eg Brian Tracy books) and others were on Alexander Technique (I’ve been taking lessons to help with my back problems – yep those long hours in front of a monitor take their toll if you don’t look after your posture).   Anyway, the interesting thing is that time management books focus on...

OzFox 2004

O

OzFox 2004 preparation   I’ve been doing some more organising for OzFox this last week after returning from holidays. Things are coming along nicely. Now that the admin stuff is mostly sorted I am starting to organise the fun stuff eg the Sydney tourist attractions for our overseas visitors, conference dinners, bonus talks etc. I am really looking forward to this conference. It is also...

VFP COM object recompile can’t find include file

V

I made some simple changes to a VFP COM project prg file the other day, but when I recompiled I kept getting errors that it couldn’t find certain variables (eg COMATTRIB_READONLY which is defined in an include file). This occurred in VFP8 and VFP9. To cut a long story short – manually deleted all the fxp files. Opened each prg file and compiled. Then recompiled the entire project to...

Archives