LincolnBlog.net

Using the KILL command

Posted on 11/22/2016 by Lincoln Bovee'

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

KILL [SPID] WITH STATUSONLY

1	KILL [SPID] WITH STATUSONLY

Views – 1123

About Replication

Posted on 09/28/201610/06/2016 by Lincoln Bovee'

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

A Visual Explanation of SQL Joins

Posted on 06/20/201606/20/2016 by Lincoln Bovee'

A good blog-post on joins from a visual aspect. Nicely done. A Visual Explanation of SQL Joins Views – 1211

Tearing down SQL Server Replication

Posted on 06/17/201606/20/2016 by Lincoln Bovee'

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

Posted on 06/07/201601/10/2017 by Lincoln Bovee'

…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

Posted on 05/27/201606/17/2016 by Lincoln Bovee'

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

function Get-ClusterActiveNode
{
	<#
	.SYNOPSIS
		Returns the active server node name for the specified Windows server cluster.
	.DESCRIPTION
		Returns the active server node name for the specified Windows server cluster.
	.EXAMPLE
		PS C:\> Get-ClusterActiveNode -ClusterCName ClusterAlias
    .PARAMETER ClusterName
    	Specifies the cluster name or alias for the Windows cluster to query.
	.OUTPUTS
		The output is displayed to the console.
	#>
	[CmdletBinding(DefaultParameterSetName = 'ClusterName')]
	[OutputType([string], ParameterSetName = 'ClusterName')]
	[OutputType([string])]
	Param
	(
		[Parameter(Mandatory = $true, Position = 0)]
		[string]$ClusterName
	)
	
	try
	{
		Get-WmiObject -Class Win32_ComputerSystem -ComputerName $ClusterName | Select-Object @{ Label = "Active Node"; Expression = { $_.Name } }
	}
	catch
	{
		$exception = $_.Exception
		
		"Error attempting to retrieve cluster node information for cluster name\alias: $ClusterName"
		
		Write-Error "$exception.Message"
		Write-Error $exception.InnerException
		Write-Error $exception.Data
		Write-Error $exception.StackTrace
	}
}

function Get-ClusterActiveNode

{

.SYNOPSIS

Returns the active server node name for the specified Windows server cluster.

.DESCRIPTION

Returns the active server node name for the specified Windows server cluster.

.EXAMPLE

PS C:\> Get-ClusterActiveNode -ClusterCName ClusterAlias

.PARAMETER ClusterName

Specifies the cluster name or alias for the Windows cluster to query.

.OUTPUTS

The output is displayed to the console.

[CmdletBinding(DefaultParameterSetName = 'ClusterName')]

[OutputType([string], ParameterSetName = 'ClusterName')]

[OutputType([string])]

Param

(

[Parameter(Mandatory = $true, Position = 0)]

[string]$ClusterName

)

try

{

Get-WmiObject -Class Win32_ComputerSystem -ComputerName $ClusterName | Select-Object @{ Label = "Active Node"; Expression = { $_.Name } }

}

catch

{

$exception = $_.Exception

"Error attempting to retrieve cluster node information for cluster name\alias: $ClusterName"

Write-Error "$exception.Message"

Write-Error $exception.InnerException

Write-Error $exception.Data

Write-Error $exception.StackTrace

}

Using the cmdlet as displayed…

…my observations in the world of SQL Server, PowerShell, .Net etc…

Using the KILL command

About Replication

A Visual Explanation of SQL Joins

Tearing down SQL Server Replication

Using PSScriptAnalyzer

A new cmdlet: Get-ClusterActiveNode

Using Get-ClusterNode

PowerShell Help Notes

Manually removing log-shipping

Resolving the “Backup detected log corruption in database”