Such HA features are also available on VMware with quite good throughput. Low latency may be obtained with Raw Device Mapping, but I'm not sure if VMotion works with RDM.

Think...

You can now get a 20 TB SAN with high-end FC disks and integrated NAS appliance from the EMC for < 100 KEuros.

I think that if you use your database...

When changing a database name, it's also good practise to change db's logical and physical file names.

Stueyd (6/30/2008)

---

Our rule is that no-one except DBAs have SA privs. In a few cases where a useless 3rd party app has been purchased and this is not possible we...

Matt Miller (6/27/2008)

---

At a previous job, we used to have the same SA passwords....until some trojan captured that password and started mercilessly DOS'ing our servers.

So, instead of having a common...

I totally agree with Mickael, and that's the way we do it with SQL 2k5 instances.

1 svc account per instance (Engine, Agent...), whatever the number of instances on a server.

Automatic...

My policy is rather having a unique complex (>50 chars) sa password that only the dba and the IT mgr / Security mgr knows. Just like the domain admin account.

As...

Aren't we supposed to talk about SQL Server through Oracle users' eye ?

I agree with most of what Jeff says. Oracle also has weeknesses! Let me just moderate a few...

I've even been recently working for a company that had 2 DBA for 300+ Oracle DB, and... no "real" DBAs for MS DBs. Too many people still think that SQL...

SQL Server REPLACE string function is something different from "CREATE OR REPLACE PROCEDURE" syntax which was mentioned before.

Hi,

About Documentation : I've been practising both as a developper, and DBA for a few years (8i-10g, SQL2000-2005)

Oracle documentation is made of many "Books" (1000+ pages, freely downloadable on OTN...

Hi,

Maybe there's bug in Management studio, but 2,147,483,647 (2^31-1) means "All available physical memory at the moment of Instance creation", and should not be interpreted as megabytes.