Category: SQL Server

This article will walk through a basic install and configuration for SQL Always On, to be leveraged by SCOM for higher availability. This is no way aligned to Clustering and SQL best practices – just an example on how to set one up for a simple testing deployment.   The Server OS used will be Windows […]
I wanted to write this article to make it easier for you to choose between SQL Server’s technologies used for HA (High Availability) and DR (Disaster Recovery) for Citrix Virtual Apps & Desktop Site Setup Briefly, we will compare the technologies listed below. Always On Failover Cluster Database Mirroring Always ON Availability Group Replication Log […]
SQL Server Configuration is a crucial part of the Skype for Business Server deployment. For SQL Server installation you can follow my preceding post Step by step SQL Server Installation for Skype for Business Server 2015. The below configuration mainly focus on settings which are necessary for mirror configuration. First of all make sure network discovery, […]
Summary: This document describes how to install SQL 2014 Standard Edition in a failover configuration. This configuration uses SQL servers in an active/passive mode. Audience: customers who have SQL server Standard Edition and wish to create a failover SQL cluster configuration.  It is the full responsibility of the IT department to configure the SQL failover configuration. XMPie […]
In Today’s post, I would like to show you how to configure Microsoft Clustering across Virtual Machines with shared disk – so-called Cluster in a Box(CiB). Typical use case for Microsoft Cluster / Failover Cluster is to have cluster nodes with shared storage. Typical use case for Cluster in a Box is when you have to provide […]
As we all know by now AlwaysOn Availability Groups are an enterprise edition feature and SQL Server Clustering is a standard edition feature.  Butt what happens when you have a small business that is running its apps on SQL Server Express.  Can’t SQL Express have any sort of high availability? Officially the answer is no, […]
Archives