Full-text search is an interesting subsystem in SQL Server. It allows you to implement searches through a variety of text formats stored in SQL Server. This is a one of a series of posts that looks at different facets of full-text search.

What is a Stoplist?

A stoplist is a… Read more

Last Friday I went for a quick run before we packed up and headed to Steamboat Springs for a week’s vacation skiing with the family. Saturday I snowboarded, came back to the condo, found no treadmill, slippery, icy conditions on the roads, and just stopped running.

No fanfare, no complaints,… Read more

I’m on holiday, but I have a set of predictions for 2013 coming on Jan 1. This is a little notice in hopes that a few of you might join in to the meme and make a few predictions for 2013.

Database related, technology related, car related, write a few… Read more

I’m off again, taking a week in Steamboat Springs with my family for the Christmas holiday. We’re spending a week up there, including my oldest son who came back from Seattle to see us.

It seems like I’ve been gone a lot, with guest editorials and re-publishing old pieces in… Read more

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 and as I try to find data more often in… Read more

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 as secure, stable, and predictable as possible.

For a… Read more

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, or some lower cost events is because of the marketing… Read more

I’ll be delivering the Modern Resume presentation at SQL Saturday #183 in Albuquerque, NM on February 9, 2013. I got my acceptance today and replied that I’ll be there.

This is the first SQL Saturday in New Mexico, which is a little exciting. I’ve been there a few times since… Read more

I saw a note this week from CNet about a system built to crack passwords (also on ArsTechnica). It reminded me of the story of the guy that cracked Googles DKIM key at 512bits. Not insignificant, until you get to the point of renting that power from AWS for… Read more

It’s time once again for T-SQL Tuesday, and this month is hosted by SQLity.net, Sebastian Meine.

If you want to know more or participate, read the invitation and write your own blog post.

The topic this month is joins, in honor of Sebastian’s a-join-a-day series. He’s writing about… Read more

An Updated list of all the topics.

I was looking for a static list of all the T-SQL Tuesday topics and couldn’t find one. The domain moves around to the current hosting blog, so when it was my turn to host it, I made a list just so I could… Read more

A first for me. I’m attending a non-SQL Server event, trying to bring a little knowledge of my platform to those that typically work on the Oracle side of things.

The Rocky Mountain Oracle Users Group is holding their Training Days 2013 event on Feb 11-13 in Denver and a… Read more