SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 3

Read my complete experience series of TechEd 2011, Bangalore

TechED 2011 – Bangalore – An Unforgettable Experience – Day 0
TechED 2011 – Bangalore – An Unforgettable Experience – Day 1
TechED 2011 – Bangalore – An Unforgettable Experience – Day 2
TechED 2011 – Bangalore – An Unforgettable Experience – Day 3
TechED 2011 – Bangalore – An Unforgettable Experience – Day Next

Day 3 – March 25, 2011

Pinal Dave at TechEd 2011

Pinal Dave at TechEd 2011

My wife woke me up at 5.00 AM. Two hours of power sleep seemed inadequate as I had only less than 6 hours of sleep during the last 3 days. Today was a big day for me. I had to present two sessions. I got ready quickly, and headed towards the hotel. While I was traveling, I was continuously thinking about my sessions.

Pinal Dave at TechEd 2011

Pinal Dave at TechEd 2011

I reached the TechEd Venue at 7.00 AM and attended an-hour-long meeting with senior officers for the community. I was very happy as I strongly believed that throughout the year, I will be able to help community really well. I got the much-needed blessings from my senior officers for the same. I headed to Database Administrator Track with Vinod Kumar. As I said, it was a very important day for me.

Pinal Dave at TechEd 2011

Pinal Dave at TechEd 2011

I presented the following two topics during the sessions.

  1. Understanding SQL Server Behavioral Pattern – SQL Server Extended Events
  2. SQL Server Waits and Queues – Your Gateway to Performance Troubleshooting
Pinal Dave at TechEd 2011

Pinal Dave at TechEd 2011

You can read about them at the following links:

Pinal Dave at TechEd 2011

Pinal Dave at TechEd 2011

My both sessions had more than 200 attendees. I was glad and motivated to see considerable interest of so many people on this advanced 400 level subject. My both sessions had excellent participation and also lots of questions. I enjoy presenting the sessions more when attendees are interested and they start asking questions on various subjects that I am presenting.

Pinal Dave at TechEd 2011

Pinal Dave at TechEd 2011

I was pretty exhausted after my both my sessions. However, I still managed to attend three more sessions myself on the same day.

  1. Vinod Kumar presented on ”Database Recovery and Backup” – A simple but really interesting session.
  2. Prem Mehra presented on “SQL Server Consolidation” – A real world scenario based session.
  3. Balmukund Lakhani presented on ‘AlwaysOn – High Availability Solution’ – A session looking at the future version of the SQL Server.
Vinod Kumar

Vinod Kumar

It was the third day, and I had not seen my daughter. I was really missing her this time. As from last few days, every day when I left home, she was sleeping, and when I reached home, she was sleeping as well. On the third day, I was missing my daughter immensely. I called up Nupur and Shaivi for lunch with me at Hotel. Nupur and Shaivi both visited me during the lunch time, and I played few games with Shaivi. Nupur also met few of her friends, and they returned back home.

Anil Kumble and Gaurav Kapoor

Anil Kumble and Gaurav Kapoor

The third day was yet not over for me. After the five sessions, I went back to keynote area as we were about to have Anil Kumble as keynote speaker. He did an excellent job and discussed about team spirit and his experience as a cricketer. He was fun and inspiring. I really loved how he presented balanced views. One of the attendee in audience asked a very nasty question, and I loved the way he dodged it with a polite reply.

Pinal Shaivi Nupur

Pinal Shaivi Nupur

After the keynote, I rushed to party sponsored by sponsors. It was very good to unwind with community folks after a very successful event. I also rushed to another party right after this, where I met all the key people who had made this event successful. Finally, I decided to relax and mingle with friends – we were there till 1.00 AM. I left the venue at around 1.00 AM in the morning for home.

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

About these ads

SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 2

Read my complete experience series of TechEd 2011, Bangalore

TechED 2011 – Bangalore – An Unforgettable Experience – Day 0
TechED 2011 – Bangalore – An Unforgettable Experience – Day 1
TechED 2011 – Bangalore – An Unforgettable Experience – Day 2
TechED 2011 – Bangalore – An Unforgettable Experience – Day 3
TechED 2011 – Bangalore – An Unforgettable Experience – Day Next

Day 2 – March 24, 2011

Pinal Dave at TechEd 2011

Pinal Dave at TechEd 2011

I woke up once again at 5.00 AM as I was planning to leave at 6.00 AM. While I was heading towards the venue, I was thinking about the remaining day ‑ a very eventful day indeed! There were many things lined up and I had not yet reached the venue. Anyway the day started on a good note. I met my MVP friends in the lobby and did not realize that I talked with them for more than 2 hours. I finally went to attend the keynote, but the hall was quite full. I was directed to another room, where live streaming was happening. Live streaming was equally exciting.

Vinod Kumar and Pinal Dave

Vinod Kumar and Pinal Dave

I headed towards Database Business Intelligence Track. I enjoyed the new concepts of BI. I also attended Beauty of the Web track and enjoyed one HTML5 and IE9 track. Following are the sessions that I attended.

Rushabh Mehta

Rushabh Mehta

  1. Rushabh Mehta presented on Semantic Model of SQL Server Denali – it is very new concept and the attendees surely had a great time.
  2. Harish Vaidyanathan presented on “HTML5” – more than just HTML5 – what a fun session it was, I did not know that through HTML, one can have so much fun.
Harish Vaidyanathan

Harish Vaidyanathan

After attending the sessions, I headed right away to the keynote hall. There was going to be Demo Extravaganza, where I was about to present on “Spatial Database”. Spatial Database is interesting concept and I was encouraged immensely by the response and appreciation for the same concept. Though no one noticed, let me share one secret with you regarding this. Even the attendees did not notice this; I actually presented more tricks than what I had initially planned. It was fun that in front of 3000+ people I was able to  show new feature of SQL Server. I had two great Demo Extravaganza hosts – Harish V and Nahash – and it was really fun to be on stage with them. They were really fun to be with, very important, and excellent supporting hosts.

SQL Boys - Vinod, Rushabh, Pinal, Jacob

SQL Boys – Vinod, Rushabh, Pinal, Jacob

After the Demo Extravaganza, I attended community party. It was really gala time to meet friends like Sanjay Shetty, Abhishek Kant, Abhishek Baxi, and all the MVPs. Lots of people attended this event. I had fun time hanging around with fellow MVPs and Community Leaders. I think we should have this type of meetings quite often to keep the community spirit going.

Pinal Dave at TechEd 2011

Pinal Dave at TechEd 2011

I wanted to head home early as I had two sessions to present next day. Even though I was all ready with my presentation, I was slightly nervous. As you know Murphy’s law – if something can go wrong, it will go wrong – and this holds true for anybody at any moment. When I was returning, I noticed that it was already 11 PM. I had one more hour journey back to home. I reached home at midnight, and instead of sleeping, I went back to my sessions. I practiced all the demos and all the slide decks one more time and went to bed around 3.00 AM in the morning. A long day was already over, but about the next day was about to get started in the next 2 hours.

Pinal Dave at TechEd 2011

Pinal Dave at TechEd 2011

Moreover, an exciting World Cup quarterfinal match was taking place between India and Australia that. Despite this, I found that the event was house full! In case you are wondering of the results, India won in the exciting game. Indian bowlers and batsman indeed did a fantastic job on the ground.

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

SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 1

Read my complete experience series of TechEd 2011, Bangalore

TechED 2011 – Bangalore – An Unforgettable Experience – Day 0

TechED 2011 – Bangalore – An Unforgettable Experience – Day 1

TechED 2011 – Bangalore – An Unforgettable Experience – Day 2

TechED 2011 – Bangalore – An Unforgettable Experience – Day 3

TechED 2011 – Bangalore – An Unforgettable Experience – Day Next

Day 1 – March 23, 2011

After my 3 hours of power sleep, I was up before 5.00 AM. I got ready and headed to TechEd Venue. Even though it was pretty early and very dark, it took me around 45 minutes to reach the venue from my home. When I reached there, I met Vinod Kumar, who had reached there before me. We talked a bit; I had a chat with my manager, and then moved very quickly to location where database track was about to happen. Everything seemed alright at the location; so, I once again headed to the Hotel Lobby as I was expecting many other friends to be there.

I met so many people there and I almost lost count of them. I had great pleasure meeting Abhishek Kant (MVP Lead) once again. We shared a few words with each other. After couple of calls, I finally spotted Jacob Sebastian – SQL Server MVP and a very close friend. Jacob and I both worked together in the Ahmedabad community. We worked together in almost every event that happened in the Gujarat region. Jacob and I talked for about an hour and headed towards Keynote. We had excellent key note speakers and cheered at the new technology announcements.

When I returned from keynote, I met Rushabh Mehta (PASS Global President and Solid Quality India CEO). I talked for a while with him regarding SQL PASS community. It is always a pleasure to meet him as he has such an interesting vision for PASS for India. Along with few friends and SQL Professionals, I headed towards, Database Development Track. I am a database guy, and I am very interested to hear others who are talk about SQL Server.

I attended all the sessions in this track. However, there are two tracks which kept me on edge as I came across some new and useful information.

  1. Jacob Sebastian presented on ‘T-SQL Worst Practices’ – I really enjoyed it as it talked about what not to do in reality.
  2. Vinod Kumar presented on ‘Unexplained of SQL Server Security’ – I learned a few new things over here.

After these sessions, I also went and participated in Chalk Talk of ’100 TB Migration’ subject. It was fun to attend the questions and talk to people.

Well, the day ended with partying. It was a speaker party, and all the Microsoft biggies were attending the same. This great place brewed with some intelligent conversations ‑ in short, a wonderful party and a good place to meet great people.

Right after the party, I headed towards keynote area which could accommodate more than 3000 people. I went there and did a dry run of the my Demo-X for next day.

When I was returning home, I noticed that it was already 11.00 PM, and there was an hour of journey to reach home.

Nupur (my wife) and Shaivi (my daughter) were already asleep when I returned home. I had not talked to Shaivi the whole day – and I felt slightly guilty for the same.

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

SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 0

Read my complete experience series of TechEd 2011, Bangalore

TechED 2011 – Bangalore – An Unforgettable Experience – Day 0
TechED 2011 – Bangalore – An Unforgettable Experience – Day 1
TechED 2011 – Bangalore – An Unforgettable Experience – Day 2
TechED 2011 – Bangalore – An Unforgettable Experience – Day 3
TechED 2011 – Bangalore – An Unforgettable Experience – Day Next

TechEd India is the one of the best Technology Events in India. The event venue was at Hotel Lalit Ashok, Bangalore. This three-day event was from March 23 to March 25, 2011, and this was my third TechEd Event.

My First TechEd in 2009

I had presented on SQL Server Management Studio Tricks and Tips.

My Second TechEd in 2010

I had presented three topics: 1) MDS 2) Spatial Database, and 3) Database Myths and panel discussion on Blogging.

My Third TechEd in 2011

This time, I presented two level 400 sessions: 1) Extended Events 2) Wait Types and Queues

Instead of writing what happened at TechEd, I am going to write what I did at TechEd. I am sure you will enjoy reading the same.

Session Selections and Preparation

Every speaker knew the sessions they are going to present several months in advance. I had started to prepare for my sessions from then on. I will write a separate post on the how I prepared the sessions. Following were my major milestones in the preparation process:

Vinod Kumar and Pinal Dave

Vinod Kumar and Pinal Dave

  • Two long discussions about the two sessions I was going to present with the Database Technology Evangelist Vinod Kumar (he is currently the Technology Specialist at Microsoft Technology Center).
  • Vinod and I had 3-4 revisions regarding the outline of the sessions.
  • I studied Extended Event for more than a month to understand the entire technology.
  • I wrote a month-long series on the wait types and queues and learned this subject in depth.
  • I spent hours creating slides. Each slide deck had more than 40 slides – where 15 slides were meant for presentations and 25 slides were kept as backup reference.
  • I did not rehearse my session speech as it is in prompt, but I tested my scripts almost 2-3 times a day till the last moment.
  • Following people helped me at various levels to prepare the sessions.
    • Vinod Kumar – He helped me at every single level. From sessions review, flow review, additional resources, pre-session feedback, post-session feedback and much more.
    • Govind Kanshi – He helped me with some key input for presentations and gave me opportunity to work with a real client for additional insight.
    • Jacob Sebastian – He took my sessions and studied them diligently. In case, I was not there to present due to any unavoidable issue, he was ready as the backup speaker.

I created one more presentation on T-SQL Tricks and Tips in case of any emergency. So, I was ready with a total of three sessions.

Jacob Sebastian and Pinal Dave

Jacob Sebastian and Pinal Dave

Day 0 – March 22, 2011

I went to the hotel at 12.00 PM. I checked all the locations and stage where database track was going to happen. I joined Vinod Kumar and learned so many things about pre-day preparations. We tested all the audio and video as well stage locations. We were there till late evening. I ran all my demos one more time on Day 0. When I reached home, it was already 10.00 PM. I practiced my sessions demo one more time. By the time, I went to bed, it was like 2.00 AM. I set three alarms to wake up at 5 AM as I had to leave from home at 6.00 AM to reach to venue.

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

SQL SERVER – Tell me What You Want to Listen – My 2 TechED 2011 Sessions

I am going to present two sessions at TechEd India on March 25th, 2011.

I would like to know what do you want me to cover in this session.

Watch the video taken by my wife when I was preparing for the session.

Sessions Date: March 25, 2011

Understanding SQL Server Behavioral Pattern – SQL Server Extended Events
Date and Time: March 25, 2011 12:00 PM to 01:00 PM

SQL Server Waits and Queues – Your Gateway to Perf. Troubleshooting
Date and Time: March 25, 2011 04:15 PM to 05:15 PM

I promise following for both of my sessions:

  1. I will share the scripts demonstrated in the session right at the end of the sessions
  2. The sessions will be 300-400 level but I promise to make the concept very simple
  3. Less slides and lots of meaningful Demos
  4. Session close to real life cases and scenarios
  5. Surprise gifts to best participants
  6. I promise to answer all the questions either in session or right after the hall after the session
  7. Lots of Technical Education and FUN!

Please leave your comments with your expectation and if you are going to attend the session do let me know here. We will for sure meet at the event and do some interesting talk. You can read the abstract of the session over here.

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

SQLAuthority News – TechEd India – April 12-14, 2010 Bangalore – An Unforgettable Experience – An Opportunity of A Lifetime

TechEd India was one of the largest Technology events in India led by Microsoft. This event was attended by more than 3,000 technology enthusiasts, making it one of the most well-organized events of the year. Though I attempted to attend almost all the technology events here, I have not seen any bigger or better event in Indian subcontinents other than this. There are 21 Technical Tracks at Tech·Ed India 2010 that span more than 745 learning opportunities. I was fortunate enough to be a part of this whole event as a speaker and a delegate, as well.

TechEd India Speaker Badge and A Token of Lifetime
TechEd India Speaker Badge and A Token of Lifetime

Hotel Selection

I presented three different sessions at TechEd India and was also a part of panel discussion. (The details of the sessions are given at the end of this blog post.) Due to extensive traveling, I stay away from my family occasionally. For this reason, I took my wife – Nupur and daughter Shaivi (8 months old) to the event along with me. We stayed at the same hotel where the event was organized so as to maximize my time bonding with my family and to have more time in networking with technology community, at the same time. The hotel Lalit Ashok is the largest and most luxurious venue one can find in Bangalore, located in the middle of the city. The cost of the hotel was a bit pricey, but looking at all the advantages, I had decided to ask for a booking there.

Hotel Lalit Ashok
Hotel Lalit Ashok
Nupur Dave and Shaivi Dave
Nupur Dave and Shaivi Dave

Arrival Day – DAY 0 – April 11, 2010

I reached the event a day earlier, and that was one wise decision for I was able to relax a bit and go over my presentation for the next day’s course. I am a kind of person who likes to get everything ready ahead of time. I was also able to enjoy a pleasant evening with several Microsoft employees and my family friends. I even checked out the location where I would be doing presentations the next day. I was fortunate enough to meet Bijoy Singhal from Microsoft who helped me out with a few of the logistics issues that occurred the day before. I was not aware of the fact that the very next day he was going to be “The Man” of the TechEd 2010 event. Vinod Kumar from Microsoft was really very kind as he talked to me regarding my subsequent session. He gave me some suggestions which were really helpful that I was able to incorporate them during my presentation.

Finally, I was able to meet Abhishek Kant from Microsoft; his valuable suggestions and unlimited passion have inspired many people like me to work with the Community. Pradipta from Microsoft was also around, being extremely busy with logistics; however, in those busy times, he did find some good spare time to have a chat with me and the other Community leaders. I also met Harish Ranganathan and Sachin Rathi, both from Microsoft. It was so interesting to listen to both of them talking about SharePoint. I just have no words to express my overwhelmed spirit because of all these passionate young guys - Pradipta,Vinod, Bijoy, Harish, Sachin and Ahishek (of course!).

Map of TechEd India 2010 Event
Map of TechEd India 2010 Event

Day 1 – April 12, 2010

From morning until night-time, today was truly a very busy day for me. I had two presentations and one panel discussion for the day. Needless to say, I had a few meetings to attend as well. The day started with a keynote from S. Somaseger where he announced the launch of Visual Studio 2010. The keynote area was really eye-catching because of the very large, bigger-than- life uniform screen. This was truly one to show. The title music of the keynote was very interesting and it featured Bijoy Singhal as the model. It was interesting to talk to him afterwards, when we laughed at jokes together about his modeling assignment.

TechEd India Keynote Opening Featuring Bijoy
TechEd India Keynote Opening Featuring Bijoy
TechEd India 2010 Keynote - S. Somasegar
TechEd India 2010 Keynote – S. Somasegar

Time: 11:15pm – 11:45pm Session 1: True Lies of SQL Server – SQL Myth Buster

Following the excellent keynote, I had my very first session on the subject of SQL Server Myth Buster. At first, I was a bit nervous as right after the keynote, for this was my very first session and during my presentation I saw lots of Microsoft Product Team members. Well, it really went well and I had a really good discussion with attendees of the session. I felt that a well begin was half-done and my confidence was regained. Right after the session, I met a few of my Community friends and had meaningful discussions with them on many subjects.

The abstract of the session is as follows: In this 30-minute demo session, I am going to briefly demonstrate few SQL Server Myths and their resolutions as I back them up with some demo. This demo presentation is a must-attend for all developers and administrators who would come to the event. This is going to be a very quick yet fun session.

Pinal Presenting session at TechEd India 2010
Pinal Presenting session at TechEd India 2010

Time: 1:00 PM – 2:00 PM Lunch with Somasegar

After the session I went to see my daughter, and then I headed right away to the lunch with S. Somasegar – the keynote speaker and senior vice president of the Developer Division at Microsoft. I really thank to Abhishek who made it possible for us. Because of his efforts, all the MVPs had the opportunity to meet such a legendary person and had to talk with them on Microsoft Technology. Though Somasegar is currently holding such a high position in Microsoft, he is very polite and a real gentleman, and how I wish that everybody in industry is like him. Believe me, if you spread love and kindness, then that is what you will receive back. As soon as lunch time was over, I ran to the session hall as my second presentation was about to start.

Time: 2:30pm – 3:30pm Session 2: Master Data Services in Microsoft SQL Server 2008 R2

Business Intelligence is a subject which was widely talked about at TechEd. Everybody was interested in this subject, and I did not excuse myself from this great concept as well. I consider myself fortunate as I was presenting on the subject of Master Data Services at TechEd. When I had initially learned this subject, I had a bit of confusion about the usage of this tool. Later on, I decided that I would tackle about how we all developers and DBAs are not able to understand something so simple such as this, and even worst, creating confusion about the technology. During system designing, it is very important to have a reference material or master lookup tables. Well, I talked about the same subject and presented the session keeping that as my center talk. The session went very well and I received lots of interesting questions. I got many compliments for talking about this subject on the real-life scenario. I really thank Rushabh Mehta (CEO, Solid Quality Mentors India) for his supportive suggestions that helped me prepare the slide deck, as well as the subject.

 Pinal Presenting session at TechEd India 2010
Pinal Presenting session at TechEd India 2010

The abstract of the session is as follows: SQL Server Master Data Services will ship with SQL Server 2008 R2 and will improve Microsoft’s platform appeal. This session provides an in-depth demonstration of MDS features and highlights important usage scenarios. Master Data Services enables consistent decision-making process by allowing you to create, manage and propagate changes from a single master view of your business entities. Also, MDS – Master Data-hub which is a vital component, helps ensure the consistency of reporting across systems and deliver faster and more accurate results across the enterprise. We will talk about establishing the basis for a centralized approach to defining, deploying, and managing master data in the enterprise.

Pinal Presenting session at TechEd India 2010
Pinal Presenting session at TechEd India 2010

The day was still not over for me. I had ran into several friends but we were not able keep our enthusiasm under control about all the rumors saying that SQL Server 2008 R2 was about to be launched tomorrow in the keynote. I then ran to my third and final technical event for the day- a panel discussion with the top technologies of India.

Time: 5:00pm – 6:00pm Panel Discussion: Harness the power of Web – SEO and Technical Blogging

As I have delivered two technical sessions by this time, I was a bit tired but  not less enthusiastic when I had to talk about Blog and Technology. We discussed many different topics there. I told them that the most important aspect for any blog is its content. We discussed in depth the issues with plagiarism and how to avoid it. Another topic of discussion was how we technology bloggers can create awareness in the Community about what the right kind of blogging is and what morally and technically wrong acts are. A couple of questions were raised about what type of liberty a person can have in terms of writing blogs. Well, it was generically agreed that a blog is mainly a representation of our ideas and thoughts; it should not be governed by external entities. As long as one is writing what they really want to say, but not providing incorrect information or not practicing plagiarism, a blogger should be allowed to express himself. This panel discussion was supposed to be over in an hour, but the interest of the participants was remarkable and so it was extended for 30 minutes more. Finally, we decided to bring to a close the discussion and agreed that we will continue the topic next year.

TechEd India Panel Discussion on Web, Technology and SEO
TechEd India Panel Discussion on Web, Technology and SEO

Surprisingly, the day was just beginning after doing all of these. By this time, I have almost met all the MVP who arrived at the event, as well as many Microsoft employees. There were lots of Community folks present, too. I decided that I would go to meet several friends from the Community and continue to communicate with me on SQLAuthority.com. I also met Abhishek Baxi and had a good talk with him regarding Win Mobile and Twitter. He also took a very quick video of me wherein I spoke in my mother’s tongue, Gujarati. It was funny that I talked in Gujarati almost all the day, but when I was talking in the interview I could not find the right Gujarati words to speak. I think we all think in English when we think about Technology, so as to address universality. After meeting them, I headed towards the Speakers’ Dinner.

Time: 8:00 PM – onwards Speakers Dinner

The Speakers’ dinner was indeed a wonderful opportunity for all the speakers to get together and relax. We talked so many different things, from XBOX to Hindi Movies, and from SQL to Samosas. I just could not express how much fun I had. After a long evening, when I returned tmy room and met Shaivi, I just felt instantly relaxed. Kids are really gifts from God.

Today was a really long but exciting day. So many things happened in just one day: Visual Studio Lanch, lunch with Somasegar, 2 technical sessions, 1 panel discussion, community leaders meeting, speakers dinner and, last but not leas,t playing with my child! A perfect day!

Day 2 – April 13, 2010

Today started with a bang with the excellent keynote by Kamal Hathi who launched SQL Server 2008 R2 in India and demonstrated the power of PowerPivot to all of us. 101 Million Rows in Excel brought lots of applause from the audience.

Kamal Hathi Presenting Keynote at TechEd India 2010
Kamal Hathi Presenting Keynote at TechEd India 2010

The day was a bit easier one for me. I had no sessions today and no events planned. I had a few meetings planned for the second day of the event. I sat in the speaker’s lounge for half a day and met many people there. I attended nearly 9 different meetings today. The subjects of the meetings were very different. Here is a list of the topics of the Community-related meetings:

  • SQL PASS and its involvement in India and subcontinents
  • How to start community blogging
  • Forums and developing aptitude towards technology
  • Ahmedabad/Gandhinagar User Groups and their developments
  • SharePoint and SQL
  • Business Meeting – a client meeting
  • Business Meeting – a potential performance tuning project
  • Business Meeting – Solid Quality Mentors (SolidQ)
  • And family friends
Pinal Dave at TechEd India
Pinal Dave at TechEd India

The day passed by so quickly during this meeting. In the evening, I headed to Partners Expo with friends and checked out few of the booths. I really wanted to talk about some of the products, but due to the freebies there was so much crowd that I finally decided to just take the contact details of the partner. I will now start sending them with my queries and, hopefully, I will have my questions answered.

Nupur and Shaivi had also one meeting to attend; it was with our family friend Vijay Raj. Vijay is also a person who loves Technology and loves it more than anybody. I see him growing and learning every day, but still remaining as a ‘human’. I believe that if someone acquires as much knowledge as him, that person will become either a computer or cyborg. Here, Vijay is still a kind gentleman and is able to stay as our close family friend. Shaivi was really happy to play with Uncle Vijay.

Pinal Dave and Vijay Raj
Pinal Dave and Vijay Raj

Renuka Prasad, a Microsoft MVP, impressed me with his passion and knowledge of SQL. Every time he gives me credit for his success, I believe that he is very humble. He has way more certifications than me and has worked many more years with SQL compared to me. He is an excellent photographer as well. Most of the photos in this blog post have been taken by him. I told him if ever he wants to do a part time job, he can do the photography very well.

Pinal Dave and Renuka Prasad
Pinal Dave and Renuka Prasad

I also met L Srividya from Microsoft, whom I was looking forward to meet. She is a bundle of knowledge that everyone would surely learn a lot from her. I was able to get a few minutes from her and well, I felt confident. She enlightened me with SQL Server BI concepts, domain management and SQL Server security and few other interesting details.

I also had a wonderful time talking about SharePoint with fellow Solid Quality Mentor Joy Rathnayake. He is very passionate about SharePoint but when you talk .NET and SQL with him, he is still overwhelmingly knowledgeable. In fact, while talking to him, I figured out that the recent training he delivered was on SQL Server 2008 R2. I told him a joke that it hurts my ego as he is more popular now in SQL training and consulting than me. I am sure all of you agree that working with good people is a gift from God. I am fortunate enough to work with the best of the best Industry experts.

It was a great pleasure to hang out with my Community friends – Ahswin Kini, HimaBindu Vejella, Vasudev G, Suprotim Agrawal, Dhananjay, Vikram Pendse, Mahesh Dhola, Mahesh Mitkari,  Manu Zacharia, Shobhan, Hardik Shah, Ashish Mohta, Manan, Subodh Sohani and Sanjay Shetty (of course!) .  (Please let me know if I have met you at the event and forgot your name to list here). I specifically want to thank Niraj Bhatt and his wife for taking us out for dinner and city tour.

Time: 8:00 PM – onwards Community Leaders Dinner

After lots of meetings, I headed towards the Community Leaders dinner meeting and met almost all the folks I met in morning. The discussion was almost the same but the real good thing was that we were enjoying it. The food was really good. Nupur was invited in the event, but Shaivi could not come. When Nupur tried to enter the event, she was stopped as Shaivi did not have the pass to enter the dinner. Nupur expressed that Shaivi is only 8 months old and does not eat outside food as well and could not stay by herself at this age, but the door keeper did not agree and asked that without the entry details Shaivi could not go in, but Nupur could. Nupur called me on phone and asked me to help her out. By the time, I was outside; the organizer of the event reached to the door and happily approved Shaivi to join the party. Once in the party, Shaivi had lots of fun meeting so many people.

Shaivi Dave and Abhishek Kant
Shaivi Dave and Abhishek Kant
Dean Guida (Infragistics President and CEO) and Pinal Dave (SQLAuthority.com)
Dean Guida (Infragistics President and CEO) and Pinal Dave (SQLAuthority.com)

Day 3 – April 14, 2010

Though, it was last day, I was very much excited today as I was about to present my very favorite session. Query Optimization and Performance Tuning is my domain expertise and I make my leaving by consulting and training the same. Today’s session was on the same subject and as an additional twist, another subject about Spatial Database was presented. I was always intrigued with Spatial Database and I have enjoyed learning about it; however, I have never thought about Spatial Indexing before it was decided that I will do this session. I really thank Solid Quality Mentor Dr. Greg Low for his assistance in helping me prepare the slide deck and also review the content.

Furthermore, today was really what I call my ‘learning day’ . So far I had not attended any session in TechEd and I felt a bit down for that. Everybody spends their valuable time & money to learn something new and exciting in TechEd and I had not attended a single session at the moment thinking that it was already last day of the event. I did have a plan for the day and I attended two technical sessions before my session of spatial database.

I attended 2 sessions of Vinod Kumar. Vinod is a natural storyteller and there was no doubt that his sessions would be jam-packed. People attended his sessions simply because Vinod is the best speaker. He did not have a single time disappointed audience; he is truly a good speaker. He knows his stuff very well. I personally do not think that in India he can be compared to anyone for SQL.

Time: 12:30pm-1:30pm SQL Server Query Optimization, Execution and Debugging Query Performance

I really had a fun time attending this session. Vinod made this session very interactive. The entire audience really got into the presentation and started participating in the event. Vinod was presenting a small problem with Query Tuning, which any developer would have encountered and solved with their help in such a fashion that a developer feels he or she have already resolved it. In one question, I was the only one who was ready to answer and Vinod told me in a light tone that I am now allowed to answer it! The audience really found it very amusing. There was a huge crowd around Vinod after the session. Vinod – A master storyteller!

Time: 3:45pm-4:45pm Data Recovery / consistency with CheckDB

This session was much heavier than the earlier one, and I must say this is my most favorite session I EVER attended in India. In this TechEd I have only attended two sessions, but in my career, I have attended numerous technical sessions not only in India, but all over the world. This session had taken my breath away. One by one, Vinod took the different databases, and started to corrupt them in different ways. Each database has some unique ways to get corrupted. Once that was done, Vinod started to show the DBCC CEHCKDB and demonstrated how it can solve your problem. He finally fixed all the databases with this single tool. I do have a good knowledge of this subject, but let me honestly admit that I have learned a lot from this session. I enjoyed and cheered during this session along with other attendees. I had total satisfaction that, just like everyone, I took advantage of the event and learned something. I am now TECHnically EDucated.

Pinal Dave and Vinod Kumar
Pinal Dave and Vinod Kumar

After two very interactive and informative SQL Sessions from Vinod Kumar, the next turn me presenting on Spatial Database and Indexing. I got once again nervous but Vinod told me to stay natural and do my presentation. Well, once I got a huge stage with a total of four projectors and a large crowd, I felt better.

Time: 5:00pm-6:00pm Session 3: Developing with SQL Server Spatial and Deep Dive into Spatial Indexing

Pinal Presenting session at TechEd India 2010
Pinal Presenting session at TechEd India 2010
Pinal Presenting session at TechEd India 2010
Pinal Presenting session at TechEd India 2010

I kicked off this session with Michael J Swart‘s beautiful spatial image. This session was the last one for the day but, to my surprise, I had more than 200+ attendees. Slowly, the rain was starting outside and I was worried that the hall would not be full; despite this, there was not a single seat available in the first five minutes of the session. Thanks to all of you for attending my presentation. I had demonstrated the map of world (and India) and quickly explained what  Geographic and Geometry data types in Spatial Database are. This session had interesting story of Indexing and Comparison, as well as how different traditional indexes are from spatial indexing.

Pinal Presenting session at TechEd India 2010
Pinal Presenting session at TechEd India 2010

Due to the heavy rain during this event, the power went off for about 22 minutes (just an accident – nobodies fault). During these minutes, there were no audio, no video and no light. I continued to address the mass of 200+ people without any audio device and PowerPoint. I must thank the audience because not a single person left from the session. They all stayed in their place, some moved closure to listen to me properly. I noticed that the curiosity and eagerness to learn new things was at the peak even though it was the very last session of the TechEd. Everybody wanted get the maximum knowledge out of this whole event. I was touched by the support from audience. They listened and participated in my session even without any kinds of technology (no ppt, no mike, no AC, nothing). During these 22 minutes, I had completed my theory verbally.

Pinal Presenting session at TechEd India 2010
Pinal Presenting session at TechEd India 2010

After a while, we got the projector back online and we continued with some exciting demos. Many thanks to Microsoft people who worked energetically in background to get the backup power for project up. I had a very interesting demo wherein I overlaid Bangalore and Hyderabad on the India Map and find their aerial distance between them. After finding the aerial distance, we browsed online and found that SQL Server estimates the exact aerial distance between these two cities, as compared to the factual distance. There was a huge applause from the crowd on the subject that SQL Server takes into the count of the curvature of the earth and finds the precise distances based on details.

Pinal  Presenting session at TechEd India 2010

During the process of finding the distance, I demonstrated a few examples of the indexes where I expressed how one can use those indexes to find these distances and how they can improve the performance of similar query. I also demonstrated few examples wherein we were able to see in which data type the Index is most useful. We finished the demos with a few more internal stuff.

Pinal Presenting session at TechEd India 2010
Pinal Presenting session at TechEd India 2010

Despite all issues, I was mostly satisfied with my presentation. I think it was the best session I have ever presented at any conference. There was no help from Technology for a while, but I still got lots of appreciation at the end. When we ended the session, the applause from the audience was so loud that for a moment, the rain was not audible. I was truly moved by the dedication of the Technology enthusiasts.

Pinal Dave After Presenting session at TechEd India 2010
Pinal Dave After Presenting session at TechEd India 2010

The abstract of the session is as follows: The 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.

Time: 8:00 PM – onwards Dinner by Sponsors

After the lively session during the day, there was another dinner party courtesy of one of the sponsors of TechEd. All the MVPs and several Community leaders were present at the dinner. I would like to express my gratitude to Abhishek Kant for organizing this wonderful event for us. It was a blast and really relaxing in all angles. We all stayed there for a long time and talked about our sweet and unforgettable memories of the event.

Pinal Dave and Bijoy Singhal
Pinal Dave and Bijoy Singhal

It was really one wonderful event. After writing this much, I say that I have no words to express about how much I enjoyed TechEd. However, it is true that I shared with you only 1% of the total activities I have done at the event. There were so many people I have met, yet were not mentioned here although I wanted to write their names here, too . Anyway, I have learned so many things and up until now, I am not able to get over all the fun I had in this event.

Pinal Dave at TechEd India 2010
Pinal Dave at TechEd India 2010

The Next Days – April 15, 2010 – till today

I am still not able to get my mind out of the whole experience I had at TechEd India 2010. It was like a whole Microsoft Family working together to celebrate a happy occasion.

TechEd India – Truly An Unforgettable Experience!

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

SQL SERVER – What is MDS? – Master Data Services in Microsoft SQL Server 2008 R2

What is MDS?

Master Data Services helps enterprises standardize the data people rely on to make critical business decisions. With Master Data Services, IT organizations can centrally manage critical data assets company wide and across diverse systems, enable more people to securely manage master data directly, and ensure the integrity of information over time. (Source: Microsoft)

Today I will be talking about the same subject at Microsoft TechEd India. If you want to learn about how to standardize your data and apply the business rules to validate data you must attend my session. MDS is very interesting concept, I will cover super short but very interesting 10 quick slides about this subject. I will make sure in very first 20 mins, you will understand following topics

  • Introduction to Master Data Management
    • What is Master Data and Challenges
    • MDM Challenges and Advantage
  • Microsoft Master Data Services
    • Benefits and Key Features
    • Uses of MDS
    • Capabilities
  • Key Features of MDS

This slides decks will be followed by around 30 mins demo which will have story of entity, hierarchies, versions, security, consolidation and collection. I will be tell this story keeping business rules in center. We take one business rule which will be simple validation rule and will make it much more complex and yet very useful to product.

I will also demonstrate few real life scenario where I will be talking about MDS and its usage.

Do not miss this session. At the end of session there will be book awarded to best participant.

My session details:

Session: Master Data Services in Microsoft SQL Server 2008 R2
Date: April 12, 2010  Time: 2:30pm-3:30pm

SQL Server Master Data Services will ship with SQL Server 2008 R2 and will improve Microsoft’s platform appeal. This session provides an in depth demonstration of MDS features and highlights important usage scenarios. Master Data Services enables consistent decision making by allowing you to create, manage and propagate changes from single master view of your business entities. Also with MDS – Master Data-hub which is the vital component helps ensure reporting consistency across systems and deliver faster more accurate results across the enterprise. We will talk about establishing the basis for a centralized approach to defining, deploying, and managing master data in the enterprise.

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