Yesterday I and Deepak have presented “SQL Server Query tuning” topic in Community Tech days. Community TechDays is a 11-city Roadshow conducted by the technology community in India on a quarterly basis for Developers, Infrastructure Professionals, Architects, Project Managers and Students.. This is the second time they have conducting this event. We have huge number of audiences compared to last time. Almost 1000 registrations were done and we got 400 participants right there. It was a good experience meeting everyone and we had a nice time. Most of them requested us to post the presentation and scripts in our websites, so I’m sharing the content with you folks. Please feel free to contact us if you have any concerns or comments 
. Hopefully we are expecting everyone in the next community tech days .
Category Archives: General - Page 5
Presenter at Community Tech Days (CTD)
Presenter – Chennai SQL Server User Group September Meeting
This month Chennai SQL Server User group (CSSUG) meeting was held on 19th September at Microsoft Campus, Chennai. It was a good experience meeting everyone and we had a nice time. I and Deepak Rangarajan are the presenters for CSSUG, we had the below sessions. We would like to thank each and every one of you for attending this meeting and making it a fun filled technical event. Read more »
Running Adhoc queries against multiple servers using SSMS 2008
Getting information from multi servers for a query is a big process for DBAs and we don’t have a direct option available till SQL 2008 Client tools. We need to write our own manual batch file to execute the query against all the server to fetch the information. In SQL Server 2008 management studio MS team has introduced this in SQL Server management studio 2008.
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
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
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.
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.
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