SQL Authority News – Play by Play with Pinal Dave – A Birthday Gift

Today is my birthday.

Personal Note

When I was young, I was always looking forward to my birthday as on this day, I used to get gifts from everybody.

Now when I am getting old on each of my birthday, I have almost same feeling but the direction is different. Now on each of my birthday, I feel like giving gifts to everybody. I have received lots of support, love and respect from everybody; and now I must return it back.Well, on this birthday, I have very unique gifts for everybody – my latest course on SQL Server.

How I Tune Performance

I often get questions where I am asked how do I work on a normal day. I am often asked that how do I work when I have performance tuning project is assigned to me. Lots of people have expressed their desire that they want me to explain and demonstrate my own method of solving performance problem when I am facing real world problem. It is a pretty difficult task as in the real world, nothing goes as planned and usually planned demonstrations have no place there.

The real world, demands real solutions and in a timely fashion. If a consultant goes to industry and does not demonstrate his/her capabilities in very first few minutes, it does not matter how much fame he/she is, the door is shown to them eventually. It is true and in my early career, I have faced it quite commonly. I have learned the trick to be honest from the start and request absolutely transparent communication from the organization where I am to consult.

Play by Play

Play by Play is a very unique setup. It is not planned and it is a step by step course. It is like a reality show – a very real encounter to the problem and real problem solving approach. I had a great time doing this course. Geoffrey Grosenbach (VP of Pluralsight) sits down with me to see what a SQL Server Admin does in the real world. This Play-by-Play focuses on SQL Server performance tuning and I go over optimizing queries and fine-tuning the server.

The table of content of this course is very simple.

Introduction

In the introduction I explained my basic strategies when I am approached by a customer for performance tuning.

Basic Information Gathering

In this module I explain how I do gather various information for performance tuning project. It is very crucial to demonstrate to customers for consultant his capability of solving problem. I attempt to resolve a small problem which gives a big positive impact on performance, consultant have to gather proper information from the start. I demonstrate in this module, how one can collect all the important performance tuning metrics.

Removing Performance Bottleneck

In this module, I build upon the previous module’s statistics collected. I analysis various performance tuning measures and immediately start implementing various tweaks on the performance, which will start improving the performance of my server. This is a very effective method and it gives immediate return of efforts.

Index Optimization

Indexes are considered as a silver bullet for performance tuning. However, it is not true always there are plenty of examples where indexes even performs worst after implemented. The key is to understand a few of the basic properties of the index and implement the right things at the right time. In this module, I describe in detail how to do index optimizations and what are right and wrong with Index. If you are a DBA or developer, and if your application is running slow – this is must attend module for you. I have some really interesting stories to tell as well.

Optimize Query with Rewrite

Every problem has more than one solution, in this module we will see another very famous, but hard to master skills for performance tuning – Query Rewrite. There are few do’s and don’ts for any query rewrites. I take a very simple example and demonstrate how query rewrite can improve the performance of the query at many folds. I also share some real world funny stories in this module.

This course is hosted at Pluralsight. You will need a valid login for Pluralsight to watch  Play by Play: Pinal Dave course. You can also sign up for FREE Trial of Pluralsight to watch this course.

As today is my birthday – I will give 10 people (randomly) who will express their desire to learn this course, a free code. Please leave your comment and I will send you free code to watch this course for free.

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

About these ads

28 thoughts on “SQL Authority News – Play by Play with Pinal Dave – A Birthday Gift

  1. Wish you many more happy returns of the day pinal.It is glad to know on your B’day you are giving gift to others.And I learned a lot from your site regularly.It is so helpful for me to watch this your strategy for play to play.It will very useful for me since i got a new job in database administrator in Infosys.

    Like

  2. I am in a Lead Position DB Developer, i encounter these these types of situations in my normal day routine. I really wanted to see how you tackle the things.

    Like

  3. First and foremost , Happy Birthday. I have enjoyed reading your post over the years and would love to watch and learn

    Like

  4. Hi Pinal,

    It is my great pleasure to express about my interest. I’ve been following your blog since i know DBA profile. I were impressed with your dedication. I hope you would remember i was mailed earlier asking ‘What are the steps you have been taken to became successful DBA ‘
    I want to upgrade myself by following some people like you.

    Regards,
    Laxman

    Like

  5. Happy Birthday Pinal ! your blog is a reference for everyone who wants to improve SQL SERVER skills, it helped me a lot

    Like

  6. First off, happy birthday! I use articles from your blog as a resource for strengthening my skills with SQL, and greatly appreciate the work you put into sharing your knowledge. Improving performance is one of my key interests, so I’m definitely looking to build that strength where I can.

    Like

  7. Congratulations Pinal.

    I pray God make more people like you who come forward to help SQL Community. You have been a great help to many.

    God Bless You.

    Like

  8. Hello sir,
    first of all Belated Happy b’day to you sir.
    can you give some examples of query rewrite so that we can get to know how we can perform query rewrite task?.

    Like

  9. Hi Pinal,
    Belated Happy B’day. Thanks a lot for sharing and enriching the SQL fraternity. I wish to get lot more stuffs in coming years.

    Like

  10. Hi Pinal, happy birthday!
    Thanks for all the inspirational blogs about the technology we all enjoy!
    Enjoy reading your blogs, every day!

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s