-
Recent Posts
- 009 Postgres Command Line : psql : Altering the stated language – lets try Python
- 008 Postgres Command Line : psql : Another function example
- 007 Postgres Command Line : psql : Create a function that returns a single value
- 006 Postgres Command Line : psql : Identify definition of a Function
- 005 Postgres Command Line : psql : Create a User Defined Function and Identify its creation and then Drop it.
- 004 Postgres Command Line : psql : Create a spatially enabled table
- 003 Postgres Command Line : psql : List all databases in a Postgres Instance
- 002 Postgres Command Line : psql : Enabling extensions (PostGIS) to a database
- 001 Postgres Command Line : psql : Getting Started with Postgres
- 000 Postgres Command Line : psql : Useful RESOURCES Link to Github Cheat Sheet AND live on the web SQL excercises
Archives
- February 2019 (11)
- December 2018 (1)
- November 2018 (1)
- September 2018 (2)
- August 2018 (1)
- May 2018 (2)
- April 2018 (1)
- March 2018 (6)
- February 2018 (2)
- January 2018 (1)
- November 2017 (4)
- October 2017 (2)
- September 2017 (3)
- August 2017 (5)
- July 2017 (1)
- June 2017 (5)
- April 2017 (5)
- March 2017 (6)
- February 2017 (1)
- January 2017 (1)
- December 2016 (2)
- November 2016 (1)
- October 2016 (1)
- July 2016 (1)
- June 2016 (1)
- April 2016 (7)
- March 2016 (2)
- February 2016 (3)
- January 2016 (2)
- December 2015 (3)
- August 2015 (1)
- July 2015 (2)
- June 2015 (4)
- May 2015 (4)
- April 2015 (2)
- March 2015 (4)
- February 2015 (2)
- January 2015 (4)
- December 2014 (2)
- November 2014 (4)
- October 2014 (8)
- September 2014 (3)
- August 2014 (7)
- July 2014 (6)
- June 2014 (7)
- May 2014 (12)
- April 2014 (8)
- March 2014 (2)
- February 2014 (1)
- January 2014 (1)
- September 2000 (1)
Category Archives: Productivity
Lighthouse – Performance statistics for Web Sites
As part of the general move towards the web I continue to investigate and learn about web development. An important aspect for any developer considering how to serve programs to clients and colleagues with as little resistance as possible – … Continue reading
Posted in All, Chrome, Productivity
Comments Off on Lighthouse – Performance statistics for Web Sites
AHK – Useful AutoHotKeyScripts for Outlook specifically
Another set of very useful scripts mainly dealing with creating hotkeys for common Outlook tasks. Note that if you are on a laptop you may have pre-mappings for the function keys in which case you will need to quite possibly … Continue reading
Posted in All, AutoHotKey, E-mail, Personal Development, Productivity
Comments Off on AHK – Useful AutoHotKeyScripts for Outlook specifically
AHK – Useful AutoHotKeyScripts
F2:: ; Close all windows (open/minimized, browsers) but not pwr off WinGet, id, list,,, Program Manager Loop, %id% { this_id := id%A_Index% WinActivate, ahk_id %this_id% WinGetClass, this_class, ahk_id %this_id% WinGetTitle, this_title, ahk_id %this_id% If(This_class != “Shell_traywnd”) && (This_class != “Button”) … Continue reading
Posted in All, AutoHotKey, Chrome, Productivity
Comments Off on AHK – Useful AutoHotKeyScripts
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 Configuration, Programming
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 Language Support, VBA
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 Das Keyboard, Keyboard, Touch Typing
Comments Off on Wax on Wax off