Can't you make the resultsets "look" the same and bundle them into one resultset?

You could add a column "ResultSetNumber" and split it in your dataflow...

The "almost" the same database...

I agree that cursors are not always bad but we ban them because it's safer as we have different levels of expertise in house...

OK, I just wondered whether there would...

Thanks for these feedback, it's really interesting.

We do have Entreprise edition on our main server but it would be nice to stick to Standard edition for the "read only" servers.

Looks...

I must admit I came across CDC before and it might be a viable option too.

I don't have any experience of it though...

Has it got a reputation for reliability? I...

You are not selling that one too well!!! :crying:

Let's hope that Log shipping does the trick for our users (I set up a test and it seemed so easy)

I tend not to like that one because I find it too complicated and sometimes looking like a black art.

I have not seen installations running smoothly without an "expert" lurking...

Might be what we need...

If I understand properly, the Secondary databases are available for reading but not during restores...

Could you point me to where I can find best practices for...

Thank you so much.

This is really interesting.

I did indeed wonder whether the lack of structure was something desirable. Your "it depends" answer is very valuable to me and quite relevant...

Thanks

It's very useful 🙂

On the NoSQL side... Why using NoSQL?

Is it because of the type of data you hold, or because of volume?

I think remembering that "Big Data" is caracterised...

I did not think about that! Why not...

Thx

Interesting.

Thanks for sharing the answer 🙂

Hi there!

This was a long time ago (for my weak memory anyway) but reading through my own posts, I only cured this by not reloading the database that was provoking...

The more I look at this, the more I think the smartest answer might be to move completely our database to the cloud.

Then I would not need replication... :satisfied: but...