Any alternative to Azure Elastic Query

  • nunopedrosilva

    Grasshopper

    Points: 22

    Hi,

    Today I went exploring the Azure Elastic Query, but I find the solution MS is giving, too much off an hassle, when we're talking about databases with dozens of queries. Of course our system doesn't need to use that much of cross database queries, but having an additional "external table" setup, creates a dependency for us, that we don't like to have to have it. Also the fact that it still doesn't support AD users, makes us not really like this a even more.

    So I was thinking, do you guys know any kind of alternative to this, when we're talking about Azure SQL?

    Thanks,
    Nuno

  • Grant Fritchey

    SSC Guru

    Points: 395316

    Nope.

    The only current "alternative" is to go to a Managed Instance. These allow for traditional three part naming to do cross database queries.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • nunopedrosilva

    Grasshopper

    Points: 22

    Thanks for the reply.

    I'm actually exploring it. Having some login issues using Azure AD, but I have a ticket open in Microsoft.

    Thanks again!

  • Grant Fritchey

    SSC Guru

    Points: 395316

    nunopedrosilva - Wednesday, January 30, 2019 4:40 AM

    Thanks for the reply.

    I'm actually exploring it. Having some login issues using Azure AD, but I have a ticket open in Microsoft.

    Thanks again!

    Happy to help. I'd also offer to help with Managed Instances, but I haven't been able to touch one for over a year, so my knowledge is very limited.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply