I always forget to use the Split command (or write it in VBScript before I remember PowerShell). The following command takes a comma separated list […]
Continue readingLaunching commands in PowerShell
Something I always need to look up when I’m running commands from a PowerShell script. It is always tough to get the spaces just right: […]
Continue readingIndexing a VARCHAR(MAX) column
A helpful article on using a computed column to index a VARCHAR(MAX) column: Indexing VARCHAR(MAX)
Continue readingSQL 2008 Configuration Manager: Cannot connect to WMI provider
On a 64-bit computer, you install an instance of the 32-bit (x86-based) version of Microsoft SQL Server 2008. On the same computer, you install an […]
Continue readingRemove File Server from Cluster Manager using PowerShell
I needed to remind myself about a terrific PowerShell command that will remove resources from Cluster Manager. Run the following PowerShell commands to remove the […]
Continue readingOpalis – Looping on a PowerShell Object
Looping can be a little tricky if you don’t know the rules used by Opalis: The Exit tab specifies the conditions that will determine if the […]
Continue readingOpalis – Fail a parent policy based on child status
Set the link from the triggered policy to fail is the Child policy status equals failed or warning. Succeed if the Child policy status equals […]
Continue readingOpalis – check for blank or null
One way to handle if entered data from the Custom Start object is null or blank (regex for null is ^$):
Continue readingEnable Service Broker on SQL
To determine whether or not Service Broker is enabled, execute the following T-SQL: SELECT is_broker_enabled FROM sys.databases WHERE name = ‘DatabaseName’; — Where ‘DatabaseName’ is […]
Continue readingBackspace, Enter, and Arrow Keys Stop Working in Visual Studio 2010
This irritating problem plagued me for a while in Visual Studio 2010. When this happened, my enter, backspace, and arrow keys worked in one of […]
Continue reading