SQLAuthority News – Meeting SQL Friends – SQLPASS 2011 Event Log

One of the biggest reason I go to SQLPASS is that my friends are going there too. There are so many friends with whom I often talk on Facebook and Twitter but I rarely get time to meet them as well talk with them. One thing I am usually sure that many fo them will be for sure attend SQLPASS. This is one event which every SQL Server Enthusiast should attend. Just like everybody I had pleasant time to meet many of my SQL friends. There were so many friends that I met and I did not click photo. There were so many friends who clicked photo in their camera and I do not have them.

Here are 1% of the photos which I have. If you are not in the photo, it does not mean I have less respect to our friendship. Please post link to our photo together :)

I was very fortunate that I was able to snap a quick photograph with Pinal Dave with Dr. David DeWitt. I stood outside of the hall waiting for Dr. to show up and when he was heading down from convention center I requested him if I can have one photo for my memory lane and very politely he agreed to have one. It indeed made my day!

Pinal Dave with Dr. David DeWitt
Pinal Dave with Dr. David DeWitt

Every single time I met Steve, I make sure I have one photo for my memory. Steve is so kind every single time. If you know SQL and do not know Steve Jones, you do not know SQL (IMHO).

Following is the photograph with Michael McLean. More details about this photo in future blog post!

Pinal Dave, Michael McLean, and Rick Morelan
Pinal Dave, Michael McLean, and Rick Morelan

Arnie always shares his wisdom with me. I still remember when I very first time visited USA, I was standing alone in corner and Arnie walked to me and introduced to every single person he know. Talking to Arnie is always pleasure and inspiring.

Arnie Rowland and Pinal Dave
Arnie Rowland and Pinal Dave

I am now published author and have written two books so far. I am fortunate to have Rick Morelan as Co-author of both of my books. He is great guy and very easy to become friends with. I am very much impressed by him and his kindness during book co-authoring. Here is very first of our photograph together at SQLPASS.

Rick Morelan and Pinal Dave
Rick Morelan and Pinal Dave

Diego Nogare and I have been talking for long time on twitter and on various social media channels. I finally got chance to meet my friend from Brazil. It was excellent experience to meet a friend whom one wants to meet for long time and had never got chance earlier.

Buck Woody – who does not know Buck. He is funny, kind and most important friends of every one. Buck is so kind that he does not hesitate to approach people even though he is famous and most known in community. Every time I meet him I learn something. He is always smiling and approachable.

Pinal Dave and Buck Woddy
Pinal Dave and Buck Woddy

Rushabh Mehta is current SQL PASS president and personal friend. He has always smiling face and tremendous love for SQL community. I often wonder where he gets all the time for all the time and efforts he puts in for community. I never miss a chance to meet and greet him. Even though he is renowned SQL Guru and extremely busy person – every single time I meet him he always asks me – “How is Nupur and Shaivi?” He even remembers my wife and daughters name. I am touched.

Rushabh Mehta and Pinal Dave
Rushabh Mehta and Pinal Dave

Nigel Sammy has extremely well sense of humor and passion from community. We have excellent synergy while we are together. The attached photo is taken while I was talking to him on Seattle Shoreline about SQL.

Pinal Dave and Nigel Sammy
Pinal Dave and Nigel Sammy

Rick Morelan wanted my this trip to be memorable. I am vegetarian and I told him that I do not like Seafood. Well, to prove the point, he took me to fantastic Seafood restaurant in Seattle and treated me with mouth watering vegetarian dishes. I think when I go to Seattle next time, I am going to make him to take me again to the same place.

Rick, Rushabh, Pinal and Paras
Rick, Rushabh, Pinal and Paras

Well, this is a short summary of few of the friends I met at Seattle. What is the life without friends, eh?

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

SQLAuthority News – Story of Seattle – SQLPASS 2011 Event Log

Just like every year I attended SQL PASS in Seattle earlier this month. The event was scheduled from Oct 11-14, 2011 in the convention center of the Seattle. I have been to Seattle more than 6 times so far so it is not a new city for me anymore. The city has always impressed me with its vibrant life and pleasant weather. Just like every other time, I had excellent experience once again in the city. Though I just arrived on the day of the event and left right after the event was over – I hardly visited Seattle – still some good experience to share. Here are few quick photographs from my quick trip of Seattle city.

Skyline of Seattle
Skyline of Seattle
Seattle Convention Center
Seattle Convention Center
A Shop Tenzing Momo and Co at Pike St Market
A Shop Tenzing Momo and Co at Pike St Market
The Seattle Gum Wall
The Seattle Gum Wall
Shoreline in Seattle
Shoreline in Seattle
Nigel and Paras
Nigel and Paras
First Starbucks (Relocated)
First Starbucks (Relocated)
People on Street of Seattle
People on Street of Seattle
Food at Sandy's - All Veg
Food at Sandy’s – All Veg

Well, this is a short summary of my extremely quick city tour of Seattle.

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

SQL SERVER – Next Version of SQL Server ‘Denali’ is Officially Named as SQL Server 2012

Recently I attended SQLPASS 2011 and it had few announcements and some of them really important. I am going to write in detail in future all the announcements. However, there is one announcement needs special attention and blog post. The official name of the next version of the SQL Server. So far we were all addressing the next version of the SQL Server as SQL Server ‘Denali’.

Microsoft VP Ted Kummert announced the official name of the next version of the SQL Server – SQL Server 2012. The version of the SQL Server will be 11. The release date is estimated in the first half of the year 2012. Here are two important updates which are related to SQL Server 2012.

  • Apache Hadoop will power Azure Cloud Services and Windows Deployments.
  • New touch-based data exploration capabilities will be extended to other devices.

Additionally, SQL Server Crescent project also got new name as Power View. A new Data Explorer tool will be also released that will make it easier to browse and use data from public-cloud data sources. There is a blog post from SQL Server Team on roadmap on big data.

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

SQL SERVER – SQLPASS Memory Lane of 2009 and 2010

Today is the last day of the SQLPASS 2011 and I will be soon posting SQL Server 2011 experience over here.

We all change, life change, event changes, experiences change and but memory hardly changes. I have quite commonly noticed that we all remember the good memories for long time and no matter how bad the memories are we often forget the same.

Here is my experience of my earlier experience of attending SQLPASS.

SQLAuthority News – SQLPASS Nov 8-11, 2010-Seattle – An Alternative Look at Experience

SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle

Every year SQLPASS is getting better for me and I am learning a lot more than earlier year.

I am extremely overwhelmed with the love and support showed by community towards my SQL Server Wait Stats book [Amazon] | [Flipkart] | [Kindle].

I thank you from my bottom of the heart!

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

SQLAuthority News – SQLPASS – Today FREE 100 SQL Wait Stats Book Print Copy – Book Signing

“If there’s a book you really want to read, but it hasn’t been written yet, then you must write it.” ~Toni Morrison

I wrote book on SQL Wait Stats. [Amazon] | [Flipkart] | [Kindle]

I really wanted to learn about SQL Wait Stats. There was no real book available so I wrote the book myself. Since I wrote this book, I feel I can now more 100 pages to what I had contributed. I am very fortunate that my SQL Wait Stats book is very well accepted in community. Every author who authors book has dream that his book is well received and well read. In the recent internet era eBooks and PDF copies are everywhere and the job of reading print book and using bookmark is getting faded. Just like the same every author wants to have their books book signing event. I am so fortunate that during this SQLPASS the similar opportunity has presented to me.

I will be also doing book signing but here is interesting twist – you do not have to purchase the books (USD 11.99) – this book will be FREE for you.

Here are further details:

Event: SQL Server Wait Stats Book Signing
Date: October 13, 2011 Thursday
Time: 1 PM to 2 PM
Location: SQLPASS Exhibitors Booth #300

Thanks to kind people at expressor Studio for kindly helping me to with this arrangement.

Read the review of the book on SQLConcepts and on flipkart.

See you tomorrow!

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

SQLAuthority News – SQLPASS – 100 SQL Wait Stats Book Print Copy Giveaway – A Book Every Minute for an Hour Tomorrow

“Appreciation is a wonderful thing: It makes what is excellent in others belong to us as well” – Voltaire

“The greatest of all gifts is the power to estimate things at their true worth” – Francois De La Rochefoucauld

Please Note: The date and time are Thursday 13 at 1 PM (not Wednesday) – there are few emails asking for the same.

Quotes listed above are really relevant to the news of the day. Regular readers of my blog knows that I have published SQL Server Wait Stats [Amazon] | [Flipkart] book. I am glad to say that this book has become extremely popular since it has been published. It has ran out of stock in India two times thus far. In USA, we could manage the inventory efficiently. This book is now available on Kindle (at a price less than that of a coffee).

Recently, the kind people at expressor Studio have previously gave away few copies of my book. The same folks have sent me email that they got excellent feedback for the book from the readers who received the book. They have decided to give away 100 copies of my Wait Stats Print Book on Thursday October 13, 2011 between 1.00 and 2.00 PM at SQLPASS exhibition at Booth #300. I am just speechless at their efforts and good will for my book.

Tomorrow, I will be available between 1.00 and 2.00 PM at booth #300 and signing the books personally. Just stop by the booth and pick up the book. We intend to give away 1 book every minute of that hour. Honestly, it will be more than 1 book as there will be 100 books to give away during the short period of 60 minutes (on First come first serve basis!)

See you tomorrow!

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

SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2011 – Seattle

For the third year in a row, I am attending the SQLPASS Summit, October 11-14. Every year I have explained my reasons for attending this conference in Seattle, and this year I will state those reasons again.

WHY?


I have written two articles on this subject, which you can read here: 2009 and 2010. My main reason for attending has not changed – I love it!

Why should I attend PASS Summit?

There are not one or two but many reasons why I should be a part of PASS Summit. First, it is a good platform to learn the latest skills and strategies.  This year there are over 170 expert-led technical sessions as well as two days of pre-conference sessions, which will include every aspect of SQL Server. Here, I can sharpen my skills and update myself with the latest SQL Server topics and technologies. This knowledge will help me to optimize SQL Server. It also allows me to stay ahead of the curve as I will be one of the first professionals to learn about the latest advances, roadmaps, and plans for Microsoft SQL Server.

I can learn SQL Server best practices from thousands of SQL Server MVPs, Microsoft team members, authors, experts, and peers who will attend the event.  The highlights of this PASS Summit should be the keynote speakers, Microsoft’s Ted Kummert, Quentin Clark, and David DeWitt. I can even equip myself with the strategies and skills to improve the ROI of my SQL Server environment such as virtualization technologies, performance tuning and scaling, better hardware utilization, simplified management, and need for better business intelligences, to name a few. Furthermore, I can take advantage of the group discount and enhance the knowledge and skills of the entire team.

The four-day event will be marked by a lot of learning, sharing, and networking, which will help me increase both my knowledge and contacts. Every year, PASS Summit provides me a golden opportunity to build my network as well as to identify and meet potential customers or employees. If I am a consultant or vendor who is looking for better career opportunities, PASS Summit is the perfect platform to meet and show my skills to my new potential customers and employers. Moreover, if I am already employed in an organization, here I can get in touch with top-class SQL Server experts who can help me with any future needs. 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 I can have direct access to Microsoft developers, service and support, and MVPs.

At PASS Summit, I gain not only new ideas but also inspire myself from top professionals and experts. Learning new things about SQL Server, interacting with different kinds of professionals, and sharing issues and solutions will definitely improve my understanding and turn me into a better SQL Server professional who can leverage and optimize SQL Server to improve business.

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

SQLAuthority News – SQL Server 2008 R2 Hosted Trial

This is a bit old news but for me but it will new for many of you know.

SQLPASS, Dell, Microsoft and MaximumASP has come together and build hosted environment for free to all of us to use and experiment with.

Register now to try out up to seven labs:

  • SQL Server 2008 R2 – Multi Server Management
  • SQL Server 2008 R2 – PowerPivot
  • SQL Server 2008 R2 – Reporting Services
  • SQL Server 2008 R2 – Master Data Services
  • SQL Server 2008 R2 – StreamInsight
  • SQL Server Integration Services – Introduction
  • SQL Server Integration Services – Intermediate to Advanced

Now this is indeed wonderful opportunity as you do not need to buy anything and get world class experience with this products.

Register here.

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

SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle

Update: Do not forget to checkout last three photos and follow me on twitter (of course!)

I have previously documented my four-day experience of SQL PASS 2009 Summit at Seattle. There were many reasons for SQL enthusiasts to attend the SQL PASS event; I am listing my own reasons here in order of importance to me.

  • Networking with SQL fellows and experts
  • Putting face to the name or avatar
  • Learning and improving my SQL skills
  • Understanding the structure of the largest SQL Server Professional Association
  • Attending my favorite training sessions

During these four days, there was so much happening that it is difficult to document everything. I had tried to cover this event briefly on a daily basis in the following blog posts:

SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 1
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 2
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 3
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 4

I will list a few of the additional details that I have not included in the earlier post. Keynotes were the best part of the event, and I have covered major points of the keynote in above mentioned posts. I had met many SQL Legends during this event and included information regarding them. However, there were few things I still missed and I am listing them here. Seattle is great city, and I am visiting it the second time. This time I got an opportunity to take the Underground city tour and I had really enjoyed.

Washington Convention Center
Washington Convention Center
Undergroud Tour 1
Undergroud Tour 1
Undergroup Tour 2
Undergroup Tour 2

It was great to meet SQL Server MVP Glenn Berry at the MVP Summit. He is a very kind and friendly person. You will always find him hanging around with people from different organizations and countries. If you try to eavesdrop his conversation, you will hear terms like ‘dmv’, ‘performance’, and ‘optimized query’ very often. He is very much known for his excellent optimization script known as “SQL Server 2008 Diagnostic Information Queries“. If you have never taken a look at that, I urge you to go there and check this out. I believe that even if he blogs once a year only with this script, his fans will not complain. I have previously published his interview on my blog. Please note that he is the only person ever featured in an interview on this blog.

Glenn Berry and Pinal Dave
Glenn Berry and Pinal Dave

It depends! This is one most loved (or hated) phrase in the world of programmers or DBA. It is quite common to start answering question using this phrase. Mostly, this phrase initiates humor but rarely, people take this as offence. Again the intent of speaker is not always conveyed properly, it depends on how the phrase is used (I could not resist to use this phrase as well :P). I had very interesting discussion with Michelle Ufford and Jason Strate when we were waiting for coffee at one afternoon. We discussed both the sides of this phrase. Michelle suggested many good points when and why this phrase is valid. Jason also suggested that this phrase is commonly used a) when the presenter does not have sufficient information to answer or b) when the presenter does not know the answer. We discussed that it would be really interesting to start the conversation answering the most possible answer and then talking about special cases (for which it depends is quite commonly used.) Let us see one example.

Michelle Ufford, Jason Strate, Pinal Dave
Michelle Ufford, Jason Strate, Pinal Dave

Q: Does index improve performance?
A1: It depends on query and data you have.
A2: Usually YES; however, there are cases when it reduces performance, for which the query and data needs to be examined carefully.

There are times when it depends totally make sense. I use it several times; I love the blog of Andy Warren which talks is branded as it depends. This discussion between three of us was just a friendly discussion, and if you think we are talking about you, it is wrong!

During this event, I had great conversation with SQL Legend Buck Woody. This man is full of energy and may be the most loved person in this summit. His session was the funniest session I have ever attended. At the end of his session, I had more than 2 pages of my notebook filled with notes. If I have wrote down how many times, I have laughed loudly, I would have no time to do anything else. Buck had a good hour of discussion with me. We discussed many different topics, ranging from Community to Microsoft and Collage Students to SQL. I am very thankful to Buck for spending his valuable time with me – I am honored.

Buck Woody and Pinal Dave
Buck Woody and Pinal Dave

Joe Celko – this name is very popular in SQL world, and I admit that I was always afraid of him. Every time I see his photo, I just felt nervous. I never thought that I should meet him. Honestly, for the same reason, I did not attend his session. I was absolutely wrong. I met him right after his session was over. He is one of the most friendly people I have met in my life. He is very soft spoken. He gauges the level and understanding of other person and speaks at the same level. He made me laugh and taught many good techniques for how to become good speaker and presenter. When I said I was sorry that I was scared of him, he laughed and said that he knows this. Boy, what a mistake I did!! I should have attended his session. Well, at least I am accepting my mistake here. He is indeed a very friendly soul. He promised me that one time he will come to India.

Brian Moran is the newly elected board member; I would like to call him as ‘the Man with 1000 successful ideas‘. You have to come across him to know what I am talking about. I had the great opportunity to meet him and discuss few things, besides SQL. Brian had many excellent ideas about how to build the community, how to help SQL PASS and few excellent ideas about how to take PASS to the next level. I am glad that he is one of the board members for PASS. PASS is all about passion, and Brian clearly demonstrates the same.

Pinal Dave, Joe Celko, Brian Moran
Pinal Dave, Joe Celko, Brian Moran

I met all of them and had a great conversation with them. It was great to meet Ed Hackney; he is a wonderful person and very easily approachable. He talked about SQL community in India and how any community cannot be restrained within geographical boundaries.

Ed Hackney and Pinal Dave
Ed Hackney and Pinal Dave

I was waiting to meet Thomas LaRock. He is an excellent SQL Master, and he talked in detail about outsourcing SQL technology and SQL community. I really enjoyed meeting him and spending some time with him during the summit. I plan to learn more from him when I meet him next time.

Thomas LaRock and Pinal Dave
Thomas LaRock and Pinal Dave

Robert Cain, he is one of the very few SQL masters, who have expertise in .net and Business Intelligence at the same time. I have previously wrote about him in Big Thinkers – Robert Cain. He has given approval that I can write about his BI presentation on this blog. I will write about it soon.

Chris Massy, Robert Cain, Pinal Dave
Chris Massey, Robert Cain, Pinal Dave

I have previously written a lot about Greg Low on this blog. However, I just can not resist to put this excellent photo once again here. He has great respect for the international community; and he had spent some quality time with me discussing how to enhance and grow the global community. Greg gave his insight and few plan cache tips as well. You can read my review of his book ‘Book Review – The Rational Guide to Building Technical User Communities (Rational Guides)‘. You can also read our discussion on plan cache ‘SQL SERVER – Plan Caching and Schema Change – An Interesting Observation‘.

Greg Low and Pinal Dave
Greg Low and Pinal Dave

Following image is for sure very interesting! Can you recognize the person? Well, just go here and read about Mr. Denny. And I do have permission from him to publish this photo!

Mr. Danny
Mr. Danny

PASS 2010 dates are announced; this event will take place between 8 and 12 November 2010.

PASS 2010
PASS 2010

Following image is my favorite as it brings the future and past of PASS together. Kevin Kline, a hero of PASS summit, (as he dedicated 10 years of his life to serve PASS board) is in same frame with Rushabh Mehta, who is President Elect for 2010.

Past President Kevin Kline and Future President Rushabh Mehta
Past President Kevin Kline and Future President Rushabh Mehta

Now I am coming to the most interesting part of my experience. I want to introduce to all of you the youngest SQL PASS fan and follower. Her name is Shaivi Dave, and she is big fan of SQL PASS! Shaivi suggests that save your money and register right away for PASS. There is no other conference which is as valuable as SQL PASS.

Nupur Dave and Shaivi Dave
Nupur Dave and Shaivi Dave
Pinal Dave and Shaivi Dave
Pinal Dave and Shaivi Dave

She had conveyed her wish to SQL PASS President Elect Rushabh Mehta when she was just 19 days old. May be one of following years, we will see her at summit.

Rushabh Mehta, Shaivi Dave, Pinal Dave
Rushabh Mehta, Shaivi Dave, Pinal Dave

This is note is addendum to my four original posts. I strongly suggest you all to read my earlier posts for details on keynote and other SQL legends.

SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 1
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 2
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 3
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 4

If you have visited this event and have something more to add to what I have written, please feel free to add it here as a comment. I am looking forward for you all to add more details and information here. Follow me on twitter.

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

SQL Server 2008 Diagnostic Information Queries

SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 4

Fourth day was awesome! I had scheduled nearly 8 meetings with different groups of people today. It was really great fun. Let us see the keypoints for the same.

  • PASS President Wayne Snyder honored and thanked Kevin Kline for his 10 YEARS of service.
  • Kevin then gets a well-deserved standing ovation from the entire audience.
  • Next year’s PASS Summit will be in Seattle from November 8 to 11, 2010.
  • Dell Key note was little flat in delivery. Dell was primary sponsor for the event.
  • Dr. David DeWitt, Technical Fellow, Data & Storage Platform Division at Microsoft starts presentation entitled “From 1 to 1000 MIPS.” One of the best sessions I ever had in my life.

The keynote was followed by several meetings. There was lot of food, drinks and entertainment all around. I received so much swag that I had to get brand new bag to contain the same. I will post the photos of the stuff that received once I reach home. I will be heading towards airport in next 15 minutes. So, I will be disconnected from the Internet for 36 hours once I board the flight. I am uploading only 2–3 photos at this moment. Check here again as I have nearly 30 more photos to share.

Buck Woody Presenting Excellent Funny Session

I really enjoyed the summit. I will post the in-depth summary of my whole trip to USA once I reach home. Thank you PASS; I will come here next year!

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