Your MTTR
There are a lot of metrics you can track and many ways to use them to improve how you build and manage software. Steve has a few thoughts on MTTR and similar metrics.
2021-07-30
104 reads
HA/DR/AG/FCI/Clustering/Business Continuity
Do *not* place TEMPDB on a local disk in a SQL failover cluster
What happens with tempdb on a local disk in a cluster? Read on to see that you will not get a failover if the local disk fails
2021-01-04
5,906 reads
Configuring Availability Groups in Ubuntu
In this article, we will review how to configure Always On Availability Groups in Ubuntu Server using the Pacemaker cluster. The following are the high-level steps to configure Always On Availability Groups (AOAG) with an Ubuntu server. Install SQL Server on Ubuntu 16.04 Install Pacemaker agents and configure the cluster Create Always On Availability Groups Create […]
2020-08-25
1,718 reads
Keeping Availability Group Logins in sync automatically
I am Andreas Schubert and I am working as a Princi...
2019-05-22
SQL SERVER – Drop failed for Availability Group – Failed to Destroy the Windows Server Failover Clustering Group Corresponding to Availability Group
While working with one of the clients to recover from a disaster, I encountered an error. In this blog we would talk about error Drop failed for Availability Group....
2019-05-10
Blogs
A New Form of Address: Mx
By Steve Jones
When I was presenting at the dataMinds Connect conference, I called on someone in...
Group By Starting Characters
By Kevin3NF
I was chatting with Jeff (b|t) on my team yesterday and the context escapes...
Daily Coping 22 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Remove database from Distributed Availability Group replica AG ONLY!
Hi, all! I have an existing always on availability group on-prem and last week...
How to redesign a query
Hi Result is determined by the calculated Usage, With the below query, the result...
How do I join two temporary tables using MySQL?
Hi all, I'm still pretty new to SQL and could use some help getting...
Ask SSC