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.
SQL SERVER – Interview Questions and Answers – Guest Post by Feodor Georgiev – Day 29 of 31
Feodor Georgiev’s guest post in my interview questions and answers series is part 2 of his take on job interviewing the right way and for the right reasons.