Monthly Archives: July 2011

Striping Backups in SQL Backup Pro

Posted on July 11, 2011 by way0utwest

There are times you really do want to stripe backups across multiple files. If you have a short backup window, or a large data set, if you can write the backup to multiple files at the same time, you can … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Striping Backups in SQL Backup Pro

Lesson #6: What CIOs Really Care About

Posted on July 11, 2011 by way0utwest

I saw a blog by Dave Rosenberg and it was interesting in a few ways. First of all, Dave works for OSDL, which promotes the use of open source software. There were a number of basic things that you could … Continue reading →

Posted in Editorial | Tagged | Comments Off on Lesson #6: What CIOs Really Care About

Self-aware Instances

Posted on July 8, 2011 by way0utwest

I’ve been seeing lots of monitoring solutions written up lately. I saw this blog from Phil Darmanin on SQLServerCentral and we have had numerous articles written over the years on building monitoring solutions. The build vs. buy debate is one that companies regularly have, and if … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Self-aware Instances

The IF Statement in a T-SQL Query

Posted on July 7, 2011 by way0utwest

I’ve seen quite a few posts from people asking how to do something like this: SELECT a.ID , IF a.MyChar = ‘A’ THEN ‘Success’ ELSE ‘Fail’ FROM MyTable a Of course, that doesn’t work in T-SQL, and you’ll get something … Continue reading →

Posted in Blog | Tagged , | Comments Off on The IF Statement in a T-SQL Query