Feeds:
Posts
Comments

Archive for the ‘About Me’ Category

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

Posted in About Me, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, tagged on May 16, 2013 | 99 Comments »

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)

About these ads

Read Full Post »

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

Posted in About Me, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology on May 2, 2013 | 5 Comments »

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)

Read Full Post »

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

Posted in About Me, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology on February 15, 2013 | 1 Comment »

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:

Location:
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)

Read Full Post »

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

Posted in About Me, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on February 7, 2013 | 1 Comment »

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)

Read Full Post »

SQLAuthority News – Year 2012 in Review – Perspective of Blog

Posted in About Me, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLServer, T SQL, Technology, tagged on January 3, 2013 | 6 Comments »

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)

Read Full Post »

Older Posts »