SQLAuthority News – New Theme of SQLAuthority and Video Courses

I have been blogging for almost 7 years now. Recently I reached a very important milestone for my blog. I completed over 2500 blog posts as well have been receiving consistently over 2 Million Views every month. It has been a fantastic ride and I am planning to continue contributing to blog and community. However, just like everything else the blog was in need of the fresh look for a long time.

I recently updated entire theme of SQLAuthority.com and have given clear fresh look to it. Here are few of the details of enhancements:

  • Changed width from 600 px to 840 px
  • Changed theme which is responsive and mobile friendly
  • Increased font size and changed background color
  • Increased space between lines as well cleaned up overall theme
  • Cleaned up right side banner
  • Bigger images for community initiatives
  • Added new page of Video Courses
  • Changed the header of the blog with new heading

Well, if you are reading this blog post in email, you will be not able to see any changes over here. I suggest you check the http://blog.sqlauthority.com in a regular browser.

Here is another news! 

I enjoy writing on blog and I will continue to write the blog as long as I can write. However, earlier this year, I have done a year long experiment of video blogging. I blogged about SQL Server in Sixty Seconds. The series I have put on YouTube and it has been extremely successful series. You can see SQL in Sixty Seconds Series over here. The series is extremely successful as lots of people are asking me to produce more video content. I promise that I will continue to do build the SQL in Sixty Seconds episodes.

Till today I have so far created six Pluralsight Video. I am extremely happy that I have built online courses. Blog has its own place and and video learning has its own place. Technology is such that it is very difficult to convey sometimes in text mode. Building video is fun and it is scalable as well.

I plan to build a few more interesting video courses in near future. Here are few of the  existing courses which I have build for Pluralsight.

Video Courses

SQL Server Performance: Introduction to Query Tuning

Click to View Course

SQL Server Performance: Indexing Basics

Click to View Course

SQL Server Questions and Answers

Click to View Course

MySQL Fundamentals

Click to View Course

Building a Successful Blog

Click to View Course

Introduction to ColdFusion

Click to View Course

You will have to login into Pluralsight portal to watch the courses. You can watch the courses for free by signing up for a free trial. Do let me know which one of the above is your favorite course.

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

SQLAuthority News – 2500 Blog Posts, 2 Million Views per month, 62 Million Total Views

Today, I am very happy as the journey I started almost 6.5 years ago has very important milestone. I have stopped blogging about my milestone for a long time as I believe that was just taking up the space in my blog and was not providing any useful information. However, today is a special day. This is my 2500th blog post and now the next 2500th blog post will come after many years.

When I started this blog I had no idea that I will be blogging after more than 6 years and I will ever reach to 2500th blog post. It was all just started as my personal bookmark. I was expecting that I will be a single reader of this blog and had no idea for a long time that even other people can read my blog as well. Once the very first comment appeared everything was just new world for me.

I never thought I would be able to engage with so many people from all over the world. I initially thought my blog will be majorly read by Indians as India has largest population but I am delighted to see that there is a balance among continents. As of today, this blog is the most read in USA and second place is India. Thank you readers from all over the world to support me  in spreading the knowledge.

Click to Enlarge

Another interesting and important detail is that I have been receiving over 2,000,000 views per month consistently every month. I never thought so many IT Professional would be reading this blog. When I see this 2 million number, I wonder often about readers.

If you are my blog reader, I would like to know you, would you please tell me who you are and why do you visit this blog? I encourage all you to leave a comment in the comments section. On this 2500th blog post, I will select random 10 readers and will send them surprise educational gift.

Online Course on how to Build a Successful Blog

I am often asked what are the best practices to build a successful blog. I have built a video course on the topic of How to build a successful blog. 

Watch the teaser of this course.

Here are few of the topics which I am covering in the course:

  • Blogging – Concepts, Ideas And Motives
  • Getting Started With Blogging
  • Writing An Interesting Blog
  • Blogging Rules, Ethics And Etiquette
  • Frequently Asked Questions
  • Checklist For Building Successful Blog

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

SQLAuthority News – Presenting 3 Technical Sessions at Great Indian Developer Summit – May 7, 2013 – Bangalore

I will be presenting once again 3 Technical Sessions on SQL Server and Performance Tuning at Great Indian Developer Summit on May 7, 2013. If you are going to attend the event, you do not want to miss the technical sessions at any cost. Here is the generic theme for every session I will be presenting at Great Indian Developer Summit.

  • Each session will have 30% theory and 70% demonstrations
  • Attendees will have access to scripts presented in the session
  • Location to review the videos and free learning material associated with the session
  • Practical Performance Tuning Tips to tune your server

Attendees will be able to learn the knowledge which they will be able to apply as soon as they walk out of the session. Here is the details about the session:

Tips and Tricks for Blazing Fast SQL Server Performance

12:00 PM | May 7, 2013 | Main Hall
60 mins | GIDS.NET | Session

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. In this session we will cover the common issues related to the Indexes, Statistics, Joins, Conditions as well cover a few of the mistakes developers do when they are rushing to meet deadlines. We will quickly cover SQL Server Worst Practices as well have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session. Additionally all attendees of the session will have access to learning material presented in the session.

Performance in 60 Seconds – Database Tricks Every SharePoint Developer MUST Know

14:00 PM| May 7, 2013 | SD Hall
60 mins | GIDS.NET | Session

Data and Database is a very important aspect of SharePoint implementations. SharePoint Developers often come across situations where they face a slow server response, even though their hardware specifications are above par. This session is for all the SharePoint Developers who want their server to perform at blazing fast speed but want to invest very little time to make it happen. We will go over various database tricks which require absolutely no time to master and require practically no SQL coding at all. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their SharePoint implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session. Additionally all attendees of the session will have access to learning material presented in the session.

Secrets of SQL Server: Database Worst Practices

15:10 PM| May 7, 2013 | SD Hall
60 mins | GIDS.NET | Session

“Oh my God! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. Shedding light on some of these perils and the tricks to avoid them may even save your current job. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their SharePoint implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session. Additionally all attendees of the session will have access to learning material presented in the session.

If you are going to be at the event, do not hesitate to stop by Pluralsight booth. I will have something unique for you – do not forget to ask for it.

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

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)

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)