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 […]

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. […]

More...

Microsoft Windows 2008 R2 Server Automatic Restart

Sometimes you need to restart a server automatically, e.g. some time in the early hours of the morning. The best way to do this is using the “Task Scheduler” within Windows. 1. Open Task Scheduler and click on the “Task Scheduler Library” in the left hand pane. 2. Click “Create Task…” 3. On the “General” […]

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 […]

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 […]

More...