LincolnBlog.net – Page 3 – …my observations in the world of SQL Server, PowerShell, .Net etc…

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:

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…

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…

Resolving the “Backup detected log corruption in database”

I saw this in the SQL logs today. It looks like some corruption happened in the transaction log of a specific database. I…

MSDB is in “Recovery Pending” state

I had a SQL Server at work today where I found the msdb database in “Recovery Pending” state. After reading a number of…

Moving the TempDB database to a new drive

Often you will need to add or move the tempDB data files, either to match the core count (up to 8 as best…

Moving system databases to a new drive

A common task for any DBA building new SQL servers is to relocate where SQL Server stores user and system databases. This post…

Resolving “Cannot resolve collation conflict for equal to operation”

I recently had to run a query for one of our developers where the script was inserting a number of rows. All went…