Tuesday, April 10, 2018

Why is Powershell blocking scripts from UNC paths?

If you are seeing errors and warnings trying to execute Powershell scripts from UNC paths on Windows 2012 and you have the IE enhanced security turned on  Powershell won't' automatically execute your scripts.

You will get a prompt like so; 'Run only scripts that you trust'.


The reason for this is that Windows treats the UNC paths as being from the internet and therefore doesn't trust anything on the UNC path

There are two solutions to this issue.

1. Add the UNC paths to the trusted sites list (either Via Regedit or GUI)
or
2. Turn off the Enhanced security
As a side note; some sites recommend using the unblock-file cmdlet but I've found that it doesn't address the issue of trusting the UNC paths.

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

Wednesday, March 21, 2018

Why haven't we automated trains yet?

It seems it would be easier to automate trains before we automate cars. what's the holdup Sydney?

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

Friday, March 16, 2018

Android Wear changing to WearOS

So Google is changing the name of Android Wear into WearOS. big whoop.


https://wearos.google.com/


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

Thursday, March 08, 2018

SQL Server – Check Index Fragmentation on ALL Indexes in a Database | My Adventures in Coding

SQL Server – Check Index Fragmentation on ALL Indexes in a Database | My Adventures in Coding: "Check Index Fragmentation on ALL Indexes in a Database"



I found this quite useful. Only thing I wish I had taken a before screenshot before rebuilding the indexes using Ola Hallgren scripts.



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

Monday, February 26, 2018

Carnival Legend: How to make cruises great again

Carnival Legend: How to make cruises great again:



Dear Scott,



 I believe your opinion of Carnival is gravely misplaced.



 Personally, I can think of plenty of other things worse than a cruise holiday.  I travelled on the Carnival Spirit last year and I did not find our family of 5 packed into like sardines at all. I found my holiday pleasant and the staff friendly and the island hopping was a fantastic experience.



I travelled safe and sound throughout my whole holiday. Yes, I had seen plenty of news reports about gastro outbreaks on cruise ships. I must have been one of the lucky ones that escaped without a gastro incident just like the 1000's of others that travelled with me last year. 



I've also been to Airlie Beach and I can see the two holidays are completely different and simply can't be related to anything but saying they are both holidays.. one is mostly on land where the other is mostly on the sea.



During my travels with Carnival, I found most people nice and friendly or had travelled from overseas just to cruise. Most of the time it was just families, couples and singles wanting to have a good time and create some great memories.



Simply put if you get on a ship looking for a fight you shouldn't be there in the first place. but unfortunately, there will be dickheads no matter where we go on this planet.



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

Wednesday, February 14, 2018

Maybe don't set your database to 100% growth.

It's not a good idea to set your databases to  % growth anyway but setting them to 100% is just horrible. Every time your database has to grow when setting to 100% it will double in size a couple of those growth cycles and you'll be out of storage real soon.

Better to set to an actual MB limit based on the size of your HDD. I.e if your Database drive is 1000MB only set it to 64MB or 128MB growth. that way you can see your DB grow over time



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