Lessons of the Trade : Purging Databases
We ran into an interesting issue at work recently. Documenting the solution for my records.. BACKGROUND : We had a table in one of our databases...
Databases
HOW TO : Pass environment variables when using sudo
Say you need to sudo as a particular user and run a command and at the same time you need to pass an environmental variable to...
Lessons of the trade : Troubleshooting database perfromance
If you have ever worked in an IT shop, you will know that the one thing you cannot escape from is issues related to Database performance....
Lessons of the trade : Data purge in databases..
Quick note to myself.. If you have a high volume transactional database and are looking to purge data from a table(s).. make sure you purge the...