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
Saturday, November 14, 2009
Tuesday, October 27, 2009
We have Moved to New Website
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
Friday, September 25, 2009
September month UG meeting presentations
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
There were two sessions that were taken namely,
#1. Introduction to Indexes & Effective Indexing
Speaker: Deepak Rangarajan
Duration: 90 minutes
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.
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.
Sunday, September 13, 2009
Registration for September 19th UG session
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
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
Wednesday, September 2, 2009
Chennai SQL Server UG August presentation
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.
#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.
Sunday, August 16, 2009
Meeting Details - Aug 22th 2009
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
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
Thursday, August 13, 2009
Virtual TechDays: FREE Technical Training Opportunity
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.
Subscribe to:
Posts (Atom)
