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.
http://filehippo.com/download_novabench/

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 - http://koken.me/
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).