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.

NOTE: I haven't used SSIS for years. I'm rusty, so feel free to speak gently to me.I've got an Excel sheet put together by business analysts that has very de-normalized data. I need to go through ...

Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro!