So there is no way to automatically sync table schema or stored proc schema changes during replication without using a 3rd-party tool?

With database mirroring, is a shared drive (SAN) a...

Thanks for the clarification. Alarm bells went off when I thought log shipping wasn't syncing schema changes.

Is it possible to replicate schema changes & stored procedure changes and what...

Hi Paul,

Great article. If schema changes are not copied during log shipping, what is the best method to maintain updates to scripts and tables with large databases where...

One alternative to partitioning is the manual SQL 7 way, using SQL views & the UNION ALL statement.

http://blogs.conchango.com/christianwade/archive/2004/11/08/221.aspx

You would create a monthly historical table where records would be...

This is what I use, however it would need to be modified to insert into a table if you wanted to select against it.

sp_msforeachdb 'use ?;exec sp_spaceused'

cheers,

Andrew

With regards to blobs becoming more common, I was referring to discussions around SQL 2008's filesystem data type, and not specifically storing blobs in databases.

I have no evidence of a...

By associated materials, I meant any content that could help you succeed, not really anything in particular. Some of the things I would use to study are the following:

blogs

certification...

Thanks for all of the positive feedback on my first article from everyone.

So beta exams are free AND they count towards certification? Is there a mailing list I can...

http://support.microsoft.com/default.aspx/kb/240377/EN-US/

One option may be to check winnt/system32 directory using master..xp_cmdshell 'dir c:\winnt\system32\msjet*.*'

cheers,

Andrew