SQLAuthority News – Business Intelligence Training Roadshow August September 2009

UPDATE : This is FREE training.

I quite often receive request from readers and expert from all over the world if I do any training for SQL Server. Currently I am on Tour of 8 different stats of India and will be training on Business Intelligence Boot Camp.

Here is quick image of the topics, which I am going to cover this boot camp.

Currently, I am schedule to deliver the same course in many of the cities as described below.

Let me know if you are interested in doing similar session at your city or organization and we can arrange one based on my upcoming schedule.

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

SQLAuthority News – Two Virtual Tech Days Sessions – Watch it Online

Indias premier online technical event is back again with the 6th Edition of Microsoft Virtual TechDays, scheduled to be held between August 19 -21, 2009. During these three days, you will have an opportunity to deep-dive into latest Microsoft Technologies and get a resolution to your most puzzling technical problems directly from the Technology Experts.

I will be presenting two of the SQL Server Sessions on second day of the event on August 20th, 2009.

SQL Server 2008: High Availability with SQL Server 2008 – “When, what where and how?
Timing: 10:30am-11:45am
Often in implementing High-Availability (HA) options with SQL Server we have seen people confuse it with DR options. This sessions brings out the practical things to consider using HA options and some of the core features introduced with SQL Server 2008 which makes some of the HA options so compelling for Enterprises to use. HA options can be used in various mix-and-match flavors and this session shows how a combination can get compelling architectures one can implement.

SQL Server 2008 – Performance tuning – Learn the techniques of the master for server tuning
Timing: 2:15pm-3:30pm
If your system has a performance problem, how do you know whether the problem lies in the application or the database? You need a tool that will let you view interactions between the application and the database, and that’s where Microsoft SQL Server Profiler and a number of other tools comes in. In this webcast, we’ll take a look at some common problems (with CPU, Memory, Network, Storage etc) and teach you how to analyze those tricky performance problems that lie somewhere between the application and the database but the components that surround them.

Do not wait and register today!

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 – Book Review – The Rational Guide to Building Technical User Communities (Rational Guides)

The Rational Guide to Building Technical User Communities (Rational Guides) (Paperback)
by Greg Low

Short Review : A Great, one-of-its-kind book for everybody who is interested in building technical user community. There is no other book written on this subject but after this comprehensive book no further reading will be required.

Link to Amazon

Detailed Review :

This is for the first time in my book review, instead of talking about the book or author, I will introduce myself in a couple of lines to explain why and how this book is helpful to those interested in building community. I am a Microsoft MVP and the founder of SQLAuthority.com. I am actively involved with Technical User Group Community  all over the world and have been helping many user groups to start, grow and continuously expand successfully. I am helping user groups in capacity of their mentor to overcome any obstacles they face while running the user group.

Author Greg Low is the most experienced person when it comes to community and people. He is a Microsoft Regional Director as well as mentor for Solid Quality Australia. For over a decade, he organized several Queensland User Groups. Greg is looked upon for guidance when User Groups are in need of the most appropriate advice. He is a very renowned person in technical community and does not need any further introduction.

This book focuses on the most important lessons learned by Greg over decades of involvement in technical communities. It provides practical advice on establishing, sustaining and growing these communities. This books is focused on helping user group leaders to deal with any potential pitfalls and contains workaround as well. The book is not limited to only user group leaders. In fact, this book is for everybody who is interested in community. If you are already a member of a community, this book is a perfect guide to help you get the most out of your membership.

The first chapter, which is appropriately named as – “People, Not Technology,” sets the pace and keeps up the concept live till the end of the book. In community, staying in focus is very important for people as everything revolves around it. No matter how knowledgeable  or renowned a person is in the domain of technology, if he is not a people’s person, he cannot become an integral part of community and can never grow. For any technology to survive, support from people is required. Community provides combined power of people to lend strong support to community.Throughout the book, this key concept is cherished and explored.

Greg talks about two very important challenges for any technical community. 1) Finding Speaker and 2) Finding Operational Funds. If these two things are done appropriately the heart of any community, which is “Finding People,” comes to shape on its own. I run few User Groups and they are growing tremendously. Recently, we have been discussing about lots of legal issues. That was the prime reason why I chose to read this book. After reading this book through and through, I presented the valuable ideas from this book to my fellow leaders , and we all agreed on them right away. The rich experience that Greg  shares with his readers can effectively  solve their problems. Because of this book, we were no longer required to spend money on lawyer and instead we will now divert that fund toward our scholarship program.

Each chapter of this book is build to stand alone and it covers the subject with sufficient breadth. I really liked the real-life examples from Greg, where he talks about his friends, fellow MVPs, SQL Server Groups Leaders and other important people of community. As each chapter is written to have independent read, same topics have been covered  twice. But what I liked about it is that same subject conveys different meaning when it is presented in a different consent. This particular aspect of the book, makes it a genuine must-read book.

One negative aspect of this book is that a very important checklist of the book is only given to those who will register online. If you have a friend who owns this book and has already  registered online, you can ask that friend to pass this important stuff to you. One more thing, I would like to request Greg to include his latest learning from  his experience as a Global Community Development of PASS, in the next version of his book. I am sure that more information about international technical user groups can be now included.

Rating : 5 Stars

Summary : A must-have book for everybody who is involved with technical community in any capacity. This is a unique book on this subject.

PS : I read this book while I was traveling from Kerala to Gujarat after attending a TechEd Event.

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

SQLAuthority News – TechEd on Road Ahmedabad June 20, 2009 – An Astounding Success

TechEd on Road Ahmedabad

In India, TechEd was held in Hyderabad in the month of May. You can read myTechEd summary article here. A similar event will be organized in 10 major cities in India.

Ahmedabad saw its first TechEd on Road and it was wholeheartedly welcomed by technology enthusiasts. The event was held at Rock regency, in the heart of Ahmedabad on June 20, 2009. We had attendees traveling over 500 miles to attend the event. We had attendees from Delhi, Mumbai, Jaipur, Kerala, Baroda, Himmatnagar, Rajkot, among other cities from India. It was a joyous and overwhelming experience for me to see them travel all the way from different parts of India to participate in TechEd event. Hats Off to you all!

TechEd event was attended by 200+ attendees. One of the reasons why this event had created lots of anticipation, which eventually lead to oversubscribed event, was two back to back SQL sessions by SQL Server MVPs. Pinal Dave and Jacob Sebastian; both are renowned for their technical sessions and their unique style of presentation.

Scroll down at the end of this article for photographs of the event.

Technical Sessions

The Official time to commence the event was at 1:45 PM but we had attendees pouring into the hall since 12:00 PM. We held a special session for attendees who came in early to keep them engaged. We provided them the opportunity to win loads of gifts while they waited for the official sessions to start. I must express special thanks to our event coordinator Dipen Shah, a bright young man who has just graduated as a Computer Engineering from a prestigious engineering collage for his excellent quiz master skills. It’s great to see that next generation has so much passion for technology.

The most awaited event started sharp at 1:45 PM with Keynote where in the beginning Dipen explained what is TechEd and why this event is held. Pinal Dave known for his distinctive humorous style, started the keynote from the history of Microsoft Windows and the history of SQL Server. It was a 15-mins session where everybody thoroughly enjoyed and learned the root of technology and how it evolved with changing times. All the attendees enthusiastically participated during the keynote by Pinal Dave, and lots of gifts were given away. Jacob Sebastian picked up the keynote by Pinal Dave and continued the session. Pinal explained the history while Jacob explained the future. He explained how Microsoft is doing in terms of beyond relations and on other technological fronts. The audience really enjoyed learning about how technology progressed and how is it going and growing.

Jacob’s remark “ SQL Server being now 21 years old and can get married” created a riot of laughter!

The first session was by Pinal Dave on SQL Server Best Practices.

The second session was by Jacob Sebastian on Understanding Query Execution Flow and Optimization Tips.

If you want to know more about the technical details for these two sessions, then do not wait for my blog article. Attend our next user group meeting, which will be announced soon. The same session will be delivered by these two experts on request. Here, I can only say that these two sessions were very well appreciated by the attendees and everybody was extremely happy to be a part of this event.  The event lived up to everybody’s expectations!

Event Sponsors

I must thank all my sponsors for their support – Microsoft, PASS, Solid QualityMentors, Digicorp, Quest and Excellence Infonet. Ahmedabad is fast catching up as a technology hub and growing very fast. We got our registration full in less than 36 hours. We opened up stand by tickets and which were full by 100%.

When I expressed my situation to Rushabh Mehta of Solid Quality India and told him that the event is oversubscribed by 200% on the day prior to the event, he right away told me that he does not want anybody from the community to turn away from door disappointed and miss the wonderful opportunity to learn from this event. Rushabh promised to cover all additional costs to accommodate the additional attendees. Not only this, he sponsored SQL Server Cheat Sheets for all the attendees. Rushabh, special thanks to you! Because of your support we were able to accommodate everybody who wanted to attend this event.

Arya Events did a wonderful job of making this large scale event a very smooth flowing event. There were no queues and no claustrophobic feelings. We hope to have them for all of our future events. All the graphic designs and logistics were provided by Digicorp – a vibrant young company from Ahmedabad. USB drives were provided by Excellence Infonet.

Miscellaneous Details

  • Pinal Dave got awarded for being the winner of T-SQL Challenge by Jacob Sebastian.
  • New book of Jacob Sebastian – “The Art of XSD” was available in print.
  • SQL Server Cheat Sheets were very much in demand.
  • We ordered 50 more chairs while the event was going on, as we ran out of them again (this is third time in row – when we needed more chairs)
  • .NET MVP Kaushal Parik attended and encouraged every participant.
  • Four directors of Digicorp - Abhishek, Nachiket, Kuntal and Sanket were present at the event to give their support.
  • Ritesh Shah of SQLHub performed really well and answered almost all the questions and won the highest number of gifts.
  • Mahesh Dhola announced his next event.
  • Kaushal Bhavsar Microsoft Student Partner was present throughout the event.


This event had so many giveaways that almost all the attendees got something. One of the attendees told me that he received 7 goodies today. Well, undoubtedly it was fun to share some of the nice things with all attendees.

  • 18 T-shirts
  • 3 Solid Quality Learning Polo Premium Shirts
  • 9 USB drives
  • 10 stress balls
  • 3 technology books
  • 33 high quality pens
  • 300 SQL Server Cheat Sheets
  • 200 Query Execution Flow Chart
  • 200+ SQLAuthority.com and BeyondRelations.com Stickers


TechEd On Road Ahmedabad

TechEd On Road Ahmedabad

Pinal Dave at TechEd on Road Ahmedabad

Pinal and Jacob

Pinal Dave from SQLAuthority.com

Jacob Sebastian from BeyondRelational.com

Pinal Dave at TechEd on Road Ahmedabad

Jacob Sebastian at TechEd on Road hmedabad

Dipen Shah (Microsoft Student Partner)

Dipen Shah (Microsoft Student Partner)

Pinal and Kaushal (MVP)

Pinal and Kaushal (MVP)

Pinal and Ritesh (SQLHub)

Pinal (SQLAuthority.com), Aryaman (Arya Events), Jacob (BeyondRelational.com)

Pinal (SQLAuthority.com), Aryaman (Arya Events), Jacob (BeyondRelational.com)

Nupur and Pinal – SolidQ and SQLAuthority Crew

Please note: I have a few SQL Server stickers as well as SQL Server Cheat Sheets still left with me. If you want them then please send me email at pinal ‘at’ sqlauthority.com with your name, address and telephone number.

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

SQL SERVER – Why You Should Attend PASS Summit Unite 2009- Seattle

PASS Summit Unite 2009the premier event for SQL Server professionals – will be held in Seattle from November 2 to November 5. It is the largest and the most intensive Microsoft SQL Server conference in the world organized by SQL Server users for SQL Server users. This year marks the 10th Anniversary of PASS Community Summit, making the event even more special. Every year, this event sees a huge number of attendees, as apart from high quality technical sessions it provides unparalleled access to the Microsoft SQL Server development, SQL CAT, and Customer Service and Support teams.

PASS Summit is an ideal conference for people who want to expand their knowledge. Here, sessions are available for all levels of users, from novices to experts. Specialized sessions are organized for SQL Server users who manage and support SQL Server data platforms; design, architect, and implement database solutions; architect and develop SQL Server applications; and architect, develop, and administer business intelligence solutions. So, if you are a database administrator, application developer, business intelligence and IT professional or consultant you will benefit with the latest and comprehensive SQL Server knowledge available through highest-rated technical sessions and speakers. At PASS Summit, you can choose to become a volunteer, Summit Ambassador, or even a Speaker!

Why you should attend PASS Summit

There is not one or two but a number of reasons why you must be a part of PASS Summit. First, it is a good platform to learn the latest skills and strategies through over 160 expert-led technical sessions as well as pre/post-conference sessions, which will include every aspect of SQL Server. Here, you can sharpen your skills and stay up to date with the latest SQL Server topics and technologies. This knowledge will help you optimize SQL Server. It will also let you stay ahead of the curve as you will be among the first to learn about the latest advances, roadmaps, and plans for Microsoft SQL Server.

You will get to learn SQL Server best practices from thousands of SQL Server MVPs, Microsoft team members, authors, experts, and peers who will attend the event. You can even equip yourself with the strategies and skills to improve the ROI of your SQL Server environment such as virtualization technologies, performance tuning and scaling, better hardware utilization, simplified management, need for better business intelligences, to name a few. Further, you can take advantage of the group discount and enhance the knowledge and skills of the entire team; you can send 5 employees and save.

The three-day event will be marked by a lot of learning, sharing, and networking, which will help you grow both your knowledge and contacts. PASS Summit provides you a golden opportunity to build your network as well as identify and meet potential customers or employees. If you are a consultant, vendor, and are looking for better career opportunities, PASS Summit is the perfect platform to meet and show your skills to your potential new customers and employers. And if you are already employed at an organization, here you can get in touch with top-class SQL Server experts who can help you with any future needs. Moreover, breakfasts, lunches, and evening receptions, which are included with registration, are meant to provide more and more networking opportunities.

Apart from gaining knowledge and networking PASS Summit is a good platform to solve high-priority, mission-critical SQL Server issues through Microsoft “Ask the Experts” Lounge and the CSS First Aid Station where you can have direct access to Microsoft developers, service and support, and MVPs.

At PASS Summit, you will not just gain new ideas but will also be inspired from top professionals and experts. Learning new things about SQL Server, interacting with different kinds of professionals, and sharing issues and solutions will improve your understanding and turn you into a better SQL Server professional who can leverage and optimize SQL Server to improve business.

You can find the details of the sessions here:

And last and final reason why you should visit PASS – I will be there. Let us meet and talk SQL.

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