Author Archives: Ben Hamiltonfdsdfsdf
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 […]
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 […]
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 […]
SQL JOINs? Go read the article from the source (Visual Representation of SQL Joins) and it’ll make even more sense.
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).
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.
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.
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 […]
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())
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 […]