Author Archives: Sudeepta Ganguly

About Sudeepta Ganguly

A SQL Server User... Still Learning

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

Unable to start SQL Server after relocating TempDB

Posted on November 8, 2012

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

Boot from VHD

Posted on September 10, 2012

During last user group meeting, we had a discussion on how to install Windows8RP on a VHD, without creating a separate partition. As I find that most of my friends want to try this option, so I thought of writing … Continue reading →

Posted in Deployment, How To, UG Meet | Tagged , | 4 Comments

Hyper-V Exam: My Learning

Posted on September 6, 2012

Earlier, in June, 2012, I had an opportunity to attend a full day event on “Jump Start to Windows 2008 R2 Virtualization Exam 70-659” organized by BangaloreITPro user group & Microsoft. I received a free exam voucher for the certification … Continue reading →

Posted in HyperV, UG Meet | Tagged , | Leave a comment

@PSBUG Inaugural Meet: 2 days 2 Go

Posted on July 25, 2012

I am sure, most of us are aware of this !! The Inaugural meeting of Bangalore PowerShell User Group is scheduled on 28th July, 2012 at the Dell International Services, Intermediate Ring Road, Domlur, Bangalore. The registration will be opened … Continue reading →

Posted in PowerShell, UG Meet | Tagged , | 1 Comment

Rebuild MSDB Database

Posted on June 19, 2012

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