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 – Guest Post – Jonathan Kehayias – Wait Type – Day 16 of 28

Jonathan Kehayias (Blog | Twitter) is a MCITP Database Administrator and Developer, who got started in SQL Server in 2004 as a database developer and report writer in the natural gas industry. After spending two and a half years working in TSQL, in late 2006, he transitioned to the role of SQL Database Administrator. His primary passion is performance tuning, where he frequently rewrites queries for better performance and performs in depth analysis of index implementation and usage. Jonathan blogs regularly on SQLBlog, and was a coauthor of Professional SQL Server 2008 Internals and Troubleshooting.

On a personal note, I think Jonathan is extremely positive person. In every conversation with him I have found that he is always eager to help and encourage. Every time he finds something needs to be approved, he has contacted me without hesitation and guided me to improve, change and learn. During all the time, he has not lost his focus to help larger community. I am honored that he has accepted to provide his views on complex subject of Wait Types and Queues. Currently I am reading his series on Extended Events.

Here is the guest blog post by Jonathan:

SQL Server troubleshooting is all about correlating related pieces of information together to indentify where exactly the root cause of a problem lies. In my daily work as a DBA, I generally get phone calls like, “So and so application is slow, what’s wrong with the SQL Server.” One of the funny things about the letters DBA is that they go so well with Default Blame Acceptor, and I really wish that I knew exactly who the first person was that pointed that out to me, because it really fits at times. A lot of times when I get this call, the problem isn’t related to SQL Server at all, but every now and then in my initial quick checks, something pops up that makes me start looking at things further.

The SQL Server is slow, we see a number of tasks waiting on ASYNC_IO_COMPLETION, IO_COMPLETION, or PAGEIOLATCH_* waits in sys.dm_exec_requests and sys.dm_exec_waiting_tasks. These are also some of the highest wait types in sys.dm_os_wait_stats for the server, so it would appear that we have a disk I/O bottleneck on the machine. A quick check of sys.dm_io_virtual_file_stats() and tempdb shows a high write stall rate, while our user databases show high read stall rates on the data files. A quick check of some performance counters and Page Life Expectancy on the server is bouncing up and down in the 50-150 range, the Free Page counter consistently hits zero, and the Free List Stalls/sec counter keeps jumping over 10, but Buffer Cache Hit Ratio is 98-99%. Where exactly is the problem?

In this case, which happens to be based on a real scenario I faced a few years back, the problem may not be a disk bottleneck at all; it may very well be a memory pressure issue on the server. A quick check of the system spec’s and it is a dual duo core server with 8GB RAM running SQL Server 2005 SP1 x64 on Windows Server 2003 R2 x64. Max Server memory is configured at 6GB and we think that this should be enough to handle the workload; or is it? This is a unique scenario because there are a couple of things happening inside of this system, and they all relate to what the root cause of the performance problem is on the system.

If we were to query sys.dm_exec_query_stats for the TOP 10 queries, by max_physical_reads, max_logical_reads, and max_worker_time, we may be able to find some queries that were using excessive I/O and possibly CPU against the system in their worst single execution. We can also CROSS APPLY to sys.dm_exec_sql_text() and see the statement text, and also CROSS APPLY sys.dm_exec_query_plan() to get the execution plan stored in cache. Ok, quick check, the plans are pretty big, I see some large index seeks, that estimate 2.8GB of data movement between operators, but everything looks like it is optimized the best it can be. Nothing really stands out in the code, and the indexing looks correct, and I should have enough memory to handle this in cache, so it must be a disk I/O problem right?

Not exactly!

If we were to look at how much memory the plan cache is taking by querying sys.dm_os_memory_clerks for the CACHESTORE_SQLCP and CACHESTORE_OBJCP clerks we might be surprised at what we find. In SQL Server 2005 RTM and SP1, the plan cache was allowed to take up to 75% of the memory under 8GB. I’ll give you a second to go back and read that again. Yes, you read it correctly, it says 75% of the memory under 8GB, but you don’t have to take my word for it, you can validate this by reading Changes in Caching Behavior between SQL Server 2000, SQL Server 2005 RTM and SQL Server 2005 SP2. In this scenario the application uses an entirely adhoc workload against SQL Server and this leads to plan cache bloat, and up to 4.5GB of our 6GB of memory for SQL can be consumed by the plan cache in SQL Server 2005 SP1. This in turn reduces the size of the buffer cache to just 1.5GB, causing our 2.8GB of data movement in this expensive plan to cause complete flushing of the buffer cache, not just once initially, but then another time during the queries execution, resulting in excessive physical I/O from disk. Keep in mind that this is not the only query executing at the time this occurs. Remember the output of sys.dm_io_virtual_file_stats() showed high read stalls on the data files for our user databases versus higher write stalls for tempdb? The memory pressure is also forcing heavier use of tempdb to handle sorting and hashing in the environment as well.

The real clue here is the Memory counters for the instance; Page Life Expectancy, Free List Pages, and Free List Stalls/sec. The fact that Page Life Expectancy is fluctuating between 50 and 150 constantly is a sign that the buffer cache is experiencing constant churn of data, once every minute to two and a half minutes. If you add to the Page Life Expectancy counter, the consistent bottoming out of Free List Pages along with Free List Stalls/sec consistently spiking over 10, and you have the perfect memory pressure scenario. All of sudden it may not be that our disk subsystem is the problem, but is instead an innocent bystander and victim.

Side Note: The Page Life Expectancy counter dropping briefly and then returning to normal operating values intermittently is not necessarily a sign that the server is under memory pressure. The Books Online and a number of other references will tell you that this counter should remain on average above 300 which is the time in seconds a page will remain in cache before being flushed or aged out. This number, which equates to just five minutes, is incredibly low for modern systems and most published documents pre-date the predominance of 64 bit computing and easy availability to larger amounts of memory in SQL Servers. As food for thought, consider that my personal laptop has more memory in it than most SQL Servers did at the time those numbers were posted. I would argue that today, a system churning the buffer cache every five minutes is in need of some serious tuning or a hardware upgrade.

Back to our problem and its investigation:

There are two things really wrong with this server; first the plan cache is excessively consuming memory and bloated in size and we need to look at that and second we need to evaluate upgrading the memory to accommodate the workload being performed. In the case of the server I was working on there were a lot of single use plans found in sys.dm_exec_cached_plans (where usecounts=1). Single use plans waste space in the plan cache, especially when they are adhoc plans for statements that had concatenated filter criteria that is not likely to reoccur with any frequency.  SQL Server 2005 doesn’t natively have a way to evict a single plan from cache like SQL Server 2008 does, but MVP Kalen Delaney, showed a hack to evict a single plan by creating a plan guide for the statement and then dropping that plan guide in her blog post Geek City: Clearing a Single Plan from Cache. We could put that hack in place in a job to automate cleaning out all the single use plans periodically, minimizing the size of the plan cache, but a better solution would be to fix the application so that it uses proper parameterized calls to the database. You didn’t write the app, and you can’t change its design? Ok, well you could try to force parameterization to occur by creating and keeping plan guides in place, or we can try forcing parameterization at the database level by using ALTER DATABASE <dbname> SET PARAMETERIZATION FORCED and that might help. If neither of these help, we could periodically dump the plan cache for that database, as discussed as being a problem in Kalen’s blog post referenced above; not an ideal scenario.

The other option is to increase the memory on the server to 16GB or 32GB, if the hardware allows it, which will increase the size of the plan cache as well as the buffer cache. In SQL Server 2005 SP1, on a system with 16GB of memory, if we set max server memory to 14GB the plan cache could use at most 9GB  [(8GB*.75)+(6GB*.5)=(6+3)=9GB], leaving 5GB for the buffer cache.  If we went to 32GB of memory and set max server memory to 28GB, the plan cache could use at most 16GB [(8*.75)+(20*.5)=(6+10)=16GB], leaving 12GB for the buffer cache. Thankfully we have SQL Server 2005 Service Pack 2, 3, and 4 these days which include the changes in plan cache sizing discussed in the Changes to Caching Behavior between SQL Server 2000, SQL Server 2005 RTM and SQL Server 2005 SP2 blog post. In real life, when I was troubleshooting this problem, I spent a week trying to chase down the cause of the disk I/O bottleneck with our Server Admin and SAN Admin, and there wasn’t much that could be done immediately there, so I finally asked if we could increase the memory on the server to 16GB, which did fix the problem. It wasn’t until I had this same problem occur on another system that I actually figured out how to really troubleshoot this down to the root cause.  I couldn’t believe the size of the plan cache on the server with 16GB of memory when I actually learned about this and went back to look at it.

SQL Server is constantly telling a story to anyone that will listen. As the DBA, you have to sit back and listen to all that it’s telling you and then evaluate the big picture and how all the data you can gather from SQL about performance relate to each other. One of the greatest tools out there is actually a free in the form of Diagnostic Scripts for SQL Server 2005 and 2008, created by MVP Glenn Alan Berry. Glenn’s scripts collect a majority of the information that SQL has to offer for rapid troubleshooting of problems, and he includes a lot of notes about what the outputs of each individual query might be telling you.

When I read Pinal’s blog post SQL SERVER – ASYNC_IO_COMPLETION – Wait Type – Day 11 of 28, I noticed that he referenced Checking Memory Related Performance Counters in his post, but there was no real explanation about why checking memory counters is so important when looking at an I/O related wait type. I thought I’d chat with him briefly on Google Talk/Twitter DM and point this out, and offer a couple of other points I noted, so that he could add the information to his blog post if he found it useful.  Instead he asked that I write a guest blog for this. I am honored to be a guest blogger, and to be able to share this kind of information with the community. The information contained in this blog post is a glimpse at how I do troubleshooting almost every day of the week in my own environment. SQL Server provides us with a lot of information about how it is running, and where it may be having problems, it is up to us to play detective and find out how all that information comes together to tell us what’s really the problem.

This blog post is written by Jonathan Kehayias (Blog | Twitter).

Read all the post in the Wait Types and Queue series.

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

SQL SERVER – What is a Technology Evangelist?

When you hear that someone is an “evangelist” the first thing that might pop into your mind is the Christian church.  In fact, the term did come from Christianity, and basically means someone who spreads the news about their faith.  In the technology world, the same definition is true.

Technology evangelists are individuals who, professionally or in their spare time, spread the news about the latest new products.  Sounds like a salesperson, right?  No they are absolutely different. Salespeople also keep up to date with a large number of people, and like to convince others to buy their product – and some will go to any lengths to sell!  An evangelist, on the other hand, is brutally honest about the product, even if sometimes it means not making a sale.  An evangelist is out there to tell the TRUTH.  A salesperson needs to make sales.

An Evangelist offers a Solution independent of Technology used – a Salesperson offers Particular Technology.

With this definition in mind, you can probably think of a few technology evangelists you already know.  Maybe it’s a relative or a neighbor, someone who loves keeping up with the latest trends and is always willing to tell you about them if you ask even the simplest question.  And, in fact, they probably are evangelists and don’t even know it.  For a long time, the work of technology evangelism was in the hands of community and community technology leaders. Luckily now various organizations have understood the importance of the community and helping community to reach their goals. This has lead them to create role of “Technology Evangelists”.

Let me talk about one of the most famous Evangelist of the SQL Server technology. Technology Evangelist only belongs to technology and above any country, race, location or any other thing. They are dedicated to the technology.

Vinod Kumar is such a man, who have given a lot to community. For years he was a Technology Evangelist for Microsoft, and maintained a blog that was dedicated to spreading his enthusiasm for his favorite products.  He is one of the most respected Evangelists in the field, and has done a lot of work to define the job for other professionals. Vinod’s career has since progressed to the Microsoft Technology Center (read his post), but he is continuing to be a strong presence in the evangelism community.  I have a lot of respect for Vinod.  He has done a lot for the community and technology evangelism.  Everybody has dream to serve community the way he does, and he is a great role model for evangelists everywhere.

On his blog, Vinod created one of the best descriptions of a Technology Evangelist.  It defined the position and also made the distinction between evangelist and salesperson extremely clear.  I will include the highlights of that list here, because no one can say it better than Vinod:

  • Bundle of energy – Passion is their middle name
  • Wonderful Story tellers
  • Empathy, Trust, Loyalty, Openness, Accessibility and Warmth
  • Technology Enthusiast – Doers
  • Love people, people and more people – Community oriented
  • Unique Style and Leadership qualities !!!
  • Self-Confident, Self-Motivated but a student

(To read the full list, see: Evangelism Beyond Borders with Evangelists)

His blog is a must-read for anyone interested in technology evangelism as a career or simply a hobby.  His advice about how to gain an audience and become a trusted advisor is the best in the business.

I think there is an evangelist in everyone. I, too, consider myself a technology evangelist.  Regular readers of this blog will recognize that I am dedicated to bringing information to the masses, and that I pride myself on being both brutally and honest and giving every product fair consideration.

I think there is no better way of saying following subject.

“Once an Evangelist – Always an Evangelist!”

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



SQLAuthority News – A Successful Community TechDays at Ahmedabad – December 11, 2010

We recently had one of the best community events in Ahmedabad. We were fortunate that we had SQL Experts from around the world to have presented at this event. This gathering was very special because besides Jacob Sebastian and myself, we had two other speakers traveling all the way from Florida (Rushabh Mehta) and Bangalore (Vinod Kumar).There were a total of nearly 170 attendees and the event was blast. Here are the details of the event.

Pinal Dave Presenting at Community Tech Days

Pinal Dave Presenting at Community Tech Days

On the day of the event, it seemed to be the coldest day in Ahmedabad but I was glad to see hundreds of people waiting for the doors to be opened some hours before. We started the day with hot coffee and cookies. Yes, food first; and it was right after my keynote. I could clearly see that the coffee did some magic right away; the hall was almost full after the coffee break.

Jacob Sebastian Presenting at Community Tech Days

Jacob Sebastian Presenting at Community Tech Days

Jacob Sebastian, an SQL Server MVP and a close friend of mine, had an unusual job of surprising everybody with an innovative topic accompanied with lots of question-and-answer portions. That’s definitely one thing to love Jacob, that is, the novelty of the subject. His presentation was entitled “Best Database Practices for the .Net”; it really created magic on the crowd.

Pinal Dave Presenting at Community Tech Days

Pinal Dave Presenting at Community Tech Days

Next to Jacob Sebastian, I presented “Best Database Practices for the SharePoint”. It was really fun to present Database with the perspective of the database itself. The main highlight of my presentation was when I talked about how one can speed up the database performance by 40% for SharePoint in just 40 seconds. It was fun because the most important thing was to convince people to use the recommendation as soon as they walk out of the session. It was really amusing and the response of the participants was remarkable.

Pinal Dave Presenting at Community Tech Days

Pinal Dave Presenting at Community Tech Days

My session was followed by the most-awaited session of the day: that of Rushabh Mehta. He is an international BI expert who traveled all the way from Florida to present “Self Service BI” session. This session was funny and truly interesting. In fact, no one knew BI could be this much entertaining and fascinating. Rushabh has an appealing style of presenting the session; he instantly got very much interaction from the audience.

Rushabh Mehta Presenting at Community Tech Days

Rushabh Mehta Presenting at Community Tech Days

We had a networking lunch break in-between, when we talked about many various topics. It is always interesting to get in touch with the Community and feel a part of it. I had a wonderful time during the break.

Vinod Kumar Presenting at Community Tech Days

Vinod Kumar Presenting at Community Tech Days

After lunch was apparently the most difficult session for the presenter as during this time, many people started to fall sleep and get dizzy. This spot was requested by Microsoft SQL Server Evangelist Vinod Kumar himself. During our discussion he suggested that if he gets this slot he would make sure people are up and more interactive than during the morning session. Just like always, this session was one of the best sessions ever. Vinod is true to his word as he presented the subject of “Time Management for Developer”. This session was the biggest hit in the event because the subject was instilled in the mind of every participant.

Vinod Kumar Presenting at Community Tech Days

Vinod Kumar Presenting at Community Tech Days

Vinod’s session was followed by his own small session. Due to “insistent public demand”, he presented an interesting subject, “Tricks and Tips of SQL Server“. In 20 minutes he has done another awesome job and all attendees wanted more of the tricks. Just as usual he promised to do that next time for us. Vinod’s session was succeeded by Prabhjot Singh Bakshi’s session. He presented an appealing Silverlight concept. Just the same, he did a great job and people cheered him.

Prabhjot Presenting at Community Tech Days

Prabhjot Presenting at Community Tech Days

We had a special invited speaker, Dhananjay Kumar, traveling all the way from Pune. He always supports our cause to help the Community in empowering participants. He presented the topic about Win7 Mobile and SharePoint integration. This was something many did not even expect to be possible. Kudos to Dhananjay for doing a great job.

Dhananjay Kumar Presenting at Community Tech Days

Dhananjay Kumar Presenting at Community Tech Days

All in all, this event was one of the best in the Community Tech Days series in Ahmedabad. We were fortunate that legends from the all over the world were present here to present to the Community. I’d say never underestimate the power of the Community and its influence over the direction of the technology.

Vinod Kumar Presenting trophy to Pinal Dave

Vinod Kumar Presenting trophy to Pinal Dave

Vinod Kumar Presenting trophy to Pinal Dave

Vinod Kumar Presenting trophy to Pinal Dave

This event was a very special gathering to me personally because of your support to the vibrant Community. The following awards were won for last year’s performance:

Ahmedabad SQL Server User Group (President: Jacob Sebastian; Leader: Pinal Dave) – Best Tier 2 User Group

Best Development Community Individual Contributor – Pinal Dave



I was very glad to receive the award for our entire Community.

Attendees at Community Tech Days

Attendees at Community Tech Days

I want to say thanks to Rushabh Mehta, Vinod Kumar and Dhananjay Kumar for visiting the city and presenting various technology topics in Community Tech Days.

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

SQLAuthority News – Community Tech Days – December 11, 2010

Community Tech Days are very close on December 11.

The venue details are as following:

H K Hall, H K College Campus, Near Handloom House, Opp. Natraj Cinema, Ashram Road, Ahmedabad – 380009

Click here to Registration for the event.

Please read the announcement details here.

I will be speaking on following session.

Best Database Practice for SharePoint Server

This session will be very unique. I will be starting with a bit pessimistic talk about how one cannot many things in SQL Server when SharePoint Server is installed. I will go over in the details for the reasons for the same. Right after this 5 minutes I am going to show few things to attendees which they can apply right away to their database and instantly get the performance. I am going to share the easy scripts with them online right away and if they run the same on their SharePoint Database, they will get the performance right out of the box right away – I Promise!

This is the same session I presented at SharePoint Conference and I have received excellent feedback on the same subject.

Join us!

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


SQLAuthority News – Community Tech Days – A SQL Legends in Ahmedabad – December 11, 2010

Ahmedabad is going to be fortunate city again on December 11.

We are going to have SQL Server Legends present at the prestigious event of Community Tech Days in Ahmedabad.

The venue details are as following:

H K Hall, H K College Campus, Near Handloom House, Opp. Natraj Cinema, Ashram Road, Ahmedabad – 380009

Click here to Registration for the event.

Agenda of the event is as following.
10:15am – 10:30am     Welcome – Pinal Dave
10:30am – 11:15am     SQL Tips and Tricks for .NET Developers by Jacob Sebastian
11:15am – 11:30am     Tea Break
11:30am – 12:15pm     Best Database Practice for SharePoint Server by Pinal Dave
12:15pm – 01:00pm     Self Service Business Intelligence by Rushabh Mehta
01:00pm – 02:00pm     Lunch
02:00pm – 02:45pm     Managing your future, Managing your time by Vinod Kumar
02:45pm – 03:30pm     Windows Azure News and Introducing Storage Services by Mahesh Devjibhai Dhola
03:30pm – 03:45pm     Tea Break
03:45pm – 04:30pm     Improve Silverlight application with Threads and MEF by Prabhjot Singh Bakshi
04:30pm – 04:45pm     Thank you – Mahesh Devjibhai Dhola

Ahmedabad considers itself extremely fortunate when there are SQL Legends presenting on various subjects in front of community.

Here is brief introduction about them in my own words. (Their names are in order of the agenda).

1) Jacob Sebastian (SQL Server MVP) – This person needs no introduction. Every developer and programmer in Ahmedabad and India knows him. He is the one man who is founder of various community-related ideas like SQL Challenges, SQL Quiz and BeyondRelational. He works with me on all the community-related activities; we are extremely good friends.

2) Rushabh Mehta (SQL Server MVP) – If you use SQL Server – you know this man. He is the President of SQL Server of Professional Association (PASS) and one of the leading Business Intelligence (BI) Experts renowned in the world. He has blessed Ahmedabad once before and now doing once again this year.

3) Vinod Kumar (Microsoft Evangelist – SQL Server & BI) – Ahmedabad remembers him very well. During his last visit to Ahmedabad, a fight had almost broke outside the hall amidst the rush to listen him. There were more people standing and listening to him than those who were seated. This is one man Ahmedabad will never forget.

4) and Myself. I will not rate myself in the league of abovementioned experts, but I must say that I am fortunate to have friends like those above.

We also have two strong .NET presenters – Mahesh and Prabhjot.

During this event, there will be plenty of giveaways, lots of fun, demos and pure technical talk, specifically no marketing and promotion – just pure technical talk.

The most interesting part is that all the SQL Legends – Jacob, Rushabh and Vinod are for sure presenting on SQL Server but with a twist.

Jacob – He is going to talk about .NET and SQL – Optimization Techniques

Rushabh – He is going to talk about SQL and BI – Self Service BI

Vinod – He is going to talk about professional development of developers – Managing Time

Pinal – Best Practices for SharePoint Database Administrators – SharePoint DBA – I have presented this session earlier.

I promise this event is going to be one of the best events held ever. You can read about the earlier event over here.

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