How to move/switch XBOX's in the Google assistant

So you replaced an Xbox with a new one and now you can't get the google assistant to work?

1. Logon to your New Xbox and then go to settings > Devices & Streaming > Digital assistants  > Enable Digital assistants.
2. Now, set up a new device in Google home on your phone (link your Xbox service)
3. Profit.

How to remove the old device?
Turn your old Xbox back on, disable the digital assistant instead of enabling it.

What do I do if I don't have my old Xbox?
NFI? Pray to Microsoft? Call for support?

Possible scam - Consumer Projects Group Australia

Today received a call asking if I would like to be paid money for doing surveys from a Consumer Projects Group Australia. They wanted to send someone to my house to interview me and show me a matrix and ask for feedback on this matrix. they promised for 20 minutes of my time I would get $35.  They then asked If I was free to have someone come around within the next few days.

I agreed to today or tomorrow as a test and they asked for an address straight away. I then changed my mind and said I was busy on those days. The lady on the phone then said "in that case, I will call you back" then promptly hung up on me without a goodbye.

The number the call came from was
 02 7713 3179

If you call that number it appears as disconnected Optus mobile number. and there isn't a clear domain or business called 'Consumer Projects Group Australia'

as of now, I wouldn't trust this caller. it just didn't sound right.


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

How to Tell If Your Users are Connecting to the Availability Group Listener

Patrick over at http://www.patrickkeisler.com explains this nicely

How to Tell If Your Users are Connecting to the Availability Group Listener


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

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.

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.

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.

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.