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...