It isn't the DBAs who think they are God that worry me, its the DBA who management think is God.

SQL Server does make things very easy but I look at...

If you look at the assemblies you will see the data type assembly that supports the geospatial data types.

The data types themselves are in the assembly and some of the...

RC0 doesn't support clustering.

I've been looking at spatial geography and trying to understand the new indexes which are really odd. I'm not sure why the new geography and geometry...

I totally agree with the "buy in" comment and would go further and say that the end user has to be actively involved with the project.

Bringing developers and end-users together...

I use the snippets so

ssf becomes SELECT * FROM

scf becomes SELECT COUNT(*) FROM

I've added my own so I have one for

IF EXISTS(SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME='')

...

Erm.... thats alcoholic withdrawal symptoms.

My father-in-law bought me a bike and for 10 years I cycled to work. In...

Until SQL2008 is officially released I wouldn't let it near any existing boxes.

My approach with the CTPs is to completely wipe the box in between CTP releases.

Even after the launch...

My first reaction on seeing the latest Microsoft SQL Intellisense was disappointment. It looked like a cut down version of SQL Prompt when SQL Prompt was a $20 app...

The features that interest me are as follows

1. Spatial data types

2. Resource governor

3. Improvements to SSIS/Analysis Services/reporting Services

4. Backup compression

5. Looks good on my CV

Chiropracters sound dangerous!

I know a very good osteopath who has helped me no end. I had a nasty whiplash injury and he got me to the stage where I...

What browser are you using? In FireFox the code block gets...

Hi,

I'm Dave's wife, I can recommend an earlier article " users from hell", I am fairly computer illiterate but still managed to split my sides over that one myself!.

Another...

Ah the linguistic differences again. Took me a bit to remember that "pinching" is slang for "stealing". Like the fact that a nickname is the name they gave...

Glad you all enjoyed it.

I forgot to mention that the museum curator told me that he has to replace the "turd" at frequent intervals because kids keep pinching it.

For all...

There is always a problem creating the "must have" product when you have no idea what that product the consumer will consider to be "must have".

What I read into Joel's...