Today is the first day of year 2012 – Happy New Year!. This blog post is written by my co-author of SQL Server Interview Questions.
SQL SERVER – Mastering the Basics – Igniting Learning – A Unique Learning Experience
I had very clear idea what my goals were in the book. I believed in unique learning experience. Let us talk about it in today’s blog.
SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT Function – PRINT
A quick trick with the SQL Server 2012 CONCAT function: three SQL experts suggested within minutes that it works with the PRINT statement too.
SQL SERVER – Explain Error:166 : does not allow specifying the database name as a prefix to the object name – Puzzle to Win SQL Server Interview Questions and Answers Book
Why does DROP PROCEDURE with the database name as a prefix give Error 166 when DROP TABLE works? Explain it and win my SQL Server Interview Questions and Answers book.
SQL SERVER – Dedicated Access Control for SQL Server Express Edition – An error occurred while obtaining the dedicated administrator connection (DAC) port.
Connecting to SQL Server Express failed while obtaining the dedicated administrator connection (DAC) port. Here is why it happens and how to fix it.
SQL SERVER – The Difficult Interview Question – Moment of the Life – Day 31 of 31
The last day of my interview series is about the difficult interview question: acing an interview is sometimes about personality and reasoning, not only right answers.
SQL SERVER – Interview Questions and Answers – Guest Post by Jacob Sebastian – Day 30 of 31
SQL Server MVP Jacob Sebastian, author of The Art of XSD, adds his own interview questions and answers to the series in this guest post.