March 2006 - Posts

What is that SPID doing?

My blog has moved to: http://sqlblogcasts.com/blogs/acalvett/

The full version of this post can be found here.

This is certainly not a new topic but something that i felt was worth revisiting and reminding people about, especially because i find many people are not aware of the ability to extract the statement within a stored procedure being executed........

To read the complete version of this post go to here.

posted Monday, March 27, 2006 5:44 PM by ACALVETT with 1 Comments

SQL 2005 - Log Shipping Monitoring?

My blog has moved to: http://sqlblogcasts.com/blogs/acalvett/

The full version of this post can be found here.

I took a look at log shipping in 2005 for the first time the other day and as i was curious to see how the monitor functionality had been implemented in SQL Server Management Studio i went hunting for it. I've got to say i was greeted with nothing but disappointment and left feeling that i now have a huge mountain to climb before it can be used in production......................!

To read the complete version of this post go to here.

posted Sunday, March 12, 2006 6:20 PM by ACALVETT with 2 Comments