Monthly Archives: April 2012

Failed Job Issue

Posted on April 24, 2012 by

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

Posted on April 18, 2012 by

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

Posted on April 16, 2012 by

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

Posted on April 12, 2012 by

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 , , , | 3 Comments

Recap SysInternals session #ReLiveTechEdIN

Posted on April 9, 2012 by

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

Posted on April 9, 2012 by

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

Posted on April 4, 2012 by

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

Last Password Change Time for SQL Login Account

Posted on April 4, 2012 by

Yesterday at work, I received an alert from Operations Manager (SCOM) that the password for the SQL Login account in one of instance is expired and need to be changed. While I checked the SQL Server Error Log for that instance, … Continue reading →

Posted in How To, Just Learned, Security in SQL Server, SQL Server | Tagged , , | Leave a comment