SQLAuthority News – Presenting Two Technology Sessions at TechEd India 2013 – Today and Tomorrow

Every year I am looking forward to TechEd India as it presents a wonderful opportunity to meet community in first hand. Community is my passion and I love to get involved with it at every single opportunity it presents. This year once again I am presenting a technology session at TechEd India. I will be presenting on the following subject.

Here is something I promise – if you attend my session – when you walk out of my session you will immediate action items which you can use it for your production server and improve the performance of the database. Additionally, I will have some goodies with me for everyone. I will have few of my books, free subscription access to Pluralsight’s library as well something totally interesting as a giveaway.

Here are the details of the sessions:

SQL Server Performance Troubleshooting: Ancient Problems and Modern Solutions

Date: March 18, 2013 – Bangalore
Date: March 25, 2013 – Pune
Time: 2:45 – 3:45 PM

Many believe Performance Tuning and Troubleshooting is an art which has been lost in time. The truth is that art has evolved with the time and there are more tools and techniques to overcome ancient troublesome scenarios. There three major resource when bottlenecked creates performance problem: CPU, IO, and Memory. In this session we will focus on High CPU scenarios detection and their resolutions. If time permits we will cover other performance related tips and tricks. At the end of the session attendee will have clear ideas and action items regarding what to do in when facing any of the above resource intensive scenarios.

Indexes – The Unsung Hero

Date: March 19, 2013 – Bangalore
Date: March 26, 2013 – Pune
Time: 2:45 – 3:45 PM

Slow Running Queries  are the most common problem that developers face while working with SQL Server. While it is easy to blame the SQL Server for unsatisfactory performance, however the issue often persists with the way queries have been written, and how Indexes has been set up. The session will focus on the ways of identifying problems that slow down SQL Server, and Indexing tricks to fix them. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

Looking forward to see you in session!

Pluralsight will be sponsoring the TechEd India event and don’t forget to stop by the Pluralsight booth for some goodies and meet the Pluralsight executives.

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

SQLAuthority News – Presenting Two Session at TechEd India 2013 on March 18-19, 2013 at Bangalore

TechEd India is around the corner and I have two sessions in TechEd India. I am excited and nervous as well. TechEd is a special event and I am going to present 4th time in this event. This time the event is in two location – Bangalore and Pune. Performance Tuning is my favorite subject and I love to talk about it endlessly. If you know me personally, you might be familior with how I present any session.

I promise that when you walk out of the session you will have gained learning which you can implement right away at the in your daily job. Here is one more interesting details if you attend my session I will have special goodies for you. You may win my brand New SQL Server 2012 book combo set (worth RS 4000). I will have two sets of the combo sets to give away during the sessions. Additionally, I will have a few of my SQL Server Interview Questions and Answers books as well.

Here are details of my two of the sessions.

SQL Server Performance Troubleshooting: Ancient Problems and Modern Solutions

Date: March 18, 2013 – Bangalore
Date: March 25, 2013 – Pune
Time: 2:45 – 3:45 PM

Many believe Performance Tuning and Troubleshooting is an art which has been lost in time. The truth is that art has evolved with the time and there are more tools and techniques to overcome ancient troublesome scenarios. There three major resource when bottlenecked creates performance problem: CPU, IO, and Memory. In this session we will focus on High CPU scenarios detection and their resolutions. If time permits we will cover other performance related tips and tricks. At the end of the session attendee will have clear ideas and action items regarding what to do in when facing any of the above resource intensive scenarios.

Indexes – The Unsung Hero

Date: March 19, 2013 – Bangalore
Date: March 26, 2013 – Pune
Time: 2:45 – 3:45 PM

Slow Running Queries  are the most common problem that developers face while working with SQL Server. While it is easy to blame the SQL Server for unsatisfactory performance, however the issue often persists with the way queries have been written, and how Indexes has been set up. The session will focus on the ways of identifying problems that slow down SQL Server, and Indexing tricks to fix them. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

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

SQLAuthority News – #TechEdIn – TechEd India 2012 Memories and Photos

TechEd India 2012 was held in Bangalore last March 21 to 23, 2012. Just like every year, this event is bigger, grander and inspiring.

Pinal Dave at TechEd India 2012

Pinal Dave at TechEd India 2012

Family Event

Every single year, TechEd is a special affair for my entire family.  Four months before the start of TechEd, I usually start to build the mental image of the event. I start to think  about various things. For the most part, what excites me most is presenting a session and meeting friends. Seriously, I start thinking about presenting my session 4 months earlier than the event!  I work on my presentation day and night. I want to make sure that what I present is accurate and that I have experienced it firsthand. My wife and my daughter also contribute to my efforts. For us, TechEd is a family event, and the two of them feel equally responsible as well. They give up their family time so I can bring out the best content for the Community.

Pinal, Shaivi and Nupur at TechEd India 2012

Pinal, Shaivi and Nupur at TechEd India 2012

Guinea Pigs (My Experiment Victims)

I do not rehearse my session, ever. However, I test my demo almost every single day till the last moment that I have to present it already. I sometimes go over the demo more than 2-3 times a day even though the event is more than a month away. I have two “guinea pigs”: 1) Nupur Dave and 2) Vinod Kumar. When I am at home, I present my demos to my wife Nupur. At times I feel that people often backup their demo, but in my case, I have backup demo presenters. In the office during lunch time, I present the demos to Vinod. I am sure he can walk my demos easily with eyes closed.

Pinal and Vinod at TechEd India 2012

Pinal and Vinod at TechEd India 2012

My Sessions

I’ve been determined to present my sessions in a real and practical manner. I prefer to present the subject that I myself would be eager to attend to and sit through if I were an audience. Just keeping that principle in mind, I have created two sessions this year.

SQL Server Misconception and Resolution

Pinal and Vinod at TechEd India 2012

Pinal and Vinod at TechEd India 2012

We believe all kinds of stuff – that the earth is flat, or that the forbidden fruit is apple, or that the big bang theory explains the origin of the universe, and so many other things. Just like these, we have plenty of misconceptions in SQL Server as well.

I have had this dream of co-presenting a session with Vinod Kumar for the past 3 years. I have been asking him every year if we could present a session together, but we never got it to work out, until this year came. Fortunately, we got a chance to stand on the same stage and present a single subject.

 I believe that Vinod Kumar and I have an excellent synergy when we are working together. We know each other’s strengths and weakness. We know when the other person will speak and when he will keep quiet. The reason behind this synergy is that we have worked on 2 Video Learning Courses (SQL Server Indexes and SQL Server Questions and Answers) and authored 1 book (SQL Server Questions and Answers) together.

Crowd Outside Session Hall

Crowd Outside Session Hall

This session was inspired from the “Laurel and Hardy” show so we performed a role-playing of those famous characters. We had an excellent time at the stage and, for sure, the audience had a wonderful time, too. We had an extremely large audience for this session and had a great time interacting with them.

Speed Up! – Parallel Processes and Unparalleled Performance

Pinal Dave at TechEd India 2012

Pinal Dave at TechEd India 2012

I wanted to approach this session at level 400 and I was very determined to do so. The biggest challenge I had was that this was a total of 60 minutes of session and the audience profile was very generic. I had to present at level 100 as well at 400. I worked hard to tune up these demos. I wanted to make sure that my messages would land perfectly to the minds of the attendees, and when they walk out of the session, they could use the knowledge I shared on their servers. After the session, I felt an extreme satisfaction as I received lots of positive feedback at the event. At one point, so many people rushed towards me that I was a bit scared that the stage might break and someone would get injured. Fortunately, nothing like that happened and I was able to shake hands with everybody.

Pinal Dave at TechEd India 2012

Pinal Dave at TechEd India 2012

Crowd rushing to Pinal at TechEd India 2012

Crowd rushing to Pinal at TechEd India 2012

Networking

This is one of the primary reasons many of us visit the annual TechEd event. I had a fantastic time meeting SQL Server enthusiasts. Well, it was a terrific time meeting old friends, user group members, MVPs and SQL Enthusiasts. I have taken many photographs with lots of people, but I have received a very few back. If you are reading this blog and have a photo of us at the event, would you please send it to me so I could keep it in my memory lane?

Jacob and Pinal at TechEd India 2012

SQL Track Speaker: Jacob and Pinal at TechEd India 2012

Pinal, Tejas, Nakul, Jacob, Balmukund, Manas, Sudeepta, Sahal at TechEd India 2012

SQL Community: Pinal, Tejas, Nakul, Jacob, Balmukund, Manas, Sudeepta, Sahal at TechEd India 2012

Amit and Balmukund at TechEd India 2012

Star Speakers: Amit and Balmukund at TechEd India 2012

Nakul, Tejas and Pinal at TechEd India 2012

TechED Rockstars: Nakul, Tejas and Pinal at TechEd India 2012

I guess TechEd is a mix of family affair and culture for me!

Hamara TechEd (Our TechEd)

Hamara TechEd (Our TechEd)

Please tell me which photo you like the most!

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

SQL SERVER – TechEd India 2012 – Content, Speakers and a Lots of Fun

TechEd is one event which every developers and IT professionals are looking forward to attend. It is opportunity of life time and no matter how many time one gets chance to engage with it, it is never enough. I still remember every single moment of every TechEd I have attended so far. We are less than 100 hours away from TechEd India 2012 event.This event is the one must attend event for every Technology Enthusiast. Fourth time in the row I am going to attend this event and I am equally excited as the first time of the event.

There are going to be two very solid SQL Server track this time and I will be attending end of the end both the tracks. Here is my view on each of the 10 sessions. Each session is carefully crafted and leading exeprts from industry will present it.

Day 1, March 21, 2012

  1. T-SQL Rediscovered with SQL Server 2012 – This session is going to bring some of the lesser known enhancements that were brought with SQL Server 2012. When I learned that Jacob Sebastian is going to do this session my reaction to this is DEMO, DEMO and DEMO! Jacob spends hours and hours of his time preparing his session and this will be one of those session that I am confident will be delivered over and over through out the next many events.
  2. Catapult your data with SQL Server 2012 Integration Services – Praveen is expert story teller and one of the wizard when it is about SQL Server and business intelligence. He is surely going to mesmerize you with some interesting insights on SSIS performance too.
  3. Processing Big Data with SQL Server 2012 and Hadoop – There are three sessions on Big Data at TechEd India 2012. Stephen is going to deliver one of the session. Watching Stephen present is always joy and quite entertaining. He shares knowledge with his typical humor which captures ones attention. I wrote about what is BIG DATA in a blog post.
  4. SQL Server Misconceptions and Resolutions – I will be presenting this Session along with Vinod Kumar. READ MORE HERE.
  5. Securing with ContainedDB in SQL Server 2012 – Pranab is expert when it is about SQL Server and Security. I have seen him presenting and he is indeed very pleasant to watch. A dry subject like security, he makes it much lively. A Contained Database is a database which contains all the necessary settings and metadata, making database easily portable to another server. This database will contain all the necessary details and will not have to depend on any server where it is installed for anything. You can take this database and move it to another server without having any worries.

Day 3, March 23, 2012

  1. Peeling SQL Server like an Onion: Internals Demystified – Vinod Kumar has been writing about this extensively on his other blog post. In recent conversation he suggested that he will be creating very exclusive content for this presentation. I know Vinod for long time and have worked with him along many community activities. I am going to pay special attention to the details. I know Vinod has few give-away planned now for attending the session now only if he shares with us.
  2. Speed Up – Parallel Processes and unparalleled Performance – Performance tuning is my favorite subject. I will be discussing effect of parallelism on performance in this session. Here me out, there will be lots of quiz questions during this session and if you get the answers correct – you can win some really cool goodies – I Promise! READ MORE HERE.
  3. Keep your database available – AlwaysOn – Balmukund is like an army man. He is always ready to show and prove that he has coolest toys in terms of SQL Server and he knows how to keep them running AlwaysON. Availability groups, Listener, Clustering, Failover, Read-Only replica etc all will be demo’ed in this session. This is really heavy but very interesting content not to be missed. He blogged it over here.
  4. Lesser known facts about SQL Server Backup and Restore – Amit Banerjee – this name is known internationally for solving SQL Server problems in 140 characters. He has already blogged about this and this topic is going to be interesting. A successful restore strategy for applications is as good as their last good known backup. I have few difficult questions to ask to Amit and I am very sure that his unique style will entertain people. By the way, his one of the slide may give few in audience a funny heart attack.
  5. Top 5 reasons why you want SQL Server 2012 BI – Praveen plans to take a tour of some of the BI enhancements introduced in the new version. Business Insights with SQL Server is a critical building block and this version of SQL Server is no exception. For the matter of the fact, when I saw the demos he was going to show during this session, I felt like that I wish I can set up all of this on my machine. If you miss this session – you will miss one of the most informative session of the day.

Also TechEd India 2012 has a Live streaming of some content and this can be watched here. The TechEd Team is planning to have some really good exclusive content in this channel as well.

If you spot me, just do not hesitate to come by me and introduce yourself, I want to remember you!

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

SQL SERVER – SQL Server Misconceptions and Resolution – A Practical Perspective – TechEd 2012 India

TechEd India 2012 is just around the corner and I will be presenting there in two different sessions. On the very first day of this event, my presentation will be all about SQL Server Misconceptions and Resolution – A Practical Perspective.

The dictionary tells us that a “misconception” means a view or opinion that is incorrect and is based on faulty thinking or understanding. In SQL Server, there are so many misconceptions. In fact, when I hear some of these misconceptions, I feel like fainting at that very moment! Seriously, at one time, I came across the scenario where instead of using INSERT INTO…SELECT, the developer used CURSOR believing that cursor is faster (duh!). Here is the link the blog post related to this.

Pinal and Vinod in 2009

I have been presenting in TechEd India for last three years. This is my fourth opportunity to present a technical session on SQL Server. Just like the previous years, I decided to present something different. Here is a novelty of this year: I will be presenting this session with Vinod Kumar. Vinod Kumar and I have a great synergy when we work together. So far, we have written one SQL Server Interview Questions and Answers book and 2 video courses: (1) SQL Server Questions and Answers (2) SQL Server Performance: Indexing Basics.

Pinal and Vinod in 2011

When we sat together and started building an outline for this course, we had many options in mind for this tango session. However, we have decided that we will make this session as lively as possible while keeping it natural at the same time. We know our flow and we know our conversation highlight, but we do not know what exactly each of us is going to present. We have decided to challenge each other on stage and push each other’s knowledge to the verge. We promise that the session will be entertaining with lots of SQL Server trivia, tips and tricks.

Here are the challenges that I’ll take on:

  • I will puzzle Vinod with my difficult questions
  • I will present such misconception that Vinod will have no resolution for it.

I need your help.  Will you help me stump Vinod? If yes, come and attend our session and join me to prove that together we are superior (a friendly brain clash, but we must win!).

SQL Server enthusiasts and SQL Server fans are going to have gala time at #TechEdIn as we have a very solid lineup of the speaker and extremely interesting sessions at TechEdIn. Read the complete blog post of Vinod.

Session Details

Title: SQL Server Misconceptions and Resolution – A Practical Perspective (Add to Calendar)

Abstract:

“Earth is flat”! – An ancient common misconception, which has been proven incorrect as we progressed in modern times. In this session we will see various database misconceptions prevailing and their resolution with the aid of the demos. In this unique session audience will be part of the conversation and resolution.

Date and Time: March 21, 2012, 15:15 to 16:15

Location:
 Hotel Lalit Ashok – Kumara Krupa High Grounds, Bengaluru – 560001, Karnataka, India.

Add to Calendar

Please submit your questions in the comments area and I will be for sure discussing them during my session. If I pick your question to discuss during my session, here is your gift I commit right now – SQL Server Interview Questions and Answers Book.

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

SQL SERVER – Speed Up! – Parallel Processes and Unparalleled Performance – TechEd 2012 India

TechEd India 2012 is just around the corner and I will be presenting there on two different session. SQL Server Performance Tuning is a very challenging subject that requires expertise in Database Administration and Database Development. I always have enjoyed talking about SQL Server Performance tuning subject. Just like doctors I like to call my every attempt to improve the performance of SQL Server queries and database server as a practice too. I have been working with SQL Server for more than 8 years and I believe that many of the performance tuning concept I have mastered. However, performance tuning is not a simple subject. However there are occasions when I feel stumped, there are occasional when I am not sure what should be the next step. When I face situation where I cannot figure things out easily, it makes me most happy because I clearly see this as a learning opportunity.

I have been presenting in TechEd India for last three years. This is my fourth time opportunity to present a technical session on SQL Server. Just like every other year, I decided to present something different, something which I have spend years of learning. This time, I am going to present about parallel processes. It is widely believed that more the CPU will improve performance of the server. It is true in many cases. However, there are cases when limiting the CPU usages have improved overall health of the server.

I will be presenting on the subject of Parallel Processes and its effects. I have spent more than a year working on this subject only. After working on various queries on multi-CPU systems I have personally learned few things. In coming TechEd session, I am going to share my experience with parallel processes and performance tuning.

Session Details

Title: Speed Up! – Parallel Processes and Unparalleled Performance (Add to Calendar)

Abstract:
 “More CPU More Performance” – A  very common understanding is that usage of multiple CPUs can improve the performance of the query. To get maximum performance out of any query – one has to master various aspects of the parallel processes. In this deep dive session, we will explore this complex subject with a very simple interactive demo. An attendee will walk away with proper understanding of CX_PACKET wait types, MAXDOP, parallelism threshold and various other concepts.

Date and Time: March 23, 2012, 12:15 to 13:15

Location:
 Hotel Lalit Ashok – Kumara Krupa High Grounds, Bengaluru – 560001, Karnataka, India.

Add to Calendar

Please submit your questions in the comments area and I will be for sure discussing them during my session. If I pick your question to discuss during my session, here is your gift I commit right now – SQL Server Interview Questions and Answers Book.

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

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

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 4 – March 26, 2011

I woke up again at 5.00 AM. I really had nothing to do. Everything was over the night before, but waking up at this time had become a habit after I did so for three days continuously. I tried to go back to sleep, but my efforts were in vain. Very soon, my little princess Shaivi (my daughter) was up and the day started. I was happy and relaxed as the event went very fine and that I did my best to participate at various levels of the event.

Twitter was very much the ‘in-thing’ during the event, and there were plenty of the tweets during the event. Here are some of the tweets from various people who really enjoyed the event. You can follow me at @pinaldave for my latest updates and can stay in touch with me.

@pinaldave 1st time I have attended ur sessions in this TechEd. The analogy you have used to explain waits and extended events are amazing. By: @rkassetty

@pinaldave u r too humble !!! No wonder the audiences love your style. By @vinodk_sql

@pinaldave With the amount of time, planning that went behind that session. It will be very satisfying. You did it really well. By @vinodk_sql

Great Database sessions by @pinaldave | @vinodk_sql .Enjoyed and learned a lot from the sessions. By @parveensapra

Attended @pinaldave ‘s session on Extended events in SQL server. His Heart attack example to explain extended events was fun! #techedin By @SuprotimAgrawal

Attended a highly technical session from @pinaldave. DMVs & SQL performance.. Lots of stuff I don’t know. By @AbhishekKant

Great session on extended events at #techedin by @pinaldave.Next session by @vinodk_sqlob backups. Like both the speakers and topics. By @skganguly

TechED stands for Technology Education, and I had enjoyed this event very much. Please visit the following related posts on the TechEd India. I am looking forward to the next edition of TechEd.

If you have attended my sessions and written about the same, do send me email with the link and I will link your blog post over here. Thanks

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

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)

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)