SQL Tips and Tricks Archives - Page 285 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – To Err is Human; to Forgive, Divine – Errata of SQL Server Interview Book

January 4, 2012

Personal, SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQLAuthority Book Review

Regular readers of my blog will know that I have written three books this year. We are currently reviewing readers comments about SQL Server Interview Questions and Answers. I am sorry to announce that we made a mistake but happy to add that we have corrected it. We will pay…

SQL SERVER – Significance of Various Kinds of Triggers- Quiz – Puzzle – 2 of 31

January 3, 2012

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

Click here to get free chapters (PDF) in the mailbox Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. Here is an article which discusses the Author’s Perspective. While writing the book,…

SQL SERVER – Importance of ANSI ISOLATION Levels in SQL Server Database – Quiz – Puzzle – 1 of 31

January 2, 2012

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

Click here to get free chapters (PDF) in the mailbox Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There…

SQLAuthority News – An Year Worth Remembering and Looking Forward to Better Next Year

December 31, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Year 2011 will be my favorite year for long time. I have achieved many personal milestones this year. I will list few things here today, which should keep me inspired next year to do even better. Here is my blog post which I have written for January 1, 2011 SQLAuthority…

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

December 30, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

SQLAuthority Book Review

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 – Emails…

SQL SERVER – Year End Brain Teaser – Disabled Login and Associated User Without Disabled User Red Arrow

December 29, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

I have received lots of good responses to the puzzles, quizzes and brain teasers posted on this blog post. As the year is ending, I have decided to give two interesting puzzles for you. The first one is easy and the second one is equally uncomplicated, but let us see…

SQL SERVER – Effect of Compressed Backup Setting at Server Level on Database Backup

December 28, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

I recently received following question from reader. I would like to share the complete story in few short sentences with you to give you complete idea. Let us call the reader Margie. Our long email conversation is converted into chat like conversation Margie: Hi Pinal – I am seeing strange…