I understand what you are saying about using views etc but things that don't matter a jot in small to medium databases suddenly become a very big deal in larger...

I've got to keep 200 DB servers up and running with typical specs of 16 CPU 24GB RAM replicating across 3 sites.

Even at my most cynical (and I can be...

I've just been listening to BBC Radio 4 and there is a case where someone has been prosecuted for having an Al Queda training manual. It is illegal in...

For me I want to see some good SERVICE BROKER examples. Some good monitoring tools for service broker would be appreciated.

Please M$ smarten up the error messages in SQL....

Moore's law came from Intel and its rare to see a server struggling with cpu compared to the number that struggle with disk these days- unless of course the clr...

There is an argument that the cost of tuning something to the n'th degree is excessive considering the fact that computing power doubles every 18 months.

I've never been a good...

It is not a good idea to have objects owned by people other than the dbo.

It is also not a good idea to rely on SQL Standard security especially in...

I'm assuming you are using Visual Studio and don't have access to the standard SQL Server tools.

There is a table called sysreferences that is in all databases, it is this...

If you run SELECT * FROM tablename then you will get records returned from a table owned by yourself it such a thing exists or as a fall back a...

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