Monthly Archives: July 2014

Introduction to Basic Printing QGIS 2.2

Creating maps that you can pass on to others is often a central and regular requirement if not in paper format then in a digital format that can be e-mailed or printed out. Here’s a quick reference for myself as … Continue reading

Posted in All, Digital Mapping, Geographical Information Systems, GIS, QGIS 2.2, QGIS General | Comments Off on Introduction to Basic Printing QGIS 2.2

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

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

QGIS – Free GREAT Digital Mapping Software

A map showing winds over the Atlantic Looking for a desktop digital mapping package? You really need to check out QGIS it is an absolutely excellent open source geographical information system. At the time of writing the latest version was … Continue reading

Posted in All, Digital Mapping, General Opinion, Geographical Information Systems, Open Source, QGIS General | Comments Off on QGIS – Free GREAT Digital Mapping Software

Scramble the values of individual cells in an Excel Spreadsheet

Just out of curiosity I went off and had a look for a function that does the same for excel spreadsheets as my previous post did for databases. Here’s a function that will work. Public Function Scramble(Optional ByRef UserText As … Continue reading

Posted in All, Excel, VBA Code MS Excel | Comments Off on Scramble the values of individual cells in an Excel Spreadsheet

Wanting to demonstrate a database and need to scramble the data?

Here’s a nice function I found that will completely randomize information within fields of a database. Data will not be recoverable from this process which of course is its strength. Good if you are wanting to demonstrate a database to … Continue reading

Posted in All, Database Design, MS Access, VBA Code MS Access | Comments Off on Wanting to demonstrate a database and need to scramble the data?