Back to 400

I had to research a bit, write some code, and look up things to answer questions this morning. I must...

Data Farming - Why Did I Write This?

I grew up in the Cold War, with real concern that the Russians would attack us someday. I wanted to...

SQL Server MVP

Can't say I ever expected to say this, but as of October 1st I'm a SQL Server MVP. A nice...

SQL Saturday in Olympia , WA Pulls in Crowd of over 130 DBAs and Developers

A SQL Saturday event was held Saturday, October 11, 2008 in Olympia, WA. Sponsored by the Olympia Area SQL Server...

One File Per Core?

For a long time in my career I heard various advice on how many files you should create for a...

Database Health - Why Did I Write This?

Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...

Do You Understand Microsoft Licenses?

I had an email from a friend recently asking about a licensing question pertaining to Microsoft. It reminded me of...

Tulsa TechFest Draws a Crowd of Over 500

The annual Tulsa TechFest (Tulsa, OK) had over 500 attendees today (Thursday), and is expecting another 500+ attendees on Friday....

Meeting My Goal

Last year I was talking about goals and changes for the site as I was negotiating my continued employment with...

Validating text data. A few techniques.

/*datafile used in the SQL  */

DECLARE @String VARCHAR(MAX)
SELECT  @String = 'When you are starting out to validate text input, perhaps to clean...