Author Archives: Sudeepta Ganguly

About Sudeepta Ganguly

A SQL Server User... Still Learning

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 , , | Leave a comment

PowerShell Journey: with 3 Cmdlets !!!


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


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

Why my Differential Backup was Failing?


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