Monthly Archives: December 2012

Building a Full Text Index

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

Those Who Can, Do

There was a time I considered staying in college, getting a masters or PhD and teaching others. I still might follow that path at some point since I enjoy speaking and teaching others how to better work with SQL Server. At some … Continue reading

Posted in Editorial | Tagged , , | 3 Comments

The Principle of Least Privilege

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

Annual Email Pruning

Like most of us, I get a lot of email. I get subscribed to various services from different ads, events, etc. throughout the year. That’s fine. I understand how marketing works, and the reason that I get some free services, … Continue reading

Posted in Blog | Tagged , | Comments Off on Annual Email Pruning