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

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 ,

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 , ,

Team-based Database Development with Version Control

An efficient development process requires that all of your team members coordinate their efforts. This session shows how a version control system (VCS) and standard development practices help improve the speed and quality of your development process. This talk will … Continue reading

Posted in Presentations | Tagged , ,

Filestream needs MAX

I wrote today’s Question of the Day for SQLServerCentral on Filestream. I asked which data type was needed for Filestream data, and gave a few choices. Someone pointed out that I wasn’t complete in my choices, and that was by … Continue reading

Posted in Blog | Tagged

Scripting

One of the directions in which Red Gate Software is to build more tools and utilities that all of you can use for working in cloud environments. We aren’t ignoring the desktop tools like SQL Compare and Prompt (v6, yeah!) that you’ve come to appreciate and depend … Continue reading

Posted in Editorial | Tagged , , ,

It Happens

Your code is wrong. Or it’s bad, or it won’t work as intended. I’m not sure that’s the viewpoint I’d like to take when I first start working on a project, but that’s what Nathan Marz told the attendees at the … Continue reading

Posted in Editorial | Tagged

The Human Cost of Managing Data

If you’ve ever worked in a large environment, where the numbers of nodes number in the thousands, or tens of thousands, then you know many software packages don’t scale to that size very well. I’ve seen quite a few pieces … Continue reading

Posted in Editorial | Tagged ,

An easy travel week for SQL in the City and SQL Saturday #190

This week I have two more events in my busy fall schedule: a SQL in the City Seminar on development and SQL Saturday #190. However my travel plans are limited to getting in my car and driving from the ranch … Continue reading

Posted in Blog | Tagged , , ,