Tag Archives: sql server

Powershell – Copy the Latest Backup

Posted on December 29, 2014 by way0utwest

I got an email recently where someone asked me how they can refresh a dev environment with Powershell. I guess I’d written something about this in 2009, though that would have been for testing as Red Gate had already banned … Continue reading →

Posted in Blog | Tagged , , , , | 5 Comments

SQL Server Disk Space Emergencies

Posted on December 8, 2014 by way0utwest

One of the things I’ll see happen often with SQL Server instances is that the system will run out of space on a drive. This could be for a variety of reasons, some of which can be prevented, and some … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on SQL Server Disk Space Emergencies

Consolidating Again and Again and Again

Posted on November 25, 2014 by way0utwest

This editorial was originally published on November 12, 2009. It is being re-run as Steve is on holiday.  In reading about virtualization, one of the main things that drives its acceptance is cost. It’s the reduction in actual physical resources … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Consolidating Again and Again and Again

How Often Does Production Drift?

Posted on November 24, 2014 by way0utwest

One of the new products that Red Gate Software is working on is SQL Lighthouse, which is designed to track and alert you on “database drift“, which are the changes in your schema. I hadn’t really heard the concept in the past, though … Continue reading →

Posted in Editorial | Tagged , , , , | Comments Off on How Often Does Production Drift?