Another factor to consider is the use of VMWare RAW disks.  I did a SQL benchmark in 2004 with raw compared to native disks compared to a physical OS.  With all...

You need to identify your requirements in far more detail in order to pick the appropriate tool.  These will include not only presentation quality and security, but how the tool...

As Brian says, the default instance of SQL 2005 will do what you want.  The default instance actually has a name of MSSQLSERVER, but you do not need to specify...

I would avoid doing an in-place upgrade if at all possible.  You end up with a mix of SQL 2000 and SQL 2005 folder names and file locations.  SAC normally...

I have found SAC to be very reluctant to display all the SQL services.  One sure way I have found to upset it is install SQL 2005, uninstall it, then...

Try NigelRivett.net, who has some sample routines on his site.  Also try Googling 'Jobserver class', for more details on how to use it.

Steve is right.

In SQL2000, Simple recovery mode logs virtually the same amount of information as Full recovery mode.  In SQL2005, Simple recovery mode logs virtually the same amount of information as Bulk Logged...

The error message you are getting means you need a Service Principal Name (SPN).  Google SETSPN and SQL to see the syntax, and persuade one of your Infrastructure people to...

You have hit the 2 CD problem.

The SQL 2005 install media are divided into 2 CDs.  CD 1 contains the server components, and CD 2 contains the client components.  For...

It is great being able to help others, and to get help on my problems.  Thanks for the prize!

My view is that if your 'opponents' have produced an Expert's report stating a particular view, then your organisation will need to commission an Expert report also.  Your responsibility should be to...

I am now working about 5 miles from where I was born, both in London, but I live about 80 miles away.  Between then and now I have lived and/or worked in...

The statement CASE WHEN Col001 NOT LIKE 'NULL' will be looking for the character string 'NULL'.  If this is really what you want to do, then it would be more...

You should plan to upgrade your SQL Server release to RTM code.

Any service pack is only supported when applied to RTM code.  Even if you do get SQL 2005 SP2...

The priorities of a good manageer should be: 1) Managing their own staff; 2) Managing their peers and superiors; 3) Managing relationships with customers and vendors; 4) Managing their own...