Category Archives: Just Learned

SSAS 101 with SQLBangalore User Group

Posted on March 3, 2013 by

Another wonderful event by SQLBangalore User group, this time, it was with SQL Server Analysis Services. Yesterday, 02nd March, 2013, Bangalore SQL enthusiastic met again to lean about SQL Server Analysis Service. The event was @ Signature Building, Microsoft. My … Continue reading →

Posted in Just Learned, SQL2012, SSAS, UG Meet | Tagged , , , | 6 Comments

Failed Job Notification To Event Log

Posted on February 12, 2013 by

Earlier, I had written a post about a failed job issue. A friend of mine, after reading this post, asked how should he verify the SQL jobs running in his environment without this notification option? By executing the following script, … Continue reading →

Posted in Automation in SQL Server, How To, Jobs, Just Learned, SQL Server, T-SQL | Tagged , , , , , | Leave a comment

Contained Database 102

Posted on December 4, 2012 by

In my previous post, we discussed about Contained database, how we configure the SQL Server instance, how to create a Contained database, contained user creation along with how to connect using Contained user account. In this post, we are going … Continue reading →

Posted in ContainedDB, How To, Just Learned, SQL Server, SQL2012, UG Meet | Tagged , , , , , | Leave a comment

Unable to start SQL Server after relocating TempDB

Posted on November 8, 2012 by

After I modified the file size of tempdb database yesterday on my SQL Express instance, SQL Server was failed to start. When I checked the SQL Server error log, following entries were recorded. 2012-11-07 11:25:34.99 spid10s Error: 17053, Severity: 16, … Continue reading →

Posted in How To, Just Learned, SQL Server, SQL Server Configuration, SQLCMD | Tagged , , , | 4 Comments

Rebuild MSDB Database

Posted on June 19, 2012 by

I had accidentally deleted the transaction log file of msdb database on a newly installed SQL Server 2008 R2 instance yesterday, while I was removing the old tempdb files. Although I normally copy the system database files prior removing the … Continue reading →

Posted in Backup - Restore, Disaster Recovery, How To, Just Learned, SQL Server, SQLCMD | Tagged , , , , , | 2 Comments

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

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

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

Installing SQL Server 2012

Posted on March 14, 2012 by

One of the new feature with SQL Server 2012 is that it can be installed on a Server core machine. For the first time I am installing SQL Server  2012 on a Server core machine. I am using the configuration … Continue reading →

Posted in Deployment, HyperV, Just Learned, SQL Server, SQL Server Installation, SQL2012, TestLab | Tagged , , , , | Leave a comment