Monthly Archives: September 2013

Common Problems with Backup and Recovery and How to Handle Them

Posted on September 30, 2013 by

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

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

Posted on September 27, 2013 by

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

Posted on September 27, 2013 by

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

Posted on September 27, 2013 by

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

Posted on September 27, 2013 by

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

Posted on September 26, 2013 by

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

Posted on September 25, 2013 by

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

Posted on September 24, 2013 by

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

Posted on September 24, 2013 by

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