Category Archives: Productivity

SQL Azure to MS Access – Using VBA to Dump Azure Tables into MS Access Tables

The first thing you need to get sorted when moving to SQL Azure is having the ability to get your information out and safe if needs be. When experimenting with MS Azure and for applications that don’t have sensitive information … Continue reading

Posted in All, MS Access, Productivity, Programming, SQL Azure, SQL MS Access, SQL Server, VBA Code MS Access | Comments Off on SQL Azure to MS Access – Using VBA to Dump Azure Tables into MS Access Tables

Linking to SQL Server / Oracle – don’t skip the set key field on linking

After writing Update queries with multiple joins on linked Oracle Databases I was receiving an error on running particular update queries on linked tables that had no Primary Key identified. On linking the tables I had been asked to identify … Continue reading

Posted in All, MS Access, Productivity, Programming | Comments Off on Linking to SQL Server / Oracle – don’t skip the set key field on linking

MS Access VBA Function – Automated Multiple Query Object Creation from previously created table of SQL

This completes the task of taking automatically generated SQL previously placed in a table and writes the SQL therein to Query Objects naming them automatically. This has several advantages to cut and paste – 1) Its Lightning Quick 2) Completely … Continue reading

Posted in All, MS Access, Productivity, Programming, VBA Code MS Access | Comments Off on MS Access VBA Function – Automated Multiple Query Object Creation from previously created table of SQL

AutoHotKey : Navigation between Satellite Applications to improve Work Flow

A while back I wrote a post about how allowing parameters to be passed to URLs is a big benefit in increasing the speed with which you can navigate to individual records in apparently non-connected web applications. But what do … Continue reading

Posted in All, AutoHotKey, Productivity, Programming, VBA Code MS Access | Comments Off on AutoHotKey : Navigation between Satellite Applications to improve Work Flow

Appropriate User Interfaces

I have three guitars 10 windsurfers and 4 bikes (5 if you count a static exercise bike) I have three regularly used computers (tablet , desktop and laptop) – four if you count my phone. My bikes are not duplicates … Continue reading

Posted in All, General Opinion, Productivity, Project Management | Comments Off on Appropriate User Interfaces

Guidelines for E-mails

Not the most exciting of subjects but everyone is involved in communication whether its sorting out lunch with a friend through to organising massive engineering projects. Confusion and misinformation is always an ongoing risk resulting from bad communication which results … Continue reading

Posted in All, E-mail, Productivity, Project Management | Comments Off on Guidelines for E-mails

Comparative Advantage

My opinion on fixing things is that if someone has to sit around and watch you fix something the cost of the job is not just your time in fixing it but it’s also the cost of the time of … Continue reading

Posted in All, General Opinion, Problem Solving, Productivity | Comments Off on Comparative Advantage

Developer Operations and Empowering Users My Opinion

Recently I was listening to a Channel 9 Microsoft podcast talking about how their products could be used in developer operator environments. Interestingly the podcast talked about Developer Operations being a subdivision of the central IT department and how once … Continue reading

Posted in All, General Opinion, Productivity | Comments Off on Developer Operations and Empowering Users My Opinion

Internal Development Good or Bad

Elite Dangerous from Frontier Developments an example of a game built on internally developed game engine – and they are seriously kicking ass as a result. It is tempting having been burnt with IT projects to say right that’s it … Continue reading

Posted in All, General Opinion, Productivity, Programming, The future of software | Comments Off on Internal Development Good or Bad

Why you and your Organisation should make Web Bespoke part of your operations.

Don’t get me wrong as a platform for communication I consider things like facebook and Linkedin as necessary evils for what is essentially cloud service market places but my preferences are always… No adverts No demands to have login prior … Continue reading

Posted in All, Problem Solving, Productivity | Comments Off on Why you and your Organisation should make Web Bespoke part of your operations.

Configuration vs Programming

I used to find configuration kind of frustrating – highly repetitive unintuitive and often changing as software versions change. I now consider it a simple exercise in rote learning for which there is no solution except perseverance, patience and determination and … Continue reading

Posted in All, Configuration, Problem Solving, Productivity, Programming | Tagged , | Comments Off on Configuration vs Programming

VBA Function to allow alteration of Key Mapping for Multi-lingual support

Important Proviso : bear in mind that different Windows operating system versions have different support for languages – with Windows 7 you require ultimate version of the OS and then you have to ensure that the required language pack is … Continue reading

Posted in All, Productivity, VBA Code MS Access, Русский | Tagged , | Comments Off on VBA Function to allow alteration of Key Mapping for Multi-lingual support

Wax on Wax off

One of the most useful and easy improvements I ever made to working was simply learning how to touch type. Its never been particularly necessary for programming as I find anytime I’m programming I write relatively little and the combination … Continue reading

Posted in All, Productivity | Tagged , , | Comments Off on Wax on Wax off