Jess Pomfret
Jess Pomfret
Hey @potatoqualitee - I would love to, a little swamped with Grillen & PSConfEU at the moment, but I'll chat with Sander and see what we can do :)
What should AG's be set up under? We currently test database ownership is sa I thought, was thinking would be the same here.
The problem is when it's NULL the fix is to drop and recreate the AG, would be cool if we could catch it before then.
So looks like the config for the database has both validdbowner and invaliddbowner set to sa to begin with. I can create validhadrowner and invalidhadrowner configs and base tests off...
This test hasn't been created/included yet. Not sure on whether you want to leave it open until it is?
I think the only way to find views that should have indexes on would be a specific tag as a comment, you could have 'with schemabinding' on a view that...
Since the comment would need to be added to view source code for the check to work it would out of the box it wouldn't do anything, that would be...
@SQLDBAWithABeard do you think we need to add a new check file for this and other object level tests? Objects.Tests.Ps1?
No good reason, just wasn't sure on if it made sense to break it out.
I like the idea of confirming it notifies somehow, and then maybe also matches config value if set? I'd also argue that the eventlog isn't a great notification method, I...