Tuesday, June 20, 2017

System.ComponentModel.Win32Exception: A required privilege is not held by the client while Deploying SSIS Project – Data Access / SQL BI Technologies

System.ComponentModel.Win32Exception: A required privilege is not held by the client while Deploying SSIS Project – Data Access / SQL BI Technologies: "Replace a process-level token (SeAssignPrimaryTokenPrivilege) "



I found that I need to do both the DCOM part and the Replace token part and then manually restart SSIS services and the SQL Server Service. Once this was completed I was able to load and deploy SSIS packages.



'via Blog this'

If you find this article useful please leave me a comment.

Friday, June 16, 2017

How to convert KM per L to L per 100 KM

Say the dial on our car says  8.4KM per L (1L) and want to convert this to L per 100 KM the formula to conver this is

Litre Used  / Distance in KM driven  * 100

1 L / 8.4 KM *100

1 / 8.4 * 100 = 11.9047619047619

Rounded down that 11.9L per 100KM

Let's try another example;

Say we had driven 557KM on 74 Liters  of fuel this would be

Litre / Distance * 100

74 / 557 * 100  = 13.28545780969479

Rounded down 13.2 Liters per 100  KM.




If you find this article useful please leave me a comment.

Thursday, June 08, 2017

VMware snapshots playing havoc with availability groups – Mark Read

An important lesson here. Talk to your Infrastructure teams and be on top of what they are doing too.I've found the same problem in my systems.



VMware snapshots playing havoc with availability groups – Mark Read:



'via Blog this'

If you find this article useful please leave me a comment.

VMware snapshots playing havoc with availability groups – Mark Read

An important lesson here. Talk to your Infrastructure teams and be on top of what they are doing too.I've found the same problem in my systems.



VMware snapshots playing havoc with availability groups – Mark Read:



'via Blog this'

If you find this article useful please leave me a comment.