Post image

Why You Need A Test Environment

In 2017, there’s no excuse not to have at least a testing environment, and preferably a development environment as well, in order to create and deploy code changes (software, database, you name it) outside of a production environment. If you’re making changes in a production environment without testing them first, you’re doing it wrong. Some
-> Continue reading Why You Need A Test Environment

Post image

Something something Production something something you idiot

You’re reading this series of posts because you want to learn about databases and how to use them. What you should not be doing is learning about databases and how to use them, while working inside a production environment. Also called “prod”, because we’re lazy, this server (or servers) is not meant for testing things out.
-> Continue reading Something something Production something something you idiot

Post image

Do you need access to Production?

During a recent client meeting about a database migration, I realised that I have never logged into a SQL Server on their production environment. My involvement has been strictly dealing with setting up the new environment and log shipping the backups. I get that I’m not a full-service DBA for this client, but it got
-> Continue reading Do you need access to Production?