Ben Hamilton

Author Archives: Ben Hamilton

fdsdfsdf

How I use Evernote on the Mac

I’m a big fan (BIG) of Evernote. I started out using the free service but couple of years ago upgraded to the paid service. How and why do I use it? Evernote for me is basically my online and offline, on every device I own, digital filing cabinet. Anything I want to come back to […]

Posted in Productivity | Tagged , | Comments Off on How I use Evernote on the Mac
fdsdfsdf

So you bought an Apple computer…

I know two people who have just bought themselves new Apple Mac computers, one a behemoth desktop, the other a 15″ MacBook Pro. Both have been immersed in “Windows World” and are essentially new to the Mac OS (one did have a Mac years ago). So, where to start? Here are my initial tips: Be […]

Posted in Productivity | Tagged , | Comments Off on So you bought an Apple computer…
fdsdfsdf

The five levels of delgation

I’ve been pointed to Michael Hyatt’s site which lists the five levels of delegation. Level 1: Do exactly what I have asked you to do. Level 2: Research the topic and report back Level 3: Research the topic, outline the options and make a recommendation. Level 4: Make a decision and then tell me what […]

Posted in Productivity | Tagged , | Comments Off on The five levels of delgation
fdsdfsdf

Create UAC elevated shortcuts on Windows

Create UAC elevated shortcuts on Windows (Hat tip to Jared).

Posted in Windows | Tagged , , | Comments Off on Create UAC elevated shortcuts on Windows
fdsdfsdf

SQL JOINs explained

SQL JOINs? Go read the article from the source (Visual Representation of SQL Joins)¬†and it’ll make even more sense.

Posted in How to | Tagged , , , , | Comments Off on SQL JOINs explained
fdsdfsdf

Everything Bill knows about business in one minute

“Everything I know about business in one minute.” – Bill Drenttel. Via John Gruber.

Posted in General | Tagged , , , | Comments Off on Everything Bill knows about business in one minute
fdsdfsdf

Backup WordPress to Dropbox

Backup your WordPress site to a Dropbox folder.

Posted in General | Tagged , , | Comments Off on Backup WordPress to Dropbox
fdsdfsdf

Locate on CentOS

How to install locate on CentOS.

Posted in *nix | Tagged , | Comments Off on Locate on CentOS
fdsdfsdf

What version of MySQL is running?

On a CentOS 6.x linux box, typing the following will show the MySQL version mysql -v or if not the root user, then mysql -u root -p -v (Which says user the root user, prompt for the password, then get the version).

Posted in SQL | Tagged , | Comments Off on What version of MySQL is running?
fdsdfsdf

New Act! emarketing to arrive soon

Act! (now owned by Swiftpage) will have an updated emarketing platform builtin to the next release of Act! 16.1. I know many who will be eager to test this out.

Posted in ACT! | Tagged , , , | Comments Off on New Act! emarketing to arrive soon
fdsdfsdf

Australian Privacy Law Reform Changes

There are changes to the Australian Privacy Laws. Details here: www.oaic.gov.au. This does raise some questions around where you’re hosting data. If you’re using the ‘cloud’ (Google Drive/Apps, hosted CRM, Virtual Servers etc) then you may want to read up and make sure you’re not setting yourself up for a problem.

Posted in General | Tagged , , , , , | Comments Off on Australian Privacy Law Reform Changes
fdsdfsdf

The Perfect Web Development Environment for Your New Mac

The Perfect Web Development Environment for Your New Mac. Great set of instructions, worked for me.

Posted in How to | Tagged , , | Comments Off on The Perfect Web Development Environment for Your New Mac
fdsdfsdf

Zapier on how to run a remote standup meeting

Zapier on how to run a remote standup meeting.

Posted in Productivity | Tagged , | Comments Off on Zapier on how to run a remote standup meeting
fdsdfsdf

How to resolve a Talend Execution failed due to access is denied error

Have Talend Open Studio running on a Windows server, however, when we run a job, it gives an error similar to the below: Execution failed : Failed to generate code. [No .class file created for file org\talend\designer\codegen\translators\processing\TMapMainJava$1.class in C:/Talend/TOS_DI-Win32-r111943-V5.4.1/workspace/.JETEmitters/runtime because of an IOException: C:\Talend\TOS_DI-Win32-r111943-V5.4.1\workspace\.JETEmitters\runtime\org\talend\designer\codegen\translators\processing\TMapMainJava$1.class (Access is denied) It turns out that the windows file permissions […]

Posted in How to | Tagged | Comments Off on How to resolve a Talend Execution failed due to access is denied error
fdsdfsdf

Sql snippet to show just opportunities from current month

I’m needing to do a sql query to show just the opportunities from the current month, the sql snippet for the WHERE clause to do this is the following: WHERE MONTH(opportunities.date_closed) = MONTH(NOW()) and YEAR(opportunities.date_closed) = Year(now())

Posted in SQL | Tagged , , | Comments Off on Sql snippet to show just opportunities from current month
fdsdfsdf

Create demo data for SugarCRM databases

Generate records with Tidbit for various Sugar modules.

Posted in SugarCRM | Tagged , | Comments Off on Create demo data for SugarCRM databases
fdsdfsdf

How to convert UTC time to current timezone in MySQL

Using SugarCRM (this client is using Enterprise 6.5.15) and we want the last two hundred items in the tracker table. The problem is that the `tracker`.`date_modified` field is in UTC time, not the local time zone, which is +10:00. The solution is to use the CONVERT_TZ MySQL command, as shown in the example below. It […]

Posted in SugarCRM | Tagged , , , | Comments Off on How to convert UTC time to current timezone in MySQL
fdsdfsdf

Digital email signatures

Get a digital email signature from Comodo. …digitally signing allows them to confirm you as the sender and verify the message was not tampered with en route…

Posted in General | Tagged , , , , , | Comments Off on Digital email signatures
fdsdfsdf

What is the difference between \r and \n?

What is the difference between \r and \n?

Posted in General | Tagged | Comments Off on What is the difference between \r and \n?
fdsdfsdf

What to expect when upgrading from SugarCRM 6.5.x to 7.1.5

What to expect when upgrading from SugarCRM 6.5.x to 7.1.5.

Posted in SugarCRM | Tagged , | Comments Off on What to expect when upgrading from SugarCRM 6.5.x to 7.1.5