I like the dynamic configuration idea. Would you please post more details/codes? Thanks.

Judging on all comments here, perhaps I am a minority on this one. Coming from a developer turned DBA background, I understood Steve's situation. Code tuning is all...

This article hit the nail on its head.  Data quality was the number one problem when we were building our data warehouse.  I agree that your data warehouse can reach 100%...

We stop upgrading after version 3.5 (too expensive for our small company).  I did my last database design with over 200 tables directly in Sqlserver 2000 with no problems.  Sure,...

Great article.  I wonder how does this compare to Log Shipping.  Currently we are using Log Shipping for reporting and have issues of killing all users before applying the log...

Hi Claudia,

Great read!  I am interested in creating a replication and log shipping from the same database.  The replication will be used for reporting while log shipping is used for...

Hi Claudia,

Great read!  I am interested in creating a replication and log shipping from the same database.  The replication will be used for reporting while log shipping is used for...

Hi Rcarlson ,

Thanks for the VB script.  It works great for me.  I took the liberty to parametize the server name so that I can use for multiple servers and...

Great article.  We are currently using a home grown Log Shipping process to copy logs from one location to 4 other locations with compression/decompression.  We also use the standby databases for...

I would like to share a set of naming conventions that works well for me over the years.  For table names, I mainly use domain naming technique and use suffix...

Thank you so much for your detailed explanation.

I was in a similar situation not long ago.  The exact same database (using backup and restore) is 10 times slower on a new faster server than old server running same...

I have a similar question perhap you all can help.  I have a column with Varchar(7000) in sql2k.  Only 200 chars are used in majority of records.  When convert to...

I agree with drnetwork's post.  I doubted they will use the same technology in their accounting department.