So, is it possible to go from Enterprise to Developer in an AlwaysOn cluster? TLDR: Yes. I was working in a dev environment recently that had been setup with AlwaysOn Availability Groups using the Enterprise Edition of SQL Server 2016. This environment is completely devoted to development of our applications which means it qualifies for… Continue reading Rolling Downgrade From Enterprise to Developer
In March I did my first presentation at SQL Saturday. I'd say it went very well and I was very encouraged with the attendee feedback. My presentation was on infrastructure testing with the Pester Powershell module. I didn't go into depth on the advanced features of Pester (ie. mocking) but instead focused on how you… Continue reading Pester Your SQL Servers!
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
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