SQL SERVER – Performance Tuning Resolution

This blog post is written in response to T-SQL Tuesday hosted by MidnightDBAs.

Taking resolutions is such an interesting subject. I think just like records, these are broken way more often. I find this is the funniest thing as we all take resolutions every year but not every year, we can manage to keep them. Well, does it mean we should not take resolutions? In fact I support resolutions.

Every year, I take a resolution that I will strive reduce my body weight and I usually manage to keep eating healthy till the end of January. When February begins, I begin to loose focus from my goal and as March starts, the “As usual” eating habits begin. Looking at the positive side, what would happen if every year I do not eat healthy in January, I think that might cause terrible consequences to my health in the long run. So keeping resolutions is a good practise and following them to the extent one can is commendable.

Let us come back to the world of SQL Server. What is my resolution for year 2011 for SQL Server?

There are many, I am going to list three of very important resolutions that I have taken this new year over here.

SQL SERVER - Performance Tuning Resolution nr1

To understand SQL Server Performance Tuning at a deeper Level

I think I am already half way through. I have been being very much busy during any given month doing hands-on performance tuning for at least 12 days on an average. That means, I am doing this activity for almost doing 2 weeks a month. I believe that I have a good understanding of the subject. Note that the word that I have used is “good,” and not “best.” There are often cases when I am stumped, and I have no clue of what to do next. Then, I usually go for my “trial and error” method ‑ whichever method works, I make sure to keep a note on my blog. My goal is that I should never ever go for the trial and error method again to achieve the same solution. I should know the solution right away when I see the problem. I do understand that Performance Tuning can be a strange animal at times and one cannot guess the right step every time. However, aiming a high goal never hurts and I am going to learn more and more in this focused area.

Going further from Basic BI understanding

I do fairly decent with BI concepts. I know the nbasics of SSIS, SSRS, SSAS, PowerPivot and SharePoint (and few other things MDS, StreamInsight, etc). However, I still consider myself as a beginner. I do not have hands-on experience like many other BI Gurus around. I think I want to take my learning further in this direction. I do not want to be a BI expert as the first step but the goal is to move ahead from basic level towards an advanced level. I am going to start presenting in User Group Sessions and other places on this subject. When I have to prepare new subject for presentations, I think I force myself to learn more. I am committed to learn a bit more in this direction.

Learning new features SQL Server 2012

This is new thing from “Microsoft” for all the SQL Enthusiast. I am eagerly waiting for final product later this year and I am planning to learn it well. I think if I follow my above two goals, I think this goal will be automatically covered. I am eager and excited for this new offering from Microsoft.

I guess, these are my resolutions; may be next year about the same time, I must revisit this post and see how much successful I am in following my goal.

On a lighter note, I am particularly fan of following cartoon strip (Courtesy: Calvin and Hobbes). I think when we cannot resolve our resolutions, we tend to act like Calvin.

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

Previous Post
SQLAuthority News – Free Trip on SQL Cruise
Next Post
SQLAuthority News – Download SQL Server 2008 R2 Upgrade Technical Reference Guide

Related Posts

No results found.

1 Comment. Leave new

  • Carlos Pelaez
    May 27, 2016 8:22 am

    Hi Pinal Dave
    Do you have best practices to create triggers related with option to create audit logs.
    In Example, who created or updated or deleted information from fields of tables and what field changed.
    I would like to create a trigger for any table which is being modified.


Leave a ReplyCancel reply

Exit mobile version