Sql Server does not allow for user defined constants. So we are forced to take other routes like hard-coded values, scalar udf's, settings tables, etc. Unfortunately, all methods are not equal. You need to carefully consider your use of different...
As does everyone from time-to-time, we had a lovely "learn as you go" moment in the middle of a deployment recently. As it turns out there are some very specific rules for setting up MS DTC in a clustered environment. As always, individual results...
I'm sitting at my office desk waiting for our distance cluster to finish failing back over to our local server. For the second time today, the our SQL cluster decided to fail over to our remote location. My suspicion is that due to the ungodly number...