Vidhya Sagar - Blog

Moving to SQL-Articles.com

Vidhya Sagar — Wed, 22 Jun 2011 09:36:52 +0000

After a long I have decided to move to SQL-Articles.com main website itself instead of having another blog for me. Main website is also owned by me however Sugesh, Deepak , Lexx will also be posting their article. I posted …

What happens when permission is revoked in middle of work?

Vidhya Sagar — Wed, 15 Jun 2011 12:09:25 +0000

This is one of the question asked by my friend and it seems very simple. I had a discussion with him and said that whatever the transaction it has started it will succeeded, however what I told him is not …

What’s happening in Chennai this June?

Vidhya Sagar — Wed, 08 Jun 2011 13:00:27 +0000

Does the title make you to think what’s gonna happen. It’s all related to technical so don’t go out of scope . Coming 18th we have Community Tech days going to happen in Chennai. This time we have 5 sessions …

Tech-Ed India 2011

Vidhya Sagar — Fri, 13 May 2011 17:01:30 +0000

I know this is too late to give a write up on what I learn and enjoyed at Tech-Ed 2011. Tech-Ed is one of the technical education and networking place where lots and lots of technical stuffs are running around …

Troubleshoot backup \ restore issues with trace flag 3004

Vidhya Sagar — Tue, 19 Apr 2011 08:44:00 +0000

I faced an issue during restoration of very large db in our development database \ server. Issue is restoration takes very long time even though we had latest hardware and recent version of SQL Server (it’s SQL 2008 Ent. Ed). …

New SSMS GUI Changes in SQL Server 2011 (Denali)

Vidhya Sagar — Tue, 05 Apr 2011 19:32:50 +0000

I’m just writing this article to provide you the new changes to SSMS GUI available in SQL Server 2011 aka Denali. This article is not more into techie however it will just visualize you the changes made to SSMS GUI …

Chennai SQL Server User Group – 2011 First meet scheduled

Vidhya Sagar — Mon, 14 Feb 2011 05:25:21 +0000

I’m happy to announce that we are back in action on user group after a big break. As you all know Me, Deepak and Sugesh had so many wonderful events & colourful personal life on 2010. Chennai SQL Server user group …

Adding Startup parameter made easy in Denali

Vidhya Sagar — Fri, 14 Jan 2011 14:03:12 +0000

Adding Startup parameter made easy in Denali

Script to Check SQL Server Connectivity

Vidhya Sagar — Mon, 06 Dec 2010 13:11:18 +0000

Use this VB script to check SQL Server connectivity. You can add N number of SQL Server instances to verify it’s status. Usage: Download the sqlserverconnectivity.zip file and extract all the files to a folder Make sure connectivity.vbs, serverlist.txt and …

Configuring Change Data Capture

Vidhya Sagar — Sat, 30 Oct 2010 02:06:53 +0000

In this article I’m going to configure change data capture. I’m going to create a new database and a table for this purpose. Configuring CDC is very simple it’s just a two step process as below Enable CDC for the …