Mirroring or Eventhouse?
A team I was talking with recently had a familiar mid-market reporting problem. Their nightly refresh took eight hours. The data lived in on-premises SQL Server, stitched together with linked servers, and almost none of the tables had indexes. Reports were stale by the time anyone opened them, and if a job failed overnight, they were stale for a full day. They wanted to move to Fabric and build semantic models on top. The first question on the table was whether to connect the linked server to Eventhouse…
Read more
