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...

Red Gate SQL Response Review is up

Full Disclosure: I did receive a trial version of the software and payment for the review. I am also a...

Take the Plunge - 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...

Tethering vs Air Card & Other Miscellaneous Phone Thoughts

I've been using a Blackberry Curve for a while and I'm been entirely happy with it. Great phone, great battery...

Always more to do

 My current "to do" list, which is only partially written down and organized. Putting it all one one list is...

Can't Attend SQL Server Training in Person, Consider Virtual Training

I am one of the biggest advocates there is of self-education. Whether you are a novice, intermediate, or expert-level DBA,...

Database Administration Librarian

If I cannot find a book or info in a library, I always go to a librarian for advice and...

Do You Love PASS?

Recently Tony Davis posted some thoughts (almost a rant) about his opinions of PASS, and there is a great follow...

Rendering code nicely in blogs and forums.

 I wrote the prettifier specifically to help with posting SQL into blogs and forums. You can find it here http://extras.sqlservercentral.com/prettifier/prettifier.aspx...

The Best Database Engine - 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...