Browse by Tags

• Installation
• Kerberos
• Network Aliases
• Rant
• SAN
• Server location transparency
• single-node cluster
• SQL Agent
• SQL puzzle
• SQL Server 2005
• Storage
• T-SQL

• Clustering every SQL Server instance

  You may disagree, but I believe it is a good practice to cluster all the SQL Server instances. That is, even when you plan to run a SQL Server instance on a single machine, you should install it in a single node cluster. The primary advantage is that Read More... Posted Friday, February 10, 2012 11:32 PM by Linchi Shea | 32 Comments Filed under: Cluster, Network Aliases, single-node cluster, Kerberos, Server location transparency

• Where is SQL Server running in a cluster?

  There are numerous ways to find where a SQL Server instance is running in a cluster. The most convenient tool was cluster.exe . Unfortunately, I have to say it was the most convenient tool, and no longer is because no single cluster.exe works with all Read More... Posted Tuesday, December 27, 2011 11:55 PM by Linchi Shea | 9 Comments Filed under: Cluster

• Creating features for 1% of the users

  While at PASS Summit 2011 in Seattle, I had a conversation with an attendee from one of the largest US companies. As expected and like any of the largest US companies, this company has multiple DBMS platforms. The conversation then turned to how SQL Server Read More... Posted Monday, October 17, 2011 6:50 PM by Linchi Shea | 9 Comments Filed under: Cluster, Rant

• SQL Server puzzle: Why are the SQL Agent jobs executing twice?

  I recently ran into a rather freakish case in which many SQL Agent jobs on a SQL Server 2005 instance were reported to run twice at their scheduled times. And the 2 nd run took place either at almost exactly the same time or only a second or two later. Read More... Posted Wednesday, August 25, 2010 6:13 PM by Linchi Shea | 5 Comments Filed under: Cluster, SQL puzzle, SQL Agent

• Pause the passive node to apply SQL2005 Service Pack or hotfix

  With SQL Server 2005, Microsoft tried to be helpful in enabling its installer to apply the service pack or hotfix automatically on the passive node(s) in a cluster. In my own experience, this has not worked out too well. Very often, when the installer Read More... Posted Sunday, October 04, 2009 10:55 PM by Linchi Shea | 7 Comments Filed under: Cluster, SQL Server 2005, Installation

• How to Corrupt a SQL Server 2005 Database

  How can you corrupt an online SQL Server 2005 database? Okay, why would you want to do that? Well, let's say because you want to test out some DBCC commands. If you take a SQL Server 2005 database offline, you can easily corrupt it by opening it with Read More... Posted Wednesday, August 29, 2007 11:35 PM by Linchi Shea | 2 Comments Filed under: SAN, Storage, Cluster

• A Handy Server Property in SQL2005

  One frequenctly asked question is, "How do I find out via T-SQL which cluster node is running this SQL Server instance?" There is no easy way in SQL Server 2000 or SQL Server 7.0 to determine the current node of a SQL Server instance using T-SQL. The Read More... Posted Thursday, March 22, 2007 2:08 PM by Linchi Shea | 7 Comments Filed under: T-SQL, Cluster