Migrating Parallels VMs to Oracles’ VirtualBox

Below are the steps to migrate a Parallels VM to VirtualBox. This example is done on a MacBook Pro running OS X Sierra (see screenshot below) using the followjng versions of Parallels and VirtualBox: 1. Locate the VM file that you wish to import. It is located in your Parallels folder (where all the VM´s […]

Using the KILL command

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

Views – 25

About Replication

Questions: 1. Does TR copy schema changes? (It does not. It’s a lot like CDC in many ways) Setup Transaction Replication in SQL Server 2012 Using Multiple Versions of SQL Server in a Replication Topology Getting Started with Transactional Replication In defense of transactional replication as an HA technology Troubleshooting Transactional Replication SQL Server Replication […]

Tearing down SQL Server Replication

I recently was engaged in updating the Compatibility Mode of our production databases to 110 (2012) in preparation for upgrading them all to SQL Server 2014. One of the production servers had a database named ‘distribution’ and, since I am most familiar with log-shipping, was unaware what the database was for I need to do […]

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 PSScriptAnalyzer in the GUI. PSScriptAnalyzer is a module that you can run against your scripts and identify any code that is not in line with best practices. As with most code analysis […]

A new cmdlet: Get-ClusterActiveNode

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

Using the cmdlet as displayed below: Views – 236

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 for querying the active nodes on a Windows cluster:

Which returns: Ref: TechNet: Get-ClusterNode Views – 218