SQLAuthority News – Presented on Database Worst Practices at SQLPASS 2014 in Seattle – November 5, 2014

Earlier last month, I had the opportunity to present at SQLPASS 2014. The event was held in Seattle in November 2014. I had a great time attending this event and I presented on the topic Database Worst Practices on November 5, 2014.

Here is the title and abstract of the session, which I had presented at SQLPASS.

Secrets of SQL Server: Database Worst Practices


“Oh my God! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them.

Shedding light on some of these perils and the tricks to avoid them may even save your current job. After attending this session, developers will only need 60 seconds to improve performance of their database server in their SharePoint implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately after the session.

The session was extremely well received as I had received wonderful feedback. I am honored that it was so well attended and the audience learned it. Here are a few photographs from the event. The session is recorded and available to SQLPASS subscribers who have paid for the event.

If you have not attended my previous session, you can subscribe to my newsletter over here, I will be sending various resources used in this sessions in emails.

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

SQL SERVER – Free Entry to SQLPASS 2014 is Possible

The other day, I received an email from Dell and I was extremely delighted to read it. It contained details how one can go for FREE to SQLPASS.

What is SQLPASS?

The three-day event will be marked by a lot of learningsharing, and networking, which will help me increase both my knowledge and contacts. 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. Further, breakfasts, lunches, and evening receptions, which are included with registration, are meant to provide more and more networking opportunities.

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.

I am once again going to SQLPASS. You can join me as well for FREE.

How to Get FREE Entry?

Dell is running a contest. The contest will begin July 17 and run until August 18. To enter, all you have to do is download a free 30-day trial of Spotlight on SQL Server Enterprise or LiteSpeed for SQL Server from this download page. The cost of SQLPASS regular entry is USD 1800 but you can get in for free if you take part in the contest.

About Products

Spotlight on SQL Server Enterprise delivers simplicity without compromise by providing unmatched monitoring, diagnosis and optimization of your SQL Server environments, ensuring peak performance around the clock. With intuitive overviews of enterprise health and performance, automated alerts and actions, an integrated tuning module and mobile device support, Spotlight makes it easier than ever to obtain the data you need to ensure the health of your SQL Server databases.

–  Ensure high-speed, storage-efficient backup and restore for SQL Server databases with up to 85 percent savings in backup size, storage costs, and restore times. LiteSpeed for SQL Server makes it possible, with minimal effort and risk. Delivering a wide variety of recovery options, LiteSpeed ensures the right SQL Server data is restored and available as quickly as possible.

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

SQLAuthority News – #SQLPASS 2012 Book Signing Photos

I am at SQLPASS 2012 and the event is going great. Here are few of the random photos and random news.

We had participated in three different book signing event today.

  1. SQL Queries 2012 Joes 2 Pros Book 1 Launch and Book Signing
  2. SQL 2012 Functions Book Launch at Embarcadero
  3. SQL Backup and Recovery Book Launch at Idera

Rick Morelan and I authored the first two books 1) SQL 2012 Functions and 2) SQL Queries 2012 Joes 2 Pros Volume 1. Our dear friend Tim Randney authored SQL Backup and Recovery Book. In the book signing event of Tim Radney I went ahead of the time and stood in the line. I was fortunate to receive the very first copy of the autographed book from Tim Radney.

We have one more book signing event of the book SQL Backup and Recovery by Tim Randey on Friday 9, 2012 between 12 to 1 PM at Joes 2 Pros booth #117. This is your last chance to shake hands with us and meet us in person.

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


SQLAuthority News – Learning, Community and Book Signing at #SQLPASS 2012

SQLPASS event is going excellent we are having great great fun! We are having book signing events and the response is overwhelmingly positive. I am glad that all of you love our books and I totally appreciate your support. Rick and I both are feeling very motivated to write more books in future. Here is our schedule for book signing.

SQL Queries 2012 Joes 2 Pros Volume1

Finally a book for the true SQL Server beginner! Whether you are brand new to databases and are thinking of getting your 70-461 certification or already a semi-pro working in the field and need some fingertip support, this is this is the book for you. Joes 2 Pros does not assume you already know anything about databases or SQL server.  This book builds on the success of the previous series and will help anyone transform themselves from a beginner “Joe” into a SQL 2012 “Pro”.

Wednesday, November 7, 2012
12pm-1pm – Book Signing at Exhibit Hall Joes Pros booth#117 (FREE BOOK)

Rest all the time – I will be at Exhibition Hall Joes 2 Pros Booth #117. Stop by for the goodies!

This book is also available on Amazon.

SQL 2012 Functions Joes 2 Pros

Functions have been around for many years to make our lives easier. Because of them, thousands of lines of valuable programming can be done with one statement. When we know what functions are offered in SQL Server we can get powerful projects done very quickly. Often times, the functions you wished you had are released in the next version.

Wednesday, November 7, 2012
7pm-8pm – Embarcadero Booth Book Signing (FREE BOOK)

Thursday, November 8, 2012
12pm-1pm – Embarcadero Booth Book Signing (FREE BOOK)

This book is also available on Amazon.

If you are at SQLPASS stop by Booth #117 – I will be there and many be you can get one of my signed book!

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

SQLAuthority News – 2 New Books – FREE Books and Book Signing at #SQLPASS 2012

As an author the most interesting task is to participate in Book Signing Events. If you are at SQLPASS – we are going to have a lot of book signing events. Here is the good news!


SQL 2012 Functions Limited Edition

Click to Expand

This book is a very special edition book. Our current plans is to run this book for the limited edition. You can avail this book from Amazon and it will soon come to India. Join following book signing events where you will get this book for free.

Wednesday, November 7, 2012
7pm-8pm – Embarcadero Booth Book Signing (FREE BOOK)

Thursday, November 8, 2012
12pm-1pm – Embarcadero Booth Book Signing (FREE BOOK)

SQL Queries 2012 Joes 2 Pros Volume1

Click to Expand

This is my first book this year which will be available in bookstores. Last Year I published 3 books and this year this is my first book. This book is available on Amazon over here and it will come to India very soon. Join following book signing events where you will get this book for free.

Wednesday, November 7, 2012
12pm-1pm – Book Signing at Exhibit Hall Joes Pros booth#117 (FREE BOOK)

If you are attending SQLPASS you may get this book’s Autographed Special Edition for FREE if you attend following book signing events.

Rest all the time – I will be at Exhibition Hall Joes 2 Pros Booth #117. Stop by for the goodies!

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

SQLAuthority News – #SQLPASS 2012 Schedule – Where can You Find Me

Yesterday I wrote about my memory lane with SQLPASS. It has been a fantastic experience and I am very confident that this year the same excellent experience is going to be repeated. Before I start for #SQLPASS every year, I plan where I want to be and what I will be doing. As I travel from India to attend this event (22+ hours flying time and door to door travel time around 36 hours), it is very crucial that I plan things in advance.

This year here is my quick note where I will be during the SQLPASS event. If you can stop with me, I would like to meet you, shake your hand and will archive memories as a photograph.

Tuesday, November 6, 2012

6:30pm-8:00pm PASS Summit 2012 Welcome Reception

Wednesday, November 7, 2012

12pm-1pm – Book Signing at Exhibit Hall Joes Pros booth#117 (FREE BOOK)
5:30pm-6:30pm – Idera Reception at Fox Sports Grill
7pm-8pm – Embarcadero Booth Book Signing (FREE BOOK)
8pm onwards – Exhibitor Reception

Thursday, November 8, 2012

12pm-1pm – Embarcadero Booth Book Signing (FREE BOOK)
7pm-10pm – Community Appreciation Party

Friday, November 9, 2012

12pm-1pm – Joes 2 Pros Book Signing at Exhibit Hall Joes Pros booth#117
11:30pm-1pm – Birds of a Feather Luncheon

Rest of the Time!

Exhibition Hall Joes 2 Pros Booth #117. Stop by for the goodies!

Lots of people have already sent me email asking if we can meet for a cup of coffee to discuss SQL. Absolutely! I like cafe mocha with skim milk and whip cream and I do not get tired of it.

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


SQLAuthority News – #SQLPASS 2012 Seattle Update – Memorylane 2009, 2010, 2011

Today is the first day of the SQLPASS 2012 and I will be soon posting SQL Server 2012 experience over here. Today when I landed in Seattle, I got the nostalgia feeling. I used to stay in the USA. I stayed here for more than 7 years – I studied here and I worked in USA. I had lots of friends in Seattle when I used to stay in the USA. I always wanted to visit Seattle because it is THE place. I remember once I purchased a ticket to travel to Seattle through Priceline (well it was the cheapest option and I was a student) but could not fly because of an interesting issue. I used to be Teaching Assistant of an advanced course and the professor asked me to build a pop-quiz for the course. I unfortunately had to cancel the trip.

Before I returned to India – I pretty much covered every city existed in my list to must visit, except one – Seattle. It was so interesting that I never made it to Seattle even though I wanted to visit, when I was in USA. After that one time I never got a chance to travel to Seattle. After a few years I also returned to India for good. Once on Television I saw “Sleepless in Seattle” movie playing and I immediately changed the channel as it reminded me that I never made it to Seattle before.

However, destiny has its own way to handle decisions. After I returned to India – I visited Seattle total of 5 times and this is my 6th visit to Seattle in less than 3 years. I was here for 3 previous SQLPASS events – 2009, 2010, and 2011 as well two Microsoft Most Valuable Professional Summit in 2009 and 2010. During these five trips I tried to catch up with all of my all friends but I realize that time has its own way of doing things. Many moved out of Seattle and many were too busy revive the old friendship but there were few who always make a point to meet me when I travel to the city.

During the course of my visits I have made few fantastic new friends – Rick Morelan (Joes 2 Prosand Greg Lynch. Every time I meet them I feel that I know them for years. I think city of Seattle has played very important part in our relationship that I got these fantastic friends. SQLPASS is the event where I find all of my SQL Friends and I look for this event for an entire year.

This year’s my goal is to meet as many as new friends I can meet. If you are going to be at SQLPASSFIND ME. I want to have a photo with you. I want to remember each name as I believe this is very important part of our life – making new friends and sustaining new friendship.

Here are few of the pointers where you can find me.

  • All Keynotes – Blogger’s Table
  • Exhibition Booth Joes 2 Pros Booth #117 – Do not forget to stop by at the booth – I might have goodies for you – limited editions.
  • Book Signing Events – Check details in tomorrow’s blog or stop by Booth #117
  • Evening Parties 6th Nov – Welcome Reception
  • Evening Parties 7th Nov – Exhibitor Reception – Do not miss Booth #117
  • Evening Parties 8th Nov – Community Appreciation Party
  • Additionally at few other locations –Embarcadero Booth
  • In Coffee shops in Convention Center

If you are SQLPASS – make sure that I find an opportunity to meet you at the event. Reserve a little time and lets have a coffee together. I will be continuously tweeting about my where about on twitter so let us stay connected on twitter.

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

Let us meet!

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


SQLAuthority News – A Conversation with an Old Friend – Sri Sridharan

Sri Sridharan is my old friend and we often talk on GTalk. The subject varies from Life in India/USA, movies, musics, and of course SQL. We have our differences when we talk about food or movie but we always agree when we talk about SQL. Yesterday while chatting with him we talked about SQLPASS and the conversation lasted for a long time. Here is the conversation between us on GTalk. I have removed a few of the personal talks and formatted into paragraphs as GTalk often shows stuff out of formatting.

Pinal: Sri, Congrats on running for the PASS BoD again. You were so close last year. What made you decide to run again this year?
Sri: Thank you Pinal for your leadership in the PASS India Community and all the things you do out there. After coming so close last year, there was no doubt in my mind that I will run again. I was truly humbled by the support I got from the community. Growing up in India for over 25 years, you are brought up in a very competitive part of the world. Right from the pressure of staying in the top of the class from kindergarten to your graduation, the relentless push from your parents about studying and getting good grades (and nothing else matters), you land up essentially living in a pressure cooker. To survive that relentless pressure, you need to have a thick skin, ability to stand up for who you really are , what you want to accomplish and in the process stay true those values.

I am striving for a greater cause, to make PASS an organization that can help people with their SQL Server careers, to make PASS relevant to its chapter members, to make PASS an organization that every SQL professional in the world wants to be connected with. Just because I did not get elected or appointed last year does not mean that these causes are not worth fighting. Giving up upon failing the first time is simply not in me. If I did that, what message would I send to those who voted for me? What message would I send to my kids?

Pinal: As someone who has such strong roots in India, what can the Indian PASS Community expect from you?
Sri: First of all, I think fostering a regional leadership is something PASS must encourage as part of its global growth plan. For PASS global being able to understand all the issues in a region of the world and make sound decisions will be a tough thing to do on a continuous basis. I expect people like you, chapter leaders, regional mentors, MVPs of the region start playing a bigger role in shaping the next generation of PASS. That is something I said in my campaign and I still stand by it.

I would like to see growth in the number of chapters in India. The current count does not truly represent the full potential of that region. I was pretty thrilled to see the Bangalore SQLSaturday happen early this year. I would like to see more of SQLSaturday events, at least in the major metro cities. I know the issues in India are very different from the rest of the world. So the formula needs to be tweaked a little for it to work better in India.

Once the SQLSaturday model is vetted out, maybe there could be enough justification to have SQLRally India. PASS needs to have a premier SQL event in that region. Going to USA or Europe for that matter is incredibly hard due to VISA issues etc. So this could be a case of where PASS comes closer to where the community is.

Pinal: What portfolio would take on if you are elected to the PASS Board?
Sri: There are some very strong folks on the PASS Board today. The President discusses the portfolios with the group and makes the final call on the portfolios. I am also a fan of having a team associated with the portfolios. In that case, one person is the primary for a portfolio but secondary on a couple of other portfolios. This way people on the board have a direct vested interest in a few portfolios.

Personally, I know I would these portfolios good justice – Chapters, Global Growth and Events (SQLSat, SQLRally). I would try to see if we can get a director to focus on Volunteers.  To me that is very critical for growth in the international regions.

Pinal: This is an interesting conversation with you Sri. I know you so long time but this is indeed inspiring to many. India is a big country and we appreciate your thoughts.

Sri: Thank you very much for taking time to chat with me today. Cheers.

There are pretty strong candidates for SQLPASS Board of Elections this year. I know all of them in person and honestly it is going to be extremely difficult to not to vote for anybody. I am indeed in a crunch right now how to pick one over another. Though the choice is difficult, I encourage you to vote for them. I am extremely confident that the new board of directors will all have the same goal – Better SQL Server Community.

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

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)

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)