SQLAuthority News – Presented Technical Session at DevReach 2013, Sofia, Bulgaria – Oct 1, 2013

Earlier this month, I had a fantastic time presenting at DevReach 2013, in Sofia, Bulgaria on Oct 1, 2013. DevReach strives to be the premier developer conference in Central and Eastern Europe. It is organized annually in Sofia, Bulgaria. The 8th edition of the conference is moving to a new and bigger venue: Sofia Event Center.

In my career, I have presented over 9 different countries (India, USA, Canada, Singapore, Hong Kong, Malaysia, Sri Lanka, Nepal, Thailand), this was the first time for me to present in Europe. DevReach was perfect places to start my journey in Europe as an evangelist. The event was one of the most organized event I have ever come across in my life. The DevRech organization team had perfected every minute detail of the event to perfection. After the event was over I had the opportunity to see Sofia for one day.

I presented with one of my most favorite Database Worst Practices Session.

Pinal presenting at DevReach 2013, Sofia, Bulgaria

DevReach 2013

DevReach 2013

DevReach 2013

Pinal presenting at DevReach 2013, Sofia, Bulgaria

Pinal presenting at DevReach 2013, Sofia, Bulgaria

Pinal Dave and Stephen Forte at Pluralsight Booth at DevReach 2013, Sofia, Bulgaria

Pinal on City Tour of Sofia, Bulgaria

Pinal on City Tour of Sofia, Bulgaria

Pinal on City Tour of Sofia, Bulgaria

Pinal on City Tour of Sofia, Bulgaria

Pinal on City Tour of Sofia, Bulgaria

Session Title: Secrets of SQL Server: Database Worst Practices

Abstract: “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.

Thanks to Team Telerik for making this one of the best event in my life.

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

About these ads

SQL – Solution – Crossword Puzzle Based on Course Building Successful High Traffic Profitable Blog

Earlier this month we were running a contest for solving the crossword based on my Blogging courses – Course 1, Course 2. Here is the details of the contest.  The winner of the contest was to win Melting Clock (Do not confuse this as a dummy or not working clock. This looks like melting but it always shows accurate time and it is perfectly balanced to hang off of any flat surface).

Before I continue let me just add that this is my 2600th blog post on SQLAuthority.com – it has been a long journey but extremely fun.

I have received total 142 entries and out of that there was 84 valid entries. We had to go over every single cross word manually and it took way more time than we expected. Finally we went through all the valid entries and have selected a winner. The winner is selected randomly from all the valid answer which we have received.

The winner of the contest is Martin Dauksza from Greater Los Angeles area. Congratulations Martin for winning this contest. It was indeed a difficult one as there were many valid entries to this contest. Here is the solution to the original puzzle.

Here is the link to download the original crossword: Download Crossword.

Alternatively you can download the image displayed below and print it as well.


Anyway the contest is over now but if you are interested you can still print the original crossword and try to solve it. Here are two courses Course 1, Course 2 based on which this crossword is built.

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

SQL – Crossword Puzzle Based on Course Building Successful High Traffic Profitable Blog

Do you like Crossword Puzzles? I personally love it. Everytime I open the newspaper, I try to resolve at least one crossword or sudoku. It is just fun to tease a brain little and stretch its limits.

Regular readers of the blogs are aware that I have recently published two courses on how to build successful high traffic profitable blog.

Here are the links to watch both the courses: Course 1, Course 2. Do watch them in order as both the courses have unique content, which can help you build a better blog.

On my birthday July 30th, there was an interesting blog post posted on Pluralsight blog. It was a crossword build from my two courses. I encourage you try to solve the crossword which I have built.


There is a cool gift for the winner – it is melting clock. Do not confuse this as a dummy or not working clock. This looks like melting but it always shows accurate time and it is perfectly balanced to hang off of any flat surface.

How to Participate:

Well, it is very simple, you just have to complete the crossword and send it to me at pinal at sqlauthority.com with all valid answers. The deadline is that you must send it before Monday August 5, 2013 or before the valid answer keys are posted on Pluralsight blog.


Though the crossword is very easy and intuitive, if you ever get stuck anywhere here are two hints: Hint 1Hint 2. Login to Pluralsight courses and watch both the courses. Watching the course will not only help you to easily complete crossword but there are hidden gems and secrets to build a high traffic profitable blog.

Here is the link to download the crossword: Download Crossword.

Alternatively you can download the image displayed below and print it as well.


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

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)

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)