Relational Theory (E-R Model to SQL Conversion) – Relationships (one-to-one, one-to-many and many-to-many)

This post details about relational theory relationships. I’ve struggled to find on the Internet any decent explanations of what these are in simplistic terms which are degree/masters degree level, and not primary school or PhD examples! I’ll introduce the types of relationship, with some simple examples showing how the relational theory of relationships is actually … Read more

Compass ProSolution 9.2 PowerShell Task Error

After the upgrade to ProSolution 9.2, I found that the tasks we ran which used PowerShell with the ProSolution Worker Service failed with the following error message: Error:  – System.Management.Automation.Runspaces.PSSnapInException: An error occurred when loading the system Windows PowerShell Snap-Ins. Please contact Microsoft Support Services. —> System.Management.Automation.PSArgumentException: Unable to access Windows PowerShell PowerShellEngine registry information. … Read more

Compass ProAchieve Web Upgrade 5.2.0 to 5.2.1

After the upgrade you may find that the Windows Authentication has stopped working. To fix this you need to performing the following steps: (This is for Windows 2008 R2 with IIS 7.5) 1. Open IIS Manager. 2.Click on the ProAchieve website, then click on Authentication, ensure the following settings are set: Anonymous Authentication = Disabled … Read more

Windows Server 2008 R2 Setup Fails: “setup was unable to create a new system partition”

On a Dell PowerEdge R710 had this error when trying to install Windows Server 2008 R2 Setup.  PROBLEM Fails when selecting the disk: “setup was unable to create a new system partition.” All seems to be fine up until that point then it just fails. Even booting from the Dell utility CD gives the same … Read more

PCounter – Resolving the ERROR: DATA AREA PASSED TO A SYSTEM CALL IS TOO SMALL ERROR MESSAGE” when printing to a pull queue

When using PCounter you have a separate queue that will take the job from the client; this is then passed to the queue that relates to the printer identified by the swipe card box the user swiped their card through. I.e. you print to a holding queue, the job stays there until you swipe your … Read more

IEC C14 and IEC C20 Plugs

I always get the plug types confused. A IEC C14 plug (shown below) connects to an IEC C13 socket. This type of socket has a maximum power load of 13 amps. An IEC C20 plug (shown below) connects to an IEC C19 socket. This type of socket has a maximum power load of 16 amps.