Your client is likely to look to your organisation when there are problems with the cluster setup, particularly during the warranty period of the sale. They will also want...

The first step should be to follow up on the suggestions given for improving the speed of your index rebuild, and avoiding the need to do rebuilds. The biggest...

Another viewpoint is to say that the non-IT group are running a departmental server and they can do whatever they please with it. They should have total authority and...

64-bit should be the default choice for new installations. If you think you need 32-bit you should justify why.

If you plan to install server hardware that supports more than...

Do you really need to convert your DTS to SSIS at this time?

You can download the DTS Designer component and run DTS Designer in SQL Server 2005 and 2008. ...

When all is said and done, naming standards are not very important. (cue flames!)

I agree they can help make life easier for the DBA, but do they add any...

VSS does not do branching very well. You can make a branch, but there is very little help if you want to rejoin that branch to your main code...

As always the answer is 'it depends', but in my experience VSS should be OK to handle the workload of 6 to 8 people.

Be aware that VSS is designed for use in small to (at most) medium sized environments. If your shop has 30+ developers, it is likely you are too big...

I suggest you ask this in a Windows forum. There are a lot more windows system engineers who know about this aspect of network configuration than there are SQL...

Trying to run SQL Server 2000 using a account that is not local administrator is very difficult. There is lots of functionality that does not work. My understanding...

I could tell you that you are wrong.

...but then I would be wrong. 🙂

My understanding is this is not true for at least some of...

This is definitely a SQL injection attack.

There is a new class of injection attack going round where the attacker just inserts the attacking code into a URL headed for your...

Data protection forms part of Information Lifecycle Management (ILM). ILM covers not just who should be able to access the information, but also how long the information should survive,...