All Articles exnoindex-600x200

SQL SERVER – Plan Caching and Schema Change – An Interesting Observation

Last week, I had published details regarding SQL SERVER – Plan Caching in SQL Server 2008 by Greg Low on this blog. Similar to any other white paper, I have read this paper very carefully and enjoyed reading it. One particular topic in the white paper that caught my attention…
Read More

SQL SERVER – Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet

Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet SQL Server Technical Article Writers: Isaac Kunen Project Editor: Diana Steinmetz Published: July 2008 I recently read this very interesting white paper. I really found it very interesting as this one was one very easy to read and humourous…
Read More

SQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.2

This download package is intended for Microsoft Premier Customers Only. This package includes all of the scoping tools necessary to prepare and qualify your environment to receive a Risk and Health Assessment Program for Microsoft SQL Server. Download Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool…
Read More
All Articles baby-girl

SQLAuthority News – Shaivi Dave – Baby SQLAuthority

Personal

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
All Articles career-gaps-resume-600x400

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