Deadlock Detection and Reporting part-I

This will be a 2 part series about deadlock.  First part will be about how you detect deadlock in SQL Server and collect that information.  Second part will be about reporting from the collected information. 248 more words


Announcing ExtendedTSQLCollector

I haven’t been blogging much lately, actually I haven’t been blogging at all in the last 4 months. The reason behind is I have been putting all my efforts in a new project I started recently, which absorbed all my attention and spare time. 646 more words

SQL Server

Restoring or Attaching a database using only the MDF file

Ever feel like you are traveling up a creek without a paddle? This happens to me whenever I have a database issue.

Recently I was given an MDF and LDF file to put a SQL database online using the attach option. 392 more words


Thinking about 70-462 and 70-463

Since I’m taking 70-461 next Monday (14th), Im now thinking about the next exam, 70-463 Implementing a Data Warehouse. I might skip 70-462 since I’m currently doing some DW at work. 231 more words

SQL Server 2012


Aha! Yet another easy and tricky one.

What is Cardinality?

The immediate answer is 1-1, 1-m, m-1, m-m relationships between objects.

Perhaps its the right answer, but sometime its better to explain with some essence. 460 more words

Sybase IQ

SQL Server latest Cumulative Updates (June 2014)

Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2012 and 2014 RTM:

SQL Server 2012… 24 more words

SQL Server

Worst Day As A DBA

I remember the day pretty vividly, it was in the summer months and I was as green as green can be coming into the technology field. 939 more words

SQLServerPedia Syndication