Today some architecture changes were scheduled to occur in the evening. I wanted to adjust or disable backup jobs that could be affected. I have some 50 SQL servers. I needed to know when the backups were to start on…
Author: Steve Schneider
LinkedServer Failure — SPN not set
Recently, I tested a LinkedSErver and received the error: “The object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED)) (mscorlib)” What does this mean?
Performance counter types
Learning about Performance Counters How do you interpret the value you get back for any particular performance counter?
SQL PASS Rally
May 11, 12, 13. Steve is presenting on performance tuning in Orlando.
Get Alerted when your 2000 SQL cluster fails over
Today, I want to show how to be alerted any time one of your clustered SQL 2000 server fails over. This will work whether some admin fails it over on purpose, or accidentally.
» Get Alerted when your 2005 SQL cluster fails over
Today, I want to show how to be alerted any time one of your clustered SQL 2005 server fails over. This will work whether some admin fails it over on purpose, or accidentally.
Ways to run SSIS packages (and their 64/32 bit impact):
There are many ways and twists and turns on how to get an SSIS to run and 64/32 makes even more…