Subscribe to this blog
Archives: September 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…
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…
0 comments, 524 reads
Posted in SQL Tact on 30 September 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.
I got a request from a client to break…
I got a request from a client to break…
1 comments, 670 reads
Posted in SQL Tact on 12 September 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.
While snapshots were set to be cleared out aggressively, a new snapshot on a large database could…
While snapshots were set to be cleared out aggressively, a new snapshot on a large database could…
0 comments, 546 reads
Posted in SQL Tact on 2 September 2011