Tag Archives: sql server

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

The Load Poll

Posted on December 21, 2012 by way0utwest

I was taking to someone recently and this person had a large transaction load on their SQL Server. At least, I thought it was a large load. This person said they experienced 1000tps most of the time and this made … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Load Poll

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

The Principle of Least Privilege

Posted on December 17, 2012 by way0utwest

One of the tenets of good security is that no person or process is granted more rights than it needs to accomplish a task. This is the Principle of Least Privilege, and is designed to ensure that your system is … Continue reading →

Posted in Blog | Tagged , , , | 6 Comments