-
MSDTC Best Practices with an Availability Group
In this article we are going to look at some guidelines and MSDTC best practices with an Availability Group. Please note that some of these recommendations change if… Continue Reading
-
MaxDOP Added to SQL 2019 CTP3.0 Setup
You can now set MaxDOP during SQL 2019 CTP3.0 setup. MaxDOP is the sledge hammer to Cost Threshold’s tack hammer (also MaxDOP database scoped configuration in SQL 2017+)… Continue Reading
-
Physical_Device_Name Is Not Updated
The Physical_Device_Name in msdb..backupmediafamily does not get updated to the new path when you restore a database from the same backup, but a new path. Continue Reading
-
Automate Azure VM Storage
The Problem One of the best things about Azure, and the cloud in general, is we can automate most anything, and we are going to look at how… Continue Reading
-
Configure SQL Server Failover Cluster Instance on Azure Virtual Machines with MSDTC
Configure SQL Server Failover Cluster Instance If you are running a SQL Server Failover Cluster Instance on premises and looking to migrate to Azure, you might be a… Continue Reading
-
MSDTC Supported Configurations
The MSDTC Configuration Conundrum MSDTC configuration is not as straight forward as you might think. It’s a different choice if you are using a local MSDTC, clustered MSDTC,… Continue Reading
-
Read-Scale Availability Group Setup
What is a Read-Scale Availability Group? A Read-Scale Availability Group is a Clusterless Availability Group. It’s sole purpose and design is to scale out a read workload. More… Continue Reading
-
Domain Independent Cluster and Availability Group
What is a Domain Independent Cluster? Did you know that you can have a Windows cluster that is a domain independent cluster and run a SQL Server Availability… Continue Reading
-
Verify Allocation Unit Size for SQL Server
Why Do I Care? Everything in SQL Server is stored on disk in 8K pages. The Microsoft recommended best practice is to format using a 64K allocation unit… Continue Reading
-
How to Upgrade an AG Cluster to Windows 2016
Starting in Windows Server 2012 R2 you now have a way to upgrade a cluster to Windows 2016. The best part is it’s not an OS upgrade, but… Continue Reading
-
Sync SQL Logins and Jobs
In this post I’ll point you to some options to sync SQL logins and then I’ll demo my favorite option in a video. If you are using Availability… Continue Reading
-
Implementing Buffer Pool Extension
Buffer Pool Extension was released in SQL 2014 so it’s not new. It is also not advertised very much, but that’s not for lack of usefulness. RAM is… Continue Reading
