It is a problem to provide enough data for database development work, especially when it has to be managed, and has to comply with the conditions for using live data. Added to that are the constraints of disk space and the problem of providing risk-free deployment. Grant explains how three Red Gate tools and work together to provide a neat solution to providing the ideal sandbox development environment.… Read more
Just occasionally, a user's mistake can make far more demands on a DBA than just a simple point-in-time restore. When things get complicated, and you have to work in a hurry, then that's when SQL Virtual Restore and SQL Data Compare can work together to save the day.
… Read more
With a large-scale development of a database application, the task of supporting a large number of development and test databases, keeping them up to date with different builds can soon become ridiculously complex and costly. Grant Fritchey demonstrates a novel solution that can reduce the storage requirements enormously, and allow individual developers to work on their own version, using a full set of data.
… Read more
In the first of a series of in-depth software reviews, Brad investigates a newcomer, SQL Virtual Restore. What does it aim to do? How does it achieve it? Why is it safe to use? What are the benefits? Brad aims to answer a range of questions fairly and squarely.… Read more