Monthly Archives: October 2009

Creating Maintenance Plan with Maintenance Plan Wizard in SQL Server 2005


In this post, we will discuss how to create Maintenance plan in SQL Server 2005. The environment is having SQL Server 2005 SP3 installed. Before creating the maintenance plan in the lab environment, let’s see our requirement. Maintenance Plan Details … Continue reading

Posted in Automation in SQL Server | Leave a comment

How to Transfer Logins from one SQL server instance to another SQL Server instance?


It is one of the common question, which we can expect during any SQL Server interview: “How should you transfer logins from one instance of SQL Server to another?” The answer is pretty simple, however, its very complicated as well. … Continue reading

Posted in Security in SQL Server | 6 Comments

Dedicated to My Father


My father, Late Mr. Uttam Kumar Ganguly, was a System Administrator with State Bank of India. This blog is my tribute to my father……

Posted in Personal | Leave a comment