Select Page
Best of Both Worlds - Viewing DNS Analytic Logs Without Disabling Them

Best of Both Worlds – Viewing DNS Analytic Logs Without Disabling Them

The Problem When attempting to view an enabled Analytical Log, you receive the following error: Query Error - The requested operation cannot be performed over an enabled direct channel. The channel must first be disabled before performing the requested operation ... continue reading

Fix for the Storage Migration Service “Couldn’t transfer storage on any of the endpoints” issue

Heya folks, Ned here again. For those of you seeing this issue: https://docs.microsoft.com/en-us/windows-server/storage/storage-migration-service/known-issues#error-couldnt-transfer-storage-on-any-of-the-endpoints-and-check-if-the-source-device-is-online---we-couldnt-access-it With an error in WAC like: "Couldn't transfer storage on any of the endpoints. 0x9044" And detailed error in WAC like: "Check if the source device is ... continue reading
Lab Architecture.png

Build a SQL Cluster Lab Part 4

You are going to create a SQL Server Failover Cluster Instance in Part 4 of our series on how to build a SQL Cluster Lab. The FCI will only be installed on Node1 and Node2. FCIs require shared storage so ... continue reading
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