Monthly Archives: January 2013

Message Queues in Software

Posted on January 16, 2013 by way0utwest

I had high hopes for Service Broker when it was introduced in SQL Server 2005, but it doesn’t seem that many people have bothered to architect their applications to take advantage of it. I do see some people starting to use it, … Continue reading →

Posted in Editorial | Tagged , | 2 Comments

Regression Testing before CUs and Service Packs

Posted on January 15, 2013 by way0utwest

Someone asked me on Twitter recently if I ran full regression tests before applying Cumulative Updates (CUs). I decided it wasn’t worth discussing in 140 character chunks, so I decided to jot a few notes down. I’ll also expand this … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Regression Testing before CUs and Service Packs

Cramming for Interviews

Posted on January 15, 2013 by way0utwest

On SQLServerCentral, there are a lot of common questions that I see asked over and over. Perhaps the most common is the “why is my transaction log so large it filled my disk” question, which seems to occur constantly (C’mon, … Continue reading →

Posted in Editorial | Tagged , | 4 Comments

Full-Text Search – Word Breakers and Stemmers

Posted on January 14, 2013 by way0utwest

There are numerous components to the Full-Text Search (FTS) subsystem in SQL Server that help provide efficient, relative answers to queries. Full-text Search is a little complex, and as I’ve been working with the system in an effort to learn … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Full-Text Search – Word Breakers and Stemmers