SQLAuthority News – Presenting at Sarasota IT Pro Camp, Florida on February 16, 2013

I am traveling the entire month of February 2013 in USA. First 18 days I am Florida and later part I am heading to another part of the country. When I am in India, every weekend I make a point to attend one of the User Group Meeting in the city. However, the same becomes a bit difficult when I am traveling across the globe. Well, it does not matter where I am and what position I am – if there is a community event, I am going to be there.

Tomorrow on February 16, 2013 Saturday, I am going to present at Sarasota IT Pro Camp, Florida. Special thanks to Jose Chinchilla (Twitter|Blog) for making everything possible for the event. Here are the details about the event:

Keiser University
6151 Lake Osprey Drive
Sarasota, FL 34240

Date & Time:
9:00 AM February 16, 2013 Saturday

Session Details:
Tips and Tricks for Blazing Fast SQL Server Performance
Slow Running Queries are the most common problem that developers face while working with SQL Server. While it is easy to blame the SQL Server for unsatisfactory performance, however the issue often persists with the way queries have been written, and how SQL Server has been set up. The session will focus on the ways of identifying problems that slow down SQL Servers, and tricks to fix them. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

Hope to see you there soon!

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

About these ads

SQLAuthority News – Delhi Flash Mob and Women Safety – 2400th Blog Post – A Milestone

I have stopped writing milestone posts recently as I realized that they really do not serve any other value besides having boastful note about myself. I rather do some important contribution to my blog so I started to build Weekly Memory Lane series and that is a much better contribution in my opinion as that even helps me to go and re-learn some of the concepts from the past.

However, this blog post is a different blog post than any other blog post. If you are familiar with what is going on recently in Delhi, India you will appreciate my reason behind this blog post. As an Indian it is very important to understand safety is very important for Indian Citizen. As a father and husband the safety of woman family member is the prime responsibility of mine. Recently a very sad event in Delhi, India has shaken up whole India (and the rest of the world). I have been meaning to write about this subject on this blog for a long time however, it was very painful to think about this event as an Indian.

I had decided to stay silent on this subject, even though the subject has been very much in mind. Silence is not a solution. I am strongly against crime against women. I have been discussing this subject with my friends from Koenig Solutions. They are also experiencing very similar emotions as the rest of the India. On the Republic Day of India (26th January), they have recently performed a Flash Mob in Delhi. Here is very touching, inspiring and powerful Delhi Flash Mob. If you are not familiar with Hindi (Indian Language), I strongly suggest that you turn on Closed Caption (Subtitles) to grasp the real meaning behind this song. It is not a simple dance, it is a creative fight against the rights of women and safety.

Direct Link to Video

Direct Link to Video

Thank you Koenig Solutions for inspiring all of us.

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

SQLAuthority News – Year 2012 in Review – Perspective of Blog

The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.

Click to Enlarge

Crunchy numbers:

3,200,000 people watched the Mars Rover land. This blog was viewed about 19,000,000 times in 2012. If this blog were a video of the Rover landing, it would take about 6 days for that many people to see it. In 2012, there were 372 new posts, growing the total archive of this blog to 2,360 posts. The busiest day of the year was October 9th with80,693 views.

The top referring sites:

  1. facebook.com
  2. pinaldave.com
  3. stackoverflow.com
  4. codeproject.com
  5. twitter.com

Where did they come from?

That’s 234 countries in all!
Most visitors came from The United States. India & The United Kingdom were not far behind.

Click here to see the complete report.

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

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)

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


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.


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)