Has your table become too large to handle? Have you thought about chopping it up into smaller pieces that are easier to query and maintain? What if it's in constant use?
Read more...
You have a huge table, and it is necessary to change a column's data type, but your database has to keep running with no downtime. What do you do? Here's one way to perform this change, in as unobtrusive a manner as possible while your table keeps serving users, by avoiding long DDL table locks and leveraging procedural transaction control.
Read more...
Sometimes skipping an update or two for a library means that we can trigger unexpected breakages in other software that are very hard to troubleshoot.
Read more...
/ blog
