Monthly Archives: September 2013

Common Problems with Backup and Recovery and How to Handle Them

Posted on September 30, 2013 by way0utwest

The basic concepts behind taking a backup are well understood, but people are frequently surprised by the many ways backups can go wrong. First, we’ll explore the most common problems around SQL Server backup and recovery, so that you can … Continue reading →

Posted in Presentations | Tagged , | 1 Comment

Hybrid Databases

Posted on September 30, 2013 by way0utwest

SQL Server already handles hybrid data. We are dealing with more and more data all the time, and in more and more formats. As noted in this piece, companies are receiving data in new formats, from a variety of sources, and … Continue reading →

Posted in Editorial | Tagged | Comments Off on Hybrid Databases

Best Practices for Database Deployment

Posted on September 27, 2013 by way0utwest

The easiest part of any deployment is running the deployment script on production. But what have you done to prepare that script for production? Was the script tested? Is the script tightly coupled with the application code? The difference between … Continue reading →

Posted in Presentations | Tagged , | Comments Off on Best Practices for Database Deployment

Automated Build and Test

Posted on September 27, 2013 by way0utwest

Continuous Integration (CI) is a well known process in the software development world, but it’s not often implemented with databases. This is despite the fact that database code could benefit from the practice of checking the changes on a regular … Continue reading →

Posted in Presentations | Tagged , , | Comments Off on Automated Build and Test