SQL Server 2008 Interview Questions and Answers Part 4: which command shows the version of SQL server and operating system, what SQL Server Agent is, and more.
SQL SERVER – 2008 – Interview Questions and Answers Part 3
SQL Server 2008 Interview Questions and Answers Part 3: which TCP/IP port SQL Server uses, and the difference between a clustered and non-clustered index.
SQL SERVER – Interview Questions and Answers – Part 2
This is the second part of the blog post series Interview Questions and Answers.Click here to get free chapters (PDF) in the mailbox
SQL SERVER – 2008 Interview Questions and Answers – Part 1
Part 1 of my SQL Server 2008 interview questions and answers covers general questions like what is RDBMS and the properties of relational tables.
SQLAuthority News – 700 Articles and Author Updates
The blog has reached 700 articles. Here is why I write, plus updates since article 600: the SQL Server MVP award, user group work and 4 million visitors.
IN With NULL: Show the Unknown Comparison
IN with NULL can produce UNKNOWN instead of false. Compare a positive match, an unmatched value and a missing input without hiding the truth state.
SQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name
Why does SharePoint stop working after you rename the SQL Server? The old name is still inside SQL Server. How to fix it, and what else holds it.