Setting up an availability group, a client hit an AlwaysOn Wizard Error: an endpoint uses only Windows Authentication. Here is why and how we got past it.
How to Assign Multiple Variables in a Single T-SQL Query? – Interview Question of the Week #148
How do you assign Multiple Variables in a single T-SQL query? Here are three ways, from separate SET statements to my preferred one-line style.
How to Validate Email Address in SQL Server? – Interview Question of the Week #147
How do you validate an Email Address in SQL Server? Here is a simple query that separates valid addresses from invalid ones in a sample table.
What is WorkTable in SQL Server? – Interview Question of the Week #146
What is a WorkTable in SQL Server? Run a simple CROSS JOIN with STATISTICS IO on and you will see one. Here is what it is and why SQL Server creates it.







