SQLAuthority News – Uncut and Unedited – Interview of Pinal Dave on Book Authoring

Writing a book was not an easy task. Publishing two books in a month were even harder task. In Sep-Oct 2011 I have published two books. I was very happy when books were published and I got a print copy in my hand. In this blog post we will discuss about Book Authoring.
In latest episode we discuss on the following things:

About his new book
His experience as an author
Why the name SQL Joes 2 Pros
Where can we buy his books
Challenges when writing this book

Read More

SQL SERVER – Restore Database Backup using SQL Script (T-SQL)

In this blog post we are going to learn how to restore database backup using T-SQL script. We have already database which we will use to take a backup first and right after that we will use it to restore to the server. Taking backup is an easy thing, but I have seen many times when a user tries to restore the database, it throws an error.

Read More