SQLAuthority News – Two SQL Sessions at SQL Data Camp at Chennai – July 17, 2010

I will be presenting two SQL Server advance level sessions at SQL Data Camp @ Chennai.

I am very excited for this event as I am going to meet my friends Sugesh, Deepak, Vidhya and Madhivanan at this event. All of them are SQL Server MVPs. I have come to know that there are two other SQL Server MVPs – Madhu andVenkatesh are also joining the event as speaker. This is going to be one mega fest as so many of SQL Server MVPs are going to be present at same place. The event is going to be world-class event and there is no doubt about the same.

I am very much looking forward to this event on July 17, 2010. The event venue is  Hotel Palmgrove, Vaishali Banquet Hall, 5, Kodambakkam High Road, Chennai – 600034 Tamil Nadu, INDIA.

I will be speaking on following two sessions at the event. I am very excited as Chennai is one of my favorite city and always love to visit the same. I am very glad that both the sessions which I will be doing are on Indexing and Performance Tuning. I love to talk about Index and Performance Tuning.

Spatial Database & Spatial Indexing

Speaker : Pinal Dave
Event Date : 17th July 2010
Session Time : 09:45 to 10:45

Microsoft SQL Server 2008 delivers new spatial data types that enable you to consume, use, and extend location-based data through spatial-enabled applications. Attend this session to learn how to use spatial functionality in next version of SQL Server to build and optimize spatial queries. This session outlines the new geography data type to store geodetic spatial data and perform operations on it, use the new geometry data type to store planar spatial data and perform operations on it, take advantage of new spatial indexes for high performance queries, use the new spatial results tab to quickly and easily view spatial query results directly from within Management Studio, extend spatial data capabilities by building or integrating location-enabled applications through support for spatial standards and specifications and much more.

Good, Bad & Ugly – The other side of Index

Speaker : Pinal Dave
Event Date : 17th July 2010
Session Time : 15:00 to 16:00

Index is often considered as the sure shot tool of improving the performance of any query. Learn the secrets of Indexing with examples and discover the good, bad and ugly sides of Index. This session will help you efficiently write queries in future as well make you go back and defector your earlier code.

I have presented above two sessions earlier as well but for this one specially I have created new demos and they are going to be very interesting. If you are in Chennai, I strongly suggest that you all attend this event, we are really going to do one great event.

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

About these ads

SQLAuthority News – I am a MVP and I Love SQL Server

I am very glad that I received this prestigious award for the third time in a row. I am very thankful to Microsoft for introducing this wonderful technology of SQL Server. I enjoy getting involved with the community, which also helps in my self-improvement as well. I would like to take this moment to thank all my friends, readers, session attendees, MS Product Teams, MVP Program and my Organization for the constant support and encouragement.

There are few questions that I often receive about the MVP program. Today, I will answer them in brief.

Microsoft MVP Logo
Microsoft MVP Logo

Question: How can I become a Microsoft MVP?

Answer: I suggest you read the official Microsoft FAQs on the subject here. After reading the questions and answers, if you still have any queries, you can send an email to the email address mentioned at the bottom of the FAQ page.

Question: What should I do to become a MVP?

Answer: In fact, I cannot remember anything specific to be done to become an MVP – importantly you should be dedicated to the community and working sincerely for it. MVP nomination will happen when it is the time if all your intentions are in the right place.

Question: What exams do I need to take to become a MVP?

Answer: This is not a certification; it is an award. Work with the community and do your best; you will be surely nominated by vigilant members of this community.

Question: How did you become a MVP? Please give me further details.

Answer: I have list of the community events I conduct. Please read them all at my Community Engagement page. Additionally, I blog on SQL Server; here you can find my list of All Articles.

Question: Are you a Microsoft Employee?

Answer: No, I am not Microsoft Employee or neither do I receive any kind of compensation. However, Microsoft supports you every possible way for spreading your love for technology.

Question: Will you nominate me for the MVP Award?

Answer: You can nominate yourself too. Read the FAQs.

Again, I am very glad that I have received the MVP award. Many thanks to Microsoft for supporting the community.

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

SQLAuthority News – Meeting Bryan Oliver and Learning Wisdom of Life

During my most recent travel outside India, I was fortunate enough to meet Bryan Oliver. I have heard a lot about him but never had chance to meet him in person. Just like we all do for someone we never met before, I had already some preconceived notions about him. I assumed that he might be someone who will be quite proud about his knowledge with 20+ years of experience in the industry. I was also not expecting a very friendly approach as he was quite older than me. I am sure by now that all of you might have guessed my experience with Bryan. Bryan Oliver is, in fact, an extremely friendly and knowledgeable person. If you are meeting him for the first time, I am sure that you will feel that you know him from many years.

Bryan is from Solid Quality Mentors, Australia, and pretty much works all over the world. He has a gargantuan experience in SQL Server, Business Intelligence and Data warehousing projects. He is also involved in many large-scale projects. Bryan blogs at http://www.sqlbloke.com and does not hesitate to write on unconventional topics. His writing also covers any SQL-related topic. There are many things one can learn from Bryan.

Bryan is very patient trainer. I have observed that during his training sessions, he never looses his control over the class. He explains things very politely and does not get irritated if someone asks the same question again and again. In fact, I have learned from him how to handle some unexpected queries, which I shall talk about later. Bryan has very interesting style of teaching courses. First, he covers all those points that are slightly dry in the course; in this way, the course always seems to proceed better and effectively holds the interest of the attendees. In his class, there are no frills or dramatic shows. He covers the course very easily without any gimmick. His personality and way of training reminds people of the way they studied when they were in primary school. When I was in grades 1 to 5, I hardly worried about the class, I had no responsibility, and I used to walk in the class without any pressure to study all the time. It was my teacher who took the major responsibility to teach me and make me learn. Bryan teaches the same way; he takes the complete responsibility of teaching on his shoulder and makes sure that everyone learns the technology perfectly.

Bryan and I spent couple of days together discussing various topics. I had great time learning SQL from him. In fact, after meeting him, I was fortunate to know about so many things, which he effortlessly explained to me. If I have to work now with a Data Warehousing project, I can perform much better than I used to do before. I feel like going back to all of my previous customers and requesting them to allow me to have one more look at their system and configuration. May be with newly acquired knowledge, I can work on their system to perform quite better than before.

There is one thing which Bryan and I agree upon equally: Respect for Greg Low, Rushabh Mehta and Itzik Ben-Gan. We both think that these wonderful SolidQ mentors have contributed a lot to the SQL Community and are expected to do so in future. We talked about religion, cultures, life, and kids. I have a daughter and even Bryan also has one; so we could not stop talking about our kids. Bryan gave me few tips on how to raise kids as well. There are a few tips, which are always true irrespective of one’s geographical location. We had a wonderful dinner together at Australian Restaurant, and my journey of learning was not yet over. I again got to learn a lot about food, wine and even world peace!

I must say that the world will be a better place to live in if we are lucky enough to come across more people like Bryan.

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

SQLAuthority News – Professional Development and Community

I was recently invited by Hyderabad Techies to deliver a keynote for their 16-day online session called TECH THUNDERS. This event has been running from May 15 and will continue up to the end of the month May 30). There would be a total of 30 sessions. In every evening of those 16 day, there will be either one or two sessions from several noted industry experts. It is the same group which has received the Microsoft Community Impact Award as the Best User Group in India as for developers.

I have never talked about Professional Development before. Even if this was my first time to do so, I still accepted the wonderful challenge for the sake of the thousands of audience who were expected to attend this online event. Time is of the essence; I had 15 minutes to deliver the keynote and open the event. The reason why I was nervous was because I had to cover precisely only 15 minutes- no more, no less. If I had an hour, I would have been very confident because I knew I could do a good job for sure. However, I still needed to open the event as great as it can be even if the time was short. I finally created a 6-slide small presentation. In reality, there were only two pages which had the main contents of my keynote, and the remaining slides were just wrappers and decors.

You can download the complete slide deck from here. The image used in the slide deck is a curtsy of blog reader Roger Smith who sent it to me.

The slide in which I spent a good amount of time is the slide which talks about Professional Development. The content of the slide is as follows:

  • Today, Technology and You
  • Keep your eyes, ears and senses open – Stay Active!
  • You are not the first one who faced the problem – Search Online!
  • Learn the web – Blogs, Forums and Friends!
  • Trust the Technology, Not Print – Test Everything!
  • Community and You!

I had a very little time creating the slide deck as I was busy the whole day doing the Advanced SQL Server Training. I had put together these slides during the tea/coffee break of my session. Though it was just a six-bullet point, I had received quite a few emails right after keynote requesting me to talk more about this subject and share the details of my slide deck. I have talked with the event organizer and he will put the keynote online very soon.

The subject of the talk is very simple; it revolves around the community. Time has changed, and Internet has come a long way from where it was many years ago. Now that we are all connected, help via the Internet and useful software is easily available around us. In fact, RSS, Newletters and few other technologies have progressed so much that the help through news is now being delivered to our door steps, instead of going out and seeking them. Sometimes, a simple search online solves a lot of problems of many developers.

The community is now the first stop for any developer when he or she needs help or just wants to hang around and share some thoughts. I strongly suggest everybody to be a part of the Tech Community. Be it online, offline community or just a local user group, I strongly advise all of you to get involved. I am active in the Community, and I must say I recommend getting drawn into it.

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

SQLAuthority News – Excellent Event – TechEd Sri Lanka – Feb 8, 2010

TechEd Sri Lanka was held at Waters Edge, Colombo between Feb 8 and Feb 10, 2010. It was one of the largest successful technical event in Sri Lanka. I was extremely surprised to how technically sound this event was and how excited the TechEd attendees were.

I presented there on two different subject. They were very enthusiastic and had so many interesting questions during the session. One of my session received rating of 8.9. I must thank you to all the attendees for sending their feedback and appreciating my session. Both of my session have received feedback above average.

The Other Side of SQL Server Index : Advanced Solutions to Ancient Problem (Rating 8.9)
SQL Server Index is very powerful tool and when in hand of the less skilled expert, the same tool can be very dangerous for performance and can kill server. This session touches the root base of the how incorrect usage of Index can reduce performance and what is the correct way to implement indexing solution. A problem addressed in the session may be age old but the solutions are looked into with the focus of latest versions of SQL Server.

The history of the Log: Change Data Capture (CDC) (Rating 7.8)
Learn to capture the history of data using CDC. An age old method of writing queries and triggers to capture change in database table is replaced with much powerful asynchronous method of change data capture (CDC). All attendees will learn how to configure CDC in less than 60 seconds.

Selected feedback from both of the sessions

  • I got massive knowledge from there Superb
  • Brilliant effort taken to educate us~! surely gonna make my life easier at office!!
  • The best presenter is this person
  • Presentation was very interesting and would be able to gather the points he talk easily
  • Great demo and presentation, cool stuffs.

Along with me there will be other two Solid Quality Mentors – Rushabh Mehta and Joy Ratnayake presenting on various topics. During my visit to Sri Lanka I had received the opportunity to meet MVP from Sri Lanka and I was able to attend the Sri Lanka SQL Server User Group Meeting as well.

Sri Lanka is wonderful place and I had great time to visit the country as well attend TechED Event. I am eagerly waiting for TechEd to come again in 2011.

TechEd SriLanka

TechEd SriLanka

Pinal at TechEd SriLanka

Pinal at TechEd SriLanka

Keynote at TechEd Sri Lanka

Keynote at TechEd Sri Lanka

Pinal Presenting at TechEd Sri Lanka

Pinal Presenting at TechEd Sri Lanka

Pinal Presenting at TechEd Sri Lanka

Pinal Presenting at TechEd Sri Lanka

Rushabh Mehta at TechEd Sri Lanka

Rushabh Mehta at TechEd Sri Lanka

Pinal Presenting at TechEd Sri Lanka

Pinal Presenting at TechEd Sri Lanka

UG Leaders and MVPs of Sri Lanka - Joy, Chandana, Gogula, Dinesh

UG Leaders and MVPs of Sri Lanka - Joy, Chandana, Gogula, Dinesh

Sri Lanka SQL Server User Group

Sri Lanka SQL Server User Group

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



SQLAuthority News – Hyderabad Techies February Fever Feb 11, 2010 – Indexing for Performance

I recently presented in Hyderabad User Group on the subject of The Other Side of SQL Server Index: Advanced Solutions to Ancient Problem , you can read more about this event here SQLAuthority News – MUGH – Microsoft User Group Hyderabad – Feb 2, 2010 Session Review. I really had great time talking about Index and Index Tuning. Index is very important part of database performance tuning and understanding it is a big thing. I have learned a lot of performance tuning tricks from Itzik Ben-Gan and Greg Low.

After successful session at Hyderabad User Group, I have presented follow up technical session at online Hyderabad User Group Hyderabad Techies. The title of the session was SQL Server Index Maintenance: Detect, Create, Detect & Rebuild. It was really fun as session was attended by 50+ enthusiasts and had lots of interaction in online community which is a bit unusual.

Hyderabad Techies is a community which is launched exclusively for developers working on Microsoft technologies in Hyderabad which has 1000+ members.

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

SQLAuthority News – MUGH – Microsoft User Group Hyderabad – Feb 2, 2010 Session Review

Earlier this month, I was very fortunate to visit Microsoft User Group Hyderabad lead by Hima Vindu Vejella. Hima is a very enthusiastic leader and kind person. I had a wonderful time meeting her as well her husband during my visit to Hyderabad. I had presented session on Index, which was well received.

Brief information on this session is given below:

The Other Side of SQL Server Index: Advanced Solutions to Ancient Problem
SQL Server Index is very powerful tool and when in hand of the less skilled expert, the same tool can pose a danger to its performance and kill server. This session touches the root base of the how incorrect usage of Index can reduce performance and what is the correct way to implement the indexing solution. A problem addressed in the session may be age old, but the solutions are looked into with the focus on the latest versions of SQL Server.

I really enjoyed presenting this session to group of people. Special thanks to Harish Ranganthan for arranging the venue in a very short notice. You can read the details of this event on Hima’s blog here.

I really had a great time with UG members in Hyderabad ‑ indeed, a bunch of very enthusiastic attendees.

Hyderabad UG Index Presentation by Pinal Dave
Hyderabad UG Index Presentation by Pinal Dave

Hyderabad UG Index Presentation by Pinal Dave
Hyderabad UG Index Presentation by Pinal Dave

Hyderabad UG Index Presentation by Pinal Dave
Hyderabad UG Index Presentation by Pinal Dave

Hyderabad UG Index Presentation by Pinal Dave
Hyderabad UG Index Presentation by Pinal Dave

Hyderabad User Group Leader Hima
Hyderabad User Group Leader Hima

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