Select Page
Lab Architecture.png

Build a SQL Cluster Lab Part 3

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
Lab Architecture.png

Build a SQL Cluster Lab Part 2

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
Lab Architecture.png

Build a SQL Cluster Lab Part 1

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
clipboard_image_0.png

Why Database ID Order Matters When Using Query Store to Force Plans With AlwaysOn AG

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
Clustered Default Coordinator.png

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

Establishing Linked Server to SQL Server using MSOLEDB Driver

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
Anchorman_204Pyxurz.jpg

Controlling write-through behaviors in SMB

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
Annotation 2019-09-17 144004.png

Controlling SMB Dialects

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
:lol:

New SMS log collector available

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
BackupMediaFamily.png

Physical_Device_Name Is Not Updated

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