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
9,801 reads
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
9,801 reads
With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made. This article is an update to another article, and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Before implementing your AlwaysOn Availability Group (AG), make sure […]
2020-12-07
144,465 reads
2020-11-16
593 reads
2020-10-22
9,083 reads
2020-10-15
443 reads
2020-09-21 (first published: 2020-08-25)
2,537 reads
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
3,508 reads
Learning about the Availability Group technology can be valuable for your career. Today Steve asks if you've deployed one, and if not, perhaps you want to try.
2024-03-11 (first published: 2020-04-03)
366 reads
Outages can be expensive, and today Steve asks if you know just how expensive they are for your organization.
2020-03-20
117 reads
Today Steve asks about HA and DR. What compromises and choices do you make in your environment and how do you ensure your clients can get to their data.
2019-11-22
225 reads
By SQLPals
Measuring and Improving SQL Server Query Plan Cache Efficiency The query...
By Brian Kelley
I may think I'm trying to reach the crowd, but I'm really trying to...
By Steve Jones
During a demo of Redgate Monitor Enterprise to a customer, they asked about how...
Comments posted to this topic are about the item The Technical Debt Anchor
Comments posted to this topic are about the item Getting the Updated Column List
Here's the complete error: An error occurred during local report processing. The definition of...
What happens when I run this code in SQL Server 2022?
UPDATE dbo.CustomerLarge SET CustomerContactFirstName = 'Andy' WHERE CustomerID = 1 SELECT COLUMNS_UPDATED()See possible answers