Thanks Daniel.   I'm thinking of partitioning to manage data more so than performance for very large fact tables.  Although as you say performance increase is secondary.  With large tables even...

Thanks for comments - partitioning is the way to go with snapshots.

Wouldn't be better to pull the data of the ring buffer?

Hi
Thanks for the link.   In the end I ended using the script from here and used the QueryBegin event. Exporting XEL file to CSV (manual).   I then wrote a...

Nice to have Microsoft manage the restoration - we shouldn't forget we can get downtime for on-premise servers too.

I need something a bit better than SSMS database diagrams in this case.

I created a test role and it seems to work as expected.   One other setting I had to make was set properties for measure group property (for unrelated measures)
IgnoreUnrelatedDimensions...

Thanks.  We will evaluate source control with DLM scripts.

I should add that we snapshot production db to dev to keep data fresh.  Using SAN tools make it quick for multi tb dw 🙂  and we're using the Powershell...

Yep - we're learning about capability for tools to migrate changes.  Latest problem we had was pushing a change to a column constraint.
We're able to overcome issues but seeing...

Hi
I got it working my making .Net registry changes on the client  (referenced on the MSDN page above). I had already made the IE changes to remove TLS1.0/TLS 1.1. ...

Thanks for the input I'll stick with suggestion for persisted column.

Thanks for sharing links. Will make for some interesting reading.

I'm thinking the only practical thing to do is to run the 2nd lookup with highly optimised SQL targeted target at NULLS i.e. filtered index for null for the late...

Hi Tim,

Been through all this.  I do agree with you that it's authentication related.  We get the same error when using the same account that the package was...