Monthly Archives: July 2011

Importing data from Excel

Importing data from excel is very easy and you have several options to get you started…

Posted in SQL 2000, SQL 2005, SQL 2008 | Tagged , , , | Leave a comment

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.

Posted in Performance Tuning, SQL 2005, SQL 2008, SQL Administration | Tagged , | Leave a comment

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 … Continue reading

Posted in SQL 2000, SQL 2005, SQL 2008, SQL Administration | Tagged | Leave a comment

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 … Continue reading

Posted in SQL Administration | Tagged | Leave a comment

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 … Continue reading

Posted in SQL 2005, SQL 2008 | Tagged , | 1 Comment

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 … Continue reading

Posted in SQL 2000, SQL 2005, SQL 2008, SQL Administration | Tagged , , | Leave a comment

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? 

Posted in SQL 2005, SQL 2008 | Tagged , | Leave a comment