gary.humphryes (4/29/2010)

---

Yes Rich, I spent days trying to crack this and in the end had to cut my losses and battle the SSIS import which in itself proved ridiculously difficult....

Nice article, but I have to say, my only experience with the Primary Interop Assembly (there's a reason that abbreviates to PIA!) with VB.NET was not pleasant:

Excel process could NOT...

There's no reason to use dynamic SQL, even with classic ASP. You can still insist that all interaction to the d.b. from the web uses stored procedures, which will...

We gave it to them in the form of their own server with a SAN "snapshot" delivered from production every night at midnight. I have to say that with...

Thanks, Craig. I guess we've all worked at places where some or...

Great article, thanks!

I would most emphatically add this to your excellent list:

Learn Your Business

It is impossible for you, as a DBA, to participate in discussions about data access,...

Dave, here are some items easy to get wrong when coming up with a backup plan:

1) Not backing up the transaction log when your DB is in FULL recovery mode....

I'll confess up front: I've never read Simonyi's original article.

I enjoyed this URL (Making Wrong Code Look Wrong) very much, in part b/c it emphasizes that Simonyi's original...

Brad, one of the best ways I used to learn Visual Basic for Applications years ago was to record macros and look at the code. It's still something I recommend...

Thanks again, all!

So..... if "everyone" recommends putting only 1 backup into 1 file, of what use is the Append (NOINIT) option? Is this simply a legacy from backing up...

Jeffrey, Joie, thanks.

Yes, for my testing, I've been putting multiple backups into one file with append. I figured that, if SQL Server had built-in capability for culling expired backups...

Great, thanks!

I created a query to look for jobs not owned by SA, and discovered a small "gotcha". A LEFT JOIN would work, of course, but I don't really...

I use the GUI for restores, b/c it's not something I do often.

One gotcha in restoring from a backup file using SSMS GUI is that you need to...

I found this article was very helpful in explaining some common SQL query errors, and the IN(NULL) problem is #1 on his list!

http://www.simple-talk.com/sql/t-sql-programming/ten-common-sql-programming-mistakes/

Good luck,

Rich

Might I add:

Service accounts used for each service, and any non-standard permissions for them.

Rich Mechaber