SQLAuthority News – An Incredible Successful SQL Saturday #116 Event – First SQL Saturday in India

We have recently wrapped up our most recent event, SQL Saturday #116, and I am I am sure I am not alone in reporting that it was a huge success!  We had a full crowd – every seat taken, plus standing-room-only in the back.  We also had a lot of good feedback and the crowd was definitely involved and engaged, so I think it was an all-around success.

Given the success of our UG meetings in Bangalore, this year we tried to accommodate even more people by hosting two technical tracks at the same event.  I think this plan worked out well and I have heard a lot of supportive comments about it.

Because we now were able to provide six speaking slots, we had a lot of great speakers this year.  Karan Gulati spoke about BI in Denal, Amit Banerjee gave a talk titled “Demystifying SQL Server Memory Dumps.”  My co-author Vinod Kumar even gave a talk about “Security with SQL Server – Discovering Pitfalls”, and some of the pitfalls you might come up against. Very interesting and inspiring session. I learned lots of tricks from this session and wished that this session never ends.

I was proud to be asked to speak at this event.  I was third in the line-up in the Developer track.   I think the talk went very well.  My topic was “SQL Server Performance Tips & Tricks,” and I started out with a Q&A with the audience.  I think group participation like this is a great way to learn about a subject.  The questions from the audience came fast and furious, but I think I answered everyone to the best of my ability, and I am happy to report that everyone laughed in the right places.

After my talk, Balmukund Lakhani spoke about a topic he called “Always on Unplugged.”  He talked about a new feature that is coming up in SQL Server called Availability Group.  Last was Rick Morelan, who gave a talk called “Basic Performance Tips & Gotchas.”  I think readers may recognize his name from another book I co-authored (SQL Wait Stats), and it was exciting to share the stage with him again.

When all the talks were over, the fun was not finished!   I am also very excited to tell all my readers that a special give-away at this event was none other than my book, SQL Server Interview Questions and Answers.  There was even time for book signing afterwards, and it feels like everyone wanted their copy signed.  The book wasn’t the only giveaway, either.  Every attendee received a free 7-day trial subscription to Pluralsight, which I hope everyone takes advantage of. Vinod and I have co-authored SQL Server Questions and Answers course on Pluralsight as well. Thanks to SQLPASS, Sponsors, and Microsoft for making this event a bit success.

In the end, the conference was a great success and I am very pleased with the amount of attendees and participation.  I am now very tired after all that hard work, but I am also feeling very satisfied with a job well done.

Here are few write ups on by community members:- Vinod, Lohit, Sudeepta, Manas, Varun

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

About these ads

SQLAuthority News – Book Signing Event – SQLPASS 2011 Event Log

I have been dreaming of writing book for really long time, and I finally got the chance – in fact, two chances!  I recently wrote two books: SQL Programming Joes 2 Pros: Programming and Development for Microsoft SQL Server 2008 [Amazon] | [Flipkart] | [Kindle] and SQL Wait Stats Joes 2 Pros: SQL Performance Tuning Techniques Using Wait Statistics, Types & Queues [Amazon] | [Flipkart] | [Kindle].  I had a lot of fun writing these two books, even though sometimes I had to sacrifice some family time and time for other personal development to write the books. The good side of writing book is that when the efforts put in writing books are recognize by books readers and kind organizations like expressor studio.

Book Signing Event

Book Signing Event

Book writing is a complex process.  Even after you spend months, maybe years, writing the material you still have to go through the editing and fact checking processes.  And, once the book is out there, there is no way to take back all the copies to change mistakes or add something you forgot.  Most of the time it is a one-way street.

Book Signing Event

Book Signing Event

Just like every author, I had a dream that after the books were written, they would be loved by people and gain acceptance by an audience. My first book, SQL Programming Joes 2 Pros: Programming and Development for Microsoft SQL Server 2008, is extremely popular because it helps lots of people learn various fundamental topics. My second book covers beginning to learn SQL Server Wait Stats, which is a relatively new subject. This book has had very good acceptance in the community.

Book Signing Event

Book Signing Event

Helping my community is my primary focus, so I was happy to see this year’s SQLPASS tag line: ‘This is a Community.‘ At the event, the expressor studio guys came up with a very novel idea. They had previously used my books and they had found them very useful. They got 100 copies of the book and decided to give it away to community folks. They invited me and my co-author Rick Morelan to hold a book signing event. We did a book signing on Thursday between 1 pm and 2 pm.

Book Signing Event

Book Signing Event

This event was one of the best events for me. This was my first book signing event outside of India. I reached the book signing location around 20 minutes before the scheduled time and what I saw was a big line for the book signing event. I felt very honored looking at the crowd and all the people around the event location. I felt very humbled when I saw some of my very close friends standing in the line to get my signature. It was really heartwarming to see so many enthusiasts waiting for more than an hour to get my signature. While standing in line I had the chance to have a conversation with every single person who showed up for the signature. I made sure that I repeated every single name and wrote it in every book with my signature. There is saying that if we write a name once we will remember it forever. I want to remember all of you who saw me at the book signing. Your comments were wonderful, your feedback was amazing and you were all very supportive.

Book Signing Event

Book Signing Event

I have made a note of every conversation I had with all of you when I was signing the books. Once again, I just want to express my thanks for coming to my book signing event. The whole experience was very humbling. On the top of it, I want to thank the expressor studio people who made it possible, who organized the whole signing event. I am so thankful to them for facilitating the whole experience, which is going to be hard to beat by any future experience.

My books

My books

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

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)