SQL – Building a High Traffic, Profitable Blog – A Unique Gift on Author’s Birthday

Every July 30th, I like to do something new. It is my birthday and I like to give gifts to everyone this day. Last year, at this time I had written an article A Year Older and 3 SQL Server Books and 3 Video Courses – 33. I had written a total of 3 books by that time and had published total of  3 Pluralsight courses. When I look back the year, I feel that I gave my best to last year. Sine Last July 30th, I have written 6 more books and 5 more video courses. The total is now 9 books and 8 video courses. It seems that I have been producing one new book or course every month since last July.

Building a High Traffic, Profitable Blog

Out of my 8 courses my favorite course is my latest course at Pluralsight. This course is about how to build a high traffic blog and monetize it. I have been blogging for over 7 years and there have been many hurdles and roadblocks but I have never stopped blogging any single day. There have been many instances when I felt I should just hit delete and remove my entire blog from the web but fortunately I had courage to stand by on my decisions. Well at the end, I kept on fighting through the difficult time and kept on blogging.

Every day there was a lesson to learn and every day there was an issue to resolve. I never gave up and kept on building new content. Today after 7 years, when I look back there are many stories to tell. It was impossible to write down the stories so I decided to build a course based on my experience. In this course, I share all the best tricks to build a high traffic, profitable blog. When we talk about profit, people often talk about money but the reality is that profit is much bigger word than money. There are many different ways one can profit from their own blog.

In this course, I discuss about all different ways about how you can be profitable by building a high traffic blog. I believe this course is for everybody who aspire to build a website or blog which gives them a profit.  Here are the major topics based out of this course.

  • Introduction
  • Techniques to Engage Blog Readers
  • Social Media – Social Sharing and Social Networking
  • Search Engine Optimization (SEO)
  • Monetizing a Blog
  • Frequently Asked Questions
  • Checklists

Personally I believe this is the best gift I can give to all of you my friends. Build a successful high traffic blog and monetize it.

Here is the list of the all of my video courses and here is the list of all of the books.

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

About these ads

SQLAuthority News – Don’t Be Afraid To Fool The World – Video by John Sonmez

Sometime some words and statements grabs your attention and it is hard to stop thinking about that after a while. Something similar happened a few days ago when I read the twitter statement of my friend and Pluralsight author John Sonmez. He twitted few days ago very interesting statement.

“I don’t know a single successful person, who doesn’t deep down think that have the world fooled. #fooltheworld” by John Sonmez.

When I read it, I was extremely intrigued by this statement. I read it many times, I shared with my family and I just could not stop interpreting this statement. It was indeed fun to read it again and again and there are so many different meanings one can take away from the statement. I know John very well, he is a  wonderful person and have very positive energy for the life. I just had to request him to build a video around it. Right after 5 days of my request, John created a wonderful video around this subject. I watched it multiple times as it was a wonderful video.

I am not going to write about what was in the video much as I suggest you to watch the video itself.

Here is one of the personal stories I want to share which is absolutely relevant to this video. I think my story 100% resonant the story of John.

A Real Story from My Past

Three years ago, I submitted a session in one of the SharePoint conference as a SQL Server session. My session was accepted and I prepared it very well. I put more than 2 month’s time to prepare for the session and I was very excited to present the session. I reached to the event place traveling thousands of the miles and I was very much excited to present the session. However, there was a little mixed up in the session. There were multiple session which were similar to my session title. One of the other speakers also had proposed a database related session and was selected. When the material went to print the printing team got confused and by mistake swapped the sessions. The other speaker got Performance with SQL Server session and I had received Performance with SharePoint session. IT was indeed a big mixed up but now that is how it was in the event guide and it was marketed the same way everything in the event.

A Big Mix Up

I had to talk with the event organizer and we come to the conclusion that we all had good intention but things just got mixed up and now was the time when “The show must go on“. I had a great amount of hesitation to go and present the session as I had personally never worked with Sharepoint so close in my life and my session abstracted talked about SharePoint tricks in depth. Two hours before the session I took the help of one of my friend and installed the SharePoint on my box. He showed me a few things here and there but it was never a good enough time to learn everything which I wanted to learn.

The Moments of Confidence

I was very scared and nervous to go on the stage as a SharePoint was not something I felt comfortable. However, I decided to go on stage with confidence as a SharePoint expert. Though I did not know SharePoint at the best, I had confidence that whatever I know is correct and I will not misguide people. I had no intention to fool people but I had no intention to accept that I am a fool and you all wasted your time and money to dedicate your time to attend my session. I decided to be honest but at the same time decided to take the session beyond my expertise. The sixty minutes of the session went very fine and I was able to manage all the difficult question at a satisfactory level. When the session was over my feeling was that I would have not presented or talked any different if I had more knowledge of the SharePoint at that time. I think it was one of my best sessions and it was reflected in the session feedback as well. I was the best speaker across all the track and my session had highest ranking. I was delighted and I learned a very valuable lesson.

I must go beyond my limits and knowledge. I must aim higher and work harder. I should not lie but I should have confidence that I have a good heart and I put 100% in my efforts. 

Lessions Learned

Since this incident I have learned a lot about SharePoint and I am now a regular speaker at various SharePoint conferences along with SQL Server sessions. I am motivated and I am not afraid. I know people have lots of expectation from me but I have learned not to judge myself before I do my best. I leave the judgement of my efforts to my audience. I do not take the burden of the feedback on me, even though I know my audience have expected from me. I know what I know and I put my best. I must go out, if I fail, I learn from my mistake but I must keep my progress trajectory very high.

As John said in the video, sometime success is not something we can achieve 100% but we can keep on going near to it. As long as we do not lose our focus from our goal and do not deviate from our progress path, we are doing things right.

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

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:

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)

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)