Tag Archives: Just-Learned

Availability Group Listeners Creation Issue

I must admit, that I was facing this issue since a while. I was trying to setup a lab to have a hands on with AlwaysOn feature; however the Availability Group Listeners creation was failing. As I started looking into … Continue reading

Posted in AlwaysOn, How To, Just Learned, Setup LAB, SQL Server, SQL Server Configuration, SQL Server HA, SQL2012, TestLab | Tagged , , , , , , | Leave a comment

CHECKDB Failed with 7926 error

During this weekend, I was working on a weekly maintenance job failure issue, where I came across the error 7926. This was the first time I encountered this error. The below error was reported in the job output file: Msg … Continue reading

Posted in DatabaseSnapshot, Jobs, Just Learned, SQL Server | Tagged , , , | Leave a comment

Running SQLDiag as Agent Job

This was the discussion of last evening, which was started after we receive a similar request from a specific team. The team wanted to start this trace by themselves without involving the DBAs. One of the possibility was to run … Continue reading

Posted in Automation in SQL Server, How To, Just Learned, SQL Server Tools | Tagged , , | 1 Comment

SSAS 101 with SQLBangalore User Group

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

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

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

Contained Database 101

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 ContainedDB, How To, SQL Server, SQL2012, UG Meet | Tagged , , , , , | 5 Comments