Monthly Archives: September 2013

Common Problems with Backup and Recovery and How to Handle Them

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

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

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

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