Importing data from excel is very easy and you have several options to get you started…
Month: July 2011
See your servers’ performance real-time
I have posted an article to enable you to compare your servers’ performance in real time. It’s one of my favorites. It won’t run on systems older than 2005. You’ll find it here.
Why can’t I see more job history?
I’ve been a DBA for a long time… and it still takes me a minute of thinking before I remember how to see more job history. Furthermore, it takes a second try before I remember that the “Maximum job history…
Reboot–the last resort
Simple, weird problem, long research, short answer. The other evening, “something strange” happened to one of my clustered (active-active) boxes. When i arrived in the morning, the linked servers from each of the nodes to the other node was failing with…
Multiple SQL Server Error log search
In Yesterday’s post I mentioned creating “registered servers” in groups in your “Registered Servers” Window. Today, i present a short script, which, if applied to the SQL 2005 (and up) groups will allow you to in real-time query all the…
Determine Backup schedules across multiple SQL Servers
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…
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?