SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Archives: December 2012

Full-Text Search – Stoplists in SQL Server

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

4 comments, 6,510 reads

Posted in The Voice of the DBA on 31 December 2012

I Pulled a Forest Gump

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

2 comments, 1,777 reads

Posted in The Voice of the DBA on 27 December 2012

Predictions for 2013

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

2 comments, 976 reads

Posted in The Voice of the DBA on 27 December 2012

Recharging Again

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

1 comments, 912 reads

Posted in The Voice of the DBA on 21 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 and as I try to find data more often in… Read more

3 comments, 3,504 reads

Posted in The Voice of the DBA on 19 December 2012

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

For a… Read more

6 comments, 3,375 reads

Posted in The Voice of the DBA on 17 December 2012

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

0 comments, 952 reads

Posted in The Voice of the DBA on 17 December 2012

The First Event of 2013 – SQL Saturday #183 – Albuquerque

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

0 comments, 876 reads

Posted in The Voice of the DBA on 14 December 2012

You Need to Manage Passwords

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

9 comments, 2,727 reads

Posted in The Voice of the DBA on 12 December 2012

T-SQL Tuesday #37 – A Month of Joins

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

1 comments, 1,481 reads

Posted in The Voice of the DBA on 11 December 2012

T-SQL Tuesday Topics

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

1 comments, 1,580 reads

Posted in The Voice of the DBA on 10 December 2012

Speaking at Oracle Training Days

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

1 comments, 1,054 reads

Posted in The Voice of the DBA on 3 December 2012