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 readingAuthor: kevin
Remove 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 readingUse Quest to set permissions on object attributes in AD
Normally to set permissions on attributes I have to use ADSIedit to navigate to that object, and then go through all the security tabs scroll […]
Continue readingWITH Syntax to Delete Duplicate Records with No Primary Key
If you are missing a primary key, here is a great way to delete duplicate records in an SQL table. This example uses WITH to […]
Continue readingUse PowerShell to change service accounts through SQL Configuration Manager
Works with SQL 2008 R2. I use PowerShell to update the Service Accounts for the SQL Server, Agent, and Analysis Server: $servername = “ServerName”; [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SqlServer.SqlWmiManagement”) […]
Continue reading