Tag Archives: administration

Checking the Instance Fill Factor

Posted on January 3, 2013 by way0utwest

I was reading a post from Paul Randal recently and noted that he recommends not changing the instance’s default fill factor. I agree, and you shouldn’t alter it. However if you aren’t sure if it’s been changed on any of … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Checking the Instance Fill Factor

The Daily Routine

Posted on December 27, 2012 by way0utwest

This editorial was originally published on Mar 10, 2008. It is being re-run as Steve is on holiday. If you work in an operational area, especially if you’re a DBA, you typically have a fairly tedious routine. You definitely have … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on The Daily Routine

Building a Full Text Index

Posted on December 19, 2012 by way0utwest

I hadn’t used full-text indexing in production throughout my career. We hadn’t had the need in the applications I worked on, all of them depending on LIKE searches in specific, normalized data. However I have always been interested in it … Continue reading →

Posted in Blog | Tagged , , , | 3 Comments

Test Your Restores

Posted on December 11, 2012 by way0utwest

I was talking with someone the other night about their database systems and they mentioned they had implemented TDE (Transparent Data Encryption) to comply with HIPAA regulations. This person had verified that they were backing up the Database Encryption Key, … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on Test Your Restores