Question : How do you notify third parties of future SQL Server schema changes other than through external documentation? I’ve […]
Tag: change-management
Changing the SQL Server service account – any additional considerations?
Question : I have inherited a few instances that are running under LocalSystem. I need to change this to a […]
Changing the SQL Server service account – any additional considerations?
Question : I have inherited a few instances that are running under LocalSystem. I need to change this to a […]
How to transfer DDL changes between different stages?
Question : What technical solutions are available to track DDL changes and transfer them between different stages (e.g. DEV -> […]
Storing Changes To Records
Question : Everything I am talking about relate to relational database, specific MySQL. I have a number of tables in […]
When using a master plus multiple slaves, how do I change over from one server to a brand new one with minimal downtime?
Question : In my particular case, I’m using Heroku Postgres (repackaged Amazon EC2 instances running PostgreSQL), but platform-agnostic answers are […]
Handling SQL updates for production deployments
Question : I’m researching for quite a long time now (about two months) and haven’t found a good approach for […]
How to test mysql for changes
Question : I’m OCD person, I think I accidentally dropped something in my mysql. Problem is I’ve around 50 databases, […]