Ahmedabad SQL Server User Group – April Meeting (18 April 2009)

I would like to invite everyone to the April Meeting of Ahmedabad SQL Server UG. We will meet tomorrow (Saturday, 18 April 2009) at our new office, 302 OLIVE ARCADE, OPP Samudra Anexe, OFF CG Road, Ahmedabad at 6 PM.

This month, we will discuss the XML features of SQL Server 2008 and as usual will have a QA session to discuss general SQL Server Topics. We will also discuss the community plans for the upcoming Tech-ED India 2009 and the discount options for the UG members. There will be some give-away items in addition to the usual ice-cream and snacks :-)

Hope to see many of you tomorrow!

Ahmedabad SQL Server User Group: February 2009 Meeting

I am a little late to post details of the UG meeting held on 21st February 2009, and I feel bad for keeping you waiting for so long. I was busy finishing some assignments at work. I am flying to Seattle tomorrow to attend the MVP Global Summit. I hope I will have a great time meeting other SQL Server MVPs and many of the SQL Server Team members.

Coming back to the UG meeting, we really had a wonderful time discussing many of the basic SQL Server questions. Pinal Dave has already posted a very detailed blog post covering the activities. He did a wonderful session where he presented some very interesting points related to the way SQL Server Query Optimizer uses indexes.

My session was more of an interactive discussion. While writing my series of posts on SQL Server IDENTITY columns, I came across several interesting questions and I then compiled a long list of 65 questions. We discussed those 65 questions and their answers and the 'why-how' part of each of them. I will create a PDF document with those questions and will make them available for download.

Here are some photographs:

Pinal Dave

Jacob Sebastian

Group Photo

Ahmedabad SQL Server User Group Meeting Tomorrow (21 Feb 2009)

I would like to invite everyone to the FEB 2009 meeting of Ahmedabad SQL Server User Group. As usual, we will meet at 401, TIME SQUARE, CG ROAD, AHMEDABAD. We have adjusted the meeting time a bit so as to start by 6.15 PM and end by 7.30 PM. This is to help people coming from far-off places.

We will have two sessions this month (in addition to ICE Cream and a TECHNET SUBSCRIPTION).

The agenda of meeting will be as following.

Working with IDENTITY values in SQL Server - Jacob Sebastian (SQL Server MVP)
Interesting Observation - SQL Server Index Usage - Pinal Dave (SQL Server MVP)

More details about the UG meetings are available at http://ahmedabad.sqlpass.org/

Ahmedabad SQL Server UG - January 2009 Meeting (Jan 17, 2009)

Ahmedabad SQL Server UG had the first UG meeting of 2009, yesterday. We discussed a number of interesting topics and I am pretty sure everyone enjoyed the sessions.

I had been presenting a series of sessions on 'SQL Server Query Optimization Basics' in the past few sessions and presented 'SQL Server Query Optimization Basics -  Part 3' Yesterday. We discussed Query Plan Caching in much detail.

For those of you who missed the sessions, I started writing a series of blog posts that covers all the points we discussed in the previous sessions. You can find the first blog post here. I will add a number of follow up posts soon.

Pinal Dave, SQL Server MVP and Vice President of the UG, presented an interesting session on 'Understanding indexes and sorting'. Pinal will post more details about this and will upload the presentation soon on his blog site.

Imran Bhadelia did a wonderful presentation on the MERGE keyword introduced by SQL Server 2008. This initiated a number of interesting discussions where the performance differences, triggers, capturing the output of the operation and usage of XML were discussed.

Jacob's Presentation

Pinal's Presentation

Imran's Presentation

Group Photo

News: UG Meeting (Oct 2008)- Ahmedabad SQL Server User Group

Today is 3rd saturday of the month

and this day is bit special for the

members of Ahmedabad SQL Server UG. As usual

we have the monthly meeting today

and I would like to welcome everyone

to the event. I will be speaking on

Query Optimization today.

See http://ahmedabad.sqlpass.org/ for details.

Click to join Ahmedabad_SQLServer_UserGroup

News: "SQL Hour" at Patni Computer Systems (4 Oct 2008)

Ahmedabad SQL Server User Group has started organizing a special event, "SQL Hour", where we visit IT companies and interact with the SQL Server professionals. We had the first meeting this Saturday, 4th October 2008 at Patni Computer Systems, Gandhinangar.

The meeting lasted for 2 hours and it went very interesting. People were very responsive and came up with a number of questions that initiated new discussions on various interesting topics. Pinal presented an interesting session titled "Know your SQL". His presentation was followed by mine, on "Query Optimization Basics".

"SQL Hour" at Patni was very productive, very interesting and we are very much happy about it. If you are interested to host "SQL Hour" at your company, contact us and we will be happy to meet you.

"Query Optimization Basics" by Jacob

"Know your SQL" By Pinal

News: Ahmedabad SQL Server UG Meeting - Yesterday, 20th September 2008

We had a wonderful time discussing various SQL Server related topics, yesterday. The primary attraction was an excellent session by SQL Server MVP, Pinal Dave, on CTE (Common Table Expressions). He explained CTE in great detail, discussed the cases where a CTE can help and initiated a wonderful discussion on recursive CTE.

His session was followed by a short presentation by me on a few real life examples of Recursive CTE. We discussed the internals of recursive CTEs in a bit detail. We took the execution plan of a recursive query (that uses a CTE) and discussed how the query processor might actually be doing the recursion. Then we did a TSQL demo that performs similar operation (that the query processor does with a recursive query) using a WHILE loop.

It was a great time interacting with a lot of SQL Server professionals and a few people raised questions that initiated interesting discussions on various SQL Server topics.

 

For those of you who missed the UG meeting, there is nothing to download/replay, other than the following photographs :-)

[Keep a watch on pinal's website for the slides and demo scripts]

My welcome speech

Well, Samir took the photo from behind. Next time, I will ask him to take it from the front side.

ditto

Pinal's presentation on CTE

This week we did not miss the group photo after the sessions.

I thank everyone for making it a memorable event.

News: Ahmedabad SQL Server User Group meeting - Tomorrow (Saturday, 20th Sept 2008)

Inviting every one to the UG meeting of Ahmedabad SQL Server User Group on Saturday, 20th September 2008!  Ahmedabad SQL Server User Group  is an official PASS Chapter.

The UG meeting will be held at Excellence Infonet, 401, TIME SQUARE, Opp. Bazar Calcutta, CG Road, Ahmedabad, 380006. The meeting will start at 6.30 PM and usually will last up to 8.30 PM.

SQL Server MVP, Pinal Dave will present a session on Common Table Expressions (CTE). Last month we discussed Transaction Isolation Levels. If you missed the session, you can read it here.

Hope to meet you tomorrow at the UG meeting :-)

Click to join Ahmedabad_SQLServer_UserGroup

Subscribe to Ahmedabad_SQLServer_UserGroup

Powered by us.groups.yahoo.com

News: Ahmedabad SQL Server UG Meeting on Saturday, 30 August 2008.

The UG meeting of Ahmedabad SQL Server User Group will be held on Saturday, 30 August 2008 and I would like to invite all of you to the event. I will post the details of the sessions in the next couple of days. Keep a watch on the UG web site http://ahmedabad.sqlpass.org/ for updates.

Click to join Ahmedabad_SQLServer_UserGroup