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;
These fixes are things we've discovered to save time or resolve error messages and problems. LazyJeff LLC is an IT Company focusing on Small Businesses in the St Louis and Southern Illinois Areas.
Thursday, August 18, 2016
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/
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).
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).
Subscribe to:
Posts (Atom)