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.

Monday, June 27, 2016

HOW TO - GREP / FIND PowerShell Output

q: In Windows CLI (Command Prompt) we use | find "" all the time after a standard command to filter the results.  How can we use find with PowerShell?
For example:
netstat -ano | find "LISTENING"

a: As we discover you can do anything in PowerShell, but it is considerably more complex.
To run the same command above inside PowerShell it looks like this:
netstat -ano | Out-String -Stream | Select-String -Pattern "LISTENING"

Monday, May 30, 2016

Y-U0003-DEL5 Dell Multimedia Keyboard - Media keys not working

q: Customer called with an issue where the multimedia keys on their Dell Y-U0003-DEL5 keyboard were not working. eg: next, mute, previous, etc.  This is on a new Windows 10 system.

a: We found this article that directed them to delete the "HID Keyboard Device" from Device manager, then either "scan for hardware changes" in device manager or unplug the usb keyboard and plug it back into the system. We performed the latter and they keys immediately started working.

UPDATE: That only worked for a short time. But it seems pressing CTRL or ALT and that multimedia button makes it work now. eg: CTRL+>>| (next)