Tag 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 UG Meet, Just Learned, SQL2012, SSAS | 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, SQL Server, How To, Jobs, Just Learned, 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 SQL Server, How To, UG Meet, Just Learned, SQL2012, ContainedDB | Tagged , , , , , | Leave a comment

Contained Database 101

Posted on November 29, 2012 by

Although it looks like an individual entity, a database in SQL Server is tightly integrated with the SQL Server instance. Every time we move an user database from one instance to another, a series of steps follow, which includes transfers … Continue reading →

Posted in SQL Server, How To, UG Meet, SQL2012, ContainedDB | Tagged , , , , , | 5 Comments

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 SQL Server Configuration, SQL Server, How To, Just Learned, 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 Disaster Recovery, Backup - Restore, SQL Server, How To, Just Learned, 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 SQL Server, How To, Jobs, Just Learned | 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, SQL Server, How To, Just Learned | 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 Security in SQL Server, SQL Server, How To, Just Learned | Tagged , , | Leave a comment