Using the KILL command

You can view the status of a KILL command used to stop an open transaction by typing the following:

Views – 387

About Replication

Questions: 1. Does TR copy schema changes? (It does not. It’s a lot like CDC in many ways) Setup Transaction Replication in SQL…

Tearing down SQL Server Replication

I recently was engaged in updating the Compatibility Mode of our production databases to 110 (2012) in preparation for upgrading them all to…

Using PSScriptAnalyzer

…for those of you that use Sapiens’ PowerShell Studio, there is a new feature available since version 5.2.118 that allows you to use…

A new cmdlet: Get-ClusterActiveNode

Here is a small cmdlet I wrote to get the currently active node in a Windows cluster:

Using the cmdlet as displayed…

Using Get-ClusterNode

I was in the process of writing a few PowerShell cmdlets for a project I was working on and ran across this cmdlet…

PowerShell Help Notes

A neat feature I just discovered was the -ShowWindow toggle when using Get-Help. This toggle allows you to redirect your output when using…

Manually removing log-shipping

I have had a number of situations where log-shipping broke and I needed to rebuild it but could not drop the log-shipping configuration…