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: Replace with 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)

SQLAuthority News – Spot the SQLAuthority Baby Contest – SQL Server Cheat Sheet

Last Year during the TechEd India 2009 SQL Server Cheat Sheets were instant hit. Yesterday when I announce that I am going to attend TechED India 2010 at Bangalore, I received many requests for the same. I have only 30 copies available at this moment.  I will print more copies of the same after this event.

For the moment I am going to run quick content to win SQL Server Cheat Sheet during this event. The contest is very simple. My 7 months old daughter will join me in this trip. She will be staying with me in the same hotel where the event is organized. Here is the detail for contest:

Contest: If you Spot SQLAuthority Baby, get one SQL Server Cheat Sheet.

Rules: Every hour the first person to spot SQLAuthority Baby will get 1 SQL Server Cheat Sheet.

If you spot her and the hourly SQL Server Cheat Sheet is given away, you still have chance to get a copy. Drop your business card or email address and we will contact you for your copy.

SQLAuthority Baby is very easy to spot.

Shaivi Dave

Shaivi Dave

If you are not attending this event and want copy, you can easily download the same from link below.

Download SQL Server Cheat Sheet from here.

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

SQLAuthority News – Speaking Sessions at TechEd India – 3 Sessions – 1 Panel Discussion

Microsoft Tech-Ed India 2010 is considered as the major Technology event of the year for various IT professionals and developers. This event will feature a comprehensive forum in order   to learn, connect, explore, and evolve the current technologies we have today. I would recommend this event to you since here you will learn about today’s cutting-edge trends, thereby enhancing your work profile and getting ahead of the rest. But, the most important benefit of all might be the networking opportunity that that you can attain by attending the forum. You can build personal connections with various Microsoft experts and peers that will last even far beyond this event!

It also feels good to let you know that I will be speaking at this year’s event! So, here are the sessions that await you in this mega-forum.

Session 1: True Lies of SQL Server – SQL Myth Buster
Date: April 12, 2010  Time: 11:15pm – 11:45pm

In this 30-minute demo session, I am going to briefly demonstrate few SQL Server Myth and their resolution backing up with some demo. This demo session 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.

Session 2: 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.

Session 3: Developing with SQL Server Spatial and Deep Dive into Spatial Indexing
Date: April 14, 2010 Time: 5:00pm-6:00pm

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.

Panel Discussion: Harness the power of Web – SEO and Technical Blogging
Date: April 12, 2010 Time: 5:00pm-6:00pm

Here you will learn lots of tricks and tips about SEO and Technical Blogging from various Industry Technical Blogging Experts.

This event will surely be one of the most important Tech conventions of 2010. TechEd is going to be a very busy time for Tech developers and enthusiasts, since every evening there will be a fun session to attend. If you are interested in any of the above topics for every session, I suggest that you visit each of them as you will learn so many things about the topic to be discussed.

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

SQLAuthority News – Presenting Two Sessions at TechED Sri Lanka

I will be presenting following two sessions at TechEd Sri Lanka this week. I am very excited as this is very first time I will be presenting in TechEd event. I have previously presented many sessions but I have never presented at this premier Microsoft Event.

I will be presenting on following two subject.

The history of the Log: Change Data Capture (CDC)
Pinal Dave on 8-Feb-10 at 02.00 – 03.15
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.

The Other Side of SQL Server Index : Advanced Solutions to Ancient Problem
Pinal Dave on 9-Feb-10 at 02.15 – 03.15
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.

Along with me there will be other two Solid Quality Mentors – Rushabh Mehta and Joy Ratnayake presenting on various topics. Since announcement of the event, I have already received few emails I promise that one of the evening, I will for sure meet all of you who have requested the meeting.

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

SQLAuthority News – Authors Visit – K-MUG TechEd Trivandrum on June 27, 2009

K-MUG organized TechEd Trivandrum on 27th June, 2009. They even launched an official PASS Chapter in Trivandrum. The complete report of this event is here. This event like TechEd in Ahmedabad,  was a huge success and saw a huge number of attendees from all over India. Jacob Sebastian and Pinal Dave had presented two solid SQL Sessions and created lots of buzz about Microsoft. The event saw many wonderful speakers.I really appreciate the state-of-the-art facility at K-Mug and the amazing crowd brimming with enthusiasm. You can check out K-MUG event page for further information.

I really want to thank two people in particular for making the very first TechEd Trivandrum a grand success – 1) Sreejumon – the Founder and the President of Kerala Microsoft User group and 2) Binoy K – the Vice President of K-MUG.

Let us go over few interesting details about the event.

  • Pinal Dave explained about PASS Chapters and its benefits. He gave a memorable welcome note to New PASS chapter leaders and the attendees.
  • Jacob Sebastian inaugurated K-Mug PASS chapter.
  • Pinal Dave commenced the event with the very first SQL Session of ‘SQL Server Best Practices’.
  • Jacob Sebastian gave a brilliant session on ‘SQL Logical Query Execution and Optimization Tips’
  • Pinal Dave was called again to give a Demo on ‘Windows 7′ – which came as a surprise to everyone including Pinal. But Pinal made it a real fun by making people laugh while he smoothly and quickly covered all the features of Windows 7 unbelievably in 10 mins!
  • Jacob Sebastian gave away his book “The art of XSD” to the best participant of the event.
  • Some of the renowned speakers from all around India were present at the event.

Swami Vivekanand has always been my inspiration and I have always wanted to go to that place where he practiced meditation. I was lucky enough to visit Vivekanand Rock at Kanya Kumari during this trip to Kerala. One more interesting thing which I managed to do in this trip was reading a very useful book The Rational Guide to Building Technical User Communities (Rational Guides) (Paperback) by Greg Low..

Here are few more photos of the same event.

Pinal Dave at TechED on Road Trivendrum
Pinal Dave Presenting SQL Server Best Practices
Pinal Dave Presenting
Jacob Sebastian
Pinal Dave
Pinal and Jacob
Pinal, Binoy and Jacob
K-Mug Speakers and Leaders
Vivekanand Rock at Kanya Kumari

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

SQLAuthority News – Authors Visit – DotNet Buzz Delhi TechEd Delhi on July 11, 2009

DotNet Buzz Delhi is organizing TechEd Delhi on July 11, 2009. Not just this, they are launching an official PASS Chapter in Delhi. The Agenda of the event is here and if you are around Delhi do not miss the opportunity to be a part of this upcoming great event. If you are keen to know what this event holds in store for you then read about TechEd in Ahmedabad, which saw a huge number of attendees and was a grand success.  Jacob Sebastian and Pinal Dave had presented two solid SQL Sessions and created lots of buzz about Microsoft.

I will be at TechEd and will present a session on ‘SQL Server Best Practices’. This session will mainly focus on SQL Server best practices that are not commonly known. There is a huge gamut of information which can drastically enhance the performance of a system, but these are not widely known to users. I will share with you all those brilliant tips through demo to help to develop clear idea.

Jacob Sebastian, my friend and a SQL Server MVP, will also be there to support this event. He will present a session on ‘Logical Query Execution Flow’ where he will discuss how a given T-SQL Query is processed and executed. A comprehensive understanding of the query execution flow will help you solve several common problems and will help you answer a number of baffling questions that you often come across.

Again, those of you who have requested for SQL Server Cheat Sheet, I will have one copy for all of you who will attend this event.

Register for this grand event by clicking here.

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

SQLAuthority News – Authors Visit – K-MUG TechEd Trivandrum on June 27, 2009

K-MUG is organizing TechEd Trivandrum on 27th June, 2009. Not just this, they are launching an official PASS Chapter in Trivandrum. The Agenda of the event is here and if you are around Trivandrum do not miss the opportunity to be a part of this upcoming great event. If you are keen to know what this event holds in store for you then read about TechEd in Ahmedabad, which saw a huge number of attendees and was a grand success.  Jacob Sebastian and Pinal Dave had presented two solid SQL Sessions and created lots of buzz about Microsoft.

Click here for Review of Pinal Dave

Click here for Review of Jacob Sebastian

I will be at TechEd and will present a session on ‘SQL Server Best Practices’. This session will mainly focus on SQL Server best practices that are not commonly known. There is a huge gamut of information which can drastically enhance the performance of a system, but these are not widely known to users. I will share with you all those brilliant tips through demo to help to develop clear idea.

Jacob Sebastian, my friend and a SQL Server MVP, will also be there to support this event. He will present a session on ‘Logical Query Execution Flow’ where he will discuss how a given T-SQL Query is processed and executed. A comprehensive understanding of the query execution flow will help you solve several common problems and will help you answer a number of baffling questions that you often come across. Believe me this session was very much applauded at TechEd in Ahmedabad. I highly recommend this session to everyone interested in technology.

Jacob Sebastian will also give away his book ‘The Art of XSD – SQL Server XML Schema Collections’ at K-Mug TechEd.  This unique book deals with the subject of XSD, which is very crucial to understand if you want to explore the potential of XML. This topic is hardly well covered in any other book, which makes this book a must-have if you want to explore SQL Server Beyond Relational. Please read post by Jacob regarding how one can win his famous book here.

If any of you is interested in attending this event and meeting Jacob and me then do let me know. I will be staying an extra day at Trivandrum on Sunday, 28th June, so we can meet on that day as well.

Again, those of you who have requested for SQL Server Cheat Sheet, I will have one copy for all of you who will attend this event.

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