Monthly Archives: August 2009

Chennai SQL Server User Group – August Month Meeting

Chennai SQL Server User group august month meeting was held on 22nd. This time we had less number of users attended the session since we had confirmed this meeting in the last minute as we were waiting to book the conference room. It was a nice experience meeting every SQL enthusiastic users in the group. I and Deepak took the following session in the meeting. I’m publishing the presentations used for meeting, you can download it and make use of it.

*) Introduction to Change Data Capture

Speaker: Deepak Rangarajan
Duration: 60 minutes
Download the presentation

cssug-aug-1

You can download the presentation for Change Data Capture along with the scripts with which we showed the Demo. Please feel free to let us know your thoughts/feedback.

We had a 15 minute break where refreshments were provided by us.

*) Transparent Data Encryption

Speaker: Vidhya Sagar
Duration: 60 minutes
Download the presentation

cssug-aug-2

You can download the presentation for Transparent Data Encryption along with the scripts with which we showed the Demo. Any feedback is most welcome.

Thanks to our MVP lead, Abhishek Kant who helped us in getting the required permissions to take photographs of our presentations.

cssug-aug-3

We’ll probably have our next UG on the September 19th 2009. Once the dates are confirmed we will blog about it. In the forthcoming sessions we are planning to cover something on the performance as well.

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

How to do Table Partitioning to an existing source table

In this article we are going to see how to partition a existing table in a database. In my working place I got a request from client to partition an existing table, I have searched in BOL but couldn’t find the exact detail how to do it. I’ve figured out that and Implemented successfully, I’m Just sharing the steps with you so that this might be helpful to you.

To show this with an example I would like to do the steps below

  • Create a table and populate the data first
  • Create the partition Function
  • Creation the partition Scheme
  • Create Clustered index on the table using the partition scheme to move the data’s to the partitions

Applies to

  • SQL Server 2005
  • SQL Server 2008

Read more »

VN:F [1.9.13_1145]
Rating: 5.0/5 (2 votes cast)
VN:F [1.9.13_1145]
Rating: +2 (from 2 votes)

Installing SQL Server Reporting Services 2008

In this webcast we are going to install SQL Server reporting services 2008. Watch the video and post your feed back in our discussion board.

Play Video

Download the Video in Good Quality

File Size : 11.2 MB
Video Size: 800 x 600
Duration  : 11:38 min

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