Author Archives: Vidhya Sagar - Page 2

New SSMS GUI Changes in SQL Server 2011 (Denali)

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 in .SQL 2011 I’ll update this article whenever I see a new change in SSMS GUI

Read more »

VN:F [1.9.13_1145]
Rating: 4.0/5 (1 vote cast)
VN:F [1.9.13_1145]
Rating: +1 (from 1 vote)

Chennai SQL Server User Group – 2011 First meet scheduled

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 is been utilized by many of the DBA’s & DEV’s in and around Chennai. This time we added one more speaker for BI, so BI folks, register yourself and attend the session for free. We thank Ayyappan Thangaraj & RamiReddy for voluntering themselves as speakers. Check http://sql-articles.com/cssug/march-2011-ug-meet-scheduled for more information for UG meet. Happy to see you all again :-)

VN:F [1.9.13_1145]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.13_1145]
Rating: 0 (from 0 votes)

Adding Startup parameter made easy in Denali

You folks might have already know that a new version of SQL Server is on the way to market. Right now beta version of SQL Denali (aka SQL Server 2011) is released. In this version addition of startup parameter is made easy and effort less. In previous version we will be adding it in a text box separating each entry with semi colon(;) .  There is a chance that we might miss that semi colon and it will result in SQL server startup failure. To over come this in this version they have made it simple by adding the parameter in a list. To add or modify startup parameter try the below steps

Read more »

VN:F [1.9.13_1145]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.13_1145]
Rating: 0 (from 0 votes)

Script to Check SQL Server Connectivity

Use this VB script to check SQL Server connectivity. You can add N number of SQL Server instances to verify it’s status.

Read more »

VN:F [1.9.13_1145]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.13_1145]
Rating: +1 (from 1 vote)

Configuring Change Data Capture

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 database
  • Enable CDC for the required tables

Read more »

VN:F [1.9.13_1145]
Rating: 3.0/5 (3 votes cast)
VN:F [1.9.13_1145]
Rating: 0 (from 0 votes)