Small Bites of Big Data from AzureCAT You’ve created your HDInsight Hadoop clusters and now you want to know exactly what you have out there in Azure. Maybe you want to pull the key information into a repository periodically as a reference for future troubleshooting, comparisons, or billing. Maybe you just need to get aContinue reading “Get HDInsight Properties with PowerShell”
Tag Archives: cluster
Can I Have a Single Node SQL Server Cluster
I occasionally hear the question of whether you can create a one node SQL Server cluster. That basically means you have a virtualized instance of SQL Server with a virtual IP and virtual name that are differerent from the host box, but that there is only one “possible owner” of that SQL Server. Yes, thisContinue reading “Can I Have a Single Node SQL Server Cluster”
Share this:
SQL Server 2008 setup may report a Windows 2008 cluster validation failure
You may receive the error “The cluster either has not been verified or there are errors or failures in the verification report” while installing a SQL Server clustered installation on Windows 2008. When see this error you must fix the underlying error that caused Windows validation to fail. Even though in some cases you couldContinue reading “SQL Server 2008 setup may report a Windows 2008 cluster validation failure”
Share this:
Checklist for installing SQL Server 2005 as a clustered instance
Checklist for installing SQL Server 2005 as a clustered instance Windows/Hardware 1) Verify the Windows cluster is set up per basic best practices and that basic failover works. 2) Verify you have the latest patches, especially security patches, for Windows. 3) For Windows 2008: Validate the configuration using “Validate a Configuration” in Failover ClusterContinue reading “Checklist for installing SQL Server 2005 as a clustered instance”
Share this:
SQL Server 2005 Clustering Tips/References
I have copied this over from an older blog. I have cleaned it up a bit to clarify a few areas and added some links. SQL Server 2005 Clustering Tips/References This information will supplement the clustering information I wrote in chapter 10 of SQL Server 2005 Practical Troubleshooting: The Database Engine — Handy cluster related infoContinue reading “SQL Server 2005 Clustering Tips/References”
Share this:
How to configure DTC for SQL Server in a Windows 2008 cluster
How to configure DTC for SQL Server in a Windows 2008 cluster [This post was revised 11 May 2009 with new mapping information, fixed formatting issues 23 March 2010] With Windows 2008 you now have the option to use multiple DTCs. There is a lot of confusion over whether to do that for SQL ServerContinue reading “How to configure DTC for SQL Server in a Windows 2008 cluster”
