.S0 { color: #808080; } .S2 { font-family: monospace; color: #007F00; font-size: 9pt; } .S5 { font-weight: bold; color: #00007F; } .S10 { font-weight: bold; color: #000000; } .S15 { font-family: monospace; color: #3F703F; font-size: 9pt; } span { font-family: monospace; font-size: 10pt; } I was listening to the Brian Noyes episode of DotNetRocks today and one of his recommended essential tools was QuickCode.Net, a Visual Studio addin for code expansion. Essentially, this works like a macro that pastes in simple code templates based on a pattern. Make sense ? No, I didn't think so. One of the default templates looks for a pattern like prop [datatype] [propertyname] and expands it to a...

posted @ Wednesday, February 25, 2004 7:49 AM | Feedback (3)

SQL Server Web Administrator

Microsoft have released the SQL Server Web Data Administrator. A web intrerface to managing your datbases, users, stored procedures and for running ad-hoc queries. via Mike Gunderloy

posted @ Wednesday, February 18, 2004 5:17 PM | Feedback (2)

More on CodeSmith

A good article at AspAlliance on using CodeSmith for generating database documentation.

posted @ Monday, December 08, 2003 7:38 PM | Feedback (0)

This article brought to you by....

I just published a new article on SQLTeam titled "Using the PARSENAME function to split delimited data". I've already had a few comments from people about the code coloring in the article. Not being one to shy away from plugging utilities and tools that I think rock, I thought I'd let everyone in on the trick. I use SciTE. SciTE is a lightweight text editor for Windows and Linux. It's small and fast and has pretty much become a notepad replacement for me ( although compiler integration makes it some peoples primary code editor). One of it's really cool features is...

posted @ Monday, November 10, 2003 8:35 AM | Feedback (2)

Run CLR code inside a stored procedure!

When Yukon comes we can all do this (for better or for worse). Until then, here is an extended stored proc that acts as a CLR bridge. Get it at

posted @ Tuesday, October 14, 2003 2:11 AM | Feedback (0)

Version Controlled SQL Tools

Sean Price asks in my comments about the existance of SQL development tools that integrate with source control tools. He also points out that you can use Visual Studio, I really don't like that way Visual Studio implements this as you still aren't getting a script generated for the objects you have developed. The best candidate I found a while back was Rapid SQL from Embarcadero. It generated scripts for all your procs, and checked them into VSS. Then when you did work, you worked inside the script and it deployed the code. It was all pretty seamless. It's not cheap...

posted @ Thursday, October 02, 2003 7:58 PM | Feedback (7)


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)