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;

Wednesday, August 17, 2016

HOW TO - Establish a benchmark

Q: We have two computers and we want to determine which one is better/faster overall.
A: We suggest running NovaBench on each one then compare their NovaBench Score.

Friday, August 5, 2016

Responsive HTML Photo Album

q: Customer called asking for a quick way to share photos with their users.
It had to support folders/albums, and had to be responsive.

a: KOKEN -
We were blown away by the ease of the deployment within their GoDaddy Hosting account.
We were able to turn off some features (Essays, Timeline, etc).

Tuesday, July 12, 2016

HOW TO - Share Passwords over the internet

q: What is a safe and easy way to share a password over email or over the internet?

a: We have recommended One Time Secret -
This site let's you enter a secret, and protect it with your own passphrase if you want.
Then it generates a one time use link to send to the recipient.
If you try the link again, it will say it has already been viewed.