Identifying the active cluster node

There are a number of ways that you can find out which physical machine your active cluster node is residing on.

You could access the information via the “Failover Cluster Management” console (cluadmin.msc)
Log on to the virtual windows cluster
Open the console “Failover Cluster Management” console (cluadmin.msc)
Drill down through the virtual machine and “Services and Applications” levels until you see your cluster application.
The summary screen will display the current active node under the label “Current Owner”
The benefit of doing things this way are that you can access all sorts of other information about the cluster, however for a quick check it seems quite a long winded way of doing things, a much easier way is to just connect to the virtual SQL instance and run the following T-SQL:

SELECT SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’)

Recommended SQL Books – Professional SQL Server 2008 Internals and Troubleshooting

One of the most frequent questions you will find on SQL forums and mailing lists is “which book should I buy?”, having bought quite a few SQL 2008 books recently I thought I would review one of my favourites:

Installing SQL Server with Slipstream

Many thanks to Christian Bolton for telling me about “Slipstream” and how it can streamline your installation process. Wikipedia defines slipstreaming as: In computer jargon, to slipstream updates, patches or service packs means to integrate them into the installation files of their original software, so that the resulting files will allow a direct installation of the […]

New Arrival

Things have been a bit hectic recently and unfortunately have not been able to post much, there has been a good reason for the silence. In February this year my wife and I were blessed with another son “Harry”, once everything has settled down into a routine normal blogging service will resume. Richard DouglasMore Posts […]

Custom plural notifications in SSIS

Adding notification messages in SSIS is really quite easy once you understand how you can use expressions, one of my pet hates is receiving process notification emails that contain things like &#34 file(s) processed&#34 or &#34 record(s) processed&#34. So, now we have a scenario with a disgruntled user how do we create a more professional […]