A Visual Explanation of SQL Joins
A good blog-post on joins from a visual aspect. Nicely done. A Visual Explanation of SQL Joins Views – 1183
Read MoreA good blog-post on joins from a visual aspect. Nicely done. A Visual Explanation of SQL Joins Views – 1183
Read MoreI recently was engaged in updating the Compatibility Mode of our production databases to 110 (2012) in preparation for upgrading them all to…
Read More…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…
Read MoreHere is a small cmdlet I wrote to get the currently active node in a Windows cluster:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 |
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…
Read MoreI was in the process of writing a few PowerShell cmdlets for a project I was working on and ran across this cmdlet…
Read MoreA neat feature I just discovered was the -ShowWindow toggle when using Get-Help. This toggle allows you to redirect your output when using…
Read MoreI have had a number of situations where log-shipping broke and I needed to rebuild it but could not drop the log-shipping configuration…
Read MoreI saw this in the SQL logs today. It looks like some corruption happened in the transaction log of a specific database. I…
Read MoreI had a SQL Server at work today where I found the msdb database in “Recovery Pending” state. After reading a number of…
Read MoreOften you will need to add or move the tempDB data files, either to match the core count (up to 8 as best…
Read More