You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you give the Cluster Name Object rights in Active Directory and then install your AG. You ... continue reading

You are going to create a Windows Cluster in Part 2 of our series on how to build a SQL Cluster Lab. You will run cluster validation followed by creating the Windows Server Failover Cluster. In addition, you configure the ... continue reading

This article is Part 1 in a series of articles showing how to build a SQL Cluster Lab. It covers building a Windows Cluster in Hyper-V that supports both Availability Groups and Failover Cluster Instances. Once you build the environment, ... continue reading

Recently I was engaged with a customer who ran into the following scenario. The customer had forced a query that was inside a stored procedure using the Query Store. The plan was manually forced. The customer had a 2 node ... continue reading

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 you are deploying a Failover Cluster Instance. If you are using the ... continue reading

Technical Reviewer: Krishnakumar Rukmangathan - Support Escalation Engineer, SQL Server BI Developer team, Microsoft Troy Moen - Sr. Escalation Engineer Linked server enable the SQL Server Database Engine to read data from remote data sources and execute commands against remote ... continue reading

Heya folks, Ned here again. In my continuing series on offbeat SMB settings, today I’m going to explain how to control SMB write-through and data consistency in Windows 10 and Windows Server. Background Network protocols like SMB or NFS are ... continue reading

Heya folks, Ned here again. As part of a small series on esoteric SMB settings, today I’m going to explain how to control SMB client dialects in Windows 10 and Windows Server 2019. Background SMB Dialects are simply significant versions ... continue reading

Heya folks, Ned here again. I've published a new version of the Get-SMSLogs PowerShell script on https://aka.ms/smslogs. It improves the logging of time stamps and event IDs for the non-debug event logs. And by improving, I mean, it actually has ... continue reading

The Problem You restored a database on top of an existing database to refresh your development environment, but the Physical_Device_Name is not updated in msdb..backupmediafamily.  That seems odd, but let's take a look at the documentation on that table.  We ... continue reading