We've been evaluating MySQL Vs SQL2008. So far the cheapness of MySQL means that a scaleout architecture is a practical proposition. Performance wise scale-up is not so hot....

Thanks, you have just confirmed my worst nightmares and I have to say I'm not altogether surprised.

By none functional requirements I meant things like "

a. must support x queries...

We have an experienced architect who has worked with agile development for a number of years.

He has some pearls of wisdom

1. It takes 18-24 months for the agile methodologies to...

Anyone who was in employment when SQL Slammer hit is unlikely to leave servers unpatched.

SQL Slammer caused so many problems because it attacked all editions of SQL Server so the...

The one critique I would have is this:

The article mentions quite heavily the editing process, so it would have been nice to have some kind of appendix where the reader...

Personally my favourite was "The losers"

A wise boss once told me that he was interested in assigning responsibility rather than blame. By assigning responsibility there was an expectation of some positive action such as...

For SQL2008 there is a web edition that is licensed to 4 CPUs. It sits somewhere between SQL Express and Standard Edition but with considerably cheaper licensing.

Having just gone...

I.m using SQL2008 so the exact option may differ to mine.

In SQL Management Studio from the tools/options menu look for the "query results" branch on the left hand side.

In results...

One of Scott Adam's Dilbert cartoons is about an employees "numbing". This is when the employee realises that he/she is not appreciated, he/she is simply expected to be a...

I haven't got a degree.

I fell into becoming a DBA through an interest in statistics in relation to predicting future customer behaviour from past behaviour.

Personally I would set up an explicit Domain SQLAdmin group with very tightly controlled membership.

Make this group a sysadmin and get rid of NTAuthority/System.

You need to make sure that the...

How many people have you got trying to connect to your instance?

What edition of SQL Server are you running?

What is the licensing model for your SQL Server. Is it per...

17187 means that SQL Server cannot accept anymore client connections. There was a fix in SP2 as SQL Server was sometimes overzealous in issuing this command.

18456 is a "login...

Because of my auditing needs I have a structure that is something like the following

UserID

VersionNumber

UserName

... additional fields to identify who did what and when.

The primary key is across the first...