Hmmm, it seems I need to try the dbghost next time since so many people recommend it...  but isn't it too "eye-stressing" if you have to pickup various objects through...

Hi everyone,

All excellent comments. I once used both Harvest and VSS, and I agree with you all the source control is absolutely the right way to solve most of the...

Hi Linda, can a Canadian apply this too?

I think you can use the following sql to do your work

select * from My_Table

where col_date between isnull(@Start_Date, '1900-01-01') and isnull(@End_Date, '2999-01-01')

Assume your real date is no earlier than '1900-01-01'...

Actually these days, many companies will have network admins to backup those critical hard-disk drives daily. As a DBA, I just need to backup my databases to those designated drives. To...

Log shipping is fine, but more often than not, people do not have the budget to replicate a huge-sized db, which is not adding any economic value.

"Restore all log backups in a folder within one command" is really useful in real world, esp. when you have to do the "recovery to the point". I once implemented...

How about the restore functions?

I do not like cert either though I have a MCSE title several years ago. But I would say the process to get a cert is rewarding at least in...

I guess you did not like the database with its db files (through filegroup object).

DTS is not a good answer in terms of convenience and team cooperation. Yes, DTS has a task call "Copy SQL Server Objects" that can generate most of db objects' scripts,...

Intersting article, and actually, I just finished one similar tool with a set of different features.

I have been facing migrating database objects (several hundered sometimes)from tens of databases in...

Just use

Begin Tran and Commit Tran

No, you cannot as far as I know. Think of restricting the backup priviledge only to you, no one else. Also adding password to your backup files so people cannot...

Hi Steve,

SQLServerCentral.com is usually the first website I opened everyday in my office. You guys have done an amazing job to provide SQL DBAs/Developers a free "home" to communicate...