I am looking for a way on T-SQL to be able to query all the shards at same time.

It looks like Sitecore is using a ShardManager that is used on code, which makes sense for them. But I used SQL a lot to create custom queries to find and validate Sitecore xDB data.

We keep our SQL in Azure, so I am looking into elastic queries. But it seems like a lot of lifting to get there. https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-query-horizontal-partitioning

  • Can you use the search index instead? It collects everything together into a single repository. I'm assuming you are avoiding xConnect Search API for a reason? – Jason St-Cyr May 4 at 13:30
  • xConnect search and the index will not search on the absence of data, like email etc.. So I go right at SQL and get what I need. This is usually just for research and bug issues. – Chris Auer May 4 at 13:37
  • 1
    The main problem you're going to hit is that you can't bridge multiple databases in Azure SQL due to the security implementation. So a normal union isn't going to work. You need to plumb in an object called an External Table or an External Data Source. Check this guide: techcommunity.microsoft.com/t5/azure-database-support-blog/… – Richard Hauer May 5 at 10:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.