SQLAuthority News – Resolutions of Year 2013 – Commitment to Myself

First of all, happy New Year to all of you – 2013 has started!

Every year I make at least one resolution, some I do for the public on my blog.  The reason is simple – if I declare something in front of all of you, there is a good chance I will be held accountable to it.  Without my readers, no one will check up on me and it will be easy to fall off the wagon.  But this year I am making more than resolutions, I am making commitments to myself, and I want to follow them.  In fact, I want to finish them in six months, not a whole year.  A few of my 2013 commitments are professional, and some are for my personal life.  I want to see how I progress over the year.

Write More Books

My first professional commitment: I want to write a few more books.  The reason is simple, in 2011 I wrote three books, and they gave me tremendous satisfaction.  Writing books is totally different from writing a blog.  The blog is like a sprint, writing a book is a marathon– one you have to win.  The blog is a different game – you only need to focus on it for one or two hours a day.  A book takes a whole year.  So in 2011 I wrote three books, and in 2012 I helped write few books as well.  This will be hard to replicate in 2013, but I have some ideas.  I want to rewrite a lot of books.  I want to write huge book to help someone learn SQL Server from the beginning.  I want to write a book that will hold their hand through the whole process.  The kind of book that every single person who reads it feels they learned something.  A quality book that changes people’s lives.  I already have a head start on this book.  I am only writing this resolution to make sure it gets out and that I am held accountable.

Go Beyond SQL

My second professional resolution: I want to learn more than SQL Server, and author a course for Pluralsight.  SQL is my career – but technology is a bigger world.  Everyone should learn something new – piano, guitar, skiing.  I want to learn something new, too, and I want to learn more technology, and be able to do a course on it.  To be able to teach a course, I need to have the confidence I learned it completely.  If you can’t train someone, you didn’t learn properly.

Attend SQLskills Training

My third professional resolution: Attend professional SQL training – specifically the training course taught by SQLskills Team (Paul Randal and Kimberly Tripp).  This is more than a resolution, it is a dream that in 2013 I am able to attend that course.  They have a course offered through Pluralsight, too, but want to go in person.  It will be expensive to attend in the USA all the way from India, but sometimes it’s not about money.  This is about making my dream come true; I want to make it happen. The courses I want to attend are Immersion Event 1 and Immersion Event 2.

Reduce my Weight

And finally, I have a personal resolution that I am posting here: I want to reduce my weight. I have been working on it for two years, but haven’t lost any weight, only gained (I am sure many can sympathize with this phenomenon).  However, this year I want to commit.  I will be going to the gym every day, and next year at this time I will report how much I lost.  I started this resolution last month and lost 10 pounds, but I want to lose much more than that.  Every month I will post about my weight loss, what I did and what I learned.  Let’s see how far we go with that.

Looking forward to 2013

These are four commitments to myself.  Every year I post these resolutions.  One resolution that I followed through on from last year is that I was able to spend more time with my family.  Luckily I was able to spend more time with them and am able to do more things.  My family is happy with Pluralsight and how it allows me to set my own schedule.  My colleagues are awesome, and both my family and I really appreciate it.

For 2013, let’s see how I do!  Meanwhile, post your resolution here.  Don’t do something simple – pick something challenging, which is the fun way to do it.

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

About these ads

SQLAuthority News – Last Post of Year 2012

The year 2012 was the most interesting year. If I start listing what was special about this year – I think it will take me 2-3 days to just write a blog post about this subject. Let me pick few things which I would like to specifically call out.

SQL in Sixty Seconds Series

We all can be very busy but we all have one minute of time. We can find 60 seconds of the time waiting at the gas station, using an elevator, waiting in line at Starbucks, or any other common place. Honestly 60 seconds is not a big thing if you look how much time you spend doing other things. The goal of the series was to build interesting something quick which one can learn in a single minute. So far there have been more than 35 episodes of this series and all of them are very well received. Almost all the the episodes have more than 1000 views and some are watched by tens of thousands. I am just honored that the audience is really loving this new concept.

If you have not subscribed to the SQL in Sixty Seconds Channel – do it today.

Here is the link to all the 37 SQL in Sixty Seconds Video.

Episode 1 | Episode 2 | Episode 3 | Episode 4 | Episode 5 | Episode 6 | Episode 7 | Episode 8 | Episode 9 | Episode 10

Episode 11 | Episode 12 | Episode 13 | Episode 14 | Episode 15 | Episode 16 | Episode 17 | Episode 18 | Episode 19 | Episode 20

Episode 21 | Episode 22 | Episode 23 | Episode 24 | Episode 25 | Episode 26 | Episode 27 | Episode 28 | Episode 29 | Episode 30

Episode 31 | Episode 32 | Episode 33 | Episode 34 | Episode 35 | Episode 36 | Episode 37

SQLAuthority Memory Lane Series

I have been writing this blog for Seven years. I tried to post one thing every day – sometimes it is technical and sometimes it is personal but I make sure that I write something which interests me. In recent times when I start to write new topic and when I tried to search over it – I end up on my own blog post. I quickly realized that there is so much material I have posted on this blog that it is not possible to remember it. I just can’t remember everything. To avoid reputation and bring back the old content which was lost in time.

So far I have written 9 episodes of this article and I am already getting overwhelmed with all the information is shared on this blog so far. If you have not read them, here is your chance to read all of the 9 episodes.

Episode 1Episode 2Episode 3Episode 4Episode 5Episode 6Episode 7Episode 8Episode 9

Events:

I have attended nearly 30 various events in the year 2012. If you ask me to profile the events there are no two events which can be compared – some events were small some were huge, some events were in Indian Subcontinent and some were outside Asia. Overall – I had a blast with the community. However, there are two distinct events I would like to mention here.

SQL PASS 2012

This is the biggest event for any SQL Server Professional. I had a fantastic time in book signing as well releasing our new books.

TechEd India 2012

This is the biggest event for any technologist of India. I had a great time meeting the local community and share some SQL Love. My whole family is attending this event for last 4 years and we have continued the tradition.

Well, I guess this is it for this year – see you next year (tomorrow)!

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

SQL SERVER – Inviting Ideas for SQL in Sixty Seconds – 12/12/12

Today is 12/12/12 – I am not sure when will I write this kind of date again – maybe never. This opportunity comes once in a lifetime when we have the same date, month and year all have same digit. December 12th is one of the most fantastic day in my personal life. Four years ago, this day I got married to my wife – Nupur Dave.  Here are photos of our wedding (Dec 12, 2008).

Here is a very interesting photo of myself earlier this year. It is not photoshoped or modified photo. The only modification I have done here is to add arrow and speech bubble.

Every Wednesday I tried to put one SQL in Sixty Seconds Video. The journey has been fantastic and so far I have put a total of 35 SQL in Sixty Seconds Video. The goal of the video is to learn something in 1 minute. In our daily life we are all very busy and hardly have time for anything. No matter how much we are busy – we all have one minute of time. Sometime we wait for a minute in elevators, at the escalator, at a coffee shop, or just waiting for our phone reboot.

Today is a fantastic day – 12/12/12. Let me invite all of you submits SQL in Sixty Seconds idea. If I like your idea and create a sixty second video over it – you will win surprise learning material from me. There are two very simple rules of the contest: -

  1. I should have not have already recorded the tip.
  2. The tip should be descriptive. Do not just suggest to cover “Performance Tuning” or “How to Create Index” or “More of reporting services”. The tip should have around 100 words of description explaining SQL Tip.

The contest is open forever. The winner will be announced whenever I use the tip to convert to video. If I use your tip, I will for sure mention in the blog post that it is inspired from your suggestion.

Meanwhile, do not forget to subscribe YouTube Channel.

Here are my latest three videos from SQL in Sixty Seconds.

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

SQLAuthority News – Happy Deepavali and Happy New Year

Diwali or Deepavali is popularly known as the festival of lights. It literally means “array of light” or “row of lamps“. Today we build a small clay maps and fill it with oil and light it up. The significance of lighting the lamp is the triumph of good over evil. I work every single day in a year but today I am spending my time with family and little one. I make sure that my daughter is aware of our culture and she learns to celebrate the festival with the same passion and values which I have.

Every year on this day, I do not write a long blog post but rather write a small post with various SQL Tips and Tricks. After reading them you should quickly get back to your friends and family – it is the most important festival day.

Here are a few tips and tricks:

  • Take regular full backup of your database
  • Avoid cursors if they can be replaced by set based process
  • Keep your index maintenance script handy and execute them at intervals
  • Consider Solid State Drive (SDD) for crucial database and tempdb placement
  • Update statistics for OLTP transactions at intervals

I guess that’s it for today. If you still have more time to learn. Here are few things you should consider.

Well, I am sure that will keep you busy for the rest of the day!

Happy Diwali to All of You!

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

SQLAuthority News – Why I am Going to Attend #SQLPASS Summit 2012 – Seattle

I am going to Seattle I once again attend SQLPASS this year. This will be my fourth SQLPASS. Lots of people ask me why I am going to SQLPASS every year. Well there are so many different reasons for that. I go to SQLPASS because – I love it! 

Here are few of the reasons I go to SQLPASS.

  • Meet friends whom I have never met before
  • Meet community at large – it is fun to hang around with like minded people
  • Meet Rick Morelan – my book co-author and friend
  • Attend various SQL Parties – there are so many parties around – see the list below
  • Explore various new tools from various third party vendors
  • Meet fellow Chapter Leaders and Regional Mentors

And of course attend SQL Server Learning Sessions from industry known experts.

The three-day event will be marked by a lot of learning, sharing, 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 going – are you joining?

Note: This is re-blogged with modification from my 2 years old blog posts on a similar subject.

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

SQLAuthority News – 6th Anniversary and 50 Million Views and Over 2300 Blog Posts – Thank You Thank You

Six years ago, I started this SQLAuthority.com blog. There are so many things I want to say today – it is very very emotional. Instead of writing long I am including few images and cartoons.

Last month we have also reached 50 Million Total Views on this blog. Here is the screen captured at that time.

Click Image to Enlarge

In 6 years there are total 2192 days (including 2 leap year day) and my total blog post count is 2300. That means I have been blogging more than 1 blog post every day. Here is the quick glance to all the numbers.

Here you can find the list of all the 2300 blog posts.

I am very glad to see my many of the friends stay in USA, India, United Kingdom, Canada and Australia in that order. You can see the geographic distribution of the support I receive on the blog from worldwide.

On this day I would like to call out one 2 individuals who contribute equally or more in my success. When I started this blog 6 years ago, I was walking alone. After 2 years my wife Nupur joined my journey and 3 years later my daughter Shaivi joined the journey. Here is the example of the common conversation among us almost every day -

Shaivi: Daddy, play catch-catch.
Nupur: Shaivi, daddy will play with you once he finishes tomorrow’s blog.
Shaivi: Daddy, Finish Blog. Okey. I play catch-catch (alone).

SQLAuthority Family

Well, thank you very much! We all love you!

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

SQLAuthority News – Who I Am And How I Got Here – True Story as Blog Post

Here are few of the sample questions I get every day?

  • “Give me shortcut to become superstar?”
  • “How do I become like you?”
  • “Which book I should read so I know everything?”
  • “Can you share your secret to be successful? I want to know it but do not share with others.”

There is generic answer I always give is to work hard and read good educational material or watch good online videos.

One of the emails really caught my attention. It was from a friend and SQL Server Expert John Sansom (Blog | Twitter). He wrote if I would like to share my story with the world about “Who I am and How I got Here”. I was very much intrigued with his suggestion. John is one guy I respect a lot. Every single topic he writes, I read it with dedication. I eagerly wait for his Weekly Summary of Best SQL Links. If you have not read them, you are missing something out.

Writing a guest post for him was like walking in memory lane. I remembered the time when I was beginning my career and I was bit overconfident and bit naive. I had my share of mistakes when I started my career. As time passed by I realize the truth. Well, we all do mistakes. Though, I am proud that as soon as I know my mistakes I corrected them. I never acted on impulse or when I am angry. I think that alone has helped me analysis the situation better and become better human being. During the course, I have lost my ego and it is replaced by passion. I am much more happy and successful in my work.

Quite often people ask me if I am always online and wether I have family or not. Honestly, I am able to work hard because of my family. They support me and they encourage me to be enjoy in what I do. They support everything I do and personally, I do not miss a single occasion to join them in daily chores of fun.

If there was a shortcut to success – I want know. I learnt SQL Server hard way and I am still learning. There are so many things, I have to learn. There is not enough time to learn everything which we want to learn. I am constantly working on it every day. I welcome you to join my journey as well. Please join me with my journey to learn SQL Server – more the merrier.

I have written a story of my life as a guest post. 

Read Here: A Journey to SQL Authority

Special thanks to John Sansom (Blog Twitter) for giving me space to talk my story. Indeed I am honored.

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