Sidd's SQL Solution

Hi There, Looking for the index maintenance script. A new, smarter database index maintenance script has been created and is available on this "link" .  The new script has all the existing advantages like selecting type of maintenance based on level of fragmentation etc. along with some new improved functionality like support to mirrored database. Please follow the link above to get to the right post and script. Thank you very much for following this blog.

Coming back to my blogs nearly after 3 action packed months with another interesting topic (I hope), which is on a common WMI error which haunts many DBAs. In a DBA's lifetime, he\she has changed SQL services account and\or its password at-least once and many of us may agree that they have faced "WMI Provider Error - Access is Denied" error while changing the password using "SQL Server Configuration Manager". So, for those of us who are still looking for clues, let us try to understand what happened here with an example:  Let's assume that you have joined an organisation and where they have "CompDomain\SQLsrvAccount" fixed domain account under which all your SQL Services runs. Now, a new security policy have been enforced according to which you have to recycle\change your password (due to any condition). Now, you've the new policy perfect password in your possession along with planned maintenance down-time, you went to the server ope