Thursday, January 30, 2020

Dell Laptop Windows Product Key

Q: We need to re-install the Windows Operating system on a Dell Latitude, but we cannot find the Windows Product Key sticker.  Where is it?

A:  We found this on a Dell Support post:

"The Product Key label, is situated in the battery compartment(for most of the laptops)..  we would advise you to remove the battery and check.

You can also check PC Settings, PC Info or activation wizard to check the product key."

Friday, January 24, 2020

Best IPv6 Testing Site

Q: What is the best site to use for testing my IPv6 configuration?
A: For a lightweight interface and quick results we like this site by @testipv6com

Tuesday, May 14, 2019

Google Chrome is all dark

q: What happened to Google Chrome?  The address bar / omnibox is black instead of white and we do not have a theme installed.
a: Microsoft released Light and Dark mode for Windows 10 and Chrome is inheriting it. Click Start, type dark mode, click 'Color Settings' from the search results, scroll to the bottom. Look for 'Choose your default app mode' and it is most likely set to (X) Dark mode.  Click Light mode and Chrome will immediately switch back to white.

Monday, April 2, 2018

HOW TO - Hash a file in Windows

q: The customer called and had two copies of a file. They wanted to identify if they matched exactly or not because the file dates were different.
a: A simple hash should help with that.

  1. Open an elevated command prompt
  2. Run this command
  3. CertUtil -hashfile c:\path-to-file\filename.txt MD5
  4. This will generate an MD5 of the file. Without the MD5 switch it will default to SHA1.
  5. Run the same command on the other file and see if they match.

Friday, June 9, 2017

Windows 10 Upgrade can't resize window

q: Customer called saying they were clicking the middle button on the top right (restore / maximize) and it wasn't working.
a: Windows 10 had recently upgraded the system and it was in Tablet mode. We clicked Tablet mode to disable it and everything went back to normal.  NOTE: Most of the tray icons were missing and the desktop was the start menu open.

Friday, March 17, 2017

Windows Server ftp.exe timesout

q: When we're trying to use ftp.exe with Windows Server 2012 R2 it times out on this message:
200 Port request OK.

a: We added c:\windows\system32\ftp.exe to the windows firewall and it immediately worked, since we did it while it was waiting.

Thursday, August 18, 2016

Primary Replica of SQL 2014 AlwaysOn Group

q: In SQL Server 2014, what is an easy way to determine which Availability Replica as the Primary Role (meaning they own the cluster at that time)?

a: Here are two options.
' This command, returns all of the data in in sys.availability_replicas table:
Select * from sys.availability_replicas;

' This query returns a single hostname if you're using an automated process to monitor the results.
Select replica_server_name from sys.availability_replicas
where owner_sid is not null;