SQLAuthority News – A Quick History of Writing Three Books in Year 2011

This has been an eventful year for me. I write in various formats online and offline but becoming a published author of printed book was always my dream.

Every day I write continuously. Here are few of the writing tasks I do in my everyday routine.

I write –


I write nearly 400+ emails every day. I get about 1000 emails and 10s of thousands of spam e-mails. I am thankful that 99.99% of the spam is caught by spam filters. The remaining spam I report to my email provider. However, I still get over 1000 valid emails. I do my best to answer each of them. I write a customized email to every single person. I research quite often for a few answers and that makes me write more and more. Work and personal emails combined together means I write more than 400 emails a day. If I take a one day vacation, the next day I find myself writing 800+ emails. An empty inbox has been just a dream forever.

Web Browser

To answer emails I have to research a lot, and every day I keep on finding myself writing more and more on various browsers and in search engine boxes. An efficiency tool helped me discover that I write more than 2000+ words every day just in the search engine box. I think 2000+ words is a lot of typing!

Social Media

You can find me on pretty much all the social media sites – Facebook, Twitter, LinkedIn and Google+. I have been writing various status updates and sharing information which interests me. I really find this easy but sometime this can be very distracting as well. I often cut off myself from all the social media when I am working on something important but when I find leisure time I often spend considerable time on my social media. I often answer a few technical questions on Facebook as well engage with community folks.


I have blogged every day for the last five years and if you consider the average length of the blog post to be about 500 words, and since I am about to reach the 2000th  blog post, I have written about 1,000,000 (1 Million) words so far. As per Wikipedia the longest novel is Clarissa, or, the History of a Young Lady (by Samuel Richardson) and it has 969,000 words. If you think War and Peace by Leo Tolstoy was the longest novel, it had only 587,28 words. Well, just writing blog posts I have done almost the same amount of writing as the longest novel in the world. Note that here I am not comparing the quality or genre of the work, just comparing the length of the work.

My Daughters Workbook

I did not want to include this here. However, it is currently the best part of my life. I enjoy doing work books with my 2.25 year old daughter. I enjoy it, I sometimes write the letter ‘A’ hundreds of time to demonstrate how it is written to my daughter. Recently she spotted the letter A in the newspaper and ran to me and proudly demonstrated to me that it is ‘Daddy’s A’. I loved it, I cherish every moment of my life when I am writing with my daughter. I think this is the best time spent.

3 Books in Year 2011

After writing so much throughout my life I always wanted to write a book that adds real value to the publishing world. I wanted to write a book which tremendously helps the community. I am fortunate that I was able to write three various books in the year 2011. I am lucky to write three books which covers various aspect of my favorite technology, SQL Server.

SQL Programming

SQL developers need to be able to create processes for working databases by using one of many programming objects (like functions, stored procedures, constrains, or triggers). By creating objects that talk with SQL you simply change the way other programs (like applications or web pages) can interconnect. These eternal programs only need to call your programming objects by name rather than needing to submit large pieces of advance code. With SQL Programming Development (Volume 4 of 5) in the SQL Server Joes 2 Pros development series, you learn how programming objects work in SQL Server.

[Amazon] | [Kindle]

SQL Wait Stats

You learn a lot when thrown into a crisis situation, where everyone is looking to you for answers. The system is down, the CEO is pleading with you for answers, as each minute of downtime further cuts into the company’s bottom line. You can almost hear the fiscal charts turning upside down. The simple fix you thought would work when you received the call will not fix the scenario you’ve just walked into. In a hurry, you need new ideas right away. Let this book be your solution manual at work.

[Amazon] | [Kindle]

SQL Server Interview Questions and Answers

Today we use computers for various activities, motor vehicles for traveling to places, and mobile phones for conversation. How many of us can claim the invention of the micro-processor, a basic wheel, or the telegraph? Similarly, this book was not written overnight. The journey of this book goes many years back with many individuals to be thanked. Though each of these chapters are geared towards convenience we highly recommend reading each of the sections irrespective of the roles you might be doing since each of the sections have some interesting trivia about working with SQL Server. In the industry the role of accidental DBA’s (especially with SQL Server) is very common. Hence, if you have performed the role of DBA for a short stint and want to brush-up your fundamentals then the upcoming sections will be a great review.

[Amazon] | [Sample Chapters] | [Kindle]

In future blog posts I will dive deeper into these books’ writing experiences.

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

Previous Post
SQL SERVER – Year End Brain Teaser – Disabled Login and Associated User Without Disabled User Red Arrow
Next Post
SQLAuthority News – An Year Worth Remembering and Looking Forward to Better Next Year

Related Posts

10 Comments. Leave new

  • Hemantgiri S. Goswami
    December 30, 2011 8:49 am

    Going great buddy, the best part in the blog post is Blogs and daughters workbook. And, indeed, writing 3 book in a year takes lots of effort.

    Kudos to you.

  • Interesting..

    Happy New Year Sir…,

  • 2.25 Years, decimal system for defining age :D But it has become tendency of everyone to write that way :)

    Learnt a lot from your blog and hope you’ll be writing with same enthusiasm and spirit year after year and will contribute to community. Keep Writing!

  • Chirag Satasiya
    December 30, 2011 11:23 am

    Hi pinal sir,
    Working for the people is one of the best thing in this world.
    Thank you so much for this blogs and books.

    Chirag Satasiya

  • Hi pinal,

    I am reading your blog for last three years. Compare to previous years, in this year, you done lots of thing like, become a Author of printed book, give training in VTD, take lunch with Steve Jones (SSC Editor), become a part of Microsoft.

    I wish you good luck for coming new year. New milestones are waiting for your .

    Vinay Kumar

  • Gopalakrishnan Arthanarisamy
    December 30, 2011 1:14 pm

    Hi Pinal,

    I like this statement very much,

    “I sometimes write the letter ‘A’ hundreds of time to demonstrate how it is written to my daughter. Recently she spotted the letter A in the newspaper and ran to me and proudly demonstrated to me that it is ‘Daddy’s A’. I loved it, I cherish every moment of my life when I am writing with my daughter. I think this is the best time spent.”

    Gopalakrishnan Arthanarisamy
    Unisys, Bangalore

  • Appreciating your effort.

    Advance happy new year ….

  • Pinal,

    I have your wait stats book sitting on my desk as I type this. It is an awesome book. Thanks for everything you do for the SQL community.

    Scott Shaw

  • Awsome work sirji..ur truly an inspiration…
    Ur articles have been really useful…
    Happy New Year to u nd ur family…


Leave a Reply Cancel reply

Exit mobile version