What is the difference between latches and locks? Latches guard a page only during the physical operation, while locks last for the whole transaction.
SQL SERVER – Find Port SQL Server is Listening – Port SQL Server is Running
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. Grandma’s question about a movie inspired a video course.
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.