Category Archives: Personal Development

MS Access like development environments for the Web – 3 alternatives

So you would like to construct simple applications that you can at the moment create in MS Access but you want to do it on the web. By that I mean you would like to create a data driven application … Continue reading

Posted in All, Code Generators, Continual Professional Development, Database Design, Dev Ops, dot NET framework, General Opinion, Learning, Low Coding Platforms, MS Access, Personal Development, RAD Web Tools | Comments Off on MS Access like development environments for the Web – 3 alternatives

Notepad ++ / AstroGrep / Autohotkey – 3 Useful Tools

Three useful tools for speeding up or automating tasks Notepad ++ Text editor that has formating for programming – I often use it for editing XML documents and writing VB scripts. Notepad ++ link AstroGREP Son of GREP – useful … Continue reading

Posted in All, Personal Development, Problem Solving, Useful Links | Comments Off on Notepad ++ / AstroGrep / Autohotkey – 3 Useful Tools

nuBuilderPro – Import csv into a table of your application MySQL database (Its very easy)

I don’t know about you but for me its pretty rare to start an application without any information. At the very least there may be lookup tables or you have information collected in a spreadsheet. Thus when I came to … Continue reading

Posted in All, nuBuilderPro, Open Source, Personal Development | Comments Off on nuBuilderPro – Import csv into a table of your application MySQL database (Its very easy)

Database Normalisation – a review of the rules to refresh my knowledge

Here is a review of the 6 forms of normalisation (yes the 4th is called 3.5 for some reason) – there are lots of summaries on the web of these, but I wanted to re-write them in my own words … Continue reading

Posted in All, Continual Professional Development, Database Design, My UI Design Patterns, Personal Development | Comments Off on Database Normalisation – a review of the rules to refresh my knowledge

Trusting Your Gut or When Not to Use Computers.

As good as computers are at calculating numbers they are really really bad at doing somethings that humans are just great at like making decisions based on fuzzy logic or translating things between languages. In such situations always go for … Continue reading

Posted in All, General Opinion, Personal Development, Problem Solving, Software Purchase | Comments Off on Trusting Your Gut or When Not to Use Computers.

Summary and Links for Microsoft MCSE Data Platform Solutions Expert

Microsoft MCSE Data Platform Some notes on the syllabus for this – thinking of taking it. https://www.microsoft.com/learning/en-gb/mcse-sql-data-platform.aspx Earning an MCSE : Data Platform certification will qualify you for jobs such as database analyst and database designer 1 : Querying Microsoft … Continue reading

Posted in All, Learning, Personal Development, SQL Server | Comments Off on Summary and Links for Microsoft MCSE Data Platform Solutions Expert