SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP - September 2011 - Blogs

SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP

Hemantgiri S. Goswami is working as a Consultant at Surat, INDIA. He has been a Microsoft SQL Server MVP three years running; he also moderates multiple SQL Server community forums including http://www.sql-server-performance.com and http://www.sqlserver-qa.net. He actively participates and speaks at local user group events organized under the aegis of www.surat-user-group.org, DotNetChaps and CSI Surat chapters, of which he is a founding and active member. He regularly publishes article on his blog space http://www.sql-server-citation.com. He has recently taken up a new initiative - blogging about SQL in his native language Gujarat through his blog http://sqlservercitation-gujarati.blogspot.com. He is an Author of the book SQL Server 2008 High Availability.

Archives: September 2011

workaround for orphaned users

The server principal is not able to access the database under the current security context, is the error message appears for those users who was able to access the database / application earlier especially after refreshing database from production to dev, test or uat enviornment when the correspondent login is…

2 comments, 60 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 27 September 2011

SQL 2008 R2 Administration Cook Book

Couple of week back I have received a special gift, from the person whom I admire as a elder bro and mentor – Satya SkJ. Recently he has written a cook book on SQL Server 2008 R2 Administration, forward written by MVP Brad McGehee, and reviewed by Vinod…

0 comments, 68 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 26 September 2011

CU 16 for SQL Server 2008 SP1

Microsoft has recently released a Cumulative Update (CU) # 16 for SQL Server 2008 SP1 which contains hotfixes which were resolved after SQL Server 2008 SP1; once you will install / apply this CU the server version would be 10.00.2850.00

As always it is recommended that you test this… Read more

0 comments, 87 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 23 September 2011

SQL Server DBA Quiz on BeyondRelational

Friend of my mine and fellow MVP Jecob Sebastian is running SQL Server DBA Quiz 2011 on his community web site – BeyondRelational. He asked me to submit question as a Quiz Master, so, here is my question for you all :

You have an SQL Server Integration Service… Read more

0 comments, 109 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 22 September 2011

SQL Server Wait Types in SQL 2008

While working on an assignment of troubleshooting performance issue few month back I have come across a situation where I have to provide good information about the different waittypes and what they do, while researching a good documentation on wait types I have found the most authentic information on PSS… Read more

0 comments, 77 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 21 September 2011