SQLAuthority News – SQL Server Energy Event with Rushabh Mehta – May 20, 2009

The much-awaited SQL Server Energy Event was successfully held on May 20, 2009 in Ahmedabad. It was jointly organized by Gandhinagar SQL Server User Group (President Pinal Dave – SQL MVP) and Ahmedabad SQL Server User Group (President Jacob Sebastian – SQL MVP). This vibrant event was one of the most interactive, remarkable and enriching events of this year in Ahmedabad. Several factors make this event unique. The main attraction of this outstanding event was Rushabh Mehta (SolidQ Mentor – SQL MVP), an eminent expert in the field of Business Intelligence. Technical session from a legend like Rushabh was an opportunity of a lifetime for SQL Enthusiasts in Gujarat. He absolutely mesmerized the participants with his talk and made the event memorable and a runaway success! Further, the event created networking opportunities between user group members.

Rushabh Mehta is a familiar name in SQL Server community and his expertise in the domain of Business Intelligence is commendable. He is a Mentor for Solid Quality Mentors’ global Business Intelligence division, based in USA. He also holds the position of the Managing Director for Solid Quality India Pvt. Ltd. Rushabh has been vigorously working with Microsoft SQL Server platform since 1998. He has been designing and developing large-scale BI systems since 2001, including predictive-analysis systems, healthcare solutions and a multi-terabyte financial decision support system.

We had expected a huge number of people to show up at the event; however, we had made limited arrangements. We had requested the participants to register in advance to get a guaranteed seat. The session commenced with Introduction to SQL Server Energy Event. I gave introduction in my characteristic humorous style and enlivened the event atmosphere. Everybody rolled into laughter when I started introducing Rushabh using images. The introduction ended on a funny note with some of the most hilarious photographs of Rushabh. If you had attended the session you would know what I am talking about. I believe that attending a session physically is far more helpful! It’s actually the whole experience that makes an event special and memorable!

After a short introduction, Rushabh Mehta started his presentation on Navigating through a turbulent economy with Microsoft Business Intelligence, which is a very useful topic in the current economic scenario. Rushabh in his unique interactive style sprinkled with humor kept  the audience engaged throughout his presentation. In the initial minutes of his talk, he brought everybody’s attention to the global problem of recession. Then he directed his talk to the key concepts of Business Intelligence. There were so many things Rushabh covered; however, one thing that was highly appreciated was “Demo of Gemini.” After the demo was over, questions and answers started to flow and it lasted for another hour. Everybody was so curious and wanted to learn from Rushabh as much as possible within the limited timeframe. Jacob Sebastian gave the final thank you note.

We distributed nearly 30 gifts (T-Shirts, Pen, Books, Hats, to name a few.) during presentation. This time all the participants received something. The very much in demand SQL Server Cheet Sheet was the most popular item at this event. You can now download it from here. Organizing such a large event in a very short duration is very arduous and challenging, but I must thank the host of the meeting Digicorpfor promptly arranging all the necessary logistics. Directors of Digicorp were applauded for their continuous help to User Group. The event was followed up with delicious Indian delicacies.

This event was not recorded and is not available online. Please keep on reading this blog and user goup website for similar events like this. We hope Rushabh visits us again very soon and gives us another outstanding session. Please read my previous article for complete profile of Rushabh and the abstract of  his session.

I had requested Rushabh to do session in my user group when we met last time in USA. Last but not the least, I would like to express my sincere thanks to Rushabh: “Thanks Rushabh for keeping your promise!”

DSC04850 SQLAuthority News   SQL Server Energy Event with Rushabh Mehta   May 20, 2009

Introduction by Pinal Dave

Rushabh Mehta in Action

Rushabh Mehta in Action

Part Audience

Part Audience

MVP discussing BI

MVPs discussing BI

MVP - Pinal, Rushabh, Jacob

MVP – Pinal, Rushabh, Jacob

Abhishek (Digicorp), Rushabh (SolidQ), Pinal (SQLAuthority)

Abhishek (Digicorp), Rushabh (SolidQ), Pinal (SQLAuthority)

Reference : Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Gandhinagar SQL Server User Group Meeting April 24, 2009

We had another successful Gandhinagar SQL Server User Group Meeting on April 24, 2009. In spite of our User Group being just two months old, it received overwhelming warm response from the audience! The meeting once again saw around 50 SQL Server enthusiasts eagerly looking forward to brush up their knowledge and gain some vital tips.

The agenda of the meeting was as follows:

6:30 PM – 6:45 PM – Query Optimization Tricks – Jacob Sebastian
6:45 PM – 7:10 PM – Back to Basics – Pinal Dave
7:10 PM – 7:20 PM – Questions and Answers
7:20 PM – 7:30 PM – Award for “Best Participant”

We had a guest speaker this time – Jacob Sebastian, who is a Book Author and a SQL Server MVP. The meeting commenced with his discussion on Query Writing Style and Local Query Processing Phases where he enthusiastically shared his knowledge with us. Jacob clearly explicated on how query processes its statement. Previously, I had written about on the same subject SQL SERVER – Logical Query Processing Phases – Order of Statement Execution.

DSC03999 SQLAuthority News   Gandhinagar SQL Server User Group Meeting April 24, 2009

I, Pinal Dave (SQL Server MVP), took the meeting further by elaborating on Query Optimization. Next, we had the Questions and Answers round where the best participant was awarded with a gift. This was the most interactive part of the meeting. The discussion was about “SELECT * vs SELECT column names.” As the questions were very simple every attendee was right away interested in answering the questions. This discussion unveiled thought-provoking information about Query Optimization. Another interesting topic that was discussed at the meeting was Database Statistic.

DSC04004 SQLAuthority News   Gandhinagar SQL Server User Group Meeting April 24, 2009

DSC04005 SQLAuthority News   Gandhinagar SQL Server User Group Meeting April 24, 2009

We also had  book giveaway at the end of the meeting. The most demanded book was Microsoft SQL Server 2008 Management and Administration by Ross Mistry.

Overall, the Gandhinagar SQL Server User Group Meeting went marvelously! I express my gratitude to the exclusive sponsor Digicorp for their support and infrastructure. I gratefully acknowledge the support and stimulating discussions of the guest speaker Jacob Sebastian and the SQL Server community here – which went into making this event a success in true sense!

All of you who missed this meeting have certainly missed quite an opportunity. Make sure to read announcement here and attend the meeting next time.

You can check out our information on the launch event SQLAuthority News – Launch of Gandhinagar SQL Server User Group. And if you are regretting for missing the last two events, cheer up! We have more events coming soon. Simply register at http://gandhinagar.sqlpass.org to attend future events.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Launch of Gandhinagar SQL Server User Group

Gandhinagar SQL Server User Group launch event was held on March 27, 2009. This successful, well-attended event received very positive and warm community response. This launch event, unexpectedly, saw over 50 database enthusiasts participating. It was really a moment of pleasant surprise when we ran out of chairs. The otherwise spacious room started getting smaller as more and more people joined in, and unquestionably, we felt ecstatic about it! Visit Gandhinagar SQL Server User Group Portal and register yourself now!

We commenced Gandhinagar SQL Server User Group launch event sharp at 6:30 and completed it precisely at 7:30. During these 60 minutes we conducted intense database discussion, and we had our share of some light moments as well. As this was the very first launch event, I had the privilege of being the sole speaker for all the sessions.

The agenda of meeting was as follows:

6:30 PM – 7:00 PM – Introduction to Joins and Real Life Scenario
7:00 PM – 7:10 PM – Tips to Improve SQL Performance
7:10 PM – 7:15 PM – Simple SQL Quiz (3 Question)
7:15 PM – 7:20 PM – Feedback
7:20 PM – 7:30 PM – Award for “Best Participant” and Questions and Answer

I had a great time discussing Join and I promised users that I will definitely be sharing some of my slides and scripts from the meeting with everybody. Click here to download slides and script.

One of the requests I received was to write down a simple and precise definition of Joins. I was quite taken aback to see that Joins are still a subject of interest for developers. I am seriously considering this request. To all those developers wanting to get insight into Joins I promise that I will soon come up with a write-up on Introduction to Joins.

I shared some tips on SQL Server performance improvement and even conducted an interesting and informative quiz round. UG members who gave correct answer to the questions received nice gifts. The best part of the event was giveaway of gifts to the participants near the end when everybody was really involved. The gifts included a vibrant red shirt and few other interesting gifts for the best participants. These Gifts were co-sponsored by Digicorp and me.

Here are a few photographs of UG meeting.

MarchUG5 SQLAuthority News   Launch of Gandhinagar SQL Server User Group

MarchUG3 SQLAuthority News   Launch of Gandhinagar SQL Server User Group

MarchUG2 SQLAuthority News   Launch of Gandhinagar SQL Server User Group

MarchUG4 SQLAuthority News   Launch of Gandhinagar SQL Server User Group

MarchUG6 SQLAuthority News   Launch of Gandhinagar SQL Server User Group

MarchUG7 SQLAuthority News   Launch of Gandhinagar SQL Server User Group

MarchUG SQLAuthority News   Launch of Gandhinagar SQL Server User Group

My heartfelt thanks go to the sponsor of this event – Digicorp – for their significant contribution to make this event a success. They were extremely prompt in making the last minute arrangements, especially arranging for more chairs for the room which was brimming with participants. Digicorp is a prominent IT service provider and an outsourcing company based in Ahmedabad, India. Its services range from Customized Application Development to Facebook Application Development.

To sum up, I would like to say that there are many advantages of User Group meetings. The prominent advantages are ‘Gaining Knowledge’ and ‘Sharing Knowledge’, which will surely add value to you as a professional or as a knowledge seeker.

Next time, I will be expecting a similar overwhelming response and even more participants to show up in UG meeting.

Reference : Pinal Dave (http://blog.sqlauthority.com)