Author Archives: Sudeepta Ganguly

About Sudeepta Ganguly

A SQL Server User... Still Learning

Running SQLDiag as Agent Job

Posted on October 31, 2014

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

PowerShell Journey: with 3 Cmdlets !!!

Posted on October 7, 2013

Believe me or not, but that’s true! The time was already passed and we have to run!! I am talking about Learning PowerShell. Although, I am using PowerShell Scripts for quite sometimes, I didn’t pay a lot more attention to … Continue reading →

Posted in PowerShell | Tagged | Leave a comment

SSAS 101 with SQLBangalore User Group

Posted on March 3, 2013

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

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

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

Posted on November 29, 2012

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

Why my Differential Backup was Failing?

Posted on November 17, 2012

In one of the online SQL forum, a forum user reported that, one of their server is scheduled for a weekly full database backup & daily differential database backup. However, during mid of this week, the daily differential job failed … Continue reading →

Posted in Backup - Restore, Jobs, SQL Server | Tagged , , | Leave a comment