Feeds:
Posts
Comments

Archive for the ‘Joes 2 Pros’ Category

Fans of this blog are aware that I have recently released my new books SQL Server Functions and SQL Server 2012 Queries. The books are available in market in limited edition but you can avail them for free on Wednesday Nov 14, 2012. Not only they are free but you can additionally learn SQL Server 2012 Error Handling as well.

My book’s co-author Rick Morelan is presenting a webinar tomorrow on SQL Server 2012 Error Handling.

Here is the brief abstract of the webinar:

People are often shocked when they see the demo in this talk where the first statement fails and all other statements still commit. For example, did you know that BEGIN TRANCOMMIT TRAN is not enough to make everything work together? These mistakes can still happen to you in SQL Server 2012 if you are not aware of the options. Rick Morelan, creator of Joes2Pros, will teach you how to predict the Error Action and control it with & without structured error handling.

Register for the webinar now to learn:

  • How to predict the Error Action and control it
  • Nuances between successful and failing SQL statements
  • Essential SQL Server 2012 configuration options
Register for the Webinar and be present during the webinar. My co-author will announce a winner (may be more than 1 winner) during the session. If you are present during the session – you are eligible to win the book.
The webinar is scheduled for 2 different times to accommodate various time zones. 1) 10am ET/7am PT 2) 1pm ET/11am PT. Each webinar will have their own winner. You can increase your chances by attending both the webinars. Do not miss this opportunity and register for the webinar right now.
The recordings of the webinar may not be available.

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

About these ads

Read Full Post »

As an author the most interesting task is to participate in Book Signing Events. If you are at SQLPASS – we are going to have a lot of book signing events. Here is the good news!

MY NEW BOOKS ARE OUT!

SQL 2012 Functions Limited Edition

Click to Expand

This book is a very special edition book. Our current plans is to run this book for the limited edition. You can avail this book from Amazon and it will soon come to India. Join following book signing events where you will get this book for free.

Wednesday, November 7, 2012
7pm-8pm - Embarcadero Booth Book Signing (FREE BOOK)

Thursday, November 8, 2012
12pm-1pm - Embarcadero Booth Book Signing (FREE BOOK)

SQL Queries 2012 Joes 2 Pros Volume1

Click to Expand

This is my first book this year which will be available in bookstores. Last Year I published 3 books and this year this is my first book. This book is available on Amazon over here and it will come to India very soon. Join following book signing events where you will get this book for free.

Wednesday, November 7, 2012
12pm-1pm – Book Signing at Exhibit Hall Joes Pros booth#117 (FREE BOOK)

If you are attending SQLPASS you may get this book’s Autographed Special Edition for FREE if you attend following book signing events.

Rest all the time – I will be at Exhibition Hall Joes 2 Pros Booth #117. Stop by for the goodies!

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

Read Full Post »

Earlier this week we announced that we will be giving away FREE SQL Wait Stats book to everybody who will get SQL Server Joes 2 Pros Combo Kit. We had a fantastic response to the contest. We got an overwhelming response to the offer. We knew there would be a great response but we want to honestly say thank you to all of you for making it happen. Rick and I want to make sure that we express our special thanks to all of you who are reading our books.

The offer is still on and there are two more days to avail this offer. We want to make sure that everybody who buys our most selling combo kits, we will send our other most popular SQL Wait Stats book. Please read all the details of the offer here. The books are great resources for anyone who wants to learn SQL Server from fundamentals and eventually go on the certification path of 70-433.

Exam 70-433 contains following important subject and the book covers the subject of fundamental. If you are taking the exam or not taking the exam – this book is for every SQL Developer to learn the subject from fundamentals.

  •  Create and alter tables.
  • Create and alter views.
  • Create and alter indexes.
  • Create and modify constraints.
  • Implement data types.
  • Implement partitioning solutions.
  • Create and alter stored procedures.
  • Create and alter user-defined functions (UDFs).
  • Create and alter DML triggers.
  • Create and alter DDL triggers.
  • Create and deploy CLR-based objects.
  • Implement error handling.
  • Manage transactions.
  • Query data by using SELECT statements.
  • Modify data by using INSERT, UPDATE, and DELETE statements.
  • Return data by using the OUTPUT clause.
  • Modify data by using MERGE statements.
  • Implement aggregate queries.
  • Combine datasets.
  • INTERSECT, EXCEPT
  • Implement subqueries.
  • Implement CTE (common table expression) queries.
  • Apply ranking functions.
  • Control execution plans.
  • Manage international considerations.
  • Integrate Database Mail.
  • Implement full-text search.
  • Implement scripts by using Windows PowerShell and SQL Server Management Objects (SMOs).
  • Implement Service Broker solutions.
  • Track data changes.
  • Data capture
  • Retrieve relational data as XML.
  • Transform XML data into relational data.
  • Manage XML data.
  • Capture execution plans.
  • Collect output from the Database Engine Tuning Advisor.
  • Collect information from system metadata.

Availability of Book USA - Amazon | India - Flipkart | Indiaplaza

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

Read Full Post »

Rick Morelan and I were discussing earlier this month that what we can give back to the community. We believe our books are very much successful and very well received by the community. The five books are a journey from novice to expert. The books have changed many lives and helped many get jobs as well pass the SQL Certifications. Rick is from Seattle, USA and I am from Bangalore, India. There are 12 hours difference between us. We try to do weekly meeting to catch up on various personal and SQL related topics. Here is one of our recent conversations.

Rick and Pinal

Rick and Pinal

Pinal: Good Morning Rick!

Rick: Good Morning…err… Good Evening to you – Pinal!

Pinal: Hey Rick, did you read the recent email which I sent you – one of our reader is thanking us for writing Joes 2 Pros series. He wants to dedicate his success to us. Can you believe it?

Rick: Yeah, he is very kind but did you tell him that it is all because of his hard work on learning subject and we have very little contribution in his success.

Pinal: Absolutely, I told him the same – I said we just wrote the book but it is he who learned from it and proved himself in his job. It is all him! We were just igniters.

Rick: Good response.

Pinal: Hey Rick! Are we doing enough for the community? What can we do more?

Rick: Hmmm… Let us do something more.

Pinal: Remember once we discussed the idea of if anyone who buys our Joes 2 Pros Combo Kit in the next 2 weeks – we will send them SQL Wait Stats for free. What do you say?

Rick: I agree! Great Idea! Let us do it.

Free Giveaway

Well Rick and I liked the idea of doing more. We have decided to give away free SQL Server Wait Stats books to everybody who will purchase Joes 2 Pros Combo Kit between today (Oct 15, 2012) and Oct 26, 2012. This is not a contest or a lucky winner opportunity. Everybody who participates will qualify for it.

Combo Availability

USA – Amazon

India - Flipkart | Indiaplaza

Note1: USA kit contains FREE 5 DVDs. India Kit does not contain 5 DVDs due to legal issues.
Note2: Indian Kit is priced at special Indian Economic Price.

Qualify for Free Giveaway

  • You must have purchased our Joes 2 Pros Combo Kit of 5 books between Oct 15, 2012 and Oct 26, 2012.
  • Purchase before Oct 15, 2012 and after Oct 26, 2012 will not qualify for this giveaway.
  • Send your original receipt (email, order details) to following addresses: “books@SQLAuthority.com;info@Joes2Pros.com” with the subject line “Joes 2 Pros Kit Promotion Free Offer”. Do not change the subject line or your email may be missed. 
  • Clearly mention your shipping address with phone number and pin/zip code.
  • Send your receipt before Oct 30, 2012. We will not entertain any conversation after Oct 30, 2012 cut off date.
  • The Free books will be sent to USA and India address only.
  • Availability USA - Amazon | India - Flipkart | Indiaplaza

Do leave a comment if you have question or comment.

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

Read Full Post »

SQL Wait Stats

SQL Wait Stats

About a year ago, I experienced a very proud moment. I published my second book, SQL Server Wait Stats, also acting as its primary author. It has been a long journey since then. The book received a generally great response and it has been widely accepted in the Community ever since its release. It was actually a first-of-its-kind book written to concentrate on the subject of Wait Stats and Performance. The book was based from my month-long blog series about the same subject, SQL Server Wait Stats. Today’s the first anniversary of the book, and lots of things come to my mind. Let me share a few here.

Idea behind Blog Series

A very common question I receive is why I wrote a 30 day series on Wait Stats. There were two reasons behind this series:

1) I have been working with SQL Server for a long time now and have troubleshoot more than hundreds of SQL servers which are related to performance tuning. It was a great experience and it taught me a lot of new things. I always documented my experience. After a while I found that I was able to rely completely on my own notes when I had to troubleshoot any server. It is right then that I decided to document my experience for the Community.

2) While working with Wait Stats, there were a few things which I thought I knew well enough since they were working. However, there was always a fear in the back of mind about what happens if what I believed was incorrect and I was on the wrong path all the time. There was only one way to get my belief validated -put it out in front of all the Community with my understanding and request further help to improve my understanding. And it worked – it worked beautifully. I received plenty of conversations, emails and comments. I refined my content based on the various conversations with others and made my understanding more relevant and accurate.

I guess that these two are the major reasons for beginning my journey on writing Wait Stats blog series.

Idea behind Book

After writing a blog series there was a good amount of request from my readers saying that I should convert the series into an eBook or a hardcopy. They said that reading the blog posts is great, but it does not give a comprehensive understanding of the subject as much as a book does. The most common feedback from users who were beginning to study the subject was that they prefer to read all about Wait Stats in a structured method. After receiving the same feedbacks for more than 4 months, I decided to write a book based on the blog posts. When I envisioned the book, I wanted to make sure that this book would address the Wait Stats concepts from the fundamentals and fill the gaps on the blog posts I wrote earlier.

Rick Morelan and Joes 2 Pros Team

I must acknowledge my co-author Rick Morelan for his unconditional support in writing this book. I had already authored one book before I published this book. The experience to write the book was out of the world. Writing blog posts are much much easier than writing books. The efforts it takes to write a book is 100 times more even though the content is ready. I could have not done it myself if it wasn’t for the tremendous support of my co-author as well as my editor’s team. We spend days and days researching and discussing various concepts that were to be covered in the book. When we were in doubt, we reached out to experts to improve the content, and also did a practical reproduction of the scenarios to validate the concepts and claims. After 3 months of continuous hard work, we were able to get this book published into the Community.

September 1st – the lucky day

Well, we had to select any day to publish the books. When the book was completed in the last week of August, we felt very glad. Every time my books are published, I feel the same joy which I had when my daughter was born. The feeling of holding a new book on my hand feels (almost) the same as holding newborn baby. I was excited. For me, September 1st was (and has always been) the luckiest day of my life.

My daughter Shaivi was born on September 1st. Since then, every September first has been a special day for me, and has always taken me to the next step in life. I believe anything and everything I do on September 1st is turning out to be successful and blessed.

Rick and I had finished a book in the last week of August. We sent it to the publisher (printer) and asked him to publish the book as soon as possible. We did not decide on any date as we wanted the book to get out as fast as it can. Interestingly, the publisher/printer selected September 1st for publishing the book. Because it was published on 1st September, I got a feeling that this book would reach the next level.

Book Model – The Most Beautiful Girl

We were done with book. We had no budget left for marketing. Rick and I had a long conversation about how to spread the word for the book so it can reach as many people as it can. While we were talking about marketing Rick come up with the idea that we should hire the most beautiful girl around who acknowledges our book and genuinely cares for the book.

I am a father and the most beautiful girl for me is my daughter. This was not a difficult task for me. Rick had given me the task to find the most beautiful girl and I just could not think of anyone else than my own daughter. I still do not know what Rick thought about this idea but I had already made up my mind. You can see the detailed blog post here.

The Fun Experiments

Book Signing Event

Book Signing Event

We had lots of fun moments along this book. Actually, we have given away more books to people for free than we have sold them. We went through book signing events, contests, and just plain give away events when we found out that more people could benefit from this book. There was never an intention to make money and get rich. We just wanted to see more and more people learning about this new concept and learn from it. Today when I look back at the earnings in dollars, there’s nothing much really. However, the best reward we received has been the relentless satisfaction and love of community. The amount of emails, conversations we have received for this book is over thousands as of the moment.

We had fun writing this book; it was indeed a very satisfying journey. I have earned lots of friends while learning and exploring.

Availability

The book is one year old, but the content is still very relevant when it comes to performance tuning. It is available at various online book stores. If you have read the book, please let me know what you think of it.

Amazon | Kindle | Flipkart | Indiaplaza

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

 

 

 

Read Full Post »

« Newer Posts - Older Posts »