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 (https://blog.sqlauthority.com)

SQL Training
Previous Post
SQL SERVER – SSMS: Top Object and Batch Execution Statistics Reports
Next Post
Developer’s Life – Disaster Lessons – Notes from the Field #039

Related Posts

28 Comments. Leave new

  • Happy Birthday… :)

    Reply
  • bodempudi venkata subbarao
    July 30, 2014 7:06 pm

    Many more returns of the day Dave….

    Reply
  • This is awesome

    Reply
  • stephen jesu raj
    July 30, 2014 7:14 pm

    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.

    Reply
  • Mahaboob Basha
    July 30, 2014 7:15 pm

    Wish You Happy Birthday

    Reply
  • Happy birthday Pinal!! I wish you all the best! I realy want to get a free code to learn this course.

    Reply
  • wish you happy birthday.
    Share me free code.

    Reply
  • 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.

    Reply
  • Forgot to Wish you .. A very Happy Birthday !!! Cheers

    Reply
  • Stewart Simon
    July 30, 2014 8:09 pm

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

    Reply
  • 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

    Reply
  • Gangadhar as SQL programmer
    July 30, 2014 10:42 pm

    Hi Pinal, I am interested to learn your technique of Play by Play

    Reply
  • Jose Luis Becerra Alejo
    July 30, 2014 11:26 pm

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

    Reply
  • Alain Martin
    July 30, 2014 11:28 pm

    Hapy birthday!

    Reply
  • Happy Birthday! Thank you for this. I am really interested in helping to speed up queries. :)

    Reply
  • 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.

    Reply
  • Imran Mohammed
    July 31, 2014 3:38 am

    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.

    Reply
  • Aaron Varner
    July 31, 2014 4:10 am

    I am interested in the course

    Reply
  • Gangadhar as SQL programmer
    July 31, 2014 6:06 am

    Hi Dave,
    I am interested to learn your Play by play course.

    -Gangadhara

    Reply
  • 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?.

    Reply

Leave a Reply

Menu
Exit mobile version