pointers, solutions and scripts for the SQL DBA
not intended to replace common sense

9/30/2011

New website, exciting future for BRSSUG

Just wanted to push out an announcement that the Baton Rouge SQL Server User Group has a new website.

www.brssug.org

We've got a great few months ahead of us with our buddies at the BR .net User Group!

October's meeting is on the topic of Change Data Capture (CDC) as a real-world replacement for transactional replication, presented by one of my colleagues Matt Maddox from Lamar Advertising.  November will feature Microsoft's own Patrick Leblanc talking about one of the many new features of SQL Denali.  December's meeting will be replaced by a User Group social.  In January, I'm very excited to host Devlin Liles, who will speak to the joint audience of BRSSUG and BRDNUG.

BRSSUG is coming off a 20-person meeting and a very applied, original talk on Data Mining in SQL Analysis Services by Sona Pal, a recent graduate of LSU.  We're definitely on the upswing!

9/12/2011

Striped backups in SQL Server

Some DBA's don't realize that SQL server can perform a database backup that breaks up the files - stripes them - in a single command.  SQL can stripe the backup into an unlimited number of files, creating a multi-file backup set.

9/02/2011

Moving the SQL replication snapshot folder

I recently addressed an issue where a client server's data volume was getting dangerously tight on free space.  It contained data files (.mdf's) as well as the replication snapshot folder, which hosted dozens of publications.