September 2003 Blog Posts

Versioning Code

Why oh why do some developers not feel the need to version stored procedures ? On a current project I have been watching a developer (who happens to be working on a different project to me) work. He seems like he knows what he is doing, and he is following a bunch of "best practices" like CVS and build tools. However, everytime he works on a stored procedure, it is inside Enterprise Manager!!!!! Why is T-SQL code treated like a second class citizen by so many people ?. It is equally crucial to the workings of the system, and equally easy to...

posted @ Tuesday, September 30, 2003 8:04 PM | Feedback (6)

DTS Debugging

Stephen Forte, fresh from climbing Mount Everest, talks about the perils of debugging DTS packages.

posted @ Tuesday, September 30, 2003 7:51 PM | Feedback (0)

Weblogs 101

It's great to see a bunch of the SQLTeam regulars signed up for a weblog here. I've noticed a couple of posts from people along the lines of "I have no idea what this weblog thing is all about or what I'm supposed to do." So here are a couple of things you might want to know about. (If you already know about this stuff, feel free to ignore this) What is weblogging all about ? The basic definition is a web based journal. This might give you a little bit of history and perspective. Obviously here the idea is to...

posted @ Monday, September 29, 2003 1:48 AM | Feedback (1)


Justin FINALLY got around to learning how to use Codesmith. I have only been trying to get him to do that for 2 months. I have mentioned Codesmith on the forums before as I feel compelled to let everyone know how useful this tool is. It does take a bit of getting used to, but once you have the hang of it you can save hours. For anyone who has NO idea what I am talking about, Codesmith is a template driven code generation tool with the ability to explore your database schema. What that means is you can create templates to...

posted @ Monday, September 29, 2003 12:10 AM | Feedback (2)


Scott Watermasysk, who developed this blog software (.Text) just noticed us. Cool. I'd like to very publicly thank Scott for releasing this software to the community. You rock!

posted @ Sunday, September 28, 2003 11:01 PM | Feedback (0)

Who woulda thought DOS was still useful

I'm working on a project at the moment where I find myself deploying large blocks of code from my laptop to a dev server or the live server on a fairly regular basis. Keeping code in sync was becomming a bit of an issue, I needed a good way to deploy a whole bunch of stored procs from my dev machine to a staging server. I just found out about a small app that does this, which I will review here soon, but the method I've been using is an ultra simple, Unix inspired way of doing things : 1. Drop...

posted @ Sunday, September 28, 2003 8:30 AM | Feedback (2)

Fun with the SPACE function

I'm doing a little bit of ASP maintainance work for the company I'm contracting with at the moment. I had a small task to indent items in a drop down select list in line with their level in a hierarchy tree. Nothing difficult there except that the page used a generic function to draw select lists. The last thing I want to do is reimplent it for this one off case so I decided to do it in SQL. T-SQL Has a function "SPACE(i)" which returns a number of whitespace characters. Once you have that you can replace it with...

posted @ Sunday, September 28, 2003 8:20 AM | Feedback (0)

Hello World

Welcome to the blog bandwagon!

posted @ Thursday, September 25, 2003 9:17 PM | Feedback (0)