I am getting errors in T-SQL query... Conversion failed when converting datetime from character string. SELECT roA_tblUser.Email as Email FROM roA_tblUser UNION SELECT roA_tblUserAccount ...

Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works.

Use SqlServerCmdletSnapin100 (installed when you install the SQL Server client tools, 2008 or newer (maybe 2005)) and it gets a lot easier.