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

The third day at SQL PASS Summit was education + entertainment day for me. During the last 10 days, I woke up at 4:00 AM regularly. However, as I had way too much fun yesterday at various parties earlier, I did not get up till 7:30 AM. By the time I woke up, I realized that I was late for my early breakfast meeting with Solid Quality Global Mentors. I somehow managed to reach there at 8:00 AM and we talked for nearly an hour. After the meeting, I headed to Keynote. Keynote is the best time of the day and wanton one wants to miss it.

I actively cover all my activities on twitter. So do follow me on twitter for the updates!

Today’s Keynote was extremely entertaining and educating. Audience was seen having a great time at various demos. I wished that all our technical sessions should be like this session as it was one of the excellent demos. Let us see few quick notes from the Keynote.

  • Rushabh Mehta – President Elect started the keynote asking humorous question why there is no free drink at PASS and explained the budget
  • Projected revenues in FY 2010 are $3.2 million, a 15% drop in revenues, while there was a 40% increase in community spending. There was 67% reduction in IT expenses
  • Jacob Sebastian, the PASS Outreach Program leader, was recognized for his excellent leadership
  • Charley Hanania and Allen Kinsel won PASSion Award
  • Tom Casey, GM, Business Intelligence and Amir Netz presented excellent demos and future vision
  • Power pivot demos were excellent and warmly welcomed by community
  • Touchscreen Powerpivot demo was the major highlight of the Keynote
Keynote at SQLPASS
Keynote at SQLPASS

I attended technical session of Rushabh Mehta (President Elect for PASS, SQL Server MVP and CEO, Solid Quality India). He talked about ‘Overcome SSIS Deployment and Configuration Challenges’. Now, who knew that it would be very humorous session? Rushabh started the session with reference to the movie ‘What About Bob?’ and kept the whole session as story line of the movie. Many of us will agree that subjects like SSIS, deployment issues and configuration complexity are very dry subjects. However, with audience interaction and the presentation of this technically complex subject in simple words, the whole session was the highlight of the day. I confess that I am expert in BI, but not someone who knew it inside out. In fact, I am intrigued to learn more about this particular subject after attending this excellent session. I have requested Rushabh to spend some time with me and explain the extension of this subject.

Rushabh Mehta Presenting
Rushabh Mehta Presenting

I had many different meetings scheduled today. All of them were successful. I managed to run around the exhibition hall and meet many different MS vendors. I really enjoyed meeting them and I also learned about the upcoming technology. One of the vendors really impressed me with an excellent demo; I have requested the full evaluation version for their software. If they provide me the same, I will try that out and post my review here soon. If their software meets my expectations I have built after seeing the demo, I will sincerely wish to see them go mainstream with that product.

Steven Jones in Kilt
Jacob, Pinal and Jean Rene Roy
Microsoft Learning Center

During evening, I had two different parties to attend and both party were rockstar party. It is so interesting that no matter how many different parties we go, we usually find the same people walking around. I found very strong presence of Microsoft in both the parties. Party hosted by Solid Quality Mentors had excellent food and drinks. I met many different SQL Experts there and we did NOT talk SQL. It was party and time to relax! As there was such a fun, I was late to attend the party of Microsoft which was hosted at Gameworks. Everybody went crazy with the games. Lots of game, food and drinks again here as well.

Gameworks party

In the evening, I attended two different parties and both the parties were rocking to the fullest. It is so interesting that no matter how many different parties we go, we usually find the same people walking around. I found a strong presence of Microsoft in both the parties. Party hosted by Solid Quality Mentors had excellent food and drinks. I met many different SQL Experts there and we did NOT talk SQL! It was party and time to relax! As there was so much fun, I was almost late to attend the party of Microsoft, which was hosted at Gameworks. Everybody went crazy with lots of games, food, and drinks.

I just enjoyed the third day of the summit. Just one more day to go – I just wish this summit never ends. However, I strongly miss my family and especially my 2-month old daughter (and wife! – i know its clichéd but its true!!).

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

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

The second day of PASS started with very engaging and it started with an original game invented by Stuart Ainsworth. This game involves finding twitter people in real life. As I was not one of the square in bingo, I had decided to participate in game myself and try to win if I can. During this process, I felt guilty that I borrowed a pen from Stuart and did not return it back. In fact, after a while someone took the pen from me and never returned it. It is true that karma pays off! I should have returned it right away.

Keynote at SQLPASS

Well one very first thing in the day was having breakfast with SQL friends. I met few more celebrities and Arnie Rowland again, who is a genius and very friendly. We all headed towards Keynote at around at 10 PM. The Keynote was great; it started with very interesting details. The current PASS President presented few photos before starting the session. They are as follows:

  • Year 2009 PASS registration is 2,200 for the full day event
  • 24 hours of PASS had 50,123 session registrations from 3,524 people of 70+ countries
  • SQL Server Standard is coming back
  • Microsoft’s Bob Muglia talked about SQL Server on the very first day and its future, and he covered few interesting demos as well
  • Microsoft’s Ted Kummert talked about PASS and reasons to attend PASS. He also presented few testimonies from the customers and interesting demos

Once the session was over, I headed to SQLFool aka Michelle Ufford‘s session on Index Optimization session. As I mentioned earlier, she is one expert who should be respected for her extraordinary skills for index optimization.

Michelle Ufford

During lunch we had wonderful event called Features of Birds MVP Lunch. During this event, I talked about Change Data Capture (CDC). I was very fortunate that many people showed up at my table. I really hoped that I could have accommodated everybody; however, the table capacity was only 10. I promise to all of those who missed that I will do special online session.

Pinal on table of Change Data Capture
At Lunch – Birds of Feathers

Michelle’s session was followed up by Jacob Sebastian‘s session. This session was attended by a large group of XML fans. Just like any other session of Jacob, this session was very well received, and he got a lot of good feedback. Jacob is officially the human XML.

Jacob Sebastian

After these two back–to-back sessions, I felt that I have learned quite a lot for one day. With that confidence, I went to exhibition hall. In the hall, I met so many really cool people whom I always wanted to meet. I also received a lot of giveaways at the expo – 9 T-Shirts, 3 candy boxes, 1 tote bag, and 2 sweet little ducks. I am sure Shaivi (my two-month-old daughter) is going to love those little ducks.

Little Ducks

In the evening, Microsoft threw a very interesting party for all the Microsoft MVPs and it was great fun. Jacob and I were almost lost our way to the party location. We had to hire taxi to reach the location. The taxi driver asked us so many questions that we felt like we were at the prison interrogation location. However, the journey (which seemed a year long) was less than a mile! I met many friends and MS employees there. It was a very great place for interacting with everyone.

Party Evening

Overall, today went great at SQL PASS; I am eagerly looking forward to the upcoming events in the following two days.

Jonathan Kehayias and Pinal Dave
Ross Mistry and Pinal Dave
Pinal Dave at PASS

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

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

Day 1 at PASS was awesome. I usually write everything in detail when I have to cover any project. This time, I have decided to cover this event little bit differently and with lots of images. For day 1, I have more than 90 photos taken with many SQL celebrities and different sessions. I will be not able to cover all the photos taken today in this post. I will gradually post all the photos as I will do follow up posts. In this post, I will cover my activities on day 1 as well few of the photos that give you a visual tour of the spot that I have covered in one day.

Yesterday I went to city tour where I had walked on the streets of Seattle and had lots of fun. I went on an underground tour in Seattle and then got back to registration desk for registration. Day 1 started great; while I was going to checkout the venue, I had meet Blythe Morrow on my way to Seattle Convention Center. I consider this as great start of SQL PASS event as she has put in considerable work to make this event a success.

Bill, Blythe, Pinal

Being a vegetarian, thus far I have never faced any difficulties finding good food in USA.

Veg Maxican Meal

Not every one know that the name “Seattle”is native American name, and it was taken from the name of the Native American tribe chief, Seattle. Please visit this wiki article to read further on Seattle City.

Chief Seattle

I was also mesmerized with the set up at SQL Pass Summit. SQL PASS Head Quarter has put in considerable efforts in making this event successful.

SQL PASS Summit 2009

PASS Registration

I met many of the SQL celebrities during my very first day. As I mentioned earlier, I managed to click around 80 photos of the legends. I will share all of them soon.

PASS event is a community event, and the community is heavily encouraged. I was very fortunate to meet two of the very active community leaders in my meeting. They amaze me with their dedication to help the SQL Server Community: Joe Webb and Arnie Rowland.

Community Leads – Joe Webb, Pinal Dave and Arnie Rowland

I have previously mentioned that if I want to be like someone in SQL Community, it would be Steve Jones. He is the founder and current manager for the extremely popular site SQLServerCentral.com. The reason I aspire to be like him is that he is a very nice down-to-earth person who is always smiling. I also attended his SSC Party on day 1.

Pinal Dave and Good Old Friend Steve Jones

I have mentioned about Brent Ozar several times on our blog. He is the only person with spectacles besides me in following image. I have been very eager to meet him for many years and early morning, I got the opportunity to have breakfast with him and many other SQL Celebrities. I will write in detail about other members in the image in a separate blog post.

Brent Ozar (very left) and Excellet Fellow SQL Enthusiast

Midnight DBAs – (Sean and Jen) and Pinal

I have previously blogged about SQLFool for her excellent Automated Index Defrag Script, and I was very lucky to meet her on the very first day.

Pinal Dave and Michelle Ufford (SQLFool)

During evening I had delicious dinner along with PASS Regional Mentors. New President Elect Rushabh Mehta was also present the event to encourage our efforts.

SQL Server Regional Mentor Team and Rushabh Mehta

Allen White (with his wife), Jacob Sebastian and Pinal Dave

Overall, the first day went pretty well, I met many more experts and learned a lot of new tricks. I am looking forward to the second day of the event.

SQL PASS Summit 2009 and Pinal Dave

PASS Quizbowl

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

SQLAuthority News – 3 Year Old Blog – PASS Summit 2009 – 10.5 Million Views

This blog has reached a remarkable milestone. It is 3 years old today. So far, there have been more than 10.5 million views on this blog and more than 1140 articles. It is really exciting that on this very important day, I am attending my very first SQL PASS in Seattle. The feeling and excitement to attend the very first summit cannot be put into words. I have been waiting to attend this summit for almost a year now, and today this dream is materializing with my blog’s “birthday.”

You can read all of my articles written thus far here. I will keep you updated with my daily activities at SQL PASS. You can follow me on twitter as well, where I update my status on the same.

Thanks again for staying with me to make this blog a community event as well. Surprisingly, first November has always been a significant day in my life. In fact, three years ago when I started writing, I never thought of reaching this milestone.

1st Nov 2009 – At my very first SQL PASS Summit, Seattle 2009
1st Nov 2008 – Ended my 1 year Outsourcing Manager contract and planned to join SolidQ
1st Nov 2007 – Left USA after 7 years and headed back to India as a permanent resident
1st Nov 2006 – Birth of  SQLAuthority.com

My humble and sincere thanks to the almighty and my family for their unconditional support.

I have got lots of request for photos of Shaivi Pinal Dave (my daughter). Here are few photos.

Nupur, Shaivi and Pinal

Shaivi Dave

Here is the photos of my current superiors (boss!). Thank you very much to you as well. Following photos is taken just 2 hour before this blog post in Sheraton Lobby Downtown Seattle.

Please note : Though this post is meant to be posted for 1st Nov India time. However, as I am in USA and due to time difference of 13.5 hours, it is posted on 1st Nov US time, which translates as 2nd Nov India time.

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


SQLAuthority News – New PASS President Rushabh Mehta

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (Virtual Chapters) to webcasts and the annual PASS Community Summit – the largest gathering of SQL Server professionals in the world – PASS is dedicated to helping its members Connect, Share, and Learn.

Today was a big day as PASS announced the executive board members for the term starting on Jan 1, 2010. I would like to express my congratulations to all new executives of PASS. Please read official press note here.

The newly elected board members at executive positions are as following:

  • Rushabh Mehta – President
  • Bill Graziano – Executive Vice President, Finance
  • Rick Heiges – Vice President, Marketing

A little bit more details about executives.

Rushabh Mehta is a Mentor for Solid Quality Mentors’ global Business Intelligence Division and the Managing Director for Solid Quality India. Rushabh has worked with Microsoft SQL Server since 1998 and has designed and developed BI systems on the Microsoft platform since 2001, including a predictive analysis system, a health-care analysis solution, and a multi-terabyte financial decision support system. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James Financial, Jackson Hewitt, and Checkers. Rushabh has been an active volunteer with PASS since 2000 and has also served on the board  for a number of years. Rushabh is also a SQL Server MVP and a frequent speaker at large conferences and PASS Chapters around the world.

Bill Graziano is an active member of PASS since 2001, Bill currently serves on the Board of Directors, where he is responsible for the overall marketing for PASS and PASS Summit. Bill co-founded SQLTeam.com, a web site for SQL Server developers and database administrators. In addition to managing the site, he writes articles and helps users with their most vexing problems. An involved participant in the SQL Server community for seven years, Bill was recognized as a SQL Server MVP in 2004 and still holds that designation.

Rick Heiges is a Sr. Solutions Consultant with Scalability Experts working with customers on solutions within the SQL Server environment and educating users on SQL Server 2005 by speaking at user groups, conferences, labs, and road shows across the USA, Europe, and Africa. He holds an MBA and a M.S. in MIS as well as a B.S. in Computer Science. In addition, he also has attained MCTS:SQL2005 and MCITP:DBA certifications.

Not only are these three executives experts in their domain, but have been friends for many years. Here are few of their photos from their activities at old PASS events.

Rushabh and Bill
Rushabh and Rick
Kevin Kline, Rick and Rushabh

Many congratulations to all of you. SQL Server community has lots of expectation from you and we are confident that you will not only satisfy them but will go way beyond our imaginations.

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

Image courtesy: Rick Heiges, Rushabh Mehta, SQL PASS

SQLAuthority News – Birds-of-a-Feather (BOF) Lunch – SQL PASS Summit, Seattle, 2009

I received few emails regarding where can people meet me at SQL PASS event in Seattle. I am currently in Bellevue attending Itzik Ben-Gan’s class. I am immensely enjoying the class, and I shall post details about the class once it is over.

If you are attending SQL PASS and interested to meet me, I will be present at Birds-of-a-Feather (BOF) Lunch. I will be talking on the subject Change Data Capture (CDC). Please note that this lunch is for all of us; moreover, it is not necessary that I will be talking on only subject of Change Data Capture. In fact, I will talk about this subject for few minutes, and then we can discuss on any topic you want to know about. The table will have total of 10 seats (which includes my seating).

We can all have an effective small group conversation on SQL, SQL PASS, and the entire community. You are welcome to join me at lunch. Please read the complete details about the same here.

Thanks a lot Mike Walsh for organizing this event!

Please do join us for lunch!

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

SQLAuthority News – PASS Sessions – I will be there!

As PASS is now one week away and I am all excited for the same. I am going to attend following two sessions for sure. I encourage all of you to also visit the same sessions. We can all talk about SQL , SQL Integration as well Beyond Relations.

First sessions I will be attending of Rushabh Mehta, he is Managing Director of Solid Quality India.

Overcoming SSIS Deployment and Configuration Challenges

Rushabh Mehta (Solid Quality Learning)

Session Details

It is no secret that a main deficiency of SSIS is deployment. Have you wanted to punch a wall before when trying to move a package from one server to another? You’re not alone. This session will be more than just SSIS deployment anger management. We’ll look at how to overcome the deployment challenges by considering configurations, package and connection security, and deployment approaches. And don’t miss the decision workflows that will help you down the right path on choosing the right storage and deployment approaches depending on your situation!

Second sessions I am going to attend of Jacob Sebastian, he is founder of BeyoundRelational.com.

SQL Server 2008 – Create powerful XML Schema collections to validate your XML documents

Jacob Sebastian (beyondrelational.com)

Session Details

XML is getting more widely used both inside and outside SQL Server. Stored procedures and functions that accept XML parameters or generate XML documents are part of almost every database project these days. When information is exchanged in XML format, there needs to be an agreement between the sender and receiver about the structure and content of the XML document. Using an XSD (XML Schema Definition) Schema, you can validate the structure and content of an XML document. SQL Server introduced XML Schema Collections in SQL Server 2005 and added a number of enhancements in SQL Server 2008. An XML data type variable or column that is bound to an XML Schema collection is called TYPED XML. When a TYPED XML column or variable is modified, SQL Server will validate perform the validations defined in the SCHEMA Collection and the operation will succeed only if the validation succeeds. In this session we will discuss SQL Server XML Schema collections and see how to create powerful XML Schema Collections to validate XML documents with diverse structure and content.

I am also preparing my schedule as I want to attend almost all the sessions as I can. Please read following related post about SQL PASS.

Related Articles:
Why I am Going to Attend PASS Summit Unite 2009- Seattle

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

SQLAuthority News – PASS 2009 Sessions on Query Optimization and Performance Tuning

PASS Summit 2009 is now only 10 days away and I am very excited for the same. I can not wait to attend the summit as this is the most awaited conference of SQL Server in world. Everybody will be there and there will be something for everybody. My core expertise is in Query Optimization and Performance Tuning area, and when I see the list of PASS session on the subject, I am totally speechless. There are so many great speaker at PASS who are there to talk on the subject.

It is absolutely not possible to attend all of them many of them are running parallel to each other. In any case, I strongly suggest if you are the expert who try till last bit to optimize the query and performance, I expect you to attend many of the following session. There is always option to get recorded DVD for the sessions afterwords.

You can read my article here regarding Why I am Going to Attend PASS Summit Unite 2009- Seattle.

Here is my list of the sessions related to performance tuning and query optimization.

Making Effective Use of the Plan Cache
Greg Low (Solid Q Australia)

Capturing and Analyzing File & Wait Stats
Andrew Kelly (Solid Quality Mentors)

T-SQL Tips & Tricks
Itzik Ben-Gan (Solid Quality Mentors)

Best Practices for Working With Execution Plans
Grant Fritchey (FM Global)

DMV’s as a Shortcut to Procedure Tuning
Grant Fritchey (FM Global)

Lies, damned lies and statistics
Gail Shaw (XpertEase)

Insight into Indexes
Gail Shaw (XpertEase)

Enhance your T-SQL to perform better
Joe Webb (WebbTech Solutions, LLC)

Exploring Index Internals
Kalen Delaney (SQLearning)

Super Bowl, Super Load – A Look at Performance Tuning for VLDB”s
Michelle Ufford (GoDaddy)

Optimizing SQL Server 2008 Applications using Table Valued Parameters, XML and MERGE
Tobias Ternstrom (Microsoft Corp.)

SQL Server Execution Plans From Compilation To Caching To Reuse
Maciej Pilecki (Project Botticelli Ltd.)

Using SQL Server 2008 for Performance Tuning
Buck Woody (Microsoft Corp.)

SQLCAT: Designing High Performance I/O for SQL Server (90 Mins)
Thomas Kejser (Microsoft Corp.)
Mike Ruthruff (Microsoft SQL CAT)

SQL Server 2005 / 2008 Performance Tuning and Optimization Techniques (90 Mins)
David Pless (Microsoft CSS)

Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP Workloads
Glenn Berry (NewsGator Technologies)

How the Query Optimizer Works
Ben Nevarez (AIG)

I will personally try to attend many of the above listed sessions. Here are two sessions not from above list, which I will be sure attending. You are encouraged to meet me and attend this two rock star sessions.

Overcoming SSIS Deployment and Configuration Challenges
Rushabh Mehta (Solid Quality Learning)

SQL Server 2008 – Create powerful XML Schema collections to validate your XML documents
Jacob Sebastian (beyondrelational.com)

Let me know what sessions you will be sure attending by leaving your comment here. It would be good idea to create the list of the session which one is confident about attending.

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