Category Archives: Configuration

Chrome v:56.0.2924.87 – Run Web Applications in Application Mode

Seek and you shall find – was wondering if I could do anything to get rid of the bookmark bar in Chrome. Then I thought – hold on if I am getting rid of the bookmark bar why not get … Continue reading

Posted in All, Chrome, Configuration | Comments Off on Chrome v:56.0.2924.87 – Run Web Applications in Application Mode

Compact Database automatically using this MS Access Function and VB Script

If like me you sometimes need to run multiple SQL statements in MS Access on a regular basis maybe at a particular time some of which are deletes, you will need to find a way to automate regular compacts. Here’s … Continue reading

Posted in All, Configuration, VBA Code MS Access, VBS Scripts | Comments Off on Compact Database automatically using this MS Access Function and VB Script

VBS – Pieces of code

Shutdown computer Option Explicit Dim oShell Set oShell = Wscript.CreateObject(“Wscript.Shell”) oShell.Run “SHUTDOWN -T 60 -S” ‘wait 60 seconds before shutting down Trigger speech Option Explicit Dim speechobject set speechobject=createobject(“sapi.spvoice”) speechobject.speak “Your system is setup and ready for your day” Delay … Continue reading

Posted in All, Configuration, VBS Scripts | Comments Off on VBS – Pieces of code

Using Task Scheduler and Visual Basic Scripts to automate pretty much anything Win 7

This is hardly ground breaking but windows Task Scheduler can be used to run VBS scripts on a variety of events to automate repetitive and boring tasks. Backups for example or refreshing caches on web browsers before users come in. … Continue reading

Posted in All, Backup, Configuration, Dev Ops, VBS Scripts | Comments Off on Using Task Scheduler and Visual Basic Scripts to automate pretty much anything Win 7

QGIS 2.8.1 Updating Copyright Label in your QGIS Projects

Specific example QGIS 2.8.1 probably same in other versions. Ensure you have copyright quote correct on QGIS projects View / Decorations / Copyright Label

Posted in All, Configuration, QGIS 2.8.1, QGIS General | Comments Off on QGIS 2.8.1 Updating Copyright Label in your QGIS Projects

Setting up a Blank SQL Server Spatially enabled Table using Microsoft SQL Server Management Studio 2008R2 Express and displaying it in QGIS 2.8.1

Programs used; 1- SQL Server 2008R2 Express 2- SQL Server Management Studio 2008R2 Express 3- QGIS The example uses UK national grids coordinates to create a Triangle Polygon in a SQL Server Table I’ve previously written that while we’ve had … Continue reading

Posted in All, Configuration, Database Design, Dev Ops, QGIS General, SQL 08 R2, SSMS | Comments Off on Setting up a Blank SQL Server Spatially enabled Table using Microsoft SQL Server Management Studio 2008R2 Express and displaying it in QGIS 2.8.1

Administering a Web Application some thoughts

In the last couple of years I have started administering a bought in Web Application from an outside vendor. I have found this really quite educational. I will not reveal the name of the product the vendor seems neither better … Continue reading

Posted in All, Configuration, Continual Professional Development, Dev Ops, General Opinion | Comments Off on Administering a Web Application some thoughts

Start up VBS

OPTION EXPLICIT Dim WshShell Dim counter Dim shell Dim Outlook Dim objWord Dim objshell ‘Flash keyboard to show code is being hit Set WshShell = CreateObject( “WScript.Shell” ) counter = 0 While counter < 18 WshShell.SendKeys "{NUMLOCK}" WScript.Sleep 200 WshShell.SendKeys … Continue reading

Posted in All, Configuration, Dev Ops, VBS Scripts | Comments Off on Start up VBS

The Handover – where the dragons lie

The handover – often someone figures out that something needs to be done – maybe they have realised an important omission or maybe there is a problem that only comes to light in a process when you start designing. For … Continue reading

Posted in All, Configuration, Dev Ops, General Opinion | Comments Off on The Handover – where the dragons lie

International Domain Names

I was helping to set up a domain for a friend the other day and I wondered whether they would like a domain in Cyrillics. Led to the question was that even possible. I try to be aware and present … Continue reading

Posted in All, Configuration, Русский | Comments Off on International Domain Names

Access Connection Strings – Link

Some notes on using SQL Server connection strings both using the default ODBC client drivers and also the native SQL Server driver. Juan Soto of Access Experts explains connection strings from MS Access to SQL Server Additionally I am hearing … Continue reading

Posted in All, Configuration, MS Access, SQL Server | Comments Off on Access Connection Strings – Link

Dealing with Dates can still catch you out

The other day I was dealing with dates and I found a cracking little gotcha that might just be catching a few people out. When is 07/11/14 not 07/11/14 When one is 17 November 2014 and one is 17 November … Continue reading

Posted in All, Configuration, Database Design, Win 8.1 | Comments Off on Dealing with Dates can still catch you out

Graphics vs Text

So today it is a bit slow for me so I answered a question from a lad in Phnom Phen in Stack Overflow. He was looking for support for Khmer in MS Access 2013, the official language of Cambodia. He … Continue reading

Posted in All, Configuration, Database Design, My UI Design Patterns | Comments Off on Graphics vs Text

Caspol.exe

Never heard of it? I hadn’t either – it is however a small exe that stands for Code Access Security Policy Tool which enables users and administrators to modify security policy for the client machine to .NET framework. This tool … Continue reading

Posted in All, Configuration, dot NET framework | Comments Off on Caspol.exe

40 Useful Facts to Know about a System

A list of points I should remember to ask when doing ongoing system development, total re-design or external purchase. For alternative systems rank both existing and new and compare. Collection of facts is as objective as I could make it … Continue reading

Posted in All, Configuration, Database Design, General Opinion, Software Purchase | Comments Off on 40 Useful Facts to Know about a System

Connecting to SQL Server – authentication and QGIS

Within QGIS when you set up a connection to a MS SQL Server instance you are presented with two options. Here’s a bit of clarification on what the two options entail. * Trusted connection – this is the same thing … Continue reading

Posted in All, Configuration, QGIS General, SQL Server | Comments Off on Connecting to SQL Server – authentication and QGIS

Attaching Databases to SQL Server 08R2 Express

It should be noted that the following although the easiest way to get a new database into an instance it should not be used in a production environment. In fact doing so may get you sacked. If experimenting though this … Continue reading

Posted in All, Configuration, Database Design, SQL 08 R2, SQL Server, SSMS | Comments Off on Attaching Databases to SQL Server 08R2 Express

Scope of variables – And Getting Confused

Note to self If you are wanting to pass parameter values between forms ensure that you place public variables in a module outside of the form. IMPORTANT – additionally ensure that the same variable names are NOT also listed in … Continue reading

Posted in All, Configuration, Database Design, VBA Code MS Access | Comments Off on Scope of variables – And Getting Confused

Attaching an existing SQL data file to a new SQL Express Instance

Link for information http://technet.microsoft.com/en-us/library/ms165673(v=sql.105).aspx

Posted in All, Configuration, SQL 08 R2, SQL Server, SSMS | Comments Off on Attaching an existing SQL data file to a new SQL Express Instance

Stopping and Starting SQL Server Instance 08R2 Express

Simply within SSMS right click on the instance and hit STOP and To start an instance if you are still in SSMS you can simply right click and hit start Note if you stop a SQL Server instance from within … Continue reading

Posted in All, Configuration, SQL 08 R2, SQL Server, SSMS | Comments Off on Stopping and Starting SQL Server Instance 08R2 Express