SQL Authority News – 3000th Blog Posts and Thank You

3000th Blog Posts! 

When I realized that I am writing my 3000th blog post (list of all of my blog posts), I just got blank with happiness. I could not come up with what exactly to write. It has been a long time since I have stopped writing about milestones. I believe writing about milestone is not helpful to users, it is just plain bragging about oneself. However, when I reach 3000th blog post. I am just stunned and not sure what to talk about. I will now answer three questions which I have received about this blog in the last month, maybe that will give some insight in my blog post.

Q: How can you write every single day from last 7 years?
A: It is about to be 8 years soon. I just enjoy it. Every day, I write one blog post before I start my daily routine. May be this discipline has helped me. I have talked about secrets of this in my latest Play by Play: Pinal Dave  Course.

Q: Do you have a day job or you just do blogging?
A: Yea, I have a day job where I go to the office, work for over 8 years, take a lunch break and have amazing people to work with. I work for Pluralsight as an Evangelist. However, blogging is my passion and heart beat. That is why I have recently written a book on Secret Tool Box of Successful Bloggers: 52 Tips to Build a High Traffic Top Ranking Blog and it is doing quite well.

Q: I want to learn more about blogging, is there any other resource besides your book do you suggest?
A: Well, I suggest you read my book as that is the latest additional to my library. It is 12th book I have authored in last 3 years and a very first non-technical book. If you do not want to read books, you can watch my Pluralsight courses on Building a Successful Blog and Building a High Traffic, Profitable Blog. Both of the courses are very unique in nature and gives perspective in my methodology in blogging.

Bonus Q: If you have a day job and you spend so much time in writing books as well as authoring video courses – when do you sleep?
A: Well, let me quote my favorite author Robert Frost.

The woods are lovely, dark and deep,   
But I have promises to keep,   
And miles to go before I sleep,   
And miles to go before I sleep.

I am just humbled and thank you to all of you. I really mean it.

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

About these ads

SQL Authority News – Secret Tool Box of Successful Bloggers: 52 Tips to Build a High Traffic Top Ranking Blog

When I started this blog, it was meant as a bookmark for myself for helpful tips and tricks.  Gradually, it grew into a blog that others were reading and commenting on.  While SQL and databases are my first love and the reason I started this blog, the side effect was that I discovered I loved writing.  I discovered a secret goal I didn’t even know I wanted – I wanted to become an author.  For a long time, writing this blog satisfied that urge.  Gradually, though, I wanted to see my name in print.

12th Book

Over the past few years I have authored and co-authored a number of books – they are all based on my knowledge of SQL Server, and were meant to spread my years of experience into the world, to share what I have learned with my community.  I currently have elevan of these “manuals” available for sale.  As exciting as it was to see my name in print, I still felt that there was more I could do as an author.

That is when I realized that I am more than just a SQL expert.  I have been writing this blog now for more than 10 years, and it grew from a personal bookmark to a thriving website with over 2 million views per month.  I thought to myself “I could write a book about how to create a successful blog!”  And that is exactly what I did.  I am extremely excited to share with all of you my new book – “Secret Toolbox of Successful Bloggers.”

A Labor of Love

This project has been a labor of love for me.  It started out as a series for this blog – I would post one article a week until I felt the topic had been covered.  I found that as I wrote, new topics kept popping up in my mind, and eventually this small blog series grew into a full book.  The blog series was large enough to last a whole year, so I definitely thought that it could be a full book.  Ideas on how to become a successful blogger were so frequent that, I will admit, I feel like there is so much I left out of this book.  I had a lot more to say than I originally thought!

I am so excited to be sharing this book with all of you.  I am so passionate about this topic, and I feel like there are so many people who can benefit from this book.  I know that when I started this blog, I did not know what I was doing, and I would have loved a “helping hand” to tell what to do and what not to do.  If this book can act that way to any of my readers, I feel it is a success.

Rules of Thumb

If you are interested in the topic of becoming a blogger, as you read this book, keep in mind that it is suggestions only.  Blogging is so new to the world that while there are “rules of thumb” about what to do and what not to do, a map of steps (“first, do x, then do y”) is not going to work for every single blogger.  This book is meant to encourage new bloggers to put their content out there in the world, to be brave and create a community like the one I have here at SQL Authority.  I have gained so much from this community, I wanted to give something back, and this book is just one small part.

I hope that everyone who reads this books finds at least one helpful tip, and that everyone can experience the joy of blogging.  That is the whole reason I wrote this book, and what I hope everyone takes away from it.

Where Can You Get It?

You can get the book from following URL:

Kindle eBook | Print Book

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

Developers – Drive by Daniel Pink – Book Review

I have been an avid reader of books. I read pretty much one or two books every week. I believe reading helps me a lot in my day job as well as well writing blog post. I am an evangelist and my primary responsibility is to spread the love for the technology. When I read more, I learn more and that effectively leads me to communicate better with my audience. Here is one of the recent book which I read and I loved it. This book is about what motivates us and what is the best job for us. I have read this book a second time and I think finally I have digested the meaning of this book. I love every bit of it and if you do not have it, you should get it.

I am going to give 10 Drive physical books to 10 people who register for my newsletter over here.

If you want to own the book, you can get it from Amazon |Flipkart.


Here are essential few quotes from the book.

The joy of the task was its own reward.

When money is used as an external reward for some activity, the subjects lose intrinsic interest for the activity.

Rewards can deliver a short-term boost – just as a  jolt of caffeine can keep you cranking for a few more hours. But the effects wears off – and, worse, can reduce a person’s longer term motivation to continue the project.

Enjoyment-based intrinsic motivation, namely how creative a person feels when working on the project, is the strongest and most pervasive driver.

Intrinsic motivation is of great importance for all economic activities. It is inconceivable that people are motivated solely or even mainly by external incentives.

Intrinsic motivation is conductive to creativity; controlling extrinsic motivation is detrimental to creativity.

It is those who are least motivated to pursue extrinsic rewards who eventually receive them.

Greatness and nearsightedness are incompatible. Meaningful achievement depends on lifting one’s sights and pushing toward the horizon.

Any extrinsic reward should be unexpected and offered only after the task is complete.

Type Intrisic behavior emerges when people have autonomy over the four T’s: their task, their time, their technique, and their team.

If you want to work with more type Intresic’s the strategy is to become one yourself. Automony, it turns out, can be contagious.

There is complexity, autonomy, and a relationship between effort and reward in doing creative work, and that’s worth more to most of us than money.

Carrots & sticks are so last century. Drive says for 21st century work, we need to upgrade to autonomy, mastery & purpose.

This new approach has three essential elements: (1) Autonomy—the desire to direct our own lives; (2) Mastery—the urge to get better and better at something that matters; and (3) Purpose—the yearning to do what we do in the service of something larger than ourselves.

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

SQLAuthority News – Speaking at C-Sharp Corner Annual Conference 2014 – April 11-13 – Delhi

I will be speaking at C-Sharp Corner Annual Conference 2014 – April 11-13 – Delhi. I am extremely excited and fortunate with the opportunity to present a technical session at the North India’s largest conference. The wonderful people at the conference has been doing this annual event for quite a few years and every year there are over thousands of attendees from all over the India attending it. C# Corner ANNUAL CONFERENCE is a 3 day annual meeting where C# Corner mentors, authors, chapter leaders, moderators, editors and experts meet, demonstrate, plan and hang out. One day of the conference is open to C# Corner members (this is when I am going to present technical session). There are only five days left for this extremely popular conference of India.

Here are the details of the technical session I am going to present:

Secrets of SQL Server: Database Worst Practices
Date and Time: April 12, 2014 9:45-10:30 AM
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. 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.

Indexes – The Unsung Hero
Date and Time: April 12, 2014 1:30-2:15 AM
Abstract: 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 Indexes has been set up. The session will focus on the ways of identifying problems that slow down SQL Server, and Indexing tricks to fix them. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

The event venue is Radisson Blu Hotel Ghaziabad. H3, Sector 14. Kaushambi Ghaziabad 201010 Uttar Pradesh. You do not want to miss out on any of the sessions. I will have surprise gifts for selected attendees. I will ask some question during the session and if you get it right, trust me, you will be extremely happy with the gift.

Registration for this event has been closed and there are over 2100 registered attendees to this event. It is a FREE event so there is no cost to attend this event.

I am looking forward to catch up with you at the event. Special mention to the team who is making this event a huge success: Mahesh, Dhananjay, Praveen, Dinesh! 

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

SQLAuthority News – Sign up for SQL Authority Low Frequency Newsletter

One More Newsletter!

You might already be receiving our emails in your mailbox, so why should you sign up for SQL Authority Newsletter (Sign-up).

Well, a great question. Let me answer this first.

Why should you sign up?

First of all – it is not going to be a daily email from the blog which you are receiving. It is going to be a very informal conversation between us. I blog about various details related to technology, but there are few things, I just want to keep exclusively for newsletter. For example, if I want to discuss the book which I am reading or movie I have watched or database news which I have heard from industry or just something really cool which I do not feel appropriate for the blog, I am going to include them in my newsletter. I am not going to send your summary of the week or best of the monthly newsletter, if I am going to send your newsletter, it is going to contain something unique and useful.

What do I mean by Low Frequency Newsletter?

Well, there is no set frequency of this newsletter. I am not going to send this every Tuesday or Thursday. I am going to send it when I have something unique to say and newsletter is the most appropriate way to send email. You may receive this email once a month or maybe once every 2 weeks – there is no set frequency.

What will this newsletter contain primarily?

Again, there is no set agenda for the newsletter but I promise that it is going to be fun stuff and interesting. This blog is primarily for talking technology, but there are so many different elements of life I face every day and I hardly get time to share with everybody. I do quite a bit sharing on Facebook (if you have not liked the page, do it now), but again, there are few things, which just makes sense in the newsletter.

How do I sign up for the newsletter?

Click here to sign up for the newsletter. It will send you a confirmation email, please follow the link in the confirmation email to activate your subscription to the newsletter.

What if I want to unsubscribe to the newsletter?

In the newsletter, there is a link to unsubscribe it. No hard feelings – it is your mailbox and you decide what goes there.

Final Note

If you sign up for the newsletter before the end of this month, you will be entered to win Hexbug Hive (India) or  Hexbug Hive (USA). The winner will be announced in the newsletter only. If you have never played with Hexbug and Hexbug Hive, you may just want to sign up for the newsletter for the chances to win them. It is pretty fun game and people at every age likes it. See video over here.

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

SQLAuthority News – Happy New Year 2014 – Resolution of the New Years

First of all, happy New Year to all of you – 2014 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 2014 commitments are professional, and some are in my personal life.  I want to see how I progress over the year.

However, before I go to year 2014 resolutions, let us check how did I do with my SQL 2013’s resolution.

  • Write more books – Done. I wrote total 10 books before the end of year 2013.
  • Go beyond SQL – Done. I learned a lot about Big Data (wrote a series on it) and MySQL (build courses on it).
  • Attend SQL training – Done. I learned that in Feb 2013.
  • Reduce my weight – Failed. I gained a few pounds.

Well, I am disappointed that I failed in taking care of my health in 2013. Now in year 2014, I must focus on my health – there should not be any excuse. Without further ado here are my year 2014’s resolutions.

Reduce My Weight

I failed this last year so I must keep this one as a priority. This is a very difficult one for me personally. I travel a lot – internationally and domestic. I have a sweet tooth and I love anything sweet. I love fast food and we all know what this one does to people. Anyway, I am still going to reduce my weight in the year 2014. I am going to eat healthy and every day going to spend 30-45 minutes of exercise. My wife is going to come up with the plan so I will have someone always watching my progress. I did not want to talk about this any more as last year I failed with this goal. Let us talk about this next year.

Learn More on Big Data / NOSQL

I did a pretty good job in the year 2013 with this subject. I pretty much walked into my non-comfort zone and learned a lot about Big Data. I wrote a month long series on Big Data on this blog and did presentations as well on this topic. I feel I have overcome initial obstacles and I can now handle Big Data subject pretty easily. However, the subject of Big Data is indeed very wide and deep. I think there are lots of different things to learn from me and I have a long way to go before I even call myself a moderate expert on this subject. I am going to come up with one or two different series on NoSQL and Big Data in year 2014 and learn more about them.

More Video Training Courses

In year 2013 I have done 7 of Pluralsight video courses on various subjects. You can see the list over here. I am planning to do a minimum of 4 (one per quarter) video course for Pluralsight on various subjects. I like to do a mix of database and social media courses. I have built a list of the courses with me and I am hoping that I will be able to accomplish my goal for Video Courses in the year 2014. Trust me sharing the knowledge with the medium of video is very satisfying.

Well, that’s it. I have three simple goals and I hope that next year when I write this blog post, I have completed all of my goals.

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

SQL – A Career in Database Forensics

A growing field in the information security domain – Database Forensics offers a comprehensive and highly sophisticated skill set that allows professionals to uncover and trace data security breaches of the highest order and complexity. Many enterprises are looking to hire such professionals nowadays. Critical data needs to be guarded and organizations are leaving no stone unturned to ensure that their confidential records are safely stored and accessed. But how do you become a forensics expert without getting lost in the maze of security programs and products. Koenig India shows you the way:

Why are databases critical assets?

  • They hold crucial information
  • Database servers contain sensitive information which can be used as well as misused
  • Data security regulations mandate all security breaches to be reported

Therefore, Using analysis and  investigative tools and techniques, professionals gather evidence from the database which is suitable for presenting legally in a court of law.

Some Benefits

  • Identify pre and post transaction data
  • Retrace user DDL & DML operations
  • Recover deleted data rows
  • Prove/dismiss a data security breach
  • Determine the scope and extent of database intrusion

Apart from these technical skills, individuals must possess analytical abilities and a problem solving attitude. Uncovering hidden patterns, unexpected correlations, and sorting through data to extract meaning out of it – are some of the essential skills required of a forensic expert.

Another crucial skill is the knowledge of cyber laws. An understanding of the legal procedures and law enforcement agencies’ requirements is of great importance if you are to conduct digital investigations.

SQL Server Forensics Analysis course offers the foundation required to become a forensic expert in the online world. Also learn other associative skills such as cryptography, e-discovery and incident response in this latest training program.  A relatively new field of study, the course offers a great opportunity for those who wish to gain credibility in this stream.

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