SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2009- Seattle

PASS Summit Unite2009 – the premier event for SQL Server professionals – will be held in Seattle from November 2 to 5. It is the largest and the most intensive Microsoft SQL Server conference in the world organized by SQL Server users for SQL Server users. This year marks the…
Read More

SQLAuthority News – Shaivi Dave – Baby SQLAuthority

Six days ago, on September 1st, 2009 07:03:40 AM, God blessed us with beautiful baby girl. As per Hindu Namkaran Sanskar (naming ritual), we have decided to name her as Shaivi Dave. Thank you all for all the wonderful suggestions for the baby name. Selecting the right name for the little one is really one of the most challenging tasks. According to Vedas, in Hindu religion, each occasion of a person’s life calls for elaborate rituals. After the birth of a child, naming ceremony or the Namkaran Samskar is considered one of the most important events.

Read More

SQL SERVER – Find Gaps in The Sequence

I have previously written two articles on the subject of missing identity and both are very well received by community. I had great fun to write article as many SQL Server expert participated in both the articles. Expert Imran Mohammed had provided excellent script to find missing identity. Please read both the articles for additional information before reading this article about finding gaps in the sequence.

Read More

SQL SERVER – FIX – ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)

I have set up replication at many different organization. One error I quite commonly face is after I have removed replication I can not remove database. When I try to remove the database it gives me following error. Cannot drop the database because it is being used for replication. (Microsoft…
Read More