Log Shipping is fairly useful for a disaster recovery, but requires manual intervention. I use hostname, port number for connection strings and in the event of an emergency change the...

The cluster I helped implemented has increased downtime significantly through unplanned failovers. The idea and marketing hype of Microsoft clustering sounds good, but in a production environment blips in the...

I've used Erwin for the past five years and I agree with previous comments. It was a good product when owned by Platinum in version 3.52. Since it has been...

I’ve been running Indepth on a dozen SQL Server for over one year and half years.

You can install the monitoring agent on another machine so that nothing is installed the...

I would suggest checking out Relog from Microsoft. Relog takes an existing Perfmon log and can output it to binary, csv, tsv or a SQL table.

The Oracle Online University http://www.oracle.com/education/oln/index.html?ou_online_home.html   has many online courses. The free area offers a basic introduction to Oracle architecture and the paid membership is only $280 per year...

Do you have the SQL 2000 client tools loaded on your new machine?

Under Resources >> Products and Books >> Contribute Freeware (This just sends a message to articles@sqlservercentral.com) and the site owners will post it.

Unfortunately I don't -- but that's not a bad idea for another tool. Perhaps someone else has created one. I've been sitting on DumpSQLSec for three years and I bet...

Maybe you can post it in the free downloads section.

Sure -- I'm glad you've found it useful

Having used Log Explorer for over 3 years, I've found some additional uses other than restoring data:

Exporting the transaction log records to a SQL table and running queries to determine...

I agree, here are couple other suggestions:

1. Ability to monitor SQL Mail Status (WMI) -- Up/Down, perhaps a MOM script

2. Run SQL Mail as seperate service, currently I...

Making the user the owner of the datbase will make everything they create dbo prefixed. sp_changedbowner which is different than putting a user in the db_owner role will do...

I disable all FK and triggers when I refresh data only for development:

To disable all Triggers and FK's:

-- Disable all constraints and triggers

sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"

go

sp_msforeachtable "ALTER...