Lesson Learned #56: External tables and performance issues

Hello Team, Recently I closed a service request that had the following question Our customer created external tables to perform SQL Query across Azure SQL Database. We suggested to use Azure SQL Managed Instance (because there is not needed to use external tables to access to other databases using the same connection) in order to…


Lesson Learned #9: sp_execute_fanout was deprecated and replaced by sp_execute_remote

Within Cross-Database Queries we have the option to run a procedure using parameters using sp_execute_fanout. This execution could be a Transact-SQL statement on a single remote Azure SQL Database or set of databases serving as shards in a horizontal partitioning scheme. From time ago, if you try to execute sp_execute_fanout you will have an error that this…