I've spent some time in a couple AlwaysOn shops and if you don't manage it well, you can quickly accumulate secondary databases that are owned by DBA accounts. Naturally, secondaries are read-only so you can't simply change the owner to SA. One option is to fail over the AG and change the database owner but… Continue reading Setting an AlwaysOn Secondary Database Owner to SA
When I inherit an unruly SSRS environment (and they're all unruly) I want to answer a few questions: What users are running reports? What reports are being executed? The ReportServer database is very easy to understand but a majority of the queries I run hit the ExecutionLog table, or one of the ExecutionLog views. Microsoft… Continue reading Who Is Using SSRS?
Creating a mirroring endpoint in SQL Server can sometimes do goofy things with permissions. I'm facing an issue right now where two bad things are happening when one of our DBAs creates an endpoint: The creator's account becomes the owner of the endpoint, which is not un-common in SQL Server. However, like other ownerships, this… Continue reading Mirroring Endpoint Ownership