Chennai SQL Server Users Group

November Month UG Scheduled

2009-11-14T21:51:00.002-05:00

Folks,

As you all aware that we have moved to http://www.chnsqlug.co.cc website. We have scheduled November month meeting.. Here is the link

November Month UG session scheduled http://is.gd/4VdMu

We have Moved to New Website

2009-10-27T09:59:00.001-04:00

We have moved to a new website. Going forward please visit www.chnsqlug.co.cc link for further updates on Chennai SQL Server User group.

Thanks

September month UG meeting presentations

2009-09-25T08:16:00.005-04:00

As always conducting our 3rd User group meeting was a real fun and we thoroughly enjoyed it. The other main aspect of this meeting was that we had twice the number of people than it was for the previous UG meeting. Yes, we ended up with 21 members and conference room was completely full. I would like to thank each and every one of you for attending this meeting and making it a fun filled technical event.
There were two sessions that were taken namely,

#1. Introduction to Indexes & Effective Indexing

Speaker: Deepak Rangarajan
Duration: 90 minutes

Discusses about Indexes and Index types. What are the important index operators to look for while tuning a query. How to cover a query with indexes and avoid lookups & a glance at the SQL Server execution plan.

Download presentation on Indexes & effective Indexing

We had refreshments for 15 minutes within which we discussed about PASS, benefits of registering with PASS, resources available at PASS and about PASS summit. We even had a group photo with our UG members.

#2. Data compression & Effects of Auto-shrinking

Speaker: VidyaSagar
Duration: 75 minutes

What is data compression, when and where can it be used. What are the underlying algorithms being used while compressing data etc..Finally the discussion was about Auto shrinking and its effects on a OLTP production machine during bussiness hours etc.

Download presentation on Data compression & Effect of Auto-shrinking

We'll be having our next month UG most likely on October 24th 2009. Once we get the conference room confirmed we'll let you know.

Registration for September 19th UG session

2009-09-13T13:47:00.005-04:00

We are back again for this months UG session. We have a slight change in timing for this week UG due to non-availability of conference room at our usual timings.

Venue: Microsoft Training centre, Radhakrishnan Salai
Landmark: Opposite to President hotel
Timings: 9:30AM to 12:30PM
Date: September 19th 2009

Please register for the sessions using the following URL,
http://spreadsheets.google.com/viewform?formkey=dHp0YkVrT3lkbnJFM3VLUndCMkIxbWc6MA..

Session details are as follows:

#1. Introduction about Indexes and Effective Indexing

Speaker - Deepak Rangarajan
Duration - 90 minutes

Most of the DBA's who are involved in performance tuning need to know when to use an index and what type of index will be helpful for a query. This session will covers about what is an index and index types etc. When to use which index and how can we effectively use an index to cover a query. Difference between an index seek, scan etc and a glance through the SQL Server execution plan.

We'll have a 15 minute break and refreshments will be provided by us.

#2. Data Compression & Effects of Auto-Shrinking

Speaker - Vidhya Sagar
Duration - 75 minutes

How is compression done internally, what type of algorithms are used etc are covered. Along with that we'll be covering another topic named Auto-Shrinking and whats the effect of this setting on the database.

Contact persons:

Vidya Sagar - kvs1983@gmail.com
Deepak - deepak.rangarajan@gmail.com

Chennai SQL Server UG August presentation

2009-09-02T20:20:00.001-04:00

The Chennai SQL Server UG for the month of August was held on 22nd of this month, refer this link for the details. It was a great learning experience. There were two sessions.

#1. Introduction to Change Data Capture

Speaker: Deepak Rangarajan
Duration: 60 minutes

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.

#2. Transparent Data Encryption

Speaker: VidyaSagar
Duration: 60 minutes

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 I'll blog about it. In the forthcoming sessions we are planning to cover something on the performance as well.

Meeting Details - Aug 22th 2009

2009-08-16T04:32:00.003-04:00

Date: Aug 22th 2009 3PM till 530PM

Venue: Microsoft Office
Radhakrishnan Road
Chennai

Registration: http://spreadsheets.google.com/viewform?formkey=dF9JUHZNNDlQQ1FtWTVGRS16dGVIR3c6MA..

Agenda:

Sessions:

Title: Change Data Capture

This session would take you intoindepth look up what is a new feature in SQL Server 2008, Change Data Capture(CDC). Are you interested in tracking when and how your data is changed then give time to get into this session to learn how to do it.

Speaker: Deepak Rangarajan
Time: 45 Mins

Title: Transparent Data Encryption

The speaker would be covering Transparent Data Encryption(TDE), this is a interesting topic for DBAs who would like to have thier data protected from being known to known and unknown sources. Have you ever tried of encrypting data? If not, you can value your time attending this session.

Speaker: Vidhya Sagar
Time: 60-75Mins

Note: Refreshments will be provided

Contact Persons:

Vidhya Sagar – kvs1983@gmail.com
Deepak Rangarajan - deepak.rangarajan@gmail.com

Virtual TechDays: FREE Technical Training Opportunity

2009-08-13T07:21:00.000-04:00

Microsoft is Offering Free SQL Server and other products Techinical training in India. This is an online event. Please use the link below to register.

Click Here to Register

Free Training from SQL PASS for 24hours

2009-08-06T21:23:00.001-04:00

PASS is organizing for a 24 hours free SQL Server training using Live Meeting on Sep 2^nd 2009. Please register to get benefits of the same. The registration can be done on 24hourssqlpass

Chennai SQL Server User Group Meeting

2009-07-30T09:31:00.003-04:00

We had a great experience in conducting the first Chennai SQL Server User Group meeting on 25th July 2008. We had the following sessions:

1. Introductory session about PASS - 30 minutes
Speaker: Deepak Rangarajan
Download the presentation

2. New features in SQL Server 2008 - 70 minutes
Speaker: Vidhya Sagar
Download the presentation

There was a 15 minute break between the two sessions with refreshment being provided by us.

The entire session was held at Microsoft campus in Chennai. We are thankful to our MVP lead Abhishek Kant for providing us the conference room(capacity 20) at Microsoft. Unfortunately, we were not allowed to take any photographs within the campus. There are some formalities so we are planning to discuss it with our MVP lead and get it fulfilled before the next user group meeting.

We are planning to conduct such User group meeting once a month, preferably in the 3rd Saturday of every month. People who are interested can join us, please visit http://sqlpass.org/ and register (free membership) at PASS. While registering please select the associated user group name as Chennai SQL Server user group.

We would like to take this opportunity to thank all those who made it to the meeting. A special thanks to Jacob Sebastian, who encouraged us to start this User group.

We took a group photo just outside the Microsoft Office in Chennai after completing our session.

SQL PASS Trip Announcement for User Groups

2009-07-21T18:04:00.000-04:00

Team,

We wanted to let you know Idera and MSSQLTips are sponsoring an all expenses paid trip from the continental United States to Seattle, Washington to attend the SQL PASS Community Summit in November 2009.

http://www.mssqltips.com/pass_giveaway_entry.asp

Meeting Details - July 25th 2009

2009-07-13T12:57:00.004-04:00

Date: July 25th 2009 3PM till 530PM

Venue: Microsoft Office
Radhakrishnan Road
Chennai

Registration: http://spreadsheets.google.com/viewform?formkey=dF9JUHZNNDlQQ1FtWTVGRS16dGVIR3c6MA..

Agenda:

Sessions:

Title: Introduction to Chennai SQL Server User Group and PASS

This session would take you into introducing the User Group, its members, PASS and how this group is associated with PASS. The benefits of being enrolled in PASS.

Speaker: Deepak Rangarajan
Time: 30-45 Mins

Title: New Features in SQL Server 2008

The speaker would be covering all new features of SQL Server 2008 exclusively for DBAs, new features for developers, BI professionals will also be touched.

Speaker: Vidhya Sagar
Time: 60-75Mins

Note: Refreshments will be provided

Contact Persons:

Vidhya Sagar – kvs1983@gmail.com
Deepak Rangarajan - deepak.rangarajan@gmail.com

And Here we go...................

2009-07-10T08:15:00.001-04:00

The first User Group Meeting of Chennai SQL Server Users group will be held in the Microsoft Office on 25th July 2009. The details of the venue and the meeting agenda will be published soon here. Please keep checking for updates.

Register with PASS

2009-06-29T06:38:00.003-04:00

Team,

Please register yourself with PASS http://www.sqlpass.org/ to get the benefits of being a PASS member of this User Group. While Registering please mention that you are part of Chennai SQL User Group.

PASS Registered

2009-04-14T10:05:00.001-04:00

We are officially registered with Professional Association for SQL Server(PASS). You will get updates on the PASS information shortly here. Please keep visiting the blog for more updates.

Launching Chennai SQL Server User Group

2009-04-03T21:58:00.001-04:00

All,

I am proud to Announce that today we are launching Chennai SQL Server Users Group shortly tagged as "CSSUG". There would be more events, posts and discussions from members of the group.