Setting an AlwaysOn Secondary Database Owner to SA

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

Generating A Simple Markdown Readme From Powershell Comments

Some of the powershell functions and modules I write don't warrant elaborate commenting. I've started using a standard commenting template and rather than re-do that commenting in markdown, I eventually wrote a simple script to generate markdown out of powershell comments. I work in an environment that uses a central git repository so simple generation… Continue reading Generating A Simple Markdown Readme From Powershell Comments