There is a fine line between "going the extra mile" and being played for a sucker.

Lawyers and accountants charge by the hour and often the minute so why should I...

Windfarms are not as green as their advocates would have you believe. Their power output is pretty meagre and you have to jump start them using a hefty motor.

They...

Years ago, sorry decades ago, there used to be a product from a company called Personics called Monarch.

What the product did was to take spool files off a mini-computer print...

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