Damian Maclennan Blog

Damian's Datalog

EQL : Emotional Query Language

Server: Msg 2812123, Level 12, State 123, Line 1 You forgot the magic word 'PLEASE'. Nice. Legacy Comments alaa 2005-08-18 re: EQL : Emotional Query Language thank u Read more →

TPC Benchmarks

News just in that HP have topped the TPC transaction benchmark with an Oracle database. Anyone have a spare TERRABYTE or RAM they can lend me ? Read more →

ASP.NET Database Cache Invalidation

Rob Howard talks about the new database cache features in ASP.NET 2.0. Currently one of the downsides of caching data is that your cache doesn't know if the data has changed. Read more →

SQL Server Tips at Microsoft.com

This is possibly old news, but I just noticed some SQL Server administration and development Tips and Tricks at the Microsoft SQL Server site. Worth checking out. Read more →

PDC Fasion tips

Good advice. Anyone interested in web service's but couldn't make it to PDC, Benjamin is doing some good coverage. I know that Developers aren't renowned for dress sense, but I've seen an alarming number of developers today wearing socks and sandals. Read more →

Clustering on a budget

To help out in this thread I dug out a couple of URLs for good clustering resources on Microsoft's site. Looking though my home Wiki for the links got me thinking about a clustering job I did early this year which was pretty scary job and nerve-wracking. Read more →

Software Fashions

An interesting article about fads in software development. Rob will appreciate this : XML is best at representing data in a clean and open fashion. Anything more is stretching the point, like sticking a saddle on a pig and calling it a micro-horse. Read more →

Best of the forums

I hope everyone is enjoying the SQLTeam blogs so far. Graz, Rob and I have been talking about this idea for a little while, well.. we knew we wanted to do something, but weren't totally sure of the format. Read more →

Specifying SQL Server port numbers in .NET

An interesting post from Chris Stewart about using a non-standard port for SQL Server and using .NET to talk to it. .NET requires that you specify the port number with a comma, not the usual (and standard) colon. Read more →

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. Read more →

Quote of the day

from Eric Sink of SourceGear At this point, Ximian has completed 90% of the work necessary to make the Vault command-line client work on Linux and its ilk. Now we at SourceGear need to do the remaining 90%. Read more →

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. Read more →

DTS Debugging

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

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. Read more →


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. Read more →


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! Read more →