Azure Search and SQL Server integration
Integrating SQL Server (Azure and on-prem) with Azure Search. A search in table/column that is Azure Search enabled would fall into a Azure Search query in the background, not visual for the developer.
Only Azure Search enabled columns and tables would be handled by Azure Search and it would not be visible for the database consumer.
Only a Azure Search Package that is installed on a on-prem machine that would enable the DBA to define which tables or columns that should be Azure Search enabled. Database triggers for SELECT, INSERT, UPDATE and DELETE would translate into Azure Search REST based actions not visible for the developer.
The millions or billions of SQL Server Databases would be able to incorporate a stunning performance increase without changing the old legacy code for the consumers of the database. This could have a huge impact on the roll-out of such a feature since the SQL server installation base today is massive in Enterprises today and even better, it is growing.
Azure Search now supports automatically indexing data in Azure SQL Databases and SQL Server in Azure VMs. For more details, see http://azure.microsoft.com/en-us/documentation/articles/search-howto-connecting-azure-sql-database-to-azure-search-using-indexers-2015-02-28/