The default instance uses port 1433, but what about a second instance on the same box? Here is how to find the port SQL Server is listening on.
SQL SERVER – How to Validate Syntax and Not Execute Statement – An Unexplored Debugging Tip
Want to validate syntax without running a query? I explain the little known SET NOEXEC setting that checks your T-SQL but does not execute it.
SQL SERVER – Interview Questions and Answers Sample Chapter Free Download – SQL in Sixty Seconds #050
SQL in Sixty Seconds hits its 50th episode and a full hour of play time. To celebrate, get a free SQL Server Interview Questions and Answers sample chapter.
SQL SERVER – Tricky Question – What is the Default Size of the Database
What is the default size of the database in SQL Server? Many guess 3 MB or 4 MB, but the real answer depends on the model system database.
SQL Server Questions and Answers: The Movie My Grandma Asked For
SQL Server Questions and Answers began as a book I carried to my grandma for blessings. One question from Grandma, “when will this book become a movie?”, turned into a video course eighty days later.
SQLAuthority News – Interview with Book Authors after 2 Months of Book Released
Sanjay Shetty and Raj Chaudhuri of INETA APAC did an interview with book authors Vinod Kumar and me, two months after our interview book came out.
SQL SERVER – Interview Questions and Answers – Perspectives of an Author
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.