Tuesday, July 04, 2017

SSRS list view bug in Internet Explorer 11 with SQL 2016 SP1 CU3 update

Issue: 
If you happen use SSRS with IE 11 and you have SQL 2016 SP1 with CU3 installed and then try to switch to 'list view' you'll get an error message about could not load folder contents


Workaround:
Go back and just use 'Tile View' or  switch to Chrome (doesn't seem to be affected) or Uninstall CU3 and go back to CU2.

I have reported this to Microsoft but no response yet.

More info:
https://social.technet.microsoft.com/

https://connect.microsoft.com

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

Monday, June 26, 2017

An expensive lesson about diesel particulate filters



I have a diesel SUV, a Holden Captiva 2011. So far it's been a great car. This car has towed a camper trailer around the place and been serviced regularly. The Captiva has been a fabulous family SUV up until I ran into Diesel Particulate Filter (DPF) issues .

First up if you don't know what a DPF is go and read this Wiki - DPF

I had issues with my DPF. The DPF had became too blocked to clear through a normal regeneration process.

What's a normal regen you ask? That when the symbol below comes on in your dashboard. It kind of looks like a fart symbol. This indicator tells the driver that the DPF is nearly full and needs to run a regen process.

Image result for DPF light captiva

To regen a DPF you basically need to go for a long drive at speed (while the symbol is ON). keep the rev's above 2000RPM and the speed above 50 KM/H for around 30 minutes (if you fin ANYWHERE in Sydney to do this please let me know).

In my case this light came on and then turned off. Great that was a quick regen. Turns out the regen process did not work and now the DPF was getting rather full. This continued until one day driving along the hose for the turbo inlet fell off due to the backpressure (from what we knew later to be the the DPF unit). Performance of the car went really bad.  My local mechanic was kind enough to refit the hose for me. This however didn't fix the issue. Performance of my SUV was still really crap I had trouble getting the car above 50 KM/H.

This is when we found that the DPF had become completely full and blocked. This required having to remove the DPF unit and have it professionally cleaned 3 times and reinstalled. This wasn't cheap as it required an engine service at the same time (only had the same service 3 weeks ago) all up this cost me over  $1200 AUD to repair.

Interesting to note since fixing the DPF is that the car fuel economy has increased dramatically. I've gone from 12.9 - 13.9 L Per 100 KM down to 10.1 - 10.4 L per 100 KM's. My car has always sat around the 12L per 100Km in suburban areas I figure this means the DPF was at least partially blocked since we bought the SUV (the Captiva was bought used). The performance of the car seems to be much better too. It's quick to take off and acceleration seems a bit quicker (possible human bias here)

Ultimately this may prove to me that Diesel cars are great for highways but rather not suited for the short trip suburban market (unless you take your car for a long drive once every month or so). For me this also raises the question of how is the DPF better when it may cause us to use more fuel? don't get me wrong I know why we need to have DPF's to break down larger particulates into smaller particles but it's at the cost of more fuel use over a lifetime of the car which equals more carbon monoxide released. We reduce issues with particle inhalation as the expense of producing more carbon and pollutants.

Extra Note: If you do the sums on how much extra this cost us over 50,000KM since owning the car (based on diesel price of $1.22 per litre and 12.9 KM Per 100KM) we've had to pay an extra $1428.00 in fuel costs since owning the car + $1200 to repair  the faulty DPF.

Looking at the official Fuel ratings for a 2011 Diesel Captiva we should of been getting around 8.3L/100km (tested as 9.8L/100KM) Source.

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

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.

Wednesday, March 15, 2017

Starting a SQL Agent job with Powershell and Windows Scheduled Tasks

Thanks Kevin,



This came in really handy on few SQL server builds



Adventures in Database Administration: Starting a SQL Agent job with Powershell and Windows Scheduled Tasks: "





'via Blog this'

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

Google Why did you take a simple messaging platform and make messaging so hard?

In the beginning there was SMS.

Then data plans exploded. There was now SMS and IM.

So google brought out Gchat and SMS functions to Android.

After a while a very smart cookie in google said  "IM is very much like SMS why don't we combine the both into one?" shortly after that Hangouts is what came from that.

I was happy, I could see all my SMS and IM in the one conversation.

Then google decided that this needed to change..

So Google brought out Allo, Duo, and Messenger.

No longer would I have conversations in one place like Hangouts, I had to open separate apps once again.  I now have to open different apps to talk to someone using Allo too.

This is how Google took a superb  product and did it's normal thing of retiring an app and replacing it with a less functional different product.

Bring back combined SMS And IM please google.


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

Wednesday, January 18, 2017

Hangouts v15 unable to send MMS

I recently moved mobile providers and found I was no longer able to send MMS messages via Google Hangouts. No matter what settings and reboots I tried I ended up moving to Google Messenger to fix/workaround the issue.

update - Since this is becoming one of my more popular posts I think others out there might be having the same issue I am.


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