Monthly Archives: April 2012

Failed Job Issue


This morning I received a mail from one of our customer stating that a SQL Server job failed many times on last Friday; however, he didn’t receive any notification about it. For a moment, I thought that I had missed … Continue reading

Posted in How To, Jobs, Just Learned, SQL Server | Tagged , , , | 3 Comments

User Mapping With ALTER USER


Yesterday I was working with my colleague to help him with a user-mapping issue. He was migrating a database to SQL server 2008 R2 environment. He restored the database in the new environment from a recent backup and copied all the logins … Continue reading

Posted in How To, Just Learned, Security in SQL Server, SQL Server | Tagged , , , | 2 Comments

Learning, Networking and Community Contribution Award


As of now, 2012 is proven to be great year for me from Learning and Networking prospective. Not only I had an opportunity to attend some of the finest events, but also able to meet many SQL Experts. The first … Continue reading

Posted in Personal, UG Meet | Tagged , | 17 Comments

Restore Database WITH RESTART


Last night, I was migrating a production database  from SQL Server 2005 to SQL Server 2008 environment. While the restoration script was running, failover happened due to a network failure. When the SQL instance started on the other node, all the … Continue reading

Posted in Backup - Restore, How To, Just Learned, SQL Server | Tagged , , , | 5 Comments

Recap SysInternals session #ReLiveTechEdIN


An event, organized by BangaloreITPro & BDotNet user groups on 7th of April,2012, #ReLiveTechEdIN, was indeed a great event to be part of. As mentioned in my previous post, the first session was on Understanding Windows with Sysinternal Tools, which … Continue reading

Posted in SQLPASS, TechED2012, Tools, UG Meet | Tagged , , , | 6 Comments

Database Snapshot 101


Database Snapshot is a feature available with the release of SQL Server 2005 and it is available in Enterprise and Datacenter editions. It provides a transitionally consistent copy of the source database, at the time of the Snapshot creation. Database … Continue reading

Posted in DatabaseSnapshot, How To, SQL Server, TestLab | Tagged , , | Leave a comment

SysInternals n SQLInternals with Vinod Kumar


After #SQLSAT116, now its time for Internals Saturday in Bangalore!!!! Yes, I am talking about the most excitement talk over Facebook since last few days, #ReLiveTechEdIN with none other than Vinod Sir (b|t). In case you didn’t had an opportunity … Continue reading

Posted in SQLPASS, TechED2012, Tools, UG Meet | Tagged , , , | 3 Comments