Why you may or may not consider using Database Snapshots!

Microsoft introduced database snapshots with SQL Server 2005. A database snapshot is a static, read-only copy of a source database...

Why do I Blog?

Last week I heard about a new blog party/meme coming down the pipe for the #SQLFamily.  This new meme is Meme15 and is the pet project of Jason Strate (Blog|Twitter)....

Why do I Blog?

Last week I heard about a new blog party/meme coming down the pipe for the #SQLFamily.  This new meme is...

spid in Killed/Rollback cannot kill

We come across a situation where we have to kill one spid which was running for quite some time, so...

Albanian SQL Server Users Group - First meeting

Today, I’m so excited to announce that we had the first meeting of our Users Group – Albanian SQL Server Users...

Configuring and monitoring transactional replication between two SQL Server 2005 instances…

Replication often plays an important part in your database management strategy. An organization may use database replication for load balancing,...

Get drive & mount points space information in SQL Server 2005 by using CLR Stored Procedure?

As we know xp_fixeddrives can only be use to retrieve normal fixed drives space information. It cannot be used to retrieve information...

My first blog post!

I’ve started my own SQL blog. Hopefully I’ll write some interesting SQL blog posts here soon.

View execution plan for a sproc in the wild

Got stored procedure problems?  I feel sorry for you son.

Here's a quick query to pull the cached execution plan out...

Open_transaction_count in sys.dm_exec_sessions

This news may be a few months old, but it is worth noting that there is now a column called...